A day on the water has ended in tragedy after a Cairns man was mauled by a shark on the Great Barrier Reef.