An investigation has been launched after a man in his 70s died after the boat he was on with a fishing party capsized, leaving 10 people in the sea for five hours.