NTSB investigations: Piper PA 46-350P, 2016
5 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\") = 2016
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") = 2016
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 GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA139Accident · No injuriesData collectionFinal reportPiper PA46 · Midland, VAThe pilot’s improper landing flare and subsequent hard landing while demonstrating a short-field landing and the flight instructor’s delayed remedial action.NTSB WPR16LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Seattle, WAThe pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB GAA16CA107Accident · Minor injuriesData collectionFinal reportPiper PA 46 · Ottawa, KSThe flight crews encounter with un-forecasted freezing rain resulting in an uncontrolled descent, forced landing, and substantial damage to the airplane's firewall, and forward pressure bulkhead.