# NTSB investigations: Maneuvering

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 101 of 378 · 18,851 cases

## Cases, newest first

- [NTSB FTW02LA109](https://openairdocs.org/ntsb/FTW02LA109.md): Cessna 188 · Forrest City, AR · Accident · No injuries · Limited investigation · Final report · Mar 24, 2002 · N9454J · Substantial damage
  > the pilot's failure to maintain clearance with a light pole and power lines during an aerial application flight.
- [NTSB CHI02LA095](https://openairdocs.org/ntsb/CHI02LA095.md): Schweizer G-164A · Cascade, IA · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2002 · N9763 · Substantial damage
  > The pilot's inadequate preflight planning/preparation and his failure to maintain clearance with the wire. A factor associated with the accident was the wire that the airplane contacted.
- [NTSB LAX02FA110](https://openairdocs.org/ntsb/LAX02FA110.md): Pilatus UV-20A · Marana, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 15, 2002 · N23253 · 2 aircraft · Destroyed
  > the failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.
- [NTSB SEA02GA053](https://openairdocs.org/ntsb/SEA02GA053.md): Piper PA-31 · Atlanta, ID · Accident · 3 fatal · Final report · Mar 12, 2002 · N2336V · Substantial damage
  > The pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.
- [NTSB FTW02LA092](https://openairdocs.org/ntsb/FTW02LA092.md): Schleicher AS-W19 · Moriarty, NM · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 2002 · N333US · Substantial damage
  > The pilot's attempt to perform a turn upwind at a altitude too low to complete the turn. A factor was the turbulance.
- [NTSB DEN02FA030](https://openairdocs.org/ntsb/DEN02FA030.md): Mooney M20C · Glenwood Sprngs, CO · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2002 · N1323D · Destroyed
  > the pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.
- [NTSB ATL02LA061](https://openairdocs.org/ntsb/ATL02LA061.md): Moore Sammie M-Breezy · Pell City, AL · Accident · 1 fatal · Limited investigation · Final report · Mar 8, 2002 · N9167C · Destroyed
  > The pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.
- [NTSB NYC02LA067](https://openairdocs.org/ntsb/NYC02LA067.md): Brantly Helicopter B-2 · Grove City, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 2002 · N2128U · Substantial damage
  > The pilot's inadequate compensation for wind conditions which resulted in an in-flight collision with trees. A factor related to the accident was the gusting wind conditions.
- [NTSB ATL02FA059](https://openairdocs.org/ntsb/ATL02FA059.md): Piper PA-28-151 · Macon, GA · Accident · 2 fatal · Field investigation · Final report · Mar 4, 2002 · N41340 · Substantial damage
  > The pilot's failure to maintain clearance from a tree while maneuvering after takeoff.
- [NTSB FTW02LA086](https://openairdocs.org/ntsb/FTW02LA086.md): Air Tractor AT-502B · Extension, LA · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 2002 · N6073U · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.
- [NTSB LAX02LA096](https://openairdocs.org/ntsb/LAX02LA096.md): Rotorway Rotorway Exec 90 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Feb 25, 2002 · N9876D · Substantial damage
  > The student's inadvertent over control of the throttle mechanism, which resulted in the bending of the throttle mechanical stop and binding the linkage in the idle position. Also causal was the CFI's inadequate supervision. A factor in the accident was the…
- [NTSB LAX02LA093](https://openairdocs.org/ntsb/LAX02LA093.md): Saumure Exec 162F · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Feb 24, 2002 · N162KS · Substantial damage
  > The pilot's failure to maintain adequate airspeed and main rotor rpm while performing a low altitude maneuver, which resulted in a loss of translational lift, a hard landing, and rollover on downhill terrain.
- [NTSB ANC02LA017](https://openairdocs.org/ntsb/ANC02LA017.md): Robinson R-22 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Feb 23, 2002 · N8353M · Substantial damage
  > The pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.
- [NTSB LAX02FA088](https://openairdocs.org/ntsb/LAX02FA088.md): Robinson R22 Beta · Glendora, CA · Accident · No injuries · Field investigation · Final report · Feb 21, 2002 · N8045K · Substantial damage
  > The student's failure to maintain adequate main rotor rpm, and the flight instructor's inadequate supervision. Contributing factors were the high helicopter gross weight and density altitude, and the descending mountainous terrain.
- [NTSB ATL02LA050](https://openairdocs.org/ntsb/ATL02LA050.md): Cessna 152 · Blowing Rock, NC · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 2002 · N757AS · Substantial damage
  > The pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.
- [NTSB SEA02LA042](https://openairdocs.org/ntsb/SEA02LA042.md): Cessna 172 · Concrete, WA · Accident · No injuries · Limited investigation · Final report · Feb 20, 2002 · C-FISS · Substantial damage
  > The pilot's failure to maintain adequate clearance/altitude while reversing course and turning towards rising, tree covered terrain in downdraft conditions. Contributing factors were trees, rising terrain, downdrafts and the pilot's in-flight decision to turn…
- [NTSB FTW02LA081](https://openairdocs.org/ntsb/FTW02LA081.md): Cessna 177 · Pond Creek, OK · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2002 · N3402T · Substantial damage
  > The pilot's failure to maintain altitude due to falling asleep while performing pipeline patrol activities.
- [NTSB MIA02LA061](https://openairdocs.org/ntsb/MIA02LA061.md): Smith, Ted Aerostar 601P · Belle Glade, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 2002 · N715RM · Substantial damage
  > the pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.
- [NTSB LAX02LA085](https://openairdocs.org/ntsb/LAX02LA085.md): Ellenberger/Werner Glasair I TD · Minden, NV · Accident · 2 fatal · Limited investigation · Final report · Feb 13, 2002 · N777WE · Destroyed
  > the pilot's failure to maintain control of the airplane resulting in the airplane entering a flat spin from which the pilot did not recover.
- [NTSB ATL02LA045](https://openairdocs.org/ntsb/ATL02LA045.md): Cessna 150 · Panama City Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2002 · N10949 · Destroyed
  > The pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.
- [NTSB FTW02LA085](https://openairdocs.org/ntsb/FTW02LA085.md): Quicksilver MXL II Sport · Gatesville, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 2002 · UNREG · Substantial damage
  > The loss of engine power for undertermined reasons.
- [NTSB ATL02LA044](https://openairdocs.org/ntsb/ATL02LA044.md): Hiller UH12E · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 2002 · N103HA · Substantial damage
  > Fatigue cracking in the main rotor hub that resulted in the separation of the main rotor system. A factor was corrosive deposits on the exposed portion of the plate set pin.
- [NTSB SEA02LA039](https://openairdocs.org/ntsb/SEA02LA039.md): Bitton/Sport Flight Talon · Boring, OR · Accident · 1 fatal · Limited investigation · Final report · Feb 10, 2002 · UNREG · Substantial damage
  > Loss of control for undetermined reasons.
- [NTSB FTW02LA078](https://openairdocs.org/ntsb/FTW02LA078.md): Piper PA-18-150 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Feb 7, 2002 · N4013E · Substantial damage
  > the loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ANC02LA013](https://openairdocs.org/ntsb/ANC02LA013.md): Cessna 150 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2002 · N3829J · Substantial damage
  > The pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…
- [NTSB DEN02LA023](https://openairdocs.org/ntsb/DEN02LA023.md): Beech V35B · American Fork, UT · Accident · 1 fatal · Limited investigation · Final report · Jan 28, 2002 · N1176T · Destroyed
  > The pilot's poor judgment in that he intentionally initiated VFR flight into instrument meteorological conditions. Contributing factors were low ceiling and obscuration, and the pilot's lack of recent instrument time.
- [NTSB LAX02LA071](https://openairdocs.org/ntsb/LAX02LA071.md): Richard S. Anderson Rotorway Exec 162F · Willcox, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 2002 · N30545 · Substantial damage
  > The pilot's failure to compensate for a gust condition and to maintain lateral control while hovering due to restricted cyclic control movement, which resulted from an inadequate control location/design.
- [NTSB IAD02LA028](https://openairdocs.org/ntsb/IAD02LA028.md): Wilburn Jodel F-12 · Clarksville, VA · Accident · 1 fatal · Limited investigation · Final report · Jan 27, 2002 · N722Z · Substantial damage
  > The pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Also causal, was the loss of engine power for undetermined reasons.
- [NTSB IAD02FA026](https://openairdocs.org/ntsb/IAD02FA026.md): MBB BK-117 A-3 · Cleveland, OH · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2002 · N626MB · Destroyed
  > pilot's failure to maintain directional control of the helicopter while hovering, which resulted in its collision with a building. Factors were the confined area, tail wind, and wind gusts.
- [NTSB MIA02FA049](https://openairdocs.org/ntsb/MIA02FA049.md): Piper PA-24-250 · Micanopy, FL · Accident · 2 fatal · Field investigation · Final report · Jan 13, 2002 · N8263P · Destroyed
  > The pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.
- [NTSB SEA02LA026](https://openairdocs.org/ntsb/SEA02LA026.md): Robinson R22 Beta · Renton, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 11, 2002 · N7185A · Substantial damage
  > The flight instructor's failure to ensure that adequate altitude/clearance above the ground was maintained during hovering flight, resulting in an inadvertent ground contact and subsequent loss of control of the helicopter. A factor was the flight…
- [NTSB LAX02LA064](https://openairdocs.org/ntsb/LAX02LA064.md): Piper PA-22-108 · Tehachapi, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 11, 2002 · N4895Z · Substantial damage
  > the pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.
- [NTSB ATL02LA035](https://openairdocs.org/ntsb/ATL02LA035.md): Springer Longbow 150 · Oak Hill, FL · Accident · 1 fatal · Limited investigation · Final report · Jan 10, 2002 · N150LB · Substantial damage
  > The improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…
- [NTSB SEA02LA025](https://openairdocs.org/ntsb/SEA02LA025.md): Cessna 210L · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Jan 9, 2002 · N1713X · Substantial damage
  > The pilot's intentional continuation of a visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the terrain. Factors include low ceilings, snow, mountainous/hilly terrain, and trees.
- [NTSB FTW02LA063](https://openairdocs.org/ntsb/FTW02LA063.md): Cessna 172N · Durango, CO · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 2002 · N3535E · Substantial damage
  > the pilot's failure to maintain clearance with the trees and mountainous terrain while maneuvering. A contributing factor was the pilot's delay in taking remedial action.
- [NTSB SEA02LA024](https://openairdocs.org/ntsb/SEA02LA024.md): Hughes 369E · Grand Coulee, WA · Accident · No injuries · Limited investigation · Final report · Jan 8, 2002 · N369ET · Substantial damage
  > The net gunner's improper decision to fire the net gun at an angle that allowed the net to become entangled in the main rotor system. A factor was foreign object damage to the main rotor blades.
- [NTSB FTW02FA062](https://openairdocs.org/ntsb/FTW02FA062.md): Beech 95-B55 · Oak Grove, LA · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2002 · N77RY · Destroyed
  > the pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.
- [NTSB DEN02FA017](https://openairdocs.org/ntsb/DEN02FA017.md): Cessna 172K · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2002 · N78035 · Destroyed
  > the pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.
- [NTSB ATL02TA030](https://openairdocs.org/ntsb/ATL02TA030.md): Hughes OH-6A · Tampa, FL · Accident · Minor injuries · Final report · Jan 4, 2002 · N46TP · Substantial damage
  > The pilot's improper flare during practice autorotation.
- [NTSB ATL02LA027](https://openairdocs.org/ntsb/ATL02LA027.md): Flugzeugbau DG-200 · Benton, TN · Accident · No injuries · Limited investigation · Final report · Dec 29, 2001 · N5457T · Substantial damage
  > The pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.
- [NTSB DEN02GA016](https://openairdocs.org/ntsb/DEN02GA016.md): Hughes 369E · Park City, UT · Accident · 3 fatal · Final report · Dec 27, 2001 · N280SP · Destroyed
  > the pilot's inadequate visual lookout, resulting in an inflight collision with powerlines. Contributing factors were the fog and the powerlines.
- [NTSB ATL02TA021](https://openairdocs.org/ntsb/ATL02TA021.md): Bell 206 · Awendaw, SC · Accident · No injuries · Final report · Dec 21, 2001 · N206HE · Substantial damage
  > The pilot's failure to maintain clearance from the bambi bucket suspension assembly during dip operation.
- [NTSB ATL02FA017](https://openairdocs.org/ntsb/ATL02FA017.md): Beech BE-55 · Montgomery, AL · Accident · 3 fatal · Field investigation · Final report · Dec 12, 2001 · N99DC · Destroyed
  > The pilots failure to maintain airspeed while maneuvering in instrument flight conditions resulting in an inadvertence stall/spin (vertical descent) and subsequent in-flight collision with trees and terrain.
- [NTSB MIA02FA039](https://openairdocs.org/ntsb/MIA02FA039.md): Beech BE-55-T42A · Johnson City, TN · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2001 · N50KF · Destroyed
  > The pilot's failure to maintain altitude clearance above the tree resulting in a collision with the tree, subsequent collision with a building, and the ground.
- [NTSB LAX02LA039](https://openairdocs.org/ntsb/LAX02LA039.md): Bell 206 B-2 · Aieia, HI · Accident · No injuries · Limited investigation · Final report · Dec 4, 2001 · N968YC · Substantial damage
  > The pilot's loss of lateral control while in a hover that resulted in a rollover and collision with the ground. A factor was the unclear exit and boarding procedures provided to the work crew, who were non-aviators, during the preflight briefing.
- [NTSB LAX02LA037](https://openairdocs.org/ntsb/LAX02LA037.md): Bellanca 8KCAB · Long Beach, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2001 · N50554 · Destroyed
  > the loss of aircraft control while maneuvering for undetermined reasons.
- [NTSB FTW02LA046](https://openairdocs.org/ntsb/FTW02LA046.md): Cessna 152 · Perry, TX · Accident · No injuries · Limited investigation · Final report · Nov 30, 2001 · N95565 · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB MIA02LA031](https://openairdocs.org/ntsb/MIA02LA031.md): Cessna 172M · Barceloneta, PR · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 2001 · N61582 · Substantial damage
  > The pilot's failure to maintain control of the aircraft which resulted in an uncontrolled descent and an in flight collision with water. Contributing to the accident was the impairment of the pilot due to alcohol.
- [NTSB MIA02LA040](https://openairdocs.org/ntsb/MIA02LA040.md): Eurocopter AS-350-BA · Swanee, GA · Accident · No injuries · Limited investigation · Final report · Nov 16, 2001 · N6101U · Substantial damage
  > The pilot's improper visual lookout while hovering the helicopter, which resulted in the helicopter's main rotor blades colliding with a light post.
- [NTSB NYC02TA029](https://openairdocs.org/ntsb/NYC02TA029.md): Kaman K-1200 · Bloomfield, CT · Accident · Minor injuries · Final report · Nov 14, 2001 · N361KA · Substantial damage
  > The pilot's failure to maintain aircraft control while hovering. A factor related to the accident was the pilots lack of experience in type of aircraft.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=102

## 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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=101

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