Ongoing NTSB investigations
116 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2024 | 12 |
|---|---|
| 2025 | 43 |
| 2026 | 61 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA27LA006Accident · Serious injuriesLimited investigationInvestigation openCessna 525 · Bedford, PANTSB CEN27FA006Accident · 1 fatalClass 3 · FieldPreliminary reportLancair IV · Haslet, TXOn October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB WPR27FA001Accident · 1 fatalClass 3 · FieldInvestigation openRoesler Scott D Roesler Glasair · Everett, WANTSB WPR26FA363Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter Deutschland EC 135 P2+ · Avalon, CAOn September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…NTSB ERA26FA350Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 112 · Chatsworth, GAOn September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB WPR26FA346Accident · 2 fatalClass 3 · FieldPreliminary reportAirbus AS332 · Yosemite Valley, CAOn September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…NTSB ANC26FA106Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Northway, AKNTSB ERA26FA341Accident · 1 fatalClass 3 · FieldPreliminary reportWeatherly 620 · Lynchburg, SCOn September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as…NTSB CEN26LA332Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA18 · Karinen, SDOn September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…NTSB WPR26FA345Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter AS 350 B2 · Chatsworth, CAOn September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…NTSB ANC26FA105Accident · 2 fatalClass 3 · FieldInvestigation openCessna A185F · Stony River, AKNTSB CEN26FA311Accident · 2 fatalClass 3 · FieldPreliminary reportEXP Stol CH701 · Neosho, MOOn September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was…NTSB ANC26FA097Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T206H · Dunton, COOn September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…NTSB CEN26LA301Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 172M · Frankston, TXNTSB WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA296Accident · 1 fatalClass 3 · LimitedPreliminary reportPara-Ski VX · Westport, SDOn August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…NTSB ERA26LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportBarry Lynn Kromer Zenith Cruzer · Chatham, MAOn August 14, 2026, about 1040 eastern daylight time, an experimental amateur-built Zenith Cruzer, N673BK, was substantially damaged when it was involved in an accident near Chatham, Massachusetts. The pilot and the pilot-rated passenger received minor…NTSB CEN26LA290Accident · No injuriesClass 3 · LimitedPreliminary reportGulfstream Aerospace G-IV · St. Louis, MOOn August 14, 2026, about 1459 central daylight time, a Gulfstream Aerospace G-IV airplane, N406JS, was substantially damaged when it was involved in an accident near St. Louis, Missouri. The three crew members and 7 passengers were not injured. The airplane…NTSB CEN26LA285Accident · Serious injuriesClass 3 · LimitedPreliminary reportStaudacher Jon ZZ 102 · Vicksburg, MIOn August 12, 2026, about 1906 eastern daylight time, a Staudacher ZZ 102 experimental airplane, N134ZZ, was substantially damaged when it was involved in an accident near Vicksburg, Michigan. The airline transport pilot and one passenger were seriously…NTSB WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…NTSB ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…NTSB ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA289Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Bend, OROn August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…NTSB ANC26FA077Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA22 · Chitina, AKOn July 27, 2026, about 2130 Alaska daylight time, a deregistered Piper PA-22-150 airplane, N4535A, was destroyed when it was involved in an accident near Chitina, Alaska. The pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA266Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper J3C-65 · Richmond, TXOn July 20, 2026, at 0643 central daylight time, a Piper J3C-65 airplane, N92432, sustained substantial damage when it was involved in an accident near Richmond, Texas. The commercial pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN26LA263Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Baraboo, WIOn July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…NTSB CEN26FA253Accident · 1 fatalClass 3 · FieldPreliminary reportMontana Coyote · Fredericksburg, VAOn July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…NTSB ANC26LA071Accident · Serious injuriesClass 4 · LimitedInvestigation openBellanca 7GCBC · Skwentna, AKNTSB ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA224Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Middlefield, OHOn June 20, 2026, about 1535 eastern daylight time, a Piper PA-24-250, N6403P, was substantially damaged when it was involved in an accident near Middlefield, Ohio. The pilot and two passengers sustained fatal injuries. The airplane was operated as a Title 14…NTSB ANC26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502B · Forbes, MOOn June 15, 2026, about 2015 Central daylight time, an Air Tractor AT-502B airplane, N503GK, sustained substantial damage when it was involved in an accident near Forbes, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26FA217Accident · 1 fatalClass 3 · FieldPreliminary reportLancair 235 · Hillsboro, OROn June 12, 2026, at about 1508 Pacific daylight time, a Lancair 235, N10CF, was destroyed when it was involved in an accident near Hillsboro, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26FA216Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-36-300 · Henderson, NEOn June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26FA202Accident · 1 fatalClass 3 · FieldPreliminary reportPipistrel D O O Sinus 912 · Columbus, MSOn May 31, 2026, about 1236 central daylight time, a Pipistrel D O O Sinus 912, N1277P, was destroyed when it was involved in an accident near Columbus, Mississippi. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26FA207Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Dawsonville, GAOn May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…NTSB WPR26LA205Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 208B · Shelton, WANTSB CEN26FA192Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172N · Westerly, RIOn May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 182T · Armistead, CAOn May 7, 2026, about 1055 pacific daylight time (PDT), a Cessna 182T airplane, N227TF, was destroyed when it was involved in an accident near Armistead, California. The flight instructor and the pilot receiving instruction were fatally injured. The airplane…NTSB CEN26FA174Accident · 5 fatalClass 3 · FieldPreliminary reportCessna 421 · Wimberley, TXOn April 30, 2026, about 2303 central daylight time, a Cessna 421C airplane, N291AN, was destroyed when it was involved in an accident near Wimberley, Texas. The private pilot and four passengers were fatally injured. The airplane was operated under the…NTSB ERA26FA177Accident · 1 fatalClass 3 · FieldPreliminary reportRajchl Vladimir Airplane Swing 06 · O'Brien, FLOn April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title…NTSB ANC26FA024Accident · 2 fatalClass 3 · FieldPreliminary reportAirplane Factory Ltd The Sling · Avalon, CAOn April 09, 2026, about 1224 Pacific daylight time, an Airplane Factory (Pty) Ltd. Sling 2 airplane, N166TW, was substantially damaged when it was involved in an accident near Avalon, California. The pilot and pilot-rated passenger were fatally injured. The…NTSB CEN26FA147Accident · 1 fatalClass 3 · FieldPreliminary reportExperimental Homebuilt Airshark · Statesboro, GAOn March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a…NTSB WPR26FA130Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Olympic Valley, CAOn March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal…NTSB ANC26FA021Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Boynton Beach, FLOn March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The…NTSB CEN26FA142Accident · 1 fatalClass 3 · FieldPreliminary reportBeechcraft B200GT · Sharp, LAOn March 22, 2026, at 1418 central daylight time (CDT), a Beechcraft B200GT (Super King Air) airplane, N886DS, was destroyed when it was involved in an accident near Sharp, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code…