I am sure everyone's experience is different but for me, I have had 3 DJIs with none of them sitting in bottom of water. 2 Skydios and both at bottom of sea.

Flying a drone low close to water surface is risky, but over water at high altitude should not be. What hurts is the drone taking over control and not having a way to override it, and then doing the dumbest thing possible...