Skip to content

NTSB investigations: Piper PA-23

331 cases on aircraft the registry lists as Piper PA-23. 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 ('7102302')) 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 ('7102302'))
  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 ('7102302'))
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 SEA67D0301Accident · No injuriesClosedPiper PA-23 · Alderwood Mr, WAApr 2, 1967 · N1203P · Substantial damage NTSB FTW67F0507Accident · No injuriesClosedPiper PA-23 · Okla.City, OKMar 24, 1967 · N2194P · Substantial damage NTSB CHI67F0606Accident · Serious injuriesClosedPiper PA-23 · Alsip, ILMar 17, 1967 · N1485P · Destroyed NTSB CHI68F0475Accident · No injuriesClosedPiper PA-23 · Cobden, ILFeb 23, 1967 · N3080P · Substantial damage NTSB FTW67D0629Accident · No injuriesClosedPiper PA-23 · Pitiquito, MexicoFeb 19, 1967 · N1294P · Destroyed NTSB OAK67A0062Accident · 2 fatalClosedPiper PA-23 · Oakland, CAFeb 17, 1967 · N2043P · 2 aircraft · Destroyed NTSB MIA67F0467Accident · No injuriesClosedPiper PA-23 · Cayce, SCFeb 13, 1967 · N1189P · Substantial damage NTSB MIA67A0083Accident · 1 fatalClosedPiper PA-23 · Flagler Beach, FLFeb 4, 1967 · N2227P · Destroyed NTSB LAX67D0259Accident · No injuriesClosedPiper PA-23 · Ontario, CAJan 22, 1967 · N2043P · Substantial damage NTSB MKC67F0387Accident · No injuriesClosedPiper PA-23 · Augusta, KSDec 21, 1966 · N2236P · Substantial damage NTSB CHI67F0425Accident · No injuriesClosedPiper PA-23 · Muskegon, MIDec 13, 1966 · N4194P · Destroyed NTSB FTW67F0344Accident · No injuriesClosedPiper PA-23 · Fort Worth, TXDec 8, 1966 · N1408P · Substantial damage NTSB CHI67D0341Accident · No injuriesClosedPiper PA-23 · Racine, WIOct 30, 1966 · N2150P · Substantial damage NTSB OAK67D0167Accident · No injuriesClosedPiper PA-23 · Reno, NVSep 27, 1966 · N1368P · Substantial damage NTSB OAK67F0105Accident · No injuriesClosedPiper PA-23 · Honolulu, HISep 23, 1966 · N2060P · Substantial damage NTSB CHI67F0214Accident · No injuriesClosedPiper PA-23 · Cincinnatti, OHSep 22, 1966 · N2123P · Substantial damage NTSB OAK67D0113Accident · No injuriesClosedPiper PA-23 · Fresno, CASep 20, 1966 · N4631P · Substantial damage NTSB LAX67F0146Accident · No injuriesClosedPiper PA-23 · S Bernardino, CASep 12, 1966 · N2164P · Substantial damage NTSB NYC67D0198Accident · No injuriesClosedPiper PA-23 · Pittstown, NJSep 8, 1966 · N1343P · Substantial damage NTSB NYC67D0016Accident · No injuriesClosedPiper PA-23 · Norwood, MAJul 4, 1966 · N4455P · Substantial damage NTSB MIA67F0074Accident · No injuriesClosedPiper PA-23 · Sylvester, GAJul 2, 1966 · N1376P · Substantial damage NTSB NYC67A0002Accident · 3 fatalClosedPiper PA-23 · Neptune, NJJul 1, 1966 · N2014P · Destroyed NTSB LAX67D0041Accident · No injuriesClosedPiper PA-23 · Torrance, CAJun 23, 1966 · N2291P · Substantial damage NTSB MKC67F0277Accident · No injuriesClosedPiper PA-23 · Hazelwood, MOJun 19, 1966 · N2223R · Substantial damage NTSB NYC66F0718Accident · No injuriesClosedPiper PA23 · Salisbury, MDJun 3, 1966 · N1067P · Substantial damage NTSB OAK67D0014Accident · No injuriesClosedPiper PA-23 · Mammoth Lakes, CAMay 27, 1966 · N1438P · Substantial damage NTSB NYC66F0688Accident · Serious injuriesClosedPiper PA-23 · Lincoln, RIMay 25, 1966 · N2184P · Destroyed NTSB CHI66F0763Accident · No injuriesClosedPiper PA-23 · Michigan City, INMay 18, 1966 · N2189P · Substantial damage NTSB NYC66F0621Accident · No injuriesClosedPiper PA-23 · Syracuse, NYApr 13, 1966 · N2183P · Substantial damage NTSB CHI66A0082Accident · 1 fatalClosedPiper PA-23 · Jackson, MIApr 1, 1966 · N1118P · Destroyed NTSB MKC66D0553Accident · No injuriesClosedPiper PA-23 · Guttenberg, IAMar 31, 1966 · N3229P · Substantial damage NTSB MIA66A0107Accident · 2 fatalClosedPiper PA-23 · Gallatin, TNMar 20, 1966 · N2179P · Substantial damage NTSB CHI67F0062Accident · No injuriesClosedPiper PA-23 · East St Louis, ILFeb 19, 1966 · N2153P · Substantial damage NTSB CHI66F0455Accident · No injuriesClosedPiper PA-23 · Ionia, MINov 29, 1965 · N3169P · Substantial damage NTSB CHI66F0444Accident · No injuriesClosedPiper PA-23 · Columbus, OHNov 24, 1965 · N1190P · Substantial damage NTSB CHI66F0402Accident · No injuriesClosedPiper PA-23 · Lansing, MIOct 31, 1965 · N3138P · Substantial damage NTSB DEN66F0129Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMOct 16, 1965 · N3163P · Substantial damage NTSB LAX66A0034Accident · 1 fatalClosedPiper PA-23 · San Diego, CASep 30, 1965 · N3025P · Destroyed NTSB DEN66F0105Accident · No injuriesClosedPiper PA-23 · Evanston, WYSep 16, 1965 · N1096P · Substantial damage NTSB MKC66D0244Accident · No injuriesClosedPiper PA-23 · Springfield, MOSep 14, 1965 · N2180P · Substantial damage NTSB FTW66D0304Accident · No injuriesClosedPiper PA-23 · Crystal City, TXAug 31, 1965 · N1225P · Substantial damage NTSB OAK66D0108Accident · No injuriesClosedPiper PA-23 · San Francisco, CAAug 26, 1965 · N2214P · Substantial damage NTSB DEN66A0006Accident · 3 fatalClosedPiper PA-23 · Douglas, WYAug 9, 1965 · N1272P · Destroyed NTSB FTW66A0010Accident · 6 fatalClosedPiper PA-23 · Tahlequah, OKJul 29, 1965 · N2025P · Destroyed NTSB FTW66F0182Accident · Minor injuriesClosedPiper PA-23 · Fort Worth, TXJul 23, 1965 · N1159P · Substantial damage NTSB DEN66F0063Accident · No injuriesClosedPiper PA-23 · Loveland, COJul 11, 1965 · N6567F · Substantial damage NTSB MIA66F0102Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLJul 2, 1965 · N2036P · Substantial damage NTSB NYC66F0080Accident · No injuriesClosedPiper PA-23 · Ambler, PAJun 19, 1965 · N1325P · Substantial damage NTSB LAX66D0221Accident · No injuriesClosedPiper PA-23 · Long Beach, CAJun 14, 1965 · N1133P · Substantial damage NTSB NYC66F0009Accident · No injuriesClosedPiper PA-23 · Manassas, VAJun 4, 1965 · N1215P · Substantial damage