NTSB investigations: Piper PA-46-310P
16 cases on aircraft the registry lists as Piper PA-46-310P, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2023 | 1 |
| 2024 | 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.\"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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB ERA23LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46 · Port Orange, FLThe pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees.NTSB GAA18CA312Accident · No injuriesData collectionFinal reportPiper PA 46 · Prescott, AZThe pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB WPR17FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-310P · Harrisburg, ORAn encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…NTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…NTSB GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.NTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…NTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…NTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB WPR10LA284Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Ontario, CAA loss of engine power due to the in-flight separation of the 1-3-5 cylinder induction tube elbow, which was caused by the improper installation of the induction tube elbow by maintenance personnel.NTSB ERA10FA195Accident · 1 fatalField investigationFinal reportPiper PA46 · Roanoke, VAA malfunction of the flight controls for undetermined reasons.NTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.NTSB CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.