# Ongoing NTSB investigations: Off-field or emergency landing 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 1 of 2 · 53 cases ## Latest cases - [NTSB CEN26LA313](https://openairdocs.org/ntsb/CEN26LA313.md): Stearman A75 · Bogue Chitto, MS · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 8, 2026 · N680HW · Substantial damage > On September 8, 2026, about 1100 central daylight time, a Boeing-Stearman A75L300 airplane, N680HW, was substantially damaged when it was involved in an accident near Bogue Chitto, Mississippi. The pilot sustained minor injuries and the passenger was… - [NTSB ERA26LA328](https://openairdocs.org/ntsb/ERA26LA328.md): Piper PA-28-180 · Dallas, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 4, 2026 · N7635W · Substantial damage > On September 3, 2026, at 2004 eastern daylight time, a Piper PA-28-180, N7635W, was substantially damaged when it was involved in an accident near Dallas, Georgia. The flight instructor and student pilot were seriously injured. The airplane was operated as a… - [NTSB ERA26FA310](https://openairdocs.org/ntsb/ERA26FA310.md): Diamond Aircraft Ind DA20-A1 · Bristol, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2026 · N83RF · Substantial damage > On August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor… - [NTSB ERA26LA303](https://openairdocs.org/ntsb/ERA26LA303.md): Mcfarland Larry C Zenith 601 HDS · Ripley Landing, WV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2026 · N601EZ · Substantial damage > On August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.… - [NTSB ERA26LA358](https://openairdocs.org/ntsb/ERA26LA358.md): Piper PA24 · Union City, OH · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 10, 2026 · N6985P · Substantial damage > On August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a… - [NTSB ERA26LA296](https://openairdocs.org/ntsb/ERA26LA296.md): Piper PA32 · Dawsonville, GA · Accident · Serious injuries · Class 3 · Limited · Investigation open · Aug 9, 2026 · N3011X - [NTSB ERA26LA295](https://openairdocs.org/ntsb/ERA26LA295.md): Mooney M20E · Conway, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 9, 2026 · N9257V · Substantial damage > On August 9, 2026 at 802 eastern daylight time, a Mooney M20E, N9257V, was substantially damaged when it was involved in an accident near Conway, South Carolina. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB CEN26LA276](https://openairdocs.org/ntsb/CEN26LA276.md): Robinson Helicopter R44 II · Bennett, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 2, 2026 · N26KL · Substantial damage > On 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 CEN26LA269](https://openairdocs.org/ntsb/CEN26LA269.md): Aero Commander Callair A-9B · Livonia, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 27, 2026 · N7799V · Substantial damage > On 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 ANC26LA076](https://openairdocs.org/ntsb/ANC26LA076.md): Cessna 180K · Anchorage, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 22, 2026 · N180LW · Substantial damage - [NTSB CEN26FA257](https://openairdocs.org/ntsb/CEN26FA257.md): Dakota Cub Super 18 · Plymouth, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 16, 2026 · N84AJ · Substantial damage > On 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 ERA26LA254](https://openairdocs.org/ntsb/ERA26LA254.md): Rath Michael J Sonerai 2 · Cynthiana, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 30, 2026 · N1406 · Substantial damage > On June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA251](https://openairdocs.org/ntsb/ERA26LA251.md): Jones Peter M Boeing/Jones 75 · Cleveland, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 26, 2026 · N3993C · Substantial damage > On 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 CEN26LA230](https://openairdocs.org/ntsb/CEN26LA230.md): Zenith 601 XL · O'Donnell, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N165TJ · Substantial damage > On 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 WPR26LA209](https://openairdocs.org/ntsb/WPR26LA209.md): Cirrus Design SR22T · Casper, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2026 · N324WY · Substantial damage > On June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA224](https://openairdocs.org/ntsb/ERA26LA224.md): Boeing E75 · Dresden, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N181RF · Substantial damage > On May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA219](https://openairdocs.org/ntsb/ERA26LA219.md): Rainbow Cheetah XLS · Knightdale, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N146RC · Substantial damage > On May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were… - [NTSB ERA26LA216](https://openairdocs.org/ntsb/ERA26LA216.md): Cessna A188B · Doerun, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 23, 2026 · N8288G · Substantial damage > On May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB CEN26LA202](https://openairdocs.org/ntsb/CEN26LA202.md): Piper PA-32R-300 · Comanche, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N4556Q · Substantial damage > On May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA197](https://openairdocs.org/ntsb/ERA26LA197.md): Cessna 182 · Lancaster, OH · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 4, 2026 · N9069X · Substantial damage > On May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA195](https://openairdocs.org/ntsb/ERA26LA195.md): Air Tractor AT-602 · Bealeton, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N602RH · Substantial damage > On May 1, 2026, at 1230 eastern daylight time, an Air Tractor AT-602, N602RH, was substantially damaged when it was involved in an accident near Bealeton, Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB ERA26FA178](https://openairdocs.org/ntsb/ERA26FA178.md): Mooney M20J · Ironton, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N205MK · Substantial damage > On April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB WPR26LA158](https://openairdocs.org/ntsb/WPR26LA158.md): Alexander Schleicher ASH 31 MI · Williams, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2026 · N77UK · Substantial damage > On April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The… - [NTSB ERA26LA145](https://openairdocs.org/ntsb/ERA26LA145.md): Rockwell International 114 · Whitmire, SC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 10, 2026 · N4832W · Substantial damage > On March 10, 2026, about 1915 eastern daylight time, a Rockwell International 114 airplane, N4832W, was substantially damaged when it was involved in an accident near Whitmire, South Carolina. The flight instructor received minor injuries. The pilot receiving… - [NTSB ERA26LA127](https://openairdocs.org/ntsb/ERA26LA127.md): Piper PA-28-151 · Arno, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 24, 2026 · N85RW · Substantial damage > On February 24, 2026, about 1107 central standard time, a Piper PA-28-151, N85RW, was substantially damaged when it was involved in an accident near Arno, Tennessee. The pilot was not injured. The airplane was operated as a 14 Code of Federal Regulations Part… - [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 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 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 ERA26FA027](https://openairdocs.org/ntsb/ERA26FA027.md): Mooney M20E · Ballston Spa, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 31, 2025 · N79338 · Destroyed > On October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was… - [NTSB CEN26LA031](https://openairdocs.org/ntsb/CEN26LA031.md): Denney Kitfox · Chilton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 27, 2025 · N5241N · Substantial damage > On October 27, 2025, about 0530 central daylight time, a Denney Kitfox III airplane, N5241N, was substantially damaged when it was involved in an accident near Chilton, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14… - [NTSB ANC26LA001](https://openairdocs.org/ntsb/ANC26LA001.md): Cessna 172N · Petersburg, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N80628 · Substantial damage > On October 7, 2025, at 1456 Alaska daylight time, a Cessna 172 airplane, N80628, was substantially damaged when it was involved in an accident near Petersburg, Alaska. The student pilot and flight instructor were not injured. The airplane was operated as a… - [NTSB ERA25LA369](https://openairdocs.org/ntsb/ERA25LA369.md): Gregory A Spicola AR-1 · Fort Myers, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 28, 2025 · N107AR · Substantial damage > On September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.… - [NTSB WPR25LA292](https://openairdocs.org/ntsb/WPR25LA292.md): Cessna 182N · Fallbrook, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 23, 2025 · N766EE · Substantial damage > On September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25LA362](https://openairdocs.org/ntsb/ERA25LA362.md): Cessna 182F · Williamsburg, VA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 22, 2025 · N3192U · Substantial damage > On September 22, 2025, about 1730 eastern daylight time, a Cessna 182F, N3192U, was substantially damaged when it was involved in an accident near Williamsburg, Virginia. The airline transport pilot sustained minor injuries. The airplane was operated as a… - [NTSB ERA25LA350](https://openairdocs.org/ntsb/ERA25LA350.md): Piper PA-28-181 · Astatula, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 17, 2025 · N580JA · Substantial damage > On September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of… - [NTSB ERA25LA345](https://openairdocs.org/ntsb/ERA25LA345.md): Cessna 172 · Williston, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N345QA · Substantial damage > On September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25LA346](https://openairdocs.org/ntsb/ERA25LA346.md): Piper PA-24-180 · Ashland City, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 5, 2025 · N5759P · Substantial damage > On September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a… - [NTSB WPR25LA259](https://openairdocs.org/ntsb/WPR25LA259.md): Czech Aircraft Group Sro Sportcruiser · Puyallup, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 25, 2025 · N538SF · Substantial damage > On August 25, 2025, about 1456 Pacific daylight time, a Czech Aircraft Group SRO Sportcruiser, N538SF was substantially damaged when it was involved in an accident near Puyallup, Washington. The pilot sustained serious injuries, and the passenger was not… - [NTSB WPR25LA265](https://openairdocs.org/ntsb/WPR25LA265.md): Cessna 120 · Taylor, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N3151N · Substantial damage > On August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25LA313](https://openairdocs.org/ntsb/ERA25LA313.md): Raytheon A36 · Gulf Shores, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N855DC · Substantial damage > On August 24, 2025, about 1500 eastern daylight time, a Raytheon Aircraft Company A36, N855DC, was substantially damaged when it was involved in an accident near Gulf Shores, Alabama. The pilot and passenger were seriously injured. The airplane was operated… - [NTSB WPR25LA261](https://openairdocs.org/ntsb/WPR25LA261.md): Piper PA-28-181 · San Diego, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 17, 2025 · N8150J · Substantial damage > On August 16, 2025, about 1737 Pacific daylight time, a Piper PA-28-181, N8150J, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code… - [NTSB CEN25LA309](https://openairdocs.org/ntsb/CEN25LA309.md): Vans RV4 · Elgin, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N595BS · Substantial damage > On August 6, 2025, about 1925 central daylight time, a Vans RV4 airplane, N595BS, was substantially damaged when it was involved in an accident near Elgin, Illinois. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA283](https://openairdocs.org/ntsb/ERA25FA283.md): Piper J5C · Rochester, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N28151 · Substantial damage > On August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was… - [NTSB CEN25FA269](https://openairdocs.org/ntsb/CEN25FA269.md): Aero Vodochody L-39C · Granite Falls, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 21, 2025 · N339L · Substantial damage > On July 21, 2025, about 1728 central daylight time, an Aero Vodochody L-39C airplane, N339L, was substantially damaged during an accident near Granite Falls, Minnesota. The flight instructor, seated in the front seat, sustained serious injuries after ejecting… - [NTSB ERA25LA270](https://openairdocs.org/ntsb/ERA25LA270.md): Piper PA46 · Sunset, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 17, 2025 · N460WW · Substantial damage > On July 17, 2025, about 1122 eastern daylight time, a Piper PA-46-310P, N460WW, was substantially damaged when it was involved in an accident near Sunset, South Carolina. The commercial pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25LA163](https://openairdocs.org/ntsb/WPR25LA163.md): Rans S20 · Fairfield, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · May 27, 2025 · N327KM · Substantial damage > On May 27, 2025, about 1330 mountain daylight time, an experimental amateur-built RANS S20 Raven, N327KM, was substantially damaged when it was involved in an accident near Fairfield, Utah. The pilot was not injured. The airplane was operated as a Title 14… - [NTSB ERA25LA214](https://openairdocs.org/ntsb/ERA25LA214.md): Jernigan Zenith 750 · Greenville, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · May 18, 2025 · N864AJ · Substantial damage > On May 18, 2025, about 1416 eastern daylight time, an experimental, amateur-built Zenith 750, N864AJ, was substantially damaged when it was involved in an accident near Greenville, South Carolina. The private pilot was not injured. The airplane was operated… - [NTSB CEN25LA111](https://openairdocs.org/ntsb/CEN25LA111.md): Piper PA-28-140 · Pearland, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 6, 2025 · N54479 · Substantial damage > On March 6, 2025, about 1145 central standard time, a Piper PA-28-140 airplane, N54479, was substantially damaged when it was involved in an accident near Pearland, Texas. One pilot sustained minor injuries, and the other pilot was not injured. The airplane… - [NTSB CEN25LA096](https://openairdocs.org/ntsb/CEN25LA096.md): Grumman American Avn. AA-5A · Gladewater, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 18, 2025 · N26071 · Substantial damage > On February 17, 2025, about 2215 central standard time, a Grumman AA-5A airplane, N26071, was substantially damaged when it was involved in an accident near Gladewater, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN25LA097](https://openairdocs.org/ntsb/CEN25LA097.md): Douglas A-20G · Laredo, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Feb 16, 2025 · N747HS · Substantial damage > On February 16, 2025, about 1239 central standard time, a Douglas A-20G airplane, N747HS, was substantially damaged when it was involved in an accident in Laredo, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal… Next page: https://openairdocs.org/ntsb-events/440/sequence.md?status=ongoing&page=2 ## 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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' 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 ``` This list as a web page: https://openairdocs.org/ntsb-events/440/sequence?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.