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

## Cases, newest first

- [NTSB CEN15WA448](https://openairdocs.org/ntsb/CEN15WA448.md): Pitts S2 · Friesach, Austria · Accident · 1 fatal · Foreign investigation · Aug 30, 2015 · D-EZZT · Destroyed
  > On August 30, 2015, about 1242 UTC, a Pitts S2B airplane, D-EZZT, (s/n 5327), impacted terrain while performing aerobatic maneuvers near Friesach, Austria. The airplane was destroyed and the pilot was fatally injured. This investigation is under the…
- [NTSB ERA15FA331](https://openairdocs.org/ntsb/ERA15FA331.md): Cornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NY · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N18FJ · Destroyed
  > Separation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…
- [NTSB GAA15CA255](https://openairdocs.org/ntsb/GAA15CA255.md): Aviat A-1C-200 · Irwin, ID · Accident · No injuries · Data collection · Final report · Aug 27, 2015 · N63BW · Substantial damage
  > The pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.
- [NTSB CEN15LA389](https://openairdocs.org/ntsb/CEN15LA389.md): Air Tractor AT 502B · Monroe, NE · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 2015 · N61267 · Substantial damage
  > Loss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.
- [NTSB CEN15LA399](https://openairdocs.org/ntsb/CEN15LA399.md): Weatherly 620B · Hancock, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 26, 2015 · N2005C · Destroyed
  > The in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…
- [NTSB CEN15LA384](https://openairdocs.org/ntsb/CEN15LA384.md): Air Tractor AT 602 · Pine Bluff, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 2015 · N3026R · Substantial damage
  > The pilot’s failure to maintain clearance from terrain during an aerial application flight.
- [NTSB ANC15FA066](https://openairdocs.org/ntsb/ANC15FA066.md): Cessna 180 · Kasilof, AK · Accident · 2 fatal · Field investigation · Final report · Aug 23, 2015 · N3043E · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on postaccident examination and testing.
- [NTSB CEN15LA375](https://openairdocs.org/ntsb/CEN15LA375.md): Robinson Helicopter R44 II · Carlos, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 2015 · N445HS · Substantial damage
  > The pilot’s improper decision to turn the helicopter toward a tailwind during an out-of-ground-effect hover, which resulted in a loss of tail rotor effectiveness. Contributing to the accident was the accident and lead pilots’ inadequate preflight risk…
- [NTSB CEN15FA378](https://openairdocs.org/ntsb/CEN15FA378.md): Cessna 172 · Martinville, IL · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2015 · N8265B · Substantial damage
  > The non-certificated pilot's failure to maintain clearance from terrain.
- [NTSB WPR15LA248](https://openairdocs.org/ntsb/WPR15LA248.md): Sikorsky S 61A · Ironside, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2015 · N1043T · Substantial damage
  > A loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…
- [NTSB GAA15CA238](https://openairdocs.org/ntsb/GAA15CA238.md): Robinson Helicopter R22 Beta · Ronkonkoma, NY · Accident · Minor injuries · Data collection · Final report · Aug 19, 2015 · N86EH · Substantial damage
  > The student pilot's loss of control during a hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's lack of action to remediate the student pilot's control inputs and recover aircraft control.
- [NTSB CEN15LA370](https://openairdocs.org/ntsb/CEN15LA370.md): Bell 206B · Cresco, IA · Accident · No injuries · Limited investigation · Final report · Aug 18, 2015 · N5743W · Substantial damage
  > The loss of engine power due to the high-cycle fatigue failure of the third-stage turbine wheel.
- [NTSB CEN15LA367](https://openairdocs.org/ntsb/CEN15LA367.md): Air Tractor AT-802A · Wiville, AR · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2015 · N3070R · Destroyed
  > The pilot's failure to maintain clearance from a utility pole while maneuvering during an agricultural application flight, which resulted in damage to the right aileron and a subsequent uncontrolled right roll at a low altitude.
- [NTSB GAA15CA230](https://openairdocs.org/ntsb/GAA15CA230.md): Bell 412 · Whittier, CA · Accident · Minor injuries · Data collection · Final report · Aug 17, 2015 · N412LA · Substantial damage
  > The pilot's failure to appropriately monitor the helicopter's fuel supply, resulting in fuel exhaustion, loss of engine power, and an autorotation with a hard landing.
- [NTSB CEN15WA364](https://openairdocs.org/ntsb/CEN15WA364.md): MX MX2 · Châteauneuf-sur-Cher, France · Accident · Minor injuries · Foreign investigation · Aug 16, 2015 · N88MX · Destroyed
- [NTSB CEN15LA403](https://openairdocs.org/ntsb/CEN15LA403.md): Cessna 182 · Big Piney, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 2015 · XBYUH · Substantial damage
  > The pilot's failure to maintain adequate altitude while operating over high mountainous terrain, which resulted in an emergency landing after the airplane's encounter with a downdraft.
- [NTSB WPR15LA240](https://openairdocs.org/ntsb/WPR15LA240.md): Stinson SR 9B · Chula Vista, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2015 · N17154 · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s failure to verify the fuel quantity before the flight.
- [NTSB CEN15LA377](https://openairdocs.org/ntsb/CEN15LA377.md): Grumman G 164B · Sac City, IA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2015 · N311AL · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN15RA352](https://openairdocs.org/ntsb/CEN15RA352.md): Dehavilland DHC 2 · Akureyri, Iceland · Accident · 1 fatal · Foreign investigation · Aug 9, 2015 · N610LC · Substantial damage
  > On August 9, 2015, at an unknown time, a De Havilland DHC-2 airplane, United States registration N610LC, was substantially damaged when it impacted mountainous terrain near Akureyri, Iceland. One occupant sustained fatal injuries, and one occupant sustained…
- [NTSB CEN15LA344](https://openairdocs.org/ntsb/CEN15LA344.md): Erickson Larry D RAF 2000 GT · Humboldt, IA · Accident · 1 fatal · Limited investigation · Final report · Aug 9, 2015 · N315LK · Substantial damage
  > The pilot’s loss of gyroplane control while maneuvering at low altitude.
- [NTSB ANC15LA063](https://openairdocs.org/ntsb/ANC15LA063.md): Piper PA 18-150 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2015 · N9265D · Substantial damage
  > Impact with terrain during low-level cruise flight for reasons that could not be determined based on the available information.
- [NTSB ERA15WA305](https://openairdocs.org/ntsb/ERA15WA305.md): Cessna 402B · Vereda Guarigua Cajica, Colombia · Accident · 3 fatal · Foreign investigation · Aug 8, 2015 · HK-4990 · Substantial damage
  > On August 8, 2015, 1505 UTC, a Cessna 402B, HK-4990, registered to and operated by AeroExpress, collided with terrain near Vereda Guarigua Cajica, Cundinamarca, Colombia. Visual meteorological conditions prevailed at the time and flight plan information is…
- [NTSB ERA15WA303](https://openairdocs.org/ntsb/ERA15WA303.md): Cessna U206F · Istra, Russia · Accident · 9 fatal · Foreign investigation · Aug 8, 2015 · RA-67523 · 2 aircraft · Destroyed
  > On August 8, 2015, at 1708 universal coordinated time, a Cessna U206F airplane, Russian registration RA- 67523 registered to a private owner, and a Robinson R44 II helicopter, Russian registration RA- 04383, registered to a private owner, collided while…
- [NTSB CEN15LA398](https://openairdocs.org/ntsb/CEN15LA398.md): Buckeye Dream Macine · Zeeland, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2015 · UNREG · Destroyed
  > The noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.
- [NTSB CEN15LA359](https://openairdocs.org/ntsb/CEN15LA359.md): Aeros Aeros 2 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2015 · N5982V · Substantial damage
  > The ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.
- [NTSB CEN15LA355](https://openairdocs.org/ntsb/CEN15LA355.md): World Spirit · Granbury, TX · Accident · No injuries · Limited investigation · Final report · Aug 7, 2015 · N65XT · Substantial damage
  > The pilot’s failure to use the fuel boost pump following the loss of engine power and the fuel system’s inadequate design, which did not allow for equalization of fuel between the fuel tanks and led to a total loss of engine power due to fuel starvation and…
- [NTSB CEN15CA348](https://openairdocs.org/ntsb/CEN15CA348.md): Robinson R44 · Kansasville, WI · Accident · Minor injuries · Data collection · Final report · Aug 7, 2015 · N20KD · Destroyed
  > The pilot's inability to see and avoid power lines that were low to the ground and a green color that blended with the background crops.
- [NTSB GAA15LA217](https://openairdocs.org/ntsb/GAA15LA217.md): MD Helicopter 369E · Whitefish, MT · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2015 · N43792 · Substantial damage
  > The pilot’s failure to maintain altitude and a level attitude while hovering over water at night during an external load operation, which resulted in the helicopter’s main rotor contacting the surface of the water.
- [NTSB WPR15LA230](https://openairdocs.org/ntsb/WPR15LA230.md): Grumman G164 - B · Princeton, CA · Accident · No injuries · Limited investigation · Final report · Aug 4, 2015 · N48452 · Substantial damage
  > The loss of engine power during an agricultural application flight due to a cylinder failure.
- [NTSB WPR15LA232](https://openairdocs.org/ntsb/WPR15LA232.md): Schleicher ASW 20B · Logan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2015 · N20YZ · Substantial damage
  > The pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.
- [NTSB CEN15LA366](https://openairdocs.org/ntsb/CEN15LA366.md): Cessna 206 · Pecos, TX · Accident · No injuries · Limited investigation · Final report · Aug 2, 2015 · N5033U · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15FA331](https://openairdocs.org/ntsb/CEN15FA331.md): Air Tractor AT 602 · Wilmot, AR · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2015 · N6007N · Substantial damage
  > The pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.
- [NTSB CEN15LA330](https://openairdocs.org/ntsb/CEN15LA330.md): Grumman G-164A · Emmett, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2015 · N963X · Substantial damage
  > The engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…
- [NTSB GAA15CA204](https://openairdocs.org/ntsb/GAA15CA204.md): Airbus AS350-B2 · Tucson, AZ · Accident · Minor injuries · Data collection · Final report · Jul 29, 2015 · N6095U · Substantial damage
  > The flight instructor's misperception of the helicopter's altitude in relation to the runway surface during a low altitude maneuver, resulting in ground impact.
- [NTSB CEN15FA321](https://openairdocs.org/ntsb/CEN15FA321.md): Christensen Steve Wheeler Express · Holland, MN · Accident · 3 fatal · Field investigation · Final report · Jul 28, 2015 · N3FC · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…
- [NTSB WPR15FA222](https://openairdocs.org/ntsb/WPR15FA222.md): Beech F35 · Riverside, CA · Accident · 1 fatal · Field investigation · Final report · Jul 27, 2015 · N988RH · Destroyed
  > The total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…
- [NTSB CEN15FA320](https://openairdocs.org/ntsb/CEN15FA320.md): Beech M35 · Amery, WI · Accident · 4 fatal · Field investigation · Final report · Jul 27, 2015 · N9CB · Destroyed
  > The pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.
- [NTSB ERA15LA289](https://openairdocs.org/ntsb/ERA15LA289.md): Piper PA-28R-180 · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Jul 23, 2015 · N4631J · Substantial damage
  > The undetected fatigue cracks in the engine and nose landing gear (NLG) strut mount assembly, which prevented the proper alignment of the NLG after it was extended and the pilots from being able to maintain directional control after touchdown.
- [NTSB WPR15WA231](https://openairdocs.org/ntsb/WPR15WA231.md): Bell 407 - NO Series · Tifalmin Village Papua New Guinea, Papua New Guinea · Accident · Minor injuries · Foreign investigation · Jul 22, 2015 · P2-HCB · Substantial damage
  > On July 22, 2015, at 1325 local time, a Bell 407, P2-HCB, registered to and operated by Hevilift, experienced a loss of engine power while maneuvering away from a drilling/exploration camp near Tifalmin Village, Papua New Guinea. The helicopter subsequently…
- [NTSB CEN15FA310](https://openairdocs.org/ntsb/CEN15FA310.md): Aeronca 7BCM (L-16A) · Auburn, WY · Accident · 2 fatal · Field investigation · Final report · Jul 22, 2015 · N8362H · Destroyed
  > The pilot's failure to maintain airspeed while turning at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.
- [NTSB WPR15LA219](https://openairdocs.org/ntsb/WPR15LA219.md): Garlick UH1H · Walla Walla, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 2015 · N121PT · Destroyed
  > The helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…
- [NTSB ANC15FA050](https://openairdocs.org/ntsb/ANC15FA050.md): Cessna U206G · Trapper Creek, AK · Accident · 1 fatal · Field investigation · Final report · Jul 20, 2015 · N734VB · Destroyed
  > The pilot's failure to maintain clearance from trees while intentionally maneuvering close to the ground.
- [NTSB WPR15WA224](https://openairdocs.org/ntsb/WPR15WA224.md): Glasair SH-2FT · Wedderburn, Australia · Accident · 1 fatal · Foreign investigation · Jul 19, 2015 · VH-HRG · Substantial damage
  > On July 19, 2015 about 1700 local time, an amateur built Glasair SH-2FT, Australian registration VH-HRG, collided with terrain near Wedderburn, Victoria, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The investigation…
- [NTSB GAA15CA232](https://openairdocs.org/ntsb/GAA15CA232.md): Robinson Helicopter R44 II · Prairie Lea, TX · Accident · Minor injuries · Data collection · Final report · Jul 16, 2015 · N804DF · Substantial damage
  > The pilot's failure to maintain rotor rpm, resulting in an uncontrolled descent and collision with trees.
- [NTSB CEN15LA323](https://openairdocs.org/ntsb/CEN15LA323.md): Cessna 182B · Fults, IL · Accident · No injuries · Limited investigation · Final report · Jul 14, 2015 · N2764G · Destroyed
  > The malfunction of the flap assembly, which resulted in a restriction of aileron control. Contributing to the accident was maintenance personnel’s inadequate inspection of a corroded flap control cable.
- [NTSB ANC15CA051](https://openairdocs.org/ntsb/ANC15CA051.md): Cessna 140 · Homer, AK · Accident · No injuries · Data collection · Final report · Jul 14, 2015 · N72784 · Substantial damage
  > The pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.
- [NTSB GAA15LA131](https://openairdocs.org/ntsb/GAA15LA131.md): Robinson Helicopter R22 Beta · Escalante, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2015 · N441MM · Substantial damage
  > The pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…
- [NTSB ERA15CA262](https://openairdocs.org/ntsb/ERA15CA262.md): Robinson Helicopter R44 · Viola, TN · Accident · No injuries · Data collection · Final report · Jul 12, 2015 · N577AT · Substantial damage
  > The pilot's failure to see and avoid a guy wire, which resulted in contact with the wire and subsequent collision with terrain.
- [NTSB WPR15WA213](https://openairdocs.org/ntsb/WPR15WA213.md): Bell 407 - NO Series · Zhejiang Province, P.R. China, China · Accident · 2 fatal · Foreign investigation · Jul 9, 2015 · B-7723 · Substantial damage
  > On July 9, 2015 at 0225 Universal Coordinated Time, a Bell 407, B-7723, was substantially damaged when it crashed at the Qiandao Lake General Aviation airport, Zhejiang Province P. R. China, while conducting a post-repair hovering test. A total of seven…
- [NTSB GAA15CA171](https://openairdocs.org/ntsb/GAA15CA171.md): Weatherly 620B · Hatch, NM · Accident · No injuries · Data collection · Final report · Jul 9, 2015 · N2034P · Substantial damage
  > The pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.

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

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

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