NTSB investigations: Piper PA-20, 1982
6 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\") = 1982
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") = 1982
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 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.NTSB ANC82DAG53Accident · 2 fatalFinal reportPiper PA-20 · Kenai, AKAt 0837 the plt called Kenai tower & reported 8 mi west inbound for landing. At 0845 he reported that he would be landing on the beach. At 0847 he reported that he would not make the beach & would be going into the water. The acft & occupants were not…NTSB ANC82DA093Accident · No injuriesFinal reportPiper PA-20 · Near Mcgrath, AKPrior to departure, the pilot serviced the aircraft with fuel and verified the right wing tank was full. The pilot did not switch the fuel selector from the left fuel tank prior to departing. During a low pass over a wooded area, the engine quit. Due to the…NTSB ANC82DAG43Accident · No injuriesFinal reportPiper PA-20 · Eagle River, AKThe eng lost power about 750 ft after a water takeoff. There was insufficient landing room on the lake & the acft hit a dike. The pilot stated he fuels the acft from 5 gallon cans due to nonavaiability of aviation fuel at fire lake. Approximately 2 cups of…NTSB MKC82DA139Accident · No injuriesFinal reportPiper PA-20 · Scottsbluff, NEDuring takeoff, the pilot raised the tail at about 50 mph and the aircraft veered to the left. Despite the pilot's countermeasures, it departed the left side of the runway. The right gear then collapsed and the right wing and propeller were damaged. An…NTSB NYC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, CTThe pilot began taking off on runway 19 with a right crosswind. Reportedly, a strong gust of wind was encountered and the aircraft veered off the left side of the runway. It headed toward the opening of a culvert that went under the runway. To avoid the…