An off-duty police officer has died after a diving accident despite being given first aid on the scene after emergency services were alerted to a diver in distress.