# Ongoing NTSB investigations: Loss of engine power (total) 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 5 · 216 cases ## Cases, newest first - [NTSB ANC26LA069](https://openairdocs.org/ntsb/ANC26LA069.md): Piper PA-18-150 · Mekoryuk, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2026 · N824JT · Substantial damage > On July 7, 2026 about 1430 Alaska daylight time, a Piper PA-18-150 airplane, N824JT, was substantially damaged when it was involved in an accident near Mekoryuk, Alaska. The pilot and one passenger were not injured. The airplane was operated as a Title 14… - [NTSB WPR26LA245](https://openairdocs.org/ntsb/WPR26LA245.md): Piper PA-28-140 · Salome, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 5, 2026 · N3995K · Substantial damage > On July 5, 2026, at about 0825 Pacific daylight time, a Piper PA-28-140, N3995K, was substantially damaged when it was involved in an accident near Salome, Arizona. The pilot and passenger were uninjured. The airplane was operating as a Title 14 Code of… - [NTSB ERA26LA257](https://openairdocs.org/ntsb/ERA26LA257.md): Cirrus Design SR22 · Lafayette, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 2, 2026 · N127DC · Substantial damage > On July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14… - [NTSB CEN26FA241](https://openairdocs.org/ntsb/CEN26FA241.md): Beech 95-A55 · Lancaster, SC · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jul 2, 2026 · N7501S · Substantial damage > On July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title… - [NTSB WPR26LA237](https://openairdocs.org/ntsb/WPR26LA237.md): Autogyro MT03 · San Jose, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 29, 2026 · N423AG · Substantial damage > On June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received… - [NTSB WPR26LA235](https://openairdocs.org/ntsb/WPR26LA235.md): Diamond Aircraft Ind DA20-C1 · Nephi, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 25, 2026 · N643DC · Substantial damage > On June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title… - [NTSB ANC26LA063](https://openairdocs.org/ntsb/ANC26LA063.md): Cirrus Design SR22 · Windom, WV · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 21, 2026 · N544CD · Substantial damage > On June 21, 2026, about 1132 eastern daylight time, a Cirrus SR22 airplane, N544CD, was substantially damaged when it was involved in an accident near Windom, West Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26FA228](https://openairdocs.org/ntsb/CEN26FA228.md): Textron 680A · Laredo, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N523QS · Substantial damage > On June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one… - [NTSB WPR26LA211](https://openairdocs.org/ntsb/WPR26LA211.md): Piper PA-44-180T · St. George, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 7, 2026 · N8390K · Substantial damage > On June 7, 2026, about 1012 mountain standard time, a Piper PA-44-180T, N8390K, was substantially damaged when it was involved in an accident near St. George, Utah. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA231](https://openairdocs.org/ntsb/ERA26LA231.md): Olson/Williams Sonex · Jaffrey, NH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 5, 2026 · N28YD · Substantial damage > On June 5, 2026, at 1100 eastern daylight time, an experimental amateur-built Sonex airplane, N28YD, was substantially damaged when it was involved in an accident near Jaffrey, New Hampshire. The private pilot was seriously injured. The flight was conducted… - [NTSB CEN26LA218](https://openairdocs.org/ntsb/CEN26LA218.md): Air Tractor AT-602 · Breaux Bridge, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 3, 2026 · N50050 · Substantial damage > On June 3, 2026, about 1320 central daylight time, an Air Tractor AT-602 airplane, N50050, was substantially damaged when it was involved in an accident near Breaux Bridge, Louisiana. The pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA225](https://openairdocs.org/ntsb/ERA26LA225.md): Piper J5C-65 · East Granby, CT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 2, 2026 · N331JM · Substantial damage > On June 2, 2026, at 1151 eastern daylight time, a Piper J3C-65, N331JM, was substantially damaged when it was involved in an accident near East Granby, Connecticut. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA209](https://openairdocs.org/ntsb/WPR26LA209.md): Cirrus Design SR22T · Casper, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2026 · N324WY · Substantial damage > On June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA204](https://openairdocs.org/ntsb/WPR26LA204.md): Air Tractor AT-602 · Robbins, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N5111A · Substantial damage > On May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA223](https://openairdocs.org/ntsb/ERA26LA223.md): Cessna T210 · Loíza, PR · Accident · No injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N210PL · Substantial damage > On May 30, 2026, about 0744 Atlantic standard time, a Cessna T210, N210PL, was substantially damaged when it was involved in an accident near Loiza, Puerto Rico. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA208](https://openairdocs.org/ntsb/CEN26LA208.md): American AA-1A · Amery, WI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N6416L · Substantial damage > On May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA224](https://openairdocs.org/ntsb/ERA26LA224.md): Boeing E75 · Dresden, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N181RF · Substantial damage > On May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA199](https://openairdocs.org/ntsb/CEN26LA199.md): Cessna A188B · Blair, NE · Accident · No injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N84497 · Substantial damage > On May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA216](https://openairdocs.org/ntsb/ERA26LA216.md): Cessna A188B · Doerun, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 23, 2026 · N8288G · Substantial damage > On May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB ERA26LA215](https://openairdocs.org/ntsb/ERA26LA215.md): Textron 172S · Jupiter Farms, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N294PL · Substantial damage > On May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated… - [NTSB CEN26LA202](https://openairdocs.org/ntsb/CEN26LA202.md): Piper PA-32R-300 · Comanche, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N4556Q · Substantial damage > On May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA183](https://openairdocs.org/ntsb/WPR26LA183.md): Stinson 108-3 · Quilcene, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 12, 2026 · N588C · Substantial damage > On May 12, 2026, at about 1049 Pacific daylight time, a Stinson 108-3 airplane, N588C, was substantially damaged when it was involved in an accident near Quilcene, Washington. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA26LA196](https://openairdocs.org/ntsb/DCA26LA196.md): Skydweller S L Solar Impulse SI2 · Gulf of America (Gulf of Mexico) · Accident · No injuries · Class 4 · Limited · Investigation open · May 4, 2026 · N247PF · Destroyed - [NTSB ERA26LA198](https://openairdocs.org/ntsb/ERA26LA198.md): North American Navion · New Salem, MA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N8618H · Substantial damage > On May 1, 2026, about 1910 eastern daylight time, a North American Navion, N8618H, was substantially damaged when it was involved in an accident near New Salem, Massachusetts. The pilot received minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA196](https://openairdocs.org/ntsb/ERA26LA196.md): Beech C23 · Bangor, ME · Accident · No injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N18516 · Substantial damage > On May 01, 2026, at 1604 eastern daylight time, a Beechcraft C23 airplane, N18516, was substantially damaged when it was involved in an accident near Bangor, Maine. The private pilot and flight instructor were uninjured. The airplane was operated as a Title… - [NTSB CEN26LA173](https://openairdocs.org/ntsb/CEN26LA173.md): Cirrus Design SR22T · Chanute, KS · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 23, 2026 · N39VF · Substantial damage > On April 23, 2026, at about 1445 central daylight time, a Cirrus SR22T was substantially damaged when it was involved in an accident near Chanute, Kansas. The pilot and pilot-rated passenger sustained minor injuries. The airplane was operated as a Title 14… - [NTSB ERA26LA180](https://openairdocs.org/ntsb/ERA26LA180.md): Piper PA-28-181 · Indiantown, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 19, 2026 · N643FT · Substantial damage > On April 18, 2026, about 2115 eastern daylight time, a Piper PA-28-181, N643FT, was substantially damaged when it was involved in an accident near Indiantown, Florida. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA163](https://openairdocs.org/ntsb/WPR26LA163.md): Piper PA30 · Auburn, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 18, 2026 · N741TJ · Substantial damage > On April 18, 2026, about 1330 Pacific daylight time, a Piper PA-30 Twin Comanche, N741TJ, was substantially damaged when it was involved in an accident near Auburn, Washington. The pilot and pilot-rated passenger sustained minor injuries. The airplane was… - [NTSB WPR26LA162](https://openairdocs.org/ntsb/WPR26LA162.md): Cirrus Design SR22 · La Cienega, NM · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 17, 2026 · N654MC · Substantial damage > On April 17, 2026, at about 0954 mountain standard time, a Cirrus Design Corp SR22, N654MC, sustained substantial damage when it was involved in an accident near La Cienega, New Mexico. The pilot receiving instruction and the flight instructor were not… - [NTSB CEN26LA164](https://openairdocs.org/ntsb/CEN26LA164.md): Piper PA-28-180 · Corpus Christi, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 14, 2026 · N317HM · Destroyed > On April 13, 2026, about 19:19 central daylight time, a Piper Cherokee PA-28-180 airplane, N317HM was destroyed when it was involved in an accident near Corpus Christi, Texas. The flight instructor and student pilot were seriously injured. The airplane was… - [NTSB WPR26LA158](https://openairdocs.org/ntsb/WPR26LA158.md): Alexander Schleicher ASH 31 MI · Williams, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2026 · N77UK · Substantial damage > On April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The… - [NTSB WPR26LA153](https://openairdocs.org/ntsb/WPR26LA153.md): Republic RC-3 · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 12, 2026 · N6518K · Substantial damage > On April 12, 2026, about 1423 mountain standard time, a Republic RC-3 airplane, N6518K, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot and two passengers were not injured. The amphibious airplane was operated as… - [NTSB WPR26LA155](https://openairdocs.org/ntsb/WPR26LA155.md): Aero Vodochody L-39 · Ennis, MT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N136EM · Substantial damage > On April 10, 2026, about 1210 mountain daylight time, an Aero Vodochody L 39, N136EM, was substantially damaged when it was involved in an accident near Ennis, Montana. The flight instructor sustained minor injuries, and the pilot undergoing instruction was… - [NTSB ERA26LA168](https://openairdocs.org/ntsb/ERA26LA168.md): Piper J3C-65 · Crestview, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N92480 · Substantial damage > On April 10, 2026, about 1700 eastern daylight time, a Piper J3C-65, N92480 was substantially damaged when it was involved in an accident near Baker, Florida. The pilot sustained minor injuries, and the passenger was seriously injured. The airplane was… - [NTSB WPR26LA152](https://openairdocs.org/ntsb/WPR26LA152.md): Just Highlander · Great Falls, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 8, 2026 · N563JA · Substantial damage > On April 8, 2026, about 1106 mountain daylight time, an experimental amateur built Just Aircraft Highlander, N563JA, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated… - [NTSB WPR26LA150](https://openairdocs.org/ntsb/WPR26LA150.md): Cessna 150G · Phoenix, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 8, 2026 · N4714X · Substantial damage > On April 8, 2026, about 1033 mountain standard time, a Cessna 150G, N4714X, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot were not injured. The airplane was being operated as a… - [NTSB ERA26LA156](https://openairdocs.org/ntsb/ERA26LA156.md): Piper PA-28-181 · Philadelphia, PA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 1, 2026 · N494LA · Substantial damage > On April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious… - [NTSB CEN26LA149](https://openairdocs.org/ntsb/CEN26LA149.md): Piper PA28 · Atlanta, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 26, 2026 · N1653J · Substantial damage > On March 26, 2026, about 0720 central daylight time, a Piper PA28-140 airplane, N1653J, was substantially damaged when it was involved in an accident near Atlanta, Texas. The pilot was not injured. The flight was operated under the provisions of Title 14 Code… - [NTSB ERA26LA145](https://openairdocs.org/ntsb/ERA26LA145.md): Rockwell International 114 · Whitmire, SC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 10, 2026 · N4832W · Substantial damage > On March 10, 2026, about 1915 eastern daylight time, a Rockwell International 114 airplane, N4832W, was substantially damaged when it was involved in an accident near Whitmire, South Carolina. The flight instructor received minor injuries. The pilot receiving… - [NTSB ANC26LA018](https://openairdocs.org/ntsb/ANC26LA018.md): Bell Textron Canada 505 · Fort Worth, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N911FW · Substantial damage > On March 7, 2026, at 2210 Central daylight time, a Bell Textron 505 helicopter, N911FW, was substantially damaged when it was involved in an accident near Fort Worth, Texas. The pilot and crew member were not injured. The helicopter was operated as a Title 14… - [NTSB WPR26FA120](https://openairdocs.org/ntsb/WPR26FA120.md): Columbia Aircraft Mfg LC41-550FG · Albuquerque, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 6, 2026 · N2516S · Substantial damage > On March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from… - [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 ERA26LA134](https://openairdocs.org/ntsb/ERA26LA134.md): Cessna 172N · Newburgh, NY · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 3, 2026 · N1560E · Substantial damage > On March 2, 2026, at 1910 eastern standard time, a Cessna 172N, N1560E, was substantially damaged when it was involved in an accident near Newberg, New York. The flight instructor and student pilot incurred minor injuries. The airplane was operated as a Title… - [NTSB CEN26FA126](https://openairdocs.org/ntsb/CEN26FA126.md): Peck JODEL-F12 · Rogers, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 26, 2026 · N30P · Destroyed > On February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code… - [NTSB CEN26LA123](https://openairdocs.org/ntsb/CEN26LA123.md): Grumman AA5 · Admire, KS · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 23, 2026 · N9939U · Substantial damage > On February 23, 2026, about 0958 central standard time, a Grumman AA-5A airplane, N9939U, was substantially damaged when it was involved in an accident near Admire, Kansas. The pilot and passenger were not injured. The airplane operated under the provisions… - [NTSB WPR26FA103](https://openairdocs.org/ntsb/WPR26FA103.md): Cessna 210B · Camarillo, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 16, 2026 · N9735X · Substantial damage > On February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane… - [NTSB ERA26LA116](https://openairdocs.org/ntsb/ERA26LA116.md): Cessna 182G · Quail Heights, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 16, 2026 · N515CL · Substantial damage > On February 16, 2026, at 1020 eastern standard time a Cessna 182G, N515CL, was substantially damaged when it was involved in an accident near Quail Heights, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA109](https://openairdocs.org/ntsb/ERA26LA109.md): Hawker Beechcraft G36 · Gainesville, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 9, 2026 · N229TT · Substantial damage > On February 09, 2026, about 1732 eastern standard time, a Beechcraft G36, N229TT, was substantially damaged when it was involved in an accident near Gainesville, Georgia. The pilot and flight instructor were uninjured, and two occupants of separate… - [NTSB ERA26FA110](https://openairdocs.org/ntsb/ERA26FA110.md): Pipistrel Taurus 503 · Boynton Beach, FL · Accident · Serious injuries · Class 3 · Field · Preliminary report · Feb 9, 2026 · N414HG · Substantial damage > On February 9, 2026, about 1514 eastern standard time, a Pipistrel Taurus 503 motorglider, N414HG, was substantially damaged when it was involved in an accident at Willis Gliderport (FA44), Boynton Beach, Florida. The pilot was seriously injured. The… - [NTSB ERA26FA106](https://openairdocs.org/ntsb/ERA26FA106.md): Cirrus Design SR22 · Lexington, SC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N705CD · Substantial damage > On February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally… Next page: https://openairdocs.org/ntsb-events/341/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" = '341' 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/341/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.