NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WPR25LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB GAA25WA246Accident · No injuriesClass 5 · ForeignRockwell 112 · Sanat Ana del Yacuma, BoliviaNTSB ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ERA25FA310Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Milledgeville, GAOn August 23, 2025, about 1825 eastern daylight time, a Cessna 310Q, N7664Q was destroyed when it was involved in an accident near Milledgeville, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD 83 · Miami, FLAn encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.NTSB CEN25LA337Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Caseville, MIThe front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.NTSB CEN25LA336Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Argusville, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ANC25LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot receiving instruction’s failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Fly Balonismo E Inflaveis AF-SS-94 · Walbridge, OHThe balloon pilot’s failure to see and avoid powerlines during an off-field airport landing.NTSB ERA25FA309Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185F · Bangor, MEOn August 22, 2025, at 1321 eastern daylight time, a Cessna A185F, N714HE, was substantially damaged when it was involved in an accident near Bangor, Maine. The pilot was fatally injured. The flight was being conducted as a 14 Code of Federal Regulations Part…NTSB CEN25LA408Accident · No injuriesClass 3 · LimitedPreliminary reportBell Helicopter Textron Canada 206L-3 · Picayune, MSOn August 22, 2025, about 1130 central daylight time, a Bell Helicopter Textron Canada 206L-3 helicopter, N17TL, was substantially damaged when it was involved in an accident near Picayune, Mississippi. The pilot and passenger were not injured. The helicopter…NTSB CEN25LA338Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fargo, NDThe pilot’s failure to maintain directional control during landing with a gusting crosswind. Contributing to the accident was the closure of the wind aligned runway 27.NTSB CEN25LA334Accident · No injuriesClass 4 · LimitedFinal reportKaman Aerospace K-1200 · Eagle, COThe pilot’s failure to maintain helicopter control which resulted in an uncontrolled descent and impact with terrain.NTSB CEN25LA333Accident · No injuriesClass 4 · LimitedFinal reportParks Fokker D-VII Replica · Englewood, COA malfunction of the tailwheel which resulted in a runway excursion and ground loop.NTSB ANC25LA092Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Juneau, AKThe pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.NTSB ERA25LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gaithersburg, MDThe flight instructor’s distraction during landing, which resulted in a long landing and subsequent runway excursion.NTSB CEN25LA344Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Markesan, WIThe pilot’s failure to attain a proper touchdown point which resulted in a long landing and subsequent runway overrun.NTSB CEN25LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Air Force Academy, COThe student pilot’s failure to perform an adequate preflight inspection.NTSB ANC25LA095Accident · No injuriesClass 4 · LimitedFinal reportHelio H-395 · Pilot Point, AKThe pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.NTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.NTSB ERA25LA315Accident · Serious injuriesClass 4 · LimitedFinal reportPatriot CX1900A · Centreville, ALThe pilot’s failure to detect and remove water contamination from the airplane’s fuel system before the flight, which resulted in a total loss of engine power during initial climb.NTSB ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.NTSB ENG25WA052AccidentClass 3 · ForeignAirbus A320 · Haute-Corse, FranceNTSB CEN25LA331Accident · Minor injuriesClass 4 · LimitedFinal reportElmwood Christavia · South Saint Paul, MNThe pilot’s failure to maintain airplane control during the landing roll. Contributing to the accident was the pilot’s decision to land the airplane on a non-approved landing surface.NTSB CEN25LA330Accident · Minor injuriesClass 4 · LimitedFinal reportEXP Supercub · Grove, OKThe pilot’s failure to maintain elevator control during the landing, which resulted in a nose over.NTSB ANC25LA097Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3e · Skwentna, AKThe pilot’s inadvertent entanglement of a lightweight Kevlar long line into the helicopters operating main rotor system, resulting in a severe imbalance and separation of the main rotor gearbox.NTSB ANC25LA091Accident · No injuriesClass 3 · LimitedPreliminary reportVu Holdings LLC/DBA Vanilla UN VA 001 · Ninilchik, AKOn August 20, 2025, at about 0632 Alaska daylight time, a Platform Aerospace VA 001 Unmanned Aerial System (UAS), N246VU, was substantially damaged when it was involved in an accident on a beachside cliff near Ninilchik, Alaska. The aircraft was unmanned. The…NTSB WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB CEN25LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportMarshall Allen L RV6A · Centerview, MOOn August 19, 2025, at 1640 central daylight time, a Vans RV-6A airplane, N692AC, was substantially damaged when it was involved in an accident near Centerview, Missouri. The commercial pilot sustained minor injuries and the passenger was uninjured. The…NTSB CEN25FA321Accident · 1 fatalClass 3 · FieldPreliminary reportLancair NLA-275-FR-C · Bradley, AROn August 18, 2025, about 2133 central daylight time, a Lancair NLA-275-FR-C airplane, N345LA, was destroyed when it was involved in an accident near Bradley, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.NTSB ANC25LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Homer, AKThe failure of the left main landing gear mount due to extensive corrosion while landing in an area of rough terrain.NTSB WPR25LA267Accident · No injuriesClass 3 · LimitedPreliminary reportDavid Ullman Jabirwatt · Albany, OROn August 18, 2025, about 1300 Pacific daylight time, an experimental amateur-built Jabirwatt, N824DW, was substantially damaged when it was involved in an accident near Albany, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB WPR25LA262Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Burlington, WAThe pilot’s failure to see and avoid the light pole, which resulted in a collision with the light pole and subsequent ground impact.NTSB GAA25WA245Accident · No injuriesClass 5 · ForeignEmbraer EMB721 · Cano Negro, BoliviaNTSB ERA25LA378Accident · Minor injuriesClass 3 · LimitedPreliminary reportThrush S2R-T660 · Albany, GAOn August 18, 2025, about 0944 EST, a Thrush Aircraft LLC S2R-T660, N7001B, was substantially damaged when it was involved in an accident at Southwest Georgia Regional Airport, Albany, Georgia. The commercial pilot sustained minor injuries. The airplane was…NTSB ERA25LA318Accident · No injuriesClass 4 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Portsmouth, NHThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN25LA329Accident · No injuriesClass 4 · LimitedFinal reportJMB Aircraft S R O VL-3LSA-912 · Erie, COThe flight instructors inadequate supervision of the flight and delayed remedial action and the pilot’s improper landing flare during which resulted in a hard landing.NTSB CEN25LA325Accident · No injuriesClass 4 · LimitedFinal reportHelio H-391B · Monroe, MIThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ANC25LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Haines, AKThe pilot’s selection of an unsuitable landing area resulting in an on-ground collision with an obscured log and a main landing gear separation.NTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.NTSB WPR25LA261Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · San Diego, CAOn August 16, 2025, about 1737 Pacific daylight time, a Piper PA-28-181, N8150J, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB WPR25FA257Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 140 · Shelter Cove, CAOn August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…NTSB GAA25WA248Accident · 1 fatalClass 5 · ForeignQuicksilver MX II · Phuket, ThailandNTSB ERA25LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Baltimore, MDThe pilot’s inadequate landing flare at night, which resulted in a hard landing.NTSB GAA25WA287Accident · 2 fatalClass 5 · ForeignRobin DR400 · Saint-Pons, France