# Ongoing NTSB investigations: Takeoff

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 4 · 158 cases

## Cases, newest first

- [NTSB OPS26LA063](https://openairdocs.org/ntsb/OPS26LA063.md): Sikorsky VH3D · Washington, DC · Incident · Class 3 · Limited · Preliminary report · Aug 4, 2026 · MILITARY - VM1 · 2 aircraft · No damage
  > On August 4, 2026, about 1434 eastern daylight time (EDT), Marine One (VM1) a Sikorsky VH-3D, and Envoy Air flight 3742 (ENY3742), an Embraer E-170, were involved in a loss of separation about 2 miles north of Ronald Reagan Washington National Airport (DCA),…
- [NTSB WPR26LA282](https://openairdocs.org/ntsb/WPR26LA282.md): Mark Lee Schillinger GT-VX2 · Petaluma, CA · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jul 30, 2026 · N556GT · Substantial damage
- [NTSB CEN26LA265](https://openairdocs.org/ntsb/CEN26LA265.md): Piper PA-28-180 · Bulverde, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N454MD · Substantial damage
  > On July 20, 2026, about 1340 central daylight time, a Piper PA-28-180, N454MD was substantially damaged when it was involved in an accident near Bulberde, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a…
- [NTSB WPR26LA264](https://openairdocs.org/ntsb/WPR26LA264.md): Tag Aviation PTY Titanium Explorer · Cashmere, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2026 · N498TE · Substantial damage
  > On July 16, 2026, about 0930 Pacific daylight time, a Tag Aviation Pty Ltd. Titanium Explorer gyroplane, N498TE, was substantially damaged when it was involved in an accident at Cashmere-Dryden Airport (8S2), Cashmere, Washington. The pilot sustained serious…
- [NTSB CEN26LA242](https://openairdocs.org/ntsb/CEN26LA242.md): Piper PA-25-235 · Forest Lake, MN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 4, 2026 · N386AB · Substantial damage
  > On July 4, 2026, about 0942 central daylight time, a Piper PA-25-235 airplane, N386AB, was substantially damaged when it was involved in an accident near Forest Lake, Minnesota. The pilot was not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ANC26LA067](https://openairdocs.org/ntsb/ANC26LA067.md): Dehavilland DHC-3 · Denali National Park, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 3, 2026 · N424KT · Substantial damage
- [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 ERA26FA253](https://openairdocs.org/ntsb/ERA26FA253.md): Bellanca 14-19-2 · Goldsby, OK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 29, 2026 · N9846B · Destroyed
  > On June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN26LA239](https://openairdocs.org/ntsb/CEN26LA239.md): Cessna T206H · Ava, MO · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 29, 2026 · N480AC · Substantial damage
- [NTSB CEN26LA231](https://openairdocs.org/ntsb/CEN26LA231.md): Bailey-Moyes Dragonfly · Whitewater, WI · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jun 23, 2026 · N3849A · No damage
  > On June 22, 2026, about 1915 central daylight time, a Bailey-Moyes Dragonfly, N3849A, was involved in an accident near Whitewater, Wisconsin. The pilot of the Dragonfly was not injured. The pilot of the hang glider in tow was fatally injured. The tow…
- [NTSB ANC26LA059](https://openairdocs.org/ntsb/ANC26LA059.md): Piper PA-12 · North Pole, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 21, 2026 · N2586M · Substantial damage
- [NTSB ERA26LA244](https://openairdocs.org/ntsb/ERA26LA244.md): Cessna 182S · Naples, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N7270H · Substantial damage
  > On June 20, 2026 at 1030 eastern daylight time, a Cessna 182S, N7270H, was substantially damaged when it was involved in an accident near Naples, Florida. The pilot and three passengers were uninjured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA241](https://openairdocs.org/ntsb/ERA26FA241.md): Cessna 177RG · Morrison, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N7637V · Substantial damage
  > On June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…
- [NTSB ANC26LA053](https://openairdocs.org/ntsb/ANC26LA053.md): Piper PA-28-235 · Key West, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 14, 2026 · N15564 · Substantial damage
  > On June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…
- [NTSB ERA26LA242](https://openairdocs.org/ntsb/ERA26LA242.md): Scoda Aeronautica Ltda Super Petrel XP · New York, NY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 13, 2026 · N817PP · Substantial damage
  > On June 13, 2026, about 0924 eastern daylight time, a Scoda Aeronautica LTDA, Super Petrel XP airplane, N817PP, was substantially damaged when it was involved in an accident near New York, New York. The private pilot and a passenger were not injured. The…
- [NTSB WPR26FA217](https://openairdocs.org/ntsb/WPR26FA217.md): Lancair 235 · Hillsboro, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 12, 2026 · N10CF · Substantial damage
  > On June 12, 2026, at about 1508 Pacific daylight time, a Lancair 235, N10CF, was destroyed when it was involved in an accident near Hillsboro, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB CEN26FA222](https://openairdocs.org/ntsb/CEN26FA222.md): Cirrus Design SR20 · Wheelers Mill, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 11, 2026 · N858SD · Destroyed
  > On June 11, 2026, about 1030 eastern daylight time, a Cirrus SR20 airplane, N858SD, was destroyed when it was involved in an accident near Wheelers Mill, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB WPR26LA215](https://openairdocs.org/ntsb/WPR26LA215.md): Cessna 172 · Cleburne, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 9, 2026 · N1330Y · Substantial damage
  > On June 9, 2026 at about 1520 central daylight time a Cessna 172C, N1330Y, was substantially damaged when it crashed near Cleburne, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ANC26LA048](https://openairdocs.org/ntsb/ANC26LA048.md): Helio H-295 · Fairbanks, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 8, 2026 · N2267Z · Substantial damage
- [NTSB ERA26FA230](https://openairdocs.org/ntsb/ERA26FA230.md): Cessna 150 · Kissimmee, FL · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jun 6, 2026 · N156KA · Substantial damage
  > On June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.…
- [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 ERA26LA226](https://openairdocs.org/ntsb/ERA26LA226.md): Piper PA44 · Opa-locka, FL · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 2, 2026 · N156WM · Substantial damage
- [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 CEN26LA217](https://openairdocs.org/ntsb/CEN26LA217.md): Autogyro Cavalon · Coffeyville, KS · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 2, 2026 · N113CX · Substantial damage
  > On June 2, 2026, at 0837 central daylight time, an AutoGyro Cavalon gyroplane, N113CX, was substantially damaged when it was involved in an accident near Coffeyville, Kansas. The pilot was not injured. The gyroplane was operated as a Title 14 Code of Federal…
- [NTSB ANC26LA050](https://openairdocs.org/ntsb/ANC26LA050.md): Cessna A185F · Steele Creek, AK · Accident · No injuries · Class 4 · Limited · Investigation open · May 31, 2026 · N2821Q · Substantial damage
- [NTSB CEN26LA204](https://openairdocs.org/ntsb/CEN26LA204.md): Mustang Aeronautics Mustang II · Richmond, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 28, 2026 · N160MT · Substantial damage
  > On May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a…
- [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 ANC26LA043](https://openairdocs.org/ntsb/ANC26LA043.md): Piper PA-18A 150 · Tyonek, AK · Accident · No injuries · Class 4 · Limited · Investigation open · May 19, 2026 · N9250D · Substantial damage
- [NTSB CEN26LA191](https://openairdocs.org/ntsb/CEN26LA191.md): Vertical Hummingbird · Lee's Summit, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 16, 2026 · N284ST · Substantial damage
  > On May 16, 2026, about 0950 central daylight time, a Vertical Aviation Technologies 300L Hummingbird helicopter, N284ST, was substantially damaged when it was involved in an accident near Lee’s Summit, Missouri. One passenger sustained minor injuries. The…
- [NTSB WPR26LA197](https://openairdocs.org/ntsb/WPR26LA197.md): Mooney M20J · Lake Havasu City, AZ · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 14, 2026 · N4665H · Substantial damage
  > On May 14, 2026, at 1523, a Mooney M20J, N4665H, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The pilot and two passengers sustained serious injuries. The airplane was operated under Title 14 Code of Federal…
- [NTSB CEN26LA187](https://openairdocs.org/ntsb/CEN26LA187.md): Cessna 172S · Denton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 13, 2026 · N2134M · Substantial damage
  > On May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB ANC26LA035](https://openairdocs.org/ntsb/ANC26LA035.md): Champion 7EC · Hollis, OK · Accident · No injuries · Class 4 · Limited · Investigation open · Apr 30, 2026 · N7436B · Substantial damage
- [NTSB ERA26LA186](https://openairdocs.org/ntsb/ERA26LA186.md): Cessna 172M · Crystal River, FL · Accident · No injuries · Class 4 · Limited · Investigation open · Apr 22, 2026 · N868SA · Substantial damage
- [NTSB ERA26LA183](https://openairdocs.org/ntsb/ERA26LA183.md): Cessna 421 · Richmond, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 18, 2026 · C-GTGR · Substantial damage
  > On April 18, 2026, about 1410 eastern daylight time, a Cessna 421C, C-GTGR, was substantially damaged when it was involved in an accident near Richmond, Virginia. The pilot and four passengers were uninjured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA172](https://openairdocs.org/ntsb/ERA26LA172.md): Dehavilland DHC-3 · Dry Tortugas, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 11, 2026 · N708KA · Substantial damage
  > On April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA169](https://openairdocs.org/ntsb/ERA26LA169.md): Eric Vargosko SW-51 · Iron Station, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N551EV · Minor damage
  > On April 10, 2026, about 1732 eastern daylight time, an experimental amateur built SW-51 airplane, N551EV, sustained minor damage when it was involved in an accident near Iron Station, North Carolina. The front seat pilot sustained minor injuries, and the…
- [NTSB WPR26LA149](https://openairdocs.org/ntsb/WPR26LA149.md): Cessna T-41B · Fort Mohave, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 7, 2026 · N39ND · Substantial damage
  > On April 7, 2026, about 1300 mountain standard time, a Cessna T-41B, N39ND, was substantially damaged when it was involved in an accident near Fort Mohave, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code…
- [NTSB ERA26LA159](https://openairdocs.org/ntsb/ERA26LA159.md): Cessna 172M · Lakeland, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 5, 2026 · N61972 · Substantial damage
  > On April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…
- [NTSB WPR26LA131](https://openairdocs.org/ntsb/WPR26LA131.md): Aerospatiale SA341G Gazelle · Winslow, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N71FR · Substantial damage
  > On March 21, 2026, about 1406 mountain daylight time, a Aerospatiale SA341G Gazelle, N71FR, sustained substantial damage when it was involved in an accident near Winslow, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as…
- [NTSB ERA26LA153](https://openairdocs.org/ntsb/ERA26LA153.md): Textron T206H · Fort Myers, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N2469H · Substantial damage
  > On March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title…
- [NTSB CEN26LA143](https://openairdocs.org/ntsb/CEN26LA143.md): Cessna 172P · Denton, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 20, 2026 · N65614 · Substantial damage
  > On March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious…
- [NTSB WPR26LA133](https://openairdocs.org/ntsb/WPR26LA133.md): Piper PA-12 · West Linn, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 19, 2026 · N7632H · Substantial damage
  > On March 18, 2026, about 1700 Pacific daylight time, a Piper PA-12, N7632H, was substantially damaged when it was involved in an accident near West Linn, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN26FA140](https://openairdocs.org/ntsb/CEN26FA140.md): Aero Commander 500-B · Chesterfield, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 17, 2026 · N444CA · Destroyed
  > On March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [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 CEN26LA137](https://openairdocs.org/ntsb/CEN26LA137.md): Piper PA-12 · Lockhart, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 7, 2026 · N2511M · Substantial damage
  > On March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [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 ERA26LA107](https://openairdocs.org/ntsb/ERA26LA107.md): Cessna 560 · Danville, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 6, 2026 · N476JC · Substantial damage
  > On February 6, 2026, about 0925 eastern daylight time, a Cessna 560XL, N476JL, was substantially damaged when it was involved in an accident near Danville, Kentucky. The two flight crew and two passengers were not injured. The airplane was operated as a Title…
- [NTSB WPR26LA094](https://openairdocs.org/ntsb/WPR26LA094.md): Enstrom F28C · Leeds, UT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 2, 2026 · N5692Y · Substantial damage
  > On February 2, 2026, at about 1301 mountain standard time, an Enstrom F-28C helicopter, registration N5692Y, was substantially damaged near Leeds, Utah. The pilot and passenger sustained minor injuries. At the time of the accident, the helicopter was being…
- [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 CEN26FA098](https://openairdocs.org/ntsb/CEN26FA098.md): Bombardier CL-600-2B16 · Bangor, ME · Accident · 6 fatal · Class 2 · Field · Preliminary report · Jan 26, 2026 · N10KJ · Substantial damage
  > On January 25, 2026, at 1944 eastern standard time (EST), a Bombardier CL-600-2B16 (Challenger 650) airplane, N10KJ, sustained substantial damage when it was involved in an accident near Bangor, Maine. The pilot, copilot, and 4 passengers were fatally…

Next page: https://openairdocs.org/ntsb-phases/300/cases.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
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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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