NTSB investigations: Piper PA-32RT-300, 1984
5 cases on aircraft the registry lists as Piper PA-32RT-300. 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
| 1978 | 5 |
|---|---|
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 5 |
| 1982 | 4 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 6 |
| 1988 | 1 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 4 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
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 CHI84FA315Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sandwich, ILPilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.NTSB LAX84LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Avalon, CAThe plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the…NTSB CHI84LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Lima, OHHeavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…NTSB ATL84FA083Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Attalla, ALDuring a VOR approach to land in IMC wx, the acft collided with a tree. The non-instrument rated plt had filed an IFR flt plan on this and other occasions even though he was not qualified. During this approach, the descent was continued past the mda of 960…NTSB ATL84FA080Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Basye, VAAfter the acft landed, slush was observed to have accumulated under the wings & lower aft fuselage & was freezing. The acft was parked with the tail facing the sun, but none of the arpt personnel noticed whether the sun had melted the ice. The plt indicated…