NTSB investigations: Piper PA-34-200T, WA
11 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
| 1976 | 2 |
|---|---|
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2006 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'WA' 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" = 'WA' 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 WPR21LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Chelan, WAThe pilot’s unstable approach to land in turbulent conditions, which resulted in a hard landing short of the runway and subsequent loss of directional control and collision with terrain.NTSB SEA06FA039Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Burlington, WAThe pilot's failure to maintain the published minimum descent altitude and not adhering to the published missed approach procedures, which resulted in an in-flight collision with trees and terrain. Factors contributing to the accident were low ceilings and…NTSB SEA97FA006Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cle Elum, WAThe pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…NTSB SEA91FA099Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Ravensdale, WAThe in-flight breakup of the airplane as a result of the pilot exceeding the speed and stress limits for the airplane. A factor relating to the accident was the center of gravity loading that exceeded the aft limits.NTSB SEA89LA008Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Cashmere, WAPlt landed short of hard surface, collapsing lndg gear.NTSB SEA83FA054Accident · No injuriesField investigationFinal reportPiper PA-34-200T · Seattle, WAThe aircraft collided with another parked aircraft while taxiing to takeoff. The time was dawn and the taxiway lights were on. The taxiing pilot allowed his aircraft to stray and collided with a parked PA-34. Both aircraft were damaged substantially. The…NTSB SEA81DA052Accident · No injuriesClosedPiper PA-34 · Wenatchee, WANTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WANTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WANTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WANTSB SEA76DYG40Accident · No injuriesClosedPiper PA-34 · Clyde, WA