NTSB investigations: Piper PA-28R-200, TX
65 cases on aircraft the registry lists as Piper PA-28R-200. 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 ('7102811'))
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 ('7102811'))
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 FTW76AF065Accident · 4 fatalClosedPiper PA-28R · Mont Belview, TXNTSB FTW76FRA22Accident · Serious injuriesClosedPiper PA-28R · Willis, TXNTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXNTSB FTW76FPD09Accident · No injuriesClosedPiper PA-28R · Denton, TXNTSB FTW75AF072Accident · 1 fatalClosedPiper PA-28R · Jasper, TXNTSB FTW75FPA11Accident · No injuriesClosedPiper PA-28 · Plano, TXNTSB FTW75FQD03Accident · No injuriesClosedPiper PA-28R · El Paso, TXNTSB FTW74DRA37Accident · No injuriesClosedPiper PA-28 · Baytown, TXNTSB FTW74DRA09Accident · No injuriesClosedPiper PA-28R · Marquez, TXNTSB FTW73FQD17Accident · Minor injuriesClosedPiper PA-28R · El Paso, TXNTSB FTW73FQG29Accident · Minor injuriesClosedPiper PA-28R · Odessa, TXNTSB FTW73AF038Accident · 1 fatalClosedPiper PA-28R · Whiteface, TXNTSB FTW73FQD04Accident · No injuriesClosedPiper PA-28 · Fabens, TXNTSB FTW72AF023Accident · Minor injuriesClosedPiper PA-28R · La Porte, TXNTSB FTW70AF047Accident · 4 fatalClosedPiper PA-28R · Stonewall, TX