# 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 13 of 22 · 1,083 cases ## Cases, newest first - [NTSB ANC26LA009](https://openairdocs.org/ntsb/ANC26LA009.md): Piper PA-31-310 · Anchorage, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jan 12, 2026 · N669CW · Substantial damage - [NTSB ERA26LA091](https://openairdocs.org/ntsb/ERA26LA091.md): Piper PA-28-180 · Port St. Lucie, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jan 11, 2026 · N6516J · Substantial damage > On January 10, 2026, about 1925 eastern standard time, a Piper PA-28-180, N6516J was substantially damaged when it was involved in an accident near Port St. Lucie, Florida. The pilot and passenger sustained serious injuries. The airplane was operated as a… - [NTSB CEN26LA087](https://openairdocs.org/ntsb/CEN26LA087.md): Stinson 108-3 · Gypsum, CO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 11, 2026 · N6725M · Substantial damage > On January 11, 2026, at 1408 mountain standard time, a Stinson 108-3 airplane, N6725M, sustained substantial damage when it was involved in an accident near Gypsum, Colorado. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26FA086](https://openairdocs.org/ntsb/CEN26FA086.md): Beech A36 · Sabine Pass, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 8, 2026 · N5677X · Substantial damage > On January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title… - [NTSB WPR26LA078](https://openairdocs.org/ntsb/WPR26LA078.md): Beech K35 · Prescott, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 7, 2026 · N6010E · Substantial damage > On January 7, 2026, at about 0809 mountain standard time, a Beech K35, N6010E, was substantially damaged when it was involved in an accident near Prescott, Arizona. The pilot and flight instructor were not injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26LA079](https://openairdocs.org/ntsb/CEN26LA079.md): Canard Aero SW-51 Mustang · Fredericksburg, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 5, 2026 · N351MT · Substantial damage > On January 5, 2026, about 1545 central standard time, a Canard Aero LLC (Scalewings) SW-51 Mustang, N351MT, was substantially damaged when it was involved in an accident near Fredericksburg, Texas. The pilot was not injured. The airplane was operated as a… - [NTSB ERA26FA084](https://openairdocs.org/ntsb/ERA26FA084.md): Cessna 172 · Provincetown, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 4, 2026 · N9360E · Substantial damage > On January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA074](https://openairdocs.org/ntsb/WPR26FA074.md): MD Helicopters 369FF · Superior, AZ · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jan 2, 2026 · N3502P · Substantial damage > On January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter… - [NTSB CEN26FA071](https://openairdocs.org/ntsb/CEN26FA071.md): Lancair Legacy · Fredericksburg, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 30, 2025 · N618AM · Destroyed > On December 30, 2025, about 1623 central standard time, a Lancair Legacy RG airplane, N618AM, was destroyed when it was involved in an accident near Fredericksburg, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA078](https://openairdocs.org/ntsb/ERA26LA078.md): Beech B90 · Atlanta, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 28, 2025 · N40BA · Substantial damage > On December 28, 2025, about 0935 eastern standard time, a Beech B90 airplane, N40BA, was substantially damaged when it was involved in an accident near Atlanta, Georgia. The pilot received minor injuries, and the copilot was seriously injured. The airplane… - [NTSB ERA26FA077](https://openairdocs.org/ntsb/ERA26FA077.md): Enstrom 280 · Hammonton, NJ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 28, 2025 · N280MG · 2 aircraft · Destroyed > On December 28, 2025, at 1124 eastern standard time, an Enstrom F-28A helicopter, N520H, and an Enstrom 280C helicopter, N280MG, collided in midair near Hammonton, New Jersey. The private pilots onboard each of the helicopters were fatally injured. Both… - [NTSB WPR26LA073](https://openairdocs.org/ntsb/WPR26LA073.md): Evektor - Aerotechnik A S Sportstar MAX · Needles, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 27, 2025 · N2312T · Substantial damage > On December 27, 2025, about 1109 Pacific standard time, an Evektor-Aerotechnik AS Sportstar Max LSA airplane, N2312T, was substantially damaged when it was involved in an accident near Needles, California. The pilot and pilot rated passenger were not injured.… - [NTSB CEN26LA082](https://openairdocs.org/ntsb/CEN26LA082.md): Wag Aero Cuby · Wimberley, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 26, 2025 · N437WT · Substantial damage > On December 26, 2025, about 1630 central standard time, a Wag Aero Cuby airplane, N437WT, was substantially damaged when it was involved in an accident near Wimberley, Texas. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal… - [NTSB WPR26FA069](https://openairdocs.org/ntsb/WPR26FA069.md): Piper PA-32-260 · Rio Linda, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 24, 2025 · N2785Q · Substantial damage > On December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was… - [NTSB WPR26FA068](https://openairdocs.org/ntsb/WPR26FA068.md): Beech K35 · Summer Lake, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 23, 2025 · N9540R · Substantial damage > On December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal… - [NTSB WPR26FA067](https://openairdocs.org/ntsb/WPR26FA067.md): Beechcraft B300 · Galveston, TX · Accident · 6 fatal · Class 3 · Field · Preliminary report · Dec 22, 2025 · ANX1209 · Destroyed > On December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two… - [NTSB CEN26LA080](https://openairdocs.org/ntsb/CEN26LA080.md): Cessna 150 · Prospect Heights, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 21, 2025 · N3103V · Substantial damage > On December 21, 2025, about 1342 central standard time, a Cessna 150M, N3103V, was substantially damaged when it was involved in an accident near Prospect Heights, Illinois. The student pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA073](https://openairdocs.org/ntsb/ERA26LA073.md): Cessna 172P · Browns Corner, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 20, 2025 · N54576 · Substantial damage > On December 20, 2025, at 1415 eastern standard time, a Cessna 172P airplane, N54576, was substantially damaged when it was involved in an accident near Quinton, Virginia. The private pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA066](https://openairdocs.org/ntsb/CEN26LA066.md): Cirrus Design SR22 · Springfield, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 20, 2025 · N242AZ · Substantial damage > On December 20, 2025, about 1302 central standard time, a Cirrus SR22 airplane, N242AZ, was substantially damaged when it was involved in an accident near Springfield, Missouri. The pilot and passenger were not injured. The airplane was operated as a Title 14… - [NTSB ERA26LA089](https://openairdocs.org/ntsb/ERA26LA089.md): Alon A-2A · Winter Haven, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 19, 2025 · N818SW · Substantial damage > On December 19, 2025, about 0918 EST, an Alon A-2A, N818SW, was substantially damaged when it was involved in an accident at Winter Haven Regional Airport (GIF), Winter Haven, Florida. The commercial pilot was not injured. The airplane was operated as a Title… - [NTSB WPR26MA063](https://openairdocs.org/ntsb/WPR26MA063.md): Cessna 550 · Statesville, NC · Accident · 7 fatal · Class 2 · Major · Preliminary report · Dec 18, 2025 · N257BW · Substantial damage > On December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14… - [NTSB CEN26LA072](https://openairdocs.org/ntsb/CEN26LA072.md): Cirrus Design SR22T · Muleshoe, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 18, 2025 · N53KH · Substantial damage > On December 18, 2025, about 1255 central standard time, a Cirrus SR22T, N53KH, was substantially damaged when it was involved in an accident near Muleshoe, Texas. The pilot was not injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB WPR26LA064](https://openairdocs.org/ntsb/WPR26LA064.md): Mooney M20J · Silver Springs, NV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 17, 2025 · N87PM · Substantial damage > On December 17, 2025, about 1230 Pacific standard time, a Mooney M20J, N87PM, was substantially damaged when it was involved in an accident near Silver Springs, Nevada. The pilot and passenger sustained serious injuries. The airplane was operated as a Title… - [NTSB ERA26LA070](https://openairdocs.org/ntsb/ERA26LA070.md): Holtaway Robert F Velocity V-TWIN · Nashua, NH · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 17, 2025 · N22EU · Substantial damage > On December 17, 2025, at 1410 eastern standard time, an experimental amateur-built Velocity V-Twin airplane, N22EU, was substantially damaged when it was involved in an accident near Nashua, New Hampshire. The pilot received minor injuries. The airplane was… - [NTSB CEN26FA064](https://openairdocs.org/ntsb/CEN26FA064.md): Piper PA-30 · West Chicago, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 17, 2025 · N8693Y · Substantial damage > On December 17, 2025, about 1349 central standard time, a Piper PA-30 airplane, N8693Y, was substantially damaged when it was involved in an accident near West Chicago, Illinois. The pilot and pilot-rated passenger were fatally injured. The airplane was… - [NTSB WPR26LA060](https://openairdocs.org/ntsb/WPR26LA060.md): Beechcraft G36 · Tracy, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 15, 2025 · N360FV · Substantial damage > On December 15, 2025, about 1526 Pacific standard time, a Beechcraft G36, N360FV, was substantially damaged when it was involved in an accident near Tracy, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA067](https://openairdocs.org/ntsb/ERA26FA067.md): American Champion 8KCAB · Irvington, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 13, 2025 · N157WB · Substantial damage > On December 13, 2025, about 1145 central standard time, an American Champion Decathlon, N157WB, was destroyed when it was involved in an accident near Roy E. Ray Airfield (5R7), Bayou La Batre, Alabama. The commercial pilot was fatally injured. The airplane… - [NTSB CEN26LA061](https://openairdocs.org/ntsb/CEN26LA061.md): Bell Textron Canada 505 · Divot, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 13, 2025 · N865S · Substantial damage > On December 13, 2025, about 1345 central standard time, a Bell Helicopter 505, N865S, was substantially damaged when it was involved in an accident near Divot, Texas. The pilot was seriously injured and the passenger sustained minor injuries. The helicopter… - [NTSB CEN26LA060](https://openairdocs.org/ntsb/CEN26LA060.md): Sonerai II · Cresson, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 12, 2025 · N28MD · Substantial damage > On December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA066](https://openairdocs.org/ntsb/ERA26LA066.md): Cessna TU206 · Pell City, AL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 11, 2025 · N917WC · Substantial damage > On December 11, 2025, about 1340 central standard time, a Cessna TU206F, N917WC, was substantially damaged when it was involved in an accident near Pell City, Alabama. The commercial pilot was not injured. The single passenger sustained minor injuries. The… - [NTSB WPR26FA054](https://openairdocs.org/ntsb/WPR26FA054.md): Hughes 369D · Pryor, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 5, 2025 · N161LA · Substantial damage > On December 5, 2025, about 0858 central standard time, a Hughes 369D, N161LA, was substantially damaged when it was involved in an accident near Pryor, Oklahoma. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal… - [NTSB ERA26LA061](https://openairdocs.org/ntsb/ERA26LA061.md): Mooney M20K · Foley, AL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 3, 2025 · N57229 · Substantial damage > On December 3, 2025, about 1600 central standard time, a Mooney Aircraft Corp. M20K, N57229, was substantially damaged when it was involved in an accident near Foley, Alabama. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA051](https://openairdocs.org/ntsb/WPR26FA051.md): American AA-1A · High Rolls, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 26, 2025 · N9439L · Destroyed > On November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a… - [NTSB CEN26LA052](https://openairdocs.org/ntsb/CEN26LA052.md): Gray RG12 · Benton Harbor, MI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 26, 2025 · C-FGEW · Substantial damage > On November 26, 2025, at 0920 eastern standard time, a RG12 airplane, C-FGEW, sustained substantial damage when it was involved in an accident near Benton Harbor, Michigan. The pilot and a passenger sustained minor injuries. The airplane was operated under… - [NTSB CEN26FA051](https://openairdocs.org/ntsb/CEN26FA051.md): Cessna 172N · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 25, 2025 · N80FP · Destroyed > On November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was… - [NTSB WPR26LA050](https://openairdocs.org/ntsb/WPR26LA050.md): Piper PA-46-701TP · Provo, UT · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Nov 24, 2025 · N646U · Substantial damage > On November 24, 2025, at 1529 Pacific daylight time, a Piper Aircraft Inc. PA-46-701TP (Fury), N646U, was substantially damaged when it was involved in an accident in Provo, Utah. The pilot was seriously injured and the three passengers sustained minor… - [NTSB ERA26LA056](https://openairdocs.org/ntsb/ERA26LA056.md): Piper PA-24-180 · South Brooksville, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 24, 2025 · N8328P · Substantial damage > On November 24, 2025, about 1427 eastern standard time, a Piper PA-24-180, N8328P, was substantially damaged during a forced landing near South Brooksville, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26FA050](https://openairdocs.org/ntsb/CEN26FA050.md): Socata TBM 700 · Monroe, WI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N700PT · Substantial damage > On November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated… - [NTSB CEN26FA049](https://openairdocs.org/ntsb/CEN26FA049.md): Piper PA-28R-201 · Pittsfield, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N47700 · Substantial damage > On November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2… - [NTSB ERA26LA052](https://openairdocs.org/ntsb/ERA26LA052.md): Toomey Long EZ · Beaufort, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 19, 2025 · N82MT · Substantial damage > On November 19, 2025, about 1630 eastern standard time, an experimental, amateur-built Long EZ, N82MT, was substantially damaged when it was involved in an accident near Beaufort, South Carolina. The private pilot was not injured. The airplane was operated as… - [NTSB ERA26LA050](https://openairdocs.org/ntsb/ERA26LA050.md): Cessna 401 · Eureka, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6255Q · Substantial damage > On November 18, 2025, at 12:30 eastern standard time, a Cessna 401A, N6255Q, was substantially damaged when it was involved in an accident near Eureka, North Carolina. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA046](https://openairdocs.org/ntsb/ERA26LA046.md): Cessna 172 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6124D · Substantial damage > On November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA045](https://openairdocs.org/ntsb/WPR26LA045.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2025 · N4402N · Substantial damage > On November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a… - [NTSB ERA26LA040](https://openairdocs.org/ntsb/ERA26LA040.md): Piper PA-32R-301T · Woodfin Mill, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 16, 2025 · N327HP · Substantial damage > On November 16, 2025, about 0845 eastern standard time, a Piper Pa-32R-301T, N327HP, was substantially damaged when it was involved in an accident near Woodfin Mill, Georgia. The commercial pilot sustained minor injuries. The airplane was operated as a Title… - [NTSB ERA26LA055](https://openairdocs.org/ntsb/ERA26LA055.md): Perry William Lancair IV P · Savannah, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 14, 2025 · N163BR · Substantial damage > On November 13, 2025, at 1949 eastern standard time, an experimental amateur-built Lancair IV-P, N163BR, was substantially damaged when it was involved in an accident near Savannah, Georgia. The pilot and passenger were uninjured. The airplane was operated as… - [NTSB ERA26FA039](https://openairdocs.org/ntsb/ERA26FA039.md): Jabiru USA Sport J230-SP · New Bavaria, OH · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 14, 2025 · N755J · Substantial damage > On November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was… - [NTSB CEN26LA046](https://openairdocs.org/ntsb/CEN26LA046.md): Cirrus Design SR22 · Teague, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 13, 2025 · N79EM · Substantial damage > On November 13, 2025, about 1430 central standard time, a Cirrus SR22 airplane, N79EM, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA045](https://openairdocs.org/ntsb/CEN26LA045.md): Cessna TU206F · Muscatine, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 12, 2025 · N37EW · 2 aircraft · Substantial damage > On November 12, 2025, about 14:10 central standard time, a Cessna TU206F, N37EW, and a Hawker Beechcraft Corp B300, N545KA, were substantially damaged when they were involved in an accident at Muscatine Regional Airport (MUT), Muscatine, Iowa. The pilot and… - [NTSB CEN26LA044](https://openairdocs.org/ntsb/CEN26LA044.md): Cirrus Design SR20 · Chesterfield, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N866CD · Substantial damage > On November 11, 2025, about 1750 central standard time, a Cirrus SR20, N866CD, was substantially damaged when it was involved in an accident near Chesterfield, Missouri. The pilot and copilot received minor injuries. The airplane was operated as a Title 14… - [NTSB CEN26LA042](https://openairdocs.org/ntsb/CEN26LA042.md): Piper PA-28-235 · Castle Rock, CO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N9143W · Substantial damage > On November 10, 2025, about 1815 mountain standard time, a Piper PA-28-235 airplane, N9143W, was substantially damaged when it was involved in an accident near Castle Rock, Colorado. The pilot and one passenger reported no injuries. A second passenger… Next page: https://openairdocs.org/ntsb.md?status=ongoing&page=14 ## 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=13&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.