NTSB investigations: Fairchild Hiller FH-1100, 1985
3 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
| 1966 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 5 |
| 1969 | 10 |
| 1970 | 13 |
| 1971 | 7 |
| 1972 | 12 |
| 1973 | 6 |
| 1974 | 6 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 6 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2016 | 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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…NTSB MKC85LA207Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ashland, KSThe helicopter lost power and made a hard forced landing in a backyard. There were no leaks in the fuel system but the fuel tank was found to be empty. The owner states that even though the fuel tank was found to be empty after the accident, the fuel quantity…NTSB DEN85LA079Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Steamboat Sprng, COPurpose of the flt was to test the helicopter after an annual inspection. The plt flew the acft for aprx 1 hour from the left seat with the acft owner in the right seat before the owner deplaned the acft and the plt moved into the right seat. Plt stated that…