Skip to content

NTSB investigations: Piper PA-25-235, WI

15 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

19692026

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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.Jul 3, 2016 · N6803Z · Substantial damage NTSB CEN14CA344Accident · Minor injuriesData collectionFinal reportPiper PA 25-235 · Rhinelander, WIA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.Jul 3, 2014 · N8730L · Substantial damage NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.May 5, 2008 · N4352Y · Substantial damage NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.May 27, 1991 · N855SD · Substantial damage NTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.May 22, 1989 · N4395Y · Substantial damage NTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…Aug 11, 1988 · N4856Y · Substantial damage NTSB CHI84LA386Accident · No injuriesLimited investigationFinal reportPiper PA25 · Sheboygan, WIPlt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground.Sep 7, 1984 · N4571Y · Substantial damage NTSB CHI83LA219Accident · No injuriesLimited investigationFinal reportPiper PA25 · Tomah, WIThe acft lost power and made a forced landing immediately after takeoff on an aerial application mission. The landing gear collapsed during the landing. The pilot stated that the accident occurred on the 5th flt of the day after taking off on runway 27 and…May 17, 1983 · N4521Y · Substantial damage NTSB CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WISep 26, 1980 · N7627Z · Substantial damage NTSB CHI76DEP03Accident · No injuriesClosedPiper PA-25 · Bancroft, WIJul 15, 1975 · N4659Y · Substantial damage NTSB CHI73DEP63Accident · No injuriesClosedPiper PA-25 · Portage, WIJun 4, 1973 · N7796Z · Substantial damage NTSB CHI73FEP10Accident · Serious injuriesClosedPiper PA-25 · Suring, WISep 12, 1972 · N4598Y · Substantial damage NTSB CHI71DEP52Accident · No injuriesClosedPiper PA-25 · Random Lake, WIMay 28, 1971 · N4421Y · Substantial damage NTSB CHI70F0319Accident · No injuriesClosedPiper PA-25 · Peshtigo, WIAug 25, 1969 · N7796Z · Substantial damage NTSB CHI70D0095Accident · No injuriesClosedPiper PA-25 · Suring, WIJul 8, 1969 · N4598Y · Substantial damage