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 ENG25WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Katunayake, Sri LankaNTSB ANC25FA044Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Kaparuk, AKOn June 4, 2025 about 1055 Alaska daylight time, a Robinson R66 turbine-powered helicopter, N962MD, was substantially damaged when it was involved in an accident near Kaparuk, Alaska. The pilot and passenger were fatally injured. The helicopter was operated…NTSB GAA25WA180AccidentClass 5 · ForeignCessna 500 · Naiguata, VenezuelaNTSB GAA25WA177Accident · No injuriesClass 5 · ForeignCessna U206 · Santa Elena de Uairén, VenezuelaNTSB CEN25FA194Accident · 2 fatalClass 3 · FieldPreliminary reportUniversal Stinson 108 · Farmington, NCOn June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously…NTSB ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB WPR25LA168Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Port Townsend, WAThe flight instructor’s delayed remedial action and inadequate compensation for shifting wind conditions which resulted in a veer off the runway and collision with a sign.NTSB ERA25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172F · Vero Beach, FLA total loss of engine power for reasons that could not be determined.NTSB DCA25WA280Incident · No injuriesClass 5 · ForeignBoeing 777 · Singapore, SingaporeNTSB CEN25LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Charlevoix, MIThe pilot’s failure to maintain pitch control during the takeoff that resulted in multiple bounces and substantial damage to the fuselage.NTSB CEN25LA191Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Hamlet, NEThe pilot's failure to maintain clearance from the power lines during low altitude maneuvering.NTSB ERA25LA225Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150J · Elberta, ALOn June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…NTSB ERA25LA215Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Branford, CTMaintenance personnel's improper installation and inspection of the crankshaft gear bolt during major overhaul, which resulted in the crankshaft gear disengaging from the accessory gears which led to a total loss of engine power.NTSB CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.NTSB WPR25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182J · Kooskia, IDOn May 31, 2025, about 0930 Pacific daylight time, a Cessna 182J, N3463F, was substantially damaged when it was involved in an accident near Kooskia, Idaho. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA288Accident · No injuriesClass 5 · ForeignPiper PA38 · Tucumán, ArgentinaNTSB GAA25WA239Accident · 1 fatalClass 3 · ForeignCessna TU206 · Vereda El Canelón, ColombiaNTSB GAA25WA172Accident · 2 fatalClass 5 · ForeignBeech B36 · Korschenbroich, GermanyNTSB ENG25WA037Incident · No injuriesClass 5 · ForeignBoeing 737 · Muscat, OmanNTSB DCA25WA223Incident · No injuriesClass 5 · ForeignBoeing 737-8 Max · Muscat, OmanNTSB CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR25LA165Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620B · Lewiston, MTThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB CEN25LA192Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-32RT-300T · Tulsa, OKOn May 30, 2025, about 1627 central daylight time, a Piper PA-32RT-300T airplane, N130XR, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…NTSB WPR25LA164Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Tucson Estates, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA25WA179Accident · No injuriesClass 5 · ForeignCessna 310 · Lake Evella Aerodrome, AustraliaNTSB GAA25WA171Accident · 1 fatalClass 5 · ForeignCessna 188 · Trinidad Casanare, ColombiaNTSB CEN25LA190Accident · Minor injuriesClass 4 · LimitedFinal reportNelson Special · Hope, ARThe pilot’s failure to maintain airplane control during the landing roll.NTSB ANC25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Snohomish, WAThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun and collision with a fence.NTSB WPR25LA163Accident · No injuriesClass 3 · LimitedPreliminary reportRans S20 · Fairfield, UTOn May 27, 2025, about 1330 mountain daylight time, an experimental amateur-built RANS S20 Raven, N327KM, was substantially damaged when it was involved in an accident near Fairfield, Utah. The pilot was not injured. The airplane was operated as a Title 14…NTSB GAA25WA279Occurrence · No injuriesClass 5 · ForeignBeech 1900 · Aix-les-Milles, FranceNTSB DCA25WA221IncidentClass 5 · ForeignBoeing 767 · Xi An Shi, ComorosNTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB GAA25WA175AccidentClass 5 · ForeignGulfstream Aerospace G-IV · Robertsfield, LiberiaNTSB GAA25WA173Accident · No injuriesClass 5 · ForeignPiper PA-24 · Reykjavik, IcelandNTSB ENG25LA038IncidentClass 3 · LimitedPreliminary reportBoeing 777 · Beijing, ChinaOn May 26, 2025, at approximately 0925 UTC, a Boeing 777-200, registration N793UA, operated as United Airlines flight 889, executed a rejected takeoff at Beijing Capital International Airport when the crew heard a loud bang and followed by a No. 2 (right)…NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB GAA25WA169Accident · No injuriesClass 5 · ForeignCessna F182 · Šeduva, LithuaniaNTSB ERA25LA212Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Fremont, OHThe pilot’s inadequate takeoff performance planning, which resulted in a runway overrun and collision with terrain.NTSB ERA25FA211Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Stol CH701 · Geneva, OHOn May 25, 2025, about 1007 eastern daylight time, an experimental, amateur-built Zenith STOL CH701, N514JG, was substantially damaged when it was involved in an accident near Geneva, Ohio. The pilot was fatally injured and the pilot-rated passenger sustained…NTSB ERA25LA210Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV-12 · Abingdon, VAThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA186Accident · No injuriesClass 3 · LimitedPreliminary reportAeronca 7AC · Westphalia, MIOn May 24, 2025, at 1300 eastern daylight time, an Aeronca 7AC, N2659E, was substantially damaged when it was involved in an accident near Westphalia, Michigan. The commercial pilot was not injured. The airplane was operated under Title 14 Code of Federal…NTSB CEN25FA184Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell Commander 114A · Hankamer, TXOn May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…NTSB GAA25WA174Incident · No injuriesClass 5 · ForeignPiper PA34 · Karachi, PakistanNTSB GAA25WA167Accident · Serious injuriesClass 5 · ForeignCessna 188 · Pasaje, EcuadorNTSB GAA25WA165AccidentClass 5 · ForeignPiper PA-22-108 · Norfolk, United KingdomNTSB DCA25WA220IncidentForeign investigationBoeing 737 · Lima, PeruNTSB DCA25WA216IncidentClass 5 · ForeignEmbraer ERJ190 · Nueva Linda, MexicoNTSB CEN25LA187Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Goudeau, LAThe pilot’s inadvertent encounter with soft terrain conditions during the landing which resulted in a loss of directional and a subsequent nose-over.NTSB CEN25FA183Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 II · Miami, TXOn May 23, 2025, about 0718 central daylight time, a Robinson Helicopter Company R44 II helicopter, N1195P, was destroyed when it was involved in an accident near Miami, Texas. The student pilot was fatally injured. The helicopter was operated as a Title 14…NTSB ANC25LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Susitna, AKThe pilot’s encounter with shifting winds during landing, which resulted in a loss of airspeed and altitude, and subsequent contact with water.