Does a torpedo have to be launched in the water?

Torpedoes can be airdropped, or fired from above-water tubes on surface vessels. In fact, many of the first locomotive torpedoes were fired from surface vessels.