What is the cause of water in the transmission?

Failed oil to water cooler ( usually antifreeze from the radiator )

Water entering through a seal, Dipstick, axle seal, etc

Drove into deep water and it came in through the vent.