# Ongoing NTSB investigations, 2024 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 · 60 cases ## Latest cases - [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… - [NTSB ANC24FA091](https://openairdocs.org/ntsb/ANC24FA091.md): Champion 7GCBC · Ninilchik, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 13, 2024 · N8CK · Substantial damage > On September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as… - [NTSB DCA24FA300](https://openairdocs.org/ntsb/DCA24FA300.md): Boeing 737-9 · Nashville, TN · Incident · No injuries · Class 3 · Field · Preliminary report · Sep 12, 2024 · N919AK · 2 aircraft · Minor damage > On September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight… - [NTSB CEN24FA353](https://openairdocs.org/ntsb/CEN24FA353.md): Hawker Beechcraft G36 · Lafayette, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 12, 2024 · N643RS · Destroyed > On September 12, 2024, about 1137 central daylight time, a Hawker Beechcraft G36 airplane, N643RS, was destroyed when it was involved in an accident near Lafayette, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR24FA295](https://openairdocs.org/ntsb/WPR24FA295.md): Piper PA-24-250 · Hawthorne, CA · Accident · Serious injuries · Class 3 · Field · Preliminary report · Sep 6, 2024 · N588CP · Destroyed > On September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title… - [NTSB WPR24FA289](https://openairdocs.org/ntsb/WPR24FA289.md): Cessna 421C · Fairview, OR · Accident · 3 fatal · Class 3 · Field · Preliminary report · Aug 31, 2024 · N421GP · Substantial damage > On August 31, 2024, about 1030 Pacific daylight time, a Cessna 421C, N421GP was destroyed when it was involved in an accident near Fairview, Oregon. The two pilots and one person on the ground were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB WPR24FA288](https://openairdocs.org/ntsb/WPR24FA288.md): Textron T206H · Yellow Pine, ID · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 29, 2024 · N712AM · Destroyed > On August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR24LA323](https://openairdocs.org/ntsb/WPR24LA323.md): Beech J35 · Belgrade, MT · Accident · Class 3 · Limited · Preliminary report · Aug 28, 2024 · N8350D · Substantial damage > On August 27, 2024, about 1845 mountain daylight time, a Beech J35, N8350D, was substantially damaged when it was involved in an accident near Belgrade, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN24FA325](https://openairdocs.org/ntsb/CEN24FA325.md): Arrow Falcon Exporters OH-58A+ · Newton, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 23, 2024 · N199BD · Substantial damage > On August 23, 2024, about 1330 central daylight time, a restricted category Arrow Falcon Exporters OH-58A helicopter, N199BD was substantially damaged when it was involved in an accident near Newton, Texas. The pilot was fatally injured and one person on the… - [NTSB WPR24FA284](https://openairdocs.org/ntsb/WPR24FA284.md): Lockwood AIR CAM · Minden, NV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2024 · N2412Y · Substantial damage > On August 20, 2024, about 0819 Pacific daylight time, an experimental amateur-built Lockwood Air Cam, N2412Y, was substantially damaged when in was involved in an accident at the Minden-Tahoe Airport, Minden, Nevada. The pilot was fatally injured, and the… - [NTSB CEN24FA320](https://openairdocs.org/ntsb/CEN24FA320.md): Cessna 550 · Odessa, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 20, 2024 · N689VP · Destroyed > On August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane… - [NTSB CEN24FA304](https://openairdocs.org/ntsb/CEN24FA304.md): Beech F33 · Oklahoma City, OK · Accident · 4 fatal · Class 3 · Field · Preliminary report · Aug 6, 2024 · N8095U · Destroyed > On August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was… - [NTSB CEN24LA311](https://openairdocs.org/ntsb/CEN24LA311.md): Piper PA-34-200T · Wills Point, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 31, 2024 · N2106E · Substantial damage > On July 31, 2024, about 0836 central daylight time, a Piper PA-34-200T, N2106E, was substantially damaged when it was involved in an accident near Wills Point, Texas. The pilot and pilot-rated passenger were not injured. The airplane was operated as a Title… - [NTSB CEN24FA287](https://openairdocs.org/ntsb/CEN24FA287.md): Bell 206 · Nashua, IA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 29, 2024 · N94XA · Substantial damage > On July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part… Next page: https://openairdocs.org/ntsb.md?status=ongoing&year=2024&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 year(c."eventDate") = 2024 AND c."completionStatus" = 'Ongoing' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?status=ongoing&year=2024 --- 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.