NTSB investigations: Hiller UH-12E, AR
7 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
| 1981 | 1 |
|---|---|
| 1984 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 2005 | 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\" = 'AR' 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" = 'AR' 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 DFW05CA208Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Hampton, ARA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was unsuitable terrain to complete a successful autorotation.NTSB FTW98LA253Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delaplaine, ARThe failure of maintenance personnel to comply with and airworthiness directive, which resulted in failure of the planetary gear due to lack of lubrication. A contributing factors was the lack of suitable terrain for the pilot to execute a forced landing.NTSB FTW96LA385Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Hamburg, ARThe loss of tail rotor control as result of a tail rotor blade strike by a partially disconnected ballast weight, due to a disconnected pin. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA144Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Osage, ARFuel exhaustion due to the pilot's failure to refuel and the lack of suitable terrain for a forced landing.NTSB MKC84LA128Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Pocahontas, ARThe acft crashed after an engine failure during a swath run at an alt of 20 ft AGL. Examination of the engine revealed 3 dowel pins and 6 screws which hold the starter drive gear and the accessory drive gear had sheared. Metallurgical exam revealed that dowel…NTSB FTW81FPG50Accident · No injuriesClosedHiller Acft UH-12E · Warren, AR