NTSB investigations: Piper PA-22-150, 1998
10 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\") = 1998
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") = 1998
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 CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.NTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB ANC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Copper Center, AKThe pilot's selection of an unsuitable off-airport landing site. A factor associated with the accident is rough and uneven terrain.NTSB ANC98LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKThe pilot's selection of unsuitable runway terrain for takeoff, and his failure to maintain directional control of the airplane. Factors in the accident were uneven/rutted terrain, and high vegetation along the runway edge.NTSB FTW98LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Searcy, ARThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the certified flight instructor's inadequate supervision.NTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.