Skip to content

NTSB investigations: Piper PA-32-260, IL

33 cases on aircraft the registry lists as Piper PA-32-260. 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

19652026

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 ('7103206')) 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 ('7103206'))
  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 ('7103206'))
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 CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.Mar 30, 2023 · N56793 · Substantial damage NTSB GAA19CA145Accident · No injuriesData collectionFinal reportPiper PA32 · Lacon, ILThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a subsequent impact with a snowbank.Feb 14, 2019 · N3708W · Substantial damage NTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.Oct 18, 2009 · N3357W · Destroyed NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.Aug 10, 2003 · N3258W · Substantial damage NTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…Jul 21, 2001 · N27AP · Substantial damage NTSB CHI99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Charles, ILA loss of engine power due to fuel exhaustion. Also causal was the pilot's inadequate preflight/planning preparation which led to inadvertent flight into instrument meteorological conditions and him becoming lost/disoriented. Contributing to the accident were…Jan 17, 1999 · N40712 · Substantial damage NTSB CHI99LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Creal Springs, ILwas the pilot having the fuel tank selector in the improper position and not following the airplane manufacturer's emergency procedures to restore a loss of power. A factor in this accident was fuel starvation.Jan 16, 1999 · N3689W · Destroyed NTSB CHI91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marshall, ILFlight into known adverse weather by the pilot(s) and subsequent icing of the Piper PA-32'S air induction system. Factors related to the accident were: the adverse weather conditions and a perceived sense of urgency to make the flight.Jan 13, 1991 · N3212W · Destroyed NTSB CHI90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mcleansboro, ILThe pilot-in-command's failure to maintain control of the aircraft while recovering from a bounced landing.Nov 11, 1989 · N3916W · Substantial damage NTSB CHI84LA359Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Woodstock, ILThe acft collided with the terrain during a forced landing. The wx was VMC & no flt plan was filed. During the forced landing in a farm field the right main gear was sheared off and the nose gear bent. The left wing was also substantiallydamaged. The engine…Aug 24, 1984 · N5541J · Substantial damage NTSB CHI84LA265Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kankakee, ILThe eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.Jun 25, 1984 · N40712 · Substantial damage NTSB CHI83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Waukegan, ILThe student was receiving a high performance checkout. During the third landing the acft landed hard.Jun 12, 1983 · N4824S · Substantial damage NTSB CHI77FA028Accident · 4 fatalClosedPiper PA-32 · Sugar Grove, ILFeb 12, 1977 · N31CA · Destroyed NTSB CHI76AC013Accident · 6 fatalClosedPiper PA-32 · Chandlerville, ILAug 14, 1975 · N3287W · Destroyed NTSB CHI74DEE58Accident · No injuriesClosedPiper PA-32 · Dekalb, ILFeb 26, 1974 · N4803S · Substantial damage NTSB CHI74AC062Accident · 1 fatalClosedPiper PA-32 · Chicago, ILJan 17, 1974 · N3998W · Destroyed NTSB CHI72DEE44Accident · No injuriesClosedPiper PA-32 · Rockford, ILOct 30, 1971 · N757UG · Substantial damage NTSB CHI71AC072Accident · Serious injuriesClosedPiper PA-32 · Hinsdale, ILApr 5, 1971 · N3384W · 2 aircraft · Destroyed NTSB CHI71AC064Accident · 5 fatalClosedPiper PA-32 · Geneva, ILMar 13, 1971 · N3955W · Destroyed NTSB CHI71FBQ31Accident · No injuriesClosedPiper PA-32 · Pontiac, ILFeb 25, 1971 · N2785Q · Substantial damage NTSB CHI71AC015Accident · Minor injuriesClosedPiper PA-32 · Princeton, ILAug 21, 1970 · N3639W · Substantial damage NTSB CHI71FBQ02Accident · No injuriesClosedPiper PA-32 · Liverpool, ILJul 12, 1970 · N3924W · Substantial damage NTSB CHI70AC062Accident · No injuriesClosedPiper PA-32 · Northbrook, ILMar 14, 1970 · N3271W · Substantial damage NTSB CHI70DBD14Accident · No injuriesClosedPiper PA-32 · Wheeling, ILJan 25, 1970 · N3478W · Substantial damage NTSB CHI70D0393Accident · No injuriesClosedPiper PA-32 · Lansing, ILDec 24, 1969 · N3342W · Substantial damage NTSB CHI70A0032Accident · 1 fatalClosedPiper PA-32 · Northlake, ILNov 10, 1969 · N3262W · Destroyed NTSB CHI70F0055Accident · No injuriesClosedPiper PA-32 · Chicago, ILJun 27, 1969 · N5581J · Substantial damage NTSB CHI69F0403Accident · No injuriesClosedPiper PA-32 · Peoria, ILNov 21, 1968 · N3200W · Substantial damage NTSB CHI69A0035Accident · No injuriesClosedPiper PA-32 · St Charles, ILSep 23, 1968 · N3271W · Substantial damage NTSB CHI69F0223Accident · No injuriesClosedPiper PA-32 · Effingham, ILAug 25, 1968 · N3344W · Substantial damage NTSB CHI68F0421Accident · No injuriesClosedPiper PA-32 · Monticello, ILSep 10, 1967 · N3458W · Substantial damage NTSB CHI66F0761Accident · No injuriesClosedPiper PA-32 · Decatur, ILMay 19, 1966 · N3462W · Substantial damage NTSB CHI66F0109Accident · Minor injuriesClosedPiper PA-32 · Elgin, ILJul 20, 1965 · N3207W · Substantial damage