NTSB investigations: Piper PA-25-235, 1988
15 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\") = 1988
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") = 1988
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 FTW89DQG02Accident · 1 fatalFinal reportPiper PA-25 · Amarillo, TXFailure on the part of the pilot to maintain the proper airspeed for the maneuver being performed, followed by a stall at an altitude insufficient to recover.NTSB BFO88LA084Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Princess Anne, MDThe pilot reported that he had sprayed aprx 1/2 of the soybean field when smoke started to fill the cockpit. He shut off the spray, turned off the electrical system and opened the fresh air vents. He then looked back at the tail section of the airplane and…NTSB DEN88LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lund, UTThe private plt was spraying crops during an aerial application flight. During a right turn at the end of a spray run, he said he diverted his attention into the cockpit to check the metering rate, and may have inadvertently pushed the control stick forward.…NTSB BFO88DID04Accident · 1 fatalFinal reportPiper PA-25-250 · Waverly, VAThe acft contacted pwr lines, crashed and burned during an aerial appliation flt. Witnesses reported that it looked as if the plt descended to fly under the lines when it suddenly pulled up and contacted them.NTSB ATL88DMG08Accident · No injuriesFinal reportPiper PA-25-235 · La Grange, NCThe pilot reported that the spray boom collided with a tree, resulting in the left aileron being jammed in an uncontrollable position. The acft impacted in a field.NTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…NTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GANTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.NTSB MIA88LA217Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Stringer, MSAccording to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree.NTSB DEN88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Conrad, MTThe plt reported that he was making a lt turnaround to begin a swath run. He said the acft slowed while in a steep lt bank at the highest part of the turn and he was unable to raise the lt wing as the acft approached the ground. The lt wing and main landing…NTSB DEN88DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Limon, COThe plt reported that he was making his third swathrun when the eng quit. He attempted a forced landing but the acft nosed over. The plt said he had 15 gal of fuel on board at takeoff and had been airborne about 15 min. The FAA a/w insp who examined the…NTSB DEN88DTE03Accident · No injuriesFinal reportPiper PA-25-235 · Akron, COThe pilot said the wind was from 200 degrees at 10 KTS, as he began his takeoff on runway 13. When the aircraft reached 20-30 feet AGL it began to sink and collided with the ground. The pilot said he thought he encountered a wind shear or change of wind…NTSB MKC88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Red Cloud, NEAfter a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the…