Believe it or not, the only ship left that sunk an enemy ship is the U.S.S Constitution during the war of 1812. Although it's not really active anymore, it's the only one left ! The U.S.S Simpson was the last modern U.S. Navy ship to sink another enemy ship but has long been decommissioned.
