Fatal NTSB investigations: Piper PA-31P
24 cases on aircraft the registry lists as Piper PA-31P. 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
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103120', '7103144'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103120', '7103144'))
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 CEN23FA314Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Kearney, MOThe pilot’s decision to operate an airplane with known fuel leaks, his failure to conduct an engine run-up before takeoff, his subsequent failure to abort the takeoff, and the mechanic’s inadequate maintenance, which resulted in a partial loss of right engine…NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.NTSB CEN14RA340Accident · 11 fatalForeign investigationPiper PA 31P · Czestochowska, PolandNTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB CEN10WA096Accident · 2 fatalForeign investigationPiper PA-31P · Kidlington, United KingdomNTSB DEN05FA045Accident · 1 fatalField investigationFinal reportPiper PA-31P · Gallup, NMthe pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.NTSB IAD04FA040Accident · 1 fatalField investigationFinal reportPiper PA-31P · Clarkson, NYThe pilot's mismanagement of the fuel by his failure to select the proper fuel tank which resulted in starvation and subsequent loss of engine power in both engines.NTSB ATL03FA107Accident · 2 fatalField investigationFinal reportPiper PA-31P · Augusta, GAThe pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…NTSB CHI03FA138Accident · 4 fatalField investigationFinal reportPiper PA-31P · Woodruff, WIThe pilot's failure to follow the before take-off checklist which led to an improper selection of the auxilliary fuel tanks for the takeoff leading to the subsequent fuel starvation of the left engine. Additional causes were the pilot not maintaining minimum…NTSB CHI02FA094Accident · 2 fatalField investigationFinal reportPiper PA-31P · Daleville, INThe pilots failure to maintain control of the airplane during the instrument approach. The low overcast ceiling and the pilot's in-flight decision to execute the instrument approach in below minimum weather conditions were factors.NTSB MIA99FA269Accident · 1 fatalField investigationFinal reportPiper PA-31P · Louisville, MSThe pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.NTSB FTW93FA267Accident · 1 fatalField investigationFinal reportPiper PA-31P · San Antonio, TXFailure by the pilot-in-command to maintain VMC following takeoff. Factors were: partial loss of power to one engine for undetermined reason, and lack of total experience in aircraft type.NTSB LAX93FA066Accident · 2 fatalField investigationFinal reportPiper PA-31P · Oceanside, CAThe airplane colliding with the ocean due to unknown reason (s).NTSB CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.NTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…NTSB MKC85FA062Accident · 3 fatalField investigationFinal reportPiper PA-31P · Sunset Hills, MOThe acft was on a ngt instructional flt with 2 multi-eng instructor plts at the controls & a rated plt occupying a rear pax seat. The rgt fnt seat occupant was an experienced multi-eng plt with 110 hrs in this make & model; however, his 2NDCLASS med cert was…NTSB ATL81FA094Accident · 1 fatalClosedPiper PA-31P · Wilmington, NCNTSB ATL80FA072Accident · 1 fatalClosedPiper PA-31P · Charleston, SCNTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WANTSB CHI74AC063Accident · 4 fatalClosedPiper PA-31P · Willoughby H, OHNTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WANTSB MIA73AM109Accident · 1 fatalClosedPiper PA-31P · Tampa, FL