Skip to content

NTSB investigations: Piper PA-25-235, AR

98 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN22LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Benton, ARThe pilot’s failure to maintain control of the airplane while landing.Mar 26, 2022 · N7523Z · Substantial damage NTSB FTW92LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Des Arc, ARThe power loss due to the failed exhaust stack resultant from inadequate maintenance inspection. Factors were the lack of suitable terrain for the landing and the pilot's failure to maintain airspeed.May 21, 1992 · N7354Z · Substantial damage NTSB MKC87DPG02Accident · Serious injuriesFinal reportPiper PA-25-235 · Hazen, ARThe pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and…Jul 11, 1987 · N7705Z · Destroyed NTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…Mar 3, 1987 · N6540Z · Substantial damage NTSB MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.Jul 19, 1984 · N8815L · Destroyed NTSB FTW81DPG57Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARJul 30, 1981 · N7192Z · Substantial damage NTSB FTW81DPG17Accident · No injuriesClosedPiper PA-25 · Monette, ARApr 10, 1981 · N82349 · Substantial damage NTSB FTW81DPG13Accident · No injuriesClosedPiper PA-25 · Keiser, ARMar 12, 1981 · N82378 · Substantial damage NTSB FTW80FPG57Accident · Serious injuriesClosedPiper PA-25 · Humphrey, ARAug 6, 1980 · N6933Z · Substantial damage NTSB FTW80DPG49Accident · No injuriesClosedPiper PA-25 · Grady, ARJul 20, 1980 · N4550Y · Substantial damage NTSB FTW79DPG75Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARAug 7, 1979 · N7605Z · Substantial damage NTSB FTW79DPG65Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARJul 13, 1979 · N9845P · Destroyed NTSB FTW79DPG62Accident · No injuriesClosedPiper PA-25 · Cash, ARJul 8, 1979 · N4969Y · Destroyed NTSB FTW79FPG42Accident · Serious injuriesClosedPiper PA-25 · Light, ARJun 4, 1979 · N7462Z · Destroyed NTSB FTW78FPG78Accident · 1 fatalClosedPiper PA-25 · Sherrill, ARAug 19, 1978 · N7383Z · Destroyed NTSB FTW78DPG77Accident · No injuriesClosedPiper PA-25 · Augusta, ARAug 16, 1978 · N9771P · Destroyed NTSB FTW78DRD35Accident · No injuriesClosedPiper PA-25 · Osceola, ARJun 13, 1978 · N8936L · Substantial damage NTSB FTW77DPG88Accident · No injuriesClosedPiper PA-25 · Paragould, ARSep 27, 1977 · N6884Z · Substantial damage NTSB FTW77DPG84Accident · Serious injuriesClosedPiper PA-25 · Gregory, ARSep 6, 1977 · N9715P · Destroyed NTSB FTW77DPG65Accident · No injuriesClosedPiper PA-25 · Manila, ARJul 14, 1977 · N9511P · Substantial damage NTSB FTW77FPG64Accident · No injuriesClosedPiper PA-25 · Coy, ARJul 12, 1977 · N9837P · Destroyed NTSB FTW77FPG55Accident · Serious injuriesClosedPiper PA-25 · Des Arc, ARJul 5, 1977 · N4685Y · Destroyed NTSB FTW76DPG01Accident · No injuriesClosedPiper PA-25 · Manila, AROct 4, 1976 · N9511P · Substantial damage NTSB FTW76DPG88Accident · Minor injuriesClosedPiper PA-25 · Marion, ARJul 27, 1976 · N7779Z · Substantial damage NTSB FTW76DPG77Accident · No injuriesClosedPiper PA-25 · West Ridge, ARJul 8, 1976 · N8936L · Substantial damage NTSB FTW76DPG63Accident · No injuriesClosedPiper PA-25 · Wynne, ARJun 11, 1976 · N8540L · Substantial damage NTSB FTW76FPG52Accident · Minor injuriesClosedPiper PA-25 · Hickory Plains, ARMay 20, 1976 · N7420Z · Destroyed NTSB FTW76FPG46Accident · Serious injuriesClosedPiper PA-25 · Tuckerman, ARMar 15, 1976 · N4808Y · Destroyed NTSB FTW76DPG19Accident · No injuriesClosedPiper PA-25 · Joiner, ARAug 26, 1975 · N7692Z · Substantial damage NTSB FTW76DPG16Accident · No injuriesClosedPiper PA-25 · Wabbaseka, ARAug 12, 1975 · N8612L · Substantial damage NTSB FTW76DPG11Accident · No injuriesClosedPiper PA-25 · Grubbs, ARJul 30, 1975 · N8706L · Substantial damage NTSB FTW75FPG75Accident · No injuriesClosedPiper PA-25 · Tamo, ARJun 1, 1975 · N6848Z · Destroyed NTSB FTW75DPG67Accident · No injuriesClosedPiper PA-25 · Des Arc, ARMay 22, 1975 · N4685Y · Substantial damage NTSB FTW75DPG80Accident · Minor injuriesClosedPiper PA-25 · Whistleville, ARMay 14, 1975 · N7589Z · Destroyed NTSB FTW75DPG50Accident · No injuriesClosedPiper PA-25 · Swifton, ARMay 2, 1975 · N7752Z · Substantial damage NTSB FTW75DPG23Accident · No injuriesClosedPiper PA-25 · Cornerstone, AROct 8, 1974 · N7021Z · Substantial damage NTSB FTW75FPG13Accident · 1 fatalClosedPiper PA-25 · Fresno, ARAug 13, 1974 · N7411Z · Destroyed NTSB FTW74FPG74Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARJun 21, 1974 · N6899Z · No damage NTSB FTW74DPG58Accident · No injuriesClosedPiper PA-25 · Altheimer, ARApr 25, 1974 · N7726Z · Substantial damage NTSB FTW74DPG52Accident · No injuriesClosedPiper PA-25 · Pine Bluff, ARMar 27, 1974 · N7242Z · Substantial damage NTSB FTW74FRJ28Accident · No injuriesClosedPiper PA-25 · Texarkana, ARMar 9, 1974 · N7768Z · Substantial damage NTSB FTW74FPG42Accident · Minor injuriesClosedPiper PA-25 · Petit Jean, ARJan 17, 1974 · N8225 · Destroyed NTSB FTW74FPG27Accident · Minor injuriesClosedPiper PA-25 · Rohwer, AROct 1, 1973 · N7351Z · Destroyed NTSB FTW74FPG12Accident · 1 fatalClosedPiper PA-25 · Wabbaseka, ARAug 14, 1973 · N7238Z · Destroyed NTSB FTW73DPG60Accident · No injuriesClosedPiper PA-25 · Parkin, ARJun 4, 1973 · N4397Y · Substantial damage NTSB FTW73DPG05Accident · No injuriesClosedPiper PA-25 · Eudora, ARJul 23, 1972 · N4704Y · Substantial damage NTSB FTW72DPG73Accident · No injuriesClosedPiper PA-25 · Osceola, ARMay 6, 1972 · N4837Y · Substantial damage NTSB FTW72DPG47Accident · No injuriesClosedPiper PA-25 · Joiner, AROct 15, 1971 · N6924Z · No damage NTSB FTW72DPG43Accident · No injuriesClosedPiper PA-25 · Osceola, ARSep 23, 1971 · N8839L · Substantial damage NTSB FTW72FPG42Accident · 1 fatalClosedPiper PA-25 · Mccrory, ARSep 11, 1971 · N7640Z · Destroyed