NTSB investigations: Hughes 269C, OH
10 cases on aircraft the registry lists as Hughes 269C. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 2004 | 1 |
Where
Latest 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\" = 'OH' 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 ('4470504'))
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" = 'OH' 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 ('4470504'))
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 NYC05CA008Accident · No injuriesData collectionFinal reportHughes 269C · Minerva, OHThe pilot's failure to maintain control of the helicopter during liftoff.NTSB NYC91LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Galloway, OHImproper supervision by the flight instructor which resulted in an inadvertent ground contact and a dynamic rollover. A factor related to the accident was improper use of the flight controls by the non-rated student pilot.NTSB CHI85LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Center Village, OHWhile the student plt practiced hovering 8 to 12 inches AGL the heel of the right skid contacted the ground. The CFI stated he did not notice the helicopter drifting or descending but when the ground contact was felt he took over the controls. Up collective…NTSB CHI80FA014Accident · 1 fatalClosedHughes 269C · West Milton, OHNTSB CHI78DEI28Accident · Serious injuriesClosedHughes 269C · Chesterland, OHNTSB CHI77FEK30Accident · Minor injuriesClosedHughes 269C · Urbana, OHNTSB CHI77FEI13Accident · Minor injuriesClosedHughes 269-C · Cleveland, OHNTSB CHI75FEK20Accident · No injuriesClosedHughes 269C · Columbus, OHNTSB CHI73FEK08Accident · No injuriesClosedHughes 269C · Grove City, OHNTSB CHI71FEG25Accident · No injuriesClosedHughes 269C · Kettering, OH