NTSB investigations: Piper PA-24-250, TX
130 cases on aircraft the registry lists as Piper PA-24-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.
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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
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 FTW76FPD19Accident · No injuriesClosedPiper PA-24 · Fort Worth, TXNTSB FTW76DQG24Accident · No injuriesClosedPiper PA-24 · Christoval, TXNTSB FTW76DQG02Accident · No injuriesClosedPiper PA-24 · Bovina, TXNTSB FTW75FQG47Accident · No injuriesClosedPiper PA-24 · Wayside, TXNTSB FTW75DRG02Accident · No injuriesClosedPiper PA-24 · Austin, TXNTSB FTW74DQG40Accident · No injuriesClosedPiper PA-24 · Bovina, TXNTSB FTW74FPD13Accident · Minor injuriesClosedPiper PA-24 · Quanah, TXNTSB FTW73AF025Accident · 3 fatalClosedPiper PA-24 · Quemado, TXNTSB FTW72AF068Accident · 3 fatalClosedPiper PA-24 · Seminole, TXNTSB FTW72FRA11Accident · Serious injuriesClosedPiper PA-24 · Lagrange, TXNTSB FTW72FQD09Accident · No injuriesClosedPiper PA-24 · Girvin, TXNTSB FTW72DQD04Accident · No injuriesClosedPiper PA-24 · Sierra Blanca, TXNTSB FTW71FRH31Accident · No injuriesClosedPiper PA-24 · Mcallen, TXNTSB FTW71FPA01Accident · No injuriesClosedPiper PA-24 · Waco, TXNTSB FTW70FQD14Accident · Minor injuriesClosedPiper PA-24 · El Paso, TXNTSB FTW70DQG11Accident · No injuriesClosedPiper PA-24 · Gruver, TXNTSB FTW70FQG03Accident · No injuriesClosedPiper PA-24 · San Angelo, TXNTSB FTW70F0320Accident · No injuriesClosedPiper PA-24 · Crane, TXNTSB FTW70F0330Accident · No injuriesClosedPiper PA-24 · Lubbock, TXNTSB FTW70D0152Accident · No injuriesClosedPiper PA-24 · Mccamey, TXNTSB DEN70F0074Accident · No injuriesClosedPiper PA-24 · El Paso, TXNTSB FTW70D0125Accident · No injuriesClosedPiper PA-24 · Eastland, TXNTSB FTW70D0049Accident · No injuriesClosedPiper PA-24 · Lubbock, TXNTSB FTW69A0071Accident · 3 fatalClosedPiper PA-24 · Wolfe City, TXNTSB FTW69F0263Accident · No injuriesClosedPiper PA-24 · Big Spring, TXNTSB FTW69D0108Accident · Minor injuriesClosedPiper PA-24 · Seminole, TXNTSB FTW68F0298Accident · No injuriesClosedPiper PA-24 · Burleson, TXNTSB FTW68A0087Accident · 2 fatalClosedPiper PA-24 · Austin, TXNTSB FTW68D0420Accident · Minor injuriesClosedPiper PA-24 · Realitos, TXNTSB FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXNTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXNTSB FTW68D0379Accident · No injuriesClosedPiper PA-24 · Ralls, TXNTSB FTW68D0426Accident · No injuriesClosedPiper PA-24 · Maude, TXNTSB FTW68F0272Accident · No injuriesClosedPiper PA-24 · Mcniel, TXNTSB FTW68D0153Accident · No injuriesClosedPiper PA-24 · Stanton, TXNTSB FTW68F0031Accident · No injuriesClosedPiper PA-24 · Rockwell, TXNTSB FTW68F0086Accident · No injuriesClosedPiper PA-24 · San Antonio, TXNTSB FTW67F0637Accident · Minor injuriesClosedPiper PA-24 · Anderson, TXNTSB FTW67F0582Accident · No injuriesClosedPiper PA-24 · Luling, TXNTSB FTW67D0560Accident · No injuriesClosedPiper PA-24 · Stamford, TXNTSB FTW67F0536Accident · No injuriesClosedPiper PA-24 · Big Springs, TXNTSB FTW67F0484Accident · No injuriesClosedPiper PA-24 · Dallas, TXNTSB FTW67F0434Accident · No injuriesClosedPiper PA-24 · Angleton, TXNTSB FTW67D0470Accident · No injuriesClosedPiper PA-24 · Lyford, TXNTSB FTW67D0300Accident · No injuriesClosedPiper PA-24 · Columbus, TXNTSB FTW67A0057Accident · 1 fatalClosedPiper PA-24 · Sanderson, TXNTSB FTW67F0281Accident · Minor injuriesClosedPiper PA-24 · Mineral Wells, TXNTSB FTW67D0389Accident · No injuriesClosedPiper PA-24 · Austin, TXNTSB FTW67F0198Accident · No injuriesClosedPiper PA-24 · Wichita Falls, TXNTSB FTW67F0181Accident · No injuriesClosedPiper PA-24 · Houston, TX