NTSB investigations: Enstrom F-28C
6 cases on aircraft the registry lists as Enstrom F-28C, where the first occurrence was “In flight collision with terrain/water”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2002 | 1 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300407')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300407')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 DEN05LA068Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot's failure to maintain rotor RPM during the approach which resulted in a landing short of the helipad.NTSB SEA02LA075Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Hot Springs, MTThe pilot's failure to adequately compensate for unfavorable wind conditions. Factors include unfavorable/shifting winds, and a tailwind gust.NTSB DEN89LA118Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Regina, NMThe pilot's poorly planned approach and disregard of the helicopters performance data. Contributing to the accident was the high density altitude conditions which existed at the time of the accident.NTSB NYC88LA160Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Westerly, RIThe instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,…NTSB MKC84LA144Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Louisville, NEAccording to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over.NTSB ATL83LA191Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Wise, VAThe plt reported that he had stayed in the local area & had been practicing slow hover over the grass beside the rwy. There was a paved ramp that he had to cross, each time he went from one end of the rwy to the other. He said when he came to this area, he…