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.
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" DESCRun 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 CHI76AC057Accident · 1 fatalClosedPiper PA-24 · Cincinnati, OHNTSB MKC76AK053Accident · 3 fatalClosedPiper PA-24 · Decorah, IANTSB FTW76AF069Accident · 2 fatalClosedPiper PA-24 · Alva, OKNTSB SEA76AS028Accident · 2 fatalClosedPiper PA-24 · Myrtle Creek, ORNTSB MIA75AM038Accident · 1 fatalClosedPiper PA-24 · Mobile, ALNTSB LAX75AL031Accident · 4 fatalClosedCessna 172 · S.Luis Obsp, CANTSB DEN74AD022Accident · 1 fatalClosedPiper PA-24 · Roswell, NMNTSB NYC73AN128Accident · 1 fatalClosedPiper PA-24 · Nixon, PANTSB DEN73AD042Accident · 1 fatalClosedPiper PA-24 · Farmington, NMNTSB LAX73OL006Accident · 3 fatalClosedPiper PA-24 · Topia, MexicoNTSB FTW73AF014Accident · 7 fatalClosedPiper PA-24 · Goldthwaite, TXNTSB NYC73AN036Accident · 2 fatalClosedPiper PA-24 · Missing AircraftNTSB DEN72AD039Accident · 1 fatalClosedPiper PA-24 · Jackson, WYNTSB OAK72AP015Accident · 2 fatalClosedPiper PA-24 · Wildwood, CANTSB CHI72AC036Accident · 3 fatalClosedPiper PA-24 · Brighton, MINTSB CHI72AC011Accident · 4 fatalClosedPiper PA-24 · Richardson, KYNTSB FTW72AF013Accident · 2 fatalClosedPiper PA-24 · Missing AircraftNTSB CHI72AC003Accident · 5 fatalClosedPiper PA-24 · Philo, ILNTSB LAX71AL069Accident · 3 fatalClosedPiper PA-24 · Roosevelt, AZNTSB SEA71AS027Accident · 4 fatalClosedPiper PA-24 · St.Charles, IDNTSB MIA71AM043Accident · 3 fatalClosedPiper PA-24 · Missing AircraftNTSB NYC71AN001Accident · 1 fatalClosedPiper PA-24 · Mount Desert, MENTSB CHI70AC050Accident · 2 fatalClosedPiper PA-24 · Carey, OHNTSB MIA70AM062Accident · 2 fatalClosedPiper PA-24 · Missing AircraftNTSB FTW70A0038Accident · 5 fatalClosedPiper PA-24 · Bellevue, TXNTSB LAX70A0016Accident · 6 fatalClosedPiper PA-24 · Blythe, CANTSB FTW69A0059Accident · 2 fatalClosedPiper PA-24 · Clayton, OKNTSB DIA69A0032Accident · 2 fatalClosedPiper PA-24 · Missing AircraftNTSB OAK69A0041Accident · 5 fatalClosedPiper PA-24 · Lodi, CANTSB FTW69A0031Accident · 1 fatalClosedPiper PA-24 · Fayetteville, ARNTSB MIA68A0074Accident · 2 fatalClosedPiper PA-24 · Fernandna Bch, FLNTSB FTW68O0004Accident · 5 fatalClosedPiper PA-24 · Mexico City, MexicoNTSB OAK68D0073Accident · 1 fatalClosedPiper PA-24 · Ukiah, CANTSB MIA67A0114Accident · 2 fatalClosedPiper PA-24 · Darlington, SCNTSB MKC67A0030Accident · 2 fatalClosedPiper PA-24 · Muscatine, IANTSB CHI67A0051Accident · 3 fatalClosedPiper PA-24 · Danville, INNTSB NYC67A0031Accident · 2 fatalClosedPiper PA-24 · Buena Vista, VANTSB LAX67A0016Accident · 2 fatalClosedPiper PA-24 · Newhall, CANTSB CHI66A0098Accident · 6 fatalClosedPiper PA-24 · Alexis, ILNTSB MIA66A0014Accident · 1 fatalClosedPiper PA-24 · Parrish, ALNTSB NYC66A0052Accident · 1 fatalClosedPiper PA-24 · N.Atlantic Ocean (Atlantic Ocean)