NTSB investigations: Piper PA-25-235
22 cases on aircraft the registry lists as Piper PA-25-235, where the first occurrence was “Loss of engine power”. 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
| 1982 | 2 |
|---|---|
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
Where
Latest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 CHI06CA216Accident · No injuriesData collectionFinal reportPiper PA-25 · Minot, NDThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.NTSB DFW05LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Houston, TXA loss of engine power due to the pilot's inadequate preflight planning/preparation in detecting contaminated fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.NTSB MIA01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Spartanburg, SCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion, forced landing, and subsequent in-flight collision with trees and terrain. Contributing to the accident was an unidentified pilot's failure to yield the…NTSB SEA98LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Blackfoot, IDA loss of power for undetermined reasons.NTSB CHI98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sabetha, KSThe loss of engine power for undetermined reasons.NTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.NTSB CHI97LA209Accident · No injuriesLimited investigationFinal reportPiper PA-25-235A · O'Neil, NEfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel consumption calculations. Factors relating to the accident were: the lack of an operable fuel indication system, and the high winds.NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.NTSB ATL92LA184Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Powellsville, NCThe failure of the no.1 exhaust valve.NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.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.NTSB LAX89LA329Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warner Springs, CALoss of engine power for an unknown reason. The obstruction (tree) was a factor.NTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…NTSB FTW86FPA27Accident · Minor injuriesFinal reportPiper PA-25-235 · Marlin, TXThe plt reported the eng quit during a right turn after takeoff at an alt of aprx 200 ft AGL. The acft crashed in a heavily wooded area aprx 1/4 mile west of the arpt. Cause of the eng failure was not determined.NTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…NTSB MKC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Grenola, KSWhile maneuvering during a swath to a field, the engine quit. The plt was operating his acft for aprx 1/2 hr prior to the loss of pwr. The plt states he visually checked the fuel level. An inspection of the acft engine revealed no mechanical failure or…NTSB MIA85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Everglades, FLThe acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted…NTSB DEN82DA144Accident · No injuriesFinal reportPiper PA-25-235 · Leonard, NDThe pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.NTSB MKC82DA097Accident · Minor injuriesFinal reportPiper PA-25-235 · Kimball, NEThe aircraft was loaded with 100 gallons of 2-4-D and 40 gallons of fuel. During the preflight run-up check, the pilot noted a mag drop of 225 RPM. He stated that leaning the fuel mixture cleared the excessive decrease in RPM, and he observed 2500 RPM on the…