NTSB investigations: Hiller UH-12E, IA
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
| 1977 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1992 | 2 |
| 1993 | 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\" = 'IA' 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" = 'IA' 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 CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.NTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.NTSB CHI92DCD04Accident · No injuriesFinal reportHiller UH-12E · Milford, IAA total loss of engine power for an undetermined reason as the helicopter was performing aerial application maneuvers.NTSB MKC84LA153Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Bedford, IAThe plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft…NTSB MKC83LA207Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Corwith, IAWhile en route, the plt heard a clanking noise behind him which was followed by a severe vibration of the flt controls. He initiated an autorotative descent from 3000 ft. he said the helicopter began to roll left, then righted itself. The helicopter touched…NTSB MKC77FCD29Accident · No injuriesClosedHiller Acft 12E · Reasoner, IA