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 CEN26LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · McGregor, MNOn October 5, 2025, about 1310 central daylight time, a Piper PA-28-140, N4218T was substantially damaged when it was involved in an accident near McGregor, Minnesota. The pilot and two passengers were seriously injured. The airplane was operated under the…NTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA009Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182RG · Cottonville, IAOn October 3, 2025, about 1720 central daylight time, a Cessna 182RG airplane, N4609S, was substantially damaged when it was involved in an accident near Cottonville, Iowa. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA006Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SM 1019 · Richland, WAOn October 2, 2025, about 1050 Pacific daylight time, a Siai-Marchetti SM 1019, N3172U, sustained substantial damage when it was involved in an accident near Richland, Washington. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB ERA26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Talladega, ALOn October 2, 2025, at 1126 central daylight time, a Cirrus SR22, N812SE, was substantially damaged when it was involved in an accident near Talladega, Alabama. The commercial pilot sustained minor injuries, and the two passengers were not injured. The…NTSB DCA26FA001Accident · Minor injuriesClass 3 · FieldPreliminary reportBombardier CL-600-2D24 · New York, NYOn October 1, 2025, about 2156 eastern daylight time (EDT), Endeavor Air dba Delta Connection flight 5155, a Mitsubishi Heavy Industries (MHI) RJ CL-600-2D24 (CRJ-900), N902XJ, collided with Endeavor Air dba Delta Connection flight 5047, a MHI RJ CL-600-2D24…NTSB WPR26LA002Incident · No injuriesClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0958 mountain standard time, an Amazon.Com Services LLC, MK30, N791PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR26LA001IncidentClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0949 mountain standard time, an Amazon.Com Services LLC, MK30, N579PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB CEN26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · Colorado Springs, COOn October 1, 2025, about 0412 mountain daylight time, a Piper PA-28R-200 airplane, N999AD, was substantially damaged during an accident near Colorado Springs, Colorado. The pilot sustained minor injuries, and the 2 passengers were not injured. The airplane…NTSB ERA25LA369Accident · No injuriesClass 3 · LimitedPreliminary reportGregory A Spicola AR-1 · Fort Myers, FLOn September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…NTSB ERA25LA368Accident · No injuriesClass 3 · LimitedPreliminary reportElmore Travis C Searey · Rotonda West, FLOn September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated…NTSB CEN25FA395Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 340 · Klein, TXOn September 28, 2025, about 1212 central daylight time, a Cessna 340 airplane, N269WT, was destroyed when it was involved in an accident near Klein, Texas. The pilot and passenger were fatally injured. The airplane was operated as a Title Code of Federal…NTSB WPR25LA299Accident · Serious injuriesClass 3 · LimitedPreliminary reportVans RV3-A · Torrington, WYOn September 27, 2025, about 1600 mountain daylight time, an experimental amateur-built Vans RV-3A, N16MR, sustained substantial damage when it was involved in an accident near Torrington, Wyoming. The pilot was seriously injured. The airplane was operated as…NTSB ERA25FA367Accident · 1 fatalClass 3 · FieldPreliminary reportToop Thomas A Glasair Super II FT · Wallkill, NYOn September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a…NTSB WPR25LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150F · Lake Havasu City, AZOn September 26, 2025, at about 0915 mountain standard time, a Cessna 150F, N8171S, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane…NTSB WPR25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SF260B · Billings, MTOn September 26, 2025, about 1040 mountain daylight time, a SIAI-MARCHETTI SF 260B, N272C, was substantially damaged when it was involved in an accident near Billings, Montana. The pilot and passenger were not injured. The airplane was operated as a Title 14…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 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 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 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 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 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 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 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 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 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 ERA25LA350Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Astatula, FLOn September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of…NTSB WPR25FA279Accident · 1 fatalClass 3 · FieldPreliminary reportBellanca 17-30A · Moriarty, NMOn September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…NTSB CEN25LA386Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20K · Pearland, TXOn September 16, 2025, about 1040 central daylight time, a Mooney Aircraft Corp. M20K, N305EP was substantially damaged when it was involved in an accident at the Pearland Regional Airport, Pearland, Texas. The pilot and certificated flight instructor were…NTSB WPR25LA282Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Victorville, CAOn September 13, 2025, about 1300 Pacific daylight time, a Cessna P210N airplane, N25WD, was substantially damaged when it was involved in an accident near Victorville, California. The pilot and flight instructor were not injured. The airplane was operated as…NTSB ERA25LA345Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Williston, FLOn September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN25LA379Accident · Serious injuriesClass 3 · LimitedPreliminary reportPegasus Quantum 15 · Bedford, INOn September 13, 2025, at 1625 eastern daylight time, a Pegasus Quantum 15 weight-shift controlled aircraft, N36TJ, sustained substantial damage when it was involved in an accident near Bedford, Indiana. The pilot received serious injuries. The airplane was…NTSB ANC25LA105Accident · Serious injuriesClass 3 · LimitedPreliminary reportMaule M-5-235C · Point MacKenzie, AKOn September 13, 2025, about 12:28 Alaska daylight time, a Maule M5-235C airplane, N343GA, was substantially damaged when it was involved in an accident near Point McKenzie, Alaska. The commercial pilot sustained serious injuries. The airplane was operated…NTSB WPR25FA277Accident · 1 fatalClass 3 · FieldPreliminary reportLawson Thomas O Lancair Super ES · Mount Hamilton, CAOn September 12, 2025, about 1421 Pacific daylight time, an experimental amateur-built Lancair Super ES, N905ET, was destroyed when it was involved in an accident near Mount Hamilton, California. The pilot was fatally injured. The airplane was operated as a…NTSB CEN25LA384Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 210A · Gore Springs, MSOn September 12, 2025, about 1739 central daylight time, a Cessna 210A airplane, N911MC, was substantially damaged when it was involved in an accident near Gore Springs, Mississippi. The pilot sustained minor injuries. The airplane was operated as a Title 14…NTSB WPR25LA276Accident · No injuriesClass 3 · LimitedPreliminary reportSchieber Cedric H CH801 · Jackpot, NVOn September 11, 2025, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH801, N801CS, was substantially damaged when it was involved in an accident near Jackpot, Navada. The pilot and three passengers were not injured. The airplane was…NTSB ERA25FA344Accident · 2 fatalClass 3 · FieldPreliminary reportHughes 369D · Jim Thorpe, PAOn September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The…NTSB ERA25LA338Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell 206 · Monroe, GAOn September 10, 2025, about 1100 eastern daylight time, a Bell 206, N992MR, was destroyed when it was involved in an accident near Monroe, Geogia. The flight instructor and student pilot were seriously injured. The helicopter was operated as a Title 14 Code…NTSB WPR25LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-23-160 · Santa Teresa, NMOn September 6, 2025, about 1925 mountain daylight time, a Piper PA-23-160, N4085P, was substantially damaged when it was involved in an accident near Santa Teresa, New Mexico. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code…NTSB CEN25LA368Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 35-C33 · Brookings, SDOn September 6, 2025, about 0859 central daylight time, a Beech 35-C33 airplane, N1310A, was destroyed when it was involved in an accident near Brookings, South Dakota. The pilot and two passengers sustained minor injuries. The airplane was operated as a…NTSB CEN25FA367Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Lakeville, MNOn September 6, 2025, about 1442 central daylight time, a Robinson Helicopter Company R66 helicopter, N6633L was destroyed when it was involved in an accident near Lakeville, Minnesota. The pilot and passenger were fatally injured. The helicopter was operated…NTSB ERA25LA346Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-24-180 · Ashland City, TNOn September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a…NTSB CEN25FA366Accident · 2 fatalClass 3 · FieldPreliminary reportBeech P35 · Englewood, COOn September 5, 2025, about 0623 mountain daylight time, a Beech P35 airplane, N463T, was destroyed when it was involved in an accident near Englewood, Colorado. The pilot receiving instruction and flight instructor were both fatally injured. The airplane was…NTSB ERA25FA332Accident · 1 fatalClass 3 · FieldPreliminary reportCzech Sport Sportcruiser · Fryeburg, MEOn September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…NTSB CEN25FA364Accident · 1 fatalClass 3 · FieldPreliminary reportBeech K35 · Cambridge, MNOn September 4, 2025, about 1105 central daylight time, a Beech K35 airplane, N6021E, sustained substantial damage when it was involved in an accident near Cambridge, Minnesota. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code…NTSB ERA25LA333Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA44 · Bowling Green, OHOn September 3, 2025, about 1135 eastern daylight time, a Piper PA-44-180, N477BG, was substantially damaged when it was involved in an accident near Bowling Green, Ohio. The private pilot and the designated pilot examiner (DPE) received minor injuries. The…NTSB CEN25LA365Accident · No injuriesClass 3 · LimitedPreliminary reportIsrael Aerospace Industriesltd Gulfstream G150 · Wheeling, ILOn September 3, 2025, at 1211 central daylight time, an Israel Aerospace Industries Ltd. Gulfstream G150, N1927G, was substantially damaged when it was involved in an accident at Chicago Executive Airport (PWK), Wheeling, Illinois. The pilot and copilot were…