NTSB investigations: Piper PA-34-200T, FL
22 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 per year
| 1978 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'FL' 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" = 'FL' 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" 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 GAA16CA454Accident · No injuriesData collectionFinal reportPiper PA 34 · Fort Lauderdale, FLThe other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.NTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.NTSB ERA10TA481Accident · No injuriesFinal reportPiper PA-34-200T · Inverness, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ERA10LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Vero Beach, FLThe certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.NTSB ERA09CA104Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Tallahasee, FLThe pilot's failure to maintain aircraft control after touchdown. Contributing to the accident were the gusting winds.NTSB ANC08LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ocala, FLThe pilot's continued operation of the airplane with a known mechanical deficiency--a propeller that would feather at low power. Contributing to the accident was the uncommanded feathering of the propeller.NTSB NYC07CA156Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Fort Lauderdale, FLThe pilot's inadequate recovery from a bounced landing.NTSB MIA01LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Boca Raton, FLA loss of engine power, and the pilot unable to feather the propeller for undetermined reasons, which resulted in a forced landing on a highway, subsequent impact with a pole and vehicles.NTSB ATL99LA058Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB MIA98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Lauderdale, FLThe failure of the O-rings in the landing gear hydraulic cylinder.NTSB MIA97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Stuart, FLThe pilot's failure to maintain directional control during a crosswind landing. Factors were the crosswind and his improper level off.NTSB MIA95LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Boynton Beach, FLThe failure of the pilot-in-command to obtain the proper touchdown point and his failure to flare properly.NTSB MIA92FA051Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Rainbow Lake, FLThe pilot in command's improper inflight decision to divert her attention to other activities not related to the conduct of the flight. Contributing to the accident was the exceeding of the design limits of the airplane leading to a wing failure.NTSB MIA89IA145Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Miami, FLFatigue failure of the left main landing gear trunnion. A contributing factor was: inadequate inspection procedure in Piper service bulletin #787A.NTSB MIA88IA230Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tampa, FLShortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.…NTSB MIA88LA227Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St. Petersburg, FLThe 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt…NTSB MIA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot loaded the ac with 100 pounds of fuel,himself and 5 passengers and departed for a short local flight. The ac was landed 15 minutes later 382 pounds over max gross weight, and landed long on a 2800 ft runway, in a crosswind. The ac then skidded left…NTSB MIA85LA134Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Tampa, FLThe plt stated that during takeoff from rwy 17, the right eng lost power at an alt of about 50 to 60 ft. he attempted toturn back & land, but touched down 90 deg to rwy 03 & slid aprx 100 yards, collapsing the landing gear & separating the right wing from the…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 MIA81FLD51Accident · Minor injuriesClosedPiper PA-34 · Deer Park, FLNTSB MIA78FLA26Accident · Minor injuriesClosedPiper PA-34 · Madison, FL