NTSB investigations: Hiller UH-12B, 1986
3 cases on aircraft the registry lists as Hiller UH-12B. 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 | 3 |
|---|---|
| 1965 | 4 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 2 |
| 1977 | 2 |
| 1979 | 3 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2012 | 2 |
| 2013 | 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 year(c.\"eventDate\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360110'))
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 year(c."eventDate") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360110'))
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 CHI87LA045Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Capac, MITen minutes after takeoff and just prior to letdown from 350 feet AGL a main rotor blade drag strut failed due to progressive fatigue through a threaded portion of the strut. Only partial control of the helicopter was possible after the failure. The pilot…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 MKC86FA082Accident · Serious injuriesField investigationFinal reportHiller UH-12B · Fall River, KSThe helicopter flew through the tops of trees next to a plowed field and impacted almost straight down in the plowed field and nosed over to the inverted position. The pilot stated that he had intended to land in the field and allowed the airspeed and main…