Skip to content

NTSB investigations: Piper PA-25-235, IL

27 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.Aug 2, 2008 · N6990Z · Substantial damage NTSB CHI97LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Hinckley, ILthe failure of the glider pilot to properly handle his airplane during the initial takeoff climb which resulted in the tow pilot's inability to maintain control of his airplane.Aug 16, 1997 · N9781P · Destroyed NTSB CHI96LA339Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Highland, ILfailure of the Piper PA-25 tow pilot to see-and-avoid the Blanik L-23 glider. A factor relating to the accident was: neither aircraft was equipped with a communication radio.Sep 14, 1996 · N7753Z · 2 aircraft · Minor damage NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.Sep 24, 1995 · N7753Z · No damage NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.Jul 17, 1988 · N8807L · Substantial damage NTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.Jul 31, 1983 · N4332Y · Substantial damage NTSB CHI81FEV24Accident · 1 fatalClosedPiper PA-25 · Olney, ILJul 11, 1981 · N6531Z · Destroyed NTSB CHI81DCA08Accident · No injuriesClosedPiper PA-25 · Belleville, ILJun 28, 1981 · N7753Z · Substantial damage NTSB CHI81DEE38Accident · No injuriesClosedPiper PA-25 · Paw Paw, ILJun 7, 1981 · N8816L · Destroyed NTSB CHI81FEV04Accident · No injuriesClosedPiper PA-25 · Chrisman, ILNov 15, 1980 · N8830L · Substantial damage NTSB CHI79DEE88Accident · No injuriesClosedPiper PA-25 · La Moille, ILSep 20, 1979 · N8816L · Substantial damage NTSB CHI76FEV56Accident · No injuriesClosedPiper PA-25 · Berwick, ILJul 25, 1976 · N4333Y · Substantial damage NTSB CHI76FEV49Accident · 1 fatalClosedPiper PA-25 · Cerro Gordo, ILJul 20, 1976 · N9811P · Destroyed NTSB CHI76DEV47Accident · No injuriesClosedPiper PA-25 · Wyoming, ILJul 2, 1976 · N6816Z · Substantial damage NTSB CHI76DEV03Accident · No injuriesClosedPiper PA-25 · Sheldon, ILJul 20, 1975 · N7753Z · Substantial damage NTSB CHI75FEV28Accident · No injuriesClosedPiper PA-25 · Blue Mound, ILApr 1, 1975 · N8842L · Substantial damage NTSB CHI74FEV12Accident · No injuriesClosedPiper PA-25 · Washington, ILAug 8, 1973 · N7753Z · Substantial damage NTSB CHI73FCA01Accident · Serious injuriesClosedPiper PA-25 · Dorsey, ILSep 30, 1972 · N7247Z · Substantial damage NTSB CHI73FEV08Accident · No injuriesClosedPiper PA-25 · Browns, ILAug 23, 1972 · N8807L · Substantial damage NTSB CHI73FEV07Accident · Serious injuriesClosedPiper PA-25 · Brookport, ILAug 13, 1972 · N4552Y · Destroyed NTSB CHI72DEV17Accident · No injuriesClosedPiper PA-25 · Ware, ILOct 15, 1971 · N4552Y · Substantial damage NTSB CHI72FEV14Accident · No injuriesClosedPiper PA-25 · Fisher, ILAug 24, 1971 · N4772Y · Substantial damage NTSB CHI72FEV07Accident · No injuriesClosedPiper PA-25 · Carthage, ILJul 31, 1971 · N7014Z · Substantial damage NTSB CHI71FEV42Accident · Minor injuriesClosedPiper PA-25 · Vandalia, ILMay 10, 1971 · N6872Z · Destroyed NTSB CHI70DBQ19Accident · No injuriesClosedPiper PA-25 · Milford, ILJun 8, 1970 · N7725Z · Substantial damage NTSB CHI70FBD39Accident · Serious injuriesClosedPiper PA-25 · Saint Anne, ILMay 23, 1970 · N7245Z · Destroyed NTSB CHI70F0017Accident · No injuriesClosedPiper PA-25 · Harvel, ILApr 29, 1969 · N7472Z · Destroyed