Emergency services - including the Wales Air Ambulance - were called but the man could not be saved