NTSB investigations: Piper PA-20, AK
15 cases on aircraft the registry lists as Piper PA-20, where the first occurrence was “Loss of control - on ground/water”. 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 per year
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest cases
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.\"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 ('7102002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('7102002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.NTSB ANC05CA091Accident · No injuriesData collectionFinal reportPiper PA-20 · Nome, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in the collapse of the main landing gear, and a nose over. A factor associated with the accident was a crosswind.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 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 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 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 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 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 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 ANC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKAircraft lost control during landing and crashed into another private aircraft. Witness reported seeing aircraft make a fast appraoch, land long, ground loop and slide side ways into parked Aeronca. Witness stated that aircraft landed with a tailwind,while…NTSB ANC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Feather River, AKWhile landing in gusty surface wind conditions the pilot lost control of he airplane and turned over.NTSB ANC83FAA01Accident · No injuriesFinal reportPiper PA-20-A · Phillips Field, AKThe pilot reported that during a landing, the aircraft bounced a little. Reportedly, he recovered from the bounce, then the plane started to veer off the runway toward parked aircraft. While corecting with brakes, the aircraft nosed over.