# 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 49 of 377 · 18,849 cases

## Cases, newest first

- [NTSB CEN13LA447](https://openairdocs.org/ntsb/CEN13LA447.md): Bell 206B · Tamaroa, IL · Accident · No injuries · Limited investigation · Final report · Jul 19, 2013 · N23L · Substantial damage
  > The pilot's failure to maintain clearance from terrain during an agricultural application maneuver.
- [NTSB CEN13LA425](https://openairdocs.org/ntsb/CEN13LA425.md): Air Tractor AT-400 · Steward, IL · Accident · No injuries · Limited investigation · Final report · Jul 19, 2013 · N155HF · Substantial damage
  > The pilot's failure to maintain clearance from the guy wires during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.
- [NTSB CEN13LA424](https://openairdocs.org/ntsb/CEN13LA424.md): Air Tractor AT-802A · Huntingburg, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2013 · N86BM · Destroyed
  > The pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.
- [NTSB CEN13FA420](https://openairdocs.org/ntsb/CEN13FA420.md): Champion 7KCAB · Oak Ridge, LA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 2013 · N2978G · Substantial damage
  > The private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…
- [NTSB ERA13IA326](https://openairdocs.org/ntsb/ERA13IA326.md): Piper PA-34 · Palm Coast, FL · Incident · No injuries · Incident investigation · Final report · Jul 17, 2013 · N767PE · No damage
  > The installation of an incorrect rudder trim tab control rod by unknown maintenance personnel, which resulted in the rod failing in flight due to overload and subsequent uncontrolled rudder oscillations.
- [NTSB ERA13CA324](https://openairdocs.org/ntsb/ERA13CA324.md): Boeing B75N1 · Woodruff, SC · Accident · Minor injuries · Data collection · Final report · Jul 17, 2013 · N5815V · Substantial damage
  > The pilot’s decision to initiate a stall maneuver at a low altitude, which resulted in an uncontrolled descent and inadvertent collision with trees and terrain.
- [NTSB CEN13LA422](https://openairdocs.org/ntsb/CEN13LA422.md): Grumman Aircraft Cor-Schweizer G-164A · Elmira, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2013 · N8719H · Substantial damage
  > The pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.
- [NTSB CEN13LA467](https://openairdocs.org/ntsb/CEN13LA467.md): Christen Industries Pitts S-2B · Dalton, OH · Accident · No injuries · Limited investigation · Final report · Jul 16, 2013 · N519ZB · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN13FA415](https://openairdocs.org/ntsb/CEN13FA415.md): Bell UH-1H · Dove Creek, CO · Accident · 1 fatal · Field investigation · Final report · Jul 16, 2013 · N775AR · Substantial damage
  > Pilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…
- [NTSB CEN13LA473](https://openairdocs.org/ntsb/CEN13LA473.md): Air Tractor AT-502B · Nauvoo, IL · Accident · No injuries · Limited investigation · Final report · Jul 15, 2013 · N6113C · Substantial damage
  > A fatigue failure of an engine compressor turbine blade, which resulted in extensive secondary engine damage and a complete loss of engine power.
- [NTSB WPR13LA313](https://openairdocs.org/ntsb/WPR13LA313.md): North Wing Uum Sport X2 · Parker Dam, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 7, 2013 · N467YN · Substantial damage
  > The student pilot’s abrupt maneuver to avoid transmission wires, which resulted in his loss of airplane control. Contributing to the accident were the pilot’s decision to perform a low-altitude flight, his distracted attention, and his failure to monitor the…
- [NTSB CEN13LA401](https://openairdocs.org/ntsb/CEN13LA401.md): JDT 1600R · Chesaning, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 6, 2013 · UNREG · Destroyed
  > The failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…
- [NTSB CEN13LA395](https://openairdocs.org/ntsb/CEN13LA395.md): Bell 47G-3B-1 · Plover, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 2013 · N7924S · Substantial damage
  > The pilot’s failure to maintain proper engine rpm, which resulted in a high rate of descent and ground impact.
- [NTSB CEN13LA394](https://openairdocs.org/ntsb/CEN13LA394.md): Gulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 2013 · N8187K · Substantial damage
  > The pilot’s failure to maintain clearance from a tree.
- [NTSB ERA13LA314](https://openairdocs.org/ntsb/ERA13LA314.md): Sikorsky 269C · Burnham, ME · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2013 · N888ZW · Substantial damage
  > The pilot's failure to maintain yaw control while operating out of ground effect at a low airspeed, which resulted in the loss of tail rotor effectiveness, an uncontrolled descent, and an in-flight collision with trees and terrain. Contributing to the…
- [NTSB CEN13LA406](https://openairdocs.org/ntsb/CEN13LA406.md): American Champion 7GCBC · Lufkin, TX · Accident · No injuries · Limited investigation · Final report · Jul 3, 2013 · N255SF · Substantial damage
  > The restricted movement of the carburetor’s forked needle valve within its seat due to the mechanic’s misadjustment of the valve clip forks, which resulted in fuel starvation.
- [NTSB CEN13CA389](https://openairdocs.org/ntsb/CEN13CA389.md): Beech P35 · Bridgeport, TX · Accident · Minor injuries · Data collection · Final report · Jul 2, 2013 · N8585M · Substantial damage
  > The failure of both the flight instructor and the pilot to monitor and manage the fuel on board, which resulted in an engine failure due to fuel starvation.
- [NTSB ERA13FA309](https://openairdocs.org/ntsb/ERA13FA309.md): Nanchang China CJ-6A · Ocean City, MD · Accident · 2 fatal · Field investigation · Final report · Jun 30, 2013 · N116RL · Destroyed
  > The pilot's failure to terminate the intentional aerobatic spin at an altitude adequate to prevent impacting the water. Contributing to the accident was the pilot's loss of situational awareness due to target fixation during the prolonged aerobatic maneuver.
- [NTSB CEN13LA383](https://openairdocs.org/ntsb/CEN13LA383.md): Vink Robert D Youngster · Grand Haven, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2013 · N258RV · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB WPR13LA318](https://openairdocs.org/ntsb/WPR13LA318.md): Chicco Quicksilver Sport II · Newbury Park, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2013 · N2812 · Substantial damage
  > The partial loss of engine power while maneuvering due to the blockage of the exhaust system by broken internal engine baffles that had shifted during the flight, which resulted in a forced landing and subsequent impact with terrain.
- [NTSB WPR13LA303](https://openairdocs.org/ntsb/WPR13LA303.md): Bell 206L-3 · Missoula, MT · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2013 · N868H · Substantial damage
  > The pilot's failure to prevent the helicopter from settling with power and to maintain proper position relative to an external load, which resulted in a loss of control and subsequent hard landing.
- [NTSB WPR13LA295](https://openairdocs.org/ntsb/WPR13LA295.md): Robinson Helicopter R44 · Fielding, UT · Accident · No injuries · Limited investigation · Final report · Jun 28, 2013 · N7187B · Substantial damage
  > The pilot's failure to maintain rotor rpm while traversing a canyon in high-density altitude and gusting wind conditions.
- [NTSB CEN13LA377](https://openairdocs.org/ntsb/CEN13LA377.md): Dankelman Peter G RV-7A · Marion, TX · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 2013 · N445RV · Destroyed
  > The pilot’s sudden incapacitation and natural death as a result of cardiovascular disease.
- [NTSB ANC13FA058](https://openairdocs.org/ntsb/ANC13FA058.md): Beech 95-B55 · Cantwell, AK · Accident · 3 fatal · Field investigation · Final report · Jun 28, 2013 · N5JG · Destroyed
  > The pilot’s continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.
- [NTSB CEN13LA375](https://openairdocs.org/ntsb/CEN13LA375.md): Air Tractor AT-301 · Colome, SD · Accident · No injuries · Limited investigation · Final report · Jun 26, 2013 · N3168X · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident engine run revealed no anomalies that would have precluded normal operation.
- [NTSB WPR13LA290](https://openairdocs.org/ntsb/WPR13LA290.md): Mcdonnell Douglas Helicopter 369E · Casa Grande, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 2013 · N34CT · Substantial damage
  > The total loss of engine power due to the ingestion of a foreign object and maintenance personnel's failure to remove shop rags before completing the installation of the air inlet barrier system.
- [NTSB WPR13CA354](https://openairdocs.org/ntsb/WPR13CA354.md): Robinson Helicopter R44 II · The Dalles, OR · Accident · No injuries · Data collection · Final report · Jun 25, 2013 · N74666 · Substantial damage
  > The pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.
- [NTSB WPR13LA287](https://openairdocs.org/ntsb/WPR13LA287.md): Bell 206B · Royal City, WA · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2013 · N407FK · Substantial damage
  > The pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.
- [NTSB WPR13FA288](https://openairdocs.org/ntsb/WPR13FA288.md): Beech J35 · Helena, MT · Accident · 1 fatal · Field investigation · Final report · Jun 24, 2013 · N8255D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.
- [NTSB WPR13LA283](https://openairdocs.org/ntsb/WPR13LA283.md): Extra 300/LT · Adrian, OR · Accident · 1 fatal · Limited investigation · Final report · Jun 23, 2013 · N169TM · Substantial damage
  > The pilot's improper decision to conduct low-level maneuvering in a river canyon with power lines, which resulted in his failure to maintain clearance from the power lines.
- [NTSB CEN13LA368](https://openairdocs.org/ntsb/CEN13LA368.md): Nanchang China CJ-6 · Wolcott, CO · Accident · 2 fatal · Limited investigation · Final report · Jun 23, 2013 · N2726C · Substantial damage
  > The pilots decision to perform an aerobatic maneuver at a low altitude from which he was unable to recover.
- [NTSB CEN13FA274](https://openairdocs.org/ntsb/CEN13FA274.md): Boeing-Stearman IB75A · Dayton, OH · Accident · 2 fatal · Field investigation · Final report · Jun 22, 2013 · N450JW · Destroyed
  > The pilot's controlled flight into terrain. Contributing to the accident was the pilot's modified airshow maneuver, which placed the airplane at low altitude and airspeed and out of position within the performance area.
- [NTSB ERA13FA295](https://openairdocs.org/ntsb/ERA13FA295.md): Rockwell International 690B · McClellanville, SC · Accident · 2 fatal · Field investigation · Final report · Jun 20, 2013 · N727JA · Destroyed
  > The pilot’s loss of airplane control during high-altitude maneuvering and his subsequent failure to recover airplane control. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot and his failure to perform remedial…
- [NTSB CEN13FA357](https://openairdocs.org/ntsb/CEN13FA357.md): Bell 47G-3B-1 · Maplewood, MN · Accident · 1 fatal · Field investigation · Final report · Jun 19, 2013 · N5024N · Destroyed
  > The loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.
- [NTSB CEN13LA353](https://openairdocs.org/ntsb/CEN13LA353.md): Air Tractor AT-802A · Minot, ND · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 2013 · N8522S · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees during an aerial application flight.
- [NTSB WPR13LA270](https://openairdocs.org/ntsb/WPR13LA270.md): Aero Vodochody L39C · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 14, 2013 · N8124N · 2 aircraft · Substantial damage
  > The other pilot’s failure to see and avoid the airplane during an air race training session, which resulted in a midair collision.
- [NTSB WPR13FA269](https://openairdocs.org/ntsb/WPR13FA269.md): Graves SH-2F · Montague, CA · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2013 · N15GG · Destroyed
  > The pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.
- [NTSB CEN13LA390](https://openairdocs.org/ntsb/CEN13LA390.md): Rockwell S-2R · Boise City, OK · Accident · No injuries · Limited investigation · Final report · Jun 12, 2013 · N2249U · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.
- [NTSB CEN13LA346](https://openairdocs.org/ntsb/CEN13LA346.md): Rogers T-51 Mustang KIT · St Francis, KS · Accident · No injuries · Limited investigation · Final report · Jun 11, 2013 · N548RR · Substantial damage
  > Foreign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.
- [NTSB CEN13CA343](https://openairdocs.org/ntsb/CEN13CA343.md): Cessna 150G · Franklin, OH · Accident · No injuries · Data collection · Final report · Jun 10, 2013 · N3718J · Substantial damage
  > The pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN13LA341](https://openairdocs.org/ntsb/CEN13LA341.md): Air Tractor AT-301 · Farnsworth, TX · Accident · No injuries · Limited investigation · Final report · Jun 9, 2013 · N4421S · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because the postaccident engine examination revealed no anomalies.
- [NTSB CEN13FA324](https://openairdocs.org/ntsb/CEN13FA324.md): Weatherly 620B · Ludlow, SD · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2013 · N350WR · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was task- and/or work-related fatigue.
- [NTSB CEN13LA325](https://openairdocs.org/ntsb/CEN13LA325.md): Robinson Helicopter R22 Beta · New Braunfels, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2013 · N137DF · Substantial damage
  > The pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…
- [NTSB CEN13LA322](https://openairdocs.org/ntsb/CEN13LA322.md): Grumman Acft ENG Cor-Schweizer G-164B · Covington, OK · Accident · No injuries · Limited investigation · Final report · Jun 6, 2013 · N6754Q · Substantial damage
  > The airplane’s failure to climb after takeoff for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA321](https://openairdocs.org/ntsb/CEN13LA321.md): Bell 206-L4 · Abbeville, LA · Accident · No injuries · Limited investigation · Final report · Jun 6, 2013 · N720RL · Substantial damage
  > Failure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.
- [NTSB ERA13WA296](https://openairdocs.org/ntsb/ERA13WA296.md): Extra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, Russia · Accident · 1 fatal · Foreign investigation · Jun 2, 2013 · RA-0327G · Substantial damage
- [NTSB CEN13CA336](https://openairdocs.org/ntsb/CEN13CA336.md): Schempp-Hirth VENTUS-2B · Corona, NM · Accident · Minor injuries · Data collection · Final report · Jun 2, 2013 · N62TW · Substantial damage
  > The pilot's failure to maintain aircraft control while ridge-soaring in gusty wind conditions.
- [NTSB WPR13FA254](https://openairdocs.org/ntsb/WPR13FA254.md): Piper PA-28-181 · Anthem, AZ · Accident · 4 fatal · Field investigation · Final report · May 31, 2013 · N327PA · 2 aircraft · Substantial damage
  > The failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.
- [NTSB ERA13FA259](https://openairdocs.org/ntsb/ERA13FA259.md): Diamond Aircraft Ind DA 20-C1 · Linden, NJ · Accident · 1 fatal · Field investigation · Final report · May 31, 2013 · N176MA · Substantial damage
  > The flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…
- [NTSB WPR13LA248](https://openairdocs.org/ntsb/WPR13LA248.md): Air Tractor AT-301 · Wheatland, WY · Accident · No injuries · Limited investigation · Final report · May 24, 2013 · N23647 · Substantial damage
  > A loss of engine power due to fuel exhaustion and the pilot's inadequate fuel planning.

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

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

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