NTSB investigations: Piper PA 46-350P, 1996
4 cases on aircraft the registry lists as Piper PA 46-350P. 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
| 1989 | 1 |
|---|---|
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 9 |
| 2011 | 7 |
| 2012 | 2 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 6 |
| 2024 | 3 |
| 2025 | 6 |
| 2026 | 3 |
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\") = 1996
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104620', '7104619', '7104627', '7104618'))
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") = 1996
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104620', '7104619', '7104627', '7104618'))
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 NYC97LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Myerstown, PAfatigue failure of the connecting rod to crankshaft attachments, due to inadequate overhaul of the engine by the manufacturer, which resulted in a loss of engine power and a forced landing. Factors relating to the accident included the discharge of oil from…NTSB SEA96LA164Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hillsboro, ORblockage of the vents to both wing fuel tanks, after unknown personnel failed to remove tape (protective covering) from the vents, which resulted in collapsed fuel tanks (and wing damage).NTSB CHI96FA083Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Carlyle, ILspatial disorientation of the pilot, and his failure to maintain control of the airplane, which resulted in his exceeding the design stress limits of the airframe. A factor relating to the accident was: turbulence in clouds.NTSB ATL96FA036Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Peachtree City, GAThe pilot's failure to follow the published instrument approach procedure. The fog was a factor.