NTSB investigations: Enstrom Helicopter 280C, 1986
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
| 1976 | 1 |
|---|---|
| 1977 | 7 |
| 1978 | 5 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 4 |
| 1982 | 5 |
| 1983 | 8 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2024 | 2 |
| 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\") = 1986
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 year(c."eventDate") = 1986
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 NYC87LA012Accident · 1 fatalLimited investigationFinal reportEnstrom 280C · Newport, RIAircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available.NTSB LAX86LA291Accident · No injuriesLimited investigationFinal reportEnstrom EN-280-C · Los Altos, CAThe instructor stated that during a practice auto rotative landing the helicopter lost rotor RPM and a hard landing followed. On ground contact, the main rotor blades struck the tail cone, resulting in substantial damage. The instructor further stated that…NTSB NYC86LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Ephrata, PAThe Enstrom F28C was cruising enroute when it experienced a loss of power for reasons unknown. During the landing, in a large open field, the main rotor was damaged and the tail rotor separated from the tail boom. The lone occupant, the pilot, was uninjured…NTSB NYC86LA107Accident · No injuriesLimited investigationFinal reportEnstrom F-280C · Ridgefield, NJSeconds after an over-water takeoff from a shoreline helipad the acft impacted the water and sank. The pilot and pax escaped from the submerged acft and were not injured. The pilot claimed that he had a split needle in which the rotor RPM deteriorated. The…