NTSB investigations: Piper PA-28R-200, OR

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

19702026

NTSB investigations: Piper PA-28R-200, OR per year, 1970–2026: 11 cases
1970	1
1972	2
1973	1
1979	2
1982	1
1984	1
1990	1
1997	1
2018	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 ('7102811')) 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 ('7102811'))
  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 ('7102811'))
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 GAA18CA145Accident · No injuriesData collectionFinal reportPiper PA28R · Milton-Freewater, ORThe pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.Feb 28, 2018 · N323MQ · Substantial damage NTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…May 10, 1997 · N55676 · Destroyed NTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.Mar 2, 1990 · N2947R · Destroyed NTSB SEA84LA038Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Newport, ORThe acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…Jan 14, 1984 · N55624 · Substantial damage NTSB SEA82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Hillsboro, OROn touchdown the left main gear collapsed. No green down and locked light was observed prior to touchdown and the pilot made no attempt to go around, recycle the gear, OR other landing gear malfunction procedures. A retraction check after the accident showed…May 31, 1982 · N8584N · Substantial damage NTSB SEA79FYK14Accident · No injuriesClosedPiper PA-28R · Crescent Lake, ORJun 3, 1979 · N6998N · Substantial damage NTSB SEA79FYK09Accident · Minor injuriesClosedPiper PA-28R · Grants Pass, ORMay 8, 1979 · N9433N · Destroyed NTSB SEA73DYC35Accident · No injuriesClosedPiper PA-28R · Elgin, ORJun 16, 1973 · N9456N · Substantial damage NTSB SEA72AS036Accident · 2 fatalClosedPiper PA-28R · Pendleton, ORMar 3, 1972 · N9434N · Destroyed NTSB SEA72AS030Accident · 1 fatalClosedPiper PA-28R · Corvallis, ORFeb 4, 1972 · N2824R · Destroyed NTSB SEA71AS021Accident · 1 fatalClosedPiper PA-28R · Portland, OROct 9, 1970 · N5004S · Destroyed