Skip to content

NTSB investigations: Hiller UH-12E, ID

19 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

Latest cases

Query with SQL

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" = 'ID' 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

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\" = 'ID' 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" = 'ID' 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

Run 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 WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.Jul 24, 2024 · N3375T · Substantial damage NTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.Sep 23, 2021 · N5334V · Substantial damage NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…Aug 31, 2010 · N67264 · Substantial damage NTSB SEA00TA013Accident · Serious injuriesFinal reportHiller UH-12E · Stites, IDInadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…Nov 2, 1999 · N5388V · Substantial damage NTSB SEA99FA037Accident · No injuriesField investigationFinal reportHiller UH-12E · Yellow Pine, IDAltitude deviation during aerial taxi for undetermined reasons.Feb 28, 1999 · N2239 · Substantial damage NTSB SEA99LA031Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Tensed, IDThe pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.Jan 19, 1999 · N67264 · Substantial damage NTSB SEA82FYP11Accident · Serious injuriesFinal reportHiller UH-12-SOLOY · Kellogg, IDThe plt stated he had just released a load of logs & started his transition into forward flt when the eng failed. No usable fuel was on board. The plt stated the fuel gauge registered 50 pounds of fuel when the eng failed. A leak test of the fuel suction…Sep 6, 1982 · N9035H · Substantial damage NTSB SEA81FA053Accident · 3 fatalClosedSoloy UH-12E · Riggins, IDAug 19, 1981 · N544HA · Destroyed NTSB SEA77DYA24Accident · No injuriesClosedHiller Acft UH-12E · Blackfoot, IDJun 6, 1977 · N143HA · Substantial damage NTSB SEA76DYA48Accident · No injuriesClosedHiller Acft UH-12E · Jerome, IDSep 8, 1976 · N62346 · Substantial damage NTSB SEA76DYG47Accident · Minor injuriesClosedHiller Acft UH-12E · Worley, IDApr 22, 1976 · N101EH · Substantial damage NTSB SEA75FYA28Accident · No injuriesClosedHiller Acft UH-12E · Hammett, IDJan 20, 1975 · N7755 · Substantial damage NTSB SEA74DYA24Accident · No injuriesClosedHiller Acft UH-12E · Soda Springs, IDFeb 5, 1974 · N90465 · Substantial damage NTSB SEA74DVA09Accident · No injuriesClosedHiller UH-12E · S.Glenns Ferry, IDAug 26, 1973 · N7755 · Substantial damage NTSB SEA72DYA35Accident · No injuriesClosedHiller Acft UH-12E · Dubois, IDMay 17, 1972 · N90465 · Substantial damage NTSB SEA72DYA07Accident · No injuriesClosedHiller UH12-E · Bliss, IDJul 23, 1971 · N5345V · Substantial damage NTSB SEA69D0043Accident · No injuriesClosedHiller UH-12E · Rockford, IDJul 27, 1968 · N4414 · Substantial damage NTSB SEA68A0028Accident · No injuriesClosedHiller UH-12E · Priest River, IDSep 27, 1967 · N90465 · Substantial damage NTSB SEA67A0060Accident · No injuriesClosedHiller UH-12E · Orofino, IDApr 21, 1967 · N5388V · Substantial damage