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 CEN26LA239Accident · No injuriesClass 4 · LimitedInvestigation openCessna T206H · Ava, MONTSB ANC26LA066Accident · Serious injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 NG · Petersburg, VAOn June 29, 2026, about 1945 eastern daylight time (EDT), a Diamond Aircraft Industries Inc. DA40 NG airplane, N602RF, was substantially damaged when it was involved in an accident near Petersburg, Virginia. The flight instructor sustained serious injuries,…NTSB ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA26LA251Accident · Minor injuriesClass 3 · LimitedPreliminary reportJones Peter M Boeing/Jones 75 · Cleveland, GAOn June 26, 2026, about 1045 eastern daylight time, a Boeing/Jones 75, N3993C, was substantially damaged when it was involved in an accident near Cleveland, Georgia. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB CEN26LA238Accident · 1 fatalClass 3 · LimitedPreliminary reportAirborne Windsports PTY Edge XT-912-L · Winona, MNOn June 25, 2026, about 2000 central daylight time, an Airborne Windsports Pty Ltd Edge Xt-912-L weight-shift-control light sport aircraft, N912CV was substantially damaged when it was involved in an accident at Winona Municipal Airport (ONA) Winona,…NTSB WPR26LA236Accident · No injuriesClass 3 · LimitedPreliminary reportBeech S35 · Dome, AZOn June 25, 2026, about 1125 mountain standard time, a Beech S35, N6040F, sustained substantial damage when it was involved in an accident near Dome, Arizona. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA235Accident · No injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA20-C1 · Nephi, UTOn June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title…NTSB WPR26FA233Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 195 · Pasco, WAOn June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…NTSB WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ANC26LA065Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-125 · Wasilla, AKNTSB CEN26LA231Accident · 1 fatalClass 3 · LimitedPreliminary reportBailey-Moyes Dragonfly · Whitewater, WIOn June 22, 2026, about 1915 central daylight time, a Bailey-Moyes Dragonfly, N3849A, was involved in an accident near Whitewater, Wisconsin. The pilot of the Dragonfly was not injured. The pilot of the hang glider in tow was fatally injured. The tow…NTSB ANC26LA064Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 105 · Chena, AKNTSB CEN26LA234Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell 47G-2 · Troy, MOOn June 22, 2026, about 1840 central daylight time, a Bell 47G-2 helicopter, N65520, was substantially damaged when it was involved in an accident near Troy, Missouri. The pilot sustained serious injuries. The helicopter was operated as a Title 14 Code of…NTSB ANC26LA062Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron 208B · Wiseman, AKOn June 22, 2026, about 1043 Alaska standard time, a turbine-powered Cessna 208B airplane N94AW, was substantially damaged when it was involved in an accident near Wiseman, Alaska. The nine passengers were uninjured, the pilot sustained minor injuries. The…NTSB WPR26LA227Accident · No injuriesClass 3 · LimitedPreliminary reportEmigh Trojan A2 · Healdsburg, CAOn June 21, 2026, about 1210 Pacific daylight time, an Emigh Trojan A-2, N8329H, was substantially damaged when it was involved in an accident near Healdsburg, California. The flight instructor and student pilot were not injured. The airplane was operated as…NTSB WPR26LA226Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Los Angeles, CAOn June 21, 2026, about 1255 Pacific daylight time, a Cessna TR182, N2194S, sustained substantial damage when it was involved in an accident near Van Nuys, California. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA243Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Bowie, MDOn June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code…NTSB ANC26LA063Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Windom, WVOn June 21, 2026, about 1132 eastern daylight time, a Cirrus SR22 airplane, N544CD, was substantially damaged when it was involved in an accident near Windom, West Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26LA059Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · North Pole, AKNTSB 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 WPR26FA223Accident · 2 fatalClass 3 · FieldPreliminary reportComp Air CA6-WB · Nicholasville, KYOn June 20, 2026, about 0846 eastern daylight time, an experimental amateur-built Comp Air CA6-WB, N82BT, was destroyed when it was involved in an accident near Nicholasville, Kentucky. The pilot and passenger were fatally injured. The airplane was operated…NTSB ERA26LA244Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182S · Naples, FLOn June 20, 2026 at 1030 eastern daylight time, a Cessna 182S, N7270H, was substantially damaged when it was involved in an accident near Naples, Florida. The pilot and three passengers were uninjured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26LA242Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus Industrie A319-114 · Boston, MAOn June 20, 2026, about 1134 eastern daylight time (EDT), Delta Air Lines flight 2351 (DAL2351), an Airbus A319, and American Airlines flight 3161 (AAL3161), a Boeing 737-800, were involved in a runway incursion that resulted in a go-around of DAL2351 at…NTSB CEN26LA230Accident · Serious injuriesClass 3 · LimitedPreliminary reportZenith 601 XL · O'Donnell, TXOn June 20, 2026, about 1147 central daylight time, an experimental Zodiac 601XL airplane, N165TJ, was substantially damaged when it was involved in an accident near O’Donnell, Texas. The pilot sustained serious injuries. The airplane was operated as a Title…NTSB ANC26LA061Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Skwentna, AKNTSB ANC26LA058Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182Q · Beaver, AKNTSB WPR26LA225Accident · Serious injuriesClass 3 · LimitedPreliminary reportUltramagic N-300 · Pahrump, NVOn June 18, 2026, at 0645 mountain daylight time, an Ultramagic SA N-300 balloon, N330LV, was substantially damaged when it was involved in an accident near Pahrump, Nevada. The pilot and 2 passengers were seriously injured; 7 passengers sustained minor…NTSB ANC26LA055Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 105 · Petersville, AKNTSB ANC26FA057Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA20 · Cordova, AKOn June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB ERA26FA241Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 177RG · Morrison, TNOn June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…NTSB CEN26LA235Accident · No injuriesClass 4 · LimitedInvestigation openBeech V35B · Greeley, CONTSB CEN26FA228Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 680A · Laredo, TXOn June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one…NTSB WPR26LA228Accident · Minor injuriesClass 3 · LimitedPreliminary reportLancair Legacy 2000 · Los Angeles, CAOn June 16, 2026, about 0906 Pacific daylight time, an experimental amateur built Lancair Legacy 2000, N84BZ, was substantially damaged when it was involved in an accident near Los Angeles, California. The pilot sustained minor injuries. The airplane was…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 ERA26LA246Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 402 · Provincetown, MAOn June 15, 2026, about 0810 eastern daylight time, a Cessna 402C, N499CA, was substantially damaged when it was involved in an accident at Provincetown Municipal Airport (PVC), Provincetown, Massachusetts. The airplane transport pilot (pilot flying) and…NTSB ERA26FA239Accident · 1 fatalClass 3 · FieldPreliminary reportBlessing RV-3A · Lakeland, FLOn June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of…NTSB CEN26FA224Accident · 12 fatalClass 2 · FieldPreliminary reportPacific Aerospace 750XL · Butler, MOOn June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as…NTSB ANC26LA053Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Key West, FLOn June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB WPR26LA219Accident · 1 fatalClass 4 · LimitedInvestigation openCessna 208B · Marana, AZNTSB WPR26LA218Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-24-400 · Graham, TXNTSB ERA26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportScoda Aeronautica Ltda Super Petrel XP · New York, NYOn June 13, 2026, about 0924 eastern daylight time, a Scoda Aeronautica LTDA, Super Petrel XP airplane, N817PP, was substantially damaged when it was involved in an accident near New York, New York. The private pilot and a passenger were not injured. The…NTSB ANC26LA060Accident · No injuriesClass 4 · LimitedInvestigation openBeech E33 · Steamboat Springs, CONTSB ANC26LA051Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson R44 · Pembroke Pines, FLOn June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…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 ERA26LA250Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182 · Charlotte, VTNTSB CEN26LA223Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T206H · Bryant, AROn June 10, 2026, about 1223 central daylight time, a Cessna T206H airplane, N72RK, was substantially damaged when it was involved in an accident near Bryant, Arkansas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26FA222Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR20 · Wheelers Mill, OHOn June 11, 2026, about 1030 eastern daylight time, a Cirrus SR20 airplane, N858SD, was destroyed when it was involved in an accident near Wheelers Mill, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ANC26LA056Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-22-160 · Russian Mission, AKNTSB ANC26LA052Accident · Serious injuriesClass 4 · LimitedInvestigation openTimothy G Tarris Early Bird Jenny · Lamar, CO