NTSB investigations: Piper PA-22-150, 1994
11 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\") = 1994
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") = 1994
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 MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.NTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.NTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.NTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.