Wiflix. On December 4, 1872, the unmanned Mary Celeste was found adrift in the Atlantic with its cargo fully intact. The mystery of this "ghost ship" remained unanswered for over 135 years. What happened to the Mary Celeste is widely regarded as the most famous mystery of the sea. Watch it unfold to its stunning conclusion, at last.