NTSB investigations: Hughes 269B, AR

9 cases on aircraft the registry lists as Hughes 269B. 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 269B, AR per year, 1965–2026: 9 cases
1965	2
1966	3
1967	1
1991	1
1999	1
2008	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" = 'AR' 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 ('4470502')) 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\" = 'AR' 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 ('4470502'))
  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" = 'AR' 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 ('4470502'))
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 DEN08FA122Accident · 2 fatalField investigationFinal reportHughes 269B · Salesville, ARThe pilot's failure to maintain clearance from the crossing transmission line.Jul 15, 2008 · N469E · Destroyed NTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.Aug 23, 1999 · N44KH · Substantial damage NTSB FTW91FA123Accident · 1 fatalField investigationFinal reportHughes 269B · Brickeys, ARThe failure of the clutch control cable due to fraying which initiated the forced landing and the operator's failure to perform recommended inspections on the aircraft. Factors were the pilot's failure to maintain rotor RPM and the unsuitable terrain.Jul 18, 1991 · N11XC · Destroyed NTSB FTW68A0060Accident · Serious injuriesClosedHughes 300 · Fayetteville, ARDec 9, 1967 · N9335F · Destroyed NTSB FTW67A0001Accident · No injuriesClosedHughes 269B · Little Rock, ARJul 1, 1966 · N9303F · Substantial damage NTSB FTW66A0086Accident · 2 fatalClosedHughes 269B · Little Rock, ARApr 4, 1966 · N9392F · Destroyed NTSB FTW66A0072Accident · No injuriesClosedHughes 269B · N.Little Rock, ARFeb 18, 1966 · N9402F · Substantial damage NTSB FTW66A0017Accident · No injuriesClosedHughes 300AG · Briscoe, ARAug 13, 1965 · N9392F · Substantial damage NTSB FTW65A0102Accident · Minor injuriesClosedHughes 269B · Sheridan, ARApr 17, 1965 · N9402F · Substantial damage