# Ongoing NTSB investigations: Maneuvering

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 · 97 cases

## Latest cases

- [NTSB ERA27FA010](https://openairdocs.org/ntsb/ERA27FA010.md): Bell 407 · Myakka City, FL · Accident · 1 fatal · Class 3 · Field · Investigation open · Oct 16, 2026 · N618TS
- [NTSB CEN27LA009](https://openairdocs.org/ntsb/CEN27LA009.md): Simpson Arthur Monnett Sonerai Iilt · Sextonville, WI · Accident · Serious injuries · Class 3 · Limited · Investigation open · Oct 12, 2026 · N473AS
- [NTSB WPR27LA018](https://openairdocs.org/ntsb/WPR27LA018.md): Christen Industries Pitts S-2B · Yuma, AZ · Accident · Serious injuries · Class 4 · Limited · Investigation open · Oct 5, 2026 · N12CK · Substantial damage
- [NTSB CEN26LA326](https://openairdocs.org/ntsb/CEN26LA326.md): Beech 35-A33 · East Troy, WI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 27, 2026 · N1288Z · Substantial damage
  > On September 27, 2026, about 1333 central daylight time, a Beech A33 airplane, N1288Z, was substantially damaged when it was involved in an accident near East Troy, Wisconsin. The pilot and three passengers sustained minor injuries. The airplane was operated…
- [NTSB WPR26LA360](https://openairdocs.org/ntsb/WPR26LA360.md): Cessna A185F · Livingston, MT · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 26, 2026 · N185BZ · Substantial damage
- [NTSB WPR26FA354](https://openairdocs.org/ntsb/WPR26FA354.md): Cessna 172B · Royal City, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N44P · Substantial damage
  > On September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA352](https://openairdocs.org/ntsb/WPR26LA352.md): Beech B95 · Newport, OR · Accident · 1 fatal · Class 4 · Limited · Investigation open · Sep 21, 2026 · N529RB
- [NTSB WPR26FA346](https://openairdocs.org/ntsb/WPR26FA346.md): Airbus AS332 · Yosemite Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2026 · N332N · Destroyed
  > On September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…
- [NTSB ERA26LA345](https://openairdocs.org/ntsb/ERA26LA345.md): Cirrus Design SR20 · Asheville, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 19, 2026 · N189WM · Substantial damage
  > On September 19, 2026, at 1045 eastern daylight time, a Cirrus SR-20, N189WM, sustained substantial damage when it was involved in an accident near Ashville, North Carolina. The flight instructor and the student pilot received minor injuries. The airplane was…
- [NTSB WPR26FA345](https://openairdocs.org/ntsb/WPR26FA345.md): Eurocopter AS 350 B2 · Chatsworth, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 16, 2026 · N358TV · Destroyed
  > On September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…
- [NTSB ERA26FA338](https://openairdocs.org/ntsb/ERA26FA338.md): Reed Julian Estill RV-4 · Albertville, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N469TW · Substantial damage
  > On September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…
- [NTSB ANC26LA098](https://openairdocs.org/ntsb/ANC26LA098.md): Pitts Model 12 · Lake Stevens, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N491X · Substantial damage
  > On September 6, 2026, about 1800 Pacific daylight time, an experimental Pitts Model 12 airplane, N491X, was substantially damaged when it was involved in an accident near Lake Stevens, Washington. The pilot sustained serious injuries. The airplane was…
- [NTSB CEN26LA308](https://openairdocs.org/ntsb/CEN26LA308.md): Six Chuter SR7 XL · Amery, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 3, 2026 · N5617X · Substantial damage
  > On September 2, 2026, about 2007 central daylight time, a Six Chuter SR7XL experimental light-sport powered parachute, N5617X, was involved in an accident near Amery, Wisconsin. The pilot was seriously injured. The powered parachute was operated as a Title 14…
- [NTSB WPR26FA320](https://openairdocs.org/ntsb/WPR26FA320.md): Mooney M20C · Mount Hood, OR · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 31, 2026 · N2783W · Substantial damage
  > On August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26LA312](https://openairdocs.org/ntsb/WPR26LA312.md): Schweizer G-164B · Olene, OR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 20, 2026 · N7501Q · Destroyed
  > On August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ANC26LA088](https://openairdocs.org/ntsb/ANC26LA088.md): Cessna 172L · Micanopy, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 18, 2026 · N3866Q · Substantial damage
  > On August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…
- [NTSB ERA26FA294](https://openairdocs.org/ntsb/ERA26FA294.md): Bachem Fritz M Avid Mark IV · Arp, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 9, 2026 · N77FB · Substantial damage
  > On August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…
- [NTSB ANC26FA079](https://openairdocs.org/ntsb/ANC26FA079.md): Helicopter Transport Services CH-54A · Cove Fort, UT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N793HT · Destroyed
  > On August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…
- [NTSB WPR26LA291](https://openairdocs.org/ntsb/WPR26LA291.md): Cessna 177B · Perris, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2026 · N34852 · Substantial damage
  > On August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a…
- [NTSB WPR26FA289](https://openairdocs.org/ntsb/WPR26FA289.md): Cirrus Design SR22T · Bend, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 5, 2026 · N625LK · Substantial damage
  > On August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…
- [NTSB CEN26LA269](https://openairdocs.org/ntsb/CEN26LA269.md): Aero Commander Callair A-9B · Livonia, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 27, 2026 · N7799V · Substantial damage
  > On July 27, 2026, about 0819 central daylight time, an Aero Commander Callair A-9B airplane, N7799V, was substantially damaged when it was involved in an accident near Livonia, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR26LA275](https://openairdocs.org/ntsb/WPR26LA275.md): Czech Aircraft Works Mermaid Skeeter 2 · Cougar, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 22, 2026 · N42SK · Substantial damage
  > On July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.…
- [NTSB CEN26LA259](https://openairdocs.org/ntsb/CEN26LA259.md): Robinson Helicopter R44 · Adair, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 18, 2026 · N484AT · Substantial damage
  > On July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB CEN26LA264](https://openairdocs.org/ntsb/CEN26LA264.md): Bell 206B · Saint Joseph, IL · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 17, 2026 · N297CA · Substantial damage
- [NTSB ERA26LA274](https://openairdocs.org/ntsb/ERA26LA274.md): Robinson R22 · Monroe, NC · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 14, 2026 · N30CH · Substantial damage
- [NTSB CEN26FA247](https://openairdocs.org/ntsb/CEN26FA247.md): Kaman Aerospace K-1200 · Silver Jack Reservoir, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2026 · N40HX · Substantial damage
  > On July 12, 2026, about 1705 mountain daylight time, a Kaman Aerospace Corporation K-1200 (K-MAX) helicopter, N40HX, was substantially damaged when it was involved in an accident at Silver Jack Reservoir, Colorado. The pilot was fatally injured. The…
- [NTSB WPR26FA233](https://openairdocs.org/ntsb/WPR26FA233.md): Cessna 195 · Pasco, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N3877V · Substantial damage
  > On June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…
- [NTSB CEN26LA234](https://openairdocs.org/ntsb/CEN26LA234.md): Bell 47G-2 · Troy, MO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 22, 2026 · N65520 · Substantial damage
  > On June 22, 2026, about 1840 central daylight time, a Bell 47G-2 helicopter, N65520, was substantially damaged when it was involved in an accident near Troy, Missouri. The pilot sustained serious injuries. The helicopter was operated as a Title 14 Code of…
- [NTSB ANC26LA055](https://openairdocs.org/ntsb/ANC26LA055.md): Piper PA-18 105 · Petersville, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 18, 2026 · N249T · Substantial damage
- [NTSB ANC26LA051](https://openairdocs.org/ntsb/ANC26LA051.md): Robinson R44 · Pembroke Pines, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 13, 2026 · N336SG · Substantial damage
  > On June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…
- [NTSB WPR26FA216](https://openairdocs.org/ntsb/WPR26FA216.md): Piper PA-36-300 · Henderson, NE · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 12, 2026 · N57846 · Substantial damage
  > On June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA232](https://openairdocs.org/ntsb/ERA26LA232.md): North American SNJ-5C · Midland, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 6, 2026 · N98RJ · Substantial damage
  > On June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [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 CEN26FA207](https://openairdocs.org/ntsb/CEN26FA207.md): Robinson Helicopter R66 · Dawsonville, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 30, 2026 · N4488H · Substantial damage
  > On May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…
- [NTSB WPR26FA198](https://openairdocs.org/ntsb/WPR26FA198.md): Mooney M20J · Woodlake, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 23, 2026 · N4452H · Destroyed
  > On May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…
- [NTSB ERA26FA205](https://openairdocs.org/ntsb/ERA26FA205.md): Cessna A185F · Avon, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 12, 2026 · N61368 · Substantial damage
  > On May 12, 2026, about 1058 eastern daylight time, a Cessna A185F airplane, N61368, was substantially damaged when it was involved in an accident near Avon, Maine. The pilot was fatally injured. The airplane was owned by the state of Maine and operated as a…
- [NTSB CEN26FA184](https://openairdocs.org/ntsb/CEN26FA184.md): North American F-51D · Mound, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 12, 2026 · N251CS · Substantial damage
  > On May 12, 2026, at 1519 central daylight time, a North American F-51D airplane, N251CS, was destroyed when it was involved in an accident at the Vicksburg Tallulah Regional Airport (TVR), Mound, Louisiana. The pilot was fatally injured. The airplane was…
- [NTSB ANC26LA037](https://openairdocs.org/ntsb/ANC26LA037.md): Tundrair King · Palmer, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 6, 2026 · N62TK · Destroyed
  > On May 5, 2026, about 1950 Alaska daylight time (AKDT), an experimental Tundrair King airplane, N62TK, was destroyed when it was involved in an accident near Palmer, Alaska. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA195](https://openairdocs.org/ntsb/ERA26LA195.md): Air Tractor AT-602 · Bealeton, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N602RH · Substantial damage
  > On May 1, 2026, at 1230 eastern daylight time, an Air Tractor AT-602, N602RH, was substantially damaged when it was involved in an accident near Bealeton, Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN26LA175](https://openairdocs.org/ntsb/CEN26LA175.md): Hiller UH-12E · Chickasha, OK · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 30, 2026 · N22SP · Substantial damage
  > On April 30, 2026, about 1730 central daylight time, a Hiller UH-12E, N22SP, was substantially damaged when it was involved in an accident near Chickasha, Oklahoma. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA166](https://openairdocs.org/ntsb/ERA26FA166.md): North American AT-6D · Bronson, FL · Accident · 2 fatal · Class 3 · Field · Investigation open · Apr 13, 2026 · N29678 · Destroyed
- [NTSB ERA26FA165](https://openairdocs.org/ntsb/ERA26FA165.md): Beech 58 · New Market, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 13, 2026 · N2063G · Destroyed
  > On April 13, 2026, about 1308 eastern daylight time, a Beechcraft 58 multi-engine airplane, N2063G, was destroyed when it was involved in an accident near New Market, Tennessee. The flight instructor and the commercial pilot were fatally injured. The airplane…
- [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 CEN26LA148](https://openairdocs.org/ntsb/CEN26LA148.md): Robinson Helicopter R44 II · Stonewall, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 24, 2026 · N233JD · Substantial damage
  > On March 24, 2026, about 0930 central daylight time, a Robinson R44 II helicopter, N233JD, was substantially damaged when it was involved in an accident near Stonewall, Texas. The pilot and passenger were seriously injured. The helicopter was operated as a…
- [NTSB WPR26FA121](https://openairdocs.org/ntsb/WPR26FA121.md): MD Helicopters 369FF · Mojave, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 9, 2026 · N530XX · Substantial damage
  > On March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA098](https://openairdocs.org/ntsb/WPR26FA098.md): Bell 407 · Flagstaff, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 5, 2026 · N56AZ · Destroyed
  > On February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…
- [NTSB ERA26LA097](https://openairdocs.org/ntsb/ERA26LA097.md): Hughes 369 · North Augusta, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 22, 2026 · N105AC · Substantial damage
  > On January 22, 2026, at 1600 eastern standard time, a Hughes 369D, N105AC, was substantially damaged when it was involved in an accident near North Augusta, South Carolina. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA074](https://openairdocs.org/ntsb/WPR26FA074.md): MD Helicopters 369FF · Superior, AZ · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jan 2, 2026 · N3502P · Substantial damage
  > On January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter…
- [NTSB ERA26FA077](https://openairdocs.org/ntsb/ERA26FA077.md): Enstrom 280 · Hammonton, NJ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 28, 2025 · N280MG · 2 aircraft · Destroyed
  > On December 28, 2025, at 1124 eastern standard time, an Enstrom F-28A helicopter, N520H, and an Enstrom 280C helicopter, N280MG, collided in midair near Hammonton, New Jersey. The private pilots onboard each of the helicopters were fatally injured. Both…
- [NTSB ERA26LA070](https://openairdocs.org/ntsb/ERA26LA070.md): Holtaway Robert F Velocity V-TWIN · Nashua, NH · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 17, 2025 · N22EU · Substantial damage
  > On December 17, 2025, at 1410 eastern standard time, an experimental amateur-built Velocity V-Twin airplane, N22EU, was substantially damaged when it was involved in an accident near Nashua, New Hampshire. The pilot received minor injuries. The airplane was…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?status=ongoing&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?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.