NTSB investigations: Piper PA-32R-301, 2003
4 cases on aircraft the registry lists as Piper PA-32R-301. 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
| 1980 | 1 |
|---|---|
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 5 |
| 1987 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 6 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 5 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 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\") = 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 ('7103218'))
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 ('7103218'))
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 ATL04FA023Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spencer, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and the subsequent collision with the ground.NTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.NTSB DEN03LA134Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Logan, UTthe loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…NTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…