NTSB investigations: Hughes OH-6A, TX
8 cases on aircraft the registry lists as Hughes OH-6A. 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
| 1992 | 1 |
|---|---|
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 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 c.\"eventStateOrRegion\" = 'TX' 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 ('4470905'))
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" = 'TX' 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 ('4470905'))
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 CEN13FA205Accident · 1 fatalField investigationFinal reportHughes OH-6A · Caddo, TXThe pilot’s failure to maintain control of the helicopter during landing.NTSB DFW08TA066Accident · Minor injuriesFinal reportHughes OH-6 · Valentine, TXThe contract mechanic's failure to properly secure the castellated nut that attached the governor lever control rod to the idler bell crank. Contributing to the accident was the lack of maintenance oversight by the operator.NTSB FTW04TA012Accident · Minor injuriesFinal reportHughes OH-6A · Eagle Pass, TXThe failure of the aft segment of the tail rotor drive shaft for undertermined reasons. A contibuting factor was the lack of suitable terrain for the foced landing.NTSB FTW00TA116Accident · Minor injuriesFinal reportHughes OH-6A · El Paso, TXThe failure of the pilot to maintain rotor rpm during an autorotation, which resulted in a hard landing. A factor was the partial loss of engine power resulting from the separation of the power control line due to fatigue, as a consequence of improper…NTSB FTW99GA061Accident · Minor injuriesFinal reportHughes OH-6A · Laredo, TXThe loss of engine power as result of the failure of the power turbine governor. A factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW97TA162Accident · No injuriesFinal reportHughes OH-6A · Marfa, TXthe pilot's improper touchdown, and the designated examiner's inadequate supervision. The light condition at dusk was a related factor.NTSB FTW94T#A02Accident · No injuriesClass 3Final reportHughes OH-6A · Valentine, TXNTSB FTW93T#A02Accident · No injuriesFinal reportHughes OH-6A (BP) · Marfa, TX