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.

NTSB FTW76FPD19Accident · No injuriesClosedPiper PA-24 · Fort Worth, TXNov 12, 1975 · N8346P · Substantial damageNTSB FTW76DQG24Accident · No injuriesClosedPiper PA-24 · Christoval, TXSep 16, 1975 · N7213P · Substantial damageNTSB FTW76DQG02Accident · No injuriesClosedPiper PA-24 · Bovina, TXJul 9, 1975 · N6164P · Substantial damageNTSB FTW75FQG47Accident · No injuriesClosedPiper PA-24 · Wayside, TXMar 24, 1975 · N6711P · Substantial damageNTSB FTW75DRG02Accident · No injuriesClosedPiper PA-24 · Austin, TXJul 13, 1974 · N7824P · Substantial damageNTSB FTW74DQG40Accident · No injuriesClosedPiper PA-24 · Bovina, TXJan 17, 1974 · N8230P · Substantial damageNTSB FTW74FPD13Accident · Minor injuriesClosedPiper PA-24 · Quanah, TXSep 19, 1973 · N6139P · DestroyedNTSB FTW73AF025Accident · 3 fatalClosedPiper PA-24 · Quemado, TXDec 9, 1972 · N7714P · DestroyedNTSB FTW72AF068Accident · 3 fatalClosedPiper PA-24 · Seminole, TXApr 13, 1972 · N8395P · DestroyedNTSB FTW72FRA11Accident · Serious injuriesClosedPiper PA-24 · Lagrange, TXOct 10, 1971 · N5400P · Substantial damageNTSB FTW72FQD09Accident · No injuriesClosedPiper PA-24 · Girvin, TXSep 4, 1971 · N5624P · Substantial damageNTSB FTW72DQD04Accident · No injuriesClosedPiper PA-24 · Sierra Blanca, TXJul 17, 1971 · N7117P · Substantial damageNTSB FTW71FRH31Accident · No injuriesClosedPiper PA-24 · Mcallen, TXMay 27, 1971 · N7731P · Substantial damageNTSB FTW71FPA01Accident · No injuriesClosedPiper PA-24 · Waco, TXJul 6, 1970 · N7582P · Substantial damageNTSB FTW70FQD14Accident · Minor injuriesClosedPiper PA-24 · El Paso, TXMay 21, 1970 · N7865P · Substantial damageNTSB FTW70DQG11Accident · No injuriesClosedPiper PA-24 · Gruver, TXMar 9, 1970 · N7955P · Substantial damageNTSB FTW70FQG03Accident · No injuriesClosedPiper PA-24 · San Angelo, TXFeb 1, 1970 · N6923P · Substantial damageNTSB FTW70F0320Accident · No injuriesClosedPiper PA-24 · Crane, TXDec 12, 1969 · N5697P · Substantial damageNTSB FTW70F0330Accident · No injuriesClosedPiper PA-24 · Lubbock, TXDec 2, 1969 · N7562P · Substantial damageNTSB FTW70D0152Accident · No injuriesClosedPiper PA-24 · Mccamey, TXAug 9, 1969 · N7117P · Substantial damageNTSB DEN70F0074Accident · No injuriesClosedPiper PA-24 · El Paso, TXAug 8, 1969 · N7161P · Substantial damageNTSB FTW70D0125Accident · No injuriesClosedPiper PA-24 · Eastland, TXJul 12, 1969 · N6689P · Substantial damageNTSB FTW70D0049Accident · No injuriesClosedPiper PA-24 · Lubbock, TXJun 7, 1969 · N6715P · Substantial damageNTSB FTW69A0071Accident · 3 fatalClosedPiper PA-24 · Wolfe City, TXApr 9, 1969 · N6028P · DestroyedNTSB FTW69F0263Accident · No injuriesClosedPiper PA-24 · Big Spring, TXOct 26, 1968 · N5693P · Substantial damageNTSB FTW69D0108Accident · Minor injuriesClosedPiper PA-24 · Seminole, TXJul 27, 1968 · N7451P · Substantial damageNTSB FTW68F0298Accident · No injuriesClosedPiper PA-24 · Burleson, TXMay 27, 1968 · N7994P · DestroyedNTSB FTW68A0087Accident · 2 fatalClosedPiper PA-24 · Austin, TXApr 8, 1968 · N5942P · DestroyedNTSB FTW68D0420Accident · Minor injuriesClosedPiper PA-24 · Realitos, TXJan 8, 1968 · N181G · DestroyedNTSB FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXDec 27, 1967 · N7097P · DestroyedNTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXDec 19, 1967 · N6885P · DestroyedNTSB FTW68D0379Accident · No injuriesClosedPiper PA-24 · Ralls, TXDec 2, 1967 · N8445P · Substantial damageNTSB FTW68D0426Accident · No injuriesClosedPiper PA-24 · Maude, TXNov 10, 1967 · N7811P · Substantial damageNTSB FTW68F0272Accident · No injuriesClosedPiper PA-24 · Mcniel, TXSep 9, 1967 · N5441P · Substantial damageNTSB FTW68D0153Accident · No injuriesClosedPiper PA-24 · Stanton, TXAug 13, 1967 · N7961P · Substantial damageNTSB FTW68F0031Accident · No injuriesClosedPiper PA-24 · Rockwell, TXJul 9, 1967 · N5345P · Substantial damageNTSB FTW68F0086Accident · No injuriesClosedPiper PA-24 · San Antonio, TXJul 7, 1967 · N8010P · Substantial damageNTSB FTW67F0637Accident · Minor injuriesClosedPiper PA-24 · Anderson, TXMay 13, 1967 · N7362P · Substantial damageNTSB FTW67F0582Accident · No injuriesClosedPiper PA-24 · Luling, TXApr 23, 1967 · N6172P · Substantial damageNTSB FTW67D0560Accident · No injuriesClosedPiper PA-24 · Stamford, TXApr 16, 1967 · N5697P · Substantial damageNTSB FTW67F0536Accident · No injuriesClosedPiper PA-24 · Big Springs, TXApr 10, 1967 · N7562P · Substantial damageNTSB FTW67F0484Accident · No injuriesClosedPiper PA-24 · Dallas, TXMar 5, 1967 · N5564P · Substantial damageNTSB FTW67F0434Accident · No injuriesClosedPiper PA-24 · Angleton, TXJan 26, 1967 · N7797P · Substantial damageNTSB FTW67D0470Accident · No injuriesClosedPiper PA-24 · Lyford, TXDec 26, 1966 · N6028P · Substantial damageNTSB FTW67D0300Accident · No injuriesClosedPiper PA-24 · Columbus, TXNov 18, 1966 · N6200P · Substantial damageNTSB FTW67A0057Accident · 1 fatalClosedPiper PA-24 · Sanderson, TXNov 15, 1966 · N5519P · DestroyedNTSB FTW67F0281Accident · Minor injuriesClosedPiper PA-24 · Mineral Wells, TXOct 26, 1966 · N8317P · Substantial damageNTSB FTW67D0389Accident · No injuriesClosedPiper PA-24 · Austin, TXOct 15, 1966 · N5693P · Substantial damageNTSB FTW67F0198Accident · No injuriesClosedPiper PA-24 · Wichita Falls, TXSep 7, 1966 · N7979P · Substantial damageNTSB FTW67F0181Accident · No injuriesClosedPiper PA-24 · Houston, TXAug 22, 1966 · N7324P · Substantial damage