The story
From the fact that a pilot who lands in the sea is surrounded by water like a goldfish.
Etymology from Wiktionary, CC BY-SA 4.0.
Goldfish Club
Today it means: An informal association of people who have successfully bailed out of a disabled aircraft while it was over water, or after it had crashed into the water. Full definition →