Skip to content

NTSB investigations: Piper PA-23-160

273 cases on aircraft the registry lists as Piper PA-23-160. 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 ('7102304')) 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 ('7102304'))
  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 ('7102304'))
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 FTW68F0145Accident · No injuriesClosedPiper PA-23 · Hobart, OKAug 2, 1967 · N4225P · Substantial damage NTSB NYC68F0102Accident · No injuriesClosedPiper PA-23 · Jamestown, NYJun 26, 1967 · N4423P · Substantial damage NTSB LAX68D0042Accident · No injuriesClosedPiper PA-23 · Bakersfield, CAJun 24, 1967 · N4279P · Substantial damage NTSB CHI68D0130Accident · No injuriesClosedPiper PA-23 · Chicago, ILJun 15, 1967 · N4240P · Substantial damage NTSB MKC67F0612Accident · No injuriesClosedPiper PA-23 · Hopkins, MNMay 24, 1967 · N3471P · Substantial damage NTSB MIA68D0007Accident · No injuriesClosedPiper PA-23 · Ft.Lauderdale, FLApr 5, 1967 · N4108P · Substantial damage NTSB SEA67A0056Accident · 2 fatalClosedPiper PA-23 · Leadore, IDMar 28, 1967 · N4459P · Destroyed NTSB NYC67A0130Accident · No injuriesClosedPiper PA-23 · Jamaica, NYMar 19, 1967 · N4319P · Substantial damage NTSB MIA67F0489Accident · No injuriesClosedPiper PA-23 · Auburn, ALMar 19, 1967 · N3423P · Substantial damage NTSB MIA67A0089Accident · No injuriesClosedPiper PA-23 · St-Thomas, VIFeb 26, 1967 · N4308Y · Destroyed NTSB CHI67A0096Accident · No injuriesClosedPiper PA-23 · Mt.Hope, WIFeb 12, 1967 · N4240P · Substantial damage NTSB FTW67A0079Accident · 2 fatalClosedPiper PA-23 · Los Fresnos, TXFeb 4, 1967 · N3296P · Destroyed NTSB MIA67A0079Accident · 3 fatalClosedPiper PA-23Jan 17, 1967 · N4129P · Destroyed NTSB NYC67F0469Accident · No injuriesClosedPiper PA-23 · Wappingers Fls, NYJan 6, 1967 · N4086P · Substantial damage NTSB FTW67F0393Accident · No injuriesClosedPiper PA-23 · Austin, TXDec 23, 1966 · N4367P · Substantial damage NTSB NYC67F0441Accident · No injuriesClosedPiper PA-23 · Waterford, CTDec 15, 1966 · N4249P · Substantial damage NTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNov 28, 1966 · N4054P · Substantial damage NTSB CHI67D0390Accident · No injuriesClosedPiper PA-23 · Gladwin, MINov 16, 1966 · N4264P · Substantial damage NTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJOct 29, 1966 · N4306Y · Substantial damage NTSB SEA67A0023Accident · 3 fatalClosedPiper PA-23 · Stanley, IDSep 14, 1966 · N4242P · Substantial damage NTSB CHI67F0267Accident · No injuriesClosedBeech E18S · Fremont, OHAug 31, 1966 · N3646B · 2 aircraft · Substantial damage NTSB OAK67D0260Accident · No injuriesClosedPiper PA-23 · San Carlos, CAAug 29, 1966 · N4302P · Substantial damage NTSB MIA67A0020Accident · No injuriesClosedPiper PA-23 · Odessa, FLAug 4, 1966 · N4036P · Substantial damage NTSB NYC67A0021Accident · No injuriesClosedPiper PA-23 · Red Bank, NJJul 30, 1966 · N4073P · Substantial damage NTSB MIA67F0189Accident · No injuriesClosedPiper PA-28 · Jacksonville, FLJul 23, 1966 · N8431W · 2 aircraft · Minor damage NTSB OAK67A0005Accident · 1 fatalClosedPiper PA-23 · San Jose, CAJul 11, 1966 · N5550V · Destroyed NTSB MIA67F0082Accident · No injuriesClosedPiper PA-23 · St Augustine, FLJul 8, 1966 · N4032P · Substantial damage NTSB CHI67F0049Accident · No injuriesClosedPiper PA-23 · Orleans, INJun 2, 1966 · N4401P · Substantial damage NTSB FTW67F0017Accident · No injuriesClosedPiper PA23 · Lafayette, LAMay 17, 1966 · N4121P · Substantial damage NTSB FTW66F0647Accident · No injuriesClosedPiper PA-23 · Houston, TXApr 30, 1966 · N4367P · Substantial damage NTSB MKC66A0055Accident · 1 fatalClosedPiper PA-23 · Winchester, ARApr 28, 1966 · N4261P · Destroyed NTSB MKC66F0538Accident · No injuriesClosedPiper PA-23 · Iowa City, IAApr 20, 1966 · N3301P · Substantial damage NTSB CHI66F0644Accident · No injuriesClosedPiper PA-23 · Elgin, ILFeb 12, 1966 · N4255P · Substantial damage NTSB NYC66F0484Accident · No injuriesClosedPiper PA-23 · Somerville, NJFeb 11, 1966 · N4490P · Substantial damage NTSB MKC66F0392Accident · No injuriesClosedPiper PA-23 · Garner, IAJan 27, 1966 · N3325P · Substantial damage NTSB NYC66F0402Accident · No injuriesClosedPiper PA-23 · Leesburg, VANov 24, 1965 · N198MC · Substantial damage NTSB NYC66F0361Accident · Serious injuriesClosedPiper PA-23 · Mt.Holly, NJNov 3, 1965 · N6136 · Destroyed NTSB NYC66F0349Accident · No injuriesClosedPiper PA-23 · Old Town, MENov 3, 1965 · N3372P · Substantial damage NTSB MIA66S0002Accident · Minor injuriesClosedPiper PA-23 · Punta Caucedo, DROct 17, 1965 · N4082P · Substantial damage NTSB MIA66F0363Accident · No injuriesClosedPiper PA-23 · Mobile, ALOct 8, 1965 · N3486P · Substantial damage NTSB MKC66D0237Accident · No injuriesClosedPiper PA-23 · Iowa Falls, IASep 17, 1965 · N3325P · Substantial damage NTSB MIA66F0204Accident · No injuriesClosedPiper PA-23 · Memphis, TNSep 13, 1965 · N338WS · Substantial damage NTSB MKC66F0195Accident · No injuriesClosedPiper PA-23 · Wallace, NESep 7, 1965 · N4322P · Substantial damage NTSB MIA66F0216Accident · No injuriesClosedPiper PA-23 · Mobile, ALAug 25, 1965 · N4300Y · Substantial damage NTSB LAX66D0118Accident · No injuriesClosedPiper PA-23 · Thousand Oaks, CAJul 21, 1965 · N4120P · Substantial damage NTSB FTW66F0102Accident · No injuriesClosedPiper PA-23 · Liberty, TXJun 19, 1965 · N3404P · Substantial damage NTSB MKC66F0073Accident · No injuriesClosedPiper PA-23 · Des Moines, IAJun 17, 1965 · N3348P · Substantial damage NTSB CHI66D0050Accident · No injuriesClosedPiper PA-23 · Cleveland, OHJun 11, 1965 · N4042P · Substantial damage NTSB NYC66F0021Accident · Minor injuriesClosedPiper PA-23 · Perry, NYMay 31, 1965 · N4387P · Substantial damage NTSB FTW66F0027Accident · No injuriesClosedPiper PA-23 · Little Rock, ARMay 21, 1965 · N4020P · Substantial damage