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

## Cases, newest first

- [NTSB NYC06LA223](https://openairdocs.org/ntsb/NYC06LA223.md): Boeing 737-700 · Hastings, NE · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2006 · N793SA · No damage
  > The airplane's in flight encounter with thunderstorm related turbulence.
- [NTSB ANC06LA140](https://openairdocs.org/ntsb/ANC06LA140.md): Piper PA-12 · Soldotna, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 2006 · N593V · Substantial damage
  > The pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…
- [NTSB LAX06CA294](https://openairdocs.org/ntsb/LAX06CA294.md): Grumman American Avn. AA-5 · Watsonville, CA · Accident · No injuries · Data collection · Final report · Sep 16, 2006 · N6532L · Destroyed
  > A loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.
- [NTSB ANC06FA131](https://openairdocs.org/ntsb/ANC06FA131.md): de Havilland DHC-2 · Skwentna, AK · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2006 · N836KA · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. A factor associated with the accident was a low cloud ceiling.
- [NTSB DEN06FA132](https://openairdocs.org/ntsb/DEN06FA132.md): Beech 35-C33 · Telluride, CO · Accident · 4 fatal · Field investigation · Final report · Sep 15, 2006 · N5893J · Destroyed
  > The pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.
- [NTSB DEN06FA131](https://openairdocs.org/ntsb/DEN06FA131.md): Cirrus Design SR20 · Maybell, CO · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2006 · N787SL · Destroyed
  > The pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…
- [NTSB CHI06CA267](https://openairdocs.org/ntsb/CHI06CA267.md): Columbia 350 · Bloomington, IN · Accident · No injuries · Data collection · Final report · Sep 15, 2006 · N6500V · Substantial damage
  > The pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.
- [NTSB CHI06LA260](https://openairdocs.org/ntsb/CHI06LA260.md): Endless Skies L164 · Durand, MI · Accident · No injuries · Limited investigation · Final report · Sep 11, 2006 · N2627J · Substantial damage
  > The kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.
- [NTSB NYC06LA219](https://openairdocs.org/ntsb/NYC06LA219.md): Beech F33A · South Windsor, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 2006 · N3708B · Substantial damage
  > A loosening of the fuel injector lines from the fuel manifold valve, which resulted in a partial loss of engine power.
- [NTSB LAX06LA288](https://openairdocs.org/ntsb/LAX06LA288.md): Hughes 369D · Somis, CA · Accident · 2 fatal · Limited investigation · Final report · Sep 6, 2006 · N812CE · Substantial damage
  > The pilot's inadequate visual lookout, which resulted in a collision with wires.
- [NTSB CHI06CA276](https://openairdocs.org/ntsb/CHI06CA276.md): Cessna T206H · Cedar Rapids, IA · Accident · No injuries · Data collection · Final report · Sep 6, 2006 · N2430A · Substantial damage
  > An in-flight collision with a bird during climb to cruise altitude.
- [NTSB CHI06FA256](https://openairdocs.org/ntsb/CHI06FA256.md): Mooney M20J · Smithville, OH · Accident · 1 fatal · Field investigation · Final report · Sep 5, 2006 · N1172U · Substantial damage
  > The altitude/ clearance not maintained by the pilot during cruise flight.
- [NTSB NYC06FA215](https://openairdocs.org/ntsb/NYC06FA215.md): Cessna 150G · Penhook, VA · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2006 · N2932J · Destroyed
  > The pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…
- [NTSB MIA06LA136](https://openairdocs.org/ntsb/MIA06LA136.md): Noakes B J Corby CJ-1 · Edgewater, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 2006 · N79860 · Substantial damage
  > Partial loss of engine power for undetermined reasons.
- [NTSB ATL06CA125](https://openairdocs.org/ntsb/ATL06CA125.md): Brown Floyd L Christen Eagle II · Topsail Beach, NC · Accident · No injuries · Data collection · Final report · Sep 3, 2006 · N225FL · Substantial damage
  > The in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.
- [NTSB NYC06LA214](https://openairdocs.org/ntsb/NYC06LA214.md): Cessna 150K · Shelby Gap, KY · Accident · 1 fatal · Limited investigation · Final report · Sep 2, 2006 · N6401G · Destroyed
  > The pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.
- [NTSB DEN06MA119](https://openairdocs.org/ntsb/DEN06MA119.md): Mitsubishi MU-2B-35 · Argyle, FL · Accident · 1 fatal · Major investigation · Final report · Sep 1, 2006 · N6569L · Destroyed
  > the pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…
- [NTSB ANC06LA129](https://openairdocs.org/ntsb/ANC06LA129.md): Piper J5A · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 2006 · N35395 · Substantial damage
  > The pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.
- [NTSB LAX06FA277](https://openairdocs.org/ntsb/LAX06FA277.md): Raytheon Hawker 800XP · Smith, NV · Accident · Minor injuries · Field investigation · Final report · Aug 28, 2006 · N879QS · 2 aircraft · Substantial damage
  > The failure of the glider pilot to utilize his transponder and the high closure rate of the two aircraft, which limited each pilot's opportunity to see and avoid the other aircraft.
- [NTSB DFW06CA204](https://openairdocs.org/ntsb/DFW06CA204.md): Ron Burleigh Air Cam · Post, TX · Accident · No injuries · Data collection · Final report · Aug 28, 2006 · N9254F · Substantial damage
  > The pilot's failure to maintain clearance with power lines while making a precautionary landing.
- [NTSB CHI06FA245](https://openairdocs.org/ntsb/CHI06FA245.md): Cirrus SR22 · Indianapolis, IN · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2006 · N91MB · Destroyed
  > The pilot's failure to maintain sufficient airspeed, which resulted in a stall and subsequent spin. Contributing to the accident were the pilot's inadequate preflight planning, the overloaded condition of the airplane, and the CG aft of the CG limit.
- [NTSB LAX06LA280](https://openairdocs.org/ntsb/LAX06LA280.md): Sikorsky S-55 · Paramount, CA · Accident · No injuries · Limited investigation · Final report · Aug 26, 2006 · N111VA · Substantial damage
  > the loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.
- [NTSB NYC06MA208](https://openairdocs.org/ntsb/NYC06MA208.md): Mitsubishi MU-2B-40 · Bunnell, FL · Accident · 2 fatal · Major investigation · Final report · Aug 25, 2006 · N171MA · Destroyed
  > The pilot's inadvertent encounter with thunderstorms.
- [NTSB CHI06FA275](https://openairdocs.org/ntsb/CHI06FA275.md): Piper PA-28-140 · Kulm, ND · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2006 · N9714W · Destroyed
  > The non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.
- [NTSB CHI06LA243](https://openairdocs.org/ntsb/CHI06LA243.md): Frick Questair Q20 · Big Rapids, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 23, 2006 · N2QV · Substantial damage
  > The pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.
- [NTSB SEA06LA167](https://openairdocs.org/ntsb/SEA06LA167.md): Kinnson Lancair IV-P Turbine · Helena, MT · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 2006 · N514PT · Substantial damage
  > The total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.
- [NTSB ANC06GA121](https://openairdocs.org/ntsb/ANC06GA121.md): Eurocopter France AS350 B2 · Nuiqsut, AK · Accident · 1 fatal · Final report · Aug 22, 2006 · C-FYUN · Destroyed
  > The pilot's failure to maintain clearance from the sling load during cruise flight, which resulted in the load becoming entangled in the tail rotor, and an in-flight loss of control.
- [NTSB ATL06LA134](https://openairdocs.org/ntsb/ATL06LA134.md): Cirrus Design SR22-GTS · Mc Rae, GA · Accident · No injuries · Limited investigation · Final report · Aug 21, 2006 · N518SR · Substantial damage
  > The pilot's failure to use supplemental oxygen where required, and his failure to maintain sufficient airspeed to avoid a stall.
- [NTSB NYC06LA204](https://openairdocs.org/ntsb/NYC06LA204.md): Butterhof Ginny B · Shiloh, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 2006 · N349E · Substantial damage
  > A loss of engine power due to overheating, for undetermined reasons.
- [NTSB DFW06LA199](https://openairdocs.org/ntsb/DFW06LA199.md): Piper PA-28-161 · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 2006 · N82078 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06GA241](https://openairdocs.org/ntsb/CHI06GA241.md): McDonnell Douglas Helicopters 369E · Columbus, OH · Accident · No injuries · Final report · Aug 19, 2006 · N554CP · Substantial damage
  > The uncontained engine failure due to the fatigue failure of the gas producer turbine tie bolt.
- [NTSB ANC06LA119](https://openairdocs.org/ntsb/ANC06LA119.md): Cessna U206G · Whittier, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 2006 · N4975U · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with terrain while maneuvering to reverse direction in a pass. A factor contributing to the accident was clouds in the pass.
- [NTSB ATL06LA121](https://openairdocs.org/ntsb/ATL06LA121.md): Kirkpatrick Rans S-6 · Roseboro, NC · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2006 · N227AL · Substantial damage
  > The pilot's failure to maintain ground clearance while maneuvering for a forced landing following loss of engine power.
- [NTSB DEN06FA114](https://openairdocs.org/ntsb/DEN06FA114.md): Cirrus Design SR20 · Kremmling, CO · Accident · Serious injuries · Field investigation · Final report · Aug 16, 2006 · N8127J · Destroyed
  > The pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…
- [NTSB ATL06CA120](https://openairdocs.org/ntsb/ATL06CA120.md): Cessna 150L · Bunn, NC · Accident · No injuries · Data collection · Final report · Aug 13, 2006 · N6882G · Substantial damage
  > The pilot's improper preflight inspection resulting in a total loss of engine power due to water ingestion, a forced landing to none suitable soft ground, and a nose over.
- [NTSB DEN06LA112](https://openairdocs.org/ntsb/DEN06LA112.md): Piper PA-24-260 · Harrisburg, NE · Accident · No injuries · Limited investigation · Final report · Aug 10, 2006 · N8741P · Substantial damage
  > The loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL06LA119](https://openairdocs.org/ntsb/ATL06LA119.md): Ayres S2R · Doerun, GA · Accident · No injuries · Limited investigation · Final report · Aug 10, 2006 · N61224 · Destroyed
  > The loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.
- [NTSB ANC06CA122](https://openairdocs.org/ntsb/ANC06CA122.md): Bell 206B · Orlando, FL · Accident · No injuries · Data collection · Final report · Aug 9, 2006 · N121RH · Substantial damage
  > The pilot's failure to refuel the helicopter prior to the accident flight, which resulted in a loss of engine power during cruise flight, and a hard landing.
- [NTSB ANC06LA112](https://openairdocs.org/ntsb/ANC06LA112.md): Beech BE-18 · Culebra, PR · Accident · No injuries · Limited investigation · Final report · Aug 8, 2006 · N498BH · Substantial damage
  > A loss of engine power due to fuel starvation/exhaustion in all engines for an undetermined reason during cruise flight, which resulted in a forced landing and ditching.
- [NTSB NYC06CA195](https://openairdocs.org/ntsb/NYC06CA195.md): Champion 7KCAB · Hyannis, MA · Accident · Minor injuries · Data collection · Final report · Aug 5, 2006 · N7533F · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CHI06CA216](https://openairdocs.org/ntsb/CHI06CA216.md): Piper PA-25 · Minot, ND · Accident · No injuries · Data collection · Final report · Aug 5, 2006 · N7587Z · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.
- [NTSB LAX06FA256](https://openairdocs.org/ntsb/LAX06FA256.md): Cessna 182P · Whitethorn, CA · Accident · 2 fatal · Field investigation · Final report · Aug 4, 2006 · N9904E · Substantial damage
  > The pilot's loss of situational awareness with regard to the airplane's proximity to mountainous terrain, and her failure to maintain an adequate terrain clearance altitude or flight path, which resulted in an in-flight collision with the terrain.
- [NTSB SEA06TA153](https://openairdocs.org/ntsb/SEA06TA153.md): Bell 206L-1 · Busby, MT · Accident · No injuries · Final report · Aug 3, 2006 · N5746N · Substantial damage
  > The improper overhaul of the turbine assembly by maintenance personnel, which resulted in failure of the turbine and a total loss of engine power. A contributing factor was the pilot's misjudgment of the landing flare at the termination of the autorotation.
- [NTSB DEN06FA109](https://openairdocs.org/ntsb/DEN06FA109.md): Piper PA-24-180 · Mosca, CO · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2006 · N5416P · Destroyed
  > a non-mechanical partial loss of engine power due to carburetor ice, and the pilot's failure to maintain clearance from terrain. Contributing factors in this accident were weather conditions conducive to carburetor icing and the pilot inadvertently flying…
- [NTSB NYC06CA188](https://openairdocs.org/ntsb/NYC06CA188.md): Cessna 120 · Ashland, KY · Accident · No injuries · Data collection · Final report · Jul 30, 2006 · N1981V · Substantial damage
  > The pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.
- [NTSB CHI06FA224](https://openairdocs.org/ntsb/CHI06FA224.md): American Legend AL11C · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Jul 30, 2006 · N848LC · Substantial damage
  > The failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…
- [NTSB LAX06LA249](https://openairdocs.org/ntsb/LAX06LA249.md): Beech V35B · Independence, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2006 · N346D · Substantial damage
  > the pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.
- [NTSB LAX06LA247](https://openairdocs.org/ntsb/LAX06LA247.md): Robinson R44 · Flagstaff, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2006 · N74780 · Substantial damage
  > the pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.
- [NTSB LAX06LA246](https://openairdocs.org/ntsb/LAX06LA246.md): Cessna 177B · Kalaupapa, HI · Accident · 2 fatal · Limited investigation · Final report · Jul 28, 2006 · N30652 · Destroyed
  > Loss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.
- [NTSB DFW06FA193](https://openairdocs.org/ntsb/DFW06FA193.md): Mooney M20J · Newellton, LA · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2006 · N577RS · Destroyed
  > The pilot's continued flight into adverse weather conditions. Contributing factors were the prevailing thunderstorms, the dark night conditions, and Air Traffic Control's failure to issue hazardous weather information to the pilot.

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

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

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