NTSB investigations: Piper PA-28-140, MA

100 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\" = 'MA' 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 NYC73FNA09Accident · Serious injuriesClosedPiper PA-28 · Haverhill, MAAug 2, 1972 · N5813U · DestroyedNTSB NYC73FNE02Accident · Minor injuriesClosedPiper PA-28 · Fitchburg, MAJul 2, 1972 · N601FL · Substantial damageNTSB NYC72FNA39Accident · No injuriesClosedPiper PA-28 · Brockton, MAApr 24, 1972 · N5396S · Substantial damageNTSB NYC72DNE33Accident · No injuriesClosedPiper PA-28 · Westboro, MAApr 1, 1972 · N696FL · Substantial damageNTSB NYC72FNA18Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 10, 1971 · N5339S · Substantial damageNTSB NYC72FNA01Accident · No injuriesClosedPiper PA-28 · Norwood, MAJul 6, 1971 · N5396S · Substantial damageNTSB NYC71FNA56Accident · No injuriesClosedPiper PA-28 · Norwood, MAJun 16, 1971 · N1760J · Substantial damageNTSB NYC71DFD33Accident · No injuriesClosedPiper PA-28 · Mansfield, MAJan 20, 1971 · N5787U · Substantial damageNTSB NYC71DFD30Accident · No injuriesClosedPiper PA-28 · Plymouth, MAJan 6, 1971 · N7249F · Substantial damageNTSB NYC71DFD27Accident · Minor injuriesClosedPiper PA-28 · Beverly, MADec 29, 1970 · N6720J · Substantial damageNTSB UNK71X0101Accident · No injuriesClosedPiper PA-28 · Taunton, MANov 8, 1970 · N7285F · Substantial damageNTSB NYC71FFD17Accident · No injuriesClosedPiper PA-28 · Norwood, MAOct 25, 1970 · N5884U · Substantial damageNTSB NYC71DFM09Accident · No injuriesClosedPiper PA-28 · Northampton, MAAug 13, 1970 · N8840N · Substantial damageNTSB NYC71DFD04Accident · No injuriesClosedPiper PA-28 · New Bedford, MAAug 3, 1970 · N98299 · Substantial damageNTSB NYC71AN010Accident · 2 fatalClosedPiper PA-28 · Provincetown, MAJul 20, 1970 · N6245W · DestroyedNTSB NYC70FFD08Accident · Minor injuriesClosedPiper PA-28 · Bedford, MAFeb 5, 1970 · N8790N · Substantial damageNTSB NYC70DFD06Accident · No injuriesClosedPiper PA-28 · Beverly, MAJan 24, 1970 · N6720J · Substantial damageNTSB NYC70FFD04Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 20, 1970 · N98044 · Substantial damageNTSB NYC70DIF03Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 5, 1970 · N98001 · Substantial damageNTSB NYC70A0052Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 18, 1969 · N5566F · 2 aircraft · Substantial damageNTSB NYC70A0043Accident · 1 fatalClosedPiper PA-28 · So.Weymouth, MAOct 13, 1969 · N6423W · DestroyedNTSB NYC70D0196Accident · No injuriesClosedPiper PA-28 · Beverly, MASep 29, 1969 · N9901W · Substantial damageNTSB NYC70D0202Accident · No injuriesClosedPiper PA-28 · Fitchburg, MASep 21, 1969 · N292HA · 2 aircraft · Substantial damageNTSB NYC70A0032Accident · 1 fatalClosedPiper PA-28 · Sandisfield, MASep 7, 1969 · N1735J · DestroyedNTSB NYC70A0002Accident · 1 fatalClosedPiper PA-28 · Falmouth, MAJul 1, 1969 · N6780J · DestroyedNTSB NYC69F0341Accident · No injuriesClosedPiper PA-28 · Norwood, MAMar 12, 1969 · N1760J · Substantial damageNTSB NYC69D0290Accident · No injuriesClosedPiper PA-28 · Tewksbury, MAJan 12, 1969 · N4615R · Substantial damageNTSB NYC69D0255Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 15, 1968 · N1660J · Substantial damageNTSB NYC69D0057Accident · No injuriesClosedPiper PA-28 · Pembroke, MAJul 29, 1968 · N4150J · Substantial damageNTSB NYC68F0345Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 20, 1968 · N6423W · Substantial damageNTSB NYC68D0353Accident · No injuriesClosedPiper PA-28 · Fitchburg, MAJan 6, 1968 · N292HA · Substantial damageNTSB NYC68F0309Accident · Minor injuriesClosedPiper PA-28 · Danvers, MADec 9, 1967 · N4459J · Substantial damageNTSB NYC68D0287Accident · No injuriesClosedPiper PA-28 · Chesterfield, MANov 26, 1967 · N3946K · Substantial damageNTSB NYC68D0189Accident · No injuriesClosedPiper PA-28 · Hopedale, MAOct 5, 1967 · N6829W · Substantial damageNTSB NYC68D0181Accident · No injuriesClosedPiper PA-28 · Beverly, MASep 8, 1967 · N4485J · Substantial damageNTSB NYC68F0058Accident · No injuriesClosedPiper PA-28 · Norwood, MAJul 20, 1967 · N4150J · Substantial damageNTSB NYC67F0668Accident · No injuriesClosedPiper PA-28 · Norwood, MAMay 11, 1967 · N4540R · Substantial damageNTSB NYC67F0656Accident · Minor injuriesClosedPiper PA-28 · Norwood, MAApr 26, 1967 · N6758W · DestroyedNTSB NYC67F0631Accident · No injuriesClosedPiper PA-28 · Norwood, MAApr 1, 1967 · N4150J · Substantial damageNTSB NYC67D0621Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 18, 1967 · N6098W · Substantial damageNTSB NYC67D0479Accident · No injuriesClosedPiper PA-28 · Norwood, MAFeb 9, 1967 · N6758W · Substantial damageNTSB NYC67D0427Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 6, 1967 · N6782W · Substantial damageNTSB NYC67D0259Accident · No injuriesClosedPiper PA-28 · Barre, MASep 5, 1966 · N4697R · Substantial damageNTSB NYC66F0553Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 3, 1966 · N6098W · Substantial damageNTSB NYC66F0552Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 3, 1966 · N6526W · Substantial damageNTSB NYC66F0389Accident · Minor injuriesClosedPiper PA-28 · Worcester, MADec 7, 1965 · N6596W · Substantial damageNTSB NYC66F0327Accident · No injuriesClosedPiper PA-28 · Brookfield, MANov 3, 1965 · N6235W · Substantial damageNTSB NYC66F0220Accident · No injuriesClosedPiper PA-28 · Gr Barringtn, MASep 3, 1965 · N6586W · Substantial damageNTSB NYC66F0100Accident · No injuriesClosedPiper PA-28 · Taunton, MAJul 23, 1965 · N6510W · Substantial damageNTSB UNK64X4163Accident · No injuriesClosedPiper PA28 · Norwood, MASep 26, 1964 · N6235W · Substantial damage