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

## Cases, newest first

- [NTSB WPR16WA143](https://openairdocs.org/ntsb/WPR16WA143.md): Cessna 150 · New Crown Station, Australia · Accident · 1 fatal · Foreign investigation · Jul 12, 2016 · VH-RXU · Substantial damage
  > On July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…
- [NTSB ERA16LA253](https://openairdocs.org/ntsb/ERA16LA253.md): Bell 429 · Georgetown, DE · Accident · 1 fatal · Limited investigation · Final report · Jul 11, 2016 · N1SP · No damage
  > The emergency response team's failure to ensure that the system operator was secured to the helicopter, which resulted in his fall during the recurrent rescue hoist training operation.
- [NTSB GAA16CA372](https://openairdocs.org/ntsb/GAA16CA372.md): Bell OH 58 · Surprise, AZ · Accident · Minor injuries · Data collection · Final report · Jul 10, 2016 · N588MP · Substantial damage
  > While at a low altitude, the pilot's decision to do an abrupt descending right downwind turn which resulted in flying through his own vortices and an impact with terrain.
- [NTSB ANC16WA043](https://openairdocs.org/ntsb/ANC16WA043.md): Air Tractor AT301 · Rocanville, Canada · Accident · 1 fatal · Foreign investigation · Jul 8, 2016 · C-GCYV · Substantial damage
  > On July 8, 2016, about 2359 Coordinated Universal Time, an Air Tractor AT-301 airplane, C-GCYV, impacted terrain while low-level maneuvering near Rocanville, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…
- [NTSB CEN16LA260](https://openairdocs.org/ntsb/CEN16LA260.md): Air Tractor AT-602 · Kennett, MO · Accident · 1 fatal · Limited investigation · Final report · Jul 7, 2016 · N967JB · Destroyed
  > The pilot's failure to maintain clearance from power lines while maneuvering during the aerial application flight.
- [NTSB DCA16FA199](https://openairdocs.org/ntsb/DCA16FA199.md): Bell 525 · Italy, TX · Accident · 2 fatal · Class 2 · Field · Final report · Jul 6, 2016 · N525TA · Destroyed
  > A severe vibration of the helicopter that led to the crew's inability to maintain sufficient rotor rotation speed (Nr), leading to excessive main rotor blade flapping, subsequent main rotor blade contact with the tail boom, and the resultant in-flight…
- [NTSB ERA16LA244](https://openairdocs.org/ntsb/ERA16LA244.md): Cessna 305 · Narragansett, RI · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N5291G · Substantial damage
  > A total loss of engine power for reasons that could not be determined during a postaccident examination of the airframe and engine.
- [NTSB CEN16FA240](https://openairdocs.org/ntsb/CEN16FA240.md): Aeronca 11AC · Frankenmuth, MI · Accident · 2 fatal · Field investigation · Final report · Jul 3, 2016 · N86078 · Destroyed
  > The pilot's loss of control for undetermined reasons based on available information.
- [NTSB WPR16LA134](https://openairdocs.org/ntsb/WPR16LA134.md): Bell OH 58A · Brawley, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 2016 · N6251G · Substantial damage
  > The engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…
- [NTSB WPR16LA133](https://openairdocs.org/ntsb/WPR16LA133.md): Cessna 172 · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 2016 · N7748U · Substantial damage
  > A loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.
- [NTSB ERA16WA243](https://openairdocs.org/ntsb/ERA16WA243.md): Cessna A188 · Puerto Lopez, Colombia · Accident · 1 fatal · Foreign investigation · Jul 2, 2016 · HK1398 · Destroyed
  > On July 2, 2016, about 1810 coordinated universal time, a Cessna A188, Colombian registration HK1398, operated by Comercializadora de Aviacion Agricola - ECO, was destroyed when it collided with a utility tower near Puerto Lopez, Colombia. The certificated…
- [NTSB ERA16LA242](https://openairdocs.org/ntsb/ERA16LA242.md): Grumman Acft ENG Cor-Schweizer G-164 · Laurel, DE · Accident · No injuries · Limited investigation · Final report · Jul 2, 2016 · N6781K · Substantial damage
  > A total loss of engine power due to an encounter with a bird, which collided with the spray pump fan assembly and subsequently sent blade fragments into the engine compartment, damaging the throttle linkage.
- [NTSB WPR16LA136](https://openairdocs.org/ntsb/WPR16LA136.md): Rans S6 · Bridgeport, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 2016 · N2181K · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack while maneuvering and his improper decision to maneuver low over a home, which resulted in an aerodynamic stall at too low of an altitude to recover.
- [NTSB GAA16CA358](https://openairdocs.org/ntsb/GAA16CA358.md): Cessna 172 · Bountiful, UT · Accident · No injuries · Data collection · Final report · Jul 1, 2016 · N52071 · Substantial damage
  > The pilot's decision to fly into a canyon without sufficient room to reverse course if necessary, which resulted in an emergency landing, loss of directional control, collision with terrain, and a post-crash fire.
- [NTSB CEN16LA247](https://openairdocs.org/ntsb/CEN16LA247.md): Beech E 90 · Longmont, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 2016 · N92DV · Substantial damage
  > The pilot's unintentional activation of the green jump light before the airplane was properly configured and slowed for a jump and the jumpers' improper decision to continue with the jump after they recognized that the airplane was at a higher-than-normal…
- [NTSB WPR16FA131](https://openairdocs.org/ntsb/WPR16FA131.md): Cessna A185F · Coeur d'Alene, ID · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2016 · N4585F · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.
- [NTSB GAA16CA332](https://openairdocs.org/ntsb/GAA16CA332.md): Thrush S2R · Lazbuddie, TX · Accident · No injuries · Data collection · Final report · Jun 23, 2016 · N127PB · Substantial damage
  > The pilot's failure to avoid the metering loop pole during an aerial application.
- [NTSB WPR16LA129](https://openairdocs.org/ntsb/WPR16LA129.md): Burkes BR-1 · Brigham City, UT · Accident · No injuries · Class 3 · Limited · Final report · Jun 22, 2016 · N677DB · Substantial damage
  > A loss of engine power as a result of a failure of the primary and backup ignition system.
- [NTSB GAA16CA339](https://openairdocs.org/ntsb/GAA16CA339.md): Hughes 269B · Princeton, CA · Accident · Minor injuries · Data collection · Final report · Jun 21, 2016 · N941BD · Substantial damage
  > The uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.
- [NTSB CEN16LA222](https://openairdocs.org/ntsb/CEN16LA222.md): North American AT-6D · Henley, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 19, 2016 · N150U · Substantial damage
  > The pilot’s decision to conduct extended inverted flight, which resulted in a total loss of engine power due to fuel flow disruption. Contributing to the accident was his decision to conduct aerobatic maneuvers at low altitude, which precluded him from…
- [NTSB ERA16LA216](https://openairdocs.org/ntsb/ERA16LA216.md): Robinson Helicopter R44 · Chatham, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 2016 · N141TM · Substantial damage
  > The inadequate maintenance of the lower forward clutch actuator bearing for a prolonged period of time, which resulted in a bearing failure. Contributing to the accident was an erroneous maintenance entry, which resulted in the helicopter being operated…
- [NTSB CEN16WA226](https://openairdocs.org/ntsb/CEN16WA226.md): Zivko Aeronautics Edge 540 · Kyviškes, Lithuania · Accident · 1 fatal · Foreign investigation · Jun 16, 2016 · N13VU · Destroyed
- [NTSB ERA16CA227](https://openairdocs.org/ntsb/ERA16CA227.md): Pezetel SZD 48-1JANTAR STD 2 · Maysville, WV · Accident · No injuries · Data collection · Final report · Jun 12, 2016 · N438QA · Substantial damage
  > The glider's encounter with insufficient atmospheric lift conditions where the lift was not sufficient to maintain soaring flight, which resulted in an off-airport landing.
- [NTSB CEN16FA215](https://openairdocs.org/ntsb/CEN16FA215.md): Robinson Helicopter R44 II · Jonesboro, AR · Accident · 1 fatal · Field investigation · Final report · Jun 12, 2016 · N789MR · Destroyed
  > The pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…
- [NTSB GAA16CA312](https://openairdocs.org/ntsb/GAA16CA312.md): Piper PA 28 · Gilmer, TX · Accident · No injuries · Data collection · Final report · Jun 11, 2016 · N6700J · Substantial damage
  > The student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…
- [NTSB ERA16LA209](https://openairdocs.org/ntsb/ERA16LA209.md): WSK PZL Mielec M 18A · Brunswick, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 10, 2016 · N2283M · Destroyed
  > The failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…
- [NTSB ERA16CA214](https://openairdocs.org/ntsb/ERA16CA214.md): Hanson Robert H Pietenpol Aircamper · Dundee, MS · Accident · Minor injuries · Data collection · Final report · Jun 10, 2016 · N67RH · Substantial damage
  > The pilot’s failure to maintain clearance from a power line.
- [NTSB CEN16LA213](https://openairdocs.org/ntsb/CEN16LA213.md): Bell 47G 5 · Laureles, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2016 · N6203N · Substantial damage
  > The pilot's failure to apply additional engine power when he applied collective input, which led to a loss of rotor speed and the exceedance of the helicopter’s performance capability.
- [NTSB GAA16CA296](https://openairdocs.org/ntsb/GAA16CA296.md): Robinson Helicopter R22 · Cahokia/St. Louis, IL · Accident · No injuries · Data collection · Final report · Jun 7, 2016 · N931SH · Substantial damage
  > The flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.
- [NTSB CEN16FA209](https://openairdocs.org/ntsb/CEN16FA209.md): Pruss Richard S Kitfox IV · De Smet, SD · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2016 · N921RP · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.
- [NTSB WPR16FA120](https://openairdocs.org/ntsb/WPR16FA120.md): Rockwell S2R · De Smet, ID · Accident · 1 fatal · Field investigation · Final report · Jun 6, 2016 · N4191X · Substantial damage
  > The pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.
- [NTSB CEN16LA219](https://openairdocs.org/ntsb/CEN16LA219.md): Flohr David J R 80 Tiger Moth · Decatur, TX · Accident · No injuries · Limited investigation · Final report · Jun 6, 2016 · N8CX · Substantial damage
  > A failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.
- [NTSB CEN16LA208](https://openairdocs.org/ntsb/CEN16LA208.md): Air Tractor AT-502 · Ropesville, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2016 · N10325 · Destroyed
  > The pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.
- [NTSB ANC16WA030](https://openairdocs.org/ntsb/ANC16WA030.md): Wag-Aero Super Tri-Pacer · Williston Lake, Canada · Accident · 1 fatal · Foreign investigation · Jun 4, 2016 · CGSMJ · Substantial damage
  > On June 04, 2016, about 1500 Coordinated Universal Time, a Wag-Aero Super Tri-Pacer airplane, CGSMJ, impacted terrain near Williston Lake, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The…
- [NTSB GAA16CA303](https://openairdocs.org/ntsb/GAA16CA303.md): Air Tractor AT 502 · Nicolaus, CA · Accident · No injuries · Data collection · Final report · Jun 1, 2016 · N5091N · Substantial damage
  > The pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.
- [NTSB GAA16CA266](https://openairdocs.org/ntsb/GAA16CA266.md): Cessna 177 · Pine Bluff, AR · Accident · Minor injuries · Data collection · Final report · May 29, 2016 · N29601 · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and her exceedance of the airplane’s critical angle-of-attack during a low-altitude turn, which resulted in an aerodynamic stall.
- [NTSB ERA16WA207](https://openairdocs.org/ntsb/ERA16WA207.md): Piper PA-28-160 · Corumbaiba, Brazil · Accident · 4 fatal · Foreign investigation · May 29, 2016 · PT-CFE · Destroyed
- [NTSB ERA16CA197](https://openairdocs.org/ntsb/ERA16CA197.md): American Champion 7GCBC · Warner, NH · Accident · Serious injuries · Data collection · Final report · May 29, 2016 · N80RK · Substantial damage
  > An encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.
- [NTSB WPR16FA118](https://openairdocs.org/ntsb/WPR16FA118.md): Moore Joseph O Varieze · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · May 28, 2016 · N80681 · Destroyed
  > A total loss of engine power due to fatigue failure of the camshaft drive gear teeth.
- [NTSB CEN16LA193](https://openairdocs.org/ntsb/CEN16LA193.md): Piper PA 18-150 · Cozad, NE · Accident · Minor injuries · Limited investigation · Final report · May 24, 2016 · N4234Z · Substantial damage
  > An in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16WA321](https://openairdocs.org/ntsb/ERA16WA321.md): Vans RV7 · Cordoba, Argentina · Accident · 2 fatal · Foreign investigation · May 19, 2016 · LV-X566 · Destroyed
  > On May 19, 2016, about 2015 coordinated universal time, an experimental, amateur-built Vans RV-7, Argentine registration LV-X566, operated by a private individual, was destroyed when it impacted terrain during aerobatic maneuvers near Cordoba, Argentina. The…
- [NTSB WPR16FA112](https://openairdocs.org/ntsb/WPR16FA112.md): North American AT 6 · Mesa, AZ · Accident · 2 fatal · Field investigation · Final report · May 18, 2016 · N3198G · Destroyed
  > The pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.
- [NTSB CEN16FA188](https://openairdocs.org/ntsb/CEN16FA188.md): Cessna P210N · Sheridan Lake, CO · Accident · 1 fatal · Field investigation · Final report · May 18, 2016 · N6609P · Substantial damage
  > The pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…
- [NTSB ERA16WA205](https://openairdocs.org/ntsb/ERA16WA205.md): Piper PA-25-235 · Unai, Brazil · Accident · No injuries · Foreign investigation · May 17, 2016 · PR-TAC · Substantial damage
  > On May 17, 2016, about 0830 local time, a Piper PA-25-235, Brazilian registration PR-TAC, was substantially damaged when it impacted the ground while crop dusting near Unaí, Minas Gerais, Brazil. The Brazilian pilot was fatally injured. The local aerial…
- [NTSB ERA16FA182](https://openairdocs.org/ntsb/ERA16FA182.md): Greg Connell Pitts S-2SW · Atlanta, GA · Accident · 1 fatal · Field investigation · Final report · May 14, 2016 · N24CD · Destroyed
  > The pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.
- [NTSB CEN16LA181](https://openairdocs.org/ntsb/CEN16LA181.md): Air Tractor AT 502 · West, TX · Accident · 1 fatal · Limited investigation · Final report · May 14, 2016 · N1546Z · Destroyed
  > The pilot’s failure to see and avoid cellular tower guy wires. Contributing to the accident was the pilot’s decision to operate at low altitude.
- [NTSB CEN16LA180](https://openairdocs.org/ntsb/CEN16LA180.md): Grumman Acft ENG Cor-Schweizer G 164B · Lyons Point, LA · Accident · Minor injuries · Limited investigation · Final report · May 11, 2016 · N8362K · Substantial damage
  > A total loss of engine power due to debris contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.
- [NTSB ANC16CA025](https://openairdocs.org/ntsb/ANC16CA025.md): Piper PA 18-150 · McCarthy, AK · Accident · Minor injuries · Data collection · Final report · May 5, 2016 · N5884D · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall from which he could not recover.
- [NTSB GAA16CA213](https://openairdocs.org/ntsb/GAA16CA213.md): Robinson Helicopter R22 · Troutdale, OR · Accident · Minor injuries · Data collection · Final report · May 4, 2016 · N227SH · Substantial damage
  > The flight instructor's failure to monitor outside the helicopter during hover flight, which resulted in a collision with terrain and rollover.
- [NTSB CEN16FA171](https://openairdocs.org/ntsb/CEN16FA171.md): Mcdonnell Douglas Helicopter 369E · Reedsville, WI · Accident · 1 fatal · Field investigation · Final report · May 4, 2016 · N629JK · Substantial damage
  > The failure of the power turbine governor's dual-spool bearing due to a lack of lubrication, which resulted in a complete loss of engine power and subsequent impact with terrain.

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

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

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