An actual 1943 diesel electric submarine, the U.S.S. Pampanito was chosen from among several existing World War II submarines to stand in for the Stingray. This national historical site is used by the San Francisco-based National Maritime Museum Association as a tourist attraction and is docked at the Embarcadero.

Veteran skipper John Dodge (Kelsey Grammer) will never be a textbook officer, but he's a brilliant seaman who's always wanted to command a nuclear submarine. Instead, he's given the helm of the 'Stingray', a diesel-powered World War II sub crewed by a collection of maladjusted, mistake-prone misfits (Lauren Holly, Rob Schneider, Harry Dean Stanton), then ordered to take on the U.S. Navy's best in a crucial war game. Batten down the hatches for unsinkable hilarity that takes 200 years of naval tradition and throws it all overboard!