# 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 14 of 22 · 1,084 cases ## Cases, newest first - [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… - [NTSB WPR26FA043](https://openairdocs.org/ntsb/WPR26FA043.md): Cessna 172M · Poleta, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N13221 · Substantial damage > On November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously… - [NTSB WPR26FA040](https://openairdocs.org/ntsb/WPR26FA040.md): Beech B100 · Coral Springs, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N30HG · Destroyed > On November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA047](https://openairdocs.org/ntsb/WPR26LA047.md): Cessna 172S · Lancaster, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 9, 2025 · N5199J · Substantial damage > On November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26FA035](https://openairdocs.org/ntsb/ERA26FA035.md): Airbus Helicopters EC 130 T2 · Lebanon, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N107VU · Substantial damage > On November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was… - [NTSB ERA26FA034](https://openairdocs.org/ntsb/ERA26FA034.md): Extra Flugzeugproduktions EA 300/SC · Keystone Heights, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N330SL · Destroyed > On November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC26LA006](https://openairdocs.org/ntsb/ANC26LA006.md): Piper PA-14 · Talkeetna, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 8, 2025 · N5188H · Substantial damage > On November 8, 2025 about 1300 Alaska standard time, a Piper PA-14 airplane, N5188H, was substantially damaged when it was involved in an accident near Talkeetna, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA041](https://openairdocs.org/ntsb/WPR26LA041.md): Bessler Duane Lynn Savannah · Pacific, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 7, 2025 · N358D · Substantial damage > On November 7, 2025 at 1331 Pacific standard time, an experimental amateur-built ICP Savannah amphibious airplane, N358D, was substantially damaged when it was involved in an accident near Pacific, Washington. The pilot and the passenger were not injured. The… - [NTSB ERA26LA031](https://openairdocs.org/ntsb/ERA26LA031.md): Proctor E Ray Exec 162F · Athens, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 4, 2025 · N162RW · Destroyed > On November 04, 2025, at about 1400 eastern standard time, an amateur built experimental Rotorway 162F, N162RW, was destroyed when it was involved in an accident near Athens, Tennessee. The commercial pilot received minor injuries. The airplane was operated… - [NTSB DCA26MA024](https://openairdocs.org/ntsb/DCA26MA024.md): Mcdonnell Douglas MD-11F · Louisville, KY · Accident · 14 fatal · Class 1 · Major · Preliminary report · Nov 4, 2025 · N259UP · Destroyed > On November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad… - [NTSB CEN26FA034](https://openairdocs.org/ntsb/CEN26FA034.md): Funk B85C · Anderson, IN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 4, 2025 · N24157 · Substantial damage > On November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB WPR26LA036](https://openairdocs.org/ntsb/WPR26LA036.md): Cirrus Design SR22 · Sedona, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 3, 2025 · N237RJ · Substantial damage > On November 3, 2025, about 0830 mountain standard time, a Cirrus SR-22, N237RJ, sustained substantial damage when it was involved in an accident near Sedona, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA032](https://openairdocs.org/ntsb/CEN26LA032.md): Just Highlander · Delta, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Nov 2, 2025 · N622SC · Substantial damage > On November 2, 2025, about 1630 mountain standard time, an experimental amateur-built Just Highlander airplane, N622SC, was substantially damaged when it was involved in an accident near Delta, Colorado. The flight instructor and student pilot were seriously… - [NTSB WPR26LA035](https://openairdocs.org/ntsb/WPR26LA035.md): Maule M-7-235A · Friday Harbor, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 31, 2025 · N9234N · Substantial damage > On October 31, 2025, at about 1227 Pacific daylight time, a Maule M-7-235A, N9234N, was substantially damaged when it was involved in an accident at Friday Harbor Airport (FHR), Friday Harbor, Washington. The pilot was not injured. The airplane was operated… - [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 WPR26LA037](https://openairdocs.org/ntsb/WPR26LA037.md): Grumman American Avn. AA-5B · Santa Ynez, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 30, 2025 · N74323 · Substantial damage > On October 29, 2025, about 1820 Pacific daylight time, a Grumman American AA-5B, N74323, was substantially damaged when it was involved in an accident near Santa Ynez, California. The commercial pilot was not injured. The airplane was operated as a Title 14… - [NTSB ENG26LA004](https://openairdocs.org/ntsb/ENG26LA004.md): Airbus A320-232 · Gulf of America (Gulf of Mexico) · Incident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 30, 2025 · N605JB · Minor damage > On October 30, 2025 at 1748 UTC, JetBlue Airways Flight 1230 (N605JB) experienced a pitch excursion while cruising at 35,000 feet in smooth air and clear weather over the Gulf of America. The pitch excursion resulted in an approximate altitude loss of 100… - [NTSB WPR26LA034](https://openairdocs.org/ntsb/WPR26LA034.md): Piper PA-28R-200 · La Verne, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 29, 2025 · N5107S · Substantial damage > On October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title… - [NTSB OPS26LA001](https://openairdocs.org/ntsb/OPS26LA001.md): Eurocopter Deutschland MBB-BK 117 C-2 · Cleveland, OH · Incident · Class 4 · Limited · Investigation open · Oct 29, 2025 · N262MH · 2 aircraft · No damage - [NTSB ANC26LA020](https://openairdocs.org/ntsb/ANC26LA020.md): Cessna 182Q · Mapleton, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 29, 2025 · N735ZD · Substantial damage > On October 29, 2025, at about 1200 Central daylight time, a Cessna 182Q, N735ZD, was substantially damaged when it was involved in an accident near Mapleton, Iowa. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code… - [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 CEN26LA030](https://openairdocs.org/ntsb/CEN26LA030.md): Piper PA-46-310P · El Paso, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 26, 2025 · N46CR · Substantial damage > On October 26, 2025, about 918 mountain daylight time, a Piper PA46-310P, N46CR, was substantially damaged when it was involved in an accident near El Paso, Texas. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA032](https://openairdocs.org/ntsb/WPR26FA032.md): Cirrus Design SR22T · Lincoln, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 25, 2025 · N740TS · Destroyed > On October 24, 2025 at 2115 mountain daylight time, a Cirrus SR22T, N740TS, was destroyed when it was involved in an accident near Lincoln, Montana. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)… - [NTSB ERA26LA024](https://openairdocs.org/ntsb/ERA26LA024.md): Piper PA-28-140 · Somerville, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 24, 2025 · N3905F · Substantial damage > On October 24, 2025, about 1815 central daylight time, a Piper PA-28-140, N3905F, was substantially damaged when it was involved in an accident at Fayette County Airport (FYE), Somerville, Tennessee. The pilot sustained minor injuries. The airplane was… - [NTSB WPR26FA031](https://openairdocs.org/ntsb/WPR26FA031.md): Robinson Helicopter R66 · Ekalaka, MT · Accident · 4 fatal · Class 3 · Field · Preliminary report · Oct 23, 2025 · N67GA · Substantial damage > On October 22, 2025, about 1830 mountain daylight time, a Robinson Helicopter Co. R66, N67GA, was substantially damaged when it was involved in an accident near Ekalaka, Montana. The pilot and 3 passengers were fatally injured. The helicopter was operated as… - [NTSB CEN26LA029](https://openairdocs.org/ntsb/CEN26LA029.md): Beech 35-33 · Flippin, AR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 23, 2025 · N864R · Substantial damage > On October 23, 2025, about 1713 central daylight time, a Beech 35-33 airplane, N864R, was substantially damaged when it was involved in an accident near Flippin, Arkansas. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26FA019](https://openairdocs.org/ntsb/ERA26FA019.md): Cirrus SR22 · Ruston, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 21, 2025 · N42BE · Destroyed > On October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN26FA026](https://openairdocs.org/ntsb/CEN26FA026.md): Raytheon G58 · Carencro, LA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 21, 2025 · N16PV · Destroyed > On October 21, 2025, at 1101 central daylight time, a Raytheon Aircraft Company G58 airplane, N16PV, was destroyed when it was involved in an accident near Carencro, Louisiana. The commercial pilot and two passengers sustained fatal injuries. The airplane was… - [NTSB WPR26LA030](https://openairdocs.org/ntsb/WPR26LA030.md): Rutan Long-EZ · Long Beach, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 20, 2025 · N8183K · Substantial damage > On October 20, 2025, about 1603 Pacific daylight time, an experimental amateur-built Rutan Long-EZ, N8183K, was substantially damaged when it was involved in an accident in Long Beach, California. The pilot was seriously injured, and a pedestrian on the… - [NTSB CEN26FA023](https://openairdocs.org/ntsb/CEN26FA023.md): JMB VL-3LSA-912 · Erie, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 19, 2025 · N594TT · Substantial damage > On October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The… - [NTSB WPR26LA022](https://openairdocs.org/ntsb/WPR26LA022.md): Flight Design Ctsw · Casa Grande, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N531CT · Substantial damage > On October 17, 2025, about 13:20 mountain standard time, a Flight Design GMBH CTSW, N531CT, was substantially damaged when it was involved in an accident near Casa Grande, Arizona. The pilot received minor injuries. The airplane was operated as a Title 14… - [NTSB WPR26LA020](https://openairdocs.org/ntsb/WPR26LA020.md): Piper PA-23-250 · Condon, MT · Accident · 3 fatal · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N2345R · Substantial damage > On October 17, 2025, about 1615 mountain daylight time, a Piper PA-23-250, N2345R, was substantially damaged when it was involved in an accident near Condon, Montana. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14… - [NTSB CEN26LA024](https://openairdocs.org/ntsb/CEN26LA024.md): Vans RV8 · McKinney, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N3545W · Substantial damage > On October 17, 2025, at 0921 central daylight time, an amateur-built RV-8 airplane, N3545W, was substantially damaged when it was involved in an accident near McKinney, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26FA022](https://openairdocs.org/ntsb/CEN26FA022.md): Kitfox II · Spruce Pine, NC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 17, 2025 · N8610X · Destroyed > On October 17, 2025, about 1154 eastern daylight time, a Kitfox II airplane, N8610X was destroyed when it was involved in an accident near Spruce Pine, North Carolina. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA26LA012](https://openairdocs.org/ntsb/DCA26LA012.md): Boeing 737 · Moab, UT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 16, 2025 · N17327 · Substantial damage > On October 16, 2025, at 0643 mountain daylight time (MDT), United Airlines (UAL) flight 1093, a Boeing 737-8, N17327, was involved in a midair collision with an object while in cruise flight near Moab, Utah. Although the captain sustained minor injuries, none… - [NTSB ANC26FA002](https://openairdocs.org/ntsb/ANC26FA002.md): Raytheon Hawker 800XP · Bath, MI · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 16, 2025 · XA-JMR · Destroyed > On October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.… - [NTSB WPR26FA019](https://openairdocs.org/ntsb/WPR26FA019.md): Beech V35 · Austin, NV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 15, 2025 · CFETM · Substantial damage > On October 15, 2025, about 1447 Pacific daylight time, a Beech V35, C-FETM, was substantially damaged when it was involved in an accident near Austin, Nevada. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB WPR26LA026](https://openairdocs.org/ntsb/WPR26LA026.md): Extra Flugzeugbau EA 300/L · Arlington, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 14, 2025 · N300EX · Substantial damage > On October 14, 2025, at about 1030 Pacific daylight time, an EXTRA FLUGZEUGBAU GMBH 300L, N300EX, was substantially damaged when it was involved in an accident near Arlington, Washington. The flight instructor and private pilot receiving instruction were… - [NTSB ERA26FA011](https://openairdocs.org/ntsb/ERA26FA011.md): Socata TBM 700 · Dartmouth, MA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 13, 2025 · N111RF · Substantial damage > On October 13, 2025, at about 0815 eastern daylight time, a Socata TBM 700C2, N111RF, was substantially damaged when it was involved in an accident near Dartmouth, Massachusetts. The private pilot and the passenger were fatally injured and an automobile… - [NTSB CEN26LA016](https://openairdocs.org/ntsb/CEN26LA016.md): Rotorway AG162 · Valley View, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 13, 2025 · N162AD · Substantial damage > On October 13, 2025, at 1229 central daylight time, a Rotorway AG162 helicopter, N162AD, sustained substantial damage when it was involved in an accident near Valley View, Texas. The pilot and passenger were uninjured. The helicopter was operated under Title… - [NTSB ERA26FA010](https://openairdocs.org/ntsb/ERA26FA010.md): Beech C90 · Fort Worth, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 12, 2025 · N291CC · Destroyed > On October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14… - [NTSB ERA26LA012](https://openairdocs.org/ntsb/ERA26LA012.md): Cessna 172 · Sandersville, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 11, 2025 · N4390L · Substantial damage > On October 10, 2025, about 2015 eastern daylight time, a Cessna 172G, N4390L, was substantially damaged when it was involved in an accident near Sandersville, Geogia. The pilot was not injured and the passenger sustained minor injuries. The airplane was… - [NTSB CEN26FA015](https://openairdocs.org/ntsb/CEN26FA015.md): Bell 222 · Huntington Beach, CA · Accident · Serious injuries · Class 3 · Field · Preliminary report · Oct 11, 2025 · N222EX · Substantial damage > On October 11, 2025, at 1401 Pacific daylight time, a Bell 222 helicopter, N222EX, was substantially damaged when it was involved in an accident near Huntington Beach, California. The pilot and passenger received serious injuries. One person on the ground… - [NTSB WPR26LA012](https://openairdocs.org/ntsb/WPR26LA012.md): Piper PA24 · Vineyard, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 8, 2025 · N7946P · Substantial damage > On October 7, 2025, about 1825 mountain daylight time, a Piper PA24 airplane, N7946P, was substantially damaged in an accident near Vineyard, Utah. The pilot and pilot-rated passenger were not injured. The flight was conducted under Title 14 Code of Federal… - [NTSB WPR26FA008](https://openairdocs.org/ntsb/WPR26FA008.md): Airbus Helicopters EC 130 T2 · Sacramento, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N414RX · Substantial damage > On October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse… - [NTSB ERA26LA007](https://openairdocs.org/ntsb/ERA26LA007.md): Cessna 172 · Miami, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N433PT · Substantial damage > On October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14… - [NTSB CEN26FA012](https://openairdocs.org/ntsb/CEN26FA012.md): Beech A35 · Skidmore, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N577B · Destroyed > On October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)… - [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 ERA26LA004](https://openairdocs.org/ntsb/ERA26LA004.md): Pitts S1C · Mount Washington, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 6, 2025 · C-FAZJ · Substantial damage > On October 6, 2025, about 1415 eastern daylight time, a Pitts S-1C Special, C-FAZJ, was substantially damaged when it was involved in an accident in Mt. Washington, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26FA010](https://openairdocs.org/ntsb/CEN26FA010.md): Cessna 210B · Parkin, AR · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 6, 2025 · N9627X · Destroyed > On October 6, 2025, about 1514 central daylight time, a Cessna 210B airplane, N9627X, was destroyed when it was involved in an accident near Parkin, Arkansas. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of… Next page: https://openairdocs.org/ntsb.md?status=ongoing&page=15 ## 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=14&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.