NTSB investigations: Piper PA-20
359 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 ANC04LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Bethel, AKThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent forced landing. Factors associated with the accident were weather conditions conducive to carburetor icing, and the lack of suitable terrain for a…NTSB LAX04CA026Accident · No injuriesData collectionFinal reportPiper PA-20 · Petaluma, CAthe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control that resulted in a ground loop.NTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.NTSB ANC03LA079Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane's collision with a ditch, and the collapse of the main landing gear.NTSB ANC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Palmer, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in an inadvertent ground loop and collapse of the left main landing gear.NTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB CHI02FA200Accident · No injuriesField investigationFinal reportPiper PA-20 · Oshkosh, WIInadequate visual lookout by both the accident pilot and the pilot of the other airplane. An additional cause is the arrival procedure used which resulted in a congested traffic pattern and the subsequent inadequate visual separation of the airplanes. Factors…NTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB SEA01LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hood River, ORThe pilot's failure to maintain directional control during landing.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB LAX00LA224Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quincy, CAThe fracture and failure of the main landing gear strut to shock absorber attachment fitting.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…NTSB LAX98LA266Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Rio Vista, CAFailure of the pilot to adequately compensate for the existing wind condition and maintain directional control on rollout.NTSB CHI98LA294Accident · Minor injuriesLimited investigationFinal reportPiper 20 · Andover, KSa loss of engine power for undetermined reasons. A factor associated with the accident were the trees which the airplane contacted and the low altitude at which the loss of power occurred.NTSB ANC98LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Soldotna, AKThe pilot's inadvertent stall of the airplane.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.NTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…NTSB ANC98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of engine power due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.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.NTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB SEA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ogden, UTThe pilot-in-command's failure to maintain directional control. Hte loose tailwheel assembly bolt was a factor.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB ANC95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Koliganek, AKThe student pilot's inadequate compensation for the wind conditions. A factor in the accident is a crosswind.NTSB CHI94LA337Accident · 1 fatalLimited investigationFinal reportPiper PA-20 · Greenville, MIIncapacitation of the pilot due to a seizure and/or loss of consciousness. A factor related to the accident was: the pilot's failure to properly report his medical information on his FAA medical application.NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.NTSB ANC93LA117Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control during taxi. Factor is the rough/rutted condition of the airstrip.NTSB MIA93LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fort Walton Bch, FLThe pilot-in-command's failure to visually inspect the grapple hook/cable after deployment, to ensure it was free from all control surfaces prior to initiating a banner pickup.NTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.NTSB LAX92FA351Accident · 2 fatalField investigationFinal reportPiper PA-20-135 · Fort Bidwell, CAAn inadvertent stall while maneuvering. Contributing to the accident was pilot's diverted attention.NTSB ANC92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's improper preflight planning/decision, and his delayed aborted takeoff. Contributing was the pilot's failure to use the airplane performance data.NTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.NTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.NTSB MIA92LA038Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hilliard, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the low ceiling encountered and reduced in-flight planning decision time by the pilot-in-command.NTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.NTSB ANC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of control during the takeoff sequence caused by the failure of the tail wheel steering spring. Factors contributing to the accident were the gusty wind conditions and soft terrain.NTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.NTSB ANC91DAG01Accident · No injuriesFinal reportPiper PA-20 · Anchorage, AKThe student pilot's failure to maintain aircraft control.NTSB ANC91LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · King Salmon, AKInadvertant stall during an aborted landing.NTSB ANC89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chitina, AKThe pilot's selection of an unsuitable landing area and delay in slowing the airplane after landing. A factor in the accident was the rough/uneven terrain.NTSB ANC89LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKLoss of engine power for an unknown reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.NTSB ANC89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Sheshalik, AKPilot-in-command's failure to perform an adequate preflight inspection of the airplane's brakes.