NTSB investigations: Piper PA-32R-301T
119 cases on aircraft the registry lists as Piper PA-32R-301T. 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.
Cases, newest first
Query with SQL
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 ('7103220', '7103221'))
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 ('7103220', '7103221'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA87LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Cedar Key, FLThe plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt…NTSB DEN85LA188Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Glen Canyon, UTThe plt said that during the takeoff roll at night from an unlit runway, he was distracted when the engine overboost light illuminated. The investigation revealed, however, that the plt was actually trying to avoid colliding with an airplane at the other end…NTSB DEN85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lordsburg, NMThe plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…NTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…NTSB MIA85LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · W. Palm Beach, FLWhile en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did…NTSB CHI85FEI01Accident · Serious injuriesFinal reportPiper PA-32R-301T · Sandusky, OHThe acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree…NTSB MIA85FA040Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Freeport, FLPreflt wx brief included advisory for scattered showers/thunderstorms along route of flt. Departed in VFR conditions but encountered deteriorating wx enroute, received inflt wx advisory to expect low clngs and reduced visibility ahead. Plt stated he 'would…NTSB FTW84LA295Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · San Angelo, TXThe plt stated that he was in a climb to cruise when he smelled smoke. He immediately turned back towards the arpt but the cabin filled with smoke so he elected to make an emergency landing in a plowed field. After landing the acft was totally destroyed by…NTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…NTSB LAX84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Peach Springs, AZReportedly, the wind was variable & gusty when the acft took off from the hualapai arpt, Peach Springs, AZ. The plt reported that after rotating for takeoff, the acft moved laterally to the left, and as he was correcting for the movement, the left main gear…NTSB LAX83FA351Accident · No injuriesField investigationFinal reportPiper PA32R-T301 · Bakersfield, CAThe acft landed hard, collided with a ditch and collapsed the landing gear during a forced landing after the engine quitat 75 ft AGL during takeoff. The engine was started after the accident and ran for over 7 minutes until it was cut off.NTSB LAX82FUG17Accident · 1 fatalFinal reportPiper PA-32R-301T · San Gorgonio, CAThe acft crashed into the south face of mount San Gorgonio at approximately 8,300 ft MSL. It appeared the acft was in level flt & at a high speed at impact. Witnesses in the area reported the weather was VFR.NTSB FTW82FA223Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Hartshorne, OKWhile on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,…NTSB FTW82DQG12Accident · No injuriesClosedPiper PA-32R · Odessa, TXNTSB FTW81FRD45Accident · No injuriesClosedPiper PA-32R · Lake Charles, LANTSB FTW81FA132Accident · 2 fatalClosedPiper PA-32R · Mount Hermon, LANTSB LAX81FA030Accident · 5 fatalClosedPiper PA-32R · Las Vegas, NVNTSB SEA71DWG19Accident · No injuriesClosedPiper PA-23 · Hayden Lake, IDNTSB DEN69D0152Accident · No injuriesClosedPiper PA-30 · Denver, CO