NTSB investigations: Piper PA-34-200
210 cases on aircraft the registry lists as Piper PA-34-200. 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 ('7103405'))
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 ('7103405'))
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 MIA89LA198Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fort Myers, FLThe pilot's failure to see and avoid obstructions as he taxied from the ramp area. Contributing to the accident was the dark light conditions which degraded the pilot's visual perception.NTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.NTSB BFO89FA004Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Ocean City, MDThe pilot failed to maintain adequate clearance above the terrain. Contributing factors are inattention to altitude and dark night conditions over illusionary producing featureless water.NTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…NTSB ATL87IA163Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Birmingham, ALThe pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally.NTSB FTW87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Grand Prairie, TXDuring landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed.NTSB MIA87FA098Accident · No injuriesField investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…NTSB MIA86LA248Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that his landing apch was high. The acft touched down too fast and the plt veered the acft off the left side of the rwy to avoid contacting a fence at the end of the rwy. The acft traveled into soft dirt and the landing gear collapsed.NTSB LAX86LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Salinas, CAThe acft collided with the surface of rwy 13 after the nose gear collapsed. The plt indicated the three green gear safe indicator lights were illuminated prior to touchdown. The acft was landed on the main gear first and then the nose gear. The nose gear…NTSB ATL86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbus, GAThe flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…NTSB FTW85LA226Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Crowell, TXThe pilot landed with a light tail wind on a 3200 ft rwy which slopes downward. The brakes faded and became ineffective due to heavy application. A go-around was attempted; however, flying speed was not obtained and the acft impacted the ground about 200 ft…NTSB ATL85LA129Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Concord, NCThe plt reported that the pvt arpt at the destination had a unidirectional strip with hi obstructions on both ends. Obstacles, rwy slope & noise abatement considerations required that rwy 4 be used for landings. At 1351 EST, the wind at charlotte, NC was from…NTSB NYC84LA213Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Monongahela, PAThe certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal…NTSB SEA84FA123Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · North Bend, ORThe acft was cleared for an ILS rwy 4 apch while 9 miles north of oth (North Bend) VOR. Instructions were given to cross oth VOR at or above 3700 ft MSL. 14 min later, the plt reported to North Bend fss 'my needle doesn't seem to be moving on my localizer…NTSB ATL84LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Smyrna, TNThe CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…NTSB SEA84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Burns, OROn departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.NTSB NYC84FA032Accident · 2 fatalField investigationFinal reportBeech K35 · Stockholm, NJAt 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…NTSB FTW84LAMS1Accident · 1 fatalFinal reportPiper PA-34-200 · Gulf Of MexicoThe acft disappeared on a flt over a part of the Gulf Of Mexico south of corpus christi in an area of thunderstorm activity. The storms were densely packed and it was considered unlikely that VFR flt could be conducted in the area. Theaccident acft was in…NTSB FTW83FA149Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Kingston, OKThe acft rolled right after a premature liftoff due to a dip in the rwy. The acft continued to roll right until it impacted a 6 degree slope in a 100 degree nose down attitude. Investigation revealed that the right engine had suffered a power loss due to a…NTSB ATL83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbia, SCThe pilot landed on runway 23 with winds that were variable from 250 to 290 deg at 14 gusting 24 KTS. With these winds, the maximum crosswind component would have been about 21 KTS. The maximum demonstrated crosswind component for this aircraft was 15 KTS.…NTSB NYC82DA055Accident · No injuriesFinal reportPiper PA-34-200 · Atlantic City, NJThe pilot reported that he elected to fly his IFR approach to the runway with a 10 kt quartering tail wind. He reported encountering hydroplaning conditions after landing within the first quarter of the runway. By the time he considered a go-around, there was…NTSB FTW82DA038Accident · No injuriesFinal reportPiper PA-34 · Tomball, TXAfter being cleared by the tower to taxi onto the runway from an unlighted taxiway the right main landing gear fell into a hole. Construction work was being done in the area and no warning lights had been erected. The pilot stated that the tower personnel had…NTSB CHI81FEC47Accident · No injuriesClosedPiper PA-34 · Linden, MINTSB DEN81FA054Accident · 1 fatalClosedPiper PA-34 · Price, UTNTSB ATL81DLQ18Accident · No injuriesClosedPiper PA-34 · Paducah, KYNTSB CHI81DEC19Accident · No injuriesClosedPiper PA-34 · Detroit, MINTSB LAX81FA029Accident · 5 fatalClosedPiper PA-34 · El Cajon, CANTSB LAX80FVW24Accident · No injuriesClosedPiper PA-34 · Las Vegas, NVNTSB ANC80DA057Accident · No injuriesClosedPiper PA-34 · St Michael, AKNTSB ATL80FA047Accident · 1 fatalClosedPiper PA-34 · Enterprise, MSNTSB DEN79FA056Accident · 6 fatalClosedPiper PA-34 · Wendover, UTNTSB LAX79DUM16Accident · No injuriesClosedPiper PA-34 · Ramona, CANTSB MIA79FA064Accident · 1 fatalClosedPiper PA-34 · Davie, FLNTSB LAX80FVG15Accident · No injuriesClosedPiper PA-34 · Travis Afb, CANTSB IAD79FA023Accident · 1 fatalClosedPiper PA-34 · Blountville, TNNTSB MIA79FKT22Accident · No injuriesClosedPiper PA-34 · Ft.Lauderdale, FLNTSB MIA79FKT14Accident · Minor injuriesClosedPiper PA-34 · Opa Locka, FLNTSB MIA79FA007Accident · 2 fatalClosedPiper PA-34 · Titusville, FLNTSB MIA79DA081Accident · No injuriesClosedPiper PA-34 · Boca Raton, FLNTSB CHI79FEI02Accident · No injuriesClosedPiper PA-34 · Chargin Falls, OHNTSB IAD78FLQ35Accident · No injuriesClosedPiper PA-34 · Covington, KYNTSB IAD78FLQ30Accident · No injuriesClosedPiper PA-34 · Mt Sterling, KYNTSB IAD78FA088Accident · 3 fatalClosedPiper PA-34 · Chesterfield, VANTSB OAK78FA037Accident · 5 fatalClosedPiper PA-34 · Ysmite Nat Pk, CANTSB IAD78DLQ21Accident · No injuriesClosedPiper PA-34 · Decoy, KYNTSB FTW78DPA23Accident · No injuriesClosedPiper PA-34 · Addison, TXNTSB ANC78FA029Accident · No injuriesClosedPiper PA-34 · Anchorage, AKNTSB MIA78DLD33Accident · No injuriesClosedPiper PA-34 · Lakeland, FLNTSB MIA78FKG37Accident · No injuriesClosedPiper PA-34 · Macon, GANTSB NYC78FHD01Accident · Serious injuriesClosedPiper PA-34 · Berlin, NJ