NTSB investigations: Enstrom F-28C
12 cases on aircraft the registry lists as Enstrom F-28C, 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 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 ('3300407')
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 ('3300407')
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 NYC06CA008Accident · No injuriesData collectionFinal reportEnstrom F-28C · Smoketown, PAThe student pilot's failure to maintain aircraft control while performing pedal turns at a hover, resulting in a collision with terrain.NTSB LAX01LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Hollister, CAthe pilot's inadequate use of the antitorque controls and subsequent failure to maintain directional control of the helicopter during the takeoff initial climb.NTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.NTSB LAX95LA139Accident · No injuriesLimited investigationFinal reportEnstrom F28C-2 · San Gorgonio, CAthe pilot's selection of an inadequate terrain clearance altitude while overflying mountainous terrain.NTSB LAX95LA017Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · La Verne, CAan inadvertant entry into a settling with power condition and the flight instructor's inability to correct the situation due to an inadequate altitude above ground.NTSB NYC93GA151Accident · Serious injuriesFinal reportEnstrom F-28C · Gallipolis, OHThe pilot's improper use of the collective and throttle which resulted in a low rotor rpm condition and a loss of control, and an inflight collision with the terrain.NTSB DEN93LA070Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Boulder, COA failure by the pilot flying to adequately compensate for wind conditions which led to a loss of tail rotor control. A factor was: inadequate supervision by the pilot in command.NTSB DEN92LA001Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Evergreen, COIn flight encounter with a sudden downdraft. A factor was: the pilot's lack of total experience in aircraft type.NTSB NYC86LA011Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Linden, NJThe helicopter experienced a roll-over during a practice hover autorotation. The acc occurred when the acft started moving backwards during the hover. The left skid dug into the dirt which pitched the acft nose up & rolled it over to the left.NTSB LAX85LA089Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Sausalito, CAWx conds were sky obscured, visibility less than 1/16 of a mile in fog. Plt arrived at heliport, went directly to acft and started engine. Another heliport plt went to acft and advised mishap plt against departure due to low visibility. Mishap plt replied he…NTSB LAX83LA429Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Quincy, CAThe acft was on a flt to a radio transmitter site at about the 7000 ft level in mountainous terrain. During arrival to the helipad, the plt noticed that several vehicles were parked on the landing surface. While in a hover, he maneuvered the helicopter to an…NTSB LAX83FA266Accident · Serious injuriesField investigationFinal reportEnstrom F28C · Mesa, AZThe pilot had taken off, went into a normal hover, then traveled about 200 feet for a pattern climb-out when he radioed the tower that the acft did not feel right. The acft started to fishtail. The pilot tried to autorotate but could not stop the rate of…