# 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 2 of 2 · 97 cases

## Cases, newest first

- [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…
- [NTSB WPR26FA054](https://openairdocs.org/ntsb/WPR26FA054.md): Hughes 369D · Pryor, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 5, 2025 · N161LA · Substantial damage
  > On December 5, 2025, about 0858 central standard time, a Hughes 369D, N161LA, was substantially damaged when it was involved in an accident near Pryor, Oklahoma. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA050](https://openairdocs.org/ntsb/ERA26LA050.md): Cessna 401 · Eureka, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6255Q · Substantial damage
  > On November 18, 2025, at 12:30 eastern standard time, a Cessna 401A, N6255Q, was substantially damaged when it was involved in an accident near Eureka, North Carolina. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code…
- [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 ERA26FA039](https://openairdocs.org/ntsb/ERA26FA039.md): Jabiru USA Sport J230-SP · New Bavaria, OH · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 14, 2025 · N755J · Substantial damage
  > On November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…
- [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 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 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 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 WPR25FA294](https://openairdocs.org/ntsb/WPR25FA294.md): Cessna 172F · Battle Ground, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2025 · N8219U · Destroyed
  > On September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA290](https://openairdocs.org/ntsb/WPR25LA290.md): Eurocopter EC135 · Whittier, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 24, 2025 · N955AL · Substantial damage
  > On September 23, 2025, at 2303 Pacific daylight time, a Eurocopter EC-135 T2+, N955AL, was substantially damaged when it was involved in an accident near Whittier, Washington. The pilot and three medical crew members received minor injuries. The helicopter…
- [NTSB CEN25FA388](https://openairdocs.org/ntsb/CEN25FA388.md): North American T-6G · Louise, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2025 · N32SZ · Substantial damage
  > On September 20, 2025, about 1724 central daylight time, a North American T-6G airplane, N32SZ, was destroyed when it was involved in an accident near Lousie, Texas. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14…
- [NTSB ERA25FA344](https://openairdocs.org/ntsb/ERA25FA344.md): Hughes 369D · Jim Thorpe, PA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 11, 2025 · N5072F · Destroyed
  > On September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The…
- [NTSB ERA25LA338](https://openairdocs.org/ntsb/ERA25LA338.md): Bell 206 · Monroe, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 10, 2025 · N992MR · Destroyed
  > On September 10, 2025, about 1100 eastern daylight time, a Bell 206, N992MR, was destroyed when it was involved in an accident near Monroe, Geogia. The flight instructor and student pilot were seriously injured. The helicopter was operated as a Title 14 Code…
- [NTSB WPR25LA272](https://openairdocs.org/ntsb/WPR25LA272.md): American Champion 8KCAB · Jamesburg, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 31, 2025 · N15WJ · Substantial damage
  > On August 31, 2025, about 1100 Pacific daylight time, an American Champion 8KCAB Super Decathlon 177, N3357T, sustained substantial damage when it was involved in an accident near Jamesburg, California. The pilot and pilot rated passenger sustained minor…
- [NTSB CEN25FA339](https://openairdocs.org/ntsb/CEN25FA339.md): Rans S-12 Airaile · Concordia, KS · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 25, 2025 · N2757A · Substantial damage
  > On August 24, 2025, about 1926 central daylight time, a Rans S-12 Airaile airplane, N2757A, was substantially damaged when it was involved in an accident near Concordia, Kansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25LA323](https://openairdocs.org/ntsb/CEN25LA323.md): Grumman American Avn. G-164B · Fowler, IN · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7015N · Substantial damage
  > On August 15, 2025, about 1910 eastern daylight time, a Grumman American Avn. Corp. G-164-B airplane, N7015N, was substantially damaged when it was involved in an accident near Fowler, Indiana. The pilot was not injured. The airplane was operated under Title…
- [NTSB WPR25FA253](https://openairdocs.org/ntsb/WPR25FA253.md): Pitts S-1T · Goodyear, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 12, 2025 · N51HC · Substantial damage
  > On August 12, 2025, about 1019 mountain standard time, a Pitts S-1T, N51HC, was substantially damaged when it was involved in an accident near Goodyear, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA304](https://openairdocs.org/ntsb/CEN25LA304.md): Ayres S2R-G6 · Slayton, MN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 6, 2025 · N2239V · Substantial damage
  > On August 6, 2025, about 1300 central daylight time, a Ayres Corporation S2R-G6, airplane, registration N2239V, was substantially damaged when it was involved in an accident near Slayton, Minnesota. The pilot was seriously injured. The airplane was operated…
- [NTSB ERA25LA288](https://openairdocs.org/ntsb/ERA25LA288.md): Cessna 172N · Pembroke Pines, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N1213F · Substantial damage
  > On August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB WPR25FA233](https://openairdocs.org/ntsb/WPR25FA233.md): Cessna 152 · Hornell, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N6125B · Destroyed
  > On August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN25LA297](https://openairdocs.org/ntsb/CEN25LA297.md): Ayres S2R · Akron, IA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 28, 2025 · N524SL · Substantial damage
  > On July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…
- [NTSB CEN25FA289](https://openairdocs.org/ntsb/CEN25FA289.md): Piper PA-22-150 · New Underwood, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 28, 2025 · N9642D · Substantial damage
  > On July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…
- [NTSB CEN25LA277](https://openairdocs.org/ntsb/CEN25LA277.md): Robinson Helicopter R66 · Maynard, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 22, 2025 · N88911 · Substantial damage
  > On July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…
- [NTSB CEN25FA273](https://openairdocs.org/ntsb/CEN25FA273.md): Cessna T188C · Oregon, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 22, 2025 · N2802J · Substantial damage
  > On July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN25FA247](https://openairdocs.org/ntsb/CEN25FA247.md): Zenith CH601 · Pawnee National Grassland, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N314LB · Destroyed
  > On July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…
- [NTSB CEN25FA224](https://openairdocs.org/ntsb/CEN25FA224.md): Vans RV-10 · Capron, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 28, 2025 · N847CS · Substantial damage
  > On June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25FA182](https://openairdocs.org/ntsb/WPR25FA182.md): Cessna 172 · Billings, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 19, 2025 · N79306 · Substantial damage
  > On June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA25FA228](https://openairdocs.org/ntsb/ERA25FA228.md): Beech 58 · Tabor City, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 14, 2025 · N82UC · Destroyed
  > On June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB ERA25LA229](https://openairdocs.org/ntsb/ERA25LA229.md): Robinson Helicopter R66 · Valparaiso, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N633AF · Substantial damage
  > On June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…
- [NTSB CEN25FA198](https://openairdocs.org/ntsb/CEN25FA198.md): Aeronca 7AC · Waterman, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 7, 2025 · N1846E · Substantial damage
  > On June 7, 2025, about 1459 central daylight time, an Aeronca 7AC airplane, N1846E, sustained substantial damage when it was involved in an accident near Waterman, Illinois. The pilot was fatally injured, and the passenger was seriously injured. The airplane…
- [NTSB CEN25LA206](https://openairdocs.org/ntsb/CEN25LA206.md): Xag P100 PRO · Pontiac, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 5, 2025 · N231CU · Substantial damage
  > On June 5, 2025, at 1155 central daylight time, a XAG P100 Pro, N231CU, was substantially damaged when it was involved in an accident near Pontiac, Illinois. The unmanned aerial system (UAS) was operated under Title 14 Code of Federal Regulations as a Part…
- [NTSB CEN25FA184](https://openairdocs.org/ntsb/CEN25FA184.md): Rockwell Commander 114A · Hankamer, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 24, 2025 · N5903N · Destroyed
  > On May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…
- [NTSB CEN25FA151](https://openairdocs.org/ntsb/CEN25FA151.md): Aeronca 7AC · Cape Fair, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 10, 2025 · N83952 · Substantial damage
  > On April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…
- [NTSB CEN25FA104](https://openairdocs.org/ntsb/CEN25FA104.md): Robinson Helicopter R44 · Uvalde, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 27, 2025 · N144SG · Substantial damage
  > On February 27, 2025, about 1319 central standard time, a Robinson Helicopter Company (RHC) R44 helicopter, N144SG, sustained substantial damage when it was involved in an accident near Uvalde, Texas. The commercial pilot and the passenger sustained fatal…
- [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 ERA25FA069](https://openairdocs.org/ntsb/ERA25FA069.md): Vans RV-12IS · Homosassa, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 7, 2024 · N702DP · Substantial damage
  > On December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight…
- [NTSB ERA25FA065](https://openairdocs.org/ntsb/ERA25FA065.md): Truitt James B Vans RV-8A · Fort Blackmore, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 4, 2024 · N627TT · Substantial damage
  > On December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was…
- [NTSB WPR25LA052](https://openairdocs.org/ntsb/WPR25LA052.md): Beech 35-33 · Willcox, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 1, 2024 · N109V
  > On December 1, 2024, about 1300 mountain standard time, a Beech 35-33, N109V, was substantially damaged when it was involved in an accident near Willcox, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB WPR25LA008](https://openairdocs.org/ntsb/WPR25LA008.md): Piper PA-36-285 · Marana, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 8, 2024 · N9928P · Substantial damage
  > On October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA25FA005](https://openairdocs.org/ntsb/ERA25FA005.md): Bell 206L-3 · Owenton, KY · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 7, 2024 · N230AE · Destroyed
  > On October 7, 2024, at 1730 eastern daylight time, a Bell 206L3+, N230AE, was destroyed when it was involved in an accident in Owenton, Kentucky. The pilot, a flight nurse, and a flight medic were fatally injured. The helicopter was operated by Air Evac Life…
- [NTSB ERA25LA002](https://openairdocs.org/ntsb/ERA25LA002.md): Fokker D Viii Replica · Rhinebeck, NY · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Oct 5, 2024 · N94100 · Destroyed
  > On October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was…
- [NTSB CEN24FA287](https://openairdocs.org/ntsb/CEN24FA287.md): Bell 206 · Nashua, IA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 29, 2024 · N94XA · Substantial damage
  > On July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB ERA24FA326](https://openairdocs.org/ntsb/ERA24FA326.md): Schweizer 269C · West Carthage, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 27, 2024 · N61486 · Substantial damage
  > On July 27, 2024, about 1242 eastern daylight time, a Schweizer 269C-1, N61486, was substantially damaged when it was involved in an accident near West Carthage, New York. The private pilot was fatally injured. The helicopter was operated as a Title 14 Code…
- [NTSB ERA24FA305](https://openairdocs.org/ntsb/ERA24FA305.md): Cessna 402 · Easton, MD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 16, 2024 · N7875E · Substantial damage
  > On July 16, 2024, about 0932 eastern daylight time, a Cessna 402B, N7875E, was substantially damaged when it was involved in an accident near Easton, Maryland. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA24FA274](https://openairdocs.org/ntsb/ERA24FA274.md): Air Tractor AT502 · Martin, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 25, 2024 · N325RA · Substantial damage
  > On June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…

## 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?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
