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

## Cases, newest first

- [NTSB WPR13LA407](https://openairdocs.org/ntsb/WPR13LA407.md): Mooney M20J · Lund, NV · Accident · No injuries · Limited investigation · Final report · Sep 15, 2013 · N1079K · Substantial damage
  > The pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…
- [NTSB CEN13WA548](https://openairdocs.org/ntsb/CEN13WA548.md): Robinson R44 · Wygonin, Poland · Accident · 3 fatal · Foreign investigation · Sep 13, 2013 · SP-WNP · Destroyed
  > On September 13, 2013, about 0750 coordinated universal time, a Robinson R44 II helicopter, SP-WNP, impacted terrain near Wygonin, Poland. A postimpact fire ensued. The pilot and two passengers were fatally injured and the helicopter was destroyed. The flight…
- [NTSB CEN13CA550](https://openairdocs.org/ntsb/CEN13CA550.md): Piper PA-28-161 · Princeton, MN · Accident · No injuries · Data collection · Final report · Sep 13, 2013 · N526PU · Substantial damage
  > An in-flight collision with a bald eagle.
- [NTSB WPR13CA425](https://openairdocs.org/ntsb/WPR13CA425.md): Cessna M337B · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Sep 12, 2013 · N87653 · Substantial damage
  > The pilot's failure to properly manage fuel which resulted in fuel exhaustion and subsequent loss of power to the forward engine.
- [NTSB ANC13FA095](https://openairdocs.org/ntsb/ANC13FA095.md): Zenith 701 · Big Lake, AK · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2013 · N701MG · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he could not recover.
- [NTSB WPR13FA400](https://openairdocs.org/ntsb/WPR13FA400.md): Cantrell LW Challenger II SP · Prineville, OR · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2013 · N65VG · Substantial damage
  > The in-flight failure of the left elevator control torque tube. Contributing to the accident was the improper assembly of the elevator control torque tubes.
- [NTSB CEN13TA535](https://openairdocs.org/ntsb/CEN13TA535.md): Bell 206L-3 · Amistad, NM · Accident · Minor injuries · Final report · Sep 7, 2013 · N721LL · Substantial damage
  > The pilot's failure to arrest the descent following an abrupt maneuver to avoid birds, which resulted in an impact with terrain.
- [NTSB WPR13FA399](https://openairdocs.org/ntsb/WPR13FA399.md): Tyler Ives SD-1 TG · Spanish Fork, UT · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2013 · N123SD · Destroyed
  > The pilot’s failure to maintain airplane control while performing prohibited aerobatic maneuvers and the deployment and separation of the ballistic parachute system from the airframe for reasons that could not be determined due to the severity of impact…
- [NTSB CEN13LA537](https://openairdocs.org/ntsb/CEN13LA537.md): Continental Copters Tomcat MK5A · Arlington, MN · Accident · No injuries · Limited investigation · Final report · Sep 6, 2013 · N9005T · Substantial damage
  > The pilot’s failure to maintain control of the helicopter while maneuvering when he removed his hand from the collective control while plugging in his radio connection to his helmet, which resulted in the collective moving to the full-down position.
- [NTSB CEN13LA533](https://openairdocs.org/ntsb/CEN13LA533.md): Grumman G-164A · Atlantic, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2013 · N7843 · Destroyed
  > The pilot’s delay in releasing product to reduce the airplane’s weight and improve its climb performance, which was reduced because of the high density altitude.
- [NTSB ANC13FA093](https://openairdocs.org/ntsb/ANC13FA093.md): Cessna 170B · Glennallen, AK · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2013 · N170BN · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and impact with the ground.
- [NTSB ERA13LA410](https://openairdocs.org/ntsb/ERA13LA410.md): Cessna 188B · Woodrow, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2013 · N59JK · Substantial damage
  > A failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.
- [NTSB CEN13FA517](https://openairdocs.org/ntsb/CEN13FA517.md): Robinson R44 II · Caballo, NM · Accident · 3 fatal · Field investigation · Final report · Aug 31, 2013 · N3156U · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.
- [NTSB CEN13LA546](https://openairdocs.org/ntsb/CEN13LA546.md): Brantly B-2B · Rothbury, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 2013 · N2253U · Substantial damage
  > The pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.
- [NTSB ANC13FA090](https://openairdocs.org/ntsb/ANC13FA090.md): Champion 7ECA · Sutton, AK · Accident · 2 fatal · Field investigation · Final report · Aug 29, 2013 · N9624S · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and collision with terrain. Contributing to the accident was the pilot’s use of marijuana, which likely degraded his psychomotor…
- [NTSB WPR13FA388](https://openairdocs.org/ntsb/WPR13FA388.md): American AA-1A · Desert Center, CA · Accident · 2 fatal · Field investigation · Final report · Aug 26, 2013 · N61VT · Substantial damage
  > The pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.
- [NTSB CEN13LA507](https://openairdocs.org/ntsb/CEN13LA507.md): Robinson Helicopter R44 II · Clayton, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2013 · N744KA · Substantial damage
  > The pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.
- [NTSB CEN13CA501](https://openairdocs.org/ntsb/CEN13CA501.md): Mcdonnell Douglas Heli 369FF · Reese, MI · Accident · No injuries · Data collection · Final report · Aug 22, 2013 · N975BW · Substantial damage
  > The failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.
- [NTSB WPR13FA380](https://openairdocs.org/ntsb/WPR13FA380.md): Nelson KR-2 · Cataldo, ID · Accident · 1 fatal · Field investigation · Final report · Aug 19, 2013 · N9028Q · Substantial damage
  > The pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.
- [NTSB WPR13FA376](https://openairdocs.org/ntsb/WPR13FA376.md): Urban Air Sro Samba XXL · Carson City, NV · Accident · 2 fatal · Field investigation · Final report · Aug 16, 2013 · N19UA · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…
- [NTSB CEN13LA493](https://openairdocs.org/ntsb/CEN13LA493.md): Trick Trikes Storm Trooper · Covert, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2013 · N5157G · Substantial damage
  > The student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.
- [NTSB WPR13FA370](https://openairdocs.org/ntsb/WPR13FA370.md): Champion 7GCAA · Paradise, CA · Accident · 2 fatal · Field investigation · Final report · Aug 13, 2013 · N9607S · Destroyed
  > The pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.
- [NTSB WPR13GA374](https://openairdocs.org/ntsb/WPR13GA374.md): Mcdonnell Douglas Helicopter 369E · Burns, OR · Accident · No injuries · Final report · Aug 12, 2013 · N62PJ · Substantial damage
  > The total loss of engine power during cruise flight due to the separation of one of the 4th-stage turbine wheel blades due to low-cycle fatigue cracking that had progressed to high-cycle fatigue cracking, which ultimately led to the overload failure of the…
- [NTSB CEN13LA484](https://openairdocs.org/ntsb/CEN13LA484.md): Rockwell International S-2R · Larchwood, IA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2013 · N5610X · Substantial damage
  > A complete loss of engine power during an agricultural application flight for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA361](https://openairdocs.org/ntsb/ERA13LA361.md): Bryant Frederick M Rans S-12 · Vienna, MD · Accident · No injuries · Limited investigation · Final report · Aug 11, 2013 · N557BB · Substantial damage
  > The student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.
- [NTSB CEN13WA492](https://openairdocs.org/ntsb/CEN13WA492.md): Aerostar International S-55A · Mont-St-Grégoire, Canada · Accident · 1 fatal · Foreign investigation · Aug 11, 2013 · N25QL · No damage
  > On August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…
- [NTSB CEN13LA487](https://openairdocs.org/ntsb/CEN13LA487.md): Bell 206B · Albers, IL · Accident · No injuries · Limited investigation · Final report · Aug 10, 2013 · N804LA · Substantial damage
  > Fuel contamination, which resulted in the loss of engine power.
- [NTSB ANC13CA077](https://openairdocs.org/ntsb/ANC13CA077.md): Aviat A-1B · Arctic Village, AK · Accident · No injuries · Data collection · Final report · Aug 9, 2013 · N286AM · Substantial damage
  > The pilot's failure to maintain clearance from terrain while maneuvering at low altitude.
- [NTSB CEN13LA464](https://openairdocs.org/ntsb/CEN13LA464.md): Piper PA-36-300 · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Aug 6, 2013 · N3789E · Substantial damage
  > The pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…
- [NTSB ANC13LA074](https://openairdocs.org/ntsb/ANC13LA074.md): Hughes 500D · Delta Junction, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 6, 2013 · N134SH · Substantial damage
  > A total loss of engine power for undetermined reasons, which necessitated an emergency hovering autorotation, during which the helicopter impacted trees and terrain.
- [NTSB WPR13LA360](https://openairdocs.org/ntsb/WPR13LA360.md): Versteeg Helicycle · Richland, WA · Accident · No injuries · Limited investigation · Final report · Aug 5, 2013 · N234RV · Substantial damage
  > The pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.
- [NTSB CEN13LA461](https://openairdocs.org/ntsb/CEN13LA461.md): Hughes 369D · Ackerly, TX · Accident · 2 fatal · Limited investigation · Final report · Aug 5, 2013 · N8688F · No damage
  > The pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.
- [NTSB WPR13LA358](https://openairdocs.org/ntsb/WPR13LA358.md): Bell 206B · Chualar, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2013 · N90146 · Substantial damage
  > Maintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.
- [NTSB CEN13LA472](https://openairdocs.org/ntsb/CEN13LA472.md): Air Tractor AT-301 · Simmesport, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2013 · N3655G · Substantial damage
  > The pilot's failure to maintain proper airplane pitch control while maneuvering at an altitude that was too low for recovery.
- [NTSB CEN13WA578](https://openairdocs.org/ntsb/CEN13WA578.md): Cirrus Design SR20 · Poncins, France · Accident · 2 fatal · Class 5 · Foreign · Jul 31, 2013 · F-HCPT · Destroyed
  > On July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…
- [NTSB ERA13LA344](https://openairdocs.org/ntsb/ERA13LA344.md): Hughes 369D · Center Point, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 2013 · N31HM · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA342](https://openairdocs.org/ntsb/ERA13LA342.md): Mooney M20J · Leonardtown, MD · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 2013 · N4570H · Substantial damage
  > The improper installation and inspection of the throttle linkage by maintenance personnel, which resulted in the throttle linkage coming loose and a subsequent partial loss of engine power.
- [NTSB ERA13FA340](https://openairdocs.org/ntsb/ERA13FA340.md): Folland Gnat T 1 · Georgetown, SC · Accident · 1 fatal · Field investigation · Final report · Jul 29, 2013 · N18GT · Destroyed
  > The loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…
- [NTSB CEN13LA444](https://openairdocs.org/ntsb/CEN13LA444.md): Eagle DW-1 · Eagle Lake, MN · Accident · No injuries · Limited investigation · Final report · Jul 29, 2013 · N8803Z · Substantial damage
  > The pilot's misjudgment of tree heights, which resulted in the collision with a tree.
- [NTSB CEN13LA442](https://openairdocs.org/ntsb/CEN13LA442.md): Texas Helicopter OH-13H/M74A · Streator, IL · Accident · No injuries · Limited investigation · Final report · Jul 29, 2013 · N10009 · Substantial damage
  > The pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.
- [NTSB CEN13LA448](https://openairdocs.org/ntsb/CEN13LA448.md): Robinson R44 · Capron, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2013 · N9681R · Substantial damage
  > The pilot's failure to maintain main rotor speed while maneuvering at low altitude during an agricultural application flight, which resulted in an uncontrolled descent into terrain.
- [NTSB CEN13LA439](https://openairdocs.org/ntsb/CEN13LA439.md): Woods Rufus III Vans RV-8A · Lucas, KS · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2013 · N131RP · Destroyed
  > The noninstrument-rated pilot's inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and a subsequent loss of airplane control.
- [NTSB WPR13FA343](https://openairdocs.org/ntsb/WPR13FA343.md): Robinson Helicopter R44 II · Thompson Falls, MT · Accident · 1 fatal · Field investigation · Final report · Jul 27, 2013 · N25WH · Substantial damage
  > The pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.
- [NTSB DCA13CA172](https://openairdocs.org/ntsb/DCA13CA172.md): Nasa Ames Research Center Sierra · Beaufort Sea, AK · Accident · No injuries · Data collection · Final report · Jul 27, 2013 · UNREG · Substantial damage
  > continued operation into engine intake system icing conditions resulting in a loss of power; due to schedule pressure and an insufficient risk management process.
- [NTSB CEN13TA441](https://openairdocs.org/ntsb/CEN13TA441.md): Cessna 182S · Tecumseh, OK · Accident · Serious injuries · Final report · Jul 27, 2013 · N820HP · Substantial damage
  > The pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.
- [NTSB CEN13LA437](https://openairdocs.org/ntsb/CEN13LA437.md): Enstrom F-28A · Danbury, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 2013 · N287Q · Substantial damage
  > The loss of collective control for reasons that could not be determined due to extensive fire damage.
- [NTSB CEN13LA436](https://openairdocs.org/ntsb/CEN13LA436.md): Texas Helicopter OH-13E/M74 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Jul 24, 2013 · N176MR · Substantial damage
  > The pilot’s failure to maintain control of the helicopter during an aerial application maneuver.
- [NTSB WPR13GA338](https://openairdocs.org/ntsb/WPR13GA338.md): Bell HH-1H · Mount Charleston, NV · Accident · 1 fatal · Final report · Jul 23, 2013 · N233JP · No damage
  > The premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.
- [NTSB WPR13LA334](https://openairdocs.org/ntsb/WPR13LA334.md): Eurocopter AS 350 B2 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jul 22, 2013 · N115SH · Substantial damage
  > The pilot receiving instruction's failure to maintain control of the helicopter in a hover, which resulted in a tail rotor ground strike.
- [NTSB ERA13FA330](https://openairdocs.org/ntsb/ERA13FA330.md): Cessna 172M · Fredericksburg, VA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2013 · N61954 · Substantial damage
  > The pilot's intentional descent into the ground to commit suicide.

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

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

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