NTSB investigations: Hughes 269A, OK

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Hughes 269A, OK per year, 1965–2026: 10 cases
1965	2
1966	2
1967	1
1977	1
1979	1
1982	2
2002	1

Where

Open the map

Latest cases

Query with SQL

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" = 'OK' 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

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\" = 'OK' 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" = 'OK' 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

Run 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 FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.Nov 1, 2002 · N8885F · Destroyed NTSB FTW82DA327Accident · No injuriesFinal reportHughes 269A · Forgan, OKThe purpose of the flight was to look for a missing person. The pilot reported that during an approach to land, he lost tail rotor control and the helicopter began to spin to the right. He set the helicopter down while it was turning, but the right skid hit a…Aug 14, 1982 · N8827F · Substantial damage NTSB FTW82FPJ15Accident · Serious injuriesFinal reportHughes 269 · Boise City, OKThe plt had completed conducting tests with dyed water to determine spray pattern & coverage after recently installing special purpose aerial application equipment. While approaching for a landing at a forward speed of 15-20 mph & descending rapidly he…Jul 17, 1982 · N8873F · Substantial damage NTSB FTW79DPJ15Accident · Minor injuriesClosedHughes 269A · Alva, OKMay 5, 1979 · N8892F · Substantial damage NTSB FTW77FPM18Accident · No injuriesClosedHughes 269A · Council Hill, OKAug 21, 1977 · N8716F · Substantial damage NTSB FTW67A0122Accident · No injuriesClosedHughes 269A · Tulsa, OKJun 30, 1967 · N8733F · Substantial damage NTSB FTW67A0027Accident · Minor injuriesClosedHughes 269A · Tulsa, OKSep 3, 1966 · N8733F · Destroyed NTSB FTW66A0084Accident · No injuriesClosedHughes 269A · Tulsa, OKMar 28, 1966 · N8733F · Substantial damage NTSB FTW66A0005Accident · 2 fatalClosedHughes 269A · Woodward, OKJul 17, 1965 · N8710F · Destroyed NTSB FTW65A0077Accident · Serious injuriesClosedHughes 269A · Oklahoma Cty, OKJan 25, 1965 · N8883F · Destroyed