NTSB investigations: Piper PA-46-310P, 1986
4 cases on aircraft the registry lists as Piper PA-46-310P. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 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\") = 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 ('7104605', '7104611', '7104624'))
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 ('7104605', '7104611', '7104624'))
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 NYC86FA213Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · West Mifflin, PAAt 2232 EDT, the acft was climbing to 15000 feet when the pilot reported a low oil pressure light. ATC advised jimmy stewart field is about eleven thirty and 15 miles. After the pilot asked, 'is that a tower field?', ATC advised he did not know, westmoreland…NTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…NTSB CHI86FA108Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Boyne Falls, MIAfter the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…NTSB SEA86IA080Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Reno, NVAt FL250 the engine ceased operating due to a failed fuel pump. A restart was successful at 10,000 feet m.s.l. with an uneventful landing. This fuel pump (a model g) had a total time of three hours. It was a replacement for a model c fuel pump which had…