# 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 21 of 22 · 1,078 cases ## Cases, newest first - [NTSB ERA25LA116](https://openairdocs.org/ntsb/ERA25LA116.md): Mackey Property Holdings Sparker · Asheboro, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 11, 2025 · N769DM > On February 11, 2025, about 0635 eastern standard time, an experimental amateur-built Sparker, N769DM, was substantially damaged when it was involved in an accident near Asheboro, North Carolina. The pilot was not injured. The airplane was operated as a Title… - [NTSB WPR25FA088](https://openairdocs.org/ntsb/WPR25FA088.md): Gates Learjet 35A · Scottsdale, AZ · Accident · 1 fatal · Class 2 · Field · Preliminary report · Feb 10, 2025 · N81VN · Substantial damage > On February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously… - [NTSB ERA25LA113](https://openairdocs.org/ntsb/ERA25LA113.md): Vulcanair S P A Vulcanair V1.0 · Cheswold, DE · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 8, 2025 · N186DS · Substantial damage > On February 7, 2025, at 2233 eastern standard time, a Vulcanair S.p.A V1.0, N186DS, was substantially damaged when it was involved in an accident near Cheswold, Delaware. The private pilot and pilot-rated passenger were uninjured. The airplane was operated as… - [NTSB CEN25LA094](https://openairdocs.org/ntsb/CEN25LA094.md): Beech 58P · Pine Bluff, AR · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 6, 2025 · N138TL · Substantial damage > On February 5, 2025, about 1848 central standard time, a Beech 58P airplane, N138TL, was substantially damaged when it was involved in an accident near Pine Bluff, Arkansas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25MA106](https://openairdocs.org/ntsb/ERA25MA106.md): Learjet 55 · Philadelphia, PA · Accident · 7 fatal · Class 2 · Major · Preliminary report · Jan 31, 2025 · XA-UCI · Destroyed > On January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two… - [NTSB ERA25LA107](https://openairdocs.org/ntsb/ERA25LA107.md): Aviat Pitts S-2B · Fellsmere, FL · Accident · Class 3 · Limited · Preliminary report · Jan 30, 2025 · N8ZT > On January 30, 2025, at 1034 eastern standard time, an Aviat Inc Pitts S-2B, N8ZT, was substantially damaged when it was involved in an accident near Fellsmere, Florida. The private pilot was seriously injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA103](https://openairdocs.org/ntsb/ERA25FA103.md): Beech V35B · Charlottesville, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 25, 2025 · N2UZ · Destroyed > On January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB DCA25LA093](https://openairdocs.org/ntsb/DCA25LA093.md): Boeing 787-8 · Dabouzra, Côte d’Ivoire · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jan 24, 2025 · N27903 · No damage > On January 24, 2025, about 00:31 universal coordinated time (UTC), United Airlines (UAL) flight 613, a Boeing 787-8, experienced altitude excursions during cruise flight while transitioning over Cote d’Ivoire airspace at 36,000 feet. Of the 11 crew members… - [NTSB ERA25LA098](https://openairdocs.org/ntsb/ERA25LA098.md): Montaer Ltda Montaer MC01 · Miramar, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 19, 2025 · N916VS · Substantial damage > On January 19, 2025, about 1410 eastern standard time, a Montaer MC-01, N916VS, was substantially damaged when it was involved in an accident near Miramar, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR25LA084](https://openairdocs.org/ntsb/WPR25LA084.md): Cessna P210N · Prescott, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 18, 2025 · N4626K · Substantial damage > On January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a… - [NTSB WPR25FA079](https://openairdocs.org/ntsb/WPR25FA079.md): Piper PA-24-250 · Rock Springs, WY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 14, 2025 · N6502P > On January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB WPR25FA072](https://openairdocs.org/ntsb/WPR25FA072.md): Vans RV-10 · Fullerton, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jan 2, 2025 · N8757R · Substantial damage > On January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19… - [NTSB ERA25LA088](https://openairdocs.org/ntsb/ERA25LA088.md): Beech A36 · Naples, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 1, 2025 · N8163F · Substantial damage > On January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was… - [NTSB ERA25FA086](https://openairdocs.org/ntsb/ERA25FA086.md): Cessna 310 · Peebles, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 30, 2024 · N6979T · Substantial damage > On December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA25FA071](https://openairdocs.org/ntsb/DCA25FA071.md): Boeing 737 · Henderson, NV · Accident · Serious injuries · Class 3 · Field · Preliminary report · Dec 26, 2024 · N958AK · No damage > On December 26, 2024, at 1335 pacific standard time, Alaska Airlines flight 700, a Boeing 737-9, N958AK, encountered severe turbulence during cruise flight, near Henderson, Nevada. Of the 181 passengers and crew, two flight attendants received serious… - [NTSB ERA25FA080](https://openairdocs.org/ntsb/ERA25FA080.md): Beech A36 · East Aurora, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 19, 2024 · N36WP · Destroyed > On December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB ANC25FA010](https://openairdocs.org/ntsb/ANC25FA010.md): Cessna 208B · Honolulu, HI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 18, 2024 · N689KA · Destroyed > On December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as… - [NTSB ERA25FA069](https://openairdocs.org/ntsb/ERA25FA069.md): Vans RV-12IS · Homosassa, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 7, 2024 · N702DP · Substantial damage > On December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight… - [NTSB ERA25FA066](https://openairdocs.org/ntsb/ERA25FA066.md): Schleicher ASW24 · Vero Beach, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 6, 2024 · N244RW · Substantial damage > On December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and… - [NTSB WPR25LA055](https://openairdocs.org/ntsb/WPR25LA055.md): Vans RV14 · Palmdale, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 5, 2024 · N144SD · Substantial damage > On December 15, 2024, about 1303 pacific standard time, an experimental amateur built Vans RV-14, N144SD, was substantially damaged when it was involved in an accident near Palmdale, California. The pilot was not injured. The airplane was operated as a Title… - [NTSB WPR25LA054](https://openairdocs.org/ntsb/WPR25LA054.md): Cessna 150L · Glen Avon, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 4, 2024 · N5330Q · Substantial damage > On December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA065](https://openairdocs.org/ntsb/ERA25FA065.md): Truitt James B Vans RV-8A · Fort Blackmore, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 4, 2024 · N627TT · Substantial damage > On December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was… - [NTSB WPR25LA052](https://openairdocs.org/ntsb/WPR25LA052.md): Beech 35-33 · Willcox, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 1, 2024 · N109V > On December 1, 2024, about 1300 mountain standard time, a Beech 35-33, N109V, was substantially damaged when it was involved in an accident near Willcox, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB ERA25LA061](https://openairdocs.org/ntsb/ERA25LA061.md): Beech B300 · Franklin, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 28, 2024 · N907EJ · Substantial damage > On November 28, 2024, about 1019 eastern standard time, a Beech B300, N907EJ, was substantially damaged when it was involved in an accident near Franklin, North Carolina. The airline transport pilot was not injured. The airplane was operated as a Title… - [NTSB CEN25FA052](https://openairdocs.org/ntsb/CEN25FA052.md): Cozy MK III · Mineola, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 28, 2024 · N51810 · Destroyed > On November 27, 2024, about 18:30 central standard time, a Cozy Mark III, N51810 was destroyed when it was involved in an accident near Mineola, Texas. The pilot and passenger were fatally injured. The flight was operated under the provisions of Title 14 Code… - [NTSB ERA25FA058](https://openairdocs.org/ntsb/ERA25FA058.md): Mooney M20J · Windham, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 24, 2024 · N58156 · Substantial damage > On November 24, 2024, at about 1809 eastern standard time, a Mooney M20J, N58156, was substantially damaged when it was involved in an accident near Windham, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA25LA045](https://openairdocs.org/ntsb/DCA25LA045.md): Embraer S A ERJ 170-200 LR · Warnock, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Nov 20, 2024 · N85352 · No damage > On November 20, 2024, about 1846 eastern standard time (2346 UTC), a Mesa Airlines, Inc., Embraer SA ERJ 170-200 LR, N85352, dba as United Express flight 6149, encountered “moderate to severe” turbulence during descent to its destination, Cleveland Hopkins… - [NTSB WPR25LA045](https://openairdocs.org/ntsb/WPR25LA045.md): Bombardier CL-600-2B16 · Jackson, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2024 · N247QS · Substantial damage > On November 17, 2024, about 0945 mountain standard time, a Bombardier Inc. CL-600-2B16 (Challenger 650), N247QS, was substantially damaged when it was involved in an accident near Jackson, Wyoming. The 2 pilots and 9 passengers were not injured. The airplane… - [NTSB CEN25FA040](https://openairdocs.org/ntsb/CEN25FA040.md): Beech 35-B33 · Nunn, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 15, 2024 · N285BW · Destroyed > On November 15, 2024, about 1000 mountain standard time (MST), a Beech 35-B33, N285BW, was destroyed when it was involved in an accident near Nunn, Colorado. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB WPR25FA031](https://openairdocs.org/ntsb/WPR25FA031.md): Honda HA420 · Mesa, AZ · Accident · 5 fatal · Class 3 · Field · Preliminary report · Nov 5, 2024 · N57HP · Destroyed > On November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of… - [NTSB CEN25FA034](https://openairdocs.org/ntsb/CEN25FA034.md): Robinson Helicopter R44 II · Iowa, LA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Nov 2, 2024 · N62CD · Destroyed > On November 1, 2024, about 2106 central daylight time, a Robinson R-44 II helicopter, N62CD, was destroyed when it was involved in an accident near Iowa, Louisiana. The pilot and two passengers were fatally injured. The helicopter was operated as a Title 14… - [NTSB OPS25LA008](https://openairdocs.org/ntsb/OPS25LA008.md): Boeing 737-832 · Miami, FL · Incident · Class 4 · Limited · Investigation open · Oct 30, 2024 · N385DN · 2 aircraft · No damage - [NTSB CEN25FA033](https://openairdocs.org/ntsb/CEN25FA033.md): Beech 58 · Arlberg, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 29, 2024 · N811PB · Destroyed > On October 29, 2024, about 1426 central daylight time, a Beech 58 airplane, N811PB, was destroyed when it was involved in an accident near Arlberg, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB WPR25LA025](https://openairdocs.org/ntsb/WPR25LA025.md): Badlands Vaquero · West Wendover, NV · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 27, 2024 · N510DH · Substantial damage > On October 27, 2024, about 0915 Pacific daylight time, an experimental amateur-built Badlands Vaquero airplane, N510DH, was destroyed when it was involved in an accident near West Wendover, Nevada. The pilot sustained minor injuries. The airplane was operated… - [NTSB CEN25LA028](https://openairdocs.org/ntsb/CEN25LA028.md): Cessna 182Q · Rose Hill, KS · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Oct 26, 2024 · N8883X · No damage > On October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title… - [NTSB WPR25LA024](https://openairdocs.org/ntsb/WPR25LA024.md): Hayden ED RV10 · Beaver Marsh, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 19, 2024 · N929EH · Substantial damage > On October 19, 2024, about 1400 Pacific daylight time, an experimental amateur built Vans RV-10, N929EH, was substantially damaged when it was involved in an accident near Beaver Creek, Oregon. The pilot was not injured. The airplane was operated as a Title… - [NTSB OPS25LA005](https://openairdocs.org/ntsb/OPS25LA005.md): Boeing 737-7H4 · Long Beach, CA · Incident · Class 3 · Limited · Preliminary report · Oct 19, 2024 · N250WN · 2 aircraft · No damage > On October 19, 2024, at 1450 pacific daylight time (PDT), a Diamond DA40, N895AM, and a Boeing 737-7H4, N250WN, operated as SWA1671, were involved in a runway incursion in Long Beach, CA. There were no injuries reported and none of the aircraft were damaged.… - [NTSB CEN25FA014](https://openairdocs.org/ntsb/CEN25FA014.md): Rans S12 · Church Point, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 15, 2024 · N912RS · Destroyed > On October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code… - [NTSB WPR25FA007](https://openairdocs.org/ntsb/WPR25FA007.md): Beech 95-B55 · Avalon, CA · Accident · 5 fatal · Class 3 · Field · Preliminary report · Oct 9, 2024 · N73WA · Substantial damage > On October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was… - [NTSB WPR25LA008](https://openairdocs.org/ntsb/WPR25LA008.md): Piper PA-36-285 · Marana, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 8, 2024 · N9928P · Substantial damage > On October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25FA005](https://openairdocs.org/ntsb/ERA25FA005.md): Bell 206L-3 · Owenton, KY · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 7, 2024 · N230AE · Destroyed > On October 7, 2024, at 1730 eastern daylight time, a Bell 206L3+, N230AE, was destroyed when it was involved in an accident in Owenton, Kentucky. The pilot, a flight nurse, and a flight medic were fatally injured. The helicopter was operated by Air Evac Life… - [NTSB CEN25FA005](https://openairdocs.org/ntsb/CEN25FA005.md): Champion 7EC · Fort Worth, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2024 · N4337C · Substantial damage > On October 7, 2024, about 1240 central daylight time, a Champion 7EC airplane, N4337C, sustained substantial damage when it was involved in an accident near Fort Worth, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25LA002](https://openairdocs.org/ntsb/ERA25LA002.md): Fokker D Viii Replica · Rhinebeck, NY · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Oct 5, 2024 · N94100 · Destroyed > On October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was… - [NTSB DCA25LA001](https://openairdocs.org/ntsb/DCA25LA001.md): Airbus A321-211 · Las Vegas, NV · Incident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 5, 2024 · N701FR > On October 5, 2024, at 1510 Pacific daylight time, Frontier Airlines flight 1326, an Airbus A321-211, N701FR, was involved in an incident due to a brake fire during landing on runway 26L at Harry Reid International Airport (LAS), Las Vegas, Nevada. The… - [NTSB ANC25FA001](https://openairdocs.org/ntsb/ANC25FA001.md): Cessna 180 · Big Lake, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 5, 2024 · N4631U · Substantial damage > On October 4, 2024, about 1730 Alaska daylight time, a float-equipped Cessna 180 airplane, N4631U, sustained substantial damage when it was involved in an accident near Big Lake, Alaska. The pilot was fatally injured, and one passenger sustained serious… - [NTSB WPR25FA002](https://openairdocs.org/ntsb/WPR25FA002.md): Taylor J-2 · Roseburg, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 3, 2024 · N19252 · Substantial damage > On October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA001](https://openairdocs.org/ntsb/WPR25LA001.md): Cirrus Design SR22 · Bakersfield, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 2, 2024 · N752B · Substantial damage > On October 2, 2024, about 1347 Pacific daylight time, a Cirrus SR22, N752B, was substantially damaged when it was involved in an accident near Bakersfield, California. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25FA001](https://openairdocs.org/ntsb/ERA25FA001.md): Beech 95 · Crystal River, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 1, 2024 · N5868S · Destroyed > On October 1, 2024, about 1540 eastern daylight time, a Beech 95-B55, N5868S, was destroyed when it collided with terrain near Crystal River, Florida. The private pilot was fatally injured. The personal flight was conducted under the provisions of Title 14… - [NTSB CEN24LA361](https://openairdocs.org/ntsb/CEN24LA361.md): Rans S14 · Teague, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Sep 20, 2024 · UNREG · Substantial damage > On September 20, 2024, about 1648 central daylight time, an unregistered Rans S-14 Airaile light sport airplane, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot was fatally injured. The airplane was operated as a… - [NTSB ANC24FA094](https://openairdocs.org/ntsb/ANC24FA094.md): Cessna 207 · Saint Mary's, AK · Accident · 4 fatal · Class 3 · Field · Preliminary report · Sep 16, 2024 · N90193 · Destroyed > On September 15, 2024, about 2204 Alaska daylight time, a Cessna 207 airplane, N90193, was destroyed when it was involved in an accident near St. Mary’s, Alaska. The pilot and three passengers were fatally injured. The flight was operated as a Title 14 Code… Next page: https://openairdocs.org/ntsb.md?status=ongoing&page=22 ## 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=21&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.