NTSB investigations: Hiller UH-12B
6 cases on aircraft the registry lists as Hiller UH-12B, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1991 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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 ('4360110')
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\" = 353))
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 ('4360110')
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" = 353))
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 LAX05LA112Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Thermal, CAthe pilot's inadequate in-flight planning and failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB ANC04LA027Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Bradenton, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.NTSB MIA01LA085Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Whitesburg, GAThe improper emergency procedure performed by the pilot due to his electing to perform a run-on landing resulting in excessive airspeed at touchdown and subsequent roll-over following ground contact with grass. A contributing factor was the inadequate…NTSB NYC91LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Westfield, MAThe pilot's failure to refuel resulting in a power failure due to fuel exhaustion, and subsequent forced landing in unsuitable terrain.NTSB SEA86FA139Accident · Serious injuriesField investigationFinal reportHiller UH12B · Rathdrum, IDThe plt reported noticing the fuel gage was nearing empty shortly before the eng quit. The acft crashed during an attempted forced landing on a road. The plt stated he was flying the acft to his residence where it was based. Investigation revealed little fuel…NTSB ATL83FA261Accident · No injuriesField investigationFinal reportHiller UH-12B · Huntsville, ALThe helicopter was damaged in a forced autorotative landing after the engine quit at 1200 ft MSL in cruise flt. The acftlanded in a mowed wheat field and the right skid dug into the soft ground. The plt and passengers declared no injureis. The plt said the…