# Ongoing NTSB investigations: Loss of engine power (partial) 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 2 of 3 · 103 cases ## Cases, newest first - [NTSB ERA26LA144](https://openairdocs.org/ntsb/ERA26LA144.md): Piper PA-28-140 · Indian Trail, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N98360 · Substantial damage > On March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a… - [NTSB WPR26FA119](https://openairdocs.org/ntsb/WPR26FA119.md): Piper PA-28-140 · Phoenix, AZ · Accident · Serious injuries · Class 3 · Field · Preliminary report · Mar 4, 2026 · N7744T · Substantial damage > On March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the… - [NTSB ANC26LA016](https://openairdocs.org/ntsb/ANC26LA016.md): Cessna 177B · Rocky Junction, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 22, 2026 · N12984 · Substantial damage > On February 21, 2026, 1746 Mountain standard time, a Cessna 177B airplane, N12984, was substantially damaged when it was involved in an accident near Rocky Junction, Arizona. The pilot and passenger sustain minor injuries. The airplane was operated as a Title… - [NTSB ANC26LA013](https://openairdocs.org/ntsb/ANC26LA013.md): Piper PA-22-150 · Anchorage, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Feb 1, 2026 · N3263Z · Substantial damage > On January 31, 2026, about 1921 Alaska standard time, a Piper PA-22-150 airplane, N3263Z, was substantially damaged when it was involved in an accident near Anchorage, Alaska. The pilot was uninjured, and the passenger was transported to the hospital with… - [NTSB CEN26LA100](https://openairdocs.org/ntsb/CEN26LA100.md): Piper PA 46-350P · Sioux City, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 24, 2026 · N91MK · Substantial damage > On January 24, 2026, about 0712 central daylight time, a Piper PA-46-350P airplane, N91MK, was substantially damaged when it was involved in an accident near Sioux City, Iowa. The pilot and passenger were uninjured. The airplane was operated as a Title 14… - [NTSB CEN26LA097](https://openairdocs.org/ntsb/CEN26LA097.md): Quicksilver II · Spring, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 20, 2026 · N4NH · Substantial damage > On January 20,2026, 1658 central standard time, a Quicksilver II, N4NH, sustained substantial damage when it was involved in an accident at David Wayne Hooks Memorial Airport, DWH, in Spring, Texas. The pilot, sole occupant, sustained no injuries. The… - [NTSB CEN26LA087](https://openairdocs.org/ntsb/CEN26LA087.md): Stinson 108-3 · Gypsum, CO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 11, 2026 · N6725M · Substantial damage > On January 11, 2026, at 1408 mountain standard time, a Stinson 108-3 airplane, N6725M, sustained substantial damage when it was involved in an accident near Gypsum, Colorado. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA073](https://openairdocs.org/ntsb/WPR26LA073.md): Evektor - Aerotechnik A S Sportstar MAX · Needles, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 27, 2025 · N2312T · Substantial damage > On December 27, 2025, about 1109 Pacific standard time, an Evektor-Aerotechnik AS Sportstar Max LSA airplane, N2312T, was substantially damaged when it was involved in an accident near Needles, California. The pilot and pilot rated passenger were not injured.… - [NTSB WPR26FA068](https://openairdocs.org/ntsb/WPR26FA068.md): Beech K35 · Summer Lake, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 23, 2025 · N9540R · Substantial damage > On December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal… - [NTSB WPR26LA060](https://openairdocs.org/ntsb/WPR26LA060.md): Beechcraft G36 · Tracy, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 15, 2025 · N360FV · Substantial damage > On December 15, 2025, about 1526 Pacific standard time, a Beechcraft G36, N360FV, was substantially damaged when it was involved in an accident near Tracy, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA046](https://openairdocs.org/ntsb/ERA26LA046.md): Cessna 172 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6124D · Substantial damage > On November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA045](https://openairdocs.org/ntsb/WPR26LA045.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2025 · N4402N · Substantial damage > On November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a… - [NTSB 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 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 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 CEN26LA006](https://openairdocs.org/ntsb/CEN26LA006.md): Piper PA-28-140 · McGregor, MN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 5, 2025 · N4218T · Substantial damage > On October 5, 2025, about 1310 central daylight time, a Piper PA-28-140, N4218T was substantially damaged when it was involved in an accident near McGregor, Minnesota. The pilot and two passengers were seriously injured. The airplane was operated under the… - [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 ERA25LA368](https://openairdocs.org/ntsb/ERA25LA368.md): Elmore Travis C Searey · Rotonda West, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 28, 2025 · N2090S · Substantial damage > On September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated… - [NTSB CEN25LA386](https://openairdocs.org/ntsb/CEN25LA386.md): Mooney M20K · Pearland, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 16, 2025 · N305EP · Substantial damage > On September 16, 2025, about 1040 central daylight time, a Mooney Aircraft Corp. M20K, N305EP was substantially damaged when it was involved in an accident at the Pearland Regional Airport, Pearland, Texas. The pilot and certificated flight instructor were… - [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 CEN25LA360](https://openairdocs.org/ntsb/CEN25LA360.md): Cessna 172H · Goliad, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 28, 2025 · N8078L · Substantial damage > On August 27, 2025, about 1904 central daylight time, a Cessna 172H airplane, N8078L, was substantially damaged when it was involved in an accident near Goliad, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN25LA357](https://openairdocs.org/ntsb/CEN25LA357.md): Piper PA-24-250 · Gregory, MI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 28, 2025 · N7412P · Substantial damage > On August 28, 2025, at about 1550 eastern daylight time, a Piper PA-24-250 airplane, N7412P, was substantially damaged when it was involved in an accident near Gregory, Michigan. The pilot was seriously injured. The airplane was operated as a Title 14 Code of… - [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 ANC25LA094](https://openairdocs.org/ntsb/ANC25LA094.md): Piper PA-28-180 · Chicken, AK · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N7771N · Substantial damage > On August 24, 2025, about 0820 Alaska daylight time, a Piper PA-28-180 airplane, N7771N, was substantially damaged when it was involved in an accident near Chicken, Alaska. The pilot and one passenger sustained minor injuries; the second passenger was… - [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 ERA25LA302](https://openairdocs.org/ntsb/ERA25LA302.md): Cessna 172 · Titusville, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7205Q · Substantial damage > On August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane… - [NTSB CEN25LA313](https://openairdocs.org/ntsb/CEN25LA313.md): Air Tractor AT-502 · Lawrenceville, IL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 10, 2025 · N9193V · Substantial damage > On August 10, 2025, about 1321 central daylight time, an Air Tractor AT-502, was substantially damaged when it was involved in an accident near Lawrenceville, Illinois. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ANC25LA077](https://openairdocs.org/ntsb/ANC25LA077.md): Cessna 210-5 · Yakutat, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2025 · N8457Z · Substantial damage > On July 23, 2025, about 1700 Alaska daylight time, a Cessna 210-5 (205) airplane, N8457Z, was substantially damaged when it was involved in an accident on a remote beach about 50 miles southeast of Yakutat, Alaska. The pilot was uninjured. The airplane was… - [NTSB WPR25LA228](https://openairdocs.org/ntsb/WPR25LA228.md): Beech V35 · Astoria, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 23, 2025 · N3785Q · Substantial damage > On July 22, 2025, about 1706 Pacific daylight time, a Beechcraft Bonanza V35, N3785Q, sustained substantial damage when it was involved in an accident near Astoria, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code… - [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 ERA25LA269](https://openairdocs.org/ntsb/ERA25LA269.md): Beech K35 · Sylacauga, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N5353E · Substantial damage > On July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA210](https://openairdocs.org/ntsb/WPR25LA210.md): Hibbard Rick Rans S7 · Blackfoot, ID · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N69TY · Substantial damage > On July 12, 2025, about 2015 mountain daylight time, an experimental amateur-built Rans S7 airplane, N69TY, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was not injured. The airplane was operated as a Title 14… - [NTSB ANC25LA063](https://openairdocs.org/ntsb/ANC25LA063.md): Cessna 182G · Kona, HI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 3, 2025 · N3261S · Substantial damage > On July 3, 2025, about 0657 Hawaii-Aleutian standard time, a Cessna 182G airplane, N3261S, was substantially damaged when it was involved in an accident near Kona, Hawaii. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN25LA232](https://openairdocs.org/ntsb/CEN25LA232.md): Bell 206B · Edgerton, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N16726 · Substantial damage > On July 1, 2025, at 0845 central daylight time, a Bell 206B, N17626, was substantially damaged when it was involved in an accident near Edgerton, Missouri. The commercial pilot was uninjured. The helicopter was operated under Title 14 Code of Federal… - [NTSB DCA25LA233](https://openairdocs.org/ntsb/DCA25LA233.md): Boeing 747-47UF · Guayaquil, Ecuador · Incident · No injuries · Class 4 · Limited · Investigation open · Jun 12, 2025 · N476MC · Minor damage - [NTSB ERA25LA222](https://openairdocs.org/ntsb/ERA25LA222.md): Dehavilland DHC-6 Twin Otter · Tullahoma, TN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 8, 2025 · N166DH · Substantial damage > On June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight… - [NTSB WPR25LA167](https://openairdocs.org/ntsb/WPR25LA167.md): Cessna 182J · Kooskia, ID · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 31, 2025 · N3463F · Substantial damage > On May 31, 2025, about 0930 Pacific daylight time, a Cessna 182J, N3463F, was substantially damaged when it was involved in an accident near Kooskia, Idaho. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal… - [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 WPR25LA159](https://openairdocs.org/ntsb/WPR25LA159.md): North American T-28B · Olivehurst, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 17, 2025 · N28DE · Substantial damage > On May 17, 2025, at 1022 Pacific daylight time, a North American T-28B, N28DE, was substantially damaged when it was involved in an accident near Marysville, California. The pilot and passenger were seriously injured. The airplane was operated as a Title 14… - [NTSB CEN25LA182](https://openairdocs.org/ntsb/CEN25LA182.md): Beech F33A · Houston, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 16, 2025 · N6376S · Destroyed > On May 16, 2025, about 1459 central daylight time, a Beech F33A airplane, N6376S, was destroyed when it was involved in an accident near Houston, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB WPR25LA130](https://openairdocs.org/ntsb/WPR25LA130.md): Hy-Tek Hurricane HP · Elko, NV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 14, 2025 · N9088G · Substantial damage > On April 14, 2025, about 1003 Pacific daylight time, an experimental amateur-built Hy-Tek Hurricane HP, N9088G, was substantially damaged when it was involved in an accident near Elko, Nevada. The pilot sustained serious injuries. The airplane was operated as… - [NTSB WPR25LA133](https://openairdocs.org/ntsb/WPR25LA133.md): Cessna 182L · Erie, NV · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2025 · N182VE · No damage > On April 13, 2025, about 0850 Pacific daylight time, a Cessna 182L, N182VE, was substantially damaged when it was involved in an accident near Erie, Nevada. The pilot and two passengers were uninjured, and one passenger sustained minor injuries. The airplane… - [NTSB WPR25FA127](https://openairdocs.org/ntsb/WPR25FA127.md): Azalea Saberwing · Justin, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 12, 2025 · N121DF · Destroyed > On April 11, 2025, about 1906 central daylight time (CDT), an experimental amateur-built Azalea Aviation LLC Saberwing, N121DF, was destroyed when it was involved in an accident near Justin, Texas. The pilot was fatally injured. The airplane was operated as a… - [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… - [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 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 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… Next page: https://openairdocs.org/ntsb-events/342/sequence.md?status=ongoing&page=3 ## 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" = '342' 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/342/sequence?page=2&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.