Skip to content

NTSB investigations: Hughes 269A

401 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, newest first

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."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.\"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."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 MKC75FCG49Accident · Serious injuriesClosedHughes 269A · Rossville, KSJun 1, 1975 · N8898F · Destroyed NTSB MKC75DER68Accident · No injuriesClosedHughes 269A · Lafayette, MNMay 21, 1975 · N8929F · Substantial damage NTSB SEA75DYA42Accident · No injuriesClosedHughes 269A1A · Burley, IDMay 18, 1975 · N8859F · Substantial damage NTSB MIA75FLG35Accident · No injuriesClosedHughes 269A · Ridge Springs, SCMay 12, 1975 · N8735F · Substantial damage NTSB CHI75FEG21Accident · Minor injuriesClosedHughes 269A · Tipp City, OHMay 12, 1975 · N444E · Substantial damage NTSB SEA75AYC34Accident · No injuriesClosedHughes 269A · Astoria, ORApr 8, 1975 · N8775F · Substantial damage NTSB MKC75FCQ37Accident · Minor injuriesClosedHughes 269A · Hutchinson, KSMar 12, 1975 · N8927F · Substantial damage NTSB DEN75DQA32Accident · No injuriesClosedHughes 269A · Gallup, NMFeb 9, 1975 · N8810F · Substantial damage NTSB MKC75FCD29Accident · No injuriesClosedHughes 269A · Bettendorf, IADec 30, 1974 · N8823F · Destroyed NTSB NYC75FFJ11Accident · Serious injuriesClosedHughes 269A · Groveland, NYSep 12, 1974 · N8733F · Substantial damage NTSB FTW75FPG10Accident · No injuriesClosedHughes 269A · W.Memphis, ARJul 31, 1974 · N8751F · Destroyed NTSB IAD75DKM01Accident · Minor injuriesClosedHughes 269A · Shelby, NCJul 7, 1974 · N8934F · Substantial damage NTSB DEN74DTC39Accident · Minor injuriesClosedHughes 269A · Douglas, WYJun 22, 1974 · N8859F · Substantial damage NTSB MIA74FLT05Accident · No injuriesClosedHughes 269A · Walls, MSJun 4, 1974 · N8885F · Substantial damage NTSB CHI74FEC40Accident · No injuriesClosedHughes 269A-1 · Imlay City, MIApr 27, 1974 · N8902F · Substantial damage NTSB OAK74FJA19Accident · 1 fatalClosedHughes 269A · Kekaha, HIApr 24, 1974 · N8732F · Destroyed NTSB MKC74DCQ25Accident · No injuriesClosedHughes 269A · Scott City, KSFeb 5, 1974 · N8719F · Substantial damage NTSB MIA74FLG21Accident · No injuriesClosedHughes 269-A · St Matthews, SCJan 22, 1974 · N8718F · Substantial damage NTSB LAX74FUQ27Accident · No injuriesClosedPitts Spcl S1C · Burbank, CAJan 5, 1974 · N1XX · 2 aircraft · Minor damage NTSB OAK74FJA09Accident · No injuriesClosedHughes 269A · Kahalui, HIDec 5, 1973 · N8732F · Substantial damage NTSB CHI74FEC20Accident · No injuriesClosedHughes 269A · Howell, MINov 9, 1973 · N8798F · Substantial damage NTSB MIA74FKG41Accident · No injuriesClosedHughes 269A · Hartwell, GAOct 15, 1973 · N8917F · Substantial damage NTSB SEA74DYE19Accident · No injuriesClosedHughes 269A · Forks, WASep 23, 1973 · N8763F · Substantial damage NTSB OAK74FVG09Accident · No injuriesClosedHughes 269 · Sloughhouse, CASep 9, 1973 · N8759F · Destroyed NTSB DEN74FTE18Accident · No injuriesClosedHughes 269A · Ft Collins, COSep 9, 1973 · N8859F · Substantial damage NTSB FTW74FQD01Accident · Minor injuriesClosedHughes 269A · Alpine, TXJul 12, 1973 · N8926F · Destroyed NTSB SEA74DYE03Accident · No injuriesClosedHughes 269A · Renton, WAJul 7, 1973 · N2SW · Destroyed NTSB DEN74FTE04Accident · No injuriesClosedHughes 269A1 · Ft.Collins, COJul 6, 1973 · N8803F · Substantial damage NTSB DEN73FTC28Accident · No injuriesClosedHughes 269A · Baggs, WYJun 11, 1973 · N8859F · Destroyed NTSB CHI73FET22Accident · Minor injuriesClosedHughes 269A · Gary, INMay 28, 1973 · N8790F · Substantial damage NTSB DEN73FTE77Accident · Minor injuriesClosedHughes 269B · Broomfield, COMay 21, 1973 · N9333V · Substantial damage NTSB IAD73FLT16Accident · No injuriesClosedHughes 269A · Memphis, TNMay 8, 1973 · N8885F · Substantial damage NTSB FTW73AF064Accident · 1 fatalClosedHughes 269A · Uvalde, TXMay 1, 1973 · N8774F · Destroyed NTSB DEN73FTE67Accident · No injuriesClosedHughes 269A · Lafayette, COMar 21, 1973 · N8891F · Substantial damage NTSB DEN73FTC19Accident · No injuriesClosedHughes 269A · Hanna, WYFeb 22, 1973 · N8859F · Substantial damage NTSB FTW73DRG32Accident · No injuriesClosedHughes 269A · Uvalde, TXDec 13, 1972 · N8774F · Substantial damage NTSB CHI73FET09Accident · No injuriesClosedHughes 269A · Gary, INNov 1, 1972 · N8790F · Substantial damage NTSB NYC73DHA08Accident · No injuriesClosedHughes 269A · Lenhartsville, PASep 23, 1972 · N8936F · Substantial damage NTSB MIA73FLG21Accident · Minor injuriesClosedHughes 269A · Ridge Springs, SCSep 21, 1972 · N8735F · Substantial damage NTSB SEA73FYC08Accident · Serious injuriesClosedHughes 269A · Portland, ORSep 9, 1972 · N8752F · Destroyed NTSB MIA73FKG33Accident · Serious injuriesClosedHughes 269A · Elberton, GASep 6, 1972 · N8917F · Destroyed NTSB CHI73DEC04Accident · No injuriesClosedHughes 269A · Troy, MIAug 26, 1972 · N8889F · Destroyed NTSB NYC72FHM54Accident · Minor injuriesClosedHughes 269A · Livngstn Manor, NYMay 30, 1972 · N8866F · Destroyed NTSB MIA72FLG35Accident · Minor injuriesClosedHughes 269A · Johns Island, SCApr 28, 1972 · N8909F · Substantial damage NTSB CHI72FET10Accident · No injuriesClosedHughes 269A · Griffith, INOct 26, 1971 · N8810F · Substantial damage NTSB LAX72FUG18Accident · No injuriesClosedHughes 269A · Irwindale, CASep 30, 1971 · N8757F · Substantial damage NTSB MKC72DCD24Accident · No injuriesClosedHughes 269A · Nevada, IAAug 13, 1971 · N8892F · Substantial damage NTSB DEN72DTE10Accident · No injuriesClosedHughes 269A · Ft Collins, COAug 7, 1971 · N8891F · Substantial damage NTSB NYC72FFJ10Accident · No injuriesClosedHughes 269A · Gainesville, NYAug 5, 1971 · N8716F · Substantial damage NTSB MKC71FCQ46Accident · Minor injuriesClosedHughes 269-A · Wichita, KSJun 28, 1971 · N8719F · Destroyed