NTSB investigations: Piper PA46-500TP, FL
7 cases on aircraft the registry lists as Piper PA46-500TP. 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
| 2001 | 2 |
|---|---|
| 2003 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104622', '7104623'))
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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104622', '7104623'))
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 ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA13CA278Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · West Palm Beach, FLThe pilot’s diversion of attention while taxiing the airplane, which resulted in his failure to maintain directional control and collision with a ditch.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB CHI04FA043Accident · 2 fatalField investigationFinal reportPiper PA46-500TP · Daytona Beach, FLThe unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.NTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.