# 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 2 of 718 · 35,881 cases

## Cases, newest first

- [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 DCA26WA338](https://openairdocs.org/ntsb/DCA26WA338.md): Boeing 737 · Hongseong, South Korea · Accident · Serious injuries · Class 5 · Foreign · Aug 22, 2026 · HL8061 · No damage
- [NTSB ERA26LA311](https://openairdocs.org/ntsb/ERA26LA311.md): HPH Glasflugel 304CZ · Xenia, OH · Accident · No injuries · Class 4 · Limited · Final report · Aug 21, 2026 · N304BS · Substantial damage
  > The glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.
- [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 GAA26WA285](https://openairdocs.org/ntsb/GAA26WA285.md): Eurocopter EC130 · Ewaso Nyiro, Kenya · Accident · 7 fatal · Class 5 · Foreign · Aug 19, 2026 · 5Y-GYM · Destroyed
- [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 CEN26LA294](https://openairdocs.org/ntsb/CEN26LA294.md): Pipistrel Taurus Electro G2.5 · Hempstead, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 15, 2026 · N984TP · Substantial damage
  > The pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.
- [NTSB DCA26WA334](https://openairdocs.org/ntsb/DCA26WA334.md): Airbus A330 · Lubumbashi, Congo - Kinshasa · Incident · No injuries · Class 5 · Foreign · Aug 14, 2026 · 9S-ABS
- [NTSB DCA26WA337](https://openairdocs.org/ntsb/DCA26WA337.md): Boeing 737 · El Prat de Llobregat, Spain · Incident · No injuries · Class 5 · Foreign · Aug 13, 2026 · 9H-QEP · No damage
- [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 DCA26WA331](https://openairdocs.org/ntsb/DCA26WA331.md): Airbus A321 · Royal National Park, Australia · Incident · Class 5 · Foreign · Aug 10, 2026 · VH-OFS
- [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 DCA26WA341](https://openairdocs.org/ntsb/DCA26WA341.md): Boeing 747 · Changzhi, China · Incident · Class 5 · Foreign · Aug 2, 2026 · VQ-BBM · No damage
- [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 ERA26LA289](https://openairdocs.org/ntsb/ERA26LA289.md): Beech A36 · Weston, CT · Accident · No injuries · Class 4 · Limited · Final report · Jul 30, 2026 · N9144Q · Substantial damage
  > The in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.
- [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…
- [NTSB CEN26LA270](https://openairdocs.org/ntsb/CEN26LA270.md): Cessna P210R · Arkadelphia, AR · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 23, 2026 · N5258A · Substantial damage
- [NTSB DCA26WA328](https://openairdocs.org/ntsb/DCA26WA328.md): Boeing 737 · Higashiizu, Japan · Accident · Serious injuries · Class 5 · Foreign · Jul 21, 2026 · JA335J
- [NTSB ANC26LA075](https://openairdocs.org/ntsb/ANC26LA075.md): Cessna 152 · Pell City, AL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N103UC · Substantial damage
  > On July 20, 2026, at 1030 eastern daylight time, a Cessna 152 airplane was substantially damaged when it was involved in an accident near Pell City, Alabama. The flight instructor and student pilot were not injured. The airplane was operated as a Title 14…
- [NTSB ENG26WA031](https://openairdocs.org/ntsb/ENG26WA031.md): Airbus A321 · Hermosillo, Mexico · Incident · No injuries · Class 5 · Foreign · Jul 19, 2026 · XA-VUM
- [NTSB WPR26LA266](https://openairdocs.org/ntsb/WPR26LA266.md): Maule M-4-180V · Creede, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 18, 2026 · N489LA · Substantial damage
  > The pilot’s exceedance of the airplane’s performance capabilities in mountainous terrain, which resulted in a forced landing.
- [NTSB CEN26LA258](https://openairdocs.org/ntsb/CEN26LA258.md): Vans RV-8A · Mineral Point, WI · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 17, 2026 · N22SZ · Substantial damage
  > On July 17, 2026, at 1748 central daylight time, an experimental amateur-built Vans Aircraft Inc RV-8A, N22SZ, sustained substantial damage when it was involved in an accident in Mineral Point, Wisconsin. The commercial pilot was uninjured. The airplane was…
- [NTSB DCA26LA286](https://openairdocs.org/ntsb/DCA26LA286.md): Embraer S A ERJ 170-200 LL · Sanford, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 16, 2026 · N271SY · No damage
  > An encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.
- [NTSB ERA26LA273](https://openairdocs.org/ntsb/ERA26LA273.md): Piper PA-28-180 · Linneus, ME · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 15, 2026 · N9758J · Substantial damage
  > The pilot’s inadequate preflight and in-flight monitoring of the fuel quantity, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA26WA280](https://openairdocs.org/ntsb/DCA26WA280.md): Boeing 767 · Manta, Ecuador · Incident · No injuries · Class 5 · Foreign · Jul 12, 2026 · C-GHLU
- [NTSB DCA26WA297](https://openairdocs.org/ntsb/DCA26WA297.md): Boeing 737 · Barcelona, Spain · Incident · Class 5 · Foreign · Jul 11, 2026 · SP-RNT · 2 aircraft · No damage
- [NTSB WPR26FA254](https://openairdocs.org/ntsb/WPR26FA254.md): Beech 95-B55 (T42A) · Waterloo, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 10, 2026 · N202DK · Destroyed
  > On July 9, 2026, at about 2248 central daylight time, a Beech 95-B55, N202DK, was destroyed when it was involved in an accident near Waterloo, Illinois. The pilot and pilot rated passenger were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB GAA26WA249](https://openairdocs.org/ntsb/GAA26WA249.md): Cessna 402C · Nicholls Town, Bahamas · Accident · 10 fatal · Class 3 · Foreign · Jul 10, 2026 · C6-FLX
- [NTSB DCA26WA284](https://openairdocs.org/ntsb/DCA26WA284.md): Airbus A321 · San Andrés, Spain · Incident · Class 5 · Foreign · Jul 10, 2026 · EC-OLE
- [NTSB DCA26FA274](https://openairdocs.org/ntsb/DCA26FA274.md): Boeing 737 · Polykastro, Greece · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jul 10, 2026 · 9H-QEU · Substantial damage
  > Malta Air, doing business as Ryanair flight 1879, a Boeing 737-8AS, registration 9H-QEU, experienced a No. 2 (right) engine fan-blade-out (FBO) failure during climb out from the Thessaloniki International Airport (SKG), Thessaloniki, Greece. Engine fragments…
- [NTSB CEN26LA251](https://openairdocs.org/ntsb/CEN26LA251.md): Vans RV-12 · Grand Junction, CO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 10, 2026 · N812MM · Substantial damage
  > On July 10, 2026, about 1023 mountain daylight time, an experimental amateur-built Vans Aircraft Inc RV-12 airplane, N812MM, sustained substantial damage when it was involved in an accident near Grand Junction, Colorado. The pilot and a passenger were…
- [NTSB CEN26LA249](https://openairdocs.org/ntsb/CEN26LA249.md): Cessna 150 · Ellsworth, KS · Accident · No injuries · Class 4 · Limited · Final report · Jul 10, 2026 · N3773J · Substantial damage
  > The pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.
- [NTSB CEN26LA250](https://openairdocs.org/ntsb/CEN26LA250.md): Glasair I RG · Utica, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 9, 2026 · N141CG · Substantial damage
  > On July 9, 2026, about 1805 central daylight time, a Glasair 1RG airplane, N141CG, sustained substantial damage when it was involved in an accident near Utica, Minnesota. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ANC26LA070](https://openairdocs.org/ntsb/ANC26LA070.md): Mooney M20M · Tallahassee, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 8, 2026 · N488AT · Substantial damage
  > On July 8, 2026, at 1148 eastern daylight time, a Mooney M20 airplane was substantially damaged when it was involved in an accident near Tallahassee, Florida. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA26WA276](https://openairdocs.org/ntsb/DCA26WA276.md): Boeing 767 · enroute, France · Incident · Class 5 · Foreign · Jul 7, 2026 · OY-SRF · Minor damage
- [NTSB DCA26WA267](https://openairdocs.org/ntsb/DCA26WA267.md): Boeing 737 · Arabian Sea, Pakistan · Accident · No injuries · Class 3 · Foreign · Jul 7, 2026 · AP-BOI
- [NTSB ANC26LA069](https://openairdocs.org/ntsb/ANC26LA069.md): Piper PA-18-150 · Mekoryuk, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2026 · N824JT · Substantial damage
  > On July 7, 2026 about 1430 Alaska daylight time, a Piper PA-18-150 airplane, N824JT, was substantially damaged when it was involved in an accident near Mekoryuk, Alaska. The pilot and one passenger were not injured. The airplane was operated as a Title 14…
- [NTSB DCA26LA270](https://openairdocs.org/ntsb/DCA26LA270.md): Airbus A321-231 · Somerset, CO · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 6, 2026 · N943JT · No damage
- [NTSB ERA26LA257](https://openairdocs.org/ntsb/ERA26LA257.md): Cirrus Design SR22 · Lafayette, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 2, 2026 · N127DC · Substantial damage
  > On July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…
- [NTSB CEN26FA241](https://openairdocs.org/ntsb/CEN26FA241.md): Beech 95-A55 · Lancaster, SC · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jul 2, 2026 · N7501S · Substantial damage
  > On July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?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."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?page=2

---
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.