I think it's
The Irish Rover
The clues are basically
lyrics from the song
Not quite clear about the opening, maybe it's just a general description of the rest:
I think of an unlucky traveler / The arguably greatest one ever.
Or it could be a reference to
We'd an elegant craft, it was rigged 'fore and aft / And how the trade winds drove her / She had twenty-three masts and she stood several blasts
Indeed, from Munster now she's far away /
She'd be by now over 200 years.
In the year of our Lord, eighteen hundred and six / We set sail from the Coal Quay of Cork (Cork is in the province of Munster)
Her only target was the big apple, / Oh, but how the fog did detain her.
She was bound "For the fine city hall of New York" .... "And the ship lost her way in a fog"
On her way she went, with a zoo,
We had five million hogs, we had six million dogs
Plus Barney, Jimmy and the crew.
There was Barney Magee from the banks of the Lee / There was Hogan from County Tyrone / There was Johnny McGurk who was scared stiff of work ....
Eve of the 8th year,
We had sailed seven years when the measles broke out / And our ship lost her way in a fog
a huge rock did hit her
Then the ship struck a rock
Not sure about the bones, might be
in a different version of the song.