NTSB investigations: Piper PA-28-161, OR

11 cases on aircraft the registry lists as Piper PA-28-161. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Piper PA-28-161, OR per year, 1978–2026: 11 cases
1978	1
1980	1
1981	1
1982	3
1987	1
1995	1
1996	1
1997	1
2008	1

Where

Open the map

Latest cases

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
  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.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.Jul 7, 2008 · N2851Z · Substantial damage NTSB SEA97LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sun River, ORinadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…Jan 12, 1997 · N8414B · Substantial damage NTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.May 4, 1996 · N3568D · Substantial damage NTSB SEA95LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeview, ORthe pilot's failure to maintain clearance with terrain while his attention was directed to reading his map. The pilot's intentional low-altitude operation of the aircraft contributed to the accident.Jul 21, 1995 · N83125 · Substantial damage NTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…Dec 12, 1987 · N3275P · 2 aircraft · Substantial damage NTSB SEA82DA143Accident · No injuriesFinal reportPiper PA-28-161 · Redmond, ORThe student pilot was on a solo cross-country flight from hillsboro, OR to yakima, WA, to Redmond, OR and then return to hillsboro. The pilot reported a number of altitude and course deviations during the first two legs of the cross-country to avoid clouds.…Aug 15, 1982 · N38918 · Destroyed NTSB SEA82FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Portland, ORThe pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…Jul 18, 1982 · N2146Y · Destroyed NTSB SEA82FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Pleasant Hill, ORThe plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…Jan 5, 1982 · N8265A · Destroyed NTSB SEA81DYM38Accident · No injuriesClosedPiper PA-28 · Pacific City, ORSep 6, 1981 · N2482M · Substantial damage NTSB SEA80DYM46Accident · No injuriesClosedPiper PA-28 · Brooks, ORJul 13, 1980 · N2159C · Substantial damage NTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORSep 7, 1978 · N39499 · Destroyed