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

16 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

19682026
Fatal NTSB investigations: Piper PA-28-140, OR per year, 1968–2026: 16 cases
19681
19692
19711
19722
19732
19771
19781
19821
20041
20061
20071
20151
20221

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\" = 'OR' 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 WPR22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Sisters, ORThe non-instrument-rated pilot’s flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s degraded judgement due to fatigue.Sep 22, 2022 · N7063R · DestroyedNTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.Apr 22, 2015 · N1729J · DestroyedNTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.Sep 13, 2007 · N6735J · Substantial damageNTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.Dec 12, 2006 · N5618U · Substantial damageNTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.Oct 15, 2004 · N454FL · DestroyedNTSB SEA82FYM22Accident · 3 fatalFinal reportPiper 24-140 · Enterprise, ORWitnesses observed an aircraft fly over the city of Enterprise, Oregon on a bright night with clear sky conditions. Reportedly, the aircraft was flying very erratic; and just as it disappeared from the witnesses' sight, an explosion andfireball were observed…Jul 25, 1982 · N55492 · DestroyedNTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORSep 14, 1978 · N5877U · DestroyedNTSB SEA78FA007Accident · 1 fatalClosedPiper PA-28 · Gales Creek, ORNov 4, 1977 · N2710Q · DestroyedNTSB SEA74AS012Accident · 3 fatalClosedPiper PA-28 · Oakridge, ORSep 3, 1973 · N4576T · DestroyedNTSB SEA74AS011Accident · 2 fatalClosedPiper PA-28 · Oakridge, ORAug 21, 1973 · N6344W · DestroyedNTSB SEA73AS015Accident · 3 fatalClosedPiper PA-28 · Bend, ORNov 26, 1972 · N4447J · Substantial damageNTSB SEA73AS002Accident · 1 fatalClosedPiper PA-28 · Klamath Fall, ORJul 21, 1972 · N7165R · DestroyedNTSB SEA71AS035Accident · 3 fatalClosedPiper PA-28 · Oakridge, ORJan 22, 1971 · N8373R · DestroyedNTSB SEA70A0005Accident · 1 fatalClosedPiper PA-28 · Astoria, ORJul 27, 1969 · N9751W · DestroyedNTSB SEA69A0058Accident · 3 fatalClosedPiper PA-28 · Mcknzie Brdg, ORMay 30, 1969 · N7133R · DestroyedNTSB SEA69A0034Accident · 3 fatalClosedPiper PA-28 · Vernonia, ORDec 8, 1968 · N6382R · Destroyed