The above ship is not listing, it's merely an optical illusion created by the backward look angle. The photo was taken after the camera had passed overhead and was looking backward from the plane/satellite that took the picture.
Bring up the image using Google Earth and rotate it 180 degrees. The "tilt" goes away.
actually, that tilt does NOT go away after rotating it 180 degrees. Another reason is that you can see the bottom of the ship sticking out as if it was tilting.
No Longer There 
1) This link shows a lot of sunk ships after the Tropical Storm Jeanne in 2004 : http://googleglobetrotting.com/info.php/mid/11079
2) This boat tilt abnormally. See this other one, further : http://maps.google.com/maps?ll=19.744924,-72.188276&spn=0.000001,0.000001&t=k&hl=en
Bring up the image using Google Earth and rotate it 180 degrees. The "tilt" goes away.
http://googleglobetrotting.com/show.php/t/cat/cat/167
Depends of how deep is the area.