A desperate search is underway for the man who was taking part in a fishing competition when he was pulled from the boat.