# Ongoing NTSB investigations NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 18 of 22 · 1,083 cases ## Cases, newest first - [NTSB OPS25LA054](https://openairdocs.org/ntsb/OPS25LA054.md): Bombardier CL-600-2D24 · Freeland, MI · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N833SK · No damage > On July 16, 2025, about 1542 eastern daylight time (EDT), SkyWest Airlines (SKW) flight 3751, a Bombardier CL-600-2D24, N833SK, departed from a closed runway at MBS International Airport (MBS), Freeland, Michigan. The flight continued without further incident… - [NTSB ERA25LA269](https://openairdocs.org/ntsb/ERA25LA269.md): Beech K35 · Sylacauga, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N5353E · Substantial damage > On July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25FA213](https://openairdocs.org/ntsb/WPR25FA213.md): Scott Macwilliam SR3500 Moose · Quinault, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 15, 2025 · N80TM · Substantial damage > On July 15, 2025, at about 1440 Pacific daylight time, an experimental amateur-built Murphy Moose SR3500 airplane, N80TM, sustained substantial damage when it was involved in an accident near Quinault, Washington. The pilot received minor injuries, one… - [NTSB OPS25LA048](https://openairdocs.org/ntsb/OPS25LA048.md): Embraer ERJ 170-200 LR · Monterey, CA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 15, 2025 · N185SY · No damage > On July 15, 2025, about 0005 Pacific Daylight Time (PDT), SkyWest Airlines (SKW) flight 3005, an Embraer 170-200LR, N185SY, conducted a pilot-initiated go-around approximately 4 miles from the threshold of runway 10R at Monterey Regional Airport (MRY),… - [NTSB WPR25FA208](https://openairdocs.org/ntsb/WPR25FA208.md): Piper PA-28-180 · Needles, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 14, 2025 · N8375W · Substantial damage > On July 13, 2025, about 2128 Pacific daylight time, a Piper PA-28-180, N8375W, was substantially damaged when it was involved in an accident near Needles, California. Both pilots sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR25LA211](https://openairdocs.org/ntsb/WPR25LA211.md): Cessna 172S · Sisters, OR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N787LF · Destroyed > On July 13, 2025, about 1106 Pacific daylight time, a Cessna 172S, N787LF, was substantially damaged when it was involved in an accident near Sisters, Oregon. The flight instructor was seriously injured, and the student pilot and pilot rated passenger… - [NTSB WPR25LA210](https://openairdocs.org/ntsb/WPR25LA210.md): Hibbard Rick Rans S7 · Blackfoot, ID · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N69TY · Substantial damage > On July 12, 2025, about 2015 mountain daylight time, an experimental amateur-built Rans S7 airplane, N69TY, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was not injured. The airplane was operated as a Title 14… - [NTSB ERA25LA265](https://openairdocs.org/ntsb/ERA25LA265.md): Moyes Liteflite PTY C Dragonfly · Charlestown, NH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N4010E · Substantial damage > On July 13, 2025, about 1915 eastern daylight time, a Moyes Liteflite Model C Dragonfly airplane, N4010E, was substantially damaged when it was involved in an accident near Charleston, New Hampshire. The pilot was seriously injured. The airplane was operated… - [NTSB DCA25LA266](https://openairdocs.org/ntsb/DCA25LA266.md): Airbus A320-251N · Denver, CO · Accident · No injuries · Class 3 · Limited · Investigation open · Jul 12, 2025 · N384FR - [NTSB CEN25LA250](https://openairdocs.org/ntsb/CEN25LA250.md): Game Composites GB1 Gamebird · Tarkio, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 12, 2025 · N588AF · 2 aircraft · Substantial damage > On July 12, 2025, about 0830 central daylight time, a Game Composites GB-1 Gamebird airplane, N588AF, was substantially damaged, and a Vans RV-8, N931KZ, sustained minor damage, when they were involved in an accident near the Gould Peterson Municipal Airport… - [NTSB CEN25FA248](https://openairdocs.org/ntsb/CEN25FA248.md): Piper PA-25 · Hot Springs, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N8186K · Substantial damage > On July 12, 2025, about 1322 mountain daylight time, a Piper PA-25, N8186K, was substantially damaged when it was involved in an accident near Hot Springs, South Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN25FA247](https://openairdocs.org/ntsb/CEN25FA247.md): Zenith CH601 · Pawnee National Grassland, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N314LB · Destroyed > On July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the… - [NTSB WPR25LA204](https://openairdocs.org/ntsb/WPR25LA204.md): Beech A36 · Coolin, ID · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 9, 2025 · N41VH · Substantial damage > On July 8, 2025, about 1840 Pacific daylight time, a Beech A36, N41VH, was substantially damaged when it was involved in an accident near Coolin, Idaho. The pilot and passenger sustained minor injuries. The airplane was operated under Title 14 Code of Federal… - [NTSB ERA25LA261](https://openairdocs.org/ntsb/ERA25LA261.md): Cessna 172H · Century, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 9, 2025 · N3254C · Substantial damage > On July 9, 2025, about 1820 central daylight time, a Cessna 172, N3254C, was involved in an accident near Century, Florida. The pilot and the passenger were not injured. The flight was conducted as a 14 Code of Federal Regulations Part 91 personal flight. The… - [NTSB ERA25FA260](https://openairdocs.org/ntsb/ERA25FA260.md): Cirrus Design SR22T · Sanford, NC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jul 7, 2025 · N5656M · Substantial damage > On July 7, 2025, about 1330 eastern daylight time, a Cirrus SR22T, N5656M, was substantially damaged when it was involved in an accident near Sanford, North Carolina. The private pilot and three passengers were fatally injured. The airplane was operated as a… - [NTSB CEN25LA242](https://openairdocs.org/ntsb/CEN25LA242.md): Sikorsky UH60 · Ingram, TX · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2025 · UNREG · Minor damage > On July 7, 2025, about 1557 central daylight time, an unregistered Sikorsky UH-60 Black Hawk helicopter collided with an unregistered DJI Mavic 3T unmanned aerial vehicle (drone) near Ingram, Texas. The UH-60 received substantial damage to the tail rotor… - [NTSB WPR25FA205](https://openairdocs.org/ntsb/WPR25FA205.md): Beech F35 · Eagle Nest, NM · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 6, 2025 · N5009B · Destroyed > On July 6, 2025, about 1345 mountain daylight time, a Beech F35, N5009B, was destroyed when it was involved in an accident near Eagle Nest, New Mexico. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB ANC25LA065](https://openairdocs.org/ntsb/ANC25LA065.md): Cessna 180J · King Salmon, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 5, 2025 · N52009 · Substantial damage > On July 5, 2025, about 1430 Alaska daylight time, a Cessna 180J airplane, N52009, was substantially damaged when it was involved in an accident near King Salmon, Alaska. The pilot and two passengers were seriously injured and one passenger sustained minor… - [NTSB WPR25LA207](https://openairdocs.org/ntsb/WPR25LA207.md): Cessna 182B · Belen, NM · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 4, 2025 · N7166E · Substantial damage > On July 4, 2025, about 0900 mountain daylight time, a Cessna 182B, N7166E, was substantially damaged when it was involved in an accident near Belen, New Mexico. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB ANC25LA063](https://openairdocs.org/ntsb/ANC25LA063.md): Cessna 182G · Kona, HI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 3, 2025 · N3261S · Substantial damage > On July 3, 2025, about 0657 Hawaii-Aleutian standard time, a Cessna 182G airplane, N3261S, was substantially damaged when it was involved in an accident near Kona, Hawaii. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR25FA197](https://openairdocs.org/ntsb/WPR25FA197.md): Evolution Revolt · Mount Vernon, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N774RS · Substantial damage > On July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally… - [NTSB ERA25LA254](https://openairdocs.org/ntsb/ERA25LA254.md): Cessna 208 · Monroe, NJ · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 2, 2025 · N716MM · Substantial damage > On July 2, 2025, about 1729 eastern daylight time, a Cessna 208B, N716MM, was substantially damaged when it was involved in an accident near Monroe, New Jersey. The two commercial pilots and 10 passengers were seriously injured, while three passengers… - [NTSB ERA25FA253](https://openairdocs.org/ntsb/ERA25FA253.md): Ercoupe 415 · Gallatin, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N93985 · Substantial damage > On July 2, 2025, about 1300 central daylight time, an Ercoupe 415-C, N93985, was substantially damaged when it was involved in an accident near Gallatin, Tennessee. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN25LA233](https://openairdocs.org/ntsb/CEN25LA233.md): ICP Savannah S · Slaughter, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N5000S · Substantial damage > On June 30, 2025, about 1932 central daylight time an I.C.P. Srl Savannah S light sport airplane, N5000S was substantially damaged when it was involved in an accident near Slaughter, LA. The pilot and passenger were not injured. The flight was operated under… - [NTSB CEN25LA232](https://openairdocs.org/ntsb/CEN25LA232.md): Bell 206B · Edgerton, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N16726 · Substantial damage > On July 1, 2025, at 0845 central daylight time, a Bell 206B, N17626, was substantially damaged when it was involved in an accident near Edgerton, Missouri. The commercial pilot was uninjured. The helicopter was operated under Title 14 Code of Federal… - [NTSB CEN25LA229](https://openairdocs.org/ntsb/CEN25LA229.md): Rans S-14 · Guthrie, OK · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N981CS · Substantial damage > On June 30, 2025, about 2054 central daylight time, a Rans S-14 airplane, N981CS, was substantially damaged when it was involved in an accident near Guthrie, Oklahoma. The non-certificated pilot was fatally injured. The airplane was operated as a Title 14… - [NTSB ANC25LA060](https://openairdocs.org/ntsb/ANC25LA060.md): Piper PA-22-150 · Chinitna Bay, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N3609Z · Substantial damage > On June 30, 2025, about 1630 Alaska daylight time, a Piper PA 22-150 airplane, N3609Z, was substantially damaged when it was involved in an accident near Chinitna Bay, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA200](https://openairdocs.org/ntsb/WPR25LA200.md): Faust 3 · Harrison, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 30, 2025 · N5901V · Substantial damage > On June 30, 2025, about 1200 mountain daylight time, an experimental amateur built Faust 3, N5901V, sustained substantial damage when it was involved in an accident near Harrison, Montana. The pilot and passenger were not injured. The airplane was operated as… - [NTSB WPR25LA301](https://openairdocs.org/ntsb/WPR25LA301.md): Piper PA-24-260 · West Yellowstone, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 29, 2025 · N9366P · Substantial damage > On June 29, 2025, at 1033 mountain daylight time, a Piper PA-24-260, N9366P, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25FA248](https://openairdocs.org/ntsb/ERA25FA248.md): Robert Fidler Lancair 320/360 · Zeeland, MI · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 29, 2025 · N360RF · Destroyed > On June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ERA25FA246](https://openairdocs.org/ntsb/ERA25FA246.md): Cessna 441 · Warren, OH · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 29, 2025 · N441LS · Substantial damage > On June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB WPR25LA195](https://openairdocs.org/ntsb/WPR25LA195.md): Cessna 150F · Tracy, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 28, 2025 · N6744F · Substantial damage > On June 28, 2025, about 1420 Pacific daylight time, a Cessna 150F, N6744F, was substantially damaged when it was involved in an accident at Tracy Municipal Airport (TCY), Tracy, California. The pilot was not injured. The airplane was operated as a Title 14… - [NTSB CEN25FA224](https://openairdocs.org/ntsb/CEN25FA224.md): Vans RV-10 · Capron, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 28, 2025 · N847CS · Substantial damage > On June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25FA190](https://openairdocs.org/ntsb/WPR25FA190.md): MD Helicopters 369E · Meeker, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 25, 2025 · N411WJ · Substantial damage > On June 25, 2025, about 1001 mountain daylight time, an MD Helicopters 369E, N411WJ, was substantially damaged when it was involved in an accident near Meeker, Colorado. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal… - [NTSB ERA25FA239](https://openairdocs.org/ntsb/ERA25FA239.md): Piper J3C-65 · Dunlap, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 24, 2025 · N28DR · Substantial damage > On June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane… - [NTSB ANC25LA055](https://openairdocs.org/ntsb/ANC25LA055.md): Piper PA-32R-300 · Big Lake, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 24, 2025 · N3609Q · Substantial damage > On June 24, 2025, about 0934 Alaska daylight time, a Piper PA-32R-300 airplane, N3609Q, was substantially damaged when it was involved in an accident near Big Lake, Alaska. The pilot and flight instructor were seriously injured. The airplane was operated as a… - [NTSB WPR25LA188](https://openairdocs.org/ntsb/WPR25LA188.md): Filby Gerry RV-9 · Morgan Hill, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 23, 2025 · N696WG · Substantial damage > On June 23, 2025, about 1217 Pacific daylight time, an experimental amateur-built Vans Aircraft Inc RV-9 airplane, N696WG, was substantially damaged when it was involved in an accident near Morgan Hill, California. The pilot sustained minor injuries. The… - [NTSB CEN25FA216](https://openairdocs.org/ntsb/CEN25FA216.md): Murphy Aircraft Manufacturing Moose · Montrose, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 23, 2025 · N250MK · Destroyed > On June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.… - [NTSB ERA25FA231](https://openairdocs.org/ntsb/ERA25FA231.md): Pitts S2 · Broadway, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 20, 2025 · N79AV · Substantial damage > On June 20, 2025, at 0900 eastern daylight time, a Pitts Aerobatics S-2B, N79AV, was destroyed when it was involved in an accident near Broadway, North Carolina. The private pilot and the commercial pilot-rated passenger were fatally injured. The airplane was… - [NTSB WPR25FA182](https://openairdocs.org/ntsb/WPR25FA182.md): Cessna 172 · Billings, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 19, 2025 · N79306 · Substantial damage > On June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN25FA212](https://openairdocs.org/ntsb/CEN25FA212.md): Cessna A150L · Three Points, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 18, 2025 · N6436F · Substantial damage > On June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was… - [NTSB WPR25LA174](https://openairdocs.org/ntsb/WPR25LA174.md): Quitter John F MXL II · Acampo, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 14, 2025 · N375ME · Substantial damage > On June 14, 2025, about 1511 Pacific daylight time, an experimental MXL II, N375ME, was substantially damaged when it was involved in an accident near Acampo, California. The pilot was uninjured, and the passenger was seriously injured. The airplane was… - [NTSB ERA25FA228](https://openairdocs.org/ntsb/ERA25FA228.md): Beech 58 · Tabor City, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 14, 2025 · N82UC · Destroyed > On June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ANC25LA052](https://openairdocs.org/ntsb/ANC25LA052.md): Stinson 108 · Cantwell, AK · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 14, 2025 · N2101Q · Substantial damage > On June 14, 2025, about 1415 Alaska daylight time, a Stinson 108 airplane, N2101Q, was substantially damaged when it was involved in an accident near Cantwell, Alaska. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14… - [NTSB ERA25LA234](https://openairdocs.org/ntsb/ERA25LA234.md): Steven Scott Grasley RV-7A · Interlachen, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 13, 2025 · N783RV · Substantial damage > On June 13, 2025, about 15:31 eastern daylight time, an experimental, amateur built RV-7A, N783RV, was substantially damaged when it was involved in an accident near Interlachen, Florida. The commercial pilot received minor injuries. The airplane was operated… - [NTSB ERA25LA229](https://openairdocs.org/ntsb/ERA25LA229.md): Robinson Helicopter R66 · Valparaiso, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N633AF · Substantial damage > On June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not… - [NTSB ERA25LA227](https://openairdocs.org/ntsb/ERA25LA227.md): Cirrus Design SR22 · Hartsville, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N312DA · Substantial damage > On June 12, 2025, about 1750 central daylight time, a Cirrus SR22, N312DA, was substantially damaged when it was involved in an accident near Hartsville, Tennessee. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA25LA233](https://openairdocs.org/ntsb/DCA25LA233.md): Boeing 747-47UF · Guayaquil, Ecuador · Incident · No injuries · Class 4 · Limited · Investigation open · Jun 12, 2025 · N476MC · Minor damage - [NTSB CEN25LA205](https://openairdocs.org/ntsb/CEN25LA205.md): Lancair 360 · Fort Stockton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N77LH · Destroyed > On June 11, 2025, about 2145 central daylight time, a Lancair 360 airplane, N77LH, was destroyed when it was involved in an accident near Fort Stockton, Texas. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25FA169](https://openairdocs.org/ntsb/WPR25FA169.md): Cessna 414 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 8, 2025 · N414BA · Substantial damage > On June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of… Next page: https://openairdocs.org/ntsb.md?status=ongoing&page=19 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 ``` This list as a web page: https://openairdocs.org/ntsb?page=18&status=ongoing --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.