# 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 120 of 718 · 35,889 cases

## Cases, newest first

- [NTSB LAX07LA140](https://openairdocs.org/ntsb/LAX07LA140.md): Cessna 182Q · Carlsbad, CA · Accident · 3 fatal · Limited investigation · Final report · Apr 29, 2007 · N97287 · Destroyed
  > the pilot's loss of control due to spatial disorientation.
- [NTSB DEN07FA089](https://openairdocs.org/ntsb/DEN07FA089.md): Schleicher Alexander ASH 26E · Castle Rock, CO · Accident · 1 fatal · Field investigation · Final report · Apr 29, 2007 · N123KS · Substantial damage
  > the pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush.
- [NTSB MIA07LA086](https://openairdocs.org/ntsb/MIA07LA086.md): Aerospatiale ATR 72-212 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2007 · N407AT · No damage
  > In-flight encounter with turbulence that resulted in injuries to a flight attendant and a passenger.
- [NTSB LAX07CA144](https://openairdocs.org/ntsb/LAX07CA144.md): Gadbois Apex Cross 5 · Show Low, AZ · Accident · No injuries · Data collection · Final report · Apr 28, 2007 · N751EW · Substantial damage
  > the pilot's inadequate in-flight fuel consumption calculations and failure to divert to an alternate airport, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB MIA07LA089](https://openairdocs.org/ntsb/MIA07LA089.md): Hiller UH-12C · Plant City, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 2007 · N92993 · Substantial damage
  > The loss of engine power due to a magneto impulse coupling failure for undetermined reasons.
- [NTSB DEN07CA087](https://openairdocs.org/ntsb/DEN07CA087.md): Cessna 310R · Hatch, NM · Accident · No injuries · Data collection · Final report · Apr 27, 2007 · N3700G · Substantial damage
  > The pilot's inattentiveness to the fuel flow and fuel selector valve position resulting in fuel starvation. Contributing factors were the pilot's failure to follow proper engine failure procedures, and the pilot's improper in-flight planning and decision…
- [NTSB ATL07FA081](https://openairdocs.org/ntsb/ATL07FA081.md): Piper PA-38-112 · Dawsonville, GA · Accident · 1 fatal · Field investigation · Final report · Apr 26, 2007 · N9247T · Substantial damage
  > The pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.
- [NTSB ATL07LA079](https://openairdocs.org/ntsb/ATL07LA079.md): Hughes 369D · Whiteville, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2007 · N11AS · Substantial damage
  > A partial loss of engine power due to fatigue fracture of the power turbine governor spring, causing a false pneumatic signal to the fuel control and a corresponding reduction in fuel flow.
- [NTSB CHI07LA115](https://openairdocs.org/ntsb/CHI07LA115.md): Bird Seawind 3000 · Knox City, MO · Accident · 2 fatal · Limited investigation · Final report · Apr 23, 2007 · N40SW · Destroyed
  > The loss of engine power for an undetermined reason. Contributing to the accident was the unsuitable terrain that was encountered by the pilot during the forced landing.
- [NTSB LAX07CA133](https://openairdocs.org/ntsb/LAX07CA133.md): Jiran FJ-1 · Banks, OR · Accident · No injuries · Data collection · Final report · Apr 22, 2007 · N366W · Substantial damage
  > the pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.
- [NTSB ATL07IA078](https://openairdocs.org/ntsb/ATL07IA078.md): Airbus Industrie A319-111 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Apr 22, 2007 · N904FR · Minor damage
  > The mechanics failure to follow procedures and directives in securing the lower engine cowling after maintenance, and the failure of the first officer to follow the checklist to ensure the engine cowling was secured during the walk around inspection resulting…
- [NTSB MIA07LA084](https://openairdocs.org/ntsb/MIA07LA084.md): Piper PA-23-250 · Atlantic Ocean (Atlantic Ocean) · Accident · 5 fatal · Limited investigation · Final report · Apr 21, 2007 · N4TR · Destroyed
  > The pilot's continued visual flight rules flight into known adverse weather conditions, resulting in an in-flight loss of aircraft control. Contributing to the accident were thunderstorms.
- [NTSB MIA07FA083](https://openairdocs.org/ntsb/MIA07FA083.md): Cessna 182Q · Cudjoe Key, FL · Accident · 3 fatal · Field investigation · Final report · Apr 21, 2007 · N422G · Substantial damage
  > The pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.
- [NTSB CHI07CA116](https://openairdocs.org/ntsb/CHI07CA116.md): Diamond Aircraft Industries DA 20-A1 · Warrenton, MO · Accident · No injuries · Data collection · Final report · Apr 21, 2007 · N50ML · Substantial damage
  > The pilot's inadequate pre-flight planning which resulted in exhaustion of the fuel supply and the unsuitable terrain encountered for the forced landing. A factor in the accident was inaccurate fuel quantity indication.
- [NTSB SEA07CA100](https://openairdocs.org/ntsb/SEA07CA100.md): Cessna 150E · Levelland, TX · Accident · No injuries · Data collection · Final report · Apr 20, 2007 · N3523J · Substantial damage
  > The pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA07FA106](https://openairdocs.org/ntsb/SEA07FA106.md): Piper PA-28-140 · Tehachapi, CA · Accident · 2 fatal · Field investigation · Final report · Apr 18, 2007 · N8168N · Substantial damage
  > The pilot's VFR flight into IMC and his ensuing failure to maintain terrain clearance. Contributing factors were the cloudy weather conditions and the mountainous terrain.
- [NTSB SEA07CA105](https://openairdocs.org/ntsb/SEA07CA105.md): Cessna 150E · Shawnee, OK · Accident · No injuries · Data collection · Final report · Apr 18, 2007 · N6251T · Substantial damage
  > The pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.
- [NTSB NYC07LA095](https://openairdocs.org/ntsb/NYC07LA095.md): Rolladen-Schneider LS8-18 · Circleville, WV · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 2007 · C-GFPQ · Substantial damage
  > The glider's inadvertent encounter with mechanical turbulence.
- [NTSB CHI07LA106](https://openairdocs.org/ntsb/CHI07LA106.md): Browns Vans RV-7A · Gardner, IL · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2007 · N799WB · Substantial damage
  > Engine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrain
- [NTSB CHI07LA104](https://openairdocs.org/ntsb/CHI07LA104.md): Piper PA-22-108 · Ava, MO · Accident · 1 fatal · Limited investigation · Final report · Apr 16, 2007 · N4712Z · Substantial damage
  > The failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.
- [NTSB DFW07CA093](https://openairdocs.org/ntsb/DFW07CA093.md): Dwayne Smith RV-6 · Fort Worth, TX · Accident · No injuries · Data collection · Final report · Apr 15, 2007 · N725ES · Substantial damage
  > The loss of engine power during cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI07FA102](https://openairdocs.org/ntsb/CHI07FA102.md): Piper PA-28-180 · Viburnum, MO · Accident · 3 fatal · Field investigation · Final report · Apr 14, 2007 · N8969J · Destroyed
  > The pilot's loss of aircraft control during cruise flight in instrument meteorological conditions. Factors contributing to the accident were turbulence and icing conditions.
- [NTSB LAX07LA127](https://openairdocs.org/ntsb/LAX07LA127.md): Boeing 757-200 · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 2007 · N525UA · No damage
  > The flight's encounter with a turbulence event that occurred while the flight attendants were unseated. Contributing to the accident was the apparent conflicting information provided by the flight deck to the flight attendants and the flight attendants'…
- [NTSB LAX07CA125](https://openairdocs.org/ntsb/LAX07CA125.md): Cessna 172M · Stockton, CA · Accident · Minor injuries · Data collection · Final report · Apr 12, 2007 · N9685Q · Substantial damage
  > The loss of engine power due to fuel exhaustion resulting from the pilot's inaccurate fuel consumption calculations and failure to refuel while en route.
- [NTSB ATL07CA074](https://openairdocs.org/ntsb/ATL07CA074.md): Piper PA-28R-201 · Waynesboro, GA · Accident · No injuries · Data collection · Final report · Apr 12, 2007 · N47944 · Substantial damage
  > Company maintenance personnel’s improper installation of an unapproved oil quick drain plug which resulted in oil exhaustion and subsequent loss of engine power during cruise flight.
- [NTSB MIA07LA073](https://openairdocs.org/ntsb/MIA07LA073.md): Piper PA-46-310P · Bird Cay, Bahamas · Accident · 2 fatal · Limited investigation · Final report · Apr 10, 2007 · N444JH · Destroyed
  > The pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.
- [NTSB DEN07LA082](https://openairdocs.org/ntsb/DEN07LA082.md): Cirrus SR22 · Luna, NM · Accident · No injuries · Limited investigation · Final report · Apr 9, 2007 · N953CD · Substantial damage
  > the pilot's failure to activate the pitot heat while flying in the clouds and visible moisture, resulting in pitot tube contamination and the subsequent loss of air data for the primary flight display. Contributing to the accident was the icing conditions,…
- [NTSB LAX07LA122](https://openairdocs.org/ntsb/LAX07LA122.md): Scottish Bulldog 120 · So Lake Tahoe, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 8, 2007 · N706X · Substantial damage
  > The pilot's failure to maintain clearance from objects and the mountainous terrain.
- [NTSB CHI07FA107](https://openairdocs.org/ntsb/CHI07FA107.md): Canadair CL-600-2B19 · Lake Michigan, MI · Accident · No injuries · Field investigation · Final report · Apr 8, 2007 · N77181 · Substantial damage
  > In-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…
- [NTSB MIA07LA072](https://openairdocs.org/ntsb/MIA07LA072.md): American AA-1A · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 2007 · N8FA · Substantial damage
  > The pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.
- [NTSB MIA07LA071](https://openairdocs.org/ntsb/MIA07LA071.md): Cessna 152 · Canal Point, FL · Accident · No injuries · Limited investigation · Final report · Apr 7, 2007 · N46913 · Substantial damage
  > The pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.
- [NTSB ATL07CA068](https://openairdocs.org/ntsb/ATL07CA068.md): Beech D50E · Decatur, AL · Accident · No injuries · Data collection · Final report · Apr 6, 2007 · N107WB · Substantial damage
  > The pilot's improper fuel management resulting in failure of both engines due to fuel starvation.
- [NTSB NYC07FA091](https://openairdocs.org/ntsb/NYC07FA091.md): Piper PA-30 · Trappe, MD · Accident · 3 fatal · Field investigation · Final report · Apr 4, 2007 · N555EM · Destroyed
  > The pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.
- [NTSB ATL07CA070](https://openairdocs.org/ntsb/ATL07CA070.md): Cessna 152 · Hinesville, GA · Accident · No injuries · Data collection · Final report · Apr 4, 2007 · N89193 · Substantial damage
  > The pilots improper preflight planning with resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ATL07LA067](https://openairdocs.org/ntsb/ATL07LA067.md): Piper PA28-181 · New Tazewell, TN · Accident · 1 fatal · Limited investigation · Final report · Apr 2, 2007 · N30465 · Substantial damage
  > The pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.
- [NTSB ANC07LA027](https://openairdocs.org/ntsb/ANC07LA027.md): Carris Avid Aircraft · Delray, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 2007 · N9174D · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…
- [NTSB ENG07IA018](https://openairdocs.org/ntsb/ENG07IA018.md): Learjet · Palm Springs, CA · Incident · No injuries · Incident investigation · Final report · Mar 31, 2007 · N244FX · Minor damage
  > The fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…
- [NTSB ATL07LA066](https://openairdocs.org/ntsb/ATL07LA066.md): Szybowcowy Zaklad Do SZD-36A · Sylacauga, AL · Accident · 1 fatal · Limited investigation · Final report · Mar 31, 2007 · N6SZ · Substantial damage
  > The pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.
- [NTSB ANC07LA026](https://openairdocs.org/ntsb/ANC07LA026.md): Cessna 175 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Mar 31, 2007 · N8092T · Substantial damage
  > The loss of engine power during cruise due to the separation of an engine piston, which resulted in a forced landing in a swamp and a collision with trees.
- [NTSB SEA07CA086](https://openairdocs.org/ntsb/SEA07CA086.md): Piper PA-22 · Enumclaw, WA · Accident · No injuries · Data collection · Final report · Mar 30, 2007 · N968A · Substantial damage
  > The pilot's failure to apply carburetor heat during cruise flight. Factors include ambient weather conditions that were conducive to carburetor icing, and soft, muddy terrain at the location where the pilot attempted the power-off forced landing.
- [NTSB DFW07TA089](https://openairdocs.org/ntsb/DFW07TA089.md): Piper PA-18 · Sweetwater, TX · Accident · Minor injuries · Final report · Mar 29, 2007 · N744 · Substantial damage
  > The loss of engine power due to the failure of the throttle lever/linkage. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL07LA065](https://openairdocs.org/ntsb/ATL07LA065.md): Beech BE-58 · Woolsey, GA · Accident · No injuries · Limited investigation · Final report · Mar 29, 2007 · N1MQ · Substantial damage
  > In-flight fire of the right wing for undetermined reasons.
- [NTSB LAX07IA115](https://openairdocs.org/ntsb/LAX07IA115.md): Eurocopter AS 350 BA · Kahului, HI · Incident · No injuries · Incident investigation · Final report · Mar 28, 2007 · N4010K · Minor damage
  > The loss of tail rotor control due to wear damage to the pitch control input rod that resulted ultimately in the fatigue failure of the upper support yoke arm. Contributing factors were the improper maintenance inspection of the expansion pin assembly and the…
- [NTSB CHI07LA096](https://openairdocs.org/ntsb/CHI07LA096.md): Alon A2 · Ravenna, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 2007 · N992DC · Substantial damage
  > The pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.
- [NTSB DEN07FA079](https://openairdocs.org/ntsb/DEN07FA079.md): Robinson R44 II · Ponte Vedra Bch, FL · Accident · 2 fatal · Field investigation · Final report · Mar 27, 2007 · N744SH · Destroyed
  > the mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…
- [NTSB MIA07IA067](https://openairdocs.org/ntsb/MIA07IA067.md): Cessna 172S · Moore Haven, FL · Incident · No injuries · Incident investigation · Final report · Mar 26, 2007 · N57FH · No damage
  > A loss of engine power due to foreign object damage to the oil pump.
- [NTSB ATL07LA064](https://openairdocs.org/ntsb/ATL07LA064.md): Beech BE-90 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · Mar 25, 2007 · N90NM · Substantial damage
  > A total failure of the electrical system for undetermined reasons, which resulted in the pilot's inability to ensure that the landing gear was down and locked.
- [NTSB SEA07LA082](https://openairdocs.org/ntsb/SEA07LA082.md): Hackney Glasair TD · Arvin, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 2007 · N229DH · Substantial damage
  > Loss of engine power resulting from fuel exhaustion due to the pilot's failure to refuel the aircraft en route. A contributing factor to this accident was rough/uneven terrain at the forced landing site.
- [NTSB SEA07CA083](https://openairdocs.org/ntsb/SEA07CA083.md): Duffy/Wagner Vans RV-4 · Ogden, UT · Accident · No injuries · Data collection · Final report · Mar 24, 2007 · N423DW · Substantial damage
  > The pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC07LA085](https://openairdocs.org/ntsb/NYC07LA085.md): Piper PA-28-140 · Catherine Twp., PA · Accident · No injuries · Limited investigation · Final report · Mar 24, 2007 · N56124 · Substantial damage
  > The pilot's improper use of carburetor heat. Contributing to the accident were the weather conditions conducive to the formation of carburetor ice.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=121

## 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=120

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.