NTSB investigations: Hughes 269A, WA
14 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1973 | 2 |
| 1978 | 1 |
| 1982 | 1 |
| 1990 | 1 |
| 2002 | 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\" = 'WA' 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" = 'WA' 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 SEA02LA150Accident · No injuriesLimited investigationFinal reportHughes 269A · Covington, WAAircraft control not maintained while hovering.NTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.NTSB SEA82DA082Accident · No injuriesFinal reportHughes 269A · 2nm Nnm Redmond, WAThe engine lost power during the climb and the pilot executed an autorotation. Upon landing the aircraft rocked back and the main rotor severed the tail boom.NTSB SEA78FA033Accident · 1 fatalClosedHughes 269A · Vancouver, WANTSB SEA74DYE19Accident · No injuriesClosedHughes 269A · Forks, WANTSB SEA74DYE03Accident · No injuriesClosedHughes 269A · Renton, WANTSB SEA71DWD24Accident · No injuriesClosedHughes 269A · Chehalis, WANTSB SEA69F0129Accident · No injuriesClosedHughes 269A · Renton, WANTSB SEA68D0281Accident · No injuriesClosedHughes 269A · Yakima, WANTSB SEA67A0052Accident · No injuriesClosedHughes 269A · Yakima, WANTSB SEA66A0016Accident · No injuriesClosedHughes 269A · Granite Flls, WANTSB SEA65A0050Accident · Minor injuriesClosedHughes 269A · L.Quinault, WANTSB UNK64X3693Accident · No injuriesClosedHughes 269A · Redondo, WANTSB UNK64X1194Accident · No injuriesClosedHughes 269A · Puyallup, WA