NTSB investigations: Hiller UH-12C, CA
13 cases on aircraft the registry lists as Hiller UH-12C. 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
| 1964 | 2 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 3 |
| 1972 | 1 |
| 1973 | 3 |
| 1995 | 2 |
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 ('4360116'))
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 ('4360116'))
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 LAX95LA326Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Porterville, CAthe flight instructor's inadequate supervision of the flight; the dual student's improper use of the flight controls; and improper remedial action.NTSB LAX95LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Rio Vista, CAThe result of a chafing failure of the left anti-torque control cable while the aircraft was in flight. An inadequate preflight inspection by the pilot-in-command, and an inadequate 100-hour inspection by company maintenance personnel were factors in this…NTSB OAK74FVD14Accident · No injuriesClosedHiller Acft UH-12C · Brentwood, CANTSB OAK74DVM02Accident · No injuriesClosedHiller Acft UH-12C · Gonzalez, CANTSB OAK73FVM40Accident · Minor injuriesClosedHiller Acft UH-12C · Salinas, CANTSB OAK73FVD14Accident · 1 fatalClosedHiller Acft UH-12C · Brentwood, CANTSB OAK71DVA46Accident · No injuriesClosedHiller Acft UH-12C · Fresno, CANTSB OAK71DVM12Accident · No injuriesClosedHiller Acft UH-12C · Castroville, CANTSB OAK70DVM09Accident · Minor injuriesClosedHiller Acft UH-12C · Castroville, CANTSB LAX69D0317Accident · No injuriesClosedHiller UH-12C · Compton, CANTSB OAK68A0036Accident · No injuriesClosedHiller UH-12C · Riverdale, CANTSB UNK64X2135Accident · No injuriesClosedHiller UH12C · San Bernardino, CANTSB UNK64X0705Accident · No injuriesClosedHiller UH12C · Chatsworth, CA