Skip to content

NTSB investigations: Piper PA-25-235, MI

21 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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.Aug 13, 2003 · N8563L · Destroyed NTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.Oct 5, 1993 · N6862Z · Substantial damage NTSB CHI87DEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Marne, MIAt the end of a swath run while about one-third of the way through the procedure turn around, the engine suddenly lost power. The pilot extended his glide to clear powerlines and when he flared to land he did not have enough airspeed to stop the descent. The…Jul 20, 1987 · N8972Y · Substantial damage NTSB CHI86FEM14Accident · No injuriesFinal reportPiper PA-25-235 · White Pigeon, MIThe pilot took off with a full load of seed on a 1300 ft runway during shifting wind conditions. He struck a fence before he had enough airspeed to establish a climb.Aug 18, 1986 · N6862Z · Substantial damage NTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…Jul 4, 1986 · N4811Y · Substantial damage NTSB CHI83LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Baroda, MIThe acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing…Aug 5, 1983 · N4880Y · Substantial damage NTSB CHI80DEM30Accident · No injuriesClosedPiper PA-25 · South Haven, MIJun 21, 1980 · N7278Z · Substantial damage NTSB CHI77FET23Accident · No injuriesClosedPiper PA-25 · Niles, MIJul 13, 1977 · N7278Z · Substantial damage NTSB CHI76AEM34Accident · Minor injuriesClosedPiper PA-25 · Edmore, MIApr 7, 1976 · N4921Y · Destroyed NTSB CHI75FEM14Accident · 1 fatalClosedPiper PA-25 · Wayland, MIOct 1, 1974 · N8922L · Destroyed NTSB CHI74FEM63Accident · No injuriesClosedPiper PA-25 · Hart, MIMay 30, 1974 · N4864Y · Destroyed NTSB CHI74DEM02Accident · No injuriesClosedPiper PA-25 · Bay City, MIJul 2, 1973 · N7317Z · Substantial damage NTSB CHI73DEM03Accident · No injuriesClosedPiper PA-25 · Munger, MIJul 13, 1972 · N7200Z · Substantial damage NTSB CHI72DET07Accident · No injuriesClosedPiper PA-25 · Colon, MISep 1, 1971 · N7200Z · Substantial damage NTSB CHI72FEM03Accident · Serious injuriesClosedPiper PA-25 · Orleans, MIJul 9, 1971 · N8711L · Destroyed NTSB CHI71FBJ45Accident · Minor injuriesClosedPiper PA-25 · Bangor, MIDec 13, 1970 · N8582L · Destroyed NTSB CHI70FDW21Accident · No injuriesClosedPiper PA-25 · Linden, MIJun 11, 1970 · N7461Z · Substantial damage NTSB CHI70F0217Accident · Serious injuriesClosedPiper PA-25 · Caro, MISep 1, 1969 · N7020Z · Destroyed NTSB CHI69F0116Accident · Minor injuriesClosedPiper PA-25 · New Troy, MIJul 4, 1968 · N4896Y · Destroyed NTSB CHI68F0123Accident · Serious injuriesClosedPiper PA-25 · Bellevue, MIJun 21, 1967 · N7644Z · Substantial damage NTSB CHI67D0295Accident · No injuriesClosedPiper PA-25 · Albion, MISep 16, 1966 · N6833Z · Substantial damage