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

## Cases, newest first

- [NTSB ATL96LA076](https://openairdocs.org/ntsb/ATL96LA076.md): Hiller UH12-E · Huger, SC · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 1996 · N14MQ · Substantial damage
  > The blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.
- [NTSB LAX96LA146](https://openairdocs.org/ntsb/LAX96LA146.md): Luckett Flybaby 1A · Castiac, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1996 · N71658 · Destroyed
  > The pilot's improper in-flight planning/decision. The terrain condition and low ceiling were related factors.
- [NTSB NYC96LA079](https://openairdocs.org/ntsb/NYC96LA079.md): Grumman American AA-1C · Groton, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1996 · N9974U · Substantial damage
  > the pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.
- [NTSB NYC96LA077](https://openairdocs.org/ntsb/NYC96LA077.md): Robinson R22-BETA · Fairfield, NJ · Accident · No injuries · Limited investigation · Final report · Mar 23, 1996 · N221CW · Substantial damage
  > the flight instructor's inadequate supervision in that he delayed corrective action in recovering the low rotor RPM resulting in a loss of control.
- [NTSB ANC96LA037](https://openairdocs.org/ntsb/ANC96LA037.md): Piper PA-12 · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Mar 23, 1996 · N2431M · Substantial damage
  > The undetermined loss of engine power and lack of suitable terrain to make a forced landing.
- [NTSB MIA96LA103](https://openairdocs.org/ntsb/MIA96LA103.md): Robinson R-22-BETA · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Mar 22, 1996 · N21077 · Substantial damage
  > the flight instructor's failure to properly supervise the dual student and take corrective action before control was lost. Contributing to the accident was the dual student's overcontrol of the helicopter during hover.
- [NTSB CHI96FA116](https://openairdocs.org/ntsb/CHI96FA116.md): Cirrus VK30 · Duluth, MN · Accident · 1 fatal · Field investigation · Final report · Mar 22, 1996 · N44VK · Destroyed
  > the inadequate handling/performance design capabilities of the airplane which resulted in the inability to recover from an aft center of gravity spin. Factors were the lack of any antispin or deep stall recovery devices, and the aft center of gravity.
- [NTSB FTW96FA151](https://openairdocs.org/ntsb/FTW96FA151.md): Sukhoi SU-29 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · Mar 21, 1996 · N729SU · Destroyed
  > The in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.
- [NTSB ATL96LA068](https://openairdocs.org/ntsb/ATL96LA068.md): Bell 205A-1 · Grove Hill, AL · Accident · No injuries · Limited investigation · Final report · Mar 21, 1996 · N68HJ · Substantial damage
  > fatigue failure of the vertical fin forward spar in an area that was not accessible to inspection. A factor relating to the accident was: guidance for inspection of the area (where the fatigue occurred) was insufficiently defined by the manufacturer.
- [NTSB SEA96LA070](https://openairdocs.org/ntsb/SEA96LA070.md): Bell 206B · La Grande, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 1996 · N57362 · Substantial damage
  > the pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.
- [NTSB LAX96LA137](https://openairdocs.org/ntsb/LAX96LA137.md): Bumford GR-7 · Temecula, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 17, 1996 · N555GR · Destroyed
  > failure of the pilot to maintain control of the airplane, while performing an aerobatic maneuver, which resulted in inadvertent entry into a spin. Factors relating to the accident were: the pilot's lack of recent experience in fixed wing aircraft, his lack of…
- [NTSB FTW96LA149](https://openairdocs.org/ntsb/FTW96LA149.md): Enstrom F-28A · Killeen, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1996 · N9574 · Substantial damage
  > The pilot's improper planning/decision, which resulted in fuel exhaustion and a loss of engine power, due to an inadequate supply of fuel. A factor relating to the accident was: lack of suitable terrain for an emergency landing (autorotation).
- [NTSB MIA96FA099](https://openairdocs.org/ntsb/MIA96FA099.md): Beech A23A · Sarasota, FL · Accident · 1 fatal · Field investigation · Final report · Mar 15, 1996 · N2300W · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent in-flight loss of control (stall/spin) and subsequent in-flight collision with terrain.
- [NTSB FTW96LA148](https://openairdocs.org/ntsb/FTW96LA148.md): Air Tractor AT-502 · Texarkana, AR · Accident · No injuries · Limited investigation · Final report · Mar 15, 1996 · N4540C · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA108](https://openairdocs.org/ntsb/CHI96LA108.md): Bishop-Christian Eagle II · Cambridge, IN · Accident · 1 fatal · Limited investigation · Final report · Mar 15, 1996 · N219RC · Destroyed
  > the pilot allowed the airplane to enter a flat spin, while performing an acrobatic maneuver, and was unable to recover before ground impact. Factors relating to the accident were: the pilot's overconfidence in his personal ability, and his lack of familiarity…
- [NTSB FTW96LA147](https://openairdocs.org/ntsb/FTW96LA147.md): Bell 206BIII · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1996 · N115FH · Substantial damage
  > the pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.
- [NTSB CHI96LA105](https://openairdocs.org/ntsb/CHI96LA105.md): Cessna 172 · Camp Lake, WI · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1996 · N2966U · Substantial damage
  > Failure of the pilot to maintain clearance from trees that were located beside the runway.
- [NTSB ANC96LA029](https://openairdocs.org/ntsb/ANC96LA029.md): Cessna 172 · Ketchikan, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1996 · N739YR · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of a suitable area for an emergency landing.
- [NTSB CHI96FA099](https://openairdocs.org/ntsb/CHI96FA099.md): McDonnell Douglas 369E · Manhattan, KS · Accident · Serious injuries · Field investigation · Final report · Mar 3, 1996 · N7065C · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: pressure to meet a work schedule.
- [NTSB FTW96LA135](https://openairdocs.org/ntsb/FTW96LA135.md): Rockwell S-2R · Winchester, AR · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1996 · N431BL · Substantial damage
  > Failure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.
- [NTSB FTW96LA132](https://openairdocs.org/ntsb/FTW96LA132.md): Grumman G-164A · Dewitt, AR · Accident · No injuries · Limited investigation · Final report · Feb 24, 1996 · N48435 · Substantial damage
  > a loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.
- [NTSB FTW96LA131](https://openairdocs.org/ntsb/FTW96LA131.md): Robinson R22B · Garland, TX · Accident · No injuries · Limited investigation · Final report · Feb 24, 1996 · N8141L · Substantial damage
  > Failure of the pilot to maintain sufficient altitude and tail rotor clearance from the terrain, while demonstrating rearward movement in a hover.
- [NTSB MIA96LA086](https://openairdocs.org/ntsb/MIA96LA086.md): North American SNJ-5 · West Palm Beach, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 23, 1996 · N4LH · Destroyed
  > Failure of the pilot to maintain adequate altitude/clearance above the water, while performing a low level maneuver (wing over). The pilot's ostentatious display of aerobatic flight was a related factor.
- [NTSB IAD96LA045](https://openairdocs.org/ntsb/IAD96LA045.md): Advanced Technology Ultra Sport 254 · West Point, VA · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1996 · N254AS · Destroyed
  > the pilot's failure to maintain control of the helicopter during low altitude flight/maneuvering, which resulted in the helicopter impacting terrain. A related factor was the pilot's lack of flight experience in the make and model of helicopter.
- [NTSB ATL96FA051](https://openairdocs.org/ntsb/ATL96FA051.md): Sukhoi SU-31 · Immokalee, FL · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1996 · N31MX · Destroyed
  > the manufacturer's improper composite curing process, which resulted in wing spar voids and subsequent failure of the wing during aerobatic flight.
- [NTSB CHI96FA091](https://openairdocs.org/ntsb/CHI96FA091.md): Hughes 369D · Dweese, NE · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1996 · N5141Y · Destroyed
  > the pilot's improper in-flight planning and decision, and his lack of total experience in the type of operation. A factor was the crosswind.
- [NTSB LAX96FA114](https://openairdocs.org/ntsb/LAX96FA114.md): Bellanca 8KCAB · New River, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 18, 1996 · N2596Z · Destroyed
  > failure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.
- [NTSB FTW96LA125](https://openairdocs.org/ntsb/FTW96LA125.md): Hughes 269A · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 1996 · N8897F · Substantial damage
  > Failure of the unqualified helicopter pilot to maintain control of the helicopter. Factors relating to the accident were: his lack of total experience in helicopters and his improper decision to attempt to hover without appropriate training/endorsement for…
- [NTSB FTW96LA121](https://openairdocs.org/ntsb/FTW96LA121.md): Hiller UH-12D · Carrizo Springs, TX · Accident · No injuries · Limited investigation · Final report · Feb 16, 1996 · N67065 · Substantial damage
  > a loss of engine power for undetermined reasons, and the pilot's improper touchdown.
- [NTSB ATL96LA048](https://openairdocs.org/ntsb/ATL96LA048.md): Mcrae Titan Acft Tornado · Pahokee, FL · Accident · 2 fatal · Limited investigation · Final report · Feb 15, 1996 · N6234X · Substantial damage
  > the pilot's failure to maintain airspeed while maneuvering.
- [NTSB MIA96FA078](https://openairdocs.org/ntsb/MIA96FA078.md): Aero Commander 500S · Manati, PR · Accident · 3 fatal · Field investigation · Final report · Feb 11, 1996 · N79NU · Destroyed
  > Failure of the flight crew, for undetermined reasons, to recover from a stall and resulting uncontrolled descent. This resulted in the aircraft colliding with the terrain while in a 45-60 degree nose down attitude at a slow speed.
- [NTSB FTW96FA136](https://openairdocs.org/ntsb/FTW96FA136.md): Mbb BO-105 · Gulf Of Mexico · Accident · 2 fatal · Field investigation · Final report · Feb 10, 1996 · N126EH · Destroyed
  > The pilot's failure to maintain clearance from the ocean for unknown reasons.
- [NTSB LAX96LA194](https://openairdocs.org/ntsb/LAX96LA194.md): Bell 206B · Barstow, CA · Accident · No injuries · Limited investigation · Final report · Feb 6, 1996 · N16726 · Substantial damage
  > failure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.
- [NTSB SEA96TA046](https://openairdocs.org/ntsb/SEA96TA046.md): Christen Industries A-1 · Lakeview, OR · Accident · Minor injuries · Final report · Feb 2, 1996 · N2866B · Substantial damage
  > failure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…
- [NTSB MIA96LA074](https://openairdocs.org/ntsb/MIA96LA074.md): Yakovlev YAK-52 · Boynton Beach, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 2, 1996 · N77YK · Destroyed
  > Pilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…
- [NTSB MIA96FA067](https://openairdocs.org/ntsb/MIA96FA067.md): Mitsubishi MU-2B-60 · West Columbia, SC · Accident · Serious injuries · Field investigation · Final report · Jan 19, 1996 · N50KW · Destroyed
  > a total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.
- [NTSB FTW96LA096](https://openairdocs.org/ntsb/FTW96LA096.md): Cessna 150M · Mandeville, LA · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1996 · N714JV · Substantial damage
  > the pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.
- [NTSB LAX96FA095](https://openairdocs.org/ntsb/LAX96FA095.md): Piper J2 · Lancaster, CA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1996 · N17261 · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering from crosswind to downwind after takeoff, which resulted in an inadvertent stall/spin and collision with terrain.
- [NTSB FTW96FA089](https://openairdocs.org/ntsb/FTW96FA089.md): Cessna A150M · Vinita, OK · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1996 · N8125V · Destroyed
  > Failure of the pilot to recover from a spin. Factors relating to the accident were: the pilot's ostentatious display and the lack of altitude (terrain clearance) for recovery from the aerobatic maneuver and subsequent spin.
- [NTSB SEA96LA042](https://openairdocs.org/ntsb/SEA96LA042.md): Cessna 182 · Grantsville, UT · Accident · No injuries · Limited investigation · Final report · Jan 12, 1996 · N91130 · Substantial damage
  > the failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.
- [NTSB LAX96LA093](https://openairdocs.org/ntsb/LAX96LA093.md): Bell 47-G5 · Pope Valley, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 12, 1996 · N1309X · Destroyed
  > the pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.
- [NTSB FTW96LA095](https://openairdocs.org/ntsb/FTW96LA095.md): Schweizer 269C · San Ygnacio, TX · Accident · No injuries · Limited investigation · Final report · Jan 12, 1996 · N3623T · Substantial damage
  > Failure of the rotor drive system clutch assembly (separation of the swedge ball from the end of the clutch control cable), which resulted in disengagement of the rotor drive system, while the helicopter was in lateral movement at low altitude.
- [NTSB FTW96LA090](https://openairdocs.org/ntsb/FTW96LA090.md): Piper PA-28-181 · Collbran, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1996 · N2132J · Substantial damage
  > The pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.
- [NTSB SEA96LA041](https://openairdocs.org/ntsb/SEA96LA041.md): Cessna 172K · Park City, MT · Accident · No injuries · Limited investigation · Final report · Jan 6, 1996 · N172NS · Substantial damage
  > Inadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.
- [NTSB MIA96LA050](https://openairdocs.org/ntsb/MIA96LA050.md): Nanchang China CJ6A · Planterville, SC · Accident · 2 fatal · Limited investigation · Final report · Dec 28, 1995 · N3104U · Destroyed
  > failure of the pilot to maintain sufficient altitude or clearance from trees.
- [NTSB ATL96FA027](https://openairdocs.org/ntsb/ATL96FA027.md): Piper J-3-C65 · Belzoni, MS · Accident · 2 fatal · Field investigation · Final report · Dec 26, 1995 · N3615K · Substantial damage
  > failure of the student pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin and subsequent collision with the ground.
- [NTSB SEA96FA034](https://openairdocs.org/ntsb/SEA96FA034.md): Piper PA-18-150 · Kapowsin, WA · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1995 · N4008Z · Substantial damage
  > the pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.
- [NTSB CHI96FA065](https://openairdocs.org/ntsb/CHI96FA065.md): Mumm Lancair · Morris, MN · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1995 · N2114Z · Destroyed
  > the partially blocked elevator and improper installation of the elevator bob weight by the owner/builder which prevented full travel of the elevator control system. Factors relating to this accident were the intentional stall and inability to adequately…
- [NTSB LAX96FA076](https://openairdocs.org/ntsb/LAX96FA076.md): Hughes 369D · Feather Falls, CA · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1995 · N8395F · Destroyed
  > the pilot's failure to jettison his external load after it came in contact with trees and terrain. The pilot's failure to maintain altitude/clearance above trees and hilly terrain was a related factor.
- [NTSB ATL96LA025](https://openairdocs.org/ntsb/ATL96LA025.md): Moravan Zlin Z50 LA · Springfield, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 20, 1995 · N6660B · Destroyed
  > the pilot's failure to maintain control of the aircraft.

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

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

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