NTSB investigations: Piper PA-25-235, 1991
11 cases on aircraft the registry lists as Piper PA-25-235. 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 | 36 |
|---|---|
| 1965 | 53 |
| 1966 | 45 |
| 1967 | 75 |
| 1968 | 77 |
| 1969 | 65 |
| 1970 | 75 |
| 1971 | 91 |
| 1972 | 60 |
| 1973 | 60 |
| 1974 | 83 |
| 1975 | 58 |
| 1976 | 49 |
| 1977 | 51 |
| 1978 | 44 |
| 1979 | 48 |
| 1980 | 35 |
| 1981 | 36 |
| 1982 | 22 |
| 1983 | 24 |
| 1984 | 13 |
| 1985 | 16 |
| 1986 | 16 |
| 1987 | 14 |
| 1988 | 15 |
| 1989 | 11 |
| 1990 | 11 |
| 1991 | 11 |
| 1992 | 11 |
| 1993 | 8 |
| 1994 | 9 |
| 1995 | 11 |
| 1996 | 10 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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\") = 1991
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504'))
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") = 1991
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504'))
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 ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB ATL91LA168Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe pilot's failure to maintain adequate clearance from objects while practicing aerial application procedures.NTSB ATL91LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Roxobel, NCThe failure of the left magneto stop pin, resulting in the seizure of the magneto and the failure of the magneto drive gear, and ultimately engine stoppage. A factor in this accident was: the presence of trees at the forced landing area.NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB CHI91DER11Accident · No injuriesFinal reportPiper OA25-235 · Clinton, MNThe pilot's failure to maintain adequate control of the aircraft while maneuvering in aerial application operations. Related factors are wake turbulence and low altitude.NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.NTSB BFO91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Chesapeake, VAThe pilot's failue to maintain adequate airspeed after the loss of engine power for undetermined reasons.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.