NTSB investigations: Piper PA-25-235
12 cases on aircraft the registry lists as Piper PA-25-235, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 4 |
|---|---|
| 1983 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 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\" = 130))
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" = 130))
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 ATL01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Blakely, GAThe pilot's inadequate in-flight decision to go-around after a reported loss of right brake pressure during the landing roll resulted in the in-flight collision with trees.NTSB SEA95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe left main landing gear tire burst during takeoff.NTSB CHI94LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Spiritwood, NDthe failure of the fuselage tubing in the empennage.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 ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.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 MKC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Columbus, NEThe PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a…NTSB ATL83LA335Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Baxley, GAThe acft collided with trees during an emergency landing after the cockpit filled with smoke. A mechanic who examined the acft after the accident reported that exhaust gases had burned through the muffler shroud & had burned the ignition wires.NTSB FTW83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Andrews, TXWhile on an aerial application flight the pilot landed on a gravel road. When the aircraft speed was reduced to about 25 mph the left wheel broke and the aircraft nosed over. Inspection of the aircraft revealed that the left main landing gear wheel bolts…NTSB ATL82DA273Accident · No injuriesFinal reportPiper PA-25 · Red Level, ALWhile returning to the airport after spraying crops, the pilot noted a change in the engine sound and noticed a loss of oil pressure. Anticipating an imminent engine failure, the pilot landed on a portion of an old highway that was clear of motor vehicles.…NTSB FTW82DA297Accident · No injuriesFinal reportPiper PA-25-235 · Santa Rosa, NMWhile landing, the aircraft swerved off the runway and received substantial damage. An investigation revealed that the right main wheel had come off the axle. A closer examination revealed that the retaining nut and the cotter pin, which holds the nut in…NTSB FTW82DA208Accident · No injuriesFinal reportPiper PA-25-235 · Jayton, TXWhile taxiing out for takeoff with a full load of fuel and chemicals the left main wheel broke into three pieces. The axle sank into the surface of the runway causing the aircraft to swerve to the left, resulting in an overload condition on the right gear.…