Skip to content

NTSB investigations: Piper PA-22, AK

22 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" = 'AK' 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\" = 'AK' 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" = 'AK' 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 ANC24LA004Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22 · Anchorage, AKThe loss of engine power during final approach due to fuel exhaustion, which resulted from the pilot’s inadequate preflight.Nov 13, 2023 · N8095C · Substantial damage NTSB ANC23LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Talkeetna, AKThe pilot’s encounter with a downdraft while maneuvering low-level, which resulted in a collision with terrain.Jul 2, 2023 · N3321B · Substantial damage NTSB ANC15LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA 22 · Skwentna, AKThe pilot's failure to follow the airplane's operating limitations by rapidly opening the throttle, which resulted in a loss of engine power. Contributing to the accident was the pilot's decision to maneuver the airplane at low altitude even though he was not…Jun 1, 2015 · N2828P · Substantial damage NTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.Jul 28, 2014 · N8883C · Substantial damage NTSB ANC09CA105Accident · No injuriesData collectionFinal reportPiper PA-22 · Seward, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control and a nose over during the takeoff roll.Sep 21, 2009 · N2601P · Substantial damage NTSB ANC03CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Palmer, AKThe premature liftoff by the pilot during takeoff, which resulted in on ground encounter with terrain when the airplane settled onto rocks. A contributing factor in the accident was an unfavorable wind.Oct 29, 2002 · N878A · Destroyed NTSB ANC99LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe inadequate preflight by the pilot, who left the rudder gust lock installed, making directional control not possible.May 16, 1999 · N8883C · Substantial damage NTSB ANC93LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Seward, AKThe pilots failure to maintain directional control on the ground. Contributing to the accident was the pilots failure to maintain airspeed during the takeoff climb, his inadequate training, his lack of total experience, and the ditch.Oct 17, 1992 · N1660A · Substantial damage NTSB ANC90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Igiugig, AKThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was unsuitable terrain selected by the pilot for landing.Aug 17, 1990 · N3455A · Substantial damage NTSB ANC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Moller, AKThe pilot failed to maintain directional control during landing. Contributing to the accident were the unfavorable winds, the soft runway surface, and the pilot's lack of training and total experience.Jul 15, 1990 · N1765A · Substantial damage NTSB ANC89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKA crack on the left side of the engine crankcase which resulted in a loss of lubricating oil and which forced the pilot to land on a gravel bar which resulted in a nose over during landing.May 29, 1989 · N2828P · Substantial damage NTSB ANC88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKWitnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The…Jul 12, 1988 · N2747P · 2 aircraft · Substantial damage NTSB ANC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cordova, AKThe plt stated as he approached Cordova he smelled & observed smoke in the cockpit. He reduced power & commenced a modified approach to rwy 9 which was nearest his position. When he elected to add power the engine did not respond. The plt turned & landed on a…Nov 22, 1982 · N1461A · Substantial damage NTSB ANC82DA060Accident · No injuriesFinal reportPiper PA-22 · 65 Mi.Ene Of Mc, AKDuring flight, the pilot noticed a progressive loss of power. He elected to make an emergency landing on a gravel bar. During the landing, the aircraft rolled through a shallow slough where the left main gear hit a log. The nose gear then hit a bank at the…Jul 17, 1982 · N891A · Substantial damage NTSB ANC80DAG73Accident · No injuriesClosedPiper PA-22 · Mcgrath, AKJul 9, 1980 · N3506Z · Substantial damage NTSB ANC78FA066Accident · 2 fatalClosedPiper PA-22 · Chandalar Lake, AKAug 9, 1978 · N7615K · Substantial damage NTSB ANC76DAH42Accident · No injuriesClosedPiper PA-22 · Dillingham, AKJul 18, 1976 · N8883C · Substantial damage NTSB ANC71DAA06Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKAug 22, 1970 · N677A · Substantial damage NTSB ANC70FAA05Accident · Minor injuriesClosedPiper PA-22 · College Br, AKMar 22, 1970 · N3506Z · Substantial damage NTSB ANC67D0034Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKSep 19, 1966 · N3506Z · Substantial damage NTSB ANC66F0108Accident · Serious injuriesClosedPiper PA-22 · Palmer, AKMay 28, 1966 · N5838D · Destroyed NTSB UNK64X0382Accident · No injuriesClosedPiper PA22 · Aleknacik, AKJan 27, 1964 · N3319A · Substantial damage