Fatal NTSB investigations: Piper PA-28-140, MA

8 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 per year

19692026
Fatal NTSB investigations: Piper PA-28-140, MA per year, 1969–2026: 8 cases
19693
19701
19841
19861
19962

Latest cases

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.\"highestInjuryLevel\" = 'Fatal'
    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 IAD97LA034Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Beverly, MAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.Dec 21, 1996 · N7246F · Substantial damageNTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…Jan 18, 1996 · N5934U · DestroyedNTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…Oct 3, 1986 · N38688 · DestroyedNTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…Nov 2, 1984 · N9930W · DestroyedNTSB NYC71AN010Accident · 2 fatalClosedPiper PA-28 · Provincetown, MAJul 20, 1970 · N6245W · DestroyedNTSB NYC70A0043Accident · 1 fatalClosedPiper PA-28 · So.Weymouth, MAOct 13, 1969 · N6423W · DestroyedNTSB NYC70A0032Accident · 1 fatalClosedPiper PA-28 · Sandisfield, MASep 7, 1969 · N1735J · DestroyedNTSB NYC70A0002Accident · 1 fatalClosedPiper PA-28 · Falmouth, MAJul 1, 1969 · N6780J · Destroyed