Skip to content

NTSB investigations: Piper PA-22, OR

23 cases on aircraft the registry lists as Piper PA-22. 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" = '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 ('7102202')) 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 ('7102202'))
  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 ('7102202'))
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 WPR25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Madras, ORThe pilot’s loss of control during landing roll with gusty winds.Mar 26, 2025 · N1418C · Substantial damage NTSB GAA17CA363Accident · No injuriesData collectionFinal reportPiper PA 22 · Pendleton, ORThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jun 24, 2017 · N2473P · Substantial damage NTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.May 4, 2007 · N1394C · Substantial damage NTSB SEA99LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cottage Grove, ORThe pilot's inadequate management of fuel which led to fuel starvation.. A related factor was the unsuitable terrain.Jul 7, 1999 · N4707C · Substantial damage NTSB SEA98LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Aurora, ORDirectional control was not maintained by the pilot in command. Factors include rough terrain and hidden obstructions.Jul 7, 1998 · N2646A · Substantial damage NTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.Nov 15, 1995 · N932A · Substantial damage NTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.Apr 2, 1995 · N8276C · Substantial damage NTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.Sep 29, 1992 · N8274C · Substantial damage NTSB SEA90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boring, ORCarburetor icing, and the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing conditions and the soft/uneven terrain in the emergency landing area.Feb 4, 1990 · N8898C · Substantial damage NTSB SEA79DYM13Accident · No injuriesClosedPiper PA-22 · Dufur, ORJan 28, 1979 · N8276C · Substantial damage NTSB SEA73FYA26Accident · Serious injuriesClosedPiper PA-22 · Nyssa, ORMay 18, 1973 · N2316P · Substantial damage NTSB SEA73FYC26Accident · Serious injuriesClosedPiper PA-22 · Oregon City, ORApr 18, 1973 · N8155D · Substantial damage NTSB SEA73AS017Accident · 2 fatalClosedPiper PA-22 · Portland, ORDec 31, 1972 · N2730P · Destroyed NTSB SEA72AS051Accident · 3 fatalClosedPiper PA-22 · Sunriver, ORMay 29, 1972 · N4411A · Destroyed NTSB SEA72AS040Accident · 4 fatalClosedPiper PA-22 · Ashland, ORMar 24, 1972 · N8917C · Destroyed NTSB SEA71AS045Accident · 1 fatalClosedPiper PA-22 · Springfield, ORMay 23, 1971 · N2129A · Destroyed NTSB SEA70A0020Accident · 2 fatalClosedPiper PA-22 · Scappoose, ORNov 14, 1969 · N1460A · Destroyed NTSB SEA68F0299Accident · No injuriesClosedPiper PA-22 · Hood River, ORApr 17, 1968 · N610A · Substantial damage NTSB SEA67F0297Accident · No injuriesClosedPiper PA-22 · Albany, ORMar 21, 1967 · N679A · Substantial damage NTSB SEA67D0279Accident · No injuriesClosedPiper PA-22 · Silver Lake, ORFeb 21, 1967 · N8276C · Substantial damage NTSB SEA67D0196Accident · No injuriesClosedPiper PA-22 · Mulino, OROct 22, 1966 · N623A · Substantial damage NTSB SEA65F0012Accident · No injuriesClosedPiper PA-22 · Lake Oswego, ORFeb 13, 1965 · N1744A · Substantial damage NTSB UNK64X1324Accident · No injuriesClosedPiper PA22 · Crescent, ORApr 15, 1964 · N934A · Substantial damage