Skip to content

NTSB investigations: Piper PA-23-250

858 cases on aircraft the registry lists as Piper PA-23-250. 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 ('7102308')) 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 ('7102308'))
  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 ('7102308'))
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 MIA75AM050Accident · Minor injuriesClosedPiper PA-23 · Vieques, PRJan 31, 1975 · N5030Y · Destroyed NTSB DEN75OD002Accident · No injuriesClosedPiper PA-23 · Mulgulanga V, SFJan 31, 1975 · N6759Y · Destroyed NTSB MIA75DKG55Accident · Minor injuriesClosedPiper PA-23 · Bruswick, GAJan 9, 1975 · N5667Y · Substantial damage NTSB FTW75AF039Accident · 2 fatalClosedPiper PA-23 · Denton, TXDec 10, 1974 · N5085Y · Destroyed NTSB ANC75AA043Accident · 1 fatalClosedPiper PA-23 · Whittier, AKDec 6, 1974 · N5308Y · Substantial damage NTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANov 15, 1974 · N40254 · Substantial damage NTSB LAX75AL027Accident · 3 fatalClosedPiper PA-23 · Van Nuys, CANov 15, 1974 · N6311Y · Destroyed NTSB LAX75AL019Accident · 4 fatalClosedPiper PA-23 · Long Beach, CAOct 18, 1974 · N501EE · Destroyed NTSB NYC75AN049Accident · No injuriesClosedPiper PA-23 · Clarion, PAOct 15, 1974 · N40217 · Substantial damage NTSB IAD75AI023Accident · 3 fatalClosedPiper PA-23 · Bryson City, NCOct 13, 1974 · N6980Y · Destroyed NTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNSep 24, 1974 · N14223 · Substantial damage NTSB MIA75FKJ13Accident · No injuriesClosedPiper PA-23 · Birmingham, ALAug 17, 1974 · N6380Y · Substantial damage NTSB LAX75OL002Accident · No injuriesClosedPiper PA-23 · Tsuniah Lake, CanadaAug 13, 1974 · N54099 · Substantial damage NTSB MKC75AK012Accident · 8 fatalClosedPiper PA-23 · Fergus Falls, MNAug 10, 1974 · N5278Y · Destroyed NTSB OAK75DXQ07Accident · No injuriesClosedPiper PA-23 · Pyramid, NVJul 30, 1974 · N4694P · Substantial damage NTSB FTW75FQG12Accident · No injuriesClosedPiper PA-23 · Dalhart, TXJul 28, 1974 · N411PC · Substantial damage NTSB NYC75FNC06Accident · No injuriesClosedPiper PA-23 · Pittsfield, MEJul 10, 1974 · N6365Y · Substantial damage NTSB NYC75AN001Accident · 5 fatalClosedPiper PA-23 · Acme, PAJul 4, 1974 · N5084Y · Destroyed NTSB ANC74AA084Accident · 1 fatalClosedPiper PA-23 · Kiana, AKJun 25, 1974 · N5330Y · Destroyed NTSB NYC74IN107Incident · No injuriesClosedPiper PA-23 · Batavia, NYJun 11, 1974 · N5708Y · Minor damage NTSB FTW74AF089Accident · 6 fatalClosedPiper PA-23E · Cresson, TXJun 8, 1974 · N777AV · Destroyed NTSB CHI74AC095Accident · 1 fatalClosedPiper PA-23 · Lafayette, INMay 30, 1974 · N1711R · Destroyed NTSB IAD74AI062Accident · No injuriesClosedPiper PA-23 · Cove Point, MDMay 22, 1974 · N40592 · Substantial damage NTSB DEN74FQA45Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMMay 17, 1974 · N5180Y · Substantial damage NTSB NYC74DFA30Accident · Serious injuriesClosedPiper PA-23 · North Elba, NYApr 30, 1974 · N14TD · Destroyed NTSB NYC74FGM25Accident · No injuriesClosedPiper PA-23 · Connelsville, PAApr 19, 1974 · N5209Y · Substantial damage NTSB NYC74AN084Accident · 4 fatalClosedPiper PA-23 · Nantucket, MAApr 2, 1974 · N4623P · Destroyed NTSB SEA74FYA26Accident · Serious injuriesClosedPiper PA-23 · Burley, IDMar 21, 1974 · N123CK · Destroyed NTSB FTW74FPA18Accident · Minor injuriesClosedPiper PA-23 · Farmersville, TXMar 20, 1974 · N50CC · Substantial damage NTSB NYC74FGM20Accident · No injuriesClosedPiper PA-23 · Meadville, PAMar 16, 1974 · N5676Y · Substantial damage NTSB SEA74AS037Accident · 1 fatalClosedPiper PA-23 · Boise, IDMar 14, 1974 · N292M · Destroyed NTSB OAK74AP042Accident · No injuriesClosedPiper PA-23 · Sutter Crk, CAMar 1, 1974 · N6117Y · Substantial damage NTSB SEA74FYG23Accident · Serious injuriesClosedPiper PA-23 · Ritzville, WAFeb 9, 1974 · N6012Y · Destroyed NTSB DEN74FTE57Accident · Serious injuriesClosedPiper PA-23 · Steamboat Sp, COFeb 9, 1974 · N901E · Destroyed NTSB CHI74AC057Accident · Minor injuriesClosedPiper PA-23 · Kokomo, INJan 10, 1974 · N6764Y · Substantial damage NTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKDec 18, 1973 · N14099 · Destroyed NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VADec 11, 1973 · N1905T · Destroyed NTSB FTW74DRJ26Accident · No injuriesClosedPiper PA-23 · Vera Cruz, MexicoDec 5, 1973 · N14348 · Substantial damage NTSB OAK74FVW10Accident · No injuriesClosedPiper PA-23 · Las Vegas, NVDec 2, 1973 · N5171Y · Substantial damage NTSB NYC74AN050Accident · 1 fatalClosedPiper PA-23 · Hanover, NHNov 28, 1973 · N13978 · Destroyed NTSB NYC74AN041Accident · 3 fatalClosedCessna 182P · Dix Hills, NYNov 6, 1973 · N21208 · 2 aircraft · Destroyed NTSB MKC74DCQ16Accident · No injuriesClosedPiper PA-23 · Salina, KSNov 2, 1973 · N6503Y · Minor damage NTSB IAD74AI023Accident · 2 fatalClosedPiper PA-23 · Riverton, WVOct 31, 1973 · N5141Y · Destroyed NTSB MIA74DKJ25Accident · No injuriesClosedPiper PA-23 · Robertsdale, ALSep 21, 1973 · N4510P · Substantial damage NTSB NYC74IN027Incident · No injuriesClosedPiper PA-23 · White Plains, NYSep 19, 1973 · N14196 · Minor damage NTSB OAK74FJA02Accident · Serious injuriesClosedPiper PA-28R · Waimea, HISep 12, 1973 · N4997S · Substantial damage NTSB IAD74FLT04Accident · No injuriesClosedPiper PA-23 · Jackson, TNAug 11, 1973 · N5163Y · Minor damage NTSB NYC74AN012Accident · No injuriesClosedPiper PA-23 · University Prk, PAAug 10, 1973 · N94T · Substantial damage NTSB MIA74FKT10Accident · No injuriesClosedPiper PA-23 · Ft.Lauderdale, FLAug 7, 1973 · N4854P · Substantial damage