NTSB investigations: Piper PA-34-200, TX
14 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 per year
| 1974 | 2 |
|---|---|
| 1978 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2023 | 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\" = 'TX' 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 ('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."eventStateOrRegion" = 'TX' 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 ('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 CEN23LA172Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-200 · Coldspring, TXThe stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.NTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.NTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.NTSB GAA17CA093Accident · No injuriesData collectionFinal reportPiper PA 34 · Denton, TXThe flight instructor’s decision to continue to taxi the airplane to the parking area with a known brake malfunction, which resulted in a loss of directional control and subsequent impact with a parked airplane.NTSB CEN14LA220Accident · No injuriesLimited investigationFinal reportPiper PA 34-200 · Spring, TXThe loss of right brake effectiveness during landing for reasons that could not be determined based on the available evidence, which resulted in a loss of directional control.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 FTW98FA117Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Graford, TXThe pilot's failure to maintain clearance with the ground. Factors were the dark night, the rising terrain, and the ground fog obscuring the ground.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 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 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 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 FTW78DPA23Accident · No injuriesClosedPiper PA-34 · Addison, TXNTSB FTW75DQG18Accident · No injuriesClosedPiper PA-34 · Perryton, TXNTSB FTW74AF079Accident · 3 fatalClosedPiper PA-34 · Hockey, TX