Yes, there is a terminal velocity in water. The velocity will be less in water compared to air.
The velocity will depend on the shape of the object and it’s density. So there is no fixed answer to “how deep”. Technically, it would be the density of the object rather than the weight that makes a difference but, for ELI5, weight matters.
Latest Answers