Skip to content

NTSB investigations: Piper PA-25-235, MO

36 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' 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

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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  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

Run 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 CEN16LA332Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Miller, MOThe mechanic's improper installation of the left aileron swage fitting, which resulted in an inflight loss of control.Aug 5, 2016 · N6542Z · Substantial damage NTSB CEN13LA520Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Boonville, MOThe pilot’s failure to maintain directional control of the airplane during landing on a gravel road.Jun 30, 2013 · N7064Z · Substantial damage NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.Jun 28, 2013 · N4812Y · Substantial damage NTSB CEN13FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Lamar, MOThe pilot's in-flight loss of control, which was likely due to a sudden cardiac event.May 5, 2013 · N82509 · Substantial damage NTSB CEN12LA622Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Jasper, MOThe total loss of engine power due to separation of a carburetor air box support bracket and subsequent airflow obstruction to the carburetor.Sep 6, 2012 · N7655Z · Substantial damage NTSB CEN09CA469Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Miller, MOThe failure of the operator to shut down aircraft while conducting servicing which resulted in a ground person being struck by the rotating aircraft propeller.Jul 23, 2009 · N6689Z · No damage NTSB DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.May 5, 2008 · N6944Z · Substantial damage NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.Jul 12, 1993 · N8906L · Substantial damage 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.May 19, 1993 · N8787L · Substantial damage NTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.May 5, 1990 · N9555P · Substantial damage NTSB MKC89DCA01Accident · 1 fatalFinal reportPiper PA-25-235 · Auxvasse, MOThe pilot-in-command's failure to maintain adequate airspeed, resulting in an inadvertant stall.Jun 14, 1989 · N6579Z · Destroyed NTSB MKC85FCA02Accident · Serious injuriesFinal reportPiper PA-25-235 · Dexter, MOThe plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &…Apr 15, 1985 · N9826P · Destroyed NTSB MKC83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Puxico, MOThe plt stated that while trimming a rice field he was watching his drift & when he looked forward he saw the transmission line but was too close to avoid the lines.Jun 15, 1983 · N4813Y · Destroyed NTSB MKC82DA154Accident · No injuriesFinal reportPiper PA-25-235 · Fisk, MOThe pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the…Aug 20, 1982 · N8787L · Destroyed NTSB MKC82DA088Accident · No injuriesFinal reportPiper PA-25-235 · Salem, MOThe pilot was ferrying his newly purchased aircraft from hayti, Missouri to exira, Iowa. He was unable to purchase fuel during an enroute stop at piedmont, Missouri, since no one was at the airport. He elected to continue to Salem, Missouri to obtain fuel. As…May 20, 1982 · N9611P · Substantial damage NTSB MKC81FCG49Accident · No injuriesClosedPiper PA-25 · Knob Noster, MOJul 11, 1981 · N8516L · Destroyed NTSB MKC81FCG29Accident · No injuriesClosedPiper PA-25 · Clever, MOApr 9, 1981 · N6690Z · Substantial damage NTSB MKC80FCG03Accident · No injuriesClosedPiper PA-25 · Salisbury, MONov 28, 1979 · N4546Y · Substantial damage NTSB MKC79FCG41Accident · Serious injuriesClosedPiper PA-25 · Camdenton, MOApr 29, 1979 · N6944Z · Substantial damage NTSB MKC78DCG67Accident · No injuriesClosedPiper PA-25 · Excello, MOAug 23, 1978 · N7221Z · Substantial damage NTSB MKC78DCA45Accident · No injuriesClosedPiper PA-25 · Naylor, MOAug 11, 1978 · N7304Z · Substantial damage NTSB MKC78FCA37Accident · Serious injuriesClosedPiper PA-25 · Ptg Des Sioux, MOJul 3, 1978 · N7264Z · Destroyed NTSB MKC77FCA21Accident · 1 fatalClosedPiper PA-25 · Poplar Bluff, MOMay 28, 1977 · N4995Y · Destroyed NTSB MKC75FCA13Accident · Serious injuriesClosedPiper PA-25 · Poplar Bluff, MOOct 17, 1974 · N4863Y · Substantial damage NTSB MKC74FCA28Accident · Serious injuriesClosedPiper PA-25 · Sikeston, MOMay 30, 1974 · N4918Y · Destroyed NTSB MKC74DCA26Accident · No injuriesClosedPiper PA-25 · Catron, MOMay 20, 1974 · N4954Y · Substantial damage NTSB MKC74FCG08Accident · Serious injuriesClosedPiper PA-25 · Clifton Hill, MOJul 3, 1973 · N4904Y · Substantial damage NTSB MKC73DCA25Accident · Serious injuriesClosedPiper PA-25 · Hornersville, MOMay 12, 1973 · N7564Z · Destroyed NTSB MKC72FCA27Accident · No injuriesClosedPiper PA-25 · New Madrid, MOMay 16, 1972 · N6666Z · Substantial damage NTSB MKC72DCA09Accident · No injuriesClosedPiper PA-25 · Kewanee, MOOct 4, 1971 · N8740L · Substantial damage NTSB MKC72FCA02Accident · 1 fatalClosedPiper PA-25 · Old Monroe, MOJul 20, 1971 · N6619Z · Destroyed NTSB MKC71DCA33Accident · No injuriesClosedPiper PA-25 · Washington, MOApr 23, 1971 · N6576Z · Substantial damage NTSB MKC71DCA31Accident · Minor injuriesClosedPiper PA-25 · Sikeston, MOApr 21, 1971 · N4894Y · Destroyed NTSB MKC70D0098Accident · Minor injuriesClosedPiper PA-25 · La Plata, MOJul 8, 1969 · N4838Y · Substantial damage NTSB MKC67D0278Accident · No injuriesClosedPiper PA-25 · Wardell, MOSep 14, 1966 · N6679Z · Substantial damage NTSB MKC66D0492Accident · No injuriesClosedPiper PA-25 · Nevada, MOFeb 12, 1966 · N7682Z · Substantial damage