NTSB investigations: Hughes 269C
8 cases on aircraft the registry lists as Hughes 269C, where the sequence of events included Loss of control in flight. 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2016 | 2 |
| 2017 | 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 ('4470504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('4470504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 GAA18CA060Accident · No injuriesData collectionFinal reportHughes 300 · Woodlawn, VAThe pilot’s inappropriate descent profile during landing with a quartering gusting tailwind, which resulted in a loss of main rotor rpm.NTSB CEN16FA315Accident · 1 fatalField investigationFinal reportHughes 269C · Howe, TXThe improper execution of an autorotation following the loss of engine power, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor's lack of remedial action during the autorotation.NTSB GAA16CA363Accident · No injuriesData collectionFinal reportHughes 269C · Cullman, ALThe helicopter flight instructor candidate's improper execution of the autorotation, resulting in abnormal ground contact and subsequent damage to the vertical stabilizer and tail rotor drive assembly.NTSB WPR13CA160Accident · No injuriesData collectionFinal reportHughes 269C · Rialto, CAThe student pilot’s failure to maintain helicopter control while maneuvering in a hover.NTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.NTSB WPR12FA191Accident · Serious injuriesField investigationFinal reportHughes 269C · Phoenix, AZA loss of tail rotor drive due to a fatigue failure of the main transmission pinion, which resulted in a loss of directional control during cruise flight.NTSB WPR11LA325Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wenatchee, WAThe pilot's failure to maintain control while hovering out of ground effect at low altitude, which resulted in the helicopter settling into trees.NTSB CEN09LA202Accident · Serious injuriesLimited investigationFinal reportHughes 269C · El Indio, TXThe pilot's failure to maintain control of the helicopter while attempting to land on a transport trailer in heavy rain and gusting winds.