The Health and Safety Executive and Dyfed Powys Police are investigating the tragedy