NTSB investigations: Piper PA-20, 1985
10 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 per year
| 1964 | 25 |
|---|---|
| 1965 | 26 |
| 1966 | 23 |
| 1967 | 15 |
| 1968 | 16 |
| 1969 | 15 |
| 1970 | 14 |
| 1971 | 14 |
| 1972 | 11 |
| 1973 | 11 |
| 1974 | 9 |
| 1975 | 13 |
| 1976 | 6 |
| 1977 | 12 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 6 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 10 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 5 |
| 2000 | 5 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2025 | 2 |
| 2026 | 3 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 1985
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'))
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 year(c."eventDate") = 1985
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'))
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 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 ANC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Shageluk, AKThe acft contacted trees and descended to the terrain while on an apch to a lake. The plt reported the acft windscreen kept frosting up and he had to repeatedly wipe it clean. In the process of wiping the windscreen he approached the lake at a lower than…NTSB LAX86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calexico, CAThe acft ground looped during a landing on rwy 08 at Calexico arpt. The plt reported that upon touchdown the acft began to swerve to the right. The plt applied left rudder to arrest the right swerve. The acft then began a swerve to the left and the plt was…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 CHI85LA349Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Bay City, MIThe acft was damaged during a hard forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 250 ft AGL, the eng quit. Post accident inspection revealed the fuel selector was positioned on the right tank which…NTSB BFO85FA068Accident · 4 fatalField investigationFinal reportPiper PA-20-125 · Culpeper, VAWitnesses stated that the takeoff roll began about 2000 ft from the departure end of the 2300 ft sod rwy. The a/c lifted off from a 3-point attitude and climbed at a high angle of attack, 'mushing along' until it fell off on the rt wing and struck the ground…NTSB SEA85LA192Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAA ground loop occurred and the steering spring failed. The aircraft's steering spring had failed prior to the accident away from a repair station. The pilot made a temporary repair that failed during this ground loop. The pilot stated that a combination of a…NTSB CHI85LA319Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Madelia, MNDuring cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over.NTSB CHI85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Zionsville, INThe plt stated that she flared slightly high upon landing, causing the acft to bounce. Once the acft was on the ground again it began to drift to the left side of the rwy. To correct for this drift, the plt applied right rudder, however, she overcorrected…NTSB MKC85LA054Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wa Keeney, KSAcft touched down left of centerline. Left main gear contacted slush on the rwy and the acft swerved into a 2 to 3 ft snowbank alongside the rwy. Plt stated, 'the rwy was plenty clear and the accident would not have happened if the plane had been kept on the…