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 WPR26LA300Accident · No injuriesClass 4 · LimitedInvestigation openZaklad Szybowcowy Jezow PW-6U · Floriston, CANTSB WPR26LA293Accident · No injuriesClass 4 · LimitedInvestigation openP Z L -Warszawa-Cnpsl PZL-104 Wilga 35A · Ukiah, CANTSB WPR26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 172S · Provo, UTOn August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction…NTSB ANC26LA086Accident · No injuriesClass 4 · LimitedInvestigation openDehavilland DHC-2 · Igiugig, AKNTSB 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 CEN26LA282Accident · 1 fatalClass 3 · LimitedPreliminary reportPzl-Bielsko B1-PW-5 · Briggs, TXOn August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal…NTSB ANC26LA085Accident · No injuriesClass 4 · LimitedInvestigation openBeech 36 · Port Alsworth, AKNTSB ANC26LA083Accident · No injuriesClass 4 · LimitedInvestigation openLegend Air Alaska AK-18-4PX · Butte, AKNTSB ANC26LA080Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-32-260 · Pinetown, NCOn August 6, 2026, about 1355 eastern daylight time, a Piper Aircraft PA-32-260 airplane, N8791E, was substantially damaged when it was involved in an accident near Pinetown, North Carolina. The private pilot and two passengers sustained minor injuries. The…NTSB WPR26LA295Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV8 · Great Falls, MTOn August 5, 2026, at about 1034 mountain daylight time, a Van’s Aircraft RV-8, C-GFWR, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA292Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-24-260 · Albuquerque, NMNTSB WPR26LA291Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 177B · Perris, CAOn August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a…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 ANC26LA087Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 172P · Inalåhan, GUNTSB OPS26LA063IncidentClass 3 · LimitedPreliminary reportSikorsky VH3D · Washington, DCOn August 4, 2026, about 1434 eastern daylight time (EDT), Marine One (VM1) a Sikorsky VH-3D, and Envoy Air flight 3742 (ENY3742), an Embraer E-170, were involved in a loss of separation about 2 miles north of Ronald Reagan Washington National Airport (DCA),…NTSB CEN26LA281Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · Longmont, CONTSB CEN26FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Bethany, MOOn August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…NTSB WPR26LA290Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA22 · Goldendale, WANTSB WPR26LA288Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-20 · Reno, NVNTSB WPR26LA287Occurrence · 1 fatalClass 3 · LimitedPreliminary reportCameron Balloons A-315 · Menifee, CAOn August 2, 2026, about 0710 Pacific daylight time, a Cameron Balloons A-315, N315U, was not damaged when it was involved in an accident near Menifee, California. The pilot and one passenger were not injured, and one passenger was fatally injured. The…NTSB WPR26FA284Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Blackfoot, IDOn August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…NTSB CEN26LA277Accident · Serious injuriesClass 3 · LimitedPreliminary reportTaylorcraft BC12-D · Boyceville, WIOn August 2, 2026, about 1223 central daylight time, a Taylorcraft BC12-D airplane, N43665 was substantially damaged when it was involved in an accident near Boyceville, Wisconsin. Both the pilot and passenger were seriously injured. The airplane was operated…NTSB CEN26LA276Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Bennett, IAOn August 2, 2026, about 1318 central daylight time, a Robinson Helicopter Company R44 II helicopter, N26KL, was substantially damaged when it was involved in an accident near Bennett, Iowa. The pilot was not injured. The helicopter was operated as a Title 14…NTSB CEN26FA275Accident · 1 fatalClass 3 · FieldPreliminary reportBeech E18S · Guymon, OKOn August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA283Accident · No injuriesClass 4 · LimitedInvestigation openCub Crafters CCX-2000 · Tooele, UTNTSB WPR26LA285Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172 · Layton, UTOn July 30, 2026, at 2356 mountain daylight time, a Cessna 172M airplane, N9650V, was substantially damaged when it was involved in an accident near Layton, Utah. The flight instructor was seriously injured, and the private pilot sustained minor injuries. The…NTSB ANC26LA078Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Nenana, AKNTSB WPR26LA282Accident · Minor injuriesClass 4 · LimitedInvestigation openMark Lee Schillinger GT-VX2 · Petaluma, CANTSB WPR26FA281Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Chandler, AZOn July 28, 2026, about 1949 mountain standard time, a Piper PA-28-180, N9062J, was destroyed when it was involved in an accident near Chandler, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA273Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172F · Antigo, WINTSB 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 WPR26LA276Accident · No injuriesClass 4 · LimitedInvestigation openAviat A-1C-200 · Arlington, TXNTSB CEN26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportAero Commander Callair A-9B · Livonia, MOOn July 27, 2026, about 0819 central daylight time, an Aero Commander Callair A-9B airplane, N7799V, was substantially damaged when it was involved in an accident near Livonia, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA268Accident · No injuriesClass 3 · LimitedPreliminary reportKitfox III · Ephraim, WIOn July 26, 2026, at 1941 central daylight time, an experimental Kitfox III airplane, N573TB, sustained substantial damage when it was involved in an accident near Ephraim, Wisconsin. The private pilot and a passenger were uninjured. The airplane was operated…NTSB CEN26LA284Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150M · Ferris, TXOn July 25, 2026, about 1630 central daylight time, a Cessna 150M, N18YZ, was substantially damaged when it was involved in an accident near Ferris, Texas. One pilot sustained minor injuries and the other pilot had no injuries. The airplane was operated as a…NTSB WPR26LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Eastsound, WAOn July 23, 2026, about 1720 Pacific daylight time, a De Havilland DHC-3 Otter airplane, N709KA, was substantially damaged when it was involved in an accident near Eastsound, Washington. The pilot and two passengers were seriously injured, and eight…NTSB ENG26LA029Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 757 · Atlanta, GAOn July 24, 2026, about 14:32 Coordinated Universal Time, a Delta Air Lines Boeing 757-200, N662DN, powered by two Pratt & Whitney PW2037 turbofan engines, experienced a No. 1 (left) engine fire during initial climb from Hartsfield-Jackson Atlanta…NTSB CEN26LA271Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Carroll, IAOn July 24, 2026, about 1550 central daylight time, a Beech V35 airplane, N3707Q, was substantially damaged when it was involved in an accident near Carroll, Iowa. The pilot was not injured. The flight was operated under the provisions of Title 14 Code of…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 ERA26LA288Accident · Serious injuriesClass 4 · LimitedInvestigation openBalony Kubicek Spol Sro BB45Z · Johnstown, PANTSB ERA26LA283Accident · Serious injuriesClass 3 · LimitedPreliminary reportAmerican AA-1 · Kearneysville, WVOn July 23, 2026, at 1440 eastern daylight time, an American AA-1, N6132L, was substantially damaged when it was involved in an accident near Kearneysville, West Virginia. The pilot and pilot-rated passenger were seriously injured. The airplane was being…NTSB CEN26LA270Accident · No injuriesClass 4 · LimitedInvestigation openCessna P210R · Arkadelphia, ARNTSB WPR26LA275Accident · Minor injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Works Mermaid Skeeter 2 · Cougar, WAOn July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.…NTSB ANC26LA076Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180K · Anchorage, AKNTSB WPR26LA270Accident · No injuriesClass 3 · LimitedPreliminary reportEnstrom F-28F · Malad City, IDOn July 21, 2026, about 0815 mountain daylight time, an Enstrom F-28F helicopter, N8624B, was substantially damaged when it was involved in an accident near Malad City, Idaho. The pilot and pilot-rated passenger were not injured. The helicopter was operated…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 CEN26LA265Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Bulverde, TXOn July 20, 2026, about 1340 central daylight time, a Piper PA-28-180, N454MD was substantially damaged when it was involved in an accident near Bulberde, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a…NTSB ANC26LA075Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 152 · Pell City, ALOn July 20, 2026, at 1030 eastern daylight time, a Cessna 152 airplane was substantially damaged when it was involved in an accident near Pell City, Alabama. The flight instructor and student pilot were not injured. The airplane was operated as a Title 14…NTSB DCA26LA329Accident · Serious injuriesClass 4 · LimitedInvestigation openBoeing 777 · Boston, MA