Residents described the incident as "terrible" as police closed roads off to investigate the scene