NTSB investigations: Piper PA-34-200T
278 cases on aircraft the registry lists as Piper PA-34-200T. 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 ('7103406'))
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 ('7103406'))
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 MKC83FA028Accident · 2 fatalField investigationFinal reportPiper PA-34 · Kansas City, MODrg the 1027 wx briefing, the plt was advised that Kansas City was reporting very light rime icing from 4,000 to 11,000 ft & a PIREP of light to moderate rime ice between 6,000 & 8,000 ft 30 mi south of Kansas City. The plt announcedhis intentions of…NTSB DEN82DA202Accident · No injuriesFinal reportPiper PA-34 · Langdon, NDCabin door came open in flight and pilot made a precautionary landing. During roll-out nose gear collapsed as aircraft weight settled on it since it had not fully extended.NTSB ATL82DA253Accident · No injuriesFinal reportPiper PA-34 · Campbellsville, KYWhile taxiing to a hangar the left wheel went off the taxiway causing the left gear to collapse.NTSB LAX82FUG15Accident · No injuriesFinal reportPiper PA-34-200T · Fontana, CAApproximately 5 hrs after takeoff the plt contacted ontario tower & requested radar vectors to the arpt because he had an eng out. After switching to approach control the plt began receiving vectors to the arpt. At 0209 the plt advised a/c that he ran out of…NTSB FTW82DA311Accident · No injuriesFinal reportPiper PA-34-200T · Eagle Pass, TXThe pilot stated that he overflew the ranch strip and looked it over before landing. He stated that he touched down on the first 200 ft of the 2200 ft, asphalt runway, but each time the brakes were applied, the wheels would lock and skid due to loose gravel…NTSB SEA82FA122Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · 10 Nm E. Of Ken, IDThe plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.NTSB CHI82DA188Accident · No injuriesFinal reportPiper PA-34 · Springfield, ILAfter landing the pilot attempted to taxi the aircraft back to the ramp area in heavy rain and reduced visibility. The aircraft taxied off the left side of the runway and struck two runway lights.NTSB FTW82DA168Accident · No injuriesFinal reportPiper PA-34-200T · Harrison, ARDuring landing the aircraft porpoised and on the second bounce the nose gear assembly buckled, the windshield support buckled and the right windshield popped partially out of its channel. The pilot regained control and taxied in. The props and engine nacelles…NTSB ATL82FLG11Accident · No injuriesFinal reportPiper PA-34-200J · Columbia, SCAfter landing at night, the pilot was cleared to a parking area. A lineman with wands responded to assist. While attempting to follow the signals from the lineman, the pilot taxied into another aircraft.NTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.NTSB MIA82FA038Accident · No injuriesField investigationFinal reportPiper PA-34-200T · Newport Richey, FLThe pilot departed orlando, Florida on a VFR flight to tampa, Florida. At about 1534 EST, the pilot contacted tampa approach control for VFR flight following. Approach control reported radar contact, and at the same time, issued an advisory, "traffic at…NTSB LAX82FA038Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Near Las Vegas, NVThe aircraft, a Piper PA-34, was on a VFR flight to transport bank checks on a part 135 operation. Another company pilot in a Cessna 207 stated that he encountered instrument conditions at 9500 ft while he was flying from tonopah to las Vegas, NV. The Cessna…NTSB FTW82FPD02Accident · No injuriesClosedPiper PA-34 · Henrietta, TXNTSB DCA81AA028Accident · 2 fatalClosedPiper PA-34 · E.Rutherford, NJNTSB ANC81DAG76Accident · No injuriesClosedPiper PA-34 · Chignik, AKNTSB SEA81DA052Accident · No injuriesClosedPiper PA-34 · Wenatchee, WANTSB LAX81FUA08Accident · No injuriesClosedPiper PA-34 · Long Beach, CANTSB SEA81FA047Incident · No injuriesClosedPiper PA-34 · Boise, IDNTSB MIA81FLD51Accident · Minor injuriesClosedPiper PA-34 · Deer Park, FLNTSB FTW81DRG46Accident · No injuriesClosedPiper PA-34 · Crystal City, TXNTSB FTW81FQG34Accident · No injuriesClosedPiper PA-34 · Amarillo, TXNTSB ATL81FLJ06Accident · No injuriesClosedPiper PA-34 · Raleigh, NCNTSB MIA81FKA04Accident · No injuriesClosedPiper PA-34 · Coamo, PRNTSB ATL81FA045Accident · 1 fatalClosedPiper PA-34 · Morgantown, WVNTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WANTSB SEA81DYK03Accident · No injuriesClosedPiper PA-34 · Sutherlin, ORNTSB MIA81DKA02Accident · No injuriesClosedPiper PA-34 · Colosso Cntral, PRNTSB FTW81DQD07Accident · No injuriesClosedPiper PA-34 · Columbus, NMNTSB LAX81DUJ24Accident · No injuriesClosedPiper PA-34 · Whiteriver, AZNTSB LAX81DUQ31Accident · No injuriesClosedPiper PA-34 · Santa Rosa, CANTSB CHI80FER57Accident · No injuriesClosedPiper PA-34 · Albert Lea, MNNTSB LAX81DUJ74Accident · No injuriesClosedPiper PA-34 · Flagstaff, AZNTSB LAX80FA109Accident · 2 fatalClosedPiper PA-34 · Lihue, HINTSB LAX80FA096Accident · 2 fatalClosedPiper PA-34 · Redlands, CANTSB MKC80FCQ15Accident · No injuriesClosedPiper PA-34 · Hays, KSNTSB LAX80DXQ24Accident · No injuriesClosedPiper PA-34 · Mammoth Lakes, CANTSB FTW80FQD04Accident · Serious injuriesClosedPiper PA-34 · El Paso, TXNTSB IAD80FA030Accident · 4 fatalClosedPiper PA-34 · Pine Mountain, GANTSB LAX80FA050Accident · 2 fatalClosedPiper PA-34 · Reno, NVNTSB DEN80DA019Accident · No injuriesClosedPiper PA-34 · Roswell, NMNTSB CHI80FEE14Accident · No injuriesClosedPiper PA-34 · Elgin, ILNTSB MKC80FCQ08Accident · No injuriesClosedPiper PA-34 · Osawatomie, KSNTSB CHI80FEI09Accident · No injuriesClosedPiper PA-34 · Youngstown, OHNTSB LAX79FVG79Accident · No injuriesClosedPiper PA-34 · Sacramento, CANTSB NYC79FHJ26Accident · Serious injuriesClosedPiper PA-34 · East Quogue, NYNTSB IAD79FA060Accident · No injuriesClosedMooney M20G · Bluefield, WVNTSB NYC79FA034Accident · 2 fatalClosedPiper PA-34 · Philadelphia, PANTSB DEN79FA033Accident · 4 fatalClosedPiper PA-34 · Lander, WYNTSB LAX79DUM07Accident · No injuriesClosedPiper PA-34 · Brawley, CANTSB LAX79DUQ12Accident · No injuriesClosedPiper PA-34 · Santa Barbara, CA