Skip to content

NTSB investigations: Piper PA-25-235, OK

38 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

19642026

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.Sep 26, 2024 · N6548Z · Substantial damage NTSB CEN15LA238Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Omega, OKImproper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.May 11, 2015 · N7279Z · Substantial damage NTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.Jul 21, 1997 · N8784L · Substantial damage NTSB FTW95LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Catoosa, OKThe pilot's failure to maintain terrain and obstacle clearance.Mar 30, 1995 · N4900Y · Substantial damage NTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.Apr 16, 1994 · N4647Y · Substantial damage NTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.Apr 23, 1992 · N7603Z · Substantial damage NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.Oct 10, 1991 · N8516L · Destroyed NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Mar 26, 1991 · N9845P · Destroyed NTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.Oct 26, 1987 · N9787P · Destroyed NTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…Jun 4, 1983 · N6551Z · Destroyed NTSB FTW80FPM17Accident · No injuriesClosedPiper PA-25 · Henryetta, OKAug 23, 1980 · N9558P · Substantial damage NTSB FTW79DPJ31Accident · No injuriesClosedPiper PA-25 · Hollis, OKJul 27, 1979 · N7756Z · Substantial damage NTSB FTW79FPM09Accident · Minor injuriesClosedPiper PA-25 · Chouteau, OKMay 31, 1979 · N7161Z · Destroyed NTSB FTW79DPJ20Accident · Minor injuriesClosedPiper PA-25 · Tonkawa, OKMay 29, 1979 · N8624L · Substantial damage NTSB FTW79FPJ01Accident · 1 fatalClosedPiper PA-25 · Hydro, OKOct 24, 1978 · N8845L · Destroyed NTSB FTW78FPJ26Accident · Serious injuriesClosedPiper PA-25 · Enid, OKJun 13, 1978 · N6730Z · Destroyed NTSB FTW77FPM11Accident · No injuriesClosedPiper PA-25 · Pryor, OKMay 28, 1977 · N4646Y · Substantial damage NTSB FTW77DPJ12Accident · Serious injuriesClosedPiper PA-25 · Gotebo, OKMar 29, 1977 · N8822L · Destroyed NTSB FTW75DPJ02Accident · No injuriesClosedPiper PA-25 · Felt, OKJul 18, 1974 · N6997Z · Substantial damage NTSB FTW74DPJ20Accident · No injuriesClosedPiper PA-25 · Eldorado, OKJan 30, 1974 · N8848L · Substantial damage NTSB FTW73DPJ01Accident · No injuriesClosedPipep PA-25 · Guymon, OKAug 17, 1972 · N4959Y · Substantial damage NTSB FTW72DPJ38Accident · No injuriesClosedPiper PA-25 · Lindsay, OKApr 28, 1972 · N7386Z · Substantial damage NTSB FTW72FPM05Accident · No injuriesClosedPiper PA-25 · Atwood, OKAug 25, 1971 · N6531Z · Substantial damage NTSB FTW72DPJ05Accident · No injuriesClosedPiper PA-25 · Texhoma, OKJul 31, 1971 · N8687L · Substantial damage NTSB FTW71FPJ46Accident · 1 fatalClosedPiper PA-25 · Duncan, OKJun 18, 1971 · N6983Z · Destroyed NTSB FTW71FPJ03Accident · 1 fatalClosedPiper J3C-65 · Crawford, OKJul 7, 1970 · N30501 · 2 aircraft · Minor damage NTSB FTW70D0058Accident · No injuriesClosedPiper PA-25 · Guymon, OKJun 19, 1969 · N4631Y · Substantial damage NTSB FTW69F0481Accident · Serious injuriesClosedPiper PA-25 · Bethany, OKApr 6, 1969 · N6901Z · Destroyed NTSB FTW69F0173Accident · No injuriesClosedPiper PA-25 · Crescent, OKAug 31, 1968 · N6593Z · Substantial damage NTSB FTW68D0585Accident · No injuriesClosedPiper PA-25 · Terral, OKMay 5, 1968 · N6918Z · Substantial damage NTSB FTW68D0297Accident · No injuriesClosedPiper PA-25 · Reed, OKOct 20, 1967 · N7655Z · Substantial damage NTSB FTW68D0125Accident · No injuriesClosedPiper PA-25 · Lookeba, OKJul 28, 1967 · N6511Z · Substantial damage NTSB FTW67F0656Accident · Serious injuriesClosedPiper PA-25 · Mooreland, OKMay 29, 1967 · N7575Z · Destroyed NTSB FTW66F0584Accident · No injuriesClosedPiper PA-25 · Okarche, OKMar 26, 1966 · N7687Z · Destroyed NTSB FTW66F0241Accident · Minor injuriesClosedPiper PA-25 · Fort Gibson, OKAug 4, 1965 · N6723Z · Substantial damage NTSB FTW66F0166Accident · Serious injuriesClosedPiper PA-25 · Hough, OKJul 23, 1965 · N6739Z · Substantial damage NTSB FTW66F0039Accident · Serious injuriesClosedPiper PA-25 · Maysville, OKMay 13, 1965 · N6596Z · Destroyed NTSB UNK64X1230Accident · Serious injuriesClosedPiper PA25 · El Reno, OKApr 8, 1964 · N6983Z · Minor damage