A man has died after suffering a severe chest injury when two yachts collided on Sydney Harbour.