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 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 ANC24LA104Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Dillingham, AKThe pilot’s failure to maintain directional control while taxiing in gusting wind conditions.NTSB GAA24WA291Accident · Minor injuriesClass 5 · ForeignGrumman G164 · Rivera, UruguayNTSB ERA24LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Dyersburg, TNFailure of the tailwheel strut, which resulted in a loss of directional control during landing roll and a runway excursion.NTSB ENG24WA037AccidentClass 5 · ForeignTecnam P2008 · Abia de las Torres, SpainNTSB WPR24LA308Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B200 · Las Vegas, NMThe airplane’s collision with an elk during landing.NTSB ERA24LA386Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boston, MAThe failure of a solid hydraulic fluid line, which resulted in a loss of hydraulic fluid that prevented the landing gear extension process from completing normally. Contributing to the outcome was the pilot’s failure to fully activate the emergency landing…NTSB ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.NTSB CEN24LA362Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172N · Arboles, COA loss of engine power due to carburetor ice.NTSB ANC24LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · McKinley Village, AKThe pilot’s late decision to go-around, failure to maintain proper airspeed, and his exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB WPR24FA304Accident · 1 fatalClass 3 · FieldFinal reportGlobe Swift GC-1B · Minden, NVThe failure of the pilots of both airplanes to see and avoid the other airplane while operating in the airport traffic pattern, which resulted in a midair collision.NTSB GAA24WA288Accident · No injuriesClass 5 · ForeignCessna 208 · Migori, KenyaNTSB ENG24WA034IncidentClass 5 · ForeignAirbus A321 · Atyrau, KazakhstanNTSB DCA24WA313IncidentClass 5 · ForeignDouglas DC9 · Maiquetia, VenezuelaNTSB DCA24WA308IncidentClass 5 · ForeignBoeing 737-8 · San Francisco, CANTSB ANC24FA094Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 207 · Saint Mary's, AKOn September 15, 2024, about 2204 Alaska daylight time, a Cessna 207 airplane, N90193, was destroyed when it was involved in an accident near St. Mary’s, Alaska. The pilot and three passengers were fatally injured. The flight was operated as a Title 14 Code…NTSB WPR24LA307Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Basin, MTThe pilot’s decision to continue performing a high-performance takeoff in a full throttle and low-rotor-rpm condition, which resulted in a loss of control and subsequent impact with terrain.NTSB GAA24WA309Incident · No injuriesClass 5 · ForeignMarquart MA5 · Sussex, United KingdomNTSB GAA24WA286Accident · No injuriesClass 5 · ForeignCessna 152 · Buntingford, United KingdomNTSB ERA24LA383Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Carrollton, OHA failure of the left main landing gear due to fatigue cracking, which resulted the airplane’s left wing contacting the ground.NTSB ANC24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a ground loop and nose over.NTSB ANC24LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s failure to maintain directional control of the airplane during taxi in gusting wind conditions.NTSB ANC24LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with obstacles and a subsequent aerodynamic stall.NTSB ERA24LA380Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Baltimore, MDThe undetected worn internal parts of the on-condition carburetor, which restricted movement of the float, resulting in fuel starvation. Contributing to the severity of the accident was the pilot’s delayed reduction of the throttle when performing a forced…NTSB DCA24LA328Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Austin, TXThe unintended activation of the Emergency Autoland button on the overhead panel due to the airplane’s collision with an unknown object. Contributing to the incident was the pilot’s inability to initially deactivate the Emergency Autoland system due to a…NTSB ANC24LA097Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Lime Village, AKThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing in tree-covered terrain.NTSB ANC24LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Buckland, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC24LA093Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180B · Anchorage, AKThe pilot’s encounter with wake turbulence, which resulted in substantial damage to the airplane.NTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB ERA24LA382Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX-7 · Amsterdam, NYThe pilot’s failure to maintain adequate clearance from powerlines during final approach for landing.NTSB ERA24LA381Accident · Minor injuriesClass 4 · LimitedFinal reportWalden Robert Vans Aircraft RV-7A · Williamsburg, VAThe pilot’s decision to continue with an unstabilized approach which resulted in a hard landing and loss of directional control during a subsequent landing.NTSB ANC24FA091Accident · 2 fatalClass 3 · FieldPreliminary reportChampion 7GCBC · Ninilchik, AKOn September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as…NTSB GAA24WA285Accident · 2 fatalClass 4 · ForeignPiper PA-23-250 · Nassau, BahamasNTSB DCA24FA300Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 737-9 · Nashville, TNOn September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight…NTSB CEN24LA356Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Cumberland, WIThe total loss of engine power due to carburetor icing and the pilot’s delayed use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN24LA355Accident · Minor injuriesClass 4 · LimitedFinal reportJust SuperStol · Mount Vernon, IAThe pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.NTSB CEN24FA353Accident · 1 fatalClass 3 · FieldPreliminary reportHawker Beechcraft G36 · Lafayette, LAOn September 12, 2024, about 1137 central daylight time, a Hawker Beechcraft G36 airplane, N643RS, was destroyed when it was involved in an accident near Lafayette, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA24WA290Incident · No injuriesClass 5 · ForeignEmbraer EMB550 · Bromma, SwedenNTSB GAA24WA287Accident · No injuriesClass 5 · ForeignKawasaki KH4 · Tindal, AustraliaNTSB CEN24LA358Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Canton, MIFatigue cracking of the main rotor blade that occurred at an undetermined time.NTSB CEN24LA354Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170A · Marshall, INThe fatigue fracture of the No. 6 piston connecting rod, which resulted in a loss of engine power.NTSB CEN24LA352Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Clarksdale, MSThe pilot’s failure to maintain control during takeoff in gusting crosswind conditions.NTSB CEN24LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Schaumburg, ILThe flight crew’s fuel mismanagement resulting in the loss of engine power due to fuel starvation.NTSB CEN24LA350Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Englewood, COA partial loss of engine power due to fuel-oil contamination of the fuel injection servo.NTSB ERA24LA378Accident · No injuriesClass 4 · LimitedFinal reportBrandt Stirling D WAIEX-B · Stratford, CTThe pilot’s failure to maintain direction control of the airplane during a takeoff in crosswind conditions.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB DCA24FA299Accident · Minor injuriesClass 3 · FieldFinal reportAirbus A350-941 · College Park, GADelta Air Lines flight crew’s loss of situation awareness of the clearance between their right wingtip and the empennage of an Endeavor Air airplane holding on a perpendicular taxiway, resulting in their wingtip colliding with the other airplane’s empennage.…NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB GAA24WA284Accident · Minor injuriesClass 4 · ForeignCessna 182 · Mitu, ColombiaNTSB ENG24WA036AccidentClass 5 · ForeignBeech 200 · Egedesminde, Greenland