NTSB investigations: Piper PA-32RT-300T, 1985
6 cases on aircraft the registry lists as Piper PA-32RT-300T. 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
| 1964 | 1 |
|---|---|
| 1967 | 2 |
| 1978 | 2 |
| 1979 | 9 |
| 1980 | 10 |
| 1981 | 7 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 7 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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\") = 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 ('7103216'))
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 ('7103216'))
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 BFO86FA002Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Gaithersburg, MDThe plt was clrd for a VOR rwy 14 apch. On apch, he rprtd at the sleet intxn (a fix on the NDB apch). The acft was then seen flying ovr the arpt on an easterly hdg. UNICOM operator said he then heard the plt call "turning final." However, bfr lndg, the acft…NTSB FTW85LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Brownsville, TXWhile practicing touch-and-go landings the plt allowed the acft to descend below the proper glide slope while on final apch. The acft impacted a power line aprx 1000 ft short of the rwy and crashed on the side of a drainage ditch levee. The elevation of the…NTSB MIA85FA202Accident · Minor injuriesField investigationFinal reportPiper PA-32RT-300T · Pembroke Pines, FLThe acft experienced a complete in flt loss of his prop after departure from north perry arpt hollywood FL due to a fatigue failure of the prop hub. The fatigue cracking was due to residual stress resulting from deformation of the material in the hub ass'yNTSB CHI85FA258Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Merom, INThe aircraft was on a visual flight from fairfield Iowa to indianapolis, IN and was about 55 mautical miles south of course when the aircraft broke up in flight. The main wreckage, empennage, and outer wing sections landed within about a quarter of a mile of…NTSB CHI85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32T-300 · Milwaukee, WIThe pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.NTSB LAX85FA130Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Bishop, CAThe plt rptd that shortly after leveling off at 11500 ft MSL, the engine exploded causing both windscreens to be covered with oil and fire. The fire stopped during the emergency descent. The acft landed on ry 30 at Bishop arpt, Bishop, CA without further…