NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 CHI93IA354Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · St. Louis, MOa failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB BFO93LA164Accident · No injuriesLimited investigationFinal reportCessna 402B · Eau Claire, PAThe separation of the number four cylinder on the airplane's left engine for undetermined reasons. A factor in the accident was the rough/uneven terrain.NTSB ANC93FA172Accident · Serious injuriesField investigationFinal reportInterstate S-1B2 Arctic Tern · Talkeetna River, AKThe pilot in command's improper preflight planning. Factors in the accident were: the rough/uneven takeoff location, the excess weight of the airplane, the inadequate design of the add-on tank by the manufacturer affecting the weight and balance, and the…NTSB SEA93LA193Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Price, UTThe failure of the pilot to maintain airspeed above stall.NTSB MIA93LA191Accident · 1 fatalLimited investigationFinal reportHudson Rans S-12 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering resulting in a stall/spin.NTSB MIA93LA189Accident · No injuriesLimited investigationFinal reportFerrie Ferri Exec · Delray Beach, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective) during a simulated autorotation, resulting in an in flight collision with terrain and subsequent roll over.NTSB MIA93FA190Accident · Serious injuriesField investigationFinal reportBeech 35 · Frisco, NCThe pilot's failure to maintain airspeed (vso) resulting in a stall/mush. Contributing to the accident was the near total loss of engine power due to separation of one of the two counterweights for undetermined reasons.NTSB LAX93LA345Accident · No injuriesLimited investigationFinal reportCessna 172G · Avalon, CAthe oil starvation related failure of the number 1 and 2 connecting rods due to improper torque of the crankcase through bolts at the number 2 cylinder, which allowed fretting of the bearing surfaces and the resulting closure of the oil ports. The under…NTSB LAX93LA344Accident · No injuriesLimited investigationFinal reportCessna 182A · Potrero, CAThe overload failure of the upper nose gear torque link and the subsequent separation of the nose wheel and fork assembly from the nose gear strut. A factor in the accident was the surface irregularity in the dirt landing strip.NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.NTSB BFO93LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stowe, VTThe pilot's improper in-flight planning/decision. A related factor in the accident was: the partial loss of engine power for an undetermined reason.NTSB BFO93LA162Accident · No injuriesLimited investigationFinal reportSterner Super CAT · Cherryville, PAThe movement of a thumbscrew on the fuel filter system which resulted in fuel flow blockage and subsequent partial power loss. A factor in this accident was the lack of suitable terrain for the emergency landing.NTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.NTSB BFO93LA160Accident · No injuriesLimited investigationFinal reportSmyth Sidewinder · Point Pleasant, WVThe pilot's failure to maintain a proper glidepath.NTSB ANC93LA171Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Ptarmigan Pass, AKThe pilot inadvertently walked into a turning propeller. Factors in the accident were the soft runway which mired the airplane and the pilot's diverted attention during the attempt to free the airplane.NTSB ANC93LA169Accident · No injuriesLimited investigationFinal reportCessna 180 · Sweet Lucy Lake, AKThe pilot in command's improper preflight planning and decision making. A factor in the accident was the high wind conditions.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB SEA93LA192Accident · No injuriesLimited investigationFinal reportWestholm Vans RV-6 · Salmon, IDThe inadequate preflight planning/preparation by the PIC in his failure to close the fuel drain valve. A factor relating to the accident was the fence post located in the landing area.NTSB SEA93LA191Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bryce Canyon, UTLoss of engine power for an undetermined reason. Factors related to the forced landing were: high density altitude and rough terrain.NTSB SEA93FA194Accident · 1 fatalField investigationFinal reportCessna 182D · Lucile, IDThe pilot's failure to maintain airspeed resulting in an aerodynamic stall. The mountainous terrain was a factor.NTSB MIA93WA188Accident · No injuriesForeign investigationBeagle B 206 Series 1 · Freeport, BahamasNTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.NTSB LAX93LA346Accident · No injuriesLimited investigationFinal reportCessna 150L · Chemehuevi Valy, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB LAX93LA343Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marble Canyon, AZfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft either prior to departure or enroute.NTSB FTW93LA257Accident · 1 fatalLimited investigationFinal reportBeech C-45H · Fentress, TXInadvertent deployment of the skydiver's reserve parachute for undetermined reasons.NTSB FTW93LA252Accident · 1 fatalLimited investigationFinal reportMascola Christen Eagle II · Palo Pinto, TXThe pilot's intentional stall at an altitude insufficient to allow a safe recovery.NTSB FTW93FA255Accident · 7 fatalField investigationFinal reportGates Learjet 25D · Pecos, NMWas physical impairment of the pilot in command from alcohol and drugs. A factor was the first officer's lack of experience in the lear jet.NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB BFO93LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Inlet, NYthe blocked header tank fuel port which resulted in fuel starvation. A factor to the accident were the high obstructions in the emergency landing area.NTSB BFO93LA158Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Block Island, RIImproper in-flight planning/decision by the pilot, and his failure to attain proper runway alignment.NTSB BFO93LA157Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Oak Grove, KYThe pilot's innacurate preflight fuel consuption calculations and inadequate in-flight planning/decisions, which resulted in fuel exhaustion and subsequent loss of engine power. A factor related to the accident was: high obstructions in the emergency landing…NTSB ATL93FA151Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Laurinburg, NCThe pilot's VFR flight into instrument meteorological conditions (IMC), failure to maintain control of the aircraft after becoming spatially disoriented, and inadvertently exceeding the design stress limits of the aircraft. Factors related to the accident…NTSB ATL93FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stone Mountain, GAThe pilot-in-command's improper use of the aircraft stabilator during the takeoff, and his failure to maintain airspeed, which resulted in an inadvertant stall. A factor was the high obstructions (trees) located near the departure end of the runway.NTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB FTW93LA253Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Weatherford, TXFuel exhaustion. Factors were: the pilot's failure to have the airplane serviced to capacity prior to departure, and his erroneous fuel consumption calculations.NTSB FTW93FA251Accident · 3 fatalField investigationFinal reportCessna 182C · Porter, TXPartial loss of engine power for undetermined reasons. Factors in the accident which may have contributed were the distorted and separated muffler components resulting from improper maintenance by an unknown person.NTSB CHI93LA353Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 Twin Astir · New Douglas, ILFailure of the glider tow attachment. Factors related to the accident were the improper emergency procedure by the student, and the flight instructor's delayed remedial action..NTSB BFO93LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia Stn, OHThe pilot's delay in initiating a go-around (aborted landing), and his improper raising of the flaps at a low airspeed after lift-off, which resulted in a stall/mush. A factor related to the accident was: the pilot's failure to attain the proper touchdown…NTSB BFO93LA156Accident · 1 fatalLimited investigationFinal reportCessna 172P · Pembroke, VAThe pilot's failure to maintain proper altitude while manuevering in mountainous terrain.NTSB BFO93LA155Accident · Serious injuriesLimited investigationFinal reportDouglas MD-88 · Lexington, KYThe cabin attendant did not follow published procedures.NTSB ATL93LA149Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Tuscaloosa, ALFouled spark plugs on the number 2 and 3 cylinders, and a lack of compression on the number 1 and 4 cylinders, which resulted in a loss of engine power. A factor was the high vegetation at the forced landing site.NTSB SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.NTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB FTW93LA272Accident · 1 fatalLimited investigationFinal reportCoen Benson B8 · Aurora, COFatigue failure of the center engine mount that altered the thrust and lift vectors.NTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.NTSB CHI93LA348Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Blakesburg, IAThe pilot's failure to maintain clearance with the fence post and his midjudging the airplane glidepath.NTSB BFO93FA153Accident · Serious injuriesField investigationFinal reportMooney M20J · Mitchellville, MDCorrosion in the fuel control unit, which resulted in fuel starvation and loss of engine power. Related factors were: inadequate maintenance, and the lack of suitable terrain for an emergency landing.