A 300-year-old ship whose loss was controversially blamed on its drunken Irish crew has been found off the coast of Norway.