Final NTSB investigations
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB ERA24LA004Accident · No injuriesClass 4 · LimitedFinal reportMichael J Wright SA300 · Georgetown, KYThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting a gusting crosswind, resulting in a runway excursion and nose over.NTSB ERA24FA003Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Croydon, NHThe pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…NTSB CEN24LA008Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Warrenton, MOThe pilot’s failure to maintain directional control during the touch-and-go landing. Contributing was the pilot’s decision to land with a quartering tailwind.NTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.NTSB ANC24LA001Accident · No injuriesClass 4 · LimitedFinal reportNathan A Rehak CAW-12 · Beluga, AKThe pilot’s loss of control after failing to determine wind direction during landing in variable, gusting wind conditions.NTSB ERA24LA005Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Harrisonburg, VAThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control and subsequent runway excursion.NTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.NTSB CEN24LA014Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Saginaw, MIThe failure of the right brake assembly due to excessive brake lining wear, which resulted in a thermally damaged piston O-ring, hydraulic fluid leak, and subsequent fire.NTSB WPR24LA007Accident · No injuriesClass 4 · LimitedFinal reportScott And Laura Hoisington CCX-2000 · South Lake Tahoe, CAThe pilot’s loss of directional control during landing roll, which resulted in a ground loop and collision with terrain.NTSB ERA24LA013AccidentClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Chesterfield, VAA hard landing that resulted in substantial damage to the airplane’s right wing.NTSB DCA24FA002Accident · No injuriesClass 2 · FieldFinal reportBoeing 757-236 · Chattanooga, TNThe failure of the alternate gear extension system, which prevented the landing gear from being lowered. The cause of the system failure was a broken wire, due to tensile overload, between the alternate gear extend switch and the alternate extension power…NTSB WPR24FA004Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Newberg, ORThe pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA24LA023Accident · No injuriesClass 3 · LimitedFinal reportChampion 7FC · Hawkinsville, GAThe failure of the carburetor fuel line, which resulted in fuel starvation.NTSB WPR24LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Hayward, CAThe pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.NTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.NTSB ERA24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Gallipolis, OHA collapse of the nose landing gear during landing, which resulted in a runway excursion and collision with an approach lighting system.NTSB CEN24LA005Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia Heights, ILThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground.NTSB CEN24LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Arlington, TXA reported loss of engine power during the landing approach due to undetermined reasons, which resulted in a forced landing and collision with a fence.NTSB WPR24LA009Accident · Serious injuriesClass 3 · LimitedFinal reportStephen D Phillabaum Helicycle · Deer Park, WAA loss of engine power due to fuel starvation resulting from contamination of the fuel system during low-level flight.NTSB WPR24FA001Accident · 1 fatalClass 3 · FieldFinal reportCubcrafters CCK-1865 · Twisp, WAThe pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.NTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN24LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Olathe, KSThe pilot’s mismanagement of the available fuel which resulted in a total loss of engine power due to fuel starvation.NTSB CEN24LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Waupaca, WIThe pilot’s failure to maintain directional control during the go-around, that resulted in a runway excursion and an impact with terrain.NTSB ERA23LA386Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, GAThe pilot’s failure to maintain clearance from a light pole during taxi.NTSB ERA23LA385Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206 · Port Clinton, OHThe pilot’s failure to detect and avoid unmarked powerline(s) while attempting to take off from a river.NTSB ERA23LA383Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Towanda, PAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…NTSB DCA23LA468Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Denver, COOverheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.NTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…NTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…NTSB WPR23LA361Accident · Minor injuriesClass 4 · LimitedFinal reportGleim James M MG-1 · Madera, CAAn emergency landing on uneven terrain that resulted in the loss of directional control during landing.NTSB ERA23FA380Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Whitesville, KYThe flight instructor’s improper decision to continue flight into a known area of thunderstorms, which resulted in an in-flight breakup.NTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.NTSB CEN23LA426Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Boerne, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA425Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Herington, KSThe design of the spray valve control lever, which restricted the range of the left rear rudder and brake pedal and resulted in a loss of control during landing.NTSB CEN23LA424Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Caddo Mills, TXThe pilot’s inadequate rolling preflight, which resulted in a loss of directional control in flight and subsequent collision with an object during landing.NTSB WPR23LA359Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · San Diego, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions that resulted in a ground loop.NTSB WPR23LA358Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Salt Lake City, UTThe student pilot’s failure to maintain directional control during landing.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB ERA23LA379Accident · Minor injuriesClass 4 · LimitedFinal reportDorr Dan W Sequoia F.8L Falco · Sanford, FLThe pilot’s failure to maintain airplane control after an engine access cover opened during the initial climb.NTSB CEN23LA422Accident · Minor injuriesClass 4 · LimitedFinal reportQuicksilver Sport II · Welsh, LAThe pilot’s failure to maintain sufficient altitude from obstacles during the simulated landing approach which led to a collision with a fence and a building.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB DCA23LA462Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Caribbean Sea (Atlantic Ocean)An inadvertent encounter with convectively induced turbulence during cruise that was not depicted by the airplane’s weather radar system.NTSB CEN23LA418Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Gonzales, TXThe loss of engine power during go-around due to a failed muffler flame tube, which resulted in an exhaust blockage. Contributing to the accident was maintenance personnel's inadequate inspection of the exhaust system during the most recent maintenance.NTSB ANC23LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Beluga, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the left main landing gear (MLG) tire impacting a rock, resulting in the separation of the MLG wheel, and the subsequent loss of directional control.