Skip to content

NTSB investigations: Hiller UH-12E, AZ

21 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

19642026

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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 SEA08LA038Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Yuma, AZFatigue fracture of the control rotor blade spar and failure of maintenance personnel to follow maintenance directives.Nov 24, 2007 · N104EA · Substantial damage NTSB LAX90DUJ03Accident · Serious injuriesFinal reportHiller UH-12E · Yuma, AZThe pilot misjudged the flare altitude. Contributing to this accident was the failure of the engine torsional coupling which ultimately caused the total loss of power.Oct 11, 1989 · N689SB · Substantial damage NTSB LAX89DUJ09Accident · Minor injuriesFinal reportHiller UH-12E · Tolleson, AZAn engine failure due to water contamination in the fuel supply which preceded an autorotation and collision with the ground during night time conditions.Aug 16, 1989 · N7086 · Substantial damage NTSB LAX87DUJ11Accident · Minor injuriesFinal reportHiller UH-12E · Scottsdale, AZDuring an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle…Sep 1, 1987 · N236HA · Destroyed NTSB LAX87DUJ05Accident · No injuriesFinal reportHiller UH-12E · Tolleson, AZThe plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with…May 19, 1987 · N4034T · Destroyed NTSB LAX84LA494Accident · Serious injuriesLimited investigationFinal reportHiller UH12ET · Yuma, AZThe pilot stated that he was carrying a load of pesticide for application on a broccoli field. The aircraft was in level flight, approximately 4 to 8 feet AGL when it became uncontrollable and impacted the ground. The aircraft was consumed by a post crash…Sep 25, 1984 · N9278Z · Destroyed NTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.Aug 20, 1982 · N4026S · Substantial damage NTSB LAX81DUK03Accident · No injuriesClosedHiller Acft UH-12E · Gadsden, AZSep 20, 1981 · N62903 · Substantial damage NTSB LAX80DUJ91Accident · No injuriesClosedHiller Acft UH-12E · Sommerton, AZJul 31, 1980 · N9278Z · Substantial damage NTSB LAX79FUK10Accident · 1 fatalClosedHiller UH-12E · Somerton, AZAug 24, 1979 · N62902 · Destroyed NTSB LAX79DUJ36Accident · No injuriesClosedHiller UH12E · Yuma, AZNov 4, 1978 · N62349 · Destroyed NTSB LAX79DUJ04Accident · Minor injuriesClosedHiller UH-12E · Queen Creek, AZOct 14, 1978 · N518HA · Destroyed NTSB LAX77FUJ90Accident · No injuriesClosedHiller UH-12E · Mesa, AZAug 22, 1977 · N28877 · Substantial damage NTSB LAX77DUJ82Accident · No injuriesClosedHiller Acft UH-12E · Yuma, AZJul 28, 1977 · N62349 · Destroyed NTSB LAX77FUJ67Accident · Serious injuriesClosedHiller Acft UH-12E · Chandler, AZJul 2, 1977 · N50RG · Destroyed NTSB LAX77DUJ24Accident · No injuriesClosedHiller Acft UH-12E · Chandler, AZJan 16, 1977 · N50RG · Substantial damage NTSB LAX76DUJ80Accident · No injuriesClosedHiller Acft UH-12E · Somerton, AZMay 11, 1976 · N9278Z · Substantial damage NTSB LAX75DUJ14Accident · Serious injuriesClosedHiller Acft UH-12E · Gadsden, AZJul 19, 1974 · N62903 · Substantial damage NTSB LAX68A0047Accident · No injuriesClosedHiller UH-12E · Peach Sprngs, AZMar 8, 1967 · N5341V · Substantial damage NTSB DEN65A0066Accident · No injuriesClosedHiller UH12E · Ne Bouse, AZApr 15, 1965 · N9784C · Substantial damage NTSB UNK64X2294Accident · No injuriesClosedHiller 12E · Jacob Lake, AZJun 14, 1964 · N5341V · Substantial damage