NTSB investigations: Piper PA-22-160, 1986
6 cases on aircraft the registry lists as Piper PA-22-160. 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 | 36 |
|---|---|
| 1965 | 43 |
| 1966 | 29 |
| 1967 | 34 |
| 1968 | 20 |
| 1969 | 15 |
| 1970 | 19 |
| 1971 | 18 |
| 1972 | 13 |
| 1973 | 8 |
| 1974 | 12 |
| 1975 | 15 |
| 1976 | 13 |
| 1977 | 8 |
| 1978 | 10 |
| 1979 | 11 |
| 1980 | 4 |
| 1981 | 7 |
| 1982 | 8 |
| 1983 | 4 |
| 1984 | 4 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 10 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 6 |
| 2005 | 3 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 3 |
| 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102214'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102214'))
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 CHI87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mcgrath, MNAfter descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After…NTSB ANC87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Mcgrath, AKThe plt-in-command stated he was executing a shallow approach to runway 16 and prior to reaching the runway the engine stopped producing power. He further stated that during his descent he did not use any carburetor heat. The plt lost control of the airplane…NTSB LAX87LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Big Bear City, CAThe acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of…NTSB DEN87LA005Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fort Morgan, COThe student plt had just been endorsed for his first supervised solo flt. He had successfully completed one landing and was attempting his second landing when the accident occurred. The plt said he lost directional control, touched down, and over corrected.…NTSB FTW86LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Abbeville, LAThe pvt plt took off on a pleasure flt with 1 pax on board. Drg the initial climb, the eng lost power at about 300 ft AGL. The plt then turned downwind & subsequently made a forced landing in a sugar cane field adjacent to the arpt. Drg the landing, the acft…NTSB ATL86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Van Wert, OHThe plt reported that his airspeed was too high on ldg and that the acft brakes failed to function when he tried to stop the acft. The plt turned the acft off the rwy into a soft grassy area as the acft neared the rwy end. Another plt who witnessed the…