# Ongoing NTSB investigations: Unknown 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. ## Latest cases - [NTSB ERA27FA004](https://openairdocs.org/ntsb/ERA27FA004.md): Hughes 269B · Lahmansville, WV · Accident · 1 fatal · Class 3 · Field · Investigation open · Oct 6, 2026 · N9390F - [NTSB ERA26FA350](https://openairdocs.org/ntsb/ERA26FA350.md): Aero Commander 112 · Chatsworth, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2026 · N1102J · Substantial damage > On September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA355](https://openairdocs.org/ntsb/WPR26FA355.md): Aeronca 7AC · Hesperia, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N12DF · Substantial damage > On September 24, 2026, about 0945 Pacific daylight time, an Aeronca 7AC, N12DF, was substantially damaged when it was involved in an accident near Hesperia, California. The flight instructor and passenger were fatally injured. The airplane was operated as a… - [NTSB WPR26LA359](https://openairdocs.org/ntsb/WPR26LA359.md): Hawker Hawker Hunter MK.58 · Morro Bay, CA · Accident · Minor injuries · Class 4 · Limited · Investigation open · Sep 22, 2026 · N345AX - [NTSB ERA26FA341](https://openairdocs.org/ntsb/ERA26FA341.md): Weatherly 620 · Lynchburg, SC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 17, 2026 · N20003 · Substantial damage > On September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as… - [NTSB CEN26FA311](https://openairdocs.org/ntsb/CEN26FA311.md): EXP Stol CH701 · Neosho, MO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 7, 2026 · N101XV · Substantial damage > On September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was… - [NTSB WPR26FA284](https://openairdocs.org/ntsb/WPR26FA284.md): Cessna 172 · Blackfoot, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 2, 2026 · N1166F · Substantial damage > On August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The… - [NTSB CEN26FA267](https://openairdocs.org/ntsb/CEN26FA267.md): Zenith Zodiak 601 HDS · Sioux City, IA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 24, 2026 · N27601 · Destroyed > On July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA266](https://openairdocs.org/ntsb/CEN26LA266.md): Piper J3C-65 · Richmond, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N92432 · Substantial damage > On July 20, 2026, at 0643 central daylight time, a Piper J3C-65 airplane, N92432, sustained substantial damage when it was involved in an accident near Richmond, Texas. The commercial pilot sustained serious injuries. The airplane was operated as a Title 14… - [NTSB WPR26FA262](https://openairdocs.org/ntsb/WPR26FA262.md): Vans RV-4 · Yuba City, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 16, 2026 · N98GB · Substantial damage > On July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14… - [NTSB WPR26FA257](https://openairdocs.org/ntsb/WPR26FA257.md): Luscombe 8A · Canton, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N1164K · Substantial damage > On July 14, 2026, sometime between 1252 and 1356 CDT, a Luscombe 8A, N1164K, was substantially damaged when it crashed in a field near Canton, Texas. The pilot, who was the sole occupant, was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA254](https://openairdocs.org/ntsb/CEN26LA254.md): Tag Aviation PTY Titanium Explorer · Larkspur, CO · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jul 13, 2026 · N665TE · Substantial damage > On July 13, 2026, about 800 mountain daylight time, a Tag Aviation Pty Ltd Titanium Explorer gyrocopter, N665TE was substantially damaged when it was involved in an accident near Larkspur, Colorado. The pilot passed away in the hospital five days after the… - [NTSB ANC26LA071](https://openairdocs.org/ntsb/ANC26LA071.md): Bellanca 7GCBC · Skwentna, AK · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 11, 2026 · N11647 · Substantial damage - [NTSB WPR26FA224](https://openairdocs.org/ntsb/WPR26FA224.md): Piper PA-24-250 · Middlefield, OH · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jun 20, 2026 · N6403P · Substantial damage > On June 20, 2026, about 1535 eastern daylight time, a Piper PA-24-250, N6403P, was substantially damaged when it was involved in an accident near Middlefield, Ohio. The pilot and two passengers sustained fatal injuries. The airplane was operated as a Title 14… - [NTSB ANC26FA054](https://openairdocs.org/ntsb/ANC26FA054.md): Air Tractor AT-502B · Forbes, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 16, 2026 · N503GK · Substantial damage > On June 15, 2026, about 2015 Central daylight time, an Air Tractor AT-502B airplane, N503GK, sustained substantial damage when it was involved in an accident near Forbes, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA202](https://openairdocs.org/ntsb/WPR26FA202.md): Pipistrel D O O Sinus 912 · Columbus, MS · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 31, 2026 · N1277P · Destroyed > On May 31, 2026, about 1236 central daylight time, a Pipistrel D O O Sinus 912, N1277P, was destroyed when it was involved in an accident near Columbus, Mississippi. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC26FA039](https://openairdocs.org/ntsb/ANC26FA039.md): Cessna 182T · Armistead, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 7, 2026 · N227TF · Substantial damage > On May 7, 2026, about 1055 pacific daylight time (PDT), a Cessna 182T airplane, N227TF, was destroyed when it was involved in an accident near Armistead, California. The flight instructor and the pilot receiving instruction were fatally injured. The airplane… - [NTSB ANC26FA024](https://openairdocs.org/ntsb/ANC26FA024.md): Airplane Factory Ltd The Sling · Avalon, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 9, 2026 · N166TW · Substantial damage > On April 09, 2026, about 1224 Pacific daylight time, an Airplane Factory (Pty) Ltd. Sling 2 airplane, N166TW, was substantially damaged when it was involved in an accident near Avalon, California. The pilot and pilot-rated passenger were fatally injured. The… - [NTSB CEN26FA147](https://openairdocs.org/ntsb/CEN26FA147.md): Experimental Homebuilt Airshark · Statesboro, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 25, 2026 · N220AS · Substantial damage > On March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a… - [NTSB ANC26FA021](https://openairdocs.org/ntsb/ANC26FA021.md): Robinson Helicopter R44 · Boynton Beach, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 23, 2026 · N478AT · Destroyed > On March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The… - [NTSB CEN26FA141](https://openairdocs.org/ntsb/CEN26FA141.md): Piper PA-28-140 · Rock Falls, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 20, 2026 · N9913W · Destroyed > On March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14… - [NTSB CEN26FA132](https://openairdocs.org/ntsb/CEN26FA132.md): Cessna T210M · Deerfield, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 5, 2026 · N19FB · Substantial damage > On March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of… - [NTSB WPR26FA109](https://openairdocs.org/ntsb/WPR26FA109.md): Piper PA-22-150 · Oroville, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 28, 2026 · N3170Z · Destroyed > On February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [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 CEN26FA064](https://openairdocs.org/ntsb/CEN26FA064.md): Piper PA-30 · West Chicago, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 17, 2025 · N8693Y · Substantial damage > On December 17, 2025, about 1349 central standard time, a Piper PA-30 airplane, N8693Y, was substantially damaged when it was involved in an accident near West Chicago, Illinois. The pilot and pilot-rated passenger were fatally injured. The airplane was… - [NTSB CEN26LA061](https://openairdocs.org/ntsb/CEN26LA061.md): Bell Textron Canada 505 · Divot, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 13, 2025 · N865S · Substantial damage > On December 13, 2025, about 1345 central standard time, a Bell Helicopter 505, N865S, was substantially damaged when it was involved in an accident near Divot, Texas. The pilot was seriously injured and the passenger sustained minor injuries. The helicopter… - [NTSB WPR26FA051](https://openairdocs.org/ntsb/WPR26FA051.md): American AA-1A · High Rolls, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 26, 2025 · N9439L · Destroyed > On November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a… - [NTSB CEN26FA034](https://openairdocs.org/ntsb/CEN26FA034.md): Funk B85C · Anderson, IN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 4, 2025 · N24157 · Substantial damage > On November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB WPR26FA031](https://openairdocs.org/ntsb/WPR26FA031.md): Robinson Helicopter R66 · Ekalaka, MT · Accident · 4 fatal · Class 3 · Field · Preliminary report · Oct 23, 2025 · N67GA · Substantial damage > On October 22, 2025, about 1830 mountain daylight time, a Robinson Helicopter Co. R66, N67GA, was substantially damaged when it was involved in an accident near Ekalaka, Montana. The pilot and 3 passengers were fatally injured. The helicopter was operated as… - [NTSB CEN26LA024](https://openairdocs.org/ntsb/CEN26LA024.md): Vans RV8 · McKinney, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N3545W · Substantial damage > On October 17, 2025, at 0921 central daylight time, an amateur-built RV-8 airplane, N3545W, was substantially damaged when it was involved in an accident near McKinney, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26FA012](https://openairdocs.org/ntsb/CEN26FA012.md): Beech A35 · Skidmore, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N577B · Destroyed > On October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)… - [NTSB CEN25FA367](https://openairdocs.org/ntsb/CEN25FA367.md): Robinson Helicopter R66 · Lakeville, MN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 6, 2025 · N6633L · Destroyed > On September 6, 2025, about 1442 central daylight time, a Robinson Helicopter Company R66 helicopter, N6633L was destroyed when it was involved in an accident near Lakeville, Minnesota. The pilot and passenger were fatally injured. The helicopter was operated… - [NTSB WPR25FA264](https://openairdocs.org/ntsb/WPR25FA264.md): Cessna 172S · Los Banos, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 27, 2025 · N5203H · Destroyed > On August 26, 2025, about 1905 Pacific daylight time, a Cessna 172S, N5203H, was destroyed when it was involved in an accident near Los Banos, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB ANC25FA086](https://openairdocs.org/ntsb/ANC25FA086.md): North American T-28B · Monticello, IA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 11, 2025 · N28XT · Substantial damage > On August 11, 2025, about 1505 Central daylight time, a North American T-28B airplane, N28XT, was substantially damaged when it was involved in an accident near Monticello, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25FA261](https://openairdocs.org/ntsb/CEN25FA261.md): Kolb Firestar · Meadow Grove, NE · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 20, 2025 · N55161 · Destroyed > On July 19, 2025, about 2050 central daylight time, a Kolb Firestar airplane, N55161, was destroyed when it was involved in an accident near Meadow Grove, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25FA214](https://openairdocs.org/ntsb/WPR25FA214.md): Piper PA-28-180 · West Yellowstone, MT · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 18, 2025 · N7186W · Substantial damage > On July 17, 2025, about 2358 mountain daylight time, a Piper PA-28-180, N7186W, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot and two pilot rated passengers were fatally injured. The airplane was… - [NTSB WPR25FA208](https://openairdocs.org/ntsb/WPR25FA208.md): Piper PA-28-180 · Needles, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 14, 2025 · N8375W · Substantial damage > On July 13, 2025, about 2128 Pacific daylight time, a Piper PA-28-180, N8375W, was substantially damaged when it was involved in an accident near Needles, California. Both pilots sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA260](https://openairdocs.org/ntsb/ERA25FA260.md): Cirrus Design SR22T · Sanford, NC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jul 7, 2025 · N5656M · Substantial damage > On July 7, 2025, about 1330 eastern daylight time, a Cirrus SR22T, N5656M, was substantially damaged when it was involved in an accident near Sanford, North Carolina. The private pilot and three passengers were fatally injured. The airplane was operated as a… - [NTSB CEN25FA194](https://openairdocs.org/ntsb/CEN25FA194.md): Universal Stinson 108 · Farmington, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 3, 2025 · N40158 · Substantial damage > On June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously… - [NTSB WPR25FA156](https://openairdocs.org/ntsb/WPR25FA156.md): DB Aerocopter AK1-3 · Prineville, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 17, 2025 · N163AK · Substantial damage > On May 17, 2025, about 1134 pacific daylight time, a DB Aerocopter Ltd., AK1-3, N163AK, sustained substantial damage when it was involved in an accident near Prineville, Oregon. The private pilot undergoing instruction was fatally injured, and the flight… - [NTSB ANC25FA035](https://openairdocs.org/ntsb/ANC25FA035.md): Cessna T207 · Nanwalek, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 28, 2025 · N91025 · Substantial damage > On April 28, 2025, about 1355 Alaska daylight time, a Cessna T207 airplane, N91025, was substantially damaged when it was involved in an accident near Nanwalek, Alaska. The pilot and one passenger were fatally injured. One passenger was seriously injured. The… - [NTSB CEN25FA106](https://openairdocs.org/ntsb/CEN25FA106.md): Vans RV7 · Matheson, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 1, 2025 · N902T · Substantial damage > On March 1, 2025, about 1215 mountain daylight time, a Vans RV7 experimental airplane, N902T, was destroyed when it was involved in an accident near Matheson, Colorado. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA086](https://openairdocs.org/ntsb/ERA25FA086.md): Cessna 310 · Peebles, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 30, 2024 · N6979T · Substantial damage > On December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN25FA040](https://openairdocs.org/ntsb/CEN25FA040.md): Beech 35-B33 · Nunn, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 15, 2024 · N285BW · Destroyed > On November 15, 2024, about 1000 mountain standard time (MST), a Beech 35-B33, N285BW, was destroyed when it was involved in an accident near Nunn, Colorado. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN25FA034](https://openairdocs.org/ntsb/CEN25FA034.md): Robinson Helicopter R44 II · Iowa, LA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Nov 2, 2024 · N62CD · Destroyed > On November 1, 2024, about 2106 central daylight time, a Robinson R-44 II helicopter, N62CD, was destroyed when it was involved in an accident near Iowa, Louisiana. The pilot and two passengers were fatally injured. The helicopter was operated as a Title 14… - [NTSB ANC25FA001](https://openairdocs.org/ntsb/ANC25FA001.md): Cessna 180 · Big Lake, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 5, 2024 · N4631U · Substantial damage > On October 4, 2024, about 1730 Alaska daylight time, a float-equipped Cessna 180 airplane, N4631U, sustained substantial damage when it was involved in an accident near Big Lake, Alaska. The pilot was fatally injured, and one passenger sustained serious… - [NTSB ANC24FA091](https://openairdocs.org/ntsb/ANC24FA091.md): Champion 7GCBC · Ninilchik, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 13, 2024 · N8CK · Substantial damage > On September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as… - [NTSB WPR24FA289](https://openairdocs.org/ntsb/WPR24FA289.md): Cessna 421C · Fairview, OR · Accident · 3 fatal · Class 3 · Field · Preliminary report · Aug 31, 2024 · N421GP · Substantial damage > On August 31, 2024, about 1030 Pacific daylight time, a Cessna 421C, N421GP was destroyed when it was involved in an accident near Fairview, Oregon. The two pilots and one person on the ground were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ANC24FA052](https://openairdocs.org/ntsb/ANC24FA052.md): Piper PA-18-150 · Moose Pass, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 18, 2024 · N645DT · Substantial damage > On June 18, 2024, about 1400 Alaska daylight time, a float-equipped Piper PA-18-150 airplane, N645DT, was substantially damaged when it was involved in an accident near Moose Pass, Alaska. The instructor pilot and the pilot receiving instruction were fatally… - [NTSB CEN22LA442](https://openairdocs.org/ntsb/CEN22LA442.md): Piper PA-18 · Battle Creek, MI · Accident · No injuries · Class 3 · Limited · Investigation open · Sep 27, 2022 · N7207 ## 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 = 990) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/990/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.