NTSB investigations: Enstrom F-28A, 1988
4 cases on aircraft the registry lists as Enstrom F-28A. 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
| 1969 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 6 |
| 1973 | 9 |
| 1974 | 14 |
| 1975 | 14 |
| 1976 | 14 |
| 1977 | 11 |
| 1978 | 8 |
| 1979 | 8 |
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300406'))
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 year(c."eventDate") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3300406'))
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 CHI88LA239Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Celina, OHAfter 2 unsuccessful attempts to takeoff, the plt/owner tried a 3rd takeoff in his newly purchased helicopter. He rprtd that during the first 2 attempts to takeoff, he couldn't seem to get 100% of his left pedal authority. Shortly after the helicopter became…NTSB FTW88DRG11Accident · No injuriesFinal reportEnstrom F28A · Port Isabel, TXThe pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…NTSB LAX88LA198Accident · No injuriesLimited investigationFinal reportEnstrom F28A · La Verne, CAThe helicopter landed hard during a practice touchdown autorotation (auto). The helo remained in closed traffic for the purpose of practicing touchdown autos to a landing area adjacent to the aprt's rwy. There was also another helo in closed traffic using the…NTSB BFO88FA050Accident · No injuriesField investigationFinal reportEnstrom F-28A · Middletown, DEShortly after takeoff, at an alt of aprx 400 ft, a loud bang was heard and the helicopter developed a moderate to severe vibration. The CFI took control of the helicopter and initiated an autorotation. The helicopter contacted small tree branches and landed…