# Ongoing NTSB investigations: Enroute

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 6 · 280 cases

## Latest cases

- [NTSB ERA27LA022](https://openairdocs.org/ntsb/ERA27LA022.md): Douglas A Kupersmith Zenith CH650B · Canton, OH · Accident · Minor injuries · Class 3 · Limited · Investigation open · Oct 25, 2026 · N255DK
- [NTSB CEN27LA031](https://openairdocs.org/ntsb/CEN27LA031.md): Aeronca 65CA · Hartford, WI · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 24, 2026 · N34402 · Substantial damage
- [NTSB CEN27LA029](https://openairdocs.org/ntsb/CEN27LA029.md): Piper PA-28 · Claremore, OK · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 22, 2026 · N5393W · Substantial damage
  > On October 22, 2026, about 1510 central daylight time, a Piper PA-28-160 airplane, N5393W, was substantially damaged when it was involved in an accident near Claremore, Oklahoma. The flight instructor and student pilot were not injured. The airplane was…
- [NTSB CEN27LA028](https://openairdocs.org/ntsb/CEN27LA028.md): Cessna P206 · Nacogdoches, TX · Accident · No injuries · Class 3 · Limited · Investigation open · Oct 22, 2026 · N2649X
- [NTSB DCA27LA019](https://openairdocs.org/ntsb/DCA27LA019.md): Boeing 777-222 · Pacific Ocean (Pacific Ocean) · Accident · Serious injuries · Class 4 · Limited · Investigation open · Oct 21, 2026 · N769UA · No damage
- [NTSB CEN27LA024](https://openairdocs.org/ntsb/CEN27LA024.md): Eurocopter Deutschland EC 135 P2 · Bridgeton, MO · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 19, 2026 · N3842 · Substantial damage
- [NTSB CEN27FA016](https://openairdocs.org/ntsb/CEN27FA016.md): Piper PA 46-350P · Reedsburg, WI · Accident · 5 fatal · Class 3 · Field · Investigation open · Oct 14, 2026 · N931TT
- [NTSB CEN27LA017](https://openairdocs.org/ntsb/CEN27LA017.md): Donald K Stovall Pietenpol Aircamper · Syracuse, KS · Accident · Class 3 · Limited · Investigation open · Oct 13, 2026 · N728MK
- [NTSB DCA27LA014](https://openairdocs.org/ntsb/DCA27LA014.md): Boeing 777 · Orlando, FL · Occurrence · No injuries · Class 4 · Limited · Investigation open · Oct 12, 2026 · G-VIIT · No damage
- [NTSB WPR27FA014](https://openairdocs.org/ntsb/WPR27FA014.md): Piper PA-18-150 · Wauconda, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 11, 2026 · N927JS · Destroyed
  > On October 10, 2026, about 2014 Pacific daylight time, a Piper PA-18-150, N927JS, was substantially damaged when it was involved in an accident near Wauconda, Washington. The flight instructor and student pilot were fatally injured. The airplane was operated…
- [NTSB CEN27LA011](https://openairdocs.org/ntsb/CEN27LA011.md): Flight Design Ctls · Yankton, SD · Accident · Minor injuries · Class 4 · Limited · Investigation open · Oct 9, 2026 · N792CT · Substantial damage
- [NTSB CEN27LA005](https://openairdocs.org/ntsb/CEN27LA005.md): Diamond Aircraft Ind DA 40 · Eldorado Springs, CO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Oct 5, 2026 · N162GL · Destroyed
  > On October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…
- [NTSB WPR26FA363](https://openairdocs.org/ntsb/WPR26FA363.md): Eurocopter Deutschland EC 135 P2+ · Avalon, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 1, 2026 · N313RX · Substantial damage
  > On September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…
- [NTSB WPR26LA362](https://openairdocs.org/ntsb/WPR26LA362.md): Smith Pitts Special S-1 · Madison, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 29, 2026 · N292Y · Substantial damage
  > On September 29, 2026, at about 1347 eastern daylight time, a Smith Pitts Special S-1, N292Y, was substantially damaged when it was involved in an accident near Madison, Georgia. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26LA356](https://openairdocs.org/ntsb/WPR26LA356.md): Zenith CH 750 Stol · Spring Creek, NV · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 24, 2026 · N750WZ · Substantial damage
  > On September 24, 2026, about 0958 mountain daylight time, an experimental amateur-built Zenith CH750 STOL airplane, N750WZ, was substantially damaged when it was involved in an accident near Silver Creek, Nevada. The pilot was not injured. The airplane was…
- [NTSB CEN26LA324](https://openairdocs.org/ntsb/CEN26LA324.md): Magni M16 · Annapolis, MO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Sep 23, 2026 · N109MG · Substantial damage
  > On September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…
- [NTSB ERA26LA346](https://openairdocs.org/ntsb/ERA26LA346.md): Schleicher ASW-24 · Edinburg, NY · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Sep 18, 2026 · N94CG · 2 aircraft · Substantial damage
  > On September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was…
- [NTSB CEN26LA332](https://openairdocs.org/ntsb/CEN26LA332.md): Piper PA18 · Karinen, SD · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 17, 2026 · N3879Z · Substantial damage
  > On September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…
- [NTSB ANC26FA105](https://openairdocs.org/ntsb/ANC26FA105.md): Cessna A185F · Stony River, AK · Accident · 2 fatal · Class 3 · Field · Investigation open · Sep 15, 2026 · N4358Q
- [NTSB WPR26LA344](https://openairdocs.org/ntsb/WPR26LA344.md): Taylorcraft BC12D · Nibbe, MT · Accident · Serious injuries · Class 4 · Limited · Investigation open · Sep 14, 2026 · N96888 · Substantial damage
- [NTSB ERA26LA337](https://openairdocs.org/ntsb/ERA26LA337.md): Air Tractor AT-602 · Morven, GA · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 13, 2026 · N686LA · Substantial damage
- [NTSB CEN26LA318](https://openairdocs.org/ntsb/CEN26LA318.md): Vans RV4 · Harrisonville, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2026 · N254MM · Substantial damage
  > On September 13, 2026, about 0930 central daylight time, a Vans Aircraft Inc, RV-4, N254MM, was substantially damaged when it was involved in an accident near Harrisonville, Missouri. The pilot and passenger were not injured. The airplane was operated as a…
- [NTSB CEN26LA314](https://openairdocs.org/ntsb/CEN26LA314.md): Cessna 150F · Weslaco, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 8, 2026 · N8061F · Substantial damage
- [NTSB CEN26LA313](https://openairdocs.org/ntsb/CEN26LA313.md): Stearman A75 · Bogue Chitto, MS · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 8, 2026 · N680HW · Substantial damage
  > On September 8, 2026, about 1100 central daylight time, a Boeing-Stearman A75L300 airplane, N680HW, was substantially damaged when it was involved in an accident near Bogue Chitto, Mississippi. The pilot sustained minor injuries and the passenger was…
- [NTSB ERA26LA331](https://openairdocs.org/ntsb/ERA26LA331.md): Bell 47G-4A · Alcoma, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 6, 2026 · N797WS · Substantial damage
  > On September 5, 2026, at 1422 eastern daylight time, a Bell 47G-4A, N797WS, was substantially damaged when it was involved in an accident near Alcoma, Florida. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA26FA329](https://openairdocs.org/ntsb/ERA26FA329.md): Piper PA-28-181 · Ludlow, MA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 6, 2026 · N7653F · Destroyed
  > On September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ANC26FA097](https://openairdocs.org/ntsb/ANC26FA097.md): Cessna T206H · Dunton, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N919CW · Destroyed
  > On September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…
- [NTSB ERA26LA325](https://openairdocs.org/ntsb/ERA26LA325.md): Cessna 210 · Dawson Springs, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 2, 2026 · N9420M · Substantial damage
  > On September 1, 2026, at 2225 central daylight time, a Cessna 210K, N9420M, was substantially damaged when it was involved in an accident near Dawson Springs, Kentucky. The private pilot and passenger were not injured. The airplane was operated as a Title 14…
- [NTSB CEN26LA309](https://openairdocs.org/ntsb/CEN26LA309.md): Mooney M20E · West Branch, IA · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 2, 2026 · N55GA · Substantial damage
- [NTSB WPR26LA327](https://openairdocs.org/ntsb/WPR26LA327.md): Cessna 150E · Siler, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 1, 2026 · N3037J · Substantial damage
  > On September 1, 2026, at 1220 Pacific daylight time, a Cessna 150E, N3037J, sustained substantial damage when it was involved in an accident near Siler, Washington. The pilot and pilot rated passenger were not injured. The airplane was operated as a Title 14…
- [NTSB WPR26LA323](https://openairdocs.org/ntsb/WPR26LA323.md): Beech E-55 · Mecca, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 30, 2026 · N333W · Substantial damage
- [NTSB ERA26FA317](https://openairdocs.org/ntsb/ERA26FA317.md): Consolidated Aeronautics Lake LA-4-200 · Ithaca, NY · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 30, 2026 · N6185V · Substantial damage
  > On August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was…
- [NTSB ERA26LA316](https://openairdocs.org/ntsb/ERA26LA316.md): Piper PA-18A 150 · New Smyrna Beach, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 27, 2026 · N2368P · Substantial damage
  > On August 27, 2026, about 1051 eastern daylight time, a Piper PA-18A 150, N2368P, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA26LA340](https://openairdocs.org/ntsb/DCA26LA340.md): Airbus A319-132 · Houston, TX · Accident · Serious injuries · Class 4 · Limited · Investigation open · Aug 27, 2026 · N884UA · No damage
- [NTSB ERA26FA310](https://openairdocs.org/ntsb/ERA26FA310.md): Diamond Aircraft Ind DA20-A1 · Bristol, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2026 · N83RF · Substantial damage
  > On August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…
- [NTSB ANC26LA089](https://openairdocs.org/ntsb/ANC26LA089.md): Cessna 180J · Bettles, AK · Accident · Minor injuries · Class 4 · Limited · Investigation open · Aug 19, 2026 · N9949N · Substantial damage
- [NTSB CEN26LA295](https://openairdocs.org/ntsb/CEN26LA295.md): Aviat A-1B · Pilot Grove, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 17, 2026 · N299CA · Substantial damage
  > On August 17, 2026, about 1446 central daylight time, an Aviat Aircraft Inc A-1B airplane, N299CA, was substantially damaged when it was involved in an accident near Pilot Grove, Minnesota. The two pilots received minor injuries. The airplane was operated as…
- [NTSB CEN26LA287](https://openairdocs.org/ntsb/CEN26LA287.md): Mooney M20G · Luling, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 13, 2026 · N6916N · Substantial damage
  > On August 13, 2026, about 1302 central daylight time, a Mooney M20G airplane, N6916N, sustained substantial damage when it was involved in an accident near Luling, Texas. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ANC26LA084](https://openairdocs.org/ntsb/ANC26LA084.md): Robinson Helicopter R44 II · Anthony, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 13, 2026 · N861MP · Substantial damage
  > On August 12, 2026, at approximately 2305 eastern daylight time, a Robinson R44 Raven II helicopter, N861MP, was substantially damaged when it was involved in an accident near Anthony, Florida. The pilot and passenger sustained minor injuries. The helicopter…
- [NTSB WPR26FA301](https://openairdocs.org/ntsb/WPR26FA301.md): New Glasair Sportsman 2 Plus 2 · Pine, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 11, 2026 · N202AZ · Destroyed
  > On August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…
- [NTSB ERA26LA358](https://openairdocs.org/ntsb/ERA26LA358.md): Piper PA24 · Union City, OH · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 10, 2026 · N6985P · Substantial damage
  > On August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…
- [NTSB CEN26LA283](https://openairdocs.org/ntsb/CEN26LA283.md): Velocity Velocity · Palmyra, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 10, 2026 · N6954K · Substantial damage
  > On August 10, 2026, about 1248 central daylight time, an experimental Velocity 173 FG Elite II airplane, N6954K, sustained substantial damage when it was involved in an accident near Palmyra, Illinois. The pilot and two passengers sustained no injuries. The…
- [NTSB ERA26LA296](https://openairdocs.org/ntsb/ERA26LA296.md): Piper PA32 · Dawsonville, GA · Accident · Serious injuries · Class 3 · Limited · Investigation open · Aug 9, 2026 · N3011X
- [NTSB ERA26LA295](https://openairdocs.org/ntsb/ERA26LA295.md): Mooney M20E · Conway, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 9, 2026 · N9257V · Substantial damage
  > On August 9, 2026 at 802 eastern daylight time, a Mooney M20E, N9257V, was substantially damaged when it was involved in an accident near Conway, South Carolina. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB WPR26LA300](https://openairdocs.org/ntsb/WPR26LA300.md): Zaklad Szybowcowy Jezow PW-6U · Floriston, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 7, 2026 · N17YC · Substantial damage
- [NTSB ANC26LA080](https://openairdocs.org/ntsb/ANC26LA080.md): Piper PA-32-260 · Pinetown, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 6, 2026 · N8791E · Substantial damage
  > On August 6, 2026, about 1355 eastern daylight time, a Piper Aircraft PA-32-260 airplane, N8791E, was substantially damaged when it was involved in an accident near Pinetown, North Carolina. The private pilot and two passengers sustained minor injuries. The…
- [NTSB CEN26FA280](https://openairdocs.org/ntsb/CEN26FA280.md): Piper PA-24-250 · Bethany, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 4, 2026 · N8422P · Destroyed
  > On August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…
- [NTSB WPR26LA285](https://openairdocs.org/ntsb/WPR26LA285.md): Cessna 172 · Layton, UT · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 31, 2026 · N9650V · Substantial damage
  > On July 30, 2026, at 2356 mountain daylight time, a Cessna 172M airplane, N9650V, was substantially damaged when it was involved in an accident near Layton, Utah. The flight instructor was seriously injured, and the private pilot sustained minor injuries. The…
- [NTSB CEN26LA268](https://openairdocs.org/ntsb/CEN26LA268.md): Kitfox III · Ephraim, WI · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 27, 2026 · N573TB · Substantial damage
  > On July 26, 2026, at 1941 central daylight time, an experimental Kitfox III airplane, N573TB, sustained substantial damage when it was involved in an accident near Ephraim, Wisconsin. The private pilot and a passenger were uninjured. The airplane was operated…
- [NTSB ERA26LA283](https://openairdocs.org/ntsb/ERA26LA283.md): American AA-1 · Kearneysville, WV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 23, 2026 · N6132L · Substantial damage
  > On July 23, 2026, at 1440 eastern daylight time, an American AA-1, N6132L, was substantially damaged when it was involved in an accident near Kearneysville, West Virginia. The pilot and pilot-rated passenger were seriously injured. The airplane was being…

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

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