NTSB investigations: Hiller UH-12E, CO
11 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 | 1 |
|---|---|
| 1965 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 2 |
| 2010 | 1 |
| 2020 | 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\" = 'CO' 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 ('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 c."eventStateOrRegion" = 'CO' 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 ('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 CEN20LA073Accident · No injuriesClass 3 · LimitedFinal reportHiller UH 12E · Dinosaur, COFailure of a S4 compressor blade due to a fatigue crack that likely initiated at a corrosion pit. Contributing to the accident was maintenance personnel’s failure to detect the corrosion pits during maintenance.NTSB CEN10CA362Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Grand Junction, COThe total loss of engine power for undetermined reasons.NTSB DEN89DTM02Accident · Serious injuriesFinal reportHiller UH-12E · Mack, COThe pilot's failure to maintain proper altitude during a swath run.NTSB DEN89LA084Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Golden, COImproper in-flight planning/decision by the CFI which resulted in loss of tail rotor effectiveness and loss of directional control. Contributing factors were high density altitude, tailwind, and rough/uneven terrain.NTSB DEN85IA117Incident · No injuriesIncident investigationFinal reportHiller UH-12E · Broomfield, COPilot was taking FAA checkride for atp-rotocraft. Examiner requested autorotation demonstration with power recovery due to high gusty winds. Pilot said autorotation was normal until 75-100 ft AGL when rate of descent became excessive. Pilot said before he…NTSB DEN84LA177Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Granby, COThe helicopter plt was on a reconnaissance flt to survey a hilltop landing site in mountainous terrain. When he arrived, he made a high reconnaissance pass, then began a low reconnaissance apch. He estimated the wind was from 210 deg at 10 to 15 KTS with…NTSB DEN81DTE08Accident · No injuriesClosedHiller UH12E · Craig, CONTSB DEN79FTE64Accident · No injuriesClosedHiller 12E · Longmont, CONTSB DEN78FA058Accident · No injuriesClosedHiller UH12E · Berthoud, CONTSB DEN65A0068Accident · No injuriesClosedHiller UH12E · Meredith, CONTSB UNK65X0380Accident · 1 fatalClosedHiller UH12E · Bond, CO