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 OAK65A0056Accident · No injuriesClosedHughes 269A · Novato, CAFeb 15, 1965 · N8878F · Substantial damage NTSB NYC65A0103Accident · Minor injuriesClosedHughes 269A · Rochester, NYFeb 11, 1965 · N8815F · Substantial damage NTSB FTW65A0077Accident · Serious injuriesClosedHughes 269A · Oklahoma Cty, OKJan 25, 1965 · N8883F · Destroyed NTSB OAK65A0052Accident · No injuriesClosedHughes 269A · Visalia, CAJan 12, 1965 · N8888F · Substantial damage NTSB UNK65X1124Accident · Serious injuriesClosedHughes 269A · Castiac, CADec 24, 1964 · N8723F · Destroyed NTSB UNK65X1077Accident · No injuriesClosedHughes 269A · Columbus, NEDec 20, 1964 · N8704F · Substantial damage NTSB UNK65X1044Accident · No injuriesClosedHughes 269A · Broomfield, CODec 18, 1964 · N8891F · Substantial damage NTSB UNK65X0970Accident · 1 fatalClosedHughes 269A · Moraga, CADec 10, 1964 · N8811F · Destroyed NTSB UNK65X0576Accident · No injuriesClosedHughes 269A · Broomfield, CONov 5, 1964 · N8829F · Substantial damage NTSB UNK65X0561Accident · No injuriesClosedHughes 269A · Mt Trumbull, AZNov 4, 1964 · N8812F · Substantial damage NTSB UNK65X0279Accident · 2 fatalClosedHughes 269A · Houston, TXOct 14, 1964 · N1010F · Destroyed NTSB UNK65X0253Accident · Serious injuriesClosedHughes 269A · Huntngtn Bh, CAOct 12, 1964 · N8894F · Substantial damage NTSB UNK65X0187Accident · No injuriesClosedHughes 269A · Bakersfield, CAOct 7, 1964 · N8899F · Substantial damage NTSB UNK65X0133Accident · No injuriesClosedHughes 269A · Scottsdale, AZOct 3, 1964 · N8744F · Substantial damage NTSB UNK64X4078Accident · No injuriesClosedHughes 269A · Bryantsville, KYSep 20, 1964 · N8930F · Substantial damage NTSB UNK64X4012Accident · No injuriesClosedHughes 269A · Santa Ana, CASep 16, 1964 · N8844F · Destroyed NTSB UNK64X3930Accident · No injuriesClosedHughes 269A · North Platte, NESep 12, 1964 · N8715F · Destroyed NTSB UNK64X3779Accident · No injuriesClosedHughes 269A · Wasco, CASep 4, 1964 · N8809F · Substantial damage NTSB UNK64X3759Accident · Minor injuriesClosedHughes 269A · Lexington, NESep 3, 1964 · N8800F · Destroyed NTSB UNK64X3704Accident · No injuriesClosedHughes 269A · Phoenix, AZAug 31, 1964 · N8784F · Destroyed NTSB UNK64X3693Accident · No injuriesClosedHughes 269A · Redondo, WAAug 30, 1964 · N8792F · Destroyed NTSB UNK64X3633Accident · No injuriesClosedHughes 269A · Waynesboro, GAAug 27, 1964 · N8758F · Substantial damage NTSB UNK64X3632Accident · No injuriesClosedHughes 269A · New Orleans, LAAug 27, 1964 · N8824F · Substantial damage NTSB UNK64X3451Accident · No injuriesClosedHughes 269A · Raeford, NCAug 18, 1964 · N8913F · Substantial damage NTSB UNK64X3371Accident · No injuriesClosedHughes 269A · Fresno, CAAug 13, 1964 · N8863F · Substantial damage NTSB UNK64X3187Accident · Minor injuriesClosedHughes 269A · Buffalo, NYAug 2, 1964 · N8873F · Substantial damage NTSB UNK64X3185Accident · No injuriesClosedHughes 269A · Oconomowoc Lk, WIAug 2, 1964 · N8924F · Substantial damage NTSB UNK64X3160Accident · No injuriesClosedHughes 269A · Las Vegas, NVAug 1, 1964 · N8859F · Substantial damage NTSB UNK64X3091Accident · No injuriesClosedHughes 269A · Audubon, IAJul 28, 1964 · N8841F · Substantial damage NTSB UNK64X3076Accident · Minor injuriesClosedHughes 269A · Tennille, GAJul 27, 1964 · N8852F · Substantial damage NTSB UNK64X3027Accident · No injuriesClosedHughes 269A · Bowman, SCJul 25, 1964 · N8828F · Substantial damage NTSB UNK64X3022Accident · No injuriesClosedHughes 269A · Wasco, CAJul 25, 1964 · N8851F · Substantial damage NTSB UNK64X2814Accident · No injuriesClosedHughes 269A · Alief, TXJul 13, 1964 · N8789F · Substantial damage NTSB UNK64X2609Accident · Serious injuriesClosedHughes 269A · Burlington, NJJul 2, 1964 · N8779F · Destroyed NTSB UNK64X2599Accident · Minor injuriesClosedHughes 269A · Andalusia, ILJul 1, 1964 · N8748F · Destroyed NTSB UNK64X2380Accident · No injuriesClosedHughes 269A · Broomfield, COJun 19, 1964 · N8892F · Substantial damage NTSB UNK64X2360Accident · Serious injuriesClosedHughes 269A · Red Bank, NJJun 18, 1964 · N8734F · Destroyed NTSB UNK64X2120Accident · No injuriesClosedHughes 269A · Bakersfield, CAJun 4, 1964 · N8741F · Substantial damage NTSB UNK64X1957Accident · Minor injuriesClosedHughes 269A · Mexico, MOMay 25, 1964 · N8929F · Destroyed NTSB UNK64X1502Accident · No injuriesClosedHughes 269A · Phoenix, AZApr 28, 1964 · N8923F · Substantial damage NTSB UNK64X1462Accident · Minor injuriesClosedHughes 269A · Madrid, SPApr 26, 1964 · N8912F · Substantial damage NTSB UNK64X1460Accident · No injuriesClosedHughes 269A · Duncan Mills, CAApr 25, 1964 · N8811F · Substantial damage NTSB UNK64X1327Accident · No injuriesClosedHughes 269A · Mcfarland, CAApr 15, 1964 · N8851F · Substantial damage NTSB UNK64X1194Accident · No injuriesClosedHughes 269A · Puyallup, WAApr 5, 1964 · N8792F · Substantial damage NTSB UNK64X1152Accident · Serious injuriesClosedHughes 269A · Bird Point, AKApr 3, 1964 · N8743F · Substantial damage NTSB UNK64X1150Accident · No injuriesClosedHughes 269A · Phoenix, AZApr 3, 1964 · N8784F · Substantial damage NTSB UNK64X0897Accident · No injuriesClosedHughes 269A · Bandera, TXMar 13, 1964 · N8791F · Substantial damage NTSB UNK64X0877Accident · No injuriesClosedHughes 269A · Sacramento, CAMar 10, 1964 · N8710F · Substantial damage NTSB UNK64X0626Accident · Minor injuriesClosedHughes 269A · White Oaks, NCFeb 20, 1964 · N8831F · Substantial damage NTSB UNK64X0505Accident · No injuriesClosedHughes 269A · Opa Locka, FLFeb 9, 1964 · N8735F · Substantial damage