NTSB investigations: Piper PA-22-135, 1989
5 cases on aircraft the registry lists as Piper PA-22-135. 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 | 43 |
|---|---|
| 1965 | 34 |
| 1966 | 36 |
| 1967 | 45 |
| 1968 | 26 |
| 1969 | 18 |
| 1970 | 15 |
| 1971 | 19 |
| 1972 | 13 |
| 1973 | 10 |
| 1974 | 12 |
| 1975 | 13 |
| 1976 | 12 |
| 1977 | 12 |
| 1978 | 15 |
| 1979 | 7 |
| 1980 | 7 |
| 1981 | 6 |
| 1982 | 2 |
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 6 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 2 |
| 2015 | 3 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 2 |
| 2025 | 2 |
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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102206'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102206'))
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 NYC89LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Montague, NJImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.NTSB MIA89LA241Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Booneville, MSLoss of engine power for an unknown reason. Trees in the emergency landing area were a factor.NTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.NTSB ATL89FA144Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Augusta, GAFailure of the pilot to maintain adequate airspeed, while making a steep turn after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.NTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.