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 WPR25FA294Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172F · Battle Ground, WAOn September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA291Accident · Minor injuriesClass 3 · LimitedPreliminary reportPipistrel D O O Alpha Trainer · Wittman, AZOn September 25, 2025, at about 0653 mountain daylight time, a Pipistrel D O O Alpha Trainer, N246EA, was substantially damaged when it was involved in an accident near Wittman, Arizona. The two pilots on board received minor injuries. The airplane was…NTSB DCA25LA339Incident · No injuriesClass 3 · LimitedPreliminary reportEmbraer EMB-145XR · Roanoke, VAOn September 24, 2025, at 2117 eastern daylight time (EDT), CommuteAir (dba United Express flight 4339), Embraer EMB-145XR, N21129, experienced a runway excursion while landing at Roanoke-Blacksburg Regional Airport (ROA), Roanoke, Virginia (VA). The airplane…NTSB CEN25LA402Accident · No injuriesClass 4 · LimitedFinal reportTextron 525C · Baton Rouge, LAThe improper installation of the trunnion pin, which resulted in a failure of the right main landing gear. Contributing to the accident was the failure of maintenance personnel to follow the aircraft manufacturer’s maintenance procedures.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN25LA393Accident · No injuriesClass 4 · LimitedFinal reportFloyd G Halderman JR RV-6 · Cambridge, MNThe pilot’s continued operation of the faulty fuel selector valve which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the degraded operation of the fuel selector valve and the pilot’s poor decision to operate the…NTSB WPR25LA290Accident · Minor injuriesClass 3 · LimitedPreliminary reportEurocopter EC135 · Whittier, WAOn September 23, 2025, at 2303 Pacific daylight time, a Eurocopter EC-135 T2+, N955AL, was substantially damaged when it was involved in an accident near Whittier, Washington. The pilot and three medical crew members received minor injuries. The helicopter…NTSB GAA25WA268Accident · 1 fatalForeign investigationBushmaster Super 22 · Lillooet, CanadaNTSB GAA25WA266Accident · 2 fatalClass 3 · ForeignLearjet 55 · La Guaira, VenezuelaNTSB WPR25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Lake Havasu City, AZThe pilot’s failure to extend the landing gear before landing due to distraction and failure to conduct the before landing checklist.NTSB WPR25LA292Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182N · Fallbrook, CAOn September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB GAA25WA270Accident · 4 fatalClass 5 · ForeignCessna 175 · Aquidauana, BrazilNTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB CEN25LA400Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Rush City, MNThe pilot’s failure to properly monitor the airplane glide path which resulted in the inadvertent descent below the approach minimum descent altitude and the impact with trees.NTSB ANC25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Healy, AKThe pilot’s failure to maintain directional control during the departure roll resulting in a collision with a tractor/loader.NTSB WPR25LA307Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Anacortes, WAOn September 22, 2025, about 1157 Pacific daylight time, a Cessna 172, N6831A, was substantially damaged when it was involved in an accident near Anacortes, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA269AccidentClass 5 · ForeignBeech 58 · Balkova, CzechiaNTSB GAA25WA263Accident · 2 fatalClass 5 · ForeignBell 412 · Talpa de Allende, MexicoNTSB ERA25LA362Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182F · Williamsburg, VAOn September 22, 2025, about 1730 eastern daylight time, a Cessna 182F, N3192U, was substantially damaged when it was involved in an accident near Williamsburg, Virginia. The airline transport pilot sustained minor injuries. The airplane was operated as a…NTSB DCA26WA006Incident · No injuriesClass 5 · ForeignBoeing 737 · Cape Town, South AfricaNTSB ANC25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Yakataga, AKThe total loss of engine power due to carburetor icing and the pilot’s failure to effectively use carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB GAA25WA264Accident · 2 fatalClass 5 · ForeignCessna 150M · Municipio de Garcia, MexicoNTSB GAA25WA272Accident · 1 fatalClass 5 · ForeignRans S6 · Le Creusot, FranceNTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA361Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172K · Salisbury, CTOn September 20, 2025, about 1733 eastern daylight time, a Cessna 172K, N78938, was substantially damaged when it was involved in an accident near Salisbury, Connecticut. The flight instructor and pilot receiving instruction sustained minor injuries. The…NTSB ERA25LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Linden, NJAn in-flight collision with a bird while on approach.NTSB ERA25LA359Accident · No injuriesClass 4 · LimitedFinal reportEdwin Miller Calidus · Hopkinsville, KYThe pilot’s failure to maintain control of the gyroplane, which resulted in dynamic rollover and impact with terrain.NTSB ERA25LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Blue Ridge, GAThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB DCA25WA343Incident · No injuriesClass 5 · ForeignAirbus A320 · Catania, ItalyNTSB CEN25LA391Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Seagoville, TXThe pilot’s inadequate fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25FA388Accident · 2 fatalClass 3 · FieldPreliminary reportNorth American T-6G · Louise, TXOn September 20, 2025, about 1724 central daylight time, a North American T-6G airplane, N32SZ, was destroyed when it was involved in an accident near Lousie, Texas. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14…NTSB ANC25LA111Accident · No injuriesClass 4 · LimitedFinal report217whiskeymike SQ12 · McGrath, AKThe pilot’s failure to maintain clearance from a hole in the tundra, which resulted in impact with terrain.NTSB WPR25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportMurphy SR3500 · Bigfork, MTOn September 19, 2025, about 1205 mountain daylight time, an experimental amateur built Murphy SR3500, N62ZT, was destroyed when it was involved in an accident near Bigfork, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA25WA283AccidentClass 5 · ForeignGulfstream GIV · Singapore, SingaporeNTSB GAA25WA265Accident · 1 fatalClass 5 · ForeignPiper PA18 · Cham, SwitzerlandNTSB ERA25LA356Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Plymouth, MAThe low wing airplane pilot’s failure to maintain an adequate visual lookout and his decision to activate the portable ADS-B receiver while taxiing, which resulted in a ground collision.NTSB ERA25LA355Accident · No injuriesClass 4 · LimitedFinal reportLamphere David A Wittman Buttercup · Monterey, VAThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB DCA25WA337IncidentClass 4 · ForeignBoeing 737 · Cancun, MexicoNTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB CEN25LA389Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Decatur, TXThe pilot’s loss of control during an off-airport, pinnacle landing, and the flight instructor’s inadequate supervision of the instructional flight.NTSB ANC25LA118Accident · No injuriesClass 4 · LimitedFinal reportToci Gabe C G Supa · Palmer, AKThe pilot’s failure to maintain airplane control during the go-around.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB WPR25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 750 · San Diego, CAOn September 17, 2025, about 1742 Pacific daylight time, a Cessna 750, N769XJ, was substantially damaged when it was involved in an accident at San Diego International Airport (SAN), San Diego, California. The two pilots and four passengers sustained no…NTSB GAA26WA033Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Budawang, AustraliaNTSB ERA25LA353Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 525C · Mayfield, KYOn September 18, 2025, about 1640 central daylight time, a Cessna 525C, N577RT, was substantially damaged when it was involved in an accident near Mayfield, Kentucky. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25FA352Accident · 3 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Franklin, NCOn September 18, 2025, at 1456 eastern daylight time, a Cirrus SR22T, N218VB, was substantially damaged when it was involved in an accident near Franklin, North Carolina. The private pilot and two passengers were fatally injured. The airplane was operated as…NTSB CEN25LA387Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Oxford, MSThe pilot’s exceedance of the airplane’s critical angle of attack during the initial takeoff climb, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.NTSB WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB WPR25LA280Accident · No injuriesClass 4 · LimitedFinal reportWeaver Harmon Rocket · Hayden, IDThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.