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

## Cases, newest first

- [NTSB ERA14FA445](https://openairdocs.org/ntsb/ERA14FA445.md): North American T 28C · Alton, VA · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2014 · N531KG · Destroyed
  > The pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.
- [NTSB CEN14FA506](https://openairdocs.org/ntsb/CEN14FA506.md): Cessna 172R · Okmulgee, OK · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2014 · N2435R · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.
- [NTSB WPR14CA375](https://openairdocs.org/ntsb/WPR14CA375.md): Eurocopter AS 350 B2 · Kahului, Maui, HI · Accident · No injuries · Data collection · Final report · Sep 14, 2014 · N197BH · Substantial damage
  > The pilot's failure to maintain clearance from the cart while hovering. Contributing to the accident was the failure of ground personnel to remove the cart from the helipad.
- [NTSB CEN15WA102](https://openairdocs.org/ntsb/CEN15WA102.md): Boeing PT-17 · San Jose, Guatemala · Accident · No injuries · Foreign investigation · Sep 14, 2014 · TG-JEN · Destroyed
  > On September 14, 2014, at 2314 coordinated universal time, a Boeing PT-17, Guatemalian registration TG-JEN, operated by KEHA S.A., was destroyed when it impacted water while performing aerobatic maneuvers near San Jose, Guatemala. The pilot was not injured.…
- [NTSB WPR14LA394](https://openairdocs.org/ntsb/WPR14LA394.md): Lorentzen Lancair Legacy · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 13, 2014 · N368W · Substantial damage
  > The shearing of mounting bolts that attached the right turbocharger to its mounting bracket during an air race, which resulted in hot exhaust gases leaking into the engine compartment and starting a fire.
- [NTSB WPR14FA369](https://openairdocs.org/ntsb/WPR14FA369.md): Backovich George C G P 5 · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2014 · N501GP · Destroyed
  > The failure of the right wing under normal race loads due to an improper repair of the right wing spar that reduced its structural strength following a previous landing accident.
- [NTSB CEN14CA490](https://openairdocs.org/ntsb/CEN14CA490.md): Buckeye Dream · Monee, IL · Accident · Serious injuries · Data collection · Final report · Sep 8, 2014 · UNREG · Substantial damage
  > The pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.
- [NTSB CEN14LA487](https://openairdocs.org/ntsb/CEN14LA487.md): Robinson Helicopter R44 II · Macedonia, IA · Accident · 1 fatal · Limited investigation · Final report · Sep 6, 2014 · N699TQ · Substantial damage
  > The pilot’s inadequate visual lookout, which resulted in a collision with a static line.
- [NTSB WPR14FA362](https://openairdocs.org/ntsb/WPR14FA362.md): Cessna 177B · Neihart, MT · Accident · 1 fatal · Field investigation · Final report · Sep 2, 2014 · N34880 · Destroyed
  > The pilot's failure to maintain clearance from terrain while maneuvering at low altitude in turbulent conditions over mountainous terrain. Contributing to the accident was the pilot's improper decision to traverse the mountainous area with the airplane over…
- [NTSB CEN14LA472](https://openairdocs.org/ntsb/CEN14LA472.md): Ohlgren Brent E RV-6A · Marshalltown, IA · Accident · No injuries · Limited investigation · Final report · Sep 1, 2014 · N419B · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's misjudgment of the amount of fuel onboard prior to flight.
- [NTSB ERA14LA409](https://openairdocs.org/ntsb/ERA14LA409.md): Cessna A188B · Middleton, TN · Accident · 1 fatal · Limited investigation · Final report · Aug 27, 2014 · N5850G · Substantial damage
  > The pilot’s failure to see and avoid power lines during a low-level aerial application operation.
- [NTSB CEN14FA453](https://openairdocs.org/ntsb/CEN14FA453.md): Cessna 172R · Willoughby Hills, OH · Accident · 4 fatal · Field investigation · Final report · Aug 26, 2014 · N4207P · Destroyed
  > The pilot's failure to maintain control of the airplane while returning to the airport immediately after takeoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall during the turn. Contributing to the…
- [NTSB WPR14CA354](https://openairdocs.org/ntsb/WPR14CA354.md): Robinson Helicopter R22 Beta · Long Beach, CA · Accident · No injuries · Data collection · Final report · Aug 24, 2014 · N341SL · Substantial damage
  > The student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.
- [NTSB ANC14FA068](https://openairdocs.org/ntsb/ANC14FA068.md): Ryan Navion A · Coldfoot, AK · Accident · Serious injuries · Field investigation · Final report · Aug 24, 2014 · N4827K · Substantial damage
  > The pilot’s improper inflight planning and improper decision to deliberately operate the airplane at low altitude in close proximity to obstructions and rising terrain. Contributing to the accident were the pilot’s improper preflight planning and the Federal…
- [NTSB CEN14FA448](https://openairdocs.org/ntsb/CEN14FA448.md): American Champion 7GCBC · Lago Vista, TX · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2014 · N254AC · Destroyed
  > The pilot's decision to fly at a low altitude and his subsequent failure to see and avoid the power lines.
- [NTSB ERA14FA399](https://openairdocs.org/ntsb/ERA14FA399.md): Air Tractor AT-802A · Parsons, TN · Accident · 1 fatal · Field investigation · Final report · Aug 20, 2014 · N802BB · Substantial damage
  > The pilot’s failure to see and avoid trees during a low-level aerial application operation.
- [NTSB ERA14FA396](https://openairdocs.org/ntsb/ERA14FA396.md): Mcdonnell Douglas Helicopter 369E · Northport, AL · Accident · 2 fatal · Field investigation · Final report · Aug 19, 2014 · N444RS · Substantial damage
  > An inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.
- [NTSB CEN14CA442](https://openairdocs.org/ntsb/CEN14CA442.md): Rockwell International S 2R · Kerkhoven, MN · Accident · No injuries · Data collection · Final report · Aug 19, 2014 · N9646A · Substantial damage
  > The pilot failure to see and avoid the guide wire during the aerial application flight.
- [NTSB CEN14CA444](https://openairdocs.org/ntsb/CEN14CA444.md): Hughes 369HS · Saint Peter, MN · Accident · No injuries · Data collection · Final report · Aug 18, 2014 · N369GN · Substantial damage
  > The pilot did not see the wires resulting in the subsequent wire collision.
- [NTSB WPR14FA348](https://openairdocs.org/ntsb/WPR14FA348.md): Cliff Starduster II SA300 · Placerville, CA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2014 · N411TM · Substantial damage
  > The pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions following a partial loss of engine power for reasons that could not be determined, because postaccident examination of the airframe and engine did not reveal…
- [NTSB ERA14LA391](https://openairdocs.org/ntsb/ERA14LA391.md): Let L 23 Super Blanik · Sylacauga, AL · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2014 · N266SE · Substantial damage
  > The student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the student pilot's failure to properly assess her physical condition prior to conducting the flight.
- [NTSB WPR14CA347](https://openairdocs.org/ntsb/WPR14CA347.md): Eipper Formance Mxii · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Aug 16, 2014 · N1624Z · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB CEN14LA480](https://openairdocs.org/ntsb/CEN14LA480.md): Cessna 188 · Hearne, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2014 · N878C · Substantial damage
  > The pilot’s failure to maintain clearance from a crop.
- [NTSB CEN14LA425](https://openairdocs.org/ntsb/CEN14LA425.md): Cessna U206E · Braithwaite, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2014 · N2272X · Substantial damage
  > The pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.
- [NTSB CEN14CA426](https://openairdocs.org/ntsb/CEN14CA426.md): Robinson Helicopter R44 · Lancaster, WI · Accident · No injuries · Data collection · Final report · Aug 13, 2014 · N8343P · Substantial damage
  > The pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during an aerial application flight.
- [NTSB ERA14LA383](https://openairdocs.org/ntsb/ERA14LA383.md): Christen Industries Pitts S · Sarasota, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2014 · N50XV · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the flight instructor's inadequate preflight fuel planning.
- [NTSB CEN14LA423](https://openairdocs.org/ntsb/CEN14LA423.md): Bell 47G 5 · Mansfield, IL · Accident · 1 fatal · Limited investigation · Final report · Aug 12, 2014 · N7089J · Substantial damage
  > The pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.
- [NTSB CEN14LA415](https://openairdocs.org/ntsb/CEN14LA415.md): Bell 47G 2 · Jeanerette, LA · Accident · 1 fatal · Limited investigation · Final report · Aug 10, 2014 · N4690 · Destroyed
  > The pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.
- [NTSB ERA14WA381](https://openairdocs.org/ntsb/ERA14WA381.md): Piper PA-25-260 · Tolima, Colombia · Accident · Serious injuries · Foreign investigation · Aug 8, 2014 · HK1680 · Substantial damage
  > On August 8, 2014, about 2215 coordinated universal time, a Piper PA-25-260, Colombian registration HK1680, was substantially damaged when it impacted terrain near Tolimo, Colombia. The pilot was seriously injured. The local aerial application flight was…
- [NTSB CEN14LA412](https://openairdocs.org/ntsb/CEN14LA412.md): Enstrom F 28F · Tomah, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2014 · N213BL · Substantial damage
  > A loss of engine power due to the malfunction of the No. 4 cylinder intake valve.
- [NTSB WPR14FA330](https://openairdocs.org/ntsb/WPR14FA330.md): David Fitzgerald Zenith · Warren, ID · Accident · 2 fatal · Field investigation · Final report · Aug 5, 2014 · N32FZ · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.
- [NTSB WPR14LA322](https://openairdocs.org/ntsb/WPR14LA322.md): Schweizer G 164B · Tulelake, CA · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2014 · N3627R · Destroyed
  > The pilot's failure to maintain clearance from power lines while maneuvering during low-altitude operations.
- [NTSB CEN14LA401](https://openairdocs.org/ntsb/CEN14LA401.md): Mosquito XE · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Aug 1, 2014 · CF-HEZ · Substantial damage
  > The failure of the retaining assembly on the tail rotor blade, which resulted in the separation of the blade and the subsequent loss of helicopter control.
- [NTSB CEN14CA403](https://openairdocs.org/ntsb/CEN14CA403.md): Robinson Helicopter R44 · Allen, NE · Accident · Minor injuries · Data collection · Final report · Jul 31, 2014 · N7194H · Substantial damage
  > The pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.
- [NTSB CEN14LA398](https://openairdocs.org/ntsb/CEN14LA398.md): Hughes 369D · West Liberty, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 2014 · N89ZC · Substantial damage
  > A total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.
- [NTSB ERA14LA361](https://openairdocs.org/ntsb/ERA14LA361.md): Hiller UH 12E · Wadesboro, NC · Accident · No injuries · Limited investigation · Final report · Jul 26, 2014 · N107HA · Substantial damage
  > A partial loss of engine power due to the failure of the No. 2 engine accessory gearbox bearing for reasons that could not be determined based on the available information.
- [NTSB ERA14LA360](https://openairdocs.org/ntsb/ERA14LA360.md): Ryan Aeronautical ST3KR · Newnan, GA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 2014 · N59418 · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN14LA390](https://openairdocs.org/ntsb/CEN14LA390.md): Bell 206B · Bennet, NE · Accident · No injuries · Limited investigation · Final report · Jul 26, 2014 · N240SJ · Substantial damage
  > A total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.
- [NTSB CEN14CA391](https://openairdocs.org/ntsb/CEN14CA391.md): Continental Copters Tomcat MK5A · Osage, MN · Accident · No injuries · Data collection · Final report · Jul 25, 2014 · N161SH · Substantial damage
  > The total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…
- [NTSB ERA14FA350](https://openairdocs.org/ntsb/ERA14FA350.md): Wilderoder Great Lakes 2TIA · Lillian, AL · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2014 · N47149 · Substantial damage
  > A loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…
- [NTSB WPR14LA308](https://openairdocs.org/ntsb/WPR14LA308.md): Mdhi 369D · Oso, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2014 · N5225C · Substantial damage
  > The pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…
- [NTSB WPR14FA302](https://openairdocs.org/ntsb/WPR14FA302.md): Cessna 172K · Littlefield, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 21, 2014 · N84754 · Destroyed
  > The pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.
- [NTSB WPR14WA304](https://openairdocs.org/ntsb/WPR14WA304.md): Cessna 182 - L · Albury Aerodrome, Australia · Accident · 1 fatal · Foreign investigation · Jul 20, 2014 · VH-TRS · Substantial damage
  > On July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…
- [NTSB WPR14FA303](https://openairdocs.org/ntsb/WPR14FA303.md): Cessna 182L · Sedona, AZ · Accident · 4 fatal · Field investigation · Final report · Jul 20, 2014 · N42474 · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.
- [NTSB ERA14LA346](https://openairdocs.org/ntsb/ERA14LA346.md): Cessna 172N · Elliott Key, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2014 · N737TP · Destroyed
  > The airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.
- [NTSB WPR14CA296](https://openairdocs.org/ntsb/WPR14CA296.md): Bell 47G 2A · Merced, CA · Accident · Serious injuries · Data collection · Final report · Jul 18, 2014 · N47DT · Substantial damage
  > The pilot's failure to adequately monitor the environment to maintain clearance from the power pole guide wire during low level maneuvering.
- [NTSB CEN14CA382](https://openairdocs.org/ntsb/CEN14CA382.md): Gremminger Greg Magni M 16 · Cape Girardeau, MO · Accident · Serious injuries · Data collection · Final report · Jul 17, 2014 · N216MG · Substantial damage
  > The pilot's failure to maintain sufficient altitude while maneuvering which led to a collision with power lines.
- [NTSB ERA14FA339](https://openairdocs.org/ntsb/ERA14FA339.md): Allen Steen Skybolt · Carrollton, GA · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2014 · N849CA · Destroyed
  > An in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.
- [NTSB CEN14CA360](https://openairdocs.org/ntsb/CEN14CA360.md): Robinson Helicopter R44 II · Englewood, CO · Accident · No injuries · Data collection · Final report · Jul 11, 2014 · N69MP · Substantial damage
  > The pilot did not maintain control of the helicopter during the takeoff resulting in low rotor rpm and impact of the fuel trailer during the running landing.
- [NTSB CEN14LA371](https://openairdocs.org/ntsb/CEN14LA371.md): Air Command 532 · Petersburg, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 2014 · UNREG · Substantial damage
  > The noncertificated pilot’s failure to maintain control of the gyroplane following a total loss of engine power due to a loose spark plug.

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

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

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