NTSB investigations: Piper PA-28-140, WA

67 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\" = 'WA' 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 SEA71FWG46Accident · Minor injuriesClosedPiper PA-28 · Creston, WAApr 14, 1971 · N6931W · Substantial damageNTSB SEA71DWG30Accident · No injuriesClosedPiper PA-28 · Royal City, WAOct 30, 1970 · N7178R · Substantial damageNTSB SEA71DWG13Accident · Minor injuriesClosedPiper PA-28 · Othello, WAAug 27, 1970 · N5806U · Substantial damageNTSB SEA71FWA13Accident · Minor injuriesClosedPiper PA-28 · Glenwood, WAAug 21, 1970 · N95052 · DestroyedNTSB SEA70F0137Accident · Serious injuriesClosedPiper PA-28 · Bremerton, WADec 15, 1969 · N98296 · Substantial damageNTSB SEA69F0040Accident · Serious injuriesClosedPiper PA-28 · Friday Harbr, WAJun 23, 1968 · N6308R · DestroyedNTSB SEA68F0324Accident · No injuriesClosedPiper PA-28 · Bellevue, WAMay 16, 1968 · N1861J · Substantial damageNTSB SEA68F0212Accident · No injuriesClosedPiper PA-24 · Ocean Shores, WANov 4, 1967 · N6116P · 2 aircraft · Substantial damageNTSB SEA68D0141Accident · No injuriesClosedPiper PA-28 · Yakima, WASep 28, 1967 · N4338J · Substantial damageNTSB SEA68F0079Accident · No injuriesClosedPiper PA-28 · Kelso, WAJul 19, 1967 · N6361W · Substantial damageNTSB SEA68F0030Accident · Minor injuriesClosedPiper PA-28 · Nortgat Mall, WAMay 12, 1967 · N4102J · Substantial damageNTSB SEA68F0027Accident · Serious injuriesClosedPiper PA-28 · Port Orchard, WAApr 5, 1967 · N4392J · Substantial damageNTSB SEA67D0291Accident · No injuriesClosedPiper PA-28 · Cashmere, WAApr 1, 1967 · N4551R · Substantial damageNTSB SEA67D0246Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WAFeb 4, 1967 · N6936W · Substantial damageNTSB SEA67F0244Accident · Minor injuriesClosedPiper PA-28 · Tacoma, WADec 17, 1966 · N4545R · 2 aircraft · Substantial damageNTSB SEA67D0212Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANov 9, 1966 · N6936W · Substantial damageNTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WAOct 25, 1964 · N6241W · Substantial damage