Skip to content

NTSB investigations: Piper PA-22-135, WA

15 cases on aircraft the registry lists as Piper PA-22-135. 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 ('7102206')) 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 ('7102206'))
  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 ('7102206'))
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 WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.Apr 15, 2021 · N3023M · Substantial damage NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.Mar 12, 2021 · N1224C · Substantial damage NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.Jul 8, 2011 · N8721C · Substantial damage NTSB SEA91LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Mead, WAImproper preflight planning by the pilot, and the pilot's delay in aborting the takeoff. Factors related to the accident were: the high temperature and unfavorable wind condiiton.Aug 22, 1991 · N3781A · Destroyed NTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…Sep 9, 1988 · N2526A · Substantial damage NTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…Jun 12, 1988 · N1453A · Substantial damage NTSB SEA88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Yakima, WAThe pilot had just purchased the aircraft and was practicing takeoffs and landings. On the first landing attempt, during the ground roll after touchdwn, the pilot lost directional control and the aircraft ground looped.Feb 25, 1988 · N8919C · Substantial damage NTSB SEA76DYG41Accident · No injuriesClosedPiper PA-22 · Sunnyside, WAApr 10, 1976 · N1484C · Substantial damage NTSB SEA68F0217Accident · No injuriesClosedPiper PA-22 · Electric Cty, WADec 4, 1967 · N3446A · Substantial damage NTSB SEA67D0262Accident · No injuriesClosedPiper PA-22 · Cheney, WAFeb 26, 1967 · N3458A · Substantial damage NTSB SEA67D0242Accident · No injuriesClosedPiper PA-22 · Starbuck, WAFeb 11, 1967 · N3346A · Substantial damage NTSB SEA67D0097Accident · No injuriesClosedPiper PA-22 · Mead, WAAug 2, 1966 · N1315C · Substantial damage NTSB SEA66F0063Accident · No injuriesClosedPiper PA-22 · Underwood, WAJul 5, 1965 · N8130C · Substantial damage NTSB SEA66F0013Accident · Serious injuriesClosedPiper PA-22 · Sequim, WAJun 8, 1965 · N2755C · Substantial damage NTSB UNK64X4197Accident · Minor injuriesClosedPiper PA22 · Lynden, WASep 28, 1964 · N2334A · Substantial damage