NTSB investigations: Piper PA-28-140, AL

78 cases on aircraft the registry lists as Piper PA-28-140. 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\" = 'AL' 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 ('7102802'))
  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 MIA71DLA48Accident · No injuriesClosedPiper PA-28 · Florala, ALMay 21, 1971 · N5540F · Substantial damageNTSB MIA71FKJ52Accident · No injuriesClosedPiper PA-28 · Columbia, ALMay 2, 1971 · N3869K · Substantial damageNTSB MIA71FKJ45Accident · No injuriesClosedPiper PA-28 · Grady, ALApr 10, 1971 · N5735U · Substantial damageNTSB MIA71DKJ55Accident · No injuriesClosedPiper PA-28 · Grove Hill, ALMar 11, 1971 · N4326J · Substantial damageNTSB MIA71DKJ41Accident · No injuriesClosedPiper PA-28 · Meridianville, ALMar 7, 1971 · N5640U · Substantial damageNTSB MIA71DKJ40Accident · No injuriesClosedPiper PA-28 · Russellville, ALFeb 7, 1971 · N8370R · Substantial damageNTSB MIA71DKJ33Accident · No injuriesClosedPiper PA-28 · Talladega, ALNov 24, 1970 · N9777W · Substantial damageNTSB MIA71AKJ20Accident · Minor injuriesClosedPiper PA-28 · Jasper, ALSep 29, 1970 · N5763U · DestroyedNTSB MIA71FKJ18Accident · No injuriesClosedPiper PA-28 · Birmingham, ALSep 20, 1970 · N1576J · Substantial damageNTSB MIA71FKD04Accident · No injuriesClosedPiper PA-28 · Birmingham, ALAug 11, 1970 · N1692J · Substantial damageNTSB MIA71DKJ05Accident · No injuriesClosedPiper PA-28 · Dutton, ALJul 25, 1970 · N5708F · Substantial damageNTSB MIA70DKJ20Accident · No injuriesClosedPiper PA-28 · Birmingham, ALApr 3, 1970 · N5119G · Substantial damageNTSB MIA70DKJ06Accident · No injuriesClosedPiper PA-28 · Enterprise, ALJan 24, 1970 · N3869K · Substantial damageNTSB MIA69A0016Accident · 2 fatalClosedPiper PA-28 · Eufaula, ALSep 22, 1968 · N6544W · DestroyedNTSB MIA69D0034Accident · No injuriesClosedPiper PA-28 · Decatur, ALJun 27, 1968 · N6321R · Substantial damageNTSB MIA68D0544Accident · No injuriesClosedPiper PA-28 · Madison, ALJun 6, 1968 · N1748J · Substantial damageNTSB MIA68F0140Accident · No injuriesClosedPiper PA-28 · New Hope, ALAug 19, 1967 · N9882W · Substantial damageNTSB MIA67D0447Accident · No injuriesClosedPiper PA-28 · Monroeville, ALFeb 28, 1967 · N7531R · Substantial damageNTSB MIA67F0389Accident · No injuriesClosedPiper PA-28 · Andalusia, ALDec 16, 1966 · N6112W · Substantial damageNTSB MIA67D0127Accident · No injuriesClosedPiper PA-28 · Enterprise, ALJul 10, 1966 · N7042R · Substantial damageNTSB MIA66F0504Accident · No injuriesClosedPiper PA-28 · Birmingham, ALApr 16, 1966 · N6735W · Substantial damageNTSB MIA66D0494Accident · No injuriesClosedPiper PA-28 · Selma, ALApr 10, 1966 · N4585R · Substantial damageNTSB MIA66D0471Accident · No injuriesClosedPiper PA-28 · Birmingham, ALMar 10, 1966 · N6933W · Substantial damageNTSB MIA66D0195Accident · No injuriesClosedPiper PA-28 · Huntsville, ALAug 17, 1965 · N6666W · Substantial damageNTSB MIA65D0125Accident · No injuriesClosedPiper PA-28 · Huntsville, ALJun 6, 1965 · N6676W · Substantial damageNTSB UNK65X1284Accident · No injuriesClosedPiper PA-28 · Atmore, ALJan 13, 1965 · N6212W · Substantial damageNTSB UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALOct 25, 1964 · N6212W · Substantial damageNTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, ALOct 16, 1964 · N6021W · Substantial damage