NTSB investigations: Piper PA-22-150, 1985
12 cases on aircraft the registry lists as Piper PA-22-150. 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 | 114 |
|---|---|
| 1965 | 108 |
| 1966 | 96 |
| 1967 | 78 |
| 1968 | 69 |
| 1969 | 55 |
| 1970 | 52 |
| 1971 | 47 |
| 1972 | 35 |
| 1973 | 32 |
| 1974 | 21 |
| 1975 | 27 |
| 1976 | 40 |
| 1977 | 33 |
| 1978 | 31 |
| 1979 | 28 |
| 1980 | 19 |
| 1981 | 17 |
| 1982 | 12 |
| 1983 | 20 |
| 1984 | 15 |
| 1985 | 12 |
| 1986 | 20 |
| 1987 | 14 |
| 1988 | 17 |
| 1989 | 18 |
| 1990 | 12 |
| 1991 | 18 |
| 1992 | 15 |
| 1993 | 8 |
| 1994 | 11 |
| 1995 | 7 |
| 1996 | 10 |
| 1997 | 10 |
| 1998 | 10 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 10 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 11 |
| 2006 | 7 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 7 |
| 2010 | 7 |
| 2011 | 6 |
| 2012 | 8 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 8 |
| 2018 | 4 |
| 2019 | 12 |
| 2020 | 7 |
| 2021 | 5 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 6 |
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 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 ('7102210'))
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 ('7102210'))
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 SEA85FA181Accident · 2 fatalField investigationFinal reportPiper PA-22 · Ketchum, IDStudent pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed…NTSB ANC85FA130Accident · No injuriesField investigationFinal reportPiper PA-22/20 · Alexander Lake, AKThe plt lost directional control of the acft during takeoff and the acft rolled into rough terrain along side of the rwy where it nosed over.NTSB ANC85LA110Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe plt reported that by the time he had returned to the arpt, the wind velocity had increased to 18 KTS. During the landing, he lost directional control & the acft ground looped & was damaged.NTSB DEN85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Glen Canyon, UTThe plt became lost/disoriented near the end of a x-country flt from west jordan to blanding, Utah. When fuel quantity became low, the plt decided to make a precautionary landing on a dirt road. During the landing falre, a x-wind gust drifted the acft to the…NTSB ANC85LA103Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe aircraft swervd on the runway and ground looped, the pilot stated he lost control of the acft due to the wind condition.NTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…NTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…NTSB MIA85FLD02Accident · No injuriesFinal reportPiper PA-22-150 · Fort Pierce, FLPrior to a flt from the Bahamas to west palm beach, FL, the plt noted a problem with the quick-drain for the left fuel tank. After landing in west palm beach, fuel was only added to the right tank since the plt anticipated replacing the left quick-drain. On…NTSB ANC85LA076Accident · No injuriesLimited investigationFinal reportPiper 22/20 · Girdwood, AKThe acft was on a flt to transport 2 skiers to a glacier area, so they could ski downhill to a location to where they could be picked up. The plt landed the wheel/ski equipped acft on upsloping terrain. The visibility was good, except a whiteout phenomena was…NTSB CHI85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rush City, MNThe plt reported that he was taking off on rwy 33 with the wind from 280 deg a 18 gusting 25 KTS. After becoming airborne, the acft weathervaned into the wind. It then traveled to the left of the rwy where it settled back to the ground. Subsequently, the acft…NTSB ANC85LA060Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kanektok River, AKThe plt reported after a short fld takeoff, the eng dropped to about 1000 RPM; the plt then attempted an emergency landing. Upon touchdown, the acft settled into the snow and nosed over. The plt stated the eng failure was due to carb ice.NTSB ATL85LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lawrenceville, GAStudent pilot bought acft previous day, asked instructor to fly acft with him to home airport. CFI delayed en route to practice touch and go. On go around engine would not produce full power and acft would not climb. During subsequent interview pic/cfi told…