NTSB investigations: Hiller UH-12E, 1997
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\") = 1997
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") = 1997
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 CHI98LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Liberty, NEA loss of engine power for undetermined reasons.NTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…NTSB SEA97LA117Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Miltonfreewater, ORThe main rotor blade separated due to fatigue. Factors were: an Airworthiness Directive was not properly performed, and inadequate inspection of the main rotor blades.NTSB LAX97LA179Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Truckee, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuccessful attempt to release the long line from the belly hook after it became entangled in a tree.NTSB FTW97LA131Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Donna, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight. A factor was the power lines.NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.