NTSB investigations: Piper PA-31-350, 1986
7 cases on aircraft the registry lists as Piper PA-31-350. 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
| 1974 | 1 |
|---|---|
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 10 |
| 1979 | 7 |
| 1980 | 5 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 9 |
| 1990 | 11 |
| 1991 | 9 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 7 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 9 |
| 1998 | 11 |
| 1999 | 11 |
| 2000 | 10 |
| 2001 | 7 |
| 2002 | 8 |
| 2003 | 3 |
| 2004 | 9 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 8 |
| 2008 | 6 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
Where
Latest 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 ('7103110', '7103125'))
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 ('7103110', '7103125'))
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 MIA87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homestead, FLThe plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway…NTSB LAX87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Eleele Kauai, HIA Piper pa 31-350 lost power and collided with sign posts after landing on a road. It was reported to the FAA that the aircraft's right engine was producing partial power and the aircraft was unable to maintain altitude on the left engine. The pilot never…NTSB ANC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Barrow, AKThe plt stated there were mechanical problems with the acft but it was decided to fly it back to another arpt for repairs. Enroute the plt shut down the right eng because of an oil leak. While attempting to crossfeed fuel, the plt accidently pushed the left…NTSB ANC86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nulato, AKA witness on the ground watched the airplane fly the landing pattern for landing and at no time did he see the landing gear extend. He watched the airplane until it passed below the tree line. Testing of the hydro-mechanical and electrical systems did not…NTSB MIA86FA112Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Homestead, FLThe flt was nearing completion of a 4.2 hr x-country flt & was aprx 7 miles from the dest when both engs quit due to fuel exhaustion. A forced ldg was performed. The plt stated the acft had departed with a full fuel load of 182 gals. The acft owner stated…NTSB MIA86LA109Accident · 6 fatalLimited investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)The acft failed to arrive at it's destination on a VFR flight from miami FL, to west end, Bahamas. The acft's last reported position was 10 miles west of west end. There was no further contact with the acft. U.S. Coast guard initiated search on March 26, 1986…NTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…