NTSB investigations: Enstrom F-28A
12 cases on aircraft the registry lists as Enstrom F-28A, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 2003 | 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 ('3300406')
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\" = 250))
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 ('3300406')
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" = 250))
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 CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.NTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.NTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.NTSB BFO94LA129Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Bangor, METhe pilot's loss of aircraft control. Factors are dark night conditions, and the pilot's execution of an evasive maneuver.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.NTSB NYC89LA213Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Boston, MAFailue of pilot to maintain control of the helicopter when a passenger inadvertently pushed the cyclic control. The fence (near the helipad) was considered to be a factor.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 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…NTSB MKC87LA102Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Fayetteville, ARThe PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in…NTSB 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 ANC83FA022Accident · Minor injuriesField investigationFinal reportEnstrom F-28A · Chugiak, AKThe aircraft collided with ground and rolled while the pilot was hover taxiing downwind. The winds were described as 15 KTS to gusts as high as 45 KTS. The Enstrom chief engineer reported that a downwind hover tends to decay the main rotor RPM due to…