Skip to content

NTSB investigations: Piper PA-25-235, SD

19 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

19682026

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" = 'SD' 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\" = 'SD' 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" = 'SD' 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 CEN15CA001Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Yankton, SDThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Oct 1, 2014 · N6659Z · Substantial damage NTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.Aug 20, 2011 · N7051Z · Substantial damage NTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.Jun 18, 2011 · N7018Z · Substantial damage NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.Jun 21, 1997 · N7378Z · Destroyed NTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · Destroyed NTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.May 18, 1992 · N4427Y · Destroyed NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.Jun 9, 1990 · N7136Z · Destroyed NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…Aug 7, 1986 · N7121Z · Destroyed NTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…Sep 15, 1984 · N7236Z · Substantial damage NTSB DEN83LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Brandt, SDThe acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…Jul 1, 1983 · N7121Z · Substantial damage NTSB DEN80FTK18Accident · Serious injuriesClosedPiper PA-25 · Tulare, SDJul 24, 1980 · N7057Z · Substantial damage NTSB MKC78FTK25Accident · No injuriesClosedPiper PA-25 · Sisseston, SDJul 9, 1978 · N9882P · Substantial damage NTSB MKC76FTK28Accident · Minor injuriesClosedPiper PA-25 · Sturgis, SDJun 11, 1976 · N7500Z · Destroyed NTSB MKC73FTK18Accident · No injuriesClosedPiper PA-25 · Gettysburg, SDJun 22, 1973 · N7620Z · Substantial damage NTSB MKC72DTK30Accident · No injuriesClosedPiper PA-25 · Conde, SDJun 3, 1972 · N7326Z · Substantial damage NTSB MKC72FTK02Accident · No injuriesClosedPiper PA-25 · Dixon, SDAug 9, 1971 · N7579Z · Substantial damage NTSB MKC71FTK33Accident · Serious injuriesClosedPiper PA-25 · Onida, SDJun 17, 1971 · N7007Z · Substantial damage NTSB MKC70D0102Accident · No injuriesClosedPiper PA-25 · Doland, SDAug 4, 1969 · N4897Y · Substantial damage NTSB MKC69D0034Accident · No injuriesClosedPiper PA-25 · Platte, SDMay 29, 1968 · N6568Z · Substantial damage