Skip to content

NTSB investigations: Piper PA-22-150, WA

29 cases on aircraft the registry lists as Piper PA-22-150. 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 ('7102210')) 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 ('7102210'))
  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 ('7102210'))
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 WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.May 8, 2023 · N6058D · Substantial damage NTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.May 31, 2021 · N7159B · Substantial damage NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.Jan 9, 2011 · N5850D · Substantial damage NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.Aug 21, 2009 · N6038D · Substantial damage NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.Dec 22, 2006 · N7124D · Substantial damage NTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.Aug 24, 2006 · N8042D · Substantial damage NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.Sep 1, 2005 · N1829P · Substantial damage NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.May 13, 2004 · N1829P · Substantial damage NTSB SEA95LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Rice, WAThe pilot's failure to maintain the proper climb rate. A factor was trees in the flight path.Apr 29, 1995 · N2520P · Substantial damage NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.Mar 5, 1995 · N4778A · Substantial damage NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.Aug 31, 1994 · N1329C · Substantial damage NTSB SEA89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Black Diamond, WAPower loss due to magneto failure. Contributing to the accident were lack of suitable terrain for forced landing and the presence of obstacles.May 28, 1989 · N6121D · Substantial damage NTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…Jan 24, 1988 · N3316Z · Substantial damage NTSB SEA84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Davenport, WADuring the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured.Apr 25, 1984 · N6002D · Substantial damage NTSB SEA81FYP01Accident · Serious injuriesClosedPiper PA-22 · Waterville, WAOct 6, 1980 · N7710D · Substantial damage NTSB SEA80DYE38Accident · Minor injuriesClosedPiper PA-22 · Silverdale, WAJun 30, 1980 · N4558A · Substantial damage NTSB SEA78DYM17Accident · No injuriesClosedPiper PA-22 · Wallowa, WAJan 22, 1978 · N7244D · Substantial damage NTSB SEA75AS009Accident · 2 fatalClosedPiper PA-22 · Kent, WAAug 17, 1974 · N6199D · Destroyed NTSB SEA73DYG07Accident · No injuriesClosedPiper PA-22 · Ellisford, WAJul 27, 1972 · N2618P · Substantial damage NTSB SEA71DWG41Accident · No injuriesClosedPiper PA-22 · Dishman, WAMar 30, 1971 · N2709P · Substantial damage NTSB SEA70D0024Accident · No injuriesClosedPiper PA-22 · Bellevue, WAJun 29, 1969 · N2827Z · Substantial damage NTSB SEA68A0064Accident · 4 fatalClosedPiper PA-22 · Brush Prarie, WAApr 28, 1968 · N1738P · Destroyed NTSB SEA68D0249Accident · Minor injuriesClosedPiper PA-22 · Ritzville, WAJan 20, 1968 · N7230D · Substantial damage NTSB SEA67D0117Accident · No injuriesClosedPiper PA-22 · Vancouver, WAJul 4, 1966 · N4507A · Substantial damage NTSB SEA66F0071Accident · No injuriesClosedPiper PA-22 · Spokane, WAAug 5, 1965 · N6121D · Substantial damage NTSB SEA65A0066Accident · 1 fatalClosedPiper PA-22 · Carson, WAJun 7, 1965 · N2459P · Destroyed NTSB SEA65F0032Accident · No injuriesClosedPiper PA-22 · Othello, WAMar 31, 1965 · N5990D · Substantial damage NTSB SEA65F0022Accident · No injuriesClosedPiper PA-22 · Pullman, WAMar 11, 1965 · N3648P · Substantial damage NTSB UNK64X1046Accident · 1 fatalClosedPiper PA-22 · Cle Elum, WAMar 26, 1964 · N7117D · Destroyed