The Legend of the Black Freighter: dreamed of by a serving girl in a tavern. One day it will come, level the tavern and its obnoxious clientele if not the whole town... and then declare the serving girl Pirate Queen and sail over the horizon with her.
Ghost ship in a creek near Cincinnati off the Ohio river. The Circle Line V was launched on April 12, 1902 as the Celt and had a long and interesting history before being grounded in the creek off of its final owner's property in 1986. It rots there to this day.