NTSB investigations: Piper PA-34-200T, 1991
9 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
| 1971 | 1 |
|---|---|
| 1975 | 4 |
| 1976 | 5 |
| 1977 | 8 |
| 1978 | 10 |
| 1979 | 9 |
| 1980 | 17 |
| 1981 | 12 |
| 1982 | 14 |
| 1983 | 11 |
| 1984 | 8 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 6 |
| 2009 | 5 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 1991
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 year(c."eventDate") = 1991
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 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 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…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.NTSB MIA92WA026Accident · 2 fatalForeign investigationPiper PA-34-200T · Atlantic Ocean (Atlantic Ocean)NTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…NTSB FTW91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Orleans, LAThe pilot's improper recovery from a bounced landing. A factor was: the pilot's lack of total experience in model.NTSB NYC91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Arcadia, RIInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the lack of a suitable area for a forced landing.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 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.