NTSB investigations: Hiller UH-12D, CA
6 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 | 1 |
|---|---|
| 1980 | 1 |
| 1988 | 3 |
| 1989 | 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\" = 'CA' 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" = 'CA' 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 LAX89LA169Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bolinas, CAThe pilot's poor preflight planning in that he did not accurately account for the fuel on board the aircraft as a basis for fuel consumption calculations thereby causing the engine to stop producing power because of a lack of fuel. Contributing to the…NTSB LAX88DUM04Accident · Minor injuriesFinal reportHiller UH-12D · Winterhaven, CANTSB LAX88DVG04Accident · No injuriesFinal reportHiller UH-12E · Winters, CAThe pilot was taking off from a loading truck for his 16th aerial application. He reduced the load from 90 to 70 gals because the winds had become variable. The helicopter descended into ground effect where it normally attains translational lift. The…NTSB LAX88LA153Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bakersfield, CAThe helicopter encountered weather while enroute to its dest and diverted to an alternate arpt. It overflew the alternate and, after the engine failed from fuel exhaustion, crashed during an autorotative forced landing.NTSB LAX80DVG30Accident · Minor injuriesClosedHiller UH-12J · Frks Of Salmn, CANTSB LAX75FYM34Accident · Serious injuriesClosedHiller Acft UH-12D · Paso Robles, CA