NTSB investigations: Piper PA-22-135, 1984
6 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\") = 1984
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") = 1984
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 ANC84LA155Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe acft ran off the rwy during landing. The plt said he lost control of the acft and went on the grass for about 40 ft. the rear seat had been removed for cargo. A 6 year old boy in the back of the acft was seated on top of rope and cans ofgas at the time of…NTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.NTSB NYC84LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Canton, PAThe pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…NTSB ANC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Big Delta, AKThe plt switched the tank selector while cruising in flt and the engine quit. He said he then primed the engine and tried to start it, but failed. A forced landing was made & the acft nosed over. After the accident, the acft was righted, the tank selector was…NTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.