NTSB investigations: Piper PA-32R-300, 1982
7 cases on aircraft the registry lists as Piper PA-32R-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
| 1965 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 9 |
| 1977 | 15 |
| 1978 | 22 |
| 1979 | 13 |
| 1980 | 12 |
| 1981 | 12 |
| 1982 | 7 |
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 6 |
| 1989 | 10 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 4 |
| 1993 | 8 |
| 1994 | 10 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 6 |
| 2007 | 1 |
| 2008 | 5 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103213'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103213'))
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 SEA83LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Gustavus, AKThe pilot reported that slush accumulation on the runway prevented the aircraft from reaching takeoff speed. He aborted the takeoff and with braking action "nil" slid off the end of the runway. Gustavus airport is owned and operated by the state of Alaska and…NTSB FTW82DA335Accident · No injuriesFinal reportPiper PA-32R-300 · Alexandria, LAThe purpose of the flight was to prepare the pilot in the left seat for a commercial flight rating. After a power-off descent from 4000 ft to 2000 ft, the instructor gave the student a simulated forced landing. Reportedly, the throttle was opened briefly at…NTSB ATL82FLT04Accident · 3 fatalFinal reportPiper PA-32R-300 · Iuka, MSThe aircraft crashed during a pass across the airport. A witness was parked, facing east, in the runup area for runway 18. According to him, the the aircraft took off about 6 minutes earlier, made a traffic pattern, and crashed behind and to his right. The…NTSB MIA82DA091Accident · No injuriesFinal reportPiper PA-32R · Moca, PRThe pilot landed on an unlighted grass strip at night with a load of marijuana. During the landing, the plane continued off the strip and into a sugar cane field.NTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…NTSB LAX82DVG19Accident · No injuriesFinal reportPiper PA-32R · Brownsville, CAThe pilot stated that the aircraft did not touchdown until halfway down the runway and he then applied too much left brake resulting in the aircraft running off the left side of the runway. Before coming to a stop the left landing gear collapsed.NTSB ATL82FA047Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Lambsburg, VAThe aircraft was on an air taxi flight to transport 2 prisoners and was to be operated on a VFR flight plan in VFR conditions only. Prior to takeoff, the pilot had obtained 12 weather briefing. In 2 of the briefings, VFR flight was not recommended. At about…