NTSB investigations: Hiller UH-12E, 1995
6 cases on aircraft the registry lists as Hiller UH-12E. 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
| 1964 | 9 |
|---|---|
| 1965 | 14 |
| 1966 | 15 |
| 1967 | 7 |
| 1968 | 8 |
| 1969 | 4 |
| 1970 | 3 |
| 1971 | 5 |
| 1972 | 3 |
| 1973 | 8 |
| 1974 | 14 |
| 1975 | 18 |
| 1976 | 16 |
| 1977 | 14 |
| 1978 | 25 |
| 1979 | 19 |
| 1980 | 21 |
| 1981 | 18 |
| 1982 | 8 |
| 1983 | 15 |
| 1984 | 14 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 8 |
| 1988 | 12 |
| 1989 | 9 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 6 |
| 1993 | 10 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 9 |
| 1997 | 6 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 4 |
| 2007 | 2 |
| 2008 | 5 |
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 4 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 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\") = 1995
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137'))
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") = 1995
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137'))
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 LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.NTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.NTSB SEA95LA077Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Timber, ORThe pilot's inadequate aircraft preflight during which he failed to notice the main rotor shipping block had not been removed, and the resultant restricted movement of the flight control system.NTSB LAX95LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAfuel exhaustion due to the pilot's inattention to the fuel supply.NTSB LAX95LA109Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Arvin, CAThe seizure of the transmission due to lack of lubrication from a plugged oil supply line.NTSB LAX95LA096Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chowchilla, CAthe in-flight failure and separation of the main rotor hub due to a fatigue crack.