NTSB investigations: Piper PA-46-310P, CA
11 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
| 1987 | 1 |
|---|---|
| 1991 | 2 |
| 1996 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 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\" = 'CA' 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 ('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 c."eventStateOrRegion" = 'CA' 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 ('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 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 WPR09LA341Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Westley, CAThe failure of the landing gear hydraulic line socket, which resulted in a hydraulic leak and in-flight fire. Contributing to the accident was the failure of the owner and/or maintenance facility to comply with the maintenance manual hose replacement schedule.NTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.NTSB LAX02FA004Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Van Nuys, CAThe failure of the air traffic controller to provide effective separation on the runway surface as specified in FAA Order 7110.65, Paragraph 3-9-6.NTSB LAX00FA322Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · So. Lake Tahoe, CAThe pilot's in-flight loss of control in the takeoff initial climb for undetermined reasons.NTSB LAX00FA208Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Hawthorne, CAA partial loss of power due to water contamination in the fuel system and the pilot's inadequate preflight inspection, which failed to detect the water. The pilot's failure to perform an engine run-up before takeoff is also causal. Additional causes are the…NTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.NTSB LAX96LA313Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Redlands, CAthe pilot's improper weather evaluation. The uphill runway condition and weather associated with thunderstorm(s) were related factors.NTSB LAX91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA 46 · North Hollywood, CAThe pilot-in-command's poor preflight planning, inadequate fuel consumption calculations which resulted in a loss of engine power due to fuel exhaustion, and the pilot-in-command's failure to follow air traffic control verbal instructions which would have…NTSB LAX91LA112Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Los Angeles, CAThe poor preflight planning performed by the pilot-in-command in accurately determining the weight and fuel consumption of the airplane which resulted in loss of engine power due to fuel exhaustion.NTSB LAX88FA060Accident · 1 fatalField investigationFinal reportPiper PA-46 · Long Beach, CAPilot's failure to land the aircraft after experiencing the pilot's faulty decision was his previous experience with a gear up landing a couple of years before.