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 MIA69A0003Accident · 4 fatalClosedPiper PA-23 · Ft Lauderdale, FLJul 7, 1968 · N5694Y · Destroyed NTSB NYC69D0051Accident · No injuriesClosedPiper PA-23 · Tarentum, PAJun 28, 1968 · N6279Y · Substantial damage NTSB ANC68I0052Incident · No injuriesClosedPiper PA-23 · Anchorage, AKJun 25, 1968 · N5926Y · Minor damage NTSB DIA68A0052Accident · 1 fatalClosedPiper PA-23 · New Bern, NCJun 21, 1968 · N5355Y · Destroyed NTSB FTW69F0010Accident · No injuriesClosedPiper PA-23 · Alexandria, LAJun 5, 1968 · N6033Y · Substantial damage NTSB CHI69D0057Accident · No injuriesClosedPiper PA-23 · Lorain, OHMay 22, 1968 · N5070Y · Substantial damage NTSB DEN68A0052Accident · No injuriesClosedPiper PA-23 · Conejos, COMay 7, 1968 · N6139Y · Substantial damage NTSB CHI68F0722Accident · No injuriesClosedPiper PA-23 · Findlay, OHApr 25, 1968 · N5752Y · Substantial damage NTSB NYC68A0106Accident · No injuriesClosedPiper PA-23 · Flushing, NYMar 13, 1968 · N5610Y · Substantial damage NTSB SEA68A0057Accident · 1 fatalClosedPiper PA-23 · Cascade, IDMar 7, 1968 · N5427Y · Destroyed NTSB LAX68D0341Accident · No injuriesClosedPiper PA-23 · Palm Springs, CAMar 5, 1968 · N5466Y · Substantial damage NTSB CHI68F0610Accident · No injuriesClosedPiper PA-23 · Middletown, OHFeb 24, 1968 · N4874P · Substantial damage NTSB NYC68A0098Accident · 3 fatalClosedPiper PA-23 · Wappngrs Falls, NYFeb 9, 1968 · N5877Y · Destroyed NTSB MIA68D0432Accident · No injuriesClosedPiper PA-23 · Dublin, GAJan 21, 1968 · N4846P · Substantial damage NTSB FTW68F0412Accident · No injuriesClosedPiper PA-23 · Baton Rouge, LAJan 4, 1968 · N6285Y · Substantial damage NTSB NYC68A0086Accident · No injuriesClosedPiper PA-23 · Allentown, PAJan 3, 1968 · N4563P · Substantial damage NTSB UNK68X0115Incident · No injuriesClosedPiper PA-23 · Caborca, MexicoDec 21, 1967 · N5271Y · Minor damage NTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARDec 20, 1967 · N5904Y · Substantial damage NTSB NYC68F0328Accident · No injuriesClosedPiper PA-23 · Winooski, VTDec 18, 1967 · N5691Y · Destroyed NTSB MKC68D0425Accident · No injuriesClosedPiper PA-23 · Montrose, MODec 12, 1967 · N6059Y · Substantial damage NTSB CHI68F0469Accident · No injuriesClosedPiper PA-23 · Cottage Hill, ILDec 5, 1967 · N148AF · Substantial damage NTSB FTW68D0377Accident · No injuriesClosedPiper PA-23 · Andrews, TXNov 30, 1967 · N5032Y · Substantial damage NTSB DIA68A0022Accident · Serious injuriesClosedPiper PA-23 · Sandston, VANov 24, 1967 · N6106Y · Destroyed NTSB MIA68F0281Accident · No injuriesClosedPiper PA-23 · Muscle Shoals, ALOct 29, 1967 · N4776P · Substantial damage NTSB MIA68F0214Accident · No injuriesClosedPiper PA-23 · Dorado Beach, PROct 3, 1967 · N377DW · Substantial damage NTSB MIA68F0224Accident · No injuriesClosedPiper PA-23 · Nashville, TNOct 1, 1967 · N5100Y · Substantial damage NTSB NYC68A0050Accident · No injuriesClosedPiper PA-23 · New London, CTSep 24, 1967 · N4900P · Substantial damage NTSB MIA68F0195Accident · No injuriesClosedPiper PA-23 · Columbus, GASep 2, 1967 · N4584P · Substantial damage NTSB NYC68D0139Accident · No injuriesClosedPiper PA-23 · Fitchburg, MASep 1, 1967 · N5930Y · Substantial damage NTSB OAK68D0202Accident · No injuriesClosedPiper PA-23 · Redding, CAAug 23, 1967 · N5286Y · Substantial damage NTSB MIA68F0220Accident · Minor injuriesClosedPiper PA-23 · Aiken, SCAug 22, 1967 · N5766Y · Substantial damage NTSB FTW68D0175Accident · No injuriesClosedPiper PA-23 · Gurdon, ARAug 22, 1967 · N5595Y · Substantial damage NTSB SEA68D0136Accident · No injuriesClosedPiper PA-23 · Georgetown, WAAug 15, 1967 · N4893P · Substantial damage NTSB SEA68D0053Accident · No injuriesClosedPiper PA-23 · Caldwell, IDJul 31, 1967 · N6194Y · Substantial damage NTSB MIA68D0157Accident · No injuriesClosedPiper PA-23 · Titusville, FLJul 29, 1967 · N5184Y · Substantial damage NTSB MKC68D0390Accident · No injuriesClosedPiper PA-23 · Kansas City, MOJul 25, 1967 · N5979Y · Substantial damage NTSB CHI68F0215Accident · No injuriesClosedPiper PA-23 · Grand Haven, MIJul 15, 1967 · N4634P · Substantial damage NTSB MKC68A0004Accident · 2 fatalClosedPiper PA-23 · Benton, MOJul 13, 1967 · N4786P · Destroyed NTSB NYC68A0004Accident · No injuriesClosedPiper PA-23 · Pottstown, PAJul 10, 1967 · N5806Y · Substantial damage NTSB NYC68D0087Accident · No injuriesClosedPiper PA-23 · Laconia, NHJul 7, 1967 · N5670Y · Substantial damage NTSB MIA68F0042Accident · No injuriesClosedPiper PA-23 · Augusta, GAJul 5, 1967 · N5557Y · Substantial damage NTSB CHI68D0015Accident · No injuriesClosedPiper PA-23 · Lexington, KYJul 2, 1967 · N5935Y · Substantial damage NTSB NYC67A0178Accident · 2 fatalClosedPiper PA-23 · Tannersville, NYJun 13, 1967 · N5604Y · Destroyed NTSB DEN67D0301Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMJun 10, 1967 · N6066Y · Substantial damage NTSB SEA67D0331Accident · No injuriesClosedPiper PA-23 · Kennewick, WAMay 18, 1967 · N5834Y · Substantial damage NTSB CHI67D0644Accident · No injuriesClosedPiper PA-23 · Bloomington, INMay 3, 1967 · N4644P · Substantial damage NTSB NYC67A0151Accident · 2 fatalClosedPiper PA-23 · Hershey, PAApr 30, 1967 · N8888 · Destroyed NTSB LAX67D0374Accident · No injuriesClosedPiper PA-23 · Calexico, CAApr 16, 1967 · N5478Y · Substantial damage NTSB NYC67F0598Accident · No injuriesClosedPiper PA-23 · Granville, NYMar 27, 1967 · N5604Y · Substantial damage NTSB MIA67D0490Accident · No injuriesClosedPiper PA-23 · Marco, FLMar 17, 1967 · N6286Y · Substantial damage