# Ongoing NTSB investigations: Approach 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 3 · 104 cases ## Latest cases - [NTSB ERA27LA025](https://openairdocs.org/ntsb/ERA27LA025.md): Cessna 182Q · Ball Ground, GA · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 21, 2026 · N759RR · Substantial damage - [NTSB WPR27LA021](https://openairdocs.org/ntsb/WPR27LA021.md): Cessna 182A · Galveston, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 19, 2026 · N5153D · Substantial damage - [NTSB WPR27FA015](https://openairdocs.org/ntsb/WPR27FA015.md): Bertling Courtney MXL-2 · Newberg, OR · Accident · 1 fatal · Class 4 · Field · Investigation open · Oct 12, 2026 · N947BX · Substantial damage - [NTSB CEN27LA012](https://openairdocs.org/ntsb/CEN27LA012.md): Diamond Aircraft Ind DA20-C1 · Flint, MI · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 10, 2026 · N96YY · Substantial damage - [NTSB WPR27LA004](https://openairdocs.org/ntsb/WPR27LA004.md): Head Balloons AX8-88B · Albuquerque, NM · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 3, 2026 · N4502A · Substantial damage - [NTSB CEN26LA327](https://openairdocs.org/ntsb/CEN26LA327.md): Haberman Habercraft · Pelican Rapids, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 27, 2026 · N10516 · Substantial damage > On September 27, 2026, about 1720 central daylight time, a Haberman Habercraft airplane, N10516, was substantially damaged during an accident near Pelican Rapids, Minnesota. The pilot sustained a minor injury. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA362](https://openairdocs.org/ntsb/ERA26LA362.md): Piper PA-28-140 · Canon, GA · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 22, 2026 · N3713K · Substantial damage - [NTSB WPR26LA347](https://openairdocs.org/ntsb/WPR26LA347.md): Bell 206B-III · Creswell, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 18, 2026 · N50141 · Substantial damage > On September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of… - [NTSB CEN26LA319](https://openairdocs.org/ntsb/CEN26LA319.md): Beech K35 · Wausau, WI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 13, 2026 · N6071E · Substantial damage > On September 12, 2026, about 2049 central daylight time, a Beech K35 airplane, N6071E, was substantially damaged when it was involved in an accident near Wausau, Wisconsin. The pilot and passenger suffered minor injuries. The flight was operated as a Title 14… - [NTSB WPR26LA335](https://openairdocs.org/ntsb/WPR26LA335.md): Cessna 210 · Polson, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 10, 2026 · N9517T · Substantial damage > On September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title… - [NTSB WPR26FA330](https://openairdocs.org/ntsb/WPR26FA330.md): Cessna 172N · San Diego, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 8, 2026 · N734ZK · Destroyed > On September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a… - [NTSB WPR26LA331](https://openairdocs.org/ntsb/WPR26LA331.md): Filip Richard/Fakowee Avia Indus Thrp T211 SP E · Benson, AZ · Accident · Serious injuries · Class 4 · Limited · Investigation open · Sep 6, 2026 · N211RJ · Substantial damage - [NTSB WPR26LA322](https://openairdocs.org/ntsb/WPR26LA322.md): Krugh Patrick M Steen Skybolt · Big Bear, CA · Accident · Serious injuries · Class 4 · Limited · Investigation open · Aug 28, 2026 · N43PK · Substantial damage - [NTSB WPR26FA309](https://openairdocs.org/ntsb/WPR26FA309.md): Cessna 441 · Cape Newenham, AK · Accident · 8 fatal · Class 3 · Field · Preliminary report · Aug 20, 2026 · N128EZ · Destroyed > On August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA303](https://openairdocs.org/ntsb/ERA26LA303.md): Mcfarland Larry C Zenith 601 HDS · Ripley Landing, WV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2026 · N601EZ · Substantial damage > On August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.… - [NTSB WPR26LA296](https://openairdocs.org/ntsb/WPR26LA296.md): Cessna 180 · La Center, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 10, 2026 · N180DT · Substantial damage > On August 10, 2026, about 12:55 Pacific daylight time, a Cessna 180, N180DT, was substantially damaged when it was involved in an accident near La Center, Washington. The flight instructor and pilot receiving instruction were seriously injured. The flight was… - [NTSB WPR26LA302](https://openairdocs.org/ntsb/WPR26LA302.md): Cessna 208B · Salmon, ID · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 9, 2026 · N247JP · Substantial damage > On August 9, 2026, at 1420 mountain daylight time, a Cessna 208B airplane, N247JP, was substantially damaged when it was involved in an accident near Salmon, Idaho. The pilot and eight passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26LA271](https://openairdocs.org/ntsb/CEN26LA271.md): Beech V35 · Carroll, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2026 · N3707Q · Substantial damage > On July 24, 2026, about 1550 central daylight time, a Beech V35 airplane, N3707Q, was substantially damaged when it was involved in an accident near Carroll, Iowa. The pilot was not injured. The flight was operated under the provisions of Title 14 Code of… - [NTSB CEN26LA263](https://openairdocs.org/ntsb/CEN26LA263.md): Piper PA24 · Baraboo, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2026 · N8606P · Substantial damage > On July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14… - [NTSB CEN26FA257](https://openairdocs.org/ntsb/CEN26FA257.md): Dakota Cub Super 18 · Plymouth, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 16, 2026 · N84AJ · Substantial damage > On July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of… - [NTSB CEN26FA253](https://openairdocs.org/ntsb/CEN26FA253.md): Montana Coyote · Fredericksburg, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N448VQ · Substantial damage > On July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a… - [NTSB ERA26FA266](https://openairdocs.org/ntsb/ERA26FA266.md): Sikorsky S76 · Huntersville, WV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 10, 2026 · N93RT · Destroyed > On July 10, 2026, about 0745 eastern daylight time, a Sikorsky S-76D helicopter, N93RT, was destroyed when it was involved in an accident near Huntersville, West Virginia. The commercial pilot was fatally injured. The helicopter was operated as a Title 14… - [NTSB CEN26LA248](https://openairdocs.org/ntsb/CEN26LA248.md): Piper PA-30 · Tulsa, OK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 9, 2026 · N8154Y · Substantial damage > On July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was… - [NTSB ANC26LA068](https://openairdocs.org/ntsb/ANC26LA068.md): Schweizer 269C · Skwentna, AK · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jul 5, 2026 · N907AL · Substantial damage - [NTSB DCA26LA242](https://openairdocs.org/ntsb/DCA26LA242.md): Airbus Industrie A319-114 · Boston, MA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N328NB · 2 aircraft · No damage > On June 20, 2026, about 1134 eastern daylight time (EDT), Delta Air Lines flight 2351 (DAL2351), an Airbus A319, and American Airlines flight 3161 (AAL3161), a Boeing 737-800, were involved in a runway incursion that resulted in a go-around of DAL2351 at… - [NTSB WPR26LA211](https://openairdocs.org/ntsb/WPR26LA211.md): Piper PA-44-180T · St. George, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 7, 2026 · N8390K · Substantial damage > On June 7, 2026, about 1012 mountain standard time, a Piper PA-44-180T, N8390K, was substantially damaged when it was involved in an accident near St. George, Utah. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA214](https://openairdocs.org/ntsb/WPR26LA214.md): Mooney M20J · Albuquerque, NM · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 31, 2026 · N555ED · Substantial damage > On May 31, 2026, at 1515 mountain daylight time, a Mooney M20J, N555ED, sustained substantial damage when it was involved in an accident near Albuquerque, New Mexico. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA205](https://openairdocs.org/ntsb/WPR26LA205.md): Cessna 208B · Shelton, WA · Accident · Serious injuries · Class 4 · Limited · Investigation open · May 29, 2026 · N661WA · Substantial damage - [NTSB CEN26LA199](https://openairdocs.org/ntsb/CEN26LA199.md): Cessna A188B · Blair, NE · Accident · No injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N84497 · Substantial damage > On May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26FA197](https://openairdocs.org/ntsb/CEN26FA197.md): Fokker DR1 Replica · Frankston, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 26, 2026 · N54517 · Destroyed > On May 26, 2026, about 0810 central daylight time, an experimental Fokker DR1 airplane, N54517, was destroyed when it was involved in an accident near Frankston, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26FA192](https://openairdocs.org/ntsb/CEN26FA192.md): Cessna 172N · Westerly, RI · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 18, 2026 · N733CP · Substantial damage > On May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26FA186](https://openairdocs.org/ntsb/WPR26FA186.md): Beech C90 · Lincoln, NM · Accident · 4 fatal · Class 3 · Field · Preliminary report · May 14, 2026 · N249CP · Destroyed > On May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the… - [NTSB ERA26FA208](https://openairdocs.org/ntsb/ERA26FA208.md): Piper PA-28-180 · Akron, OH · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 14, 2026 · N7188W · Destroyed > On May 14, 2026, at 1545 eastern daylight time, a Piper PA-28-180, N7188W, was destroyed when it was involved in an accident near Akron, Ohio. The flight instructor and student pilot were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB DCA26FA194](https://openairdocs.org/ntsb/DCA26FA194.md): Boeing 767-424ER · Newark, NJ · Accident · Minor injuries · Class 3 · Field · Preliminary report · May 3, 2026 · N77066 · Substantial damage > On May 3, 2026, about 13:50 eastern daylight time (EDT), United Airlines flight 169, Boeing B767-424ER, N77066, struck a light pole on the New Jersey turnpike while on final approach to runway 29 at Newark Liberty International Airport (EWR), Newark, New… - [NTSB WPR26LA164](https://openairdocs.org/ntsb/WPR26LA164.md): Cessna 172S · Pacoima, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 20, 2026 · N2126F · Substantial damage > On April 20, 2026, about 1107 Pacific daylight time, a Cessna 172S airplane, N2126F, sustained substantial damage when it was involved in an accident near Whiteman Airport (WHP), Pacoima, California. The pilot was seriously injured. The airplane was operated… - [NTSB CEN26LA164](https://openairdocs.org/ntsb/CEN26LA164.md): Piper PA-28-180 · Corpus Christi, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 14, 2026 · N317HM · Destroyed > On April 13, 2026, about 19:19 central daylight time, a Piper Cherokee PA-28-180 airplane, N317HM was destroyed when it was involved in an accident near Corpus Christi, Texas. The flight instructor and student pilot were seriously injured. The airplane was… - [NTSB WPR26LA155](https://openairdocs.org/ntsb/WPR26LA155.md): Aero Vodochody L-39 · Ennis, MT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N136EM · Substantial damage > On April 10, 2026, about 1210 mountain daylight time, an Aero Vodochody L 39, N136EM, was substantially damaged when it was involved in an accident near Ennis, Montana. The flight instructor sustained minor injuries, and the pilot undergoing instruction was… - [NTSB WPR26LA152](https://openairdocs.org/ntsb/WPR26LA152.md): Just Highlander · Great Falls, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 8, 2026 · N563JA · Substantial damage > On April 8, 2026, about 1106 mountain daylight time, an experimental amateur built Just Aircraft Highlander, N563JA, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated… - [NTSB ERA26LA156](https://openairdocs.org/ntsb/ERA26LA156.md): Piper PA-28-181 · Philadelphia, PA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 1, 2026 · N494LA · Substantial damage > On April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious… - [NTSB CEN26LA156](https://openairdocs.org/ntsb/CEN26LA156.md): Cessna 150G · Ellicott, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N6305S · Substantial damage > On March 21, 2026, about 1023 mountain daylight time, a Cessna 150G airplane, N6305S, was substantially damaged when it was involved in an accident near Ellicott, Colorado. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA120](https://openairdocs.org/ntsb/WPR26FA120.md): Columbia Aircraft Mfg LC41-550FG · Albuquerque, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 6, 2026 · N2516S · Substantial damage > On March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from… - [NTSB ERA26LA136](https://openairdocs.org/ntsb/ERA26LA136.md): Cessna 551 · Opa-locka, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 4, 2026 · N228MH · Substantial damage > On March 4, 2026, about 1648 eastern standard time, a Cessna 551, N228MH, was substantially damaged when it was involved in an accident near Opa-locka, Florida. The two pilots and three passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26FA110](https://openairdocs.org/ntsb/ERA26FA110.md): Pipistrel Taurus 503 · Boynton Beach, FL · Accident · Serious injuries · Class 3 · Field · Preliminary report · Feb 9, 2026 · N414HG · Substantial damage > On February 9, 2026, about 1514 eastern standard time, a Pipistrel Taurus 503 motorglider, N414HG, was substantially damaged when it was involved in an accident at Willis Gliderport (FA44), Boynton Beach, Florida. The pilot was seriously injured. The… - [NTSB WPR26FA097](https://openairdocs.org/ntsb/WPR26FA097.md): Socata TB21 · Prescott, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 5, 2026 · N967WM · Destroyed > On February 4, 2026, about 1950 mountain standard time, a Socata TB21, N967WM, was destroyed when it was involved in an accident near Prescott, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB CEN26LA094](https://openairdocs.org/ntsb/CEN26LA094.md): Cessna 172K · Amery, WI · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 16, 2026 · N79118 · Substantial damage > On January 16, 2026, about 1130 central standard time, a Cessna 172 airplane, N79118, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA078](https://openairdocs.org/ntsb/ERA26LA078.md): Beech B90 · Atlanta, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 28, 2025 · N40BA · Substantial damage > On December 28, 2025, about 0935 eastern standard time, a Beech B90 airplane, N40BA, was substantially damaged when it was involved in an accident near Atlanta, Georgia. The pilot received minor injuries, and the copilot was seriously injured. The airplane… - [NTSB WPR26FA067](https://openairdocs.org/ntsb/WPR26FA067.md): Beechcraft B300 · Galveston, TX · Accident · 6 fatal · Class 3 · Field · Preliminary report · Dec 22, 2025 · ANX1209 · Destroyed > On December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two… - [NTSB CEN26LA080](https://openairdocs.org/ntsb/CEN26LA080.md): Cessna 150 · Prospect Heights, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 21, 2025 · N3103V · Substantial damage > On December 21, 2025, about 1342 central standard time, a Cessna 150M, N3103V, was substantially damaged when it was involved in an accident near Prospect Heights, Illinois. The student pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA060](https://openairdocs.org/ntsb/CEN26LA060.md): Sonerai II · Cresson, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 12, 2025 · N28MD · Substantial damage > On December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26FA051](https://openairdocs.org/ntsb/CEN26FA051.md): Cessna 172N · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 25, 2025 · N80FP · Destroyed > On November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was… Next page: https://openairdocs.org/ntsb-phases/500/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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/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.