NTSB investigations: Enstrom Helicopter 280C, UT
4 cases on aircraft the registry lists as Enstrom Helicopter 280C. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 2009 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300505'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300505'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR09LA261Accident · No injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Ogden, UTThe pilot's improper use of the helicopter's collective both during the takeoff sequence and while attempting remedial action in response to an engine over-boost condition, which resulted in a hard precautionary landing.NTSB DEN87LA245Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Bountiful, UTWhile on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir.NTSB DEN84LA271Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Bluffdale, UTPlt was practicing hovering over a 40 x 60 foot helicopter pad. Plt stated, a gust of wind caught the helicopter moving it off the pad and into nearby power lines. The terrain around the pad slopes down. The power lines were located aprx 125 ft from the pad…NTSB DEN82DTM08Accident · No injuriesFinal reportEnstrom 280C · Midway, UTThe aircraft crashed while being moved about 150 ft from the parking area to a storage building. There was about 2 1/2 ft of fresh snow on the ground. The snow had been cleared from the parking area in front of the storage building. However, a snow cat had…