# 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 113 of 718 · 35,885 cases

## Cases, newest first

- [NTSB LAX08CA166](https://openairdocs.org/ntsb/LAX08CA166.md): Piper PA-38-112 · Kykotsmovi, AZ · Accident · No injuries · Data collection · Final report · Jun 7, 2008 · N9276T · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight planning and failure to ensure that adequate fuel was onboard to complete the flight.
- [NTSB LAX08CA164](https://openairdocs.org/ntsb/LAX08CA164.md): Cessna 172 · Santa Rosa, CA · Accident · Minor injuries · Data collection · Final report · Jun 6, 2008 · N6494E · Substantial damage
  > The pilot's improper in-flight decision making and inadequate fuel consumption calculations that resulted in fuel exhaustion.
- [NTSB CHI08LA158](https://openairdocs.org/ntsb/CHI08LA158.md): Maggs Lancair 4P · Alhambra, IL · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 2008 · N241DM · Substantial damage
  > The pilot's decision to continue the flight into an area of known thunderstorm activity and the in-flight structural failure of the airplane.
- [NTSB DEN08FA100](https://openairdocs.org/ntsb/DEN08FA100.md): Extra Flugzeugbau EA 300/L · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Jun 5, 2008 · N12XT · Destroyed
  > The pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…
- [NTSB CHI08CA157](https://openairdocs.org/ntsb/CHI08CA157.md): Cessna 172C · Nortonville, ND · Accident · Minor injuries · Data collection · Final report · Jun 4, 2008 · N1437Y · Substantial damage
  > The pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.
- [NTSB NYC08LA199](https://openairdocs.org/ntsb/NYC08LA199.md): Cessna 172H · Brockport, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2008 · N3910R · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the flight instructor's inadequate preflight planning.
- [NTSB MIA08LA149](https://openairdocs.org/ntsb/MIA08LA149.md): Aero Commander 500-B · Charlotte Amali · Accident · No injuries · Limited investigation · Final report · Jun 1, 2008 · N411FS · Substantial damage
  > The failure of maintenance personnel to identify inadequate clamping of the aluminum line during inspection, and the undetected fatigue cracking of the line which resulted in the loss of hydraulic fluid.
- [NTSB CHI08LA151](https://openairdocs.org/ntsb/CHI08LA151.md): Bell 47D1 · Carrollton, OH · Accident · No injuries · Limited investigation · Final report · Jun 1, 2008 · N74898 · Substantial damage
  > The airframe vibration for an undetermined reason.
- [NTSB CHI08LA144](https://openairdocs.org/ntsb/CHI08LA144.md): Cessna 208B · Greensburg, IN · Accident · No injuries · Limited investigation · Final report · Jun 1, 2008 · N102VE · Substantial damage
  > The total loss of engine power during the en route climb due to a compressor turbine failure as a result of blade creep. Also causal was the inadequate maintenance performed by the airplane's owner.
- [NTSB NYC08LA201](https://openairdocs.org/ntsb/NYC08LA201.md): Piper PA-18-135 · Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · May 31, 2008 · N802DA · Substantial damage
  > A loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…
- [NTSB DFW08CA160](https://openairdocs.org/ntsb/DFW08CA160.md): Piper PA-28-235 · Amistad, NM · Accident · Minor injuries · Data collection · Final report · May 30, 2008 · N9122W · Substantial damage
  > Fuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.
- [NTSB CHI08FA146](https://openairdocs.org/ntsb/CHI08FA146.md): Piper PA28 · Hillsboro, OH · Accident · 2 fatal · Field investigation · Final report · May 30, 2008 · N9376W · Substantial damage
  > The pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…
- [NTSB CHI08CA145](https://openairdocs.org/ntsb/CHI08CA145.md): Cessna 150 · New Berlin, WI · Accident · No injuries · Data collection · Final report · May 30, 2008 · N3130V · Substantial damage
  > The loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.
- [NTSB DCA08FA064](https://openairdocs.org/ntsb/DCA08FA064.md): Embraer 140 · Dallas, TX · Accident · Serious injuries · Field investigation · Final report · May 27, 2008 · N816AE · No damage
  > The flight's inadvertent encounter with turbulence.
- [NTSB SEA08LA139](https://openairdocs.org/ntsb/SEA08LA139.md): Cessna 182D · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · May 25, 2008 · N8855X · Substantial damage
  > A loss of engine power due to fuel exhaustion caused by a missing fuel tank cap that allowed the fuel to be siphoned out. Also causal was the pilot's inadequate preflight inspection at the last airport.
- [NTSB SEA08LA137](https://openairdocs.org/ntsb/SEA08LA137.md): Nolan RV-4 · Tolani Lake, AZ · Accident · 1 fatal · Limited investigation · Final report · May 25, 2008 · N6290F · Substantial damage
  > An in-flight collision with terrain for undetermined reasons.
- [NTSB DFW08FA153](https://openairdocs.org/ntsb/DFW08FA153.md): Cessna 310Q · Steamboat, CO · Accident · 2 fatal · Field investigation · Final report · May 25, 2008 · N8187Q · Destroyed
  > The pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.
- [NTSB NYC08CA192](https://openairdocs.org/ntsb/NYC08CA192.md): Piper PA-32-260 · Millinocket, ME · Accident · Minor injuries · Data collection · Final report · May 24, 2008 · N4823S · Substantial damage
  > The pilot’s failure to properly monitor fuel consumption during the flight.
- [NTSB LAX08LA154](https://openairdocs.org/ntsb/LAX08LA154.md): Maule MX-7-235 · Boulder, MT · Accident · 1 fatal · Limited investigation · Final report · May 23, 2008 · N5657Y · Substantial damage
  > The pilot's decision to continue flight at low altitude in instrument weather conditions and his failure to maintain clearance from a power line. Contributing to the accident were low cloud and visibility conditions.
- [NTSB LAX08LA153](https://openairdocs.org/ntsb/LAX08LA153.md): Cessna P210N · Peach Springs, AZ · Accident · No injuries · Limited investigation · Final report · May 23, 2008 · N4753K · Substantial damage
  > A loss of engine power due to induced catastrophic internal failure of the engine as a result of the displacement and rotation of the number 2 main bearing that resulted in a fatigue fracture of the crankshaft.
- [NTSB DCA08FA062](https://openairdocs.org/ntsb/DCA08FA062.md): Mcdonnell Douglas DC10 · Pacific Ocean · Accident · Serious injuries · Field investigation · Final report · May 19, 2008 · N720AX · No damage
  > An inadvertent in-flight encounter with unforecasted clear air turbulence
- [NTSB NYC08FA184](https://openairdocs.org/ntsb/NYC08FA184.md): Cessna 337A · West Creek, NJ · Accident · 2 fatal · Field investigation · Final report · May 17, 2008 · N5382S · Substantial damage
  > The pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…
- [NTSB LAX08LA142](https://openairdocs.org/ntsb/LAX08LA142.md): Ercoupe 415-C · Penngrove, CA · Accident · No injuries · Limited investigation · Final report · May 15, 2008 · N99180 · Substantial damage
  > The loss of engine power resulting from frayed magneto "P" leads, which shorted out and killed the ignition system. Contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB NYC08FA180](https://openairdocs.org/ntsb/NYC08FA180.md): Piper PA-32-260 · Cruso, NC · Accident · 2 fatal · Field investigation · Final report · May 12, 2008 · N64FP · Destroyed
  > The pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.
- [NTSB CHI08FA133](https://openairdocs.org/ntsb/CHI08FA133.md): Beech V35 · Bristol, OH · Accident · 2 fatal · Field investigation · Final report · May 12, 2008 · N7947M · Destroyed
  > The loss of control during cruise flight in instrument conditions due to spatial disorientation.
- [NTSB CHI08FA128](https://openairdocs.org/ntsb/CHI08FA128.md): Eurocopter Deutschland EC 135 T2+ · La Crosse, WI · Accident · 3 fatal · Field investigation · Final report · May 11, 2008 · N135UW · Destroyed
  > The pilot’s failure to maintain clearance from trees along the top of a ridgeline due to inadequate preflight planning, insufficient altitude, and the lack of a helicopter terrain awareness and warning system. Member Sumwalt did not approve this brief and…
- [NTSB DFW08LA135](https://openairdocs.org/ntsb/DFW08LA135.md): Bailey Varieze · Phillipsburg, KS · Accident · Serious injuries · Limited investigation · Final report · May 10, 2008 · N6553C · Substantial damage
  > The pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.
- [NTSB CHI08CA131](https://openairdocs.org/ntsb/CHI08CA131.md): Kuntz Kuntz 2000 GTS EFI · Dickinson, ND · Accident · Minor injuries · Data collection · Final report · May 10, 2008 · N610RD · Substantial damage
  > The pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…
- [NTSB NYC08LA176](https://openairdocs.org/ntsb/NYC08LA176.md): Desalvatore Al Lancair IV-P · Snow Hill, NC · Accident · 2 fatal · Limited investigation · Final report · May 8, 2008 · N101BX · Destroyed
  > An inadvertent encounter with icing conditions, resulting in a loss of aircraft control. Contributing to the accident was the pilot's inadequate preflight and in-flight decision making.
- [NTSB DFW08LA133](https://openairdocs.org/ntsb/DFW08LA133.md): Piper PA-32R-300 · Emporia, KS · Accident · Minor injuries · Limited investigation · Final report · May 8, 2008 · N385WR · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.
- [NTSB DFW08FA131](https://openairdocs.org/ntsb/DFW08FA131.md): Cessna 182 · Black Hawk, CO · Accident · 1 fatal · Field investigation · Final report · May 8, 2008 · N8553S · Substantial damage
  > The loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.
- [NTSB LAX08LA127](https://openairdocs.org/ntsb/LAX08LA127.md): Cessna 182H · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · May 5, 2008 · N6320B · Substantial damage
  > A loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.
- [NTSB DEN08LA085](https://openairdocs.org/ntsb/DEN08LA085.md): North American SNJ-5 · Wolcott, CO · Accident · Minor injuries · Limited investigation · Final report · May 5, 2008 · N12KY · Substantial damage
  > The failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB DFW08LA130](https://openairdocs.org/ntsb/DFW08LA130.md): Piper PA-22-108 · Opelousas, LA · Accident · Minor injuries · Limited investigation · Final report · May 3, 2008 · N4515Z · Substantial damage
  > Loss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.
- [NTSB LAX08LA128](https://openairdocs.org/ntsb/LAX08LA128.md): Cessna 175A · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · May 2, 2008 · N7059E · Substantial damage
  > The partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.
- [NTSB DFW08CA149](https://openairdocs.org/ntsb/DFW08CA149.md): Bellanca 14-13-3A · San Marcos, TX · Accident · No injuries · Data collection · Final report · May 2, 2008 · N1255R · Substantial damage
  > The failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.
- [NTSB NYC08LA172](https://openairdocs.org/ntsb/NYC08LA172.md): Piper PA-28-160 · Richmond Hill, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2008 · N5426W · Substantial damage
  > The loss of engine power during cruise flight due to fuel exhaustion, and the pilot's inadequate preflight inspection.
- [NTSB SEA08LA114](https://openairdocs.org/ntsb/SEA08LA114.md): Canup Titan Tornado S · Council, ID · Accident · No injuries · Limited investigation · Final report · Apr 26, 2008 · N706BC · Substantial damage
  > The failure of the tip of the wood propeller due to damage caused by a foreign object.
- [NTSB DFW08FA111](https://openairdocs.org/ntsb/DFW08FA111.md): Cirrus Design SR22 · Hemphill, TX · Accident · 3 fatal · Field investigation · Final report · Apr 22, 2008 · N729SR · Destroyed
  > A loss of control for undetermined reasons.
- [NTSB NYC08LA165](https://openairdocs.org/ntsb/NYC08LA165.md): Dragon Fly GT-500 · Paris, TN · Accident · 1 fatal · Limited investigation · Final report · Apr 21, 2008 · N101GP · Substantial damage
  > A fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.
- [NTSB CHI08LA108](https://openairdocs.org/ntsb/CHI08LA108.md): Cessna 172L · Fairfax, IA · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 2008 · N9832G · Substantial damage
  > Fuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.
- [NTSB NYC08LA164](https://openairdocs.org/ntsb/NYC08LA164.md): Beech G35 · New Smyrna Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 2008 · N4606D · Substantial damage
  > The pilot's inadvertent encounter with turbulence that was not forcast.
- [NTSB CHI08CA112](https://openairdocs.org/ntsb/CHI08CA112.md): Pierson RV-6 · Newark, IL · Accident · No injuries · Data collection · Final report · Apr 20, 2008 · N606JP · Substantial damage
  > The partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…
- [NTSB DFW08LA106](https://openairdocs.org/ntsb/DFW08LA106.md): Tomblingson-Leathers Breezy RLU-1 · Groveton, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 2008 · N3921 · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.
- [NTSB CHI08IA109](https://openairdocs.org/ntsb/CHI08IA109.md): Eclipse EA500 · Pontiac, MI · Incident · No injuries · Incident investigation · Final report · Apr 17, 2008 · N539RM · No damage
  > The inadvertent stalling of the rudder trim actuator motor during flight due to the pilot's unintentional exceedence of the motor's design limit for stalling while accelerating after completing a simulated engine-out maneuver.
- [NTSB LAX08LA107](https://openairdocs.org/ntsb/LAX08LA107.md): Piper PA-30 · Holbrook, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 2008 · N8442Y · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.
- [NTSB ANC08FA053](https://openairdocs.org/ntsb/ANC08FA053.md): Eurocopter AS 350 B2 · Chickaloon, AK · Accident · 4 fatal · Field investigation · Final report · Apr 15, 2008 · N213EH · Substantial damage
  > An in-flight overtorque of the engine-to-transmission driveshaft resulting in disconnection of the main transmission from the engine. The overtorque likely occurred due to an in-flight main rotor blade contact with snow-covered terrain, precluding significant…
- [NTSB NYC08CA161](https://openairdocs.org/ntsb/NYC08CA161.md): Cessna 152K · Okeechobee, FL · Accident · Minor injuries · Data collection · Final report · Apr 14, 2008 · N67334 · Substantial damage
  > The loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.
- [NTSB LAX08LA098](https://openairdocs.org/ntsb/LAX08LA098.md): North American T-28C · Kingman, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2008 · N9022N · Substantial damage
  > A total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.
- [NTSB DEN08LA074](https://openairdocs.org/ntsb/DEN08LA074.md): Grumman American AA-5A · Beaumont, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 2008 · N9764U · Substantial damage
  > The pilot's inability to maintain aircraft control in cruise flight and encounter with a thunderstorm. Contributing to the accident was an inadvertent stall/spin.

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

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

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