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

## Cases, newest first

- [NTSB LAX05LA007](https://openairdocs.org/ntsb/LAX05LA007.md): DeRosier DR-107 · San Diego, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 15, 2004 · N31SH · Substantial damage
  > the pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.
- [NTSB ANC05FA008](https://openairdocs.org/ntsb/ANC05FA008.md): Piper PA-18 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2004 · N4126E · Destroyed
  > The pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with water during maneuvering flight. Factors contributing to the accident were fog and low ceilings.
- [NTSB SEA05LA006](https://openairdocs.org/ntsb/SEA05LA006.md): Caldwell Glasair II · Hermiston, OR · Accident · 1 fatal · Limited investigation · Final report · Oct 14, 2004 · N706C · Destroyed
  > The pilot's failure to maintain an airspeed above stall speed while executing a wingover maneuver at the top of a vertical climb, leading to an inadvertent spin, and the pilot's inadequate remedial action in attempting to recover from the spin. Factors…
- [NTSB ATL05CA003](https://openairdocs.org/ntsb/ATL05CA003.md): Bell 206 B · Eutaw, AL · Accident · Minor injuries · Data collection · Final report · Oct 14, 2004 · N300HT · Substantial damage
  > The pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB NYC05CA008](https://openairdocs.org/ntsb/NYC05CA008.md): Hughes 269C · Minerva, OH · Accident · No injuries · Data collection · Final report · Oct 10, 2004 · N7423F · Substantial damage
  > The pilot's failure to maintain control of the helicopter during liftoff.
- [NTSB DFW05CA004](https://openairdocs.org/ntsb/DFW05CA004.md): Schweizer SGS 1-26E · El Paso, TX · Accident · Serious injuries · Data collection · Final report · Oct 8, 2004 · N17911 · Substantial damage
  > The pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.
- [NTSB DEN05FA003](https://openairdocs.org/ntsb/DEN05FA003.md): Cessna A185E · Luna, NM · Accident · 1 fatal · Field investigation · Final report · Oct 3, 2004 · N5964 · Destroyed
  > the pilot's improper use of the mixture control, his failure to maintain clearance from the trees, and his improper preflight planning resulting in his taking off into a canyon and subsequently impacting the trees and terrain. Factors contributing to the…
- [NTSB DEN05FA002](https://openairdocs.org/ntsb/DEN05FA002.md): Sukhoi SU-29 · Santa Fe, NM · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2004 · N92CG · Destroyed
  > the pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…
- [NTSB ATL04LA195](https://openairdocs.org/ntsb/ATL04LA195.md): Cessna 172L · Gadsden, AL · Accident · 2 fatal · Limited investigation · Final report · Sep 29, 2004 · N4336Q · Destroyed
  > The flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.
- [NTSB LAX04CA332](https://openairdocs.org/ntsb/LAX04CA332.md): Bell 222U · Santa Rosa, CA · Accident · No injuries · Data collection · Final report · Sep 28, 2004 · N222UT · Substantial damage
  > the pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.
- [NTSB DEN04LA149](https://openairdocs.org/ntsb/DEN04LA149.md): American Eurocopter AS-350-B3 · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2004 · N497AE · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…
- [NTSB CHI04LA280](https://openairdocs.org/ntsb/CHI04LA280.md): Cessna T210L · Kingman, KS · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2004 · N2027S · Substantial damage
  > The lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…
- [NTSB LAX04FA329](https://openairdocs.org/ntsb/LAX04FA329.md): Bell 206B · Kalaheo, HI · Accident · 5 fatal · Class 1 · Field · Final report · Sep 25, 2004 · N16849 · Destroyed
  > The pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…
- [NTSB CHI04LA279](https://openairdocs.org/ntsb/CHI04LA279.md): Ernst Pitts S2E · Hanover, IN · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 2004 · N8005X · Substantial damage
  > The pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.
- [NTSB ATL04FA190](https://openairdocs.org/ntsb/ATL04FA190.md): Piper PA-32R-301 · Euharlee, GA · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2004 · N801SP · Substantial damage
  > The pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.
- [NTSB SEA04FA191](https://openairdocs.org/ntsb/SEA04FA191.md): Cessna 172D · Mountain Home, ID · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2004 · N2650U · Substantial damage
  > The pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.
- [NTSB LAX04CA323](https://openairdocs.org/ntsb/LAX04CA323.md): Aero Commander S2R · Firebaugh, CA · Accident · No injuries · Data collection · Final report · Sep 18, 2004 · N8822Q · Substantial damage
  > the failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.
- [NTSB DEN04LA145](https://openairdocs.org/ntsb/DEN04LA145.md): Bell 214B-1 · Aspen, CO · Accident · No injuries · Limited investigation · Final report · Sep 17, 2004 · N214B · Substantial damage
  > the inadvertent activation of the engine's fuel shut off valve, resulting in the reduction of engine power to 50 percent due to an improper cannon plug wire repair on the engine's wire harness assembly. Contributing factors include the improper wire repair,…
- [NTSB FTW04TA237](https://openairdocs.org/ntsb/FTW04TA237.md): Bell OH-58C · Beaumont, TX · Accident · 1 fatal · Final report · Sep 16, 2004 · N9273T · Destroyed
  > **This probable cause was modified on 2/22/2016. Please see the public docket for this accident for additional details.** The pilot's failure to maintain a safe altitude, resulting in collision with the water. A factor was the dark night.
- [NTSB MIA04FA135](https://openairdocs.org/ntsb/MIA04FA135.md): Cessna 336 · Magee, MS · Accident · 4 fatal · Field investigation · Final report · Sep 15, 2004 · N3832U · Destroyed
  > The student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.
- [NTSB SEA04FA190](https://openairdocs.org/ntsb/SEA04FA190.md): Cessna U206F · Stanley, ID · Accident · 1 fatal · Field investigation · Final report · Sep 14, 2004 · N20GV · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain aircraft control.
- [NTSB IAD04LA046](https://openairdocs.org/ntsb/IAD04LA046.md): Scott Rans S-12 · Seneca, NY · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 2004 · N195CB · Destroyed
  > The student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.
- [NTSB ANC04LA106](https://openairdocs.org/ntsb/ANC04LA106.md): Cessna 180A · Kasiloff, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 2004 · N5304D · Substantial damage
  > The pilot's improper use of the carburetor heat control which resulted in carburetor ice and the loss of engine power. A factor associated with the accident was the carburetor icing conditions.
- [NTSB ATL04LA177](https://openairdocs.org/ntsb/ATL04LA177.md): Piper PA-23-250 · Lake Wales, FL · Accident · 2 fatal · Limited investigation · Final report · Sep 11, 2004 · N962AB · Substantial damage
  > The pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.
- [NTSB ATL04LA181](https://openairdocs.org/ntsb/ATL04LA181.md): Hughes HU-369-D · Waynesboro, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 2004 · N5211R · Substantial damage
  > The tail rotor assembly failed due to a fatigue fracture of the input gearshaft in the tail rotor gearbox assembly, which resulted in a loss of tail rotor control and subsequent collision with trees.
- [NTSB ATL04LA176](https://openairdocs.org/ntsb/ATL04LA176.md): Lemoine Marvin J. Jr. Christian Eagle II · Cleveland, GA · Accident · 2 fatal · Limited investigation · Final report · Sep 10, 2004 · N83BL · Substantial damage
  > The pilot's failure to maintain clearance from trees while conducting aerobatic maneuvers.
- [NTSB ATL04LA173](https://openairdocs.org/ntsb/ATL04LA173.md): Air Tractor AT-401B · Bainbridge, GA · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 2004 · N3047A · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.
- [NTSB LAX04CA309](https://openairdocs.org/ntsb/LAX04CA309.md): Cessna 172S · Willits, CA · Accident · Minor injuries · Data collection · Final report · Sep 2, 2004 · N897TW · Destroyed
  > the pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…
- [NTSB FTW04LA227](https://openairdocs.org/ntsb/FTW04LA227.md): Grumman 164B · East Bernard, TX · Accident · No injuries · Limited investigation · Final report · Aug 31, 2004 · N8222K · Substantial damage
  > The loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA04FA173](https://openairdocs.org/ntsb/SEA04FA173.md): Beech C35 · Kalispell, MT · Accident · 2 fatal · Field investigation · Final report · Aug 29, 2004 · N63AC · Destroyed
  > The pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.
- [NTSB NYC04FA197](https://openairdocs.org/ntsb/NYC04FA197.md): Robinson R-22 · Northport, NY · Accident · 2 fatal · Field investigation · Final report · Aug 29, 2004 · N871CL · Substantial damage
  > An improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.
- [NTSB LAX04LA305](https://openairdocs.org/ntsb/LAX04LA305.md): Gibbs Kitfox IV · Payson, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 2004 · N728KF · Substantial damage
  > the pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent collision with terrain. Contributing factors to the accident were the turbulence and the gusting wind conditions.
- [NTSB LAX04FA304](https://openairdocs.org/ntsb/LAX04FA304.md): American Champion 8KCAB · Prescott, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2004 · N561ER · 2 aircraft · Destroyed
  > The failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.
- [NTSB ANC04LA098](https://openairdocs.org/ntsb/ANC04LA098.md): de Havilland DHC-3 · McGrath, AK · Accident · 1 fatal · Limited investigation · Final report · Aug 28, 2004 · N197TT · Destroyed
  > The pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.
- [NTSB MIA04LA123](https://openairdocs.org/ntsb/MIA04LA123.md): Bell 206B3 · Panama City, FL · Accident · No injuries · Limited investigation · Final report · Aug 24, 2004 · N107PH · Substantial damage
  > Inadequate maintenance inspection resulting in the partial loss of engine power due to a loose pneumatic line on the governor and ditching of the helicopter.
- [NTSB MIA04LA122](https://openairdocs.org/ntsb/MIA04LA122.md): Robinson R-22 · West Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2004 · N4062X · Substantial damage
  > The partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.
- [NTSB FTW04LA221](https://openairdocs.org/ntsb/FTW04LA221.md): Beech C23 · Shreveport, LA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 2004 · N9714Q · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN04LA130](https://openairdocs.org/ntsb/DEN04LA130.md): Bell 206B3 · Atlantic City, WY · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2004 · N2751U · Substantial damage
  > the pilot's inability to maintain aircraft control, improper in-flight planning and decision making, and failure to compensate for wind conditions, resulting in collision with terrain. Contributing factors were the intentional low-level maneuver, and the wind…
- [NTSB FTW04TA219](https://openairdocs.org/ntsb/FTW04TA219.md): Cessna 182Q · Lamar, OK · Accident · Serious injuries · Final report · Aug 22, 2004 · N10HP · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.
- [NTSB SEA04FA169](https://openairdocs.org/ntsb/SEA04FA169.md): Cessna A185F · Toutle, WA · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2004 · N7562Q · Destroyed
  > The pilot's continued flight into known adverse weather conditions. Inadequate preflight planning/preparation, trees, a low ceiling and no suitable terrain available for the landing were factors.
- [NTSB CHI04LA245](https://openairdocs.org/ntsb/CHI04LA245.md): Fall Cub · Rockville, IN · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 2004 · N25MF · Substantial damage
  > The fuel starvation encountered due to the builder's inadequate fuel system design and the subsequent loss of engine power during a maneuver for the landing approach. Factors were the tree and corn.
- [NTSB SEA04LA168](https://openairdocs.org/ntsb/SEA04LA168.md): Cessna 150L · Angela, MT · Accident · 1 fatal · Limited investigation · Final report · Aug 19, 2004 · N17062 · Destroyed
  > The failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.
- [NTSB SEA04TA163](https://openairdocs.org/ntsb/SEA04TA163.md): Bell 206B · Mead, WA · Accident · 1 fatal · Final report · Aug 17, 2004 · N34698 · Destroyed
  > The reversal of the reel machine during a sock line pull which resulted in a loss of control while hovering out of ground effect. Factors were the failure of company management to develop adequate procedures for conducting sock line pulls, the inadequate…
- [NTSB DEN04LA123](https://openairdocs.org/ntsb/DEN04LA123.md): Cessna 172P · Spanish Fork, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2004 · N6249K · Destroyed
  > the pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.
- [NTSB ANC04LA095](https://openairdocs.org/ntsb/ANC04LA095.md): Piper PA-18-150 · Soldotna, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2004 · N8653Y · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent.
- [NTSB CHI04LA225](https://openairdocs.org/ntsb/CHI04LA225.md): Cessna A188B · Mylo, ND · Accident · 1 fatal · Limited investigation · Final report · Aug 12, 2004 · N92806 · Destroyed
  > The pilot's failure to maintain clearance from the windmill. The windmill was a contributing factor.
- [NTSB SEA04TA158](https://openairdocs.org/ntsb/SEA04TA158.md): Bell 205A1 · Leavenworth, WA · Accident · 1 fatal · Final report · Aug 11, 2004 · N205XP · Destroyed
  > The pilot's failure to maintain clearance from the snag while hovering out of ground effect during an external load operation. Factors were the smoke jumper's misjudgment of the tree heights in the area, which resulted in the use of too short a long line, and…
- [NTSB CHI04LA220](https://openairdocs.org/ntsb/CHI04LA220.md): Allied Ag Cat Productions G-164B · Moville, IA · Accident · 1 fatal · Limited investigation · Final report · Aug 11, 2004 · N48424 · Destroyed
  > The pilot's inadequate in-flight planning/decision by his failure to maintain obstacle clearance. Contributing factors were low altitude flying and the tree.
- [NTSB FTW04LA209](https://openairdocs.org/ntsb/FTW04LA209.md): Schweizer 269C-1 · Denton, TX · Accident · No injuries · Limited investigation · Final report · Aug 9, 2004 · N204LH · Substantial damage
  > The student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight by his delay in taking remedial action.
- [NTSB DEN04FA119](https://openairdocs.org/ntsb/DEN04FA119.md): Cessna 172P · Monarch Crest, CO · Accident · 2 fatal · Field investigation · Final report · Aug 9, 2004 · N911JR · Destroyed
  > the pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.

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

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

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