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

## Cases, newest first

- [NTSB MIA96FA185](https://openairdocs.org/ntsb/MIA96FA185.md): Champion Aeronca 7GCB · Fairhope, AL · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1996 · N9908Y · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…
- [NTSB CHI96LA239](https://openairdocs.org/ntsb/CHI96LA239.md): Cessna A188B · Saint Charles, MO · Accident · No injuries · Limited investigation · Final report · Jul 15, 1996 · N9703J · Substantial damage
  > a partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.
- [NTSB IAD96LA116](https://openairdocs.org/ntsb/IAD96LA116.md): Quicksilver Sprint · Mt Airy, MD · Accident · 1 fatal · Limited investigation · Final report · Jul 13, 1996 · UNREG · Destroyed
  > The pilot's improper planning/decision and exceeding the design stress limits of the aircraft, which resulted in overload failure of the wing and subsequent uncontrolled collision with the terrain. Factors related to the accident were: the pilot's failure to…
- [NTSB CHI96FA237](https://openairdocs.org/ntsb/CHI96FA237.md): Piper PA-12 · Roselle, IL · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1996 · N25JP · Destroyed
  > the pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…
- [NTSB ANC96FA098](https://openairdocs.org/ntsb/ANC96FA098.md): Sikorsky CH-54A · Ketchikan, AK · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1996 · N541SB · Destroyed
  > failure of the number 5 tailrotor bearing. A factor relating to the accident was: the uneven/steep sloping terrain, where the pilot was forced to land. Possible factors were: inadequate handling/labeling of the 'relubed' bearing by intermediate supplyier(s),…
- [NTSB SEA96LA152](https://openairdocs.org/ntsb/SEA96LA152.md): Hanks Avid Flyer · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Jul 11, 1996 · N3086G · Substantial damage
  > partial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.
- [NTSB FTW96LA297](https://openairdocs.org/ntsb/FTW96LA297.md): Wsk Pzl Mielec M-18A · Mcgehee, AR · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N80199 · Destroyed
  > a loss of engine power and subsequent engine fire for undetermined reasons.
- [NTSB CHI96LA236](https://openairdocs.org/ntsb/CHI96LA236.md): Wsk Pzl Mielec M-18 Dromader · Waupaca, WI · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N2047S · Substantial damage
  > inadequate maintenance of the throttle cable by maintenance personnel.
- [NTSB ATL96LA106](https://openairdocs.org/ntsb/ATL96LA106.md): Bell 47G · Bartow, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1996 · N6356 · Destroyed
  > the pilot's inadequate visual lookout, and his failure to maintain ground clearance, while maneuvering to avoid a collision with a utility line.
- [NTSB ATL96FA103](https://openairdocs.org/ntsb/ATL96FA103.md): George Evenson Cuby · Hawkinsville, GA · Accident · 2 fatal · Field investigation · Final report · Jul 9, 1996 · N1035W · Destroyed
  > The failure of the pilot-in-command to maintain airspeed.
- [NTSB SEA96LA146](https://openairdocs.org/ntsb/SEA96LA146.md): Grumman American AA-5B · St Maries, ID · Accident · 1 fatal · Limited investigation · Final report · Jul 8, 1996 · N28452 · Destroyed
  > the pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.
- [NTSB NYC96LA145](https://openairdocs.org/ntsb/NYC96LA145.md): Bell 47G-5 · Carver, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1996 · N8591F · Substantial damage
  > the pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.
- [NTSB IAD96FA107](https://openairdocs.org/ntsb/IAD96FA107.md): Bell 206B · Salem, OH · Accident · 5 fatal · Field investigation · Final report · Jul 8, 1996 · N49578 · Destroyed
  > The pilot's impairment of judgment and performance due to alcohol and the pilot's improper handling of the helicopter resulting in a loss of tail rotor effectiveness. A related factor was the pilot's disregard for the aircraft's weight and balance while…
- [NTSB ANC96LA097](https://openairdocs.org/ntsb/ANC96LA097.md): Bell 206B · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Jul 8, 1996 · N2761F · Substantial damage
  > The pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.
- [NTSB LAX96LA265](https://openairdocs.org/ntsb/LAX96LA265.md): Cessna 150L · California City, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1996 · N332CS · Destroyed
  > The pilot's selection of an inadequate cruise altitude in an area of rising terrain and his failure to consider the effect of the high density altitude on the climb capability of the aircraft.
- [NTSB SEA96LA144](https://openairdocs.org/ntsb/SEA96LA144.md): Hughes 369D · Mcminnville, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1996 · N5110Y · Substantial damage
  > improper maintenance (replacement) and inspection of the engine fuel governor by company maintenance personnel, the pilot's inadequate preflight inspection, and a subsequent disconnect of the adjustable governor lever control rod, which disabled the engine…
- [NTSB LAX96LA263](https://openairdocs.org/ntsb/LAX96LA263.md): Bell 47G3 · Wasco, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1996 · N154PG · Substantial damage
  > the pilot's failure to maintain adequate engine rpm during an aerial application flight.
- [NTSB FTW96LA313](https://openairdocs.org/ntsb/FTW96LA313.md): Luscombe 8A · Corsicana, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1996 · N71973 · Substantial damage
  > The pilot's failure to maintain adequate airspeed. A factor was the high wind.
- [NTSB IAD96LA103](https://openairdocs.org/ntsb/IAD96LA103.md): Aero Commander Calair A-9B · Cloverdale, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1996 · N7730V · Destroyed
  > Powerplant failure due to undetermined reasons. Contributing to the severity of the crash was the unsuitable terrain in which the aircraft landed and post-crash fire.
- [NTSB NYC96LA135](https://openairdocs.org/ntsb/NYC96LA135.md): Bell 206B III · South Carver, MA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1996 · N444JB · Substantial damage
  > The pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…
- [NTSB FTW96LA290](https://openairdocs.org/ntsb/FTW96LA290.md): Cessna 172L · Johnstown, CO · Accident · No injuries · Limited investigation · Final report · Jul 1, 1996 · N19682 · Substantial damage
  > failure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.
- [NTSB FTW96LA286](https://openairdocs.org/ntsb/FTW96LA286.md): Air Tractor AT-502 · Almyra, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1996 · N7314C · Destroyed
  > The pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.
- [NTSB CHI96LA223](https://openairdocs.org/ntsb/CHI96LA223.md): Bell TH-13T · Mandan, ND · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N96161 · Substantial damage
  > the pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.
- [NTSB CHI96LA222](https://openairdocs.org/ntsb/CHI96LA222.md): Piper J3C-90 · Racine, WI · Accident · 1 fatal · Limited investigation · Final report · Jun 29, 1996 · N77563 · Destroyed
  > was improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…
- [NTSB MIA96LA166](https://openairdocs.org/ntsb/MIA96LA166.md): Bell UH-1B · Lorida, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1996 · N9846F · Substantial damage
  > failure of company maintenance personnel to properly torque the tail rotor 90 degree gear box mounting bolts during installation, which resulted in failure of the mounting studs due to bending fatigue and subsequent separation of the gearbox.
- [NTSB FTW96LA278](https://openairdocs.org/ntsb/FTW96LA278.md): Ryan PT-22 · Krum, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 1996 · N47621 · Substantial damage
  > the pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was his lack of recent experience in the make and model of airplane.
- [NTSB MIA96LA164](https://openairdocs.org/ntsb/MIA96LA164.md): Cessna 172H · Jonesville, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1996 · N3887R · Substantial damage
  > the pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.
- [NTSB CHI96LA217](https://openairdocs.org/ntsb/CHI96LA217.md): Air Tractor AT-301 · Ness City, KS · Accident · No injuries · Limited investigation · Final report · Jun 26, 1996 · N8883S · Substantial damage
  > the failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.
- [NTSB FTW96LA274](https://openairdocs.org/ntsb/FTW96LA274.md): Hughes 369HE · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Jun 24, 1996 · N521TC · Substantial damage
  > the pilot's failure to maintain clearance between the tail rotor and a fence while hovering.
- [NTSB FTW96LA270](https://openairdocs.org/ntsb/FTW96LA270.md): American AG5B · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1996 · N227ER · Destroyed
  > An inadvertent stall spin. Factors were the pilot's intentional maneuver at an altitude insufficient to ensure a safe recovery, and overconfidence in his personal ability.
- [NTSB LAX96LA241](https://openairdocs.org/ntsb/LAX96LA241.md): Cessna 182 · Mendota, CA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1996 · N3675U · Substantial damage
  > The pilot's decision to intentionally shut down the engine; his failure to verify the surface winds during the prolonged orbiting descent over the airport, which resulted in a final approach with a tailwind component; and his misjudging of the aircraft's…
- [NTSB SEA96FA133](https://openairdocs.org/ntsb/SEA96FA133.md): Bellanca 8KCAB · Pomeroy, WA · Accident · 1 fatal · Field investigation · Final report · Jun 21, 1996 · N57514 · Destroyed
  > The pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.
- [NTSB LAX96LA239](https://openairdocs.org/ntsb/LAX96LA239.md): Aeronca 7AC · Lamont, CA · Accident · No injuries · Limited investigation · Final report · Jun 21, 1996 · N2456E · Substantial damage
  > failure of the pilot to see-and-avoid a guy wire along the border of a field that was being agriculturally treated. The sunglare, guy wire, and lack of visual cues were related factors.
- [NTSB FTW96LA264](https://openairdocs.org/ntsb/FTW96LA264.md): Piper PA-36-300 · Littlefield, TX · Accident · No injuries · Limited investigation · Final report · Jun 20, 1996 · N57836 · Substantial damage
  > The total loss of engine power due to the failure of the number 5 and 6 connecting rods. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96TA261](https://openairdocs.org/ntsb/FTW96TA261.md): Bell 212 · Pagosa Springs, CO · Accident · Minor injuries · Final report · Jun 18, 1996 · N91AL · Destroyed
  > The pilot's failure to comply with performance data for hover out of ground effect. A factor was not attaining load jettison.
- [NTSB FTW96LA258](https://openairdocs.org/ntsb/FTW96LA258.md): Air Tractor 301A · Hunter, AR · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 1996 · N7319C · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB MIA96LA159](https://openairdocs.org/ntsb/MIA96LA159.md): Cessna 150M · Knightdale, NC · Accident · No injuries · Limited investigation · Final report · Jun 17, 1996 · N47ES · Substantial damage
  > failure of the flight instructor (CFI) to ensure proper use of the carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent emergency landing.
- [NTSB SEA96GA129](https://openairdocs.org/ntsb/SEA96GA129.md): Cessna 182R · Grand View, ID · Accident · Minor injuries · Final report · Jun 15, 1996 · N6356N · Substantial damage
  > failure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.
- [NTSB FTW96FA250](https://openairdocs.org/ntsb/FTW96FA250.md): Piper PA-18-150 · Monument, CO · Accident · 1 fatal · Field investigation · Final report · Jun 15, 1996 · N111BF · Destroyed
  > The pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.
- [NTSB LAX96LA230](https://openairdocs.org/ntsb/LAX96LA230.md): Ayres S2R · Oracle, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1996 · N4006K · Destroyed
  > the pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…
- [NTSB NYC96FA125](https://openairdocs.org/ntsb/NYC96FA125.md): Beech V35 · Williamstown, NJ · Accident · 3 fatal · Field investigation · Final report · Jun 13, 1996 · N2011W · Destroyed
  > inadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…
- [NTSB FTW96LA247](https://openairdocs.org/ntsb/FTW96LA247.md): Cessna 150L · Levelland, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1996 · N17299 · Substantial damage
  > The student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.
- [NTSB LAX96LA220](https://openairdocs.org/ntsb/LAX96LA220.md): Cessna 150F · Placerville, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1996 · N7880F · Destroyed
  > the pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.
- [NTSB CHI96LA194](https://openairdocs.org/ntsb/CHI96LA194.md): Piper PA-25 · Cleveland, ND · Accident · No injuries · Limited investigation · Final report · Jun 11, 1996 · N9844P · Destroyed
  > failure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.
- [NTSB FTW96FA243](https://openairdocs.org/ntsb/FTW96FA243.md): Aeronca 65-CA · Lonoke, AR · Accident · 1 fatal · Field investigation · Final report · Jun 10, 1996 · N36513 · Substantial damage
  > The pilot's failure to maintain aircraft control.
- [NTSB LAX96FA223](https://openairdocs.org/ntsb/LAX96FA223.md): Cessna 172N · Bermuda Dunes, CA · Accident · 3 fatal · Field investigation · Final report · Jun 9, 1996 · N734FB · Destroyed
  > the pilot's impairment of judgment and performance due to alcohol and drugs (methamphetamine, amphetamine, & marijuana), his excessive maneuvering (pull-up) after making a touch-and-go landing, and his failure to maintain sufficient airspeed, which resulted…
- [NTSB FTW96LA244](https://openairdocs.org/ntsb/FTW96LA244.md): Hughes 269 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Jun 8, 1996 · N269A · Substantial damage
  > The student pilot's encounter with dynamic rollover while hovering. Factors were the prevailing high winds and the inadequate supervision provided by the flight instructor.
- [NTSB SEA96LA114](https://openairdocs.org/ntsb/SEA96LA114.md): Cessna T188C · Roundup, MT · Accident · Serious injuries · Limited investigation · Final report · Jun 7, 1996 · N4970J · Destroyed
  > failure of the pilot to maintain adequate airspeed, during a turn-around maneuver after a swath run, which resulted in an inadvertent stall.
- [NTSB SEA96LA112](https://openairdocs.org/ntsb/SEA96LA112.md): Grumman-Schweizer G-164A · Prescott, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1996 · N9793 · Substantial damage
  > failure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.
- [NTSB MIA96FA148](https://openairdocs.org/ntsb/MIA96FA148.md): Aeronca O-58B · Greenville, SC · Accident · 1 fatal · Field investigation · Final report · Jun 5, 1996 · N49546 · Destroyed
  > the pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.

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

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

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