Emergency services raced to the scene, including an air ambulance, but she sadly died at the scene