Ongoing 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 WHERE c.\"completionStatus\" = 'Ongoing' 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 WHERE c."completionStatus" = 'Ongoing' 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 WPR25LA244Accident · Serious injuriesClass 3 · LimitedPreliminary reportNorth American T-28C · West Wendover, NVOn August 07, 2025, at 1532 Pacific daylight time, a North American T-28C, N9748Y, was substantially damaged when it was involved in an accident near West Wendover, Utah. The pilot and the passenger were seriously injured. The airplane was operated as a Title…NTSB CEN25LA310Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Jaroso, COOn August 7, 2025 at 0935 mountain daylight time, a Cirrus SR22 airplane, N412DJ, was substantially damaged when it was involved in an accident near Jaroso, Colorado. The pilot receiving instruction and a passenger were seriously injured, and the flight…NTSB CEN25LA309Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV4 · Elgin, ILOn August 6, 2025, about 1925 central daylight time, a Vans RV4 airplane, N595BS, was substantially damaged when it was involved in an accident near Elgin, Illinois. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB CEN25LA306Accident · Serious injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-301 · Davenport, NDOn August 6, 2025, at 2035 central daylight time, an Air Tractor Inc AT-301 airplane, N23069, was substantially damaged when it was involved in an accident near Davenport, North Dakota. The commercial pilot sustained serious injuries. The airplane was…NTSB CEN25FA308Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T182T · Augusta, AROn August 7, 2025, at 1037 central daylight time, a Cessna T182T airplane, N35370, was substantially damaged when it was involved in an accident near Augusta, Arkansas. The pilot was fatally injured and the passenger received minor injuries. The airplane was…NTSB CEN25LA305Accident · No injuriesClass 3 · LimitedPreliminary reportStolp Starduster SA300 · Marshall, AROn August 6, 2025 about 1552 central daylight time, a Stolp Starduster SA 300 airplane was substantially damaged when it was involved in an accident near Marshall, Arkansas. The pilot was not injured. The airplane was operated under the provisions of Title 14…NTSB CEN25LA304Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R-G6 · Slayton, MNOn August 6, 2025, about 1300 central daylight time, a Ayres Corporation S2R-G6, airplane, registration N2239V, was substantially damaged when it was involved in an accident near Slayton, Minnesota. The pilot was seriously injured. The airplane was operated…NTSB ANC25LA084Accident · Serious injuriesClass 3 · LimitedPreliminary reportAeronca 7AC · Willow, AKOn August 5, 2025, about 1600 Alaska daylight time, an Aeronca 7AC airplane, N84726, was substantially damaged when it was involved in an accident at the Willow Airport (UUO) in Willow, Alaska. The student pilot sustained serious injuries. The airplane was…NTSB WPR25FA240Accident · 4 fatalClass 3 · FieldPreliminary reportBeech 300 · Chinle, AZOn August 5, 2025, about 1245 mountain daylight time, a Beech 300, N534AW, was destroyed when it was involved in an accident near Chinle, Arizona. The pilot, co-pilot and two medical crew members were fatally injured. The airplane was operated as a Title 14…NTSB ERA25LA290Accident · Serious injuriesClass 3 · LimitedPreliminary reportGary W Lewinski Sonex · Tellico Plains, TNOn August 5, 2025, about 1131 eastern daylight time, a Lewinski Sonex, N67BG, was substantially damaged when it was involved in an accident near Tellico Plains, Tennessee. The private pilot was seriously injured. The airplane was operated as a Title 14?Code…NTSB ERA25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Pembroke Pines, FLOn August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB WPR25LA236Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Silver Springs, NVOn August 3, 2025, at about 0730 Pacific daylight time, a Piper PA28-180, N8359W, was substantially damaged when it was involved in an accident near Stagecoach, Nevada. The student pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA289Accident · Minor injuriesClass 3 · LimitedPreliminary reportJabiru Aircraft PTY J230-D · Oak Island, NCOn August 2, 2025, about 1925 eastern daylight time, a Jabiru Aircraft Pty Ltd J-230-D, N784J, was substantially damaged when it was involved in an accident near Oak Island, North Carolina. The private pilot received minor injuries. The airplane was operated…NTSB WPR25FA233Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 152 · Hornell, NYOn August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR25FA232Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW27-18 · Morgan, UTOn August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…NTSB CEN25LA300Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Gainesville, TXOn August 1, 2025, about 0802 central daylight time, a Cessna 172P airplane, N62296, was substantially damaged during an accident near Gainesville, Texas. The flight instructor and pilot-receiving-instruction were not injured. The airplane was operated as a…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 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 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 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 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 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 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 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 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 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 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 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 CEN25LA277Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Maynard, IAOn July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…NTSB CEN25FA273Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T188C · Oregon, ILOn July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25LA282Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210N · Crosby, TXOn July 21, 2025, about 0745 central daylight time, a Cessna T210N, N93HP, was substantially damaged when it was involved in an accident near Crosby, Texas. The pilot and passenger were not injured. The airplane operated as a Title 14 Code of Federal…NTSB CEN25FA270Accident · 2 fatalClass 3 · FieldPreliminary reportVan's RV-14 · Lowell, MIOn July 21, 2025, about 1627 eastern daylight time, a Van’s Aircraft RV-14A airplane, N21KL, was destroyed when it was involved in an accident near Lowell, Michigan. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was operated…NTSB CEN25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportAero Vodochody L-39C · Granite Falls, MNOn July 21, 2025, about 1728 central daylight time, an Aero Vodochody L-39C airplane, N339L, was substantially damaged during an accident near Granite Falls, Minnesota. The flight instructor, seated in the front seat, sustained serious injuries after ejecting…NTSB ERA25FA272Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA46-500TP · Lititz, PAOn July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The…NTSB CEN25LA265Accident · No injuriesClass 3 · LimitedPreliminary reportQuestair Venture · Oshkosh, WIOn July 20, 2025, about 1545 central daylight time, a Questair Venture airplane, N53TL, sustained substantial damage when it was involved in an accident at Oshkosh, Wisconsin. The pilot and passenger were not injured. The airplane was operated under the…NTSB CEN25FA261Accident · 1 fatalClass 3 · FieldPreliminary reportKolb Firestar · Meadow Grove, NEOn July 19, 2025, about 2050 central daylight time, a Kolb Firestar airplane, N55161, was destroyed when it was involved in an accident near Meadow Grove, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB OPS25LA052Incident · No injuriesClass 3 · LimitedPreliminary reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Minot, NDOn July 18, 2025, about 1948 central daylight time (CDT), WarBird03 (WBD03), a US Air Force (USAF) B-52H, enroute to conduct an aerial flyby at the North Dakota Fairgrounds, was involved with a loss of separation event approximately two miles south of Minot…NTSB WPR25FA214Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · West Yellowstone, MTOn July 17, 2025, about 2358 mountain daylight time, a Piper PA-28-180, N7186W, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot and two pilot rated passengers were fatally injured. The airplane was…NTSB WPR25LA218Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 425 · Round Rock, AZOn July 17, 2025, about 1600 mountain daylight time, a Cessna 425, N425D, was substantially damaged when it was involved in an accident near Round Rock, Arizona. The pilot receiving instruction and the flight instructor were not injured. The airplane was…NTSB WPR25LA217Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Tuba City, AZOn July 17, 2025, about 1447 mountain standard time, a Cessna TR182, N182KC, was substantially damaged when it was involved in an accident near Tuba City, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA270Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA46 · Sunset, SCOn July 17, 2025, about 1122 eastern daylight time, a Piper PA-46-310P, N460WW, was substantially damaged when it was involved in an accident near Sunset, South Carolina. The commercial pilot was not injured. The airplane was operated as a Title 14 Code of…