NTSB investigations: Piper PA-32R-301, 1993
6 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\") = 1993
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") = 1993
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 NYC94LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-301T · Norwood, MAThe pilot's delay in aborting the takeoff which resulted in a overrun of the runway. Factors were a snow covered runway, takeoff speed not attained, brakes not used, and a ditch.NTSB BFO94FA021Accident · 1 fatalField investigationFinal reportPiper PA32R-301 · Butler, PAThe pilot's inadvertent flight into IMC conditions and his failure to maintain proper altitude. The weather conditions were a factor.NTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.NTSB NYC93FA080Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Lapeer, NYThe pilot's improper inflight decision to continue flight into known icing conditions. Factors which contributed to the accident were: the pilot's failure to obtain updated weather information prior to departure, the icing conditions, and the degraded…NTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…NTSB MIA93LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Titusville, FLLoss of engine power during the downwind leg for undetermined reasons, poor in-flight planning/decision by the dual student, and inadequate supervision by the pilot-in-command (CFI).