NTSB investigations: Piper PA-34-200
16 cases on aircraft the registry lists as Piper PA-34-200, where the first occurrence was “Loss of control - in flight”. 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
| 1985 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.NTSB DFW06CA032Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Anahuac, TXThe student pilot's loss of directional control during the landing. A contributing factor was the flight instructor' delayed remedial action.NTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…NTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.NTSB MIA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.NTSB NYC99FA216Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Plymouth, MAThe flight instructor's inadequate remedial action, and the pilot-under-instruction's panic and subsequent interference with the flight controls.NTSB ATL99FA066Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Tallahassee, FLThe pilot's failure to maintain flying speed during initial climb which resulted in a stall and uncontrolled collision with terrain.NTSB FTW94FA226Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Gulf Of MexicoThe pilot's continued flight into known adverse weather. Factors were the thunderstorms and the pilot's disreqard for the forecasted adverse weather.NTSB LAX94LA230Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Chino, CAThe right engine's failure for undetermined reasons to respond to throttle command during a go-around attempt, and both pilot's failure to maintain directional control of the aircraft. Inadequate supervision of the flight by the CFI is also considered a cause.NTSB NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.NTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…NTSB LAX93FA153Accident · 6 fatalField investigationFinal reportPiper PA-34-200 · Carpenteria, CAUndetermined.NTSB BFO92LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Westhampton Bch, NYThe pilot's inadequate landing flare which resulted in a hard landing. Contributing was the pilot's failure to maintain directional control and inadequate supervision.NTSB FTW90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Denton, TXThe instructor pilot's failure to take control of the aircraft in a timely manner, resulting in loss of control. A factor was the instructor's failure to assume control of the throttles, and aircraft engine out capability exceeded.NTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.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…