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

## Cases, newest first

- [NTSB CEN15CA218](https://openairdocs.org/ntsb/CEN15CA218.md): Schmidt Donald L GS1 Glastar · Moriarty, NM · Accident · Minor injuries · Data collection · Final report · May 2, 2015 · N993S · Substantial damage
  > The inadvertent encounter with a microburst while maneuvering near mountainous terrain, which resulted in a off airport landing and impact with terrain.
- [NTSB CEN15LA235](https://openairdocs.org/ntsb/CEN15LA235.md): Lathrop Steven A B8M · Ravenna, MI · Accident · Serious injuries · Limited investigation · Final report · May 1, 2015 · N5606X · Destroyed
  > A total loss of engine power due to carburetor icing.
- [NTSB CEN15IA230](https://openairdocs.org/ntsb/CEN15IA230.md): Cessna 152 · Pilot Point, TX · Incident · No injuries · Incident investigation · Final report · Apr 30, 2015 · N49158 · Minor damage
  > The loss of engine power due to the separation of the distributor gear arm on the left magneto.
- [NTSB CEN15FA211](https://openairdocs.org/ntsb/CEN15FA211.md): Hoffman Zenith 701 · Trinidad, CO · Accident · 1 fatal · Field investigation · Final report · Apr 30, 2015 · N95MH · Substantial damage
  > The noncertificated pilot's failure to maintain airspeed following a loss of engine power while maneuvering at a low altitude, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the…
- [NTSB CEN15FA210](https://openairdocs.org/ntsb/CEN15FA210.md): Eurocopter Deutschland MBB BK 117 C-2 · Austin, TX · Accident · 1 fatal · Field investigation · Final report · Apr 28, 2015 · N392TC · No damage
  > The helicopter rescue specialist was not properly attached to the hoist system, which resulted in a fall during a night hoist operation.
- [NTSB DCA15WA115](https://openairdocs.org/ntsb/DCA15WA115.md): Bell UH1H - NO Series · Bainskloof, South Africa · Accident · 2 fatal · Foreign investigation · Apr 22, 2015 · ZU-UHI · Destroyed
  > The government of South Africa has notified the NTSB of an accident involving a BELL UH-1H helicopter that occurred on April 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…
- [NTSB CEN15WA208](https://openairdocs.org/ntsb/CEN15WA208.md): Edge 360 · Norfolk, United Kingdom · Accident · 1 fatal · Foreign investigation · Apr 22, 2015 · G-EDGJ
  > On April 22, 2015, about 1340 coordinated universal time, an Edge 360 airplane, G-EDGJ, impacted terrain while performing aerobatic maneuvers near Norfolk, United Kingdom. The pilot was fatally injured. The accident investigation is under the jurisdiction and…
- [NTSB WPR15LA150](https://openairdocs.org/ntsb/WPR15LA150.md): Cessna 206H · Redding, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 18, 2015 · N3535M · Destroyed
  > The pilot's intentional descent into terrain.
- [NTSB WPR15LA149](https://openairdocs.org/ntsb/WPR15LA149.md): Piper PA 18-150 · La Quinta, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 2015 · N162SC · Substantial damage
  > Maintenance personnel’s failure to properly repair a propeller deformation, which resulted in a fatigue crack, separation of a propeller blade tip, and forced landing onto uneven terrain.
- [NTSB WPR15WA145](https://openairdocs.org/ntsb/WPR15WA145.md): Bell 206 - B · Ziyang City, China, China · Accident · 1 fatal · Foreign investigation · Apr 13, 2015 · B-7607 · Substantial damage
  > On April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…
- [NTSB ERA15WA193](https://openairdocs.org/ntsb/ERA15WA193.md): Cessna 210L · Assuncao do Piaui, Brazil · Accident · 1 fatal · Foreign investigation · Apr 11, 2015 · PR-APG · Destroyed
  > On April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…
- [NTSB WPR15LA142](https://openairdocs.org/ntsb/WPR15LA142.md): Schleicher ASW 27 · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 2015 · N27QV · Substantial damage
  > The glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.
- [NTSB GAA15CA037](https://openairdocs.org/ntsb/GAA15CA037.md): Jabiru Jabiru - SP · Surprise, AZ · Accident · No injuries · Data collection · Final report · Apr 4, 2015 · N593J · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15WA191](https://openairdocs.org/ntsb/CEN15WA191.md): Piper Piper PA-28-140 · Loch Etive, United Kingdom · Accident · 2 fatal · Foreign investigation · Apr 4, 2015 · G-BHXK · Destroyed
  > On April 4, 2015, at an unknown time, a United Kingdom registered Piper PA-28-140 airplane, G-BHXK,impacted mountainous terrain near Lock Etive, Oban, Argyll, and Bute, United Kingdom.The two occupants were fatally injured. The investigation is under the…
- [NTSB CEN15IA200](https://openairdocs.org/ntsb/CEN15IA200.md): Air Tractor AT 402A · Brickeys, AR · Incident · No injuries · Incident investigation · Final report · Apr 4, 2015 · N623LA · Minor damage
  > The in-flight separation of the attachment hardware at the elevator control pushrod due to maintenance personnel's improper reinstallation of the attachment hardware.
- [NTSB WPR15FA140](https://openairdocs.org/ntsb/WPR15FA140.md): Quicksilver Enterprises MXL II · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Apr 3, 2015 · N476VB · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.
- [NTSB GAA15CA032](https://openairdocs.org/ntsb/GAA15CA032.md): Robinson Helicopter R22 Beta · Fort Davis, TX · Accident · No injuries · Data collection · Final report · Apr 3, 2015 · N8363D · Substantial damage
  > The pilot's failure to maintain control of the helicopter during flight, which resulted in the helicopter impacting terrain.
- [NTSB CEN15FA194](https://openairdocs.org/ntsb/CEN15FA194.md): S C Aerostar S A YAK 52TW · Advance, IN · Accident · 1 fatal · Field investigation · Final report · Apr 3, 2015 · N555GD · Destroyed
  > The pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.
- [NTSB ERA15WA180](https://openairdocs.org/ntsb/ERA15WA180.md): Bell 206 - L4 · Diego de Almagro, Chile · Accident · 4 fatal · Foreign investigation · Mar 31, 2015 · CC-APP · Destroyed
  > On March 31, 2015, about 2210 universal coordinated time (UTC), a Bell 206L4, Chilean registration CC-APP, operated by a private individual, was destroyed during a collision with power lines and a subsequent postcrash fire, while maneuvering near Diego de…
- [NTSB ERA15FA173](https://openairdocs.org/ntsb/ERA15FA173.md): Bell Helicopter Textron 206 L-1 · Saucier, MS · Accident · 2 fatal · Field investigation · Final report · Mar 30, 2015 · N50KH · Destroyed
  > A loss of engine power for reasons that could not be determined due to postaccident fire damage.
- [NTSB WPR15LA138](https://openairdocs.org/ntsb/WPR15LA138.md): Hiller UH 12E · Firebaugh, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 2015 · N130HA · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15LA172](https://openairdocs.org/ntsb/ERA15LA172.md): Merian Richard F RV 8 · Tuscaloosa, AL · Accident · No injuries · Class 3 · Limited · Final report · Mar 29, 2015 · N8JL · 2 aircraft · Substantial damage
  > The RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.
- [NTSB CEN15LA175](https://openairdocs.org/ntsb/CEN15LA175.md): Grumman Acft ENG Cor-Schweizer G 164A · New Roads, LA · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 2015 · N9755 · Substantial damage
  > The loss of engine power due to three stuck exhaust valves.
- [NTSB CEN15FA174](https://openairdocs.org/ntsb/CEN15FA174.md): Cessna 182Q · El Paso, TX · Accident · 1 fatal · Field investigation · Final report · Mar 17, 2015 · N735KF · Destroyed
  > The pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.
- [NTSB ERA15LA156](https://openairdocs.org/ntsb/ERA15LA156.md): Kolb Twinstar · Reynolds, GA · Accident · 1 fatal · Limited investigation · Final report · Mar 15, 2015 · N193Y · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…
- [NTSB WPR15CA128](https://openairdocs.org/ntsb/WPR15CA128.md): Enstrom F28 - C · Shelby, MT · Accident · No injuries · Data collection · Final report · Mar 14, 2015 · N5688N · Substantial damage
  > The pilot's failure to maintain main rotor RPM during a low altitude operation, which resulted in a loss of aircraft control and collision with terrain.
- [NTSB ANC15CA012](https://openairdocs.org/ntsb/ANC15CA012.md): Bell 206B · Palmer, AK · Accident · No injuries · Data collection · Final report · Mar 10, 2015 · N86TA · Substantial damage
  > The pilot's failure to maintain control while hovering at a low altitude, which resulted in an impact with frozen lake ice. Contributing to the accident was the pilot's decision to operate the helicopter from the left seat contrary to the rotorcraft flight…
- [NTSB ERA15FA147](https://openairdocs.org/ntsb/ERA15FA147.md): Bellanca 8KCAB · Kosciusko, MS · Accident · 2 fatal · Field investigation · Final report · Mar 8, 2015 · N7698S · Substantial damage
  > The pilot's decision to make a low pass over a lake near trees and his subsequent failure to maintain airplane control while maneuvering at a low altitude to avoid trees, which resulted in an inadvertent cross-control aerodynamic stall from which he was…
- [NTSB WPR15LA126](https://openairdocs.org/ntsb/WPR15LA126.md): Piper PA 18-150 · Merced, CA · Accident · No injuries · Limited investigation · Final report · Mar 7, 2015 · N5385Y · Substantial damage
  > The separation of the flight control stick from the stub due to its improper installation.
- [NTSB CEN15WA450](https://openairdocs.org/ntsb/CEN15WA450.md): Piper PA28 · Witzenhausen, Germany, Germany · Accident · 1 fatal · Foreign investigation · Mar 4, 2015 · D-ERIF · Substantial damage
  > On March 4, 2015, about 0718 UTC, a Piper PA28, German registration D-ERIF, owned by a private individual, was substantially damaged when it impacted heavily wooded terrain near Witzenhausen, Germany, under unknown circumstances. The pilot was fataly injured.…
- [NTSB ERA15LA145](https://openairdocs.org/ntsb/ERA15LA145.md): Cessna 152 · Venice, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 2015 · N498TC · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident testing of the engine revealed no anomalies.
- [NTSB CEN15WA161](https://openairdocs.org/ntsb/CEN15WA161.md): Cirrus SR22 · Ljubljana, Moste, Slovenia, Slovenia · Accident · No injuries · Foreign investigation · Feb 28, 2015 · S5-DJW · Substantial damage
  > The accident investigation is under the jurisdiction and control of the Slovenian government. This report is for information purposes only and contains only information released by or obtained from the Slovenian government. Further information pertaining to…
- [NTSB WPR15LA116](https://openairdocs.org/ntsb/WPR15LA116.md): Bell 47G 2A · Ivanhoe, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 2015 · N4774S · Substantial damage
  > The pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.
- [NTSB CEN15FA154](https://openairdocs.org/ntsb/CEN15FA154.md): Rose Thunder Mustang · Helotes, TX · Accident · 1 fatal · Field investigation · Final report · Feb 25, 2015 · N7TR · Destroyed
  > The pilot’s failure to maintain terrain clearance from terrain after initiating an aerobatic maneuver at a low altitude.
- [NTSB WPR15WA108](https://openairdocs.org/ntsb/WPR15WA108.md): Robinson R44 II · Queenstown, New Zealand, New Zealand · Accident · 2 fatal · Foreign investigation · Feb 19, 2015 · ZK-IPY · Substantial damage
  > On February 19, 2015, at 0244 universal coordinated time, a Robinson R44 II, ZK-IPY, operated by Over the Top Limited, collided with terrain under unknown circumstances near Queenstown, New Zealand. The two occupants on board were fatally injured and the…
- [NTSB WPR15LA109](https://openairdocs.org/ntsb/WPR15LA109.md): Bell/Garlick UH 1H · Shelton, WA · Accident · No injuries · Limited investigation · Final report · Feb 19, 2015 · N166DR · Substantial damage
  > The fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.
- [NTSB ERA15LA133](https://openairdocs.org/ntsb/ERA15LA133.md): Johnson Joel H Rans S-6ES Coyote II · Rincon, PR · Accident · 1 fatal · Limited investigation · Final report · Feb 19, 2015 · N5196W · Substantial damage
  > The inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.
- [NTSB WPR15WA124](https://openairdocs.org/ntsb/WPR15WA124.md): Bell 206 - L4 · Wabo, Papua New Guinea, Papua New Guinea · Accident · No injuries · Foreign investigation · Feb 15, 2015 · P2-HFZ · Substantial damage
  > On February 15, 2015, at 1020 local time, a Bell 206 L4, P2-HFZ, experienced a loss of engine power while maneuvering with an external load and subsequently landed hard near Wabo, Papua New Guinea. The helicopter was operated by Helifax Operations Limited…
- [NTSB WPR15CA107](https://openairdocs.org/ntsb/WPR15CA107.md): Piper PA28 - 180 · Garfield, WA · Accident · No injuries · Data collection · Final report · Feb 15, 2015 · N7928W · Substantial damage
  > The pilot did not maintain clearance from a power line while maneuvering at a low altitude.
- [NTSB CEN15CA153](https://openairdocs.org/ntsb/CEN15CA153.md): Robinson Helicopter R22 Beta · Asherton, TX · Accident · Minor injuries · Data collection · Final report · Feb 15, 2015 · N7181S · Substantial damage
  > The pilot did not maintain adequate clearance from the trees.
- [NTSB ERA15WA131](https://openairdocs.org/ntsb/ERA15WA131.md): Cessna A188 · Tapes, Brazil · Accident · 1 fatal · Foreign investigation · Feb 7, 2015 · PT-LOA · Destroyed
  > On February 7, 2015, about 1100 universal coordinated time, a Cessna A188, Brazilian registration PT-LOA, was destroyed when it struck a high-tension powerline and impacted terrain while maneuvering over a soybean field near Tapes, Brazil. The pilot was…
- [NTSB CEN15WA162](https://openairdocs.org/ntsb/CEN15WA162.md): Hughes 269A · Oresten, Sweden · Accident · No injuries · Foreign investigation · Feb 6, 2015 · N90584 · Substantial damage
- [NTSB ERA15CA120](https://openairdocs.org/ntsb/ERA15CA120.md): Piper PA 18-150 · Brookneal, VA · Accident · Minor injuries · Data collection · Final report · Feb 4, 2015 · N619GB · Substantial damage
  > The flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR15LA096](https://openairdocs.org/ntsb/WPR15LA096.md): Robinson Helicopter R44 II · Calexico, CA · Accident · No injuries · Limited investigation · Final report · Feb 1, 2015 · N510KJ · Substantial damage
  > A partial 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 ERA15CA127](https://openairdocs.org/ntsb/ERA15CA127.md): Schweizer 269C 1 · Carthage, NY · Accident · No injuries · Data collection · Final report · Feb 1, 2015 · N20059 · Substantial damage
  > The non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.
- [NTSB CEN15FA127](https://openairdocs.org/ntsb/CEN15FA127.md): Eagleston John H Vans RV9A · Kingston, OK · Accident · 1 fatal · Field investigation · Final report · Jan 28, 2015 · N708JE · Substantial damage
  > The pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…
- [NTSB DCA15WA054](https://openairdocs.org/ntsb/DCA15WA054.md): Hal Dhruv · Tena, Ecuador · Accident · 3 fatal · Foreign investigation · Jan 27, 2015 · FAE-605 · Destroyed
  > The Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving an Ecuadorian Air Force Hal Dhruv helicopter, which occurred on January 27, 2015. The NTSB has appointed a U.S Accredited Representative to assist. All investigative…
- [NTSB WPR15LA092](https://openairdocs.org/ntsb/WPR15LA092.md): Alexander RV-7 · Seabeck, WA · Accident · 1 fatal · Limited investigation · Final report · Jan 26, 2015 · N747BA · Destroyed
  > A loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.
- [NTSB CEN15LA122](https://openairdocs.org/ntsb/CEN15LA122.md): Cessna 172F · Routt County, CO · Accident · Serious injuries · Limited investigation · Final report · Jan 25, 2015 · N8368U · Substantial damage
  > The pilot’s intentional flight into terrain.
- [NTSB ERA15FA109](https://openairdocs.org/ntsb/ERA15FA109.md): Piper PA-23 · Lakeland, FL · Accident · 2 fatal · Field investigation · Final report · Jan 22, 2015 · N465JA · Destroyed
  > An in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.

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

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

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