NTSB investigations: Piper PA-32R-301, 1983
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\") = 1983
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") = 1983
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 ANC84LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Barrow, AKThe plt stated that shortly after reaching cruise altitude the eng failed. A forced landing was made on tundra covered by encrusted snow & ice nad the gear collapsed. During the on-scene investigation the fuel injector was found to allow only a small amount…NTSB CHI83LA373Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Wheeling, ILThe pilot stated that he taxied southeast on runway 12L, then turned to taxi northwest on runway 34. During the turn, the left main gear went off the runway and into a hole in the sod. The width of runway 12L is 50 ft and the width of runway 34 is 100 ft. the…NTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…NTSB ATL83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Leonardtown, MDPilot did not maintain alignment during takeoff and collided with a pile driver. The aircraft was then landed gear up inan adjacent field. The wind was calm and there was no known reason for failure to maintain runway alignment.NTSB ANC83LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Wainwright, AKThe aircraft ran off the departure end of the runway during landing. A passenger stated that the aircraft touched down at about mid-field at a higher than normal airspeed and bounced once before sliding off the end of the runway. The gravel runway was covered…NTSB MIA83LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-301R · Near Vero Beach, FLThe acft collided with tree tops during a night flight but the pilot was able to maintain control and land at a nearby airport. According to the pilot he was on approach to fort pierce airport when the accident occurred. However according to some witnesses…