NTSB investigations: Enstrom F-28C, CA
16 cases on aircraft the registry lists as Enstrom F-28C. 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
| 1979 | 1 |
|---|---|
| 1980 | 2 |
| 1981 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2017 | 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.\"eventStateOrRegion\" = 'CA' 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 ('3300407'))
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" = 'CA' 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 ('3300407'))
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 WPR17LA158Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28C · Ontario, CAThe student pilot's mismanagement of the main rotor rpm, which resulted in low rotor rpm, a high descent rate, and a subsequent hard landing.NTSB LAX02LA169Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Stockton, CAThe pilot's failure to maintain an adequate clearance from the water tower during takeoff. Also causal was the pilot's selection of a confined area for the landing and subsequent takeoff.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 LAX95LA332Accident · 1 fatalLimited investigationFinal reportEnstrom F-28C · Livermore, CAthe pilot's inadequate preflight fuel load determination procedures which resulted in fuel exhaustion. In addition, the pilot's delayed and improper use of the collective and cyclic flight controls following the engine failure led to his failure to maintain…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 LAX92LA362Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Irwindale, CAThe pilot's misjudgment of the landing flare during a practice autorotation.NTSB LAX92TL#07Accident · No injuriesClass 3Final reportEnstrom F-28C · Oakland, CANTSB LAX89LA044Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Inyokern, CAThe pilot stated that, 'I landed in an open unpopulated area for the mechanic ... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…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 LAX83LA175Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Chino, CAThe rated airplane plt was endorsed for local solo flts in the helicopter & was practicing autorotative landings. He stated that during a landing, he flared late & allowed the tail & tail rotor to impact the rwy.NTSB LAX82DVA06Accident · No injuriesClosedEnstrom F-28C · Shaver Lake, CANTSB LAX81FVD08Accident · No injuriesClosedEnstrom F-28-C · Eureka, CANTSB LAX80FVG26Accident · No injuriesClosedEnstrom F28C · Sacramento, CANTSB OAK79DXQ29Accident · No injuriesClosedEnstrom F-28C · Bridgeport, CA