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(total) - mech failure/malf”. 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
| 1983 | 3 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
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 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\" = 351))
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" = 351))
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 FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB FTW95LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · San Antonio, TXThe loss of engine power due to fuel exhaustion as result of a fuel line connector leak. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Columbia, NCThe failure of the aircraft carburetor that resulted in a total loss of engine power.NTSB NYC93LA168Accident · No injuriesLimited investigationFinal reportPiper PA-25-225 · Chesapeake, VAThe loosening of the crankshaft geardrive as a resulted of a sheared bolt and guide pin which resulted in the loss of engine power. A factor was a forced landing on a crop field.NTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB FTW92LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Des Arc, ARThe power loss due to the failed exhaust stack resultant from inadequate maintenance inspection. Factors were the lack of suitable terrain for the landing and the pilot's failure to maintain airspeed.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 DEN90DQA03Accident · No injuriesFinal reportPiper PA-25-235 · Fabens, TXEngine failure due to shorting of the magneto's 'p' lead, and failure of the exhaust manifold.NTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GANTSB DEN87DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Center, COThe plt reported that the eng lost power while the acft was en route to spray a field. There was no suitable terrain for a forced landing and the plt landed the aircraft in a soft, cultivated field and nosed over. Examination of the eng revealed burned and…NTSB CHI87DEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Marne, MIAt the end of a swath run while about one-third of the way through the procedure turn around, the engine suddenly lost power. The pilot extended his glide to clear powerlines and when he flared to land he did not have enough airspeed to stop the descent. The…NTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.NTSB ATL86LA261Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Plymouth, NCDuring a turn to reverse direction while dispersing chemicals over a peanut crop, the engine lost power. The pilot dumped the load of chemicals and made a hard full stall forced landing in the peanut field. Inspection of the engine revealed that the left…NTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…NTSB SEA85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-C · Wenatchee, WADuring an aerial applications maneuver the engine ceased operating and a forced landing was made in an orchard in between apple tree rows. Engine and aircraft inspection could not reveal any abnormalities with the exception of a very dirty, partially clogged…NTSB DEN85LA155Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fillmore, UTThe plt reported the engine failed while he was spraying a corn field, necessitating a straight ahead forced landing. During the landing roll the wheels bogged down in the soft earth and the plane overturned. Subsequent examination of theengine by the plt…NTSB ATL85LA024Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lincoln, TNThe acft was making a swath run spraying crops when the engine suddenly lost power with 200 yards of level field remaining for an emergency landing. After touchdown the plt turned the acft to avoid a collision with trees. During the turn the nose of the acft…NTSB CHI84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Morrow, OHAbout 10 min. After takeoff on an aerial application flt the acft's eng lost pwr. The plt made a forced landing in a corn field & during rollout collided with a tree. According to the plt, the acft's eng blew its right rear cylinder because its hold down…NTSB ATL83LA346Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Falkland, NCThe plt reported that during a pull-up from a swath run, the acft began to shake & lose power. He continued to climb with full throttle & was able to maintain altitude for a short time, then the eng had a total power loss. Reportedly, the acft collided with…NTSB MKC83LA142Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Corning, IAThe acft crashed in a swamp during a forced landing after the engine seized. The pilot noted a lack of oil pressure and rising oil temperature. He dumped his load and began to return to land. The engine began to run rough and soon seized. Post accident…NTSB MKC83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Grenola, KSWhile spraying liquid fertilizer, the plt noticed that the fuel indication was dropping rapidly. He stated that he tried to return to the departure point, but was unable. When the engine lost power, he jettisoned the remainder of his load & landed in a…