Final NTSB investigations: Hiller UH-12E, ND
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
| 1980 | 2 |
|---|---|
| 1983 | 1 |
| 1987 | 2 |
| 1990 | 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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" = 'ND' AND c."eventCountry" = 'USA'
AND c."completionStatus" = 'Completed'
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 CHI90DTG02Accident · No injuriesFinal reportHiller UH-12-E · Garrison, NDThe failure of the helicopter tail rotor control cable. A factor related to the accident was the chafing of the tail rotor control cable.NTSB DEN87LA157Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Ray, NDThe plt reports that he was departing from an aerial app operating area. He said there was a tree line along a road with an opening and the takeoff was made toward the opening. There were wires across the opening and the poles were obscured by the trees on…NTSB DEN87LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Grafton, NDThe plt was positioning the helicopter for an aerial application project. Before taking off, he checked the fuel quantity indicator & estimated there was 30 min of fuel on board. The proposed flt was estimated to take 10 min. During flt, the eng lost power &…NTSB DEN83LA204Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Manning, NDThe acft collided with the ground after an eng failure while stringing power lines. The acft was in a right side low, nose high attitude pulling a wire attached to the left side of the acft. The wind was from the right rear quarter when the loss of power…NTSB DEN81DTG03Accident · No injuriesClosedHiller Acft UH-12E · Watford City, NDNTSB DEN81FTG01Accident · No injuriesClosedHiller UH12E · Argusville, ND