As an interesting addendum to this chart, it now appears that the USS
Constitution is now the only remaining commissioned US warship that has sunk a enemy ship in combat. The one other remaining USN warship with that distinction was the recently retired Oliver Perry class frigate
Simpson, which sank a Iranian missile patrol boat in 1988. I do suppose there are still some carriers around who's air groups have sunk something, but I don't know if that counts.
http://www.boston.com/news/2015/09/2...bjJ/story.html
So, as ancient as she is, she's the only one left with a kill to her sole credit.