NTSB investigations: Enstrom F-28A, FL
14 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 2 |
| 1990 | 2 |
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\" = 'FL' 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 ('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 c."eventStateOrRegion" = 'FL' 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 ('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 MIA90LA120Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Marathon, FLFailure of the input drive gear of the tail rotor gear box for undetermined reasons because the drive gear was not recovered from the ocean.NTSB MIA90TL#03Accident · Minor injuriesClass 3Final reportEnstrom F-28A · Ft Pierce, FLNTSB MIA83LA138Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Brooksville, FLThe acft rolled over and crashed during an attempted downwind running takeoff. The acft was destroyed by impact forces and fire. The pilot and 2 passengers were not injured. A witness on the ground and one of the passengers who is an A&P mechanic stated that…NTSB MIA83LA059Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · New Smyrna Bch, FLThe newly purchased helicopter was being ferried to Maryland. During arrival to new Smyrna beach, FL, the 1st planned stop, the plt executed a landing approach to rwy 2. After coming to a hover, the helicopter lost rotor RPM during a pedal turn to a downwind…NTSB MIA81FLD48Accident · No injuriesClosedEnstrom F-28A · Vero Beach, FLNTSB MIA80DKT49Accident · No injuriesClosedEnstrom F-28A · Jupiter, FLNTSB MIA79DKT10Accident · No injuriesClosedEnstrom F28A · Stuart, FLNTSB MIA78FLD54Accident · No injuriesClosedEnstrom F-28A · Vero Beach, FLNTSB MIA77FKT15Accident · No injuriesClosedEnstrom F28A · Boynton Beach, FLNTSB MIA75FKT44Accident · Serious injuriesClosedEnstrom F28 · Ft Lauderdale, FLNTSB MIA74FKT19Accident · No injuriesClosedEnstrom F-28A · Ft Lauderdale, FLNTSB MIA74FLA12Accident · No injuriesClosedEnstrom F-28A · Jacksonville, FLNTSB MIA73FKT23Accident · No injuriesClosedEnstrom F-28A · Laudrdale Lks, FLNTSB MIA71FLD54Accident · No injuriesClosedEnstrom F28A · Daytona Beach, FL