NTSB investigations: Hiller OH-23G
8 cases on aircraft the registry lists as Hiller OH-23G. 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 2 |
| 1983 | 1 |
| 1987 | 1 |
| 1994 | 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 ('4360121'))
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 ('4360121'))
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 ANC94LA045Accident · No injuriesLimited investigationFinal reportHiller UH12E · Valdez, AKThe inadvertent closure of the fuel supply shutoff valve.NTSB LAX87DVA04Accident · No injuriesFinal reportHiller OH-23G · Delano, CADuring an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…NTSB SEA83LA059Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Near Oakridge, ORAccording to the pilot, a 250 lb load on a 30 ft external line had been set down at a site at an elevation of about 3500 ft MSL. After the load was released, the pilot attempted to transition from a hover to a climb, but the helicopter began to settle.…NTSB LAX81DVD28Accident · No injuriesClosedHiller Acft UH-12E · Orleans, CANTSB SEA81FYM25Accident · No injuriesClosedHiller Acft UH-12E · Milton-Freewtr, ORNTSB SEA78DYP44Accident · No injuriesClosedHiller Acft UH-12E · Mesa, WANTSB LAX77DVA35Accident · No injuriesClosedHiller Acft UH-12E · Bakersfield, CANTSB SEA76DYG67Accident · No injuriesClosedHiller Acft UH-12E · Clark Fork, ID