Skip to content

NTSB investigations: Piper PA-32-260

693 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, newest first

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."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.\"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."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 ATL84LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Indian Head, MDThe plt stated that shortly after departing dca, he encountered a small amount of rain that froze on the aircraft's windshield. He continued on to his destination and again encounter freezing rain when turning from base to final. He elected to make a…Dec 21, 1983 · N5685V · Substantial damage NTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…Dec 20, 1983 · N43302 · Substantial damage NTSB MKC84LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sikeston, MOThe acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed…Dec 16, 1983 · N321HF · Substantial damage NTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…Dec 2, 1983 · N3206W · Destroyed NTSB LAX84FA045Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Riverside, CAShortly after departure the plt radioed in that he had blown a rod 'or something' and was about two miles out on a right base leg. He then informed the tower that he was not going to make the runway after which the left wing contacted a power pole and the…Nov 4, 1983 · N15039 · Destroyed NTSB CHI84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Warsaw, INThe acft collapsed the landing gear during a forced landing following eng failure. The acft had been flown 5.5 hours before landing 3 miles NE of the intended refueling stop. The pilot had passed ft wayne at flt time of 5+ hours with about 10 gallons of fuel…Oct 28, 1983 · N15419 · Substantial damage NTSB CHI83LA394Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe plt lost directional control during the landing roll & the acft struck 3 landing lights. The left gear collapsed & there was substantial damage to the left wing. The pilot stated that his landing light was inoperative during the landing and lack of…Aug 28, 1983 · N9346C · Substantial damage NTSB NYC83LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Westerly, RIAfter landing, the plt proceeded to taxi to the ramp area. While maneuvering within the ramp area, the plt taxied the acft into a construction zone. Reportedly, the right main wheel dropped into a rough area & resulted in substantial damage to the right wing…Aug 7, 1983 · N5533J · Substantial damage NTSB CHI83LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Demotte, INThe plt stated he overflew the unfamiliar arpt & landed to the south (downwind) because of power lines on the approach to the north. He was high on final due to a tree in the approach path. The acft floated during the flare. He then raisedthe nose & the right…Jul 24, 1983 · N3744W · Substantial damage NTSB MIA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Jupiter, FLThe plt reported that he was returning from the Bahamas when he experienced a loss of eng power & landed in a vacant field. The power loss occurred following fuel starvation. The plt stated that the acft was recently purchased & the fuel gauges were…Jul 13, 1983 · N3719W · Substantial damage NTSB MKC83FA127Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Newton, IAThe non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…Jun 12, 1983 · N5509V · Destroyed 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 MIA83FA152Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Sebastian, FLDuring the flt, the plt contacted vero beach tower & requested the wx. He was advised that vero beach & ft pierce, FL were VFR, but there was wx north of vero beach, a convective SIGMET was in effect & there were thunderstorms in the area. The plt…Jun 5, 1983 · N4724S · Destroyed NTSB ATL83FIG04Accident · No injuriesFinal reportPiper PA-32-260 · Laurel, MDThe pilot started a go-around after the acft had progressed over half way down the runway in the air. When full power was applied the engine sputtered and quit. The pilot changed fuel tanks, lowered the nose and landed straight ahead in the tops of trees.…May 13, 1983 · N4823T · Substantial damage NTSB CHI83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Madeira, OHThe acft crashed into trees during a forced landing after the engine stopped operating while approaching an arpt. The acft was on a cross country flt from dayton to cincinnati in VMC weather. The acft was inspected at the scene and the engine was removed and…Feb 27, 1983 · N6809J · Destroyed NTSB MIA83LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PRThe flight had departed st. thomas, VI at 0900 on a VFR flight plan to roosevelt roads after discharging passengers in st. thomas. While enroute in cruise at 1800 MSL the engine failed. He turned toward the island of Culebra and when all efforts to restart…Jan 11, 1983 · N20FH · Destroyed NTSB NYC83FA037Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Douglassville, PAAt aprx 1540 EST, the acft was dispatched to philadelphia, PA on a pax flt. After arriving, the plt remained there to pick up 4 other pax that were arriving at approx 2100 EST. At 2007, the plt received a partial wx brief & filed an IFR flt plan to rtn to…Dec 2, 1982 · N32750 · Destroyed NTSB CHI83LA020Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Vandalia, OHThe pilot estimated that he had 40 gal of fuel on board when he departed parkersburg, WV for new carlisle, OH. During a night arrival at new carlisle, he was unable to activate the runway lights by keying his microphone. Therefore, he diverted to Vandalia,…Oct 18, 1982 · N4740S · Substantial damage NTSB ANC82DA088Accident · No injuriesFinal reportPiper PA-32-260 · Naknek, AKAt the point of rotation the acft struck a large puddle of water causing a reduction in speed. The acft continued down the rwy approximately another 150 ft at 5 ft AGL when it became evident that further flight was impossible. The takeoff was aborted & the…Sep 10, 1982 · N3884W · Substantial damage NTSB MKC82DA147Accident · Minor injuriesFinal reportPiper PA-32-260 · Manhattan, KSThe pilot departed Manhattan, KS and flew to minneapolis, MN. At minneapolis, he refueled with 10 gal added to the left main tank. He said both main tanks were full, the right auxiliary tank was empty, and he estimated there was 5 gal in the left auxiliary…Aug 19, 1982 · N3436W · Substantial damage NTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…Jun 26, 1982 · N3446W · Substantial damage NTSB NYC82FFJ12Accident · Minor injuriesFinal reportPiper PA-32 · Syracuse, NYThe pilot took off on a VFR flight plan with a litter patient and 3 other passengers onboard. The right main fuel tank was used for about the first 30 minutes of flight, then the pilot switched to the left main tank. While en route, an IFR flight plan was…Mar 12, 1982 · N260BB · Substantial damage NTSB ATL82DA043Accident · No injuriesFinal reportPiper PA-32-260 · Louisville, KYAt 600FT AGL while on a 3 mile straight in visual approach,the engine quit. The pilot stated he had insufficient time to attempt a restart and commenced a 180 degree turn toward a golf course. Upon landing the aircraft struck a tree. Investigation revealed no…Jan 28, 1982 · N3654W · Substantial damage NTSB LAX82FJA02Accident · Serious injuriesClosedPiper PA-32 · Lanai City, HINov 1, 1981 · N3864W · Destroyed NTSB ANC82DA004Accident · Serious injuriesClosedPiper PA-32 · Port Heiden, AKOct 17, 1981 · N3578W · Substantial damage NTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, COOct 3, 1981 · N3900W · Substantial damage NTSB FTW81FPG54Accident · No injuriesClosedPiper PA-32 · Little Rock, ARJul 12, 1981 · N4807S · Substantial damage NTSB MKC81FCG44Accident · No injuriesClosedPiper PA-32 · Liberty, MOJul 3, 1981 · N4828S · Substantial damage NTSB FTW81FA095Accident · 2 fatalClosedPiper PA-32 · Moulton, TXMay 26, 1981 · N3582W · Destroyed NTSB MKC81IA031Incident · No injuriesClosedPiper PA-32 · St.Ansgar, IAApr 20, 1981 · N3370W · Minor damage NTSB FTW81FRJ12Accident · Minor injuriesClosedPiper PA-32 · Texarkana, ARApr 12, 1981 · N3726W · Destroyed NTSB MIA81FKT42Accident · No injuriesClosedPiper PA-32 · Pompano Beach, FLApr 5, 1981 · N7748J · Substantial damage NTSB ANC81FA032Accident · Serious injuriesClosedPiper PA-32 · Nuiqsut, AKMar 19, 1981 · N3644W · Destroyed NTSB ATL81FKJ15Accident · 1 fatalClosedPiper PA-32 · Mobile, GAFeb 19, 1981 · N3898W · Destroyed NTSB LAX81FJA06Accident · No injuriesClosedPiper PA-32 · Kona Village, HIFeb 18, 1981 · N7708J · Substantial damage NTSB ATL81FKW09Accident · Minor injuriesClosedPiper PA-32 · Nashville, TNFeb 14, 1981 · N3932W · Destroyed NTSB NYC81FA017Accident · 1 fatalClosedPiper PA-32 · Philadelphia, PADec 28, 1980 · N3694W · Destroyed NTSB LAX81FXQ04Accident · Serious injuriesClosedPiper PA-32 · Carson City, NVDec 5, 1980 · N3587W · Destroyed NTSB ATL81FA019Accident · 5 fatalClosedPiper PA-32 · Hilton Head, SCNov 30, 1980 · N3242W · 2 aircraft · Destroyed NTSB FTW81DRD07Accident · Minor injuriesClosedPiper PA-32 · Loreauville, LANov 25, 1980 · N4690F · Substantial damage NTSB MKC81DCG11Accident · No injuriesClosedPiper PA-32 · Green City, MONov 11, 1980 · N3209W · Substantial damage NTSB FTW80FA116Accident · 4 fatalClosedPiper PA-32 · Goodwill, LASep 17, 1980 · N1806T · Destroyed NTSB CHI80DEP50Accident · No injuriesClosedPiper PA-32 · Dodgeville, WIAug 9, 1980 · N3954W · Substantial damage NTSB ATL80FKW16Accident · Serious injuriesClosedPiper PA-32 · Sparta, TNJul 8, 1980 · N3157D · Substantial damage NTSB MKC80DCQ23Accident · No injuriesClosedPiper PA-32 · Kiowa, KSJul 1, 1980 · N3532W · Substantial damage NTSB MIA80FLD66Accident · Minor injuriesClosedPiper PA-32 · Tampa, FLMay 8, 1980 · N7722J · Substantial damage NTSB MIA80DKA08Accident · No injuriesClosedPiper PA-32 · Culebra Island, PRApr 27, 1980 · N3679W · Substantial damage NTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCMar 10, 1980 · N1438X · Destroyed NTSB FTW80FPJ10Accident · No injuriesClosedPiper PA-32 · Loyal, OKMar 7, 1980 · N3223W · Substantial damage NTSB MIA80FA033Accident · 4 fatalClosedPtper PA-32 · Cedar Key, FLFeb 15, 1980 · N5558J · Destroyed