NTSB investigations: Piper PA-22-150, 1990
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
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\") = 1990
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") = 1990
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 ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB ANC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kodiak, AKThe pilot-in-command's failure to maintain directional control and failure to maintain airplane control on landing.NTSB LAX90LA291Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Weaverville, CAThe pilot's failure to maintain directional control of the aircraft. The existing wind conditions and the ditch that was located near the runway were factors in the accident.NTSB ANC90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gustavus, AKThe pilot's failure to maintain directional control during the landing roll.NTSB MIA90LA170Accident · 4 fatalLimited investigationFinal reportPiper PA-22-150 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane is missing.NTSB ANC90LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Caribou Creek, AKThe pilot's failure to adequately compensate for the existing wind conditions.NTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.NTSB MKC90LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Eldora, IAImproper planning/decision by the pilot, and his failure to maintain clearance from obstructions during the approach to land. Factors related to the accident were: the aircraft's low fuel level, darkness, the pilot's selection of the wrong airport/runway, the…NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.NTSB MKC90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ely, MNImproper planning/decision by the pilot. A factor related to the accident was: the strong/gusty crosswind condition.NTSB ANC90LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Bettles, AKFailure of the pilot to maintain sufficient altitude. Factors related to the accident were: the high density altitude, high wind, downdraft, and mountainous terrain.