NTSB investigations: Piper PA-32R-301T, 1985
4 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\") = 1985
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") = 1985
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 DEN85LA188Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Glen Canyon, UTThe plt said that during the takeoff roll at night from an unlit runway, he was distracted when the engine overboost light illuminated. The investigation revealed, however, that the plt was actually trying to avoid colliding with an airplane at the other end…NTSB DEN85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lordsburg, NMThe plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…NTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…NTSB MIA85LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · W. Palm Beach, FLWhile en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did…