Skip to content

NTSB investigations: Enstrom F-28A, OH

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

Where

Latest cases

Query with SQL

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" = 'OH' 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

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\" = 'OH' 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" = 'OH' 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

Run 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 NYC99LA138Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28 · Cincinnati, OHThe pilot's inadequate evaluation of the weather conditions at the time of departure, which resulted in a downwind takeoff. A factor in the accident was the change in wind direction.Jun 12, 1999 · N9588 · Substantial damage NTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.Mar 12, 1998 · N4884 · Substantial damage NTSB NYC93LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ironton, OHThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Jun 27, 1993 · N9555 · Substantial damage NTSB NYC93LA016Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Kitts Hill, OHA hard landing due to improper use of the collective, following a wire strike due to inadequate visual lookout.Oct 11, 1992 · N249Q · Substantial damage NTSB NYC91LA107Accident · Serious injuriesLimited investigationFinal reportEnstrom F28A · Leetonia, OHThe helicopter hover performance was exceeded by the pilot and his failure to perform a normal approach to a landing. Factors were the high winds and the tailwind condition.Apr 6, 1991 · N58KC · Substantial damage NTSB NYC90LA200Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ravenna, OHA power loss, due to contamination from deteriorating fuel tank sealant, and the pilot's failure to notice the contamination during preflight.Aug 24, 1990 · N9597 · Substantial damage 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…Sep 18, 1988 · N249Q · Destroyed NTSB ATL87LA267Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Mansfield, OHThe plt reported that the helicopter made an uncommanded turn to the right and rolled to the left as she was hover-taxiing away from the hangar toward the takeoff area. The acft subsequently impacted the terrain and came to rest on its left side. Post-crash…Sep 30, 1987 · N29GC · Substantial damage NTSB ATL87DEG05Accident · No injuriesFinal reportEnstrom F-28A · Wilmington, OHDuring a climbout the pilot reported a power reduction. The engine continued operating and the rotor RPM dropped as the helicopter climbed to 10 feet. The wreckage examination failed to disclose any system malfunction or failures. The pilot was attempting to…Apr 30, 1987 · N180Q · Substantial damage NTSB CHI80FEK19Accident · No injuriesClosedEnstrom F-28A · Circleville, OHJul 4, 1980 · N193E · Substantial damage NTSB CHI79DA075Accident · 1 fatalClosedEnstrom F-28A · Kings Mills, OHSep 12, 1979 · N244Q · Destroyed NTSB CHI77FEK05Accident · Minor injuriesClosedEnstrom F-28A · Columbus, OHNov 16, 1976 · N282Q · Substantial damage NTSB CHI76AC084Accident · 2 fatalClosedEnstrom F-28A · Enon, OHAug 9, 1976 · N88BD · Destroyed NTSB CHI74DEK21Accident · No injuriesClosedEnstrom F28A · Marion, OHApr 6, 1974 · N1150R · Substantial damage