Fatal NTSB investigations: Piper PA-24-260

91 cases on aircraft the registry lists as Piper PA-24-260. 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.

Cases, newest first

Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102406'))
  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.

NTSB CHI76AC057Accident · 1 fatalClosedPiper PA-24 · Cincinnati, OHApr 25, 1976 · N8737P · DestroyedNTSB MKC76AK053Accident · 3 fatalClosedPiper PA-24 · Decorah, IAApr 10, 1976 · N8749P · DestroyedNTSB FTW76AF069Accident · 2 fatalClosedPiper PA-24 · Alva, OKMar 11, 1976 · N16MD · DestroyedNTSB SEA76AS028Accident · 2 fatalClosedPiper PA-24 · Myrtle Creek, ORNov 29, 1975 · N9451P · DestroyedNTSB MIA75AM038Accident · 1 fatalClosedPiper PA-24 · Mobile, ALDec 23, 1974 · N9168P · DestroyedNTSB LAX75AL031Accident · 4 fatalClosedCessna 172 · S.Luis Obsp, CADec 3, 1974 · N20184 · 2 aircraft · DestroyedNTSB DEN74AD022Accident · 1 fatalClosedPiper PA-24 · Roswell, NMNov 9, 1973 · N9001P · DestroyedNTSB NYC73AN128Accident · 1 fatalClosedPiper PA-24 · Nixon, PAMar 31, 1973 · N8738P · Substantial damageNTSB DEN73AD042Accident · 1 fatalClosedPiper PA-24 · Farmington, NMMar 18, 1973 · N9433P · DestroyedNTSB LAX73OL006Accident · 3 fatalClosedPiper PA-24 · Topia, MexicoNov 22, 1972 · N8581P · DestroyedNTSB FTW73AF014Accident · 7 fatalClosedPiper PA-24 · Goldthwaite, TXOct 20, 1972 · N9111P · DestroyedNTSB NYC73AN036Accident · 2 fatalClosedPiper PA-24 · Missing AircraftAug 26, 1972 · N9301P · DestroyedNTSB DEN72AD039Accident · 1 fatalClosedPiper PA-24 · Jackson, WYFeb 29, 1972 · N8978P · DestroyedNTSB OAK72AP015Accident · 2 fatalClosedPiper PA-24 · Wildwood, CANov 9, 1971 · N9352P · DestroyedNTSB CHI72AC036Accident · 3 fatalClosedPiper PA-24 · Brighton, MIOct 10, 1971 · N9015P · DestroyedNTSB CHI72AC011Accident · 4 fatalClosedPiper PA-24 · Richardson, KYAug 1, 1971 · N8969P · DestroyedNTSB FTW72AF013Accident · 2 fatalClosedPiper PA-24 · Missing AircraftJul 7, 1971 · N8779P · DestroyedNTSB CHI72AC003Accident · 5 fatalClosedPiper PA-24 · Philo, ILJul 4, 1971 · N9120P · DestroyedNTSB LAX71AL069Accident · 3 fatalClosedPiper PA-24 · Roosevelt, AZMay 21, 1971 · N9145P · DestroyedNTSB SEA71AS027Accident · 4 fatalClosedPiper PA-24 · St.Charles, IDNov 25, 1970 · N8724P · DestroyedNTSB MIA71AM043Accident · 3 fatalClosedPiper PA-24 · Missing AircraftNov 23, 1970 · N9346P · DestroyedNTSB NYC71AN001Accident · 1 fatalClosedPiper PA-24 · Mount Desert, MEJun 30, 1970 · N9349P · DestroyedNTSB CHI70AC050Accident · 2 fatalClosedPiper PA-24 · Carey, OHFeb 7, 1970 · N9399P · DestroyedNTSB MIA70AM062Accident · 2 fatalClosedPiper PA-24 · Missing AircraftJan 17, 1970 · N9078P · DestroyedNTSB FTW70A0038Accident · 5 fatalClosedPiper PA-24 · Bellevue, TXNov 27, 1969 · N8960P · DestroyedNTSB LAX70A0016Accident · 6 fatalClosedPiper PA-24 · Blythe, CASep 3, 1969 · N9304P · DestroyedNTSB FTW69A0059Accident · 2 fatalClosedPiper PA-24 · Clayton, OKFeb 22, 1969 · N8745P · DestroyedNTSB DIA69A0032Accident · 2 fatalClosedPiper PA-24 · Missing AircraftJan 5, 1969 · N8653P · DestroyedNTSB OAK69A0041Accident · 5 fatalClosedPiper PA-24 · Lodi, CAJan 1, 1969 · N8568P · DestroyedNTSB FTW69A0031Accident · 1 fatalClosedPiper PA-24 · Fayetteville, ARJul 28, 1968 · N8948P · DestroyedNTSB MIA68A0074Accident · 2 fatalClosedPiper PA-24 · Fernandna Bch, FLMar 6, 1968 · N8941P · DestroyedNTSB FTW68O0004Accident · 5 fatalClosedPiper PA-24 · Mexico City, MexicoAug 27, 1967 · N9066P · DestroyedNTSB OAK68D0073Accident · 1 fatalClosedPiper PA-24 · Ukiah, CAJun 15, 1967 · N9062P · DestroyedNTSB MIA67A0114Accident · 2 fatalClosedPiper PA-24 · Darlington, SCApr 24, 1967 · N9036P · DestroyedNTSB MKC67A0030Accident · 2 fatalClosedPiper PA-24 · Muscatine, IAOct 18, 1966 · N9108P · DestroyedNTSB CHI67A0051Accident · 3 fatalClosedPiper PA-24 · Danville, INOct 13, 1966 · N8715P · DestroyedNTSB NYC67A0031Accident · 2 fatalClosedPiper PA-24 · Buena Vista, VAAug 18, 1966 · N8555P · DestroyedNTSB LAX67A0016Accident · 2 fatalClosedPiper PA-24 · Newhall, CAAug 5, 1966 · N8950P · DestroyedNTSB CHI66A0098Accident · 6 fatalClosedPiper PA-24 · Alexis, ILJun 15, 1966 · N8929P · DestroyedNTSB MIA66A0014Accident · 1 fatalClosedPiper PA-24 · Parrish, ALJul 24, 1965 · N8616P · DestroyedNTSB NYC66A0052Accident · 1 fatalClosedPiper PA-24 · N.Atlantic Ocean (Atlantic Ocean)Jun 17, 1965 · N8586P · Destroyed