Skip to content

NTSB investigations: Piper PA-34-200T, CA

28 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

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" = 'CA' 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 ('7103406')) 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\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('7103406'))
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 LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.May 10, 2008 · N103JH · Substantial damage NTSB LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.Nov 11, 2007 · N3038P · Substantial damage NTSB LAX04FA077Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Avalon, CAThe failure of both pilots to properly execute the published missed approach procedure.Dec 24, 2003 · N3747U · Destroyed NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.Apr 6, 1997 · N8188X · Substantial damage NTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.Oct 12, 1994 · N8154C · Substantial damage NTSB LAX93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe pilot's poorly planned approach, excessive airspeed, and failure to attain the proper touchdown point. The pilot's lack of familiarity with the airport is a factor in this accident.Mar 11, 1993 · N1808H · Substantial damage NTSB LAX92LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA34-200T · San Andreas, CAThe failure of the nonmultiengine/instrument rated pilot in command to accomplish the proper emergency procedure during a loss of engine power. Contributing to the accident was the pilot's improper training, lack of instrument experience, heavy fog reported…Dec 11, 1991 · N6522F · Destroyed NTSB LAX92LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Pine Valley, CAThe pilot's failure to monitor the proper altitude over obserable rising terrain. A contributing factor was the pilot's encounter with a strong downdraft.Dec 8, 1991 · N36506 · Destroyed NTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.Jan 7, 1991 · N66SL · Substantial damage NTSB LAX88LA208Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Corona, CACompany maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic…Jun 7, 1988 · N2710M · Substantial damage NTSB LAX88LA186Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Merced, CAWhile taxiing on a dirt road, the right wing struck a tree resulting in substantial damage. There were no mechanical failures or malfunctions reported at the time of the accident.May 14, 1988 · N66SL · Substantial damage NTSB LAX88LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbia, CAAt the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down…Mar 27, 1988 · N47766 · Substantial damage NTSB LAX88LA122Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lower Lake, CADrg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion…Mar 11, 1988 · N1555X · Substantial damage NTSB LAX87LA292Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · El Monte, CAAn instructor (CFI) was giving an airline transport plt (ATP) a check-out in the PA-34. The ATP checked the fuel quantity & questioned the CFI about the lvl in the left tank. The CFI acknowledged that the fuel tank was not full. The ATP stated the fuel gauges…Aug 4, 1987 · N477BL · Substantial damage NTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…May 30, 1986 · N8306Z · Substantial damage NTSB LAX85LA327Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe plt and a gnd witness reptd the acft touched down, main wheel first, in a smooth, soft manner. Upon touch down the nose gear collapsed. The acft slid for 200 ft before coming to rest. Examination of the nose gear assembly disclosed the gear actuator rod…Jul 22, 1985 · N2193Z · Substantial damage NTSB LAX85LA312Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saline Valley, CADuring a pleasure flight the plt observed a slight lt eng fuel pressure fluctuation. Previously, a similar fluctuation to the rt eng revealed the presence of a leaking fuel line. Fearing fire because of a suspected fuel leak to the lt eng, the plt elected to…Jul 6, 1985 · N29461 · Substantial damage 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…Aug 19, 1982 · N24MF · Substantial damage NTSB LAX81FUA08Accident · No injuriesClosedPiper PA-34 · Long Beach, CAJul 19, 1981 · N1411X · Substantial damage NTSB LAX81DUQ31Accident · No injuriesClosedPiper PA-34 · Santa Rosa, CAAug 4, 1980 · N36207 · Substantial damage NTSB LAX80FA096Accident · 2 fatalClosedPiper PA-34 · Redlands, CAMay 8, 1980 · N38598 · Destroyed NTSB LAX80DXQ24Accident · No injuriesClosedPiper PA-34 · Mammoth Lakes, CAApr 14, 1980 · N2904W · Substantial damage NTSB LAX79FVG79Accident · No injuriesClosedPiper PA-34 · Sacramento, CASep 16, 1979 · N3953X · Substantial damage NTSB LAX79DUM07Accident · No injuriesClosedPiper PA-34 · Brawley, CAMar 5, 1979 · N44447 · Substantial damage NTSB LAX79DUQ12Accident · No injuriesClosedPiper PA-34 · Santa Barbara, CAJan 22, 1979 · N2179B · Substantial damage NTSB LAX78DUM38Accident · No injuriesClosedPiper PA-34T · San Diego, CASep 20, 1978 · N1451X · Substantial damage NTSB LAX78FUA15Accident · No injuriesClosedPiper PA-34 · Fullerton, CAMay 5, 1978 · N2710M · Substantial damage NTSB OAK76AP004Accident · No injuriesClosedPiper PA-34 · Redding, CAJul 23, 1975 · N8SW · Substantial damage