NTSB investigations: Fairchild Hiller FH-1100, FL
7 cases on aircraft the registry lists as Fairchild Hiller FH-1100. 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
| 1977 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2006 | 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\" = '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 ('3376502'))
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 ('3376502'))
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 MIA06LA126Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Navarre, FLThe inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.NTSB MIA03LA047Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Fort Myers, FLThe pilot's inadequate preflight/preparation and his in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA99LA111Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Zephyrhills, FLThe student pilot's improper use of flight controls (cyclic and collective) during a takeoff to a hover. This resulted in the helicopter encountering dynamic rollover and rolling over on its right side.NTSB MIA91LA084Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ldl-By-The-Sea, FLTail rotor blade failure due to undetermined reasons and unsuitable terrain during a precautionary landing.NTSB MIA86LA117Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Miami, FLThe student plt was on a supervised solo flt & was hovering. The helicopter was seen to wobble, roll to the right & crash to the ground. The owner of the helicopter stated that he had flown the acft just prior to the accident & the acft performed normally.…NTSB MIA85FA065Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · La Belle, FLThe helicopter was observed flying at a low alt & lost all eng power, banked sharpley to the left, lost complete control & dove into the ground. The acft was destroyed by impact forces along with the post crash fire. No evidence to suggest a malfunction of…NTSB MIA77FKT37Accident · No injuriesClosedHiller Acft 1100H · Watson Is, FL