Skip to content

NTSB investigations · 49

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('7103120', '7103144') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('7103120', '7103144')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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…Jul 20, 2023 · N200RA · Destroyed 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.May 21, 2021 · N575BC · Destroyed NTSB ERA19LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 31P · East Brady, PAA total loss of left engine power for undetermined reasons.Aug 20, 2019 · N90AP · Substantial damage 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.Mar 8, 2018 · N82605 · Destroyed NTSB CEN16LA189Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Killeen, TXThe pilot’s failure to extend the landing gear due to his distraction with the flaps, his misinterpretation of the landing gear warning horn, and his failure to verify that the landing gear were down, which resulted in a landing with the gear retracted.Apr 30, 2016 · N192CS · Substantial damage NTSB CEN16LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA31 · Denton, TXThe total loss of engine power due to fuel exhaustion for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Jan 22, 2016 · N997DN · Substantial damage NTSB CEN14RA340Accident · 11 fatalForeign investigationPiper PA 31P · Czestochowska, PolandJul 5, 2014 · N11WB · Destroyed NTSB WPR14LA051Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Calexico, CAThe pilot’s failure to maintain the proper pitch attitude during the landing, which resulted in the nose landing gear contacting the surface hard and then separating from the airplane.Oct 12, 2013 · N14TG · Substantial damage NTSB ERA13LA409Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Doylestown, PAA leaking parking brake valve, which allowed air to enter the left brake line and resulted in the eventual failure of the left wheel brake during the landing roll.Sep 8, 2013 · N57JK · Substantial damage NTSB 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…Jun 30, 2012 · N33CG · Substantial damage NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoSep 12, 2011 · N69DJ · Destroyed NTSB CEN10WA096Accident · 2 fatalForeign investigationPiper PA-31P · Kidlington, United KingdomJan 15, 2010 · N95RS · Destroyed NTSB DEN07LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Newton, KSThe failure of the exhaust gasket on the number 6 cylinder for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 28, 2007 · N7325L · Substantial damage NTSB ATL05LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-31P · Fort Payne, ALThe loss of engine power due to the failure of the aft clamp connecting the turbocharger compressor outlet to the intercooler ducting which resulted in reduced aircraft performance during takeoff.Jun 30, 2005 · N4200N · Substantial damage NTSB 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.Dec 29, 2004 · N573B · Destroyed 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.Aug 20, 2004 · N57EF · Destroyed 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…Jun 16, 2003 · N577FS · Destroyed 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…May 25, 2003 · N36DR · Destroyed 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.Mar 18, 2002 · N125TT · Destroyed 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.Sep 27, 1999 · N100EE · Destroyed 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.Sep 27, 1993 · N891SP · Destroyed NTSB CHI93LA304Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Coffeyville, KSUndetermined.Aug 2, 1993 · N25TC · Substantial damage NTSB LAX93FA066Accident · 2 fatalField investigationFinal reportPiper PA-31P · Oceanside, CAThe airplane colliding with the ocean due to unknown reason (s).Dec 14, 1992 · N55UF · Destroyed NTSB LAX92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Tonopah, NVThe pilot's failure to assure that there was an adequate supply of fuel in the airplane to complete the flight due to alcoholic impairment of efficiency and judgement resulting in a total loss of power of both engines.Jan 25, 1992 · N7325L · Substantial damage 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.Jan 2, 1992 · N500BH · Destroyed NTSB MIA91WA093Accident · No injuriesForeign investigationPiper PA-31P · Atlantic Ocean (Atlantic Ocean)Mar 7, 1991 · N666SC · Substantial damage 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…Jun 17, 1988 · N560JB · Destroyed 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…Feb 26, 1985 · N404RS · Destroyed NTSB MKC84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Olathe, KSAt FL240, a fire broke out in the rgt eng compartment. The plt indicated that the eng turbo-charger was malfunctioning. The plt shut down the eng & asked for radar vectors to johnson county executive arpt. The fire went out at 21,000 ft & the acft landed…Mar 9, 1984 · N3TB · Substantial damage NTSB FTW83LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Nacogdoches, TXDuring arrival, a landing was made at night IMC conditions with low ceilings, heavy rain & gusty winds. The plt reported that during the landing, there was a x-wind component, light turbulence & a wind shift. Reportedly the acft was landed aprx half way down…Feb 21, 1983 · N7334L · Substantial damage NTSB FTW82IA209Incident · No injuriesIncident investigationFinal reportPiper PA-31P-135 · Lake Charles, LAWhile cruising at FL200 in VMC conditions, the pilot smelled and then observed smoke coming from the windshield defrosters and under the instrument panel. He advised houston center of his situation, then turned off all electrical equipment and made an…May 28, 1982 · N222SA · Minor damage NTSB MKC82DA087Accident · No injuriesFinal reportPiper PA-31P · Salina, KSAccording to the pilot, the left engine began running rough at about 300 ft AGL after takeoff and the roughness was accompanied by a slight left yaw. The pilot said the left engine was producing some power so he elected not to feather the propeller. The…May 21, 1982 · N40NC · Substantial damage NTSB ATL81FA094Accident · 1 fatalClosedPiper PA-31P · Wilmington, NCJul 11, 1981 · N7318L · Destroyed NTSB CHI81FEC12Accident · Minor injuriesClosedPiper PA-31P · Pontiac, MIJan 28, 1981 · N222EB · Substantial damage NTSB ATL80FA072Accident · 1 fatalClosedPiper PA-31P · Charleston, SCJul 10, 1980 · N776SW · Destroyed NTSB MIA80FA066Accident · No injuriesClosedPiper PA-31P · Ocala, FLJun 4, 1980 · N7651L · Destroyed NTSB UNK79X0103Accident · No injuriesClosedPiper PA-31 · Toronto, CanadaNov 26, 1978 · N777GM · Substantial damage NTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WAOct 8, 1977 · N117HC · Destroyed NTSB OAK77FA048Accident · No injuriesClosedPiper PA-31P · Modesto, CAAug 19, 1977 · N7670L · Substantial damage NTSB DEN77DA006Accident · No injuriesClosedPiper PA-31P · Alamosa, COOct 30, 1976 · N66827 · 2 aircraft · Substantial damage NTSB MKC76FCG36Accident · No injuriesClosedPiper PA-31P · Platte City, MONov 14, 1975 · N7302L · Substantial damage NTSB MKC76FCA11Accident · No injuriesClosedPiper PA-31P · Cape Girardeau, MOOct 23, 1975 · N7336L · Substantial damage NTSB SEA75KYI18Accident · Serious injuriesClosedPiper PA-31P · North Bend, ORDec 6, 1974 · N104RE · Substantial damage NTSB CHI74AC063Accident · 4 fatalClosedPiper PA-31P · Willoughby H, OHJan 25, 1974 · N7672L · Destroyed NTSB MKC74FCQ22Accident · No injuriesClosedPiper PA-31P · Wichita, KSJan 12, 1974 · N33CG · Substantial damage NTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WADec 27, 1973 · N66798 · Destroyed NTSB FTW74DPG07Accident · No injuriesClosedPiper PA-31 · West Helena, ARJul 27, 1973 · N117HC · Substantial damage NTSB MIA73AM109Accident · 1 fatalClosedPiper PA-31P · Tampa, FLJun 15, 1973 · N6840L · Destroyed NTSB NYC73IN105Incident · No injuriesClosedPiper PA-31P · Linden, NJJan 26, 1973 · N6840L · Minor damage

Back to Piper PA-31P