Fish raining is not a supernatural one, we may observe this sometime and Scientists believe the wind phenomena like whirlwinds or tornadoes are responsible. When such wind patterns appear over water bodies, they create waterspouts. Tornadic waterspouts sometimes pick up creatures such as fish or frogs and carry them for up to several miles. The strong winds in these storms can sometimes carry displaced fish, frogs, or even snakes for miles inland before dropping them on unsuspecting towns. A waterspout works just like a tornado but forms over water.

Raining animals is a rare meteorological phenomenon in which flightless animals “rain” from the sky. Such occurrences have been reported in many countries throughout history.
Just like whirlwinds and tornadoes literally lift material from the surface of the earth, they can lift huge quantities of water also, along with the fish that are in the water.
I am sure you have witnessed little whirlwinds lifting scraps of paper off the ground take it right up in a helix. Likewise, these fish (and other creatures) get sucked up by the whirlwind’s vortex and since such whirlwinds are moving, the water gets blown around in the clouds and once the whirlwind has moved on, the water and the fish fall to the surface of the earth. This is how Fish raining occurs.
Source: https://qr.ae/pN2Mr1
Terms of Service: https://www.quora.com/about/tos
i love this excellent article