NTSB investigations: Piper PA-34-220T, 2003
4 cases on aircraft the registry lists as Piper PA-34-220T. 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
| 1973 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 4 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2003
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103420', '7103223'))
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") = 2003
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103420', '7103223'))
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 LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB CHI03LA279Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Port Huron, MIThe pilot misjudging the flare during landing, and his inadequate remedial action resulting in the inadvertent porpoise of the airplane.NTSB IAD03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Burnet, TXThe pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…NTSB SEA03FA042Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Rexburg, IDThe pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.