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 GAA25WA228Accident · No injuriesClass 3 · ForeignPiper PA32 · Marsh Harbor, BahamasNTSB GAA25WA221Accident · 1 fatalClass 5 · ForeignGrumman AA5 · Ottawa, Ontario, CanadaNTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB CEN25LA298Accident · No injuriesClass 4 · LimitedFinal reportBell 47G · Assumption, MNA total loss of engine power due to fuel starvation, which resulted from attitude-inducing unporting of the fuel.NTSB ANC25LA080Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 150J · Soldotna, AKOn July 31, 2025, about 1300 Alaska daylight time, a Cessna 150J airplane, N60509, was substantially damaged when it was involved in an accident near Soldotna, Alaska. The instructor pilot sustained minor injuries and the pilot receiving instruction was…NTSB ERA25LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPaul Dennis Berg Exec 162F · Holley, NYThe pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover.NTSB ERA25LA281Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Kissimmee, FLOn July 30, 2025, at 11:28 eastern daylight time, a Cessna 172S, N121CW, was substantially damaged when it was involved in an accident near Kissimmee, Florida. The private pilot and flight instructor were uninjured. The airplane was operated as a Title 14…NTSB ERA25FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Block Island, RIOn July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…NTSB DCA25LA276Accident · Serious injuriesClass 3 · LimitedPreliminary reportAirbus A330 · Creston, WYOn July 30, 2025, at 1723 mountain daylight time, Delta Air Lines flight 56, an Airbus A330-941, encountered severe turbulence while in cruise flight at an altitude of 37,000 ft near Creston, Wyoming. After determining that injuries had occurred, the flight…NTSB CEN25FA296Accident · 1 fatalClass 3 · FieldPreliminary reportHelms Richard Lancair IVP · Greenwood, INOn July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB GAA25WA220AccidentClass 5 · ForeignCessna 210L · Turks and Caicos Islands, United KingdomNTSB DCA25WA304IncidentClass 5 · ForeignBoeing 737 · Near MAR holding fix within Algiers TMA, AlgeriaNTSB WPR25LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Inhama, ORThe pilot’s failure to maintain clearance from trees while taxiing, which resulted in a wing strike.NTSB WPR25LA229Accident · No injuriesClass 4 · LimitedFinal reportLake Tahoe Properties CA 8 · Davenport, WAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA25LA278Accident · Minor injuriesClass 3 · LimitedPreliminary reportOrlican S R O M-8 Eagle · Lake Worth Beach, FLOn July 28, 2025, about 16:24 eastern daylight time, an Orlican M-8, N974FL, was substantially damaged when it was involved in an accident near Lake Worth Beach, Florida. The flight instructor sustained minor injuries, the private pilot sustained no injuries,…NTSB DCA25WA277Incident · No injuriesClass 5 · ForeignBoeing 737 · Mexico City, MexicoNTSB DCA25WA274Incident · No injuriesClass 5 · ForeignBoeing 737 · Mexico City, MexicoNTSB CEN25LA297Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R · Akron, IAOn July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182P · Bolivar, MOOn July 28, 2025, at about 1800 central daylight time, a Cessna 182P, N8243M, was destroyed when it was involved in an accident near Bolivar, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN25LA294Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Stanwood, MIThe collision with a deer during takeoff.NTSB CEN25LA291Accident · No injuriesClass 3 · LimitedPreliminary reportMatesi Eugene E Lancair 320 · Wink, TXOn July 27, 2025, about 2001 central daylight time, a Lancair 320 airplane, N70337, was substantially damaged when it was involved in an accident near Wink, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…NTSB WPR25LA230Accident · Minor injuriesClass 3 · LimitedPreliminary reportBallisodare Lancair Evolution · Coeur d' Alene, IDOn July 27, 2025, about 1010 Pacific daylight time, an experimental amateur-built Lancair Evolution airplane, N505RF, was destroyed when it was involved in an accident near Coeur d’Alene, Idaho. The pilot and two passengers sustained minor injuries. The…NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.NTSB WPR25FA225Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20J · Nampa, IDOn August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25FA224Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Pacific Grove, CAOn July 26, 2025, about 2237 Pacific daylight time, a Beech 95-B55, N8976R, was substantially damaged when it was involved in an accident near Pacific Grove, California. The pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB WPR25FA223Accident · 2 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · West Glacier, MTOn July 26, 2025, about 0942 mountain daylight time, a Grumman AA-5, N1342R, was destroyed when it was involved in an accident near West Glacier, Montana. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA229Accident · No injuriesClass 5 · ForeignCessna 150 · BragançA Paulista, BrazilNTSB GAA25WA219Accident · 2 fatalClass 5 · ForeignPiper PA31 · Deer Lake, CanadaNTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA25WA296IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB DCA25LA275Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Denver, COThe failure of the airplane’s left main landing gear tires and wheels during the takeoff roll due to the thermal relief plugs melting and releasing tire pressure, which resulted in abnormal airplane handling characteristics and led the flight crew to reject…NTSB CEN25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31T3 · Appleton, WIThe pilot’s failure to maintain control of the airplane on the ground, which resulted in a collision with a parked airplane.NTSB CEN25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28RT-201T · Brookings, SDOn July 26, 2025, at 1840 central daylight time, a Piper PA-28RT-201T airplane, N8423H, was substantially damaged when it was involved in an accident near Brookings, South Dakota. The airline transport pilot and passenger were uninjured. The airplane was…NTSB CEN25LA287Accident · No injuriesClass 4 · LimitedFinal reportAerotek Pitts S-2A · New Holstein, WIThe pilot’s loss of direction control during landing due to an unapproved tailwheel assembly and tail spring that resulted in a tailwheel shimmy and a subsequent ground loop.NTSB ERA25LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Windham, CTThe pilot’s inadequate preflight planning, which resulted in a rejected takeoff and subsequent runway excursion.NTSB CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.NTSB ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dillingham, AKOn July 25, 2025, about 0916 Alaska daylight time, a Piper J3C-65 airplane, N5050R, was substantially damaged when it was involved in an accident near Dillingham, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB ERA25LA287Accident · No injuriesClass 4 · LimitedFinal reportGrob-Werke Twin Astir · Franconia, NHThe pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…NTSB ERA25LA277Accident · Minor injuriesClass 3 · LimitedPreliminary reportMangels Leighton LANCAIR360 · Hardinsburg, KYOn July 24, 2025, about 1000 central daylight time, an experimental amateur-built Lancair 360, N50LM, was substantially damaged when it was involved in an accident near Hardinsburg, Kentucky. The pilot and the passenger sustained minor injuries. The airplane…NTSB DCA25WA279Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Cairns, AustraliaNTSB ANC25LA077Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210-5 · Yakutat, AKOn July 23, 2025, about 1700 Alaska daylight time, a Cessna 210-5 (205) airplane, N8457Z, was substantially damaged when it was involved in an accident on a remote beach about 50 miles southeast of Yakutat, Alaska. The pilot was uninjured. The airplane was…NTSB WPR25LA228Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Astoria, OROn July 22, 2025, about 1706 Pacific daylight time, a Beechcraft Bonanza V35, N3785Q, sustained substantial damage when it was involved in an accident near Astoria, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB GAA25WA217Accident · No injuriesClass 5 · ForeignKaman K-Max · Siviez, SwitzerlandNTSB ERA25LA292Accident · No injuriesClass 3 · LimitedPreliminary reportRockwell International 112 · Burlington, VTOn July 23, 2025, about 1300 eastern daylight time, N112EF, a Rockwell International 112 airplane, was substantially damaged when it was involved in an accident near Burlington, Vermont. The pilot was not injured. The flight was conducted under the provisions…NTSB CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.