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 DIA67A0012Accident · 1 fatalClosedPiper PA-23 · Oldtown, MDMar 1, 1967 · N5868Y · Destroyed NTSB SEA67D0247Accident · Minor injuriesClosedPiper PA-23 · Royal City, WAFeb 7, 1967 · N4619P · Substantial damage NTSB MKC67D0434Accident · No injuriesClosedPiper PA-23 · Independence, MOJan 31, 1967 · N5979Y · Substantial damage NTSB NYC67A0116Accident · No injuriesClosedPiper PA-23 · Cooperstown, NYJan 29, 1967 · N5333Y · Substantial damage NTSB NYC67F0410Accident · No injuriesClosedPiper PA-23 · Easton, PAJan 9, 1967 · N6053Y · Substantial damage NTSB LAX67D0266Accident · No injuriesClosedPiper PA-23 · Oceanside, CAJan 9, 1967 · N4508P · Substantial damage NTSB NYC67A0100Accident · 1 fatalClosedPiper PA-23 · Atlantic Ocean (Atlantic Ocean)Jan 6, 1967 · N4652P · Destroyed NTSB SEA67D0203Accident · No injuriesClosedPiper PA-23 · Almira, WADec 3, 1966 · N4947P · Substantial damage NTSB NYC67D0386Accident · No injuriesClosedPiper PA-23 · Waldorf, MDNov 30, 1966 · N5574Y · Substantial damage NTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANov 23, 1966 · N4562P · Destroyed NTSB FTW67D0314Accident · No injuriesClosedPiper PA-23 · Eunice, LANov 13, 1966 · N6209Y · Substantial damage NTSB MIA67F0303Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNov 5, 1966 · N5203Y · Substantial damage NTSB NYC67D0381Accident · No injuriesClosedPiper PA-23 · Jamaica, NYNov 1, 1966 · N309SL · Substantial damage NTSB NYC67A0071Accident · No injuriesClosedPiper PA-23 · Farmingdale, NJOct 30, 1966 · N5708Y · Substantial damage NTSB MKC67F0254Accident · No injuriesClosedPiper PA-23 · Des Moines, IAOct 15, 1966 · N6193Y · Substantial damage NTSB OAK67D0182Accident · No injuriesClosedPiper PA-23 · Arcata, CASep 6, 1966 · N4541P · Substantial damage NTSB LAX67D0111Accident · No injuriesClosedPiper PA-23 · Oceanside, CAAug 25, 1966 · N4508P · Substantial damage NTSB MKC67F0160Accident · No injuriesClosedPiper PA-23 · Columbus Jct, IAAug 17, 1966 · N4529P · Substantial damage NTSB FTW67F0136Accident · No injuriesClosedPiper PA-23 · Big Spring, TXAug 15, 1966 · N5447Y · Substantial damage NTSB MKC67F0176Accident · No injuriesClosedPiper PA-23 · Broken Bow, NEAug 13, 1966 · N5128Y · Substantial damage NTSB CHI67A0019Accident · No injuriesClosedPiper PA-23 · Chicago, ILAug 5, 1966 · N6093Y · Substantial damage NTSB NYC67F0218Accident · No injuriesClosedPiper PA-23 · Bohemia, NYJul 30, 1966 · N5691Y · Substantial damage NTSB LAX67A0013Accident · No injuriesClosedPiper PA-23 · Grand Canyon, AZJul 30, 1966 · N4680P · Substantial damage NTSB OAK67A0014Accident · 1 fatalClosedPiper PA-23 · Hayward, CAJul 27, 1966 · N5749Y · Destroyed NTSB FTW67F0077Accident · No injuriesClosedPiper PA-23 · Stuttgart, ARJul 15, 1966 · N5220Y · Substantial damage NTSB FTW67D0082Accident · No injuriesClosedPiper PA-23 · Baboragama, MexicoJul 1, 1966 · N5268Y · Substantial damage NTSB MIA67D0056Accident · No injuriesClosedPiper PA-23 · Orlando, FLJun 29, 1966 · N4905P · Substantial damage NTSB NYC67F0061Accident · Serious injuriesClosedPiper PA-23 · Hasbrouck Hght, NJJun 28, 1966 · N5350Y · Destroyed NTSB MIA66A0149Accident · 4 fatalClosedPiper PA-23 · Ashland, ALJun 27, 1966 · N5775Y · Destroyed NTSB DEN67D0021Accident · No injuriesClosedPiper PA-23 · Littleton, COJun 17, 1966 · N4873P · Substantial damage NTSB CHI66A0099Accident · 3 fatalClosedCurtis C-46 · Columbia City, INJun 16, 1966 · N10415 · 2 aircraft · Destroyed NTSB FTW66A0104Accident · 2 fatalClosedPiper PA-23 · Batesville, TXMay 16, 1966 · N4869P · Destroyed NTSB NYC66A0128Accident · 4 fatalClosedPiper PA-23 · Indian Head, PAMay 8, 1966 · N5823Y · Destroyed NTSB UNK66X0133Accident · No injuriesClosedPiper PA-23 · San Luis, MexicoMar 31, 1966 · N5173Y · Substantial damage NTSB SEA66F0267Accident · No injuriesClosedPiper PA-23 · Portland, ORMar 23, 1966 · N4628P · Substantial damage NTSB NYC66F0556Accident · No injuriesClosedPiper PA-23 · Snydertown, PAMar 9, 1966 · N4562P · Substantial damage NTSB MIA66D0453Accident · No injuriesClosedPiper PA-23 · Miami, FLFeb 27, 1966 · N5694Y · Substantial damage NTSB LAX66F0238Accident · No injuriesClosedPiper PA-23 · Los Angeles, CAFeb 12, 1966 · N103MC · Substantial damage NTSB CHI66F0571Accident · No injuriesClosedPiper PA-23 · Dowagiac, MIFeb 2, 1966 · N5655Y · Substantial damage NTSB CHI66F0536Accident · No injuriesClosedPiper PA-23 · Columbus, OHFeb 1, 1966 · N5512Y · Substantial damage NTSB OAK66F0176Accident · No injuriesClosedPiper PA-23 · Reno, NVDec 29, 1965 · N5572Y · Substantial damage NTSB CHI66F0475Accident · No injuriesClosedPiper PA-23 · Muncie, INDec 26, 1965 · N5655Y · Substantial damage NTSB MIA66A0071Accident · No injuriesClosedPiper PA-23 · Huntsville, ALDec 21, 1965 · N5636Y · Substantial damage NTSB CHI66A0055Accident · No injuriesClosedPiper PA-23 · Detroit, MIDec 6, 1965 · N5700Y · Substantial damage NTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, ARNov 4, 1965 · N5836Y · Substantial damage NTSB DEN66F0157Accident · No injuriesClosedPiper PA-23 · Cheyenne, WYOct 25, 1965 · N5448Y · Substantial damage NTSB OAK66D0165Accident · No injuriesClosedPiper PA-23 · Furnace Creek, CAOct 24, 1965 · N5478Y · Substantial damage NTSB NYC66A0036Accident · 1 fatalClosedPiper PA-23 · Glen Burnie, MDSep 20, 1965 · N5759Y · Destroyed NTSB MIA66F0253Accident · No injuriesClosedPiper PA-23 · Albemarle, NCSep 19, 1965 · N5329Y · Substantial damage NTSB MIA66F0252Accident · No injuriesClosedPiper PA-23 · Pompano Beach, FLSep 12, 1965 · N5658Y · Substantial damage