Skip to content

NTSB investigations: Piper PA-25-235, AL

46 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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ATL04CA160Accident · No injuriesData collectionFinal reportPiper PA 25 · Foley, ALThe pilot's failure to maintain airspeed during climbout which resulted in a stall while maneuvering to pick up a banner.Jul 20, 2004 · N7222Z · Substantial damage NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.Jun 20, 2004 · N82451 · Substantial damage NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.Oct 6, 1995 · N6674Z · Substantial damage NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.Sep 21, 1991 · N7509Z · Destroyed NTSB ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.Jul 8, 1989 · N6941Z · Destroyed NTSB ATL87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ardmore, ALThe engine lost pwr during initial climb at about 150 ft AGL shortly after the plt turned the fuel boost pump off. A forced ldg was subsequently made on a nearby interstate hwy. the plt delayed the ldg to avoid hitting autos on the hwy and a hard ldg…Aug 5, 1987 · N9867P · Substantial damage NTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…Aug 12, 1985 · N9647P · Destroyed NTSB ATL82DA273Accident · No injuriesFinal reportPiper PA-25 · Red Level, ALWhile returning to the airport after spraying crops, the pilot noted a change in the engine sound and noticed a loss of oil pressure. Anticipating an imminent engine failure, the pilot landed on a portion of an old highway that was clear of motor vehicles.…Sep 13, 1982 · N9728P · Substantial damage NTSB ATL88DKJ34Accident · No injuriesClosedPiper PA-25 · Bay Minette, ALSep 26, 1980 · N7726Z · Destroyed NTSB MIA80DKJ01Accident · Serious injuriesClosedPiper PA-25 · Samson, ALOct 1, 1979 · N7377Z · Destroyed NTSB MIA79FKJ62Accident · Minor injuriesClosedPiper PA-25 · Autaugaville, ALAug 21, 1979 · N82367 · Substantial damage NTSB MIA79FKJ46Accident · No injuriesClosedPiper PA-25 · Opp, ALJun 28, 1979 · N4966Y · Substantial damage NTSB MIA79DKJ01Accident · Minor injuriesClosedPiper PA-25 · Huntsville, ALOct 3, 1978 · N7520Z · Substantial damage NTSB MIA78FKJ84Accident · No injuriesClosedPiper PA-25 · Evergreen, ALAug 26, 1978 · N7755Z · Substantial damage NTSB MIA78FKJ62Accident · No injuriesClosedPiper PA-25 · Shorter, ALJul 19, 1978 · N6965Z · Substantial damage NTSB MIA77DKJ79Accident · No injuriesClosedPiper PA-25 · Mccullough, ALAug 25, 1977 · N7509Z · Substantial damage NTSB MIA77FKJ76Accident · 1 fatalClosedPiper PA-25 · Castleberry, ALAug 20, 1977 · N4622Y · Destroyed NTSB MIA77DKJ74Accident · No injuriesClosedPiper PA-25 · Ashford, ALAug 16, 1977 · N4960Y · Substantial damage NTSB MIA75DKJ18Accident · No injuriesClosedPiper PA-25 · Gantt, ALSep 10, 1974 · N6676Z · Substantial damage NTSB MIA74FKJ11Accident · 1 fatalClosedPiper PA-25 · Trinity, ALAug 6, 1973 · N7432Z · Destroyed NTSB MIA73DKJ56Accident · No injuriesClosedPiper PA-25 · Mccullough, ALMay 10, 1973 · N7716Z · Substantial damage NTSB MIA72DKJ21Accident · No injuriesClosedPiper PA-25 · Ardmore, ALSep 8, 1971 · N7704Z · Substantial damage NTSB MIA72DKJ13Accident · No injuriesClosedPiper PA-25 · Muscle Shoals, ALAug 7, 1971 · N4414Y · Substantial damage NTSB MIA72DKJ08Accident · Minor injuriesClosedPiper PA-25 · Mooresville, ALJul 28, 1971 · N7432Z · Substantial damage NTSB MIA71DKJ53Accident · No injuriesClosedPiper PA-25 · Mccullough, ALApr 20, 1971 · N7509Z · Substantial damage NTSB MIA71FKJ16Accident · 1 fatalClosedPiper PA-25 · Heflin, ALAug 30, 1970 · N7102Z · Destroyed NTSB MIA71DKJ04Accident · Minor injuriesClosedPiper PA-25 · Atmore, ALJul 24, 1970 · N4821Y · Substantial damage NTSB MIA70FKJ42Accident · Serious injuriesClosedPiper PA-25 · Atmore, ALJun 15, 1970 · N4789Y · Destroyed NTSB MIA70D0103Accident · Serious injuriesClosedPiper PA-25 · Atmore, ALJul 25, 1969 · N6655Z · Substantial damage NTSB MIA70F0024Accident · Serious injuriesClosedPiper PA-25 · Rutledge, ALJun 23, 1969 · N7505Z · Destroyed NTSB MIA69F0137Accident · Minor injuriesClosedPiper PA-25 · River Falls, ALAug 23, 1968 · N4697Y · Substantial damage NTSB MIA69F0099Accident · Minor injuriesClosedPiper PA-25 · Eufala, ALJul 27, 1968 · N4908Y · Destroyed NTSB MIA69F0061Accident · Serious injuriesClosedPiper PA-25 · Clanton, ALJul 4, 1968 · N7149Z · Destroyed NTSB MIA68D0495Accident · No injuriesClosedPiper PA-25 · Whitehall, ALApr 8, 1968 · N6657Z · Substantial damage NTSB MIA68D0170Accident · Minor injuriesClosedPiper PA-25 · Foley, ALSep 7, 1967 · N7632Z · Destroyed NTSB MIA68D0149Accident · Minor injuriesClosedPiper PA-25 · Childersburg, ALAug 23, 1967 · N7251Z · Destroyed NTSB MIA68A0020Accident · 1 fatalClosedPiper PA-25 · Millbrook, ALAug 11, 1967 · N7209Z · Destroyed NTSB MIA68D0095Accident · No injuriesClosedPiper PA-25 · Centre, ALAug 7, 1967 · N7102Z · Substantial damage NTSB MIA68F0066Accident · Minor injuriesClosedPiper PA-25 · Elmore, ALJul 26, 1967 · N7706Z · Substantial damage NTSB MIA67F0060Accident · Serious injuriesClosedPiper PA-25 · Eufaula, ALJul 23, 1966 · N7486Z · Destroyed NTSB MIA66F0212Accident · No injuriesClosedPiper PA-25 · Florala, ALSep 12, 1965 · N6789Z · Substantial damage NTSB MIA66F0196Accident · No injuriesClosedPiper PA-25 · Moundville, ALAug 23, 1965 · N7245Z · Substantial damage NTSB MIA66F0067Accident · Minor injuriesClosedPiper PA-25 · Burnt Corn, ALJul 21, 1965 · N7139Z · Destroyed NTSB UNK64X4096Accident · Minor injuriesClosedPiper PA25 · New Lexington, ALSep 22, 1964 · N6493Z · Destroyed NTSB UNK64X3504Accident · No injuriesClosedPiper PA25 · New Lexington, ALAug 21, 1964 · N6488Z · Destroyed NTSB UNK64X3431Accident · No injuriesClosedPiper PA25 · Trickham, ALAug 16, 1964 · N6657Z · Destroyed