Yacht ignores high tide warning in dramatic harbour attempt