NTSB investigations: Piper PA-32R-301T, 2004
6 cases on aircraft the registry lists as Piper PA-32R-301T. 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
| 1968 | 1 |
|---|---|
| 1970 | 1 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 8 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
| 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\") = 2004
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103220', '7103221'))
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") = 2004
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103220', '7103221'))
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 CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…NTSB LAX05FA032Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Santa Barbara, CAThe pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…NTSB SEA04LA180Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Picabo, IDThe pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.NTSB NYC04FA170Accident · 5 fatalField investigationFinal reportPiper PA-32R-301T · Wheeling, WVThe pilot's failure to maintain terrain clearance while executing an instrument approach. A factor was the night instrument meteorological conditions.NTSB LAX04FA177Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Ukiah, CAThe non-instrument rated pilot's flight intentional flight into instrument meteorological conditions during takeoff-initial climb, which resulted in spatial disorientation, a subsequent loss of aircraft control, and an uncontrolled descent into terrain. A…NTSB FTW04CA061Accident · No injuriesData collectionFinal reportPiper PA-32R · Poynor, TXThe pilot's failure to maintain aircraft control while on final approach. A factor was the downdraft.