NTSB investigations: Piper PA-28R-201, 1986
5 cases on aircraft the registry lists as Piper PA-28R-201. 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
| 1977 | 5 |
|---|---|
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833'))
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 LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…NTSB CHI86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chicago, ILThe pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from…NTSB NYC86LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · West Dover, VTShortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.NTSB MIA86FA110Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Ocklawaha, FLThe pvt plt refueled his acft the night before the flt and was observed to drain only the firewall strainer. The morning of the flt he did not drain any drains. About half way to his destination an eng pwr loss was experienced, he declared an emergency and…NTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.