Skip to content

NTSB investigations: Piper PA-25-235, MT

20 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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 DEN89LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wh Sulphur Spgs, MTThe pilot failed to maintain adequate airspeed during an aerial application maneuver and inadvertently allowed the aircraft to mush into the ground. Unfavorable wind and turbulence were considered to be contributing factors.Jul 11, 1989 · N6663Z · Substantial damage NTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.Jun 20, 1989 · N7001Z · Destroyed NTSB DEN88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Conrad, MTThe plt reported that he was making a lt turnaround to begin a swath run. He said the acft slowed while in a steep lt bank at the highest part of the turn and he was unable to raise the lt wing as the acft approached the ground. The lt wing and main landing…Jun 27, 1988 · N9856P · Substantial damage NTSB DEN86LA183Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bynum, MTAfter the first landing on a gravel road for reloading liquid insecticide the pilot attempted to take off for an aerial application flight. During the take off ground roll the pilot observed that the left door was not properly closed. He momentarily reduced…Jul 2, 1986 · N7099Z · Substantial damage NTSB DEN82FTA10Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendive, MTThe pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…Jun 1, 1982 · N4589Y · Destroyed NTSB DEN80FTA18Accident · Serious injuriesClosedPiper PA-25 · Sidney, MTAug 7, 1980 · N7375Z · Substantial damage NTSB SEA78FTI19Accident · No injuriesClosedPiper PA-25 · Conrad, MTMay 26, 1978 · N9883P · Substantial damage NTSB SEA76FTA25Accident · No injuriesClosedPiper PA-25 · Forsyth, MTJun 9, 1976 · N7611Z · Substantial damage NTSB SEA76DTI03Accident · Minor injuriesClosedPiper PA-25 · Big Sandy, MTJul 24, 1975 · N7391Z · Destroyed NTSB SEA74FTA27Accident · No injuriesClosedPiper PA-25 · Broadview, MTJun 7, 1974 · N7051Z · Substantial damage NTSB SEA74FTA24Accident · No injuriesClosedPiper PA-25 · Wolf Point, MTApr 26, 1974 · N6507Z · Destroyed NTSB SEA73FTI22Accident · No injuriesClosedPiper PA-25 · Belgrade, MTJun 22, 1973 · N6530Z · Substantial damage NTSB SEA70FDA11Accident · No injuriesClosedPiper PA-25 · Lindsay, MTJun 6, 1970 · N6483Z · Substantial damage NTSB SEA70DDA08Accident · No injuriesClosedPiper PA-25 · Billings, MTMay 31, 1970 · N4337Y · Substantial damage NTSB SEA69F0249Accident · 1 fatalClosedPiper PA-25 · Geraldine, MTApr 10, 1969 · N7291Z · Destroyed NTSB SEA68F0315Accident · No injuriesClosedPiper PA-25 · Cut Bank, MTJun 5, 1968 · N7291Z · Substantial damage NTSB SEA68F0319Accident · No injuriesClosedPiper PA-25 · Santa Rita, MTMay 29, 1968 · N7701Z · Substantial damage NTSB SEA68F0314Accident · No injuriesClosedPiper PA-25 · Townsend, MTMay 16, 1968 · N7306Z · Substantial damage NTSB SEA68D0111Accident · Minor injuriesClosedPiper PA-25 · Carter, MTAug 11, 1967 · N7668Z · Substantial damage NTSB SEA67F0054Accident · No injuriesClosedPiper PA-25 · Winifred, MTJul 25, 1966 · N6880Z · Substantial damage