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.

NTSB CHI99LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Lincoln, KSthe altitude/clearance not obtained by the pilot and the unsuitable takeoff area selected by the pilot. Factors to the accident were the high, soft, and wet grass runway.May 16, 1999 · N9275R · Substantial damageNTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.May 16, 1999 · N20417 · Substantial damageNTSB ATL99LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dickson, TNThe loss of engine power due to undetermined reasons. A factor was uneven terrain.May 16, 1999 · N414AA · Substantial damageNTSB ANC99LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe inadequate preflight by the pilot, who left the rudder gust lock installed, making directional control not possible.May 16, 1999 · N8883C · Substantial damageNTSB SEA99LA063Accident · No injuriesLimited investigationFinal reportLake LA-4 · Coeur D'Alene, IDThe fatigue failure of a repair weld on one of the engine pylon mount straps and the resultant reduction in directional control. Factors include an inadequate repair of the strap, variable wind speeds and sudden wind shifts.May 15, 1999 · N152WB · Substantial damageNTSB FTW99LA142Accident · Minor injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/L · Edna, TXThe inadvertent stall by the pilot during a go-around. A factor was the pilot's failure to maintain directional control during the landing roll.May 15, 1999 · N91MS · Substantial damageNTSB CHI99LA151Accident · No injuriesLimited investigationFinal reportEngleman Pitts S1 · Mattoon, ILThe pilot's failure to maintain directional control and inadvertent ground loop/swerve. A related factor was the crosswind.May 15, 1999 · N64DE · Substantial damageNTSB ATL99LA091Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brooksville, FLThe certified flight instructor's failure to recover from a porpoise during landing and his failure to maintain directional control.May 15, 1999 · N8055Y · Substantial damageNTSB ATL99LA089Accident · Serious injuriesLimited investigationFinal reportBoyd Dan MONO-WHEEL; Euro · Smith, ALThe loss of engine power for undetermined reasons.May 15, 1999 · N216JE · Substantial damageNTSB ANC99TA061Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind.May 15, 1999 · N7051 · Substantial damageNTSB LAX99LA184Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Buckeye, AZFailure of the pilot to maintain directional control of the airplane during the landing rollout.May 14, 1999 · N9661S · Substantial damageNTSB FTW99LA141Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Roanoke, TXThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 14, 1999 · N2343Y · Substantial damageNTSB FTW99LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownwood, TXThe failure of the pilot-in-command to use the manufacturer's published checklist and extend the flaps prior to takeoff. A factor was the pilot's fatigued physiological condition as a result of extended flight and ground duty hours.May 14, 1999 · N4329S · DestroyedNTSB DEN99LA078Accident · No injuriesLimited investigationFinal reportBell/Mason RV-6 · Albuquerque, NMThe loss of aircraft control for undetermined reasons. Factors were the sudden wind shift and wind gusts weather condition.May 14, 1999 · N107BB · Substantial damageNTSB ATL99LA087Accident · No injuriesLimited investigationFinal reportCessna T188C · Bruce, MSThe loss of lubrication to the number 2 connecting rod due to the shifted bearing that resulted in the total loss of engine power.May 14, 1999 · N1994J · Substantial damageNTSB ATL99LA086Accident · No injuriesLimited investigationFinal reportBeech BE-100 · Hickory, NCThe failure of the landing gear actuator due to the improper installation of the lower thrust bearing by maintenance personnel.May 14, 1999 · N924RM · Substantial damageNTSB FTW99LA139Accident · No injuriesLimited investigationFinal reportCessna 175B · Spur, TXThe total loss of engine power during cruise flight for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 13, 1999 · N8133T · Substantial damageNTSB DEN99FA077Accident · No injuriesField investigationFinal reportCessna 172Q · Greeley, COFailure of both the pilot receiving instruction and the flight instructor to maintain a visual lookout. A factor was the failure of the other pilot to maintain a visual lookout.May 13, 1999 · N96299 · 2 aircraft · Minor damageNTSB ATL99LA085Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Louisville, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.May 13, 1999 · N36493 · Substantial damageNTSB ATL99LA084Accident · No injuriesLimited investigationFinal reportCessna 195A · Tupelo, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop/swerve and subsequent nose over.May 13, 1999 · N4478C · Substantial damageNTSB NYC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Chambersburg, PAThe loss of engine power for undetermined reasons.May 12, 1999 · N5938Z · Substantial damageNTSB MIA99LA155Accident · 1 fatalLimited investigationFinal reportAero Commander 500B · Atlantic Ocean (Atlantic Ocean)an in-flight collision with water for undetermined reasons, due to the wreckage never being recovered from the water.May 12, 1999 · N6138X · DestroyedNTSB LAX99LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lucerne Valley, CAthe pilot's failure to refuel the airplane and improper fuel consumption calculations.May 12, 1999 · N66487 · Substantial damageNTSB FTW99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe flight instructor's inadequate supervision resulting in an inadvertent stall/spin by the student pilot.May 12, 1999 · N4608Q · DestroyedNTSB LAX99LA182Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Stovepipe Wells, CAfuel exhaustion resulting from the pilot becoming lost and disoriented on a cross-country flight.May 11, 1999 · N9603J · Substantial damageNTSB LAX99LA179Accident · No injuriesLimited investigationFinal reportHamilton Pitts Special SC-1 · Sacramento, CAThe pilot's misjudged flare, which led to bounced landing, and his failure to maintain directional control of the aircraft during the bounced landing recovery.May 11, 1999 · N23NL · Substantial damageNTSB FTW99LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Huffman, TXThe pilot's inadequate compensation for the wind conditions during landing. Factors were the wind gusts and the high vegetation beside the runway.May 11, 1999 · N166MM · Substantial damageNTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…May 11, 1999 · N7082A · No damageNTSB ATL99LA083Accident · 1 fatalLimited investigationFinal reportMichael W. Campbell Lancair 320 · Tallessee, ALThe pilot's failure to maintain flying speed during the takeoff to initial climb that resulted in the a stall and the inflight collision with the trees.May 11, 1999 · N6111 · Substantial damageNTSB MIA99LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rock Hill, SCThe pilot's failure to maintain directional control. Related factors were the crosswind and the pilot's lack of experience.May 10, 1999 · N7173R · Substantial damageNTSB CHI99TA149Accident · Minor injuriesFinal reportCessna 180J · Necedah, WIThe pilot's failure to maintain compensation for the wind conditions. A factor was the gusting tailwind.May 10, 1999 · N59DW · Substantial damageNTSB CHI99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-L21B · Vincennes, INthe pilot's failure to maintain directional control after landing. Factors which contributed to this accident were the pilot's long touchdown, the rough area on the runway, and the wheat field.May 10, 1999 · N3VU · Substantial damageNTSB SEA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Salem, ORThe pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…May 9, 1999 · N7483L · Substantial damageNTSB NYC99LA109Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Phillipsburg, OHFuel starvation to the engine due to the pilot's failure to switch fuel tanks.May 9, 1999 · N722B · Substantial damageNTSB MIA99LA154Accident · No injuriesLimited investigationFinal reportRyan ST-A · Leesburg, FLThe pilot's failure to maintain adequate clearance from the fence.May 9, 1999 · N18904 · Substantial damageNTSB MIA99LA151Accident · No injuriesLimited investigationFinal reportBoone RV6 · Apalachicola, FLA loss of engine power for undetermined reasons.May 9, 1999 · N34C · Substantial damageNTSB LAX99LA178Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Clarkdale, AZThe pilot's selection of unsuitable terrain during a high wind condition. Contributing factors were the high winds and the tree.May 9, 1999 · N3592Z · No damageNTSB LAX99FA177Accident · 2 fatalField investigationFinal reportAerostar Rally RX-8 · Morgan Hill, CAThe pilot's selection of an inadequate takeoff site that did not allow sufficient horizontal clearance from obstacles in the takeoff path, and, his failure to ensure that all burners were connected to fuel sources, which reduced the available climb capability…May 9, 1999 · N70290 · DestroyedNTSB IAD99FA043Accident · 6 fatalField investigationFinal reportCessna 205 · Celina, OHwas the pilot's failure to refuel the airplane which resulted in fuel exhaustion and a loss of engine power. Also causal to the accident was the pilot's failure to maintain aircraft control after the power loss. A factor in the accident was a lack of…May 9, 1999 · N8157Z · DestroyedNTSB CHI99LA150Accident · No injuriesLimited investigationFinal reportBeech A-36 · Buffalo Center, IAThe pilot not attaining a proper touchdown point and not performing a go around. Factors were the wet grass and the tailwin.May 9, 1999 · N53LE · Substantial damageNTSB CHI99FA147Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Newton, IAthe failure of the pilot to maintain flying speed resulting in a stall and spin into the ground.May 9, 1999 · N96876 · Substantial damageNTSB SEA99LA061Accident · No injuriesLimited investigationFinal reportEugene Hughes Lancair IV · Butte, MTThe pilot's improper flare.May 8, 1999 · N124GH · Substantial damageNTSB SEA99FA060Accident · No injuriesField investigationFinal reportBeech 36 · Portland, ORImproper installation of the strobe light system. Factors include a leak in the fuel bladder and electrical arcing.May 8, 1999 · N6222V · Substantial damageNTSB NYC99FA110Accident · Serious injuriesField investigationFinal reportSaab-Scania 340B · Jamaica, NYThe pilot-in-command's failure to perform a missed approach as required by his company procedures. Factors were the pilot-in-command's improper in-flight decisions, the pilot-in-command's failure to comply with FAA regulations and company procedures,…May 8, 1999 · N232AE · Substantial damageNTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.May 8, 1999 · N7068G · DestroyedNTSB MIA99LA152Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Knoxville, TNa total loss of engine power caused by the failure of the number 6 connecting rod, due to oil starvation for an undetermined reason.May 8, 1999 · N260Z · Substantial damageNTSB LAX99LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Las Vegas, NVThe pilot's premature rotation during the aborted landing and his failure to attain and maintain sufficient airspeed, which resulted in a stall mush. Factors in the accident were the pilot's decision to attempt a landing in adverse wind conditions beyond the…May 8, 1999 · CGIUX · DestroyedNTSB LAX99LA175Accident · Minor injuriesLimited investigationFinal reportMatter GLASAIR-SH-2R · St. Johns, AZThe pilot misjudging the distance/altitude while on final approach to the runway, which resulted in a landing overrun. Factors were the pilot's failure to position the flap switch to the neutral position after takeoff, resulting in the continuous running and…May 8, 1999 · N6DM · Substantial damageNTSB LAX99LA174Accident · No injuriesLimited investigationFinal reportCessna T303 · San Diego, CAThe pilot-in-command's inaccurate fuel consumption calculations that resulted in fuel exhaustion and the subsequent ditching.May 8, 1999 · N3303S · Substantial damageNTSB LAX99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.May 8, 1999 · N48845 · Substantial damage