NTSB investigations: Hiller OH-23B
7 cases on aircraft the registry lists as Hiller OH-23B. 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
| 1973 | 1 |
|---|---|
| 1978 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 2014 | 1 |
| 2016 | 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 ('4360109'))
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 ('4360109'))
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 CEN17LA055Accident · Serious injuriesLimited investigationFinal reportHiller OH 23B · Tynan, TXThe student pilot's delayed and improper landing flare during a practice autorotation, which resulted in the tail rotor striking terrain.NTSB ERA15CA059Accident · No injuriesData collectionFinal reportHiller OH 23B · Leesburg, VAA loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.NTSB FTW89LA043Accident · No injuriesLimited investigationFinal reportHiller OH-23B · Wichita Falls, TXThe pilot's improper use of the carburetor heat during flight and his improper flare during an autorotative landing. Contributing factors were: carburetor icing conditions, improper in-flight planning/decision by the pilot, a tailwind during the landing, and…NTSB NYC85FGM02Accident · Serious injuriesFinal reportHiller UH-12B · Butler, PAAfter training at mcville arpt for about 1HR & 15MIN the plt decided to purchase fuel, taxied to the fuel pumps & discovered that the operator was not there. The CFI EST that there was sufficient fuel to fly to Butler county arpt, aprx 18 miles away. During…NTSB ATL84LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Mccullough, ALThe acft crashed in a cotton field after maneuvering at low alt to check the crop. The pilot said he was at an alt of 4 or 5 ft and forward flt was below transitional lift speed. The rotor RPM began to reduce and also there was a drop in engine RPM. The pilot…NTSB IAD78FID21Accident · No injuriesClosedHiller Acft UH-12B · Roanoke, VANTSB UNK73X0110Accident · No injuriesClosedHiller Acft UH-12B · Gothenburg, SW