NTSB investigations: Hiller UH-12E
18 cases on aircraft the registry lists as Hiller UH-12E, where the first occurrence was “In flight collision with object”. 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
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 LAX03CA284Accident · No injuriesData collectionFinal reportHiller UH12E · Kekaha, HIthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.NTSB LAX00LA027Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Castroville, CAThe pilot's inadequate visual lookout and diverted attention.NTSB FTW97LA131Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Donna, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight. A factor was the power lines.NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.NTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.NTSB LAX93LA319Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Dixon, CAthe failure of the pilot to visually detect and avoid the guy wire.NTSB LAX92LA401Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Coachella, CAThe pilot's inadequate visual lookout and his failure to maintain an adequate clearance from the wires.NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.NTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.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 FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.NTSB NYC84LA212Accident · No injuriesLimited investigationFinal reportHiller 12E · Meadville, PAThe acft flew into wires during a crop spraying mission. The acft was flying at about 5-10 ft when a flash was seen overhead. The acft vibrated and slowed before impacting the ground and rolling over.NTSB CHI83LA321Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooklyn Park, MNThe plt reported that he was spraying the end rows of a field when the helicopter approached some wires. He stated that he saw the wires at the last second & tried to get under them. Reportedly, the helicopter crossed below a set of power lines, but struck a…NTSB FTW83LA217Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quanah, TXThe helicopter was being used to search for cattle. As the plt was looking down through some bushes for cattle, the m/r blade hit a powerline wire about 25 ft AGL.NTSB LAX83LA069Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Near Vacaville, CAThe aircraft collided with a telephone wire during takeoff. The pilot made a precautionary landing on the soft bank of a levee to assess the damage and left the rotor at idle. The levee bank gave way and the helicopter slid into the ditch where the rotor…NTSB ATL82DA214Accident · No injuriesFinal reportHiller UH-12E · Centre, ALWhile returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing.NTSB LAX82DVA14Accident · Serious injuriesFinal reportHiller UH-12E · Chowchilla, CAThe pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer…