NTSB investigations: Hughes 269A, OH
12 cases on aircraft the registry lists as Hughes 269A. 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
| 1965 | 2 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 2008 | 2 |
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\" = '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 ('4470402'))
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 ('4470402'))
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 CHI08CA267Accident · No injuriesData collectionFinal reportHughes 269A · Bremen, OHThe pilot's failure to maintain sufficient main rotor speed during the quick-stop maneuver. Contributing to the accident was the drainage ditch.NTSB CHI08CA097Accident · No injuriesData collectionFinal reportHughes 269A · Franklin Furnac, OHThe fuel exhaustion during cruise flight and the unsuitable terrain encountered by the pilot-in-command. A contributing factor was the trees.NTSB CHI81FEK26Accident · Serious injuriesClosedHughes 269A · Newark, OHNTSB CHI77FEG20Accident · No injuriesClosedHughes 269A · Cincinnati, OHNTSB CHI76FEG12Accident · Serious injuriesClosedHughes 269A · West Charlestn, OHNTSB CHI75FEG21Accident · Minor injuriesClosedHughes 269A · Tipp City, OHNTSB CHI70F0309Accident · 1 fatalClosedHughes 269A · Moreland Hil, OHNTSB CHI69A0032Accident · 1 fatalClosedHughes 269A · Camp Denison, OHNTSB CHI65A0015Accident · Minor injuriesClosedHughes 269A · Findley, OHNTSB CHI67A0132Accident · No injuriesClosedHughes 269A · Euclid, OHNTSB CHI66A0035Accident · No injuriesClosedHughes 269A · Cleveland, OHNTSB CHI65A0091Accident · Minor injuriesClosedHughes 269A · Columbus, OH