NTSB investigations: Hiller UH-12D, OR
10 cases on aircraft the registry lists as Hiller UH-12D. 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
| 1975 | 2 |
|---|---|
| 1977 | 1 |
| 1980 | 2 |
| 1982 | 1 |
| 1993 | 2 |
| 2012 | 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\" = 'OR' 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 ('4360118'))
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" = 'OR' 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 ('4360118'))
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 WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.NTSB WPR12LA347Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Deer Island, ORA loss of helicopter control while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB SEA94LA039Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH-12D · Sublimity, ORFuel exhaustion due to inadequate preflight and refueling not acomplished.NTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.NTSB SEA82FYM11Accident · Minor injuriesFinal reportHiller UH-12E · Mount Angle, ORThe aircraft was being used on an external load operation. On his fourth load, the pilot was to transport a 1190 lb electric pump and fan from the back of a pickup truck. While preparing to lift the load, the pilot was not satisfied with its position. He…NTSB SEA80DYM55Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORNTSB SEA80FYM30Accident · No injuriesClosedHiller Acft UH-12D · Scappoose, ORNTSB SEA77DYM18Accident · No injuriesClosedHiller Acft UH12D · Pendleton, ORNTSB SEA76FYC26Accident · Minor injuriesClosedHiller Acft UH-12D · Nehalem, ORNTSB SEA75DYC42Accident · No injuriesClosedHiller Acft UH-12D · Manzanita, OR