Skip to content

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

19 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

19692026

Where

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" = '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 ('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\" = '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 ('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" = '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 ('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 WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.Apr 4, 2025 · N9404N · Substantial damage NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.Nov 11, 2016 · N9466K · Substantial damage NTSB WPR12LA377Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Everett, WAA hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.Aug 28, 2012 · N4922T · Substantial damage NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.Dec 8, 2011 · N2611R · Substantial damage NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.Mar 17, 2010 · N1KU · Substantial damage NTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.Nov 10, 2001 · N9466K · Substantial damage NTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.Jan 19, 1992 · N2742R · Minor damage NTSB SEA88LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Elma, WADuring landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing…Mar 12, 1988 · N8374C · Substantial damage NTSB SEA86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Royal City, WAThe plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged.Jul 7, 1986 · N15270 · Substantial damage NTSB SEA81FYP39Accident · No injuriesClosedPiper PA-28R · Republic, WAOct 11, 1981 · N8906C · Substantial damage NTSB SEA77FYP43Accident · Serious injuriesClosedPiper PA-28R · Cle Elum, WASep 5, 1977 · N5303T · Substantial damage NTSB SEA77FA019Accident · 1 fatalClosedPiper PA-28R · Port Orchard, WAFeb 12, 1977 · N1529X · Substantial damage NTSB SEA75DYG08Accident · No injuriesClosedPiper PA-28R · Othello, WAAug 19, 1974 · N3079R · Substantial damage NTSB SEA74AS019Accident · 1 fatalClosedPiper PA-28R · Tenino, WAOct 13, 1973 · N9456N · Destroyed NTSB SEA74DYG04Accident · No injuriesClosedPiper PA-28R · Chelan, WAJul 18, 1973 · N55699 · Substantial damage NTSB SEA73DVE41Accident · No injuriesClosedPiper PA-28 · Port Townsnd, WAJun 30, 1973 · N55435 · Substantial damage NTSB SEA72AS026Accident · 3 fatalClosedPiper PA-28R · Paradise, WAJan 13, 1972 · N3025R · Destroyed NTSB SEA70F0075Accident · No injuriesClosedPiper PA-28 · Lester, WAAug 30, 1969 · N2839R · Substantial damage NTSB SEA69D0231Accident · No injuriesClosedPiper PA-28R · Friday Harbr, WAApr 26, 1969 · N9448N · Substantial damage