The young boy was pulled unresponsive from the water before being flown to hospital in a critical condition.