NTSB investigations: Fairchild Hiller FH-1100, TX
6 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
| 1968 | 1 |
|---|---|
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1994 | 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\" = 'TX' 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" = 'TX' 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 FTW94FA272Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Van Horn, TXThe uncorrected descent by the pilot. A factor was the lack of total experience in type aircraft.NTSB FTW93FA051Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Forney, TXThe pilot's failure to maintain control of the helicopter as a result of his physical impairment due to alcohol. Factors contributing to the accident were: the dark night and the pilot's likely diversion of his attention from operating the helicopter.NTSB FTW86LA164Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Abilene, TXThe plt was conducting sight-seeing flts from a rodeo/fairground area. During a critical part of a takeoff, a tail rotor blade separated & the plt lost directional control. He attempted an autorotative landing. After spinning around about 3 times, the plt…NTSB FTW83LA247Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Beaumont, TXThe helicopter was damaged in an emergency landing in a street. The acft had just taken off from an adjoining parking lot in a shopping center. According the plt the acft lost rotor RPM at 150-175 ft during climb after takeoff and went into a 'settling with…NTSB FTW81FRG25Accident · Serious injuriesClosedHiller Acft FH1100 · Bastrop, TXNTSB FTW68A0085Accident · 2 fatalClosedHiller Acft FH1100 · Goliad, TX