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.

NTSB FTW76AF065Accident · 4 fatalClosedPiper PA-28R · Mont Belview, TXFeb 15, 1976 · N1542X · DestroyedNTSB FTW76FRA22Accident · Serious injuriesClosedPiper PA-28R · Willis, TXFeb 13, 1976 · N40931 · DestroyedNTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXDec 23, 1975 · N16479 · DestroyedNTSB FTW76FPD09Accident · No injuriesClosedPiper PA-28R · Denton, TXSep 3, 1975 · N55411 · Substantial damageNTSB FTW75AF072Accident · 1 fatalClosedPiper PA-28R · Jasper, TXJun 13, 1975 · N5065S · DestroyedNTSB FTW75FPA11Accident · No injuriesClosedPiper PA-28 · Plano, TXOct 15, 1974 · N41761 · Substantial damageNTSB FTW75FQD03Accident · No injuriesClosedPiper PA-28R · El Paso, TXJul 13, 1974 · N4435T · Substantial damageNTSB FTW74DRA37Accident · No injuriesClosedPiper PA-28 · Baytown, TXApr 29, 1974 · N1398T · Substantial damageNTSB FTW74DRA09Accident · No injuriesClosedPiper PA-28R · Marquez, TXJul 23, 1973 · N4985S · Substantial damageNTSB FTW73FQD17Accident · Minor injuriesClosedPiper PA-28R · El Paso, TXFeb 16, 1973 · N5235T · Substantial damageNTSB FTW73FQG29Accident · Minor injuriesClosedPiper PA-28R · Odessa, TXFeb 4, 1973 · N5046S · Substantial damageNTSB FTW73AF038Accident · 1 fatalClosedPiper PA-28R · Whiteface, TXJan 20, 1973 · N490CC · DestroyedNTSB FTW73FQD04Accident · No injuriesClosedPiper PA-28 · Fabens, TXAug 1, 1972 · N5009S · Substantial damageNTSB FTW72AF023Accident · Minor injuriesClosedPiper PA-28R · La Porte, TXOct 26, 1971 · N5015S · Substantial damageNTSB FTW70AF047Accident · 4 fatalClosedPiper PA-28R · Stonewall, TXJan 9, 1970 · N3035R · Destroyed