Skip to content

NTSB investigations: Piper PA-20, WA

19 cases on aircraft the registry lists as Piper PA-20. 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

19642026

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 ('7102002')) 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 ('7102002'))
  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 ('7102002'))
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 GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.Jun 17, 2018 · N11YB · Substantial damage NTSB SEA04LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · North Bend, WAThe pilot's failure to maintain aircraft control during the landing roll. A rough landing surface and tailwind gusts were factors.Apr 29, 2004 · N7631K · Substantial damage NTSB SEA00LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quinault, WAFuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…Jun 4, 2000 · N7737K · Substantial damage NTSB SEA98LA067Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Arlington, WAThe pilot's failure to maintain directional control during the landing roll, and his delayed remedial action when the aircraft started to drift off the side of the runway.Apr 26, 1998 · N7458K · Substantial damage NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.Jun 1, 1996 · N1645A · Substantial damage NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.Jul 15, 1994 · N1540A · Substantial damage NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.Jul 21, 1991 · N7066K · Destroyed NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.Jul 13, 1991 · N7458K · Substantial damage NTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…Aug 28, 1987 · N6901K · Destroyed NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.May 10, 1987 · N7732K · Substantial damage NTSB SEA85LA192Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAA ground loop occurred and the steering spring failed. The aircraft's steering spring had failed prior to the accident away from a repair station. The pilot made a temporary repair that failed during this ground loop. The pilot stated that a combination of a…Aug 9, 1985 · N7765K · Substantial damage NTSB SEA83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, WAThe acft groundlooped after the main landing gear collapsed during landing. Investigation revealed that the main landinggear tubing failed after being weakened by corrosion inside the tube.Aug 27, 1983 · N7650K · Substantial damage NTSB SEA77DYE26Accident · No injuriesClosedPiper PA-20 · Seattle, WAJun 24, 1977 · N6895K · Substantial damage NTSB SEA74AS017Accident · 2 fatalClosedPiper PA-20 · Oakesdale, WASep 18, 1973 · N7666K · Destroyed NTSB SEA69D0234Accident · No injuriesClosedPiper PA-20 · Wilbur, WAApr 3, 1969 · N7666K · Substantial damage NTSB SEA69D0227Accident · No injuriesClosedPiper PA-20 · Chehalis, WAMar 30, 1969 · N7028K · Substantial damage NTSB SEA68F0008Accident · No injuriesClosedPiper PA-20A · Newport, WAJun 9, 1967 · N2338A · Substantial damage NTSB SEA65F0065Accident · No injuriesClosedPiper PA-20 · Othello, WAMay 25, 1965 · N7092K · Substantial damage NTSB UNK65X0181Accident · No injuriesClosedPiper PA20 · Yakima, WAOct 7, 1964 · N7754K · Substantial damage