NTSB investigations: Fairchild Hiller FH-1100, 1986
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\") = 1986
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") = 1986
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 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 LAX86LA193Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Keaau, HIA hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…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.…