Final NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WHERE c.\"completionStatus\" = 'Completed' 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."completionStatus" = 'Completed' 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 ERA24LA299Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 8GCBC · Frankford, DEA partial loss of engine power resulting from cylinder detonation and a cracked spark plug, which resulted in a forced landing and impact with terrain.NTSB ERA24LA297Accident · 1 fatalClass 4 · LimitedFinal reportBuckeye Dream Machine · Bainbridge, GAThe non-certificated pilot’s failure to maintain adequate clearance from powerlines while maneuvering at low altitude. Contributing to the accident was the pilot’s impairment due to alcohol and methamphetamine use.NTSB ERA24FA292Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · Lock Haven, PAThe student pilot’s premature turn to the crosswind leg of the traffic pattern at low airspeed and altitude, resulting in a collision with trees and terrain.NTSB CEN24LA329Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Leadville, COA loss of brake fluid for reasons that could not be determined, which resulted in a loss of braking effectiveness during landing.NTSB CEN24LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Brad, TXThe pilot’s failure to maintain airplane control after encountering a large boat wake.NTSB CEN24LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Florence, MOThe pilot’s failure to maintain proper altitude/clearance from a dead tree limb during an aerial application flight.NTSB CEN24LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Dowagiac, MIThe pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.NTSB CEN24LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Fayetteville, ARThe pilot’s loss of directional control due to a muscle spasm.NTSB CEN24LA249Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 F · Maybee, MIA partial loss of engine power for undetermined reasons.NTSB WPR24LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Harmony, WYA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.NTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.NTSB WPR24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV-12IS · Scappoose, ORThe pilot’s failure to remove the seat belt used as a flight control lock from the right control stick before takeoff, which resulted in a loss of control, an aerodynamic stall, and a collision with terrain during takeoff. Contributing to the accident was the…NTSB ANC24LA060Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Susitna, AKThe pilot’s selection of an unsuitable takeoff area, resulting in the floats contacting the shallow river bottom during takeoff, and a subsequent loss of control.NTSB WPR24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tacoma, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.NTSB ERA24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 · Greenville, NCA landing with the nose gear retracted as a result of an intermittent landing gear relay.NTSB ERA24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Richmond, VAThe pilot’s failure to maintain directional control of the airplane while landing in rain and gusting wind conditions.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB ERA24LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCorella Neil RV9A · Saluda, SCThe pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA245Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon A36 · Land O' Lakes, WIA partial loss of engine power for undetermined reasons.NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA24LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lewiston Woodville, NCThe obstruction of the engine’s cooling system by foreign object debris (residential-type insulation), which resulted in smoke, an elevated oil temperature, and a subsequent off-airport landing on unsuitable terrain.NTSB ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.NTSB CEN24LA247Accident · No injuriesClass 4 · LimitedFinal reportAmerican Air Racing Lancair IVP · Midland, TXThe pilot’s failure to extend and verify landing gear extension which resulted in a wheels-up landing. Contributing was the increased workload due to several airplane issues that occurred during the descent in severe turbulence.NTSB WPR24LA220Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Cedar City, UTThe pilot’s failure to maintain directional control during the landing roll, with gusty tailwind.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB ANC24LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland-Kenmore DHC-2 · Juneau, AKA partial loss of engine power during initial climb due to a cracked cylinder.NTSB ERA24LA287Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350 · Sanford, FLThe helicopter pilot’s improper maneuvering at low altitude in gusty wind conditions, which resulted in the helicopter entering a vortex ring state, and hard landing during a subsequent autorotation.NTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.NTSB CEN24LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Duluth, MNThe failure of the left engine induction coupling during takeoff, which resulted in a total loss of left engine power and an uncommanded left yaw/roll due to asymmetrical thrust and increased drag, from which the pilot had insufficient altitude to recover…NTSB CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.NTSB CEN24FA240Accident · 2 fatalClass 3 · FieldFinal reportCessna 414A · McKinney, TXThe pilot's improper decision to attempt continued flight after a loss of left engine power with usable runway remaining and his subsequent failure to follow the emergency procedures and maintain air minimum control speed, which resulted in a loss of control.…NTSB WPR24LA223Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic T210 · Arroyo Hondo, NMThe passenger’s failure to maintain a proper landing position and handhold during the landing sequence, which resulted in a serious injury.NTSB WPR24LA218Accident · Minor injuriesClass 3 · LimitedFinal reportTL Ultralight Sting RG · Rio Linda, CAA loss of engine power due to fuel exhaustion. Contributing to the accident was a fuel quantity indication that was inconsistent with the actual fuel state of the airplane, which likely led the pilot to overestimate the amount of fuel remaining onboard.NTSB ERA24LA279Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski Aventura II · DeLand, FLImproper installation of the electric-driven fuel pump inlet hoses, which resulted in a hose failure and subsequent loss of engine power due to fuel starvation.NTSB ANC24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Cordova, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ANC24LA055Accident · No injuriesClass 4 · LimitedFinal reportGippsland GA-8 · Tuntutuliak, AKThe pilot's failure to maintain directional control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.NTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.NTSB WPR24LA214Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CAThe pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.NTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB ERA24LA298Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC1B · Peachtree City, GAA right main landing gear collapse during landing.NTSB ERA24LA288Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Medina, OHThe pilot’s failure to extend the landing gear and the flight instructor’s lack of remedial action, which resulted in a landing with the landing gear not correctly configured.NTSB ERA24LA278Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Swans Island, METhe pilot’s delayed decision to abort the landing. Contributing was his decision to land downwind.NTSB ERA24LA276Accident · Minor injuriesClass 3 · LimitedFinal reportSnyder Searey · New Ipswich, NHA total loss of engine power due to the exhaust muffler and tailpipe assembly separating from its attach points and impacting the propeller.NTSB ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.NTSB DCA24LA219Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-79P · Portland, METhe flight crew’s inadequate review of preflight information and the flight dispatcher’s noncompliance with company guidance requiring the placement of a flight lock, which resulted in the flight’s departure from a closed runway. Contributing to the incident…