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

## Cases, newest first

- [NTSB WPR15WA211](https://openairdocs.org/ntsb/WPR15WA211.md): Amature Built Pitts · Maitland, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jul 8, 2015 · VH-JDZ · Destroyed
  > On July 8, 2015, at 1641 local time, an amateur built Pitts 12, VH-JDZ, collided with terrain near Maitland, Australia and was destroyed by postimpact fire. The pilot, the sole occupant, was fatally injured. The airplane was being operated under the pertinent…
- [NTSB CEN15LA303](https://openairdocs.org/ntsb/CEN15LA303.md): Aviat A-1C-180 · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Jul 5, 2015 · N354BM · Substantial damage
  > The pilot’s inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN15CA293](https://openairdocs.org/ntsb/CEN15CA293.md): Cessna A188B · Crawfordsville, IN · Accident · Serious injuries · Data collection · Final report · Jul 5, 2015 · N625EH · Substantial damage
  > The pilot's failure to maintain clearance from the powerline during an aerial application operations.
- [NTSB CEN15FA291](https://openairdocs.org/ntsb/CEN15FA291.md): Champion 7BCM · Portland, TX · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2015 · N10497 · Substantial damage
  > The pilot’s ostentatious low-altitude aerobatic display, which resulted in an aerodynamic stall/spin when he exceeded the airplane’s critical angle of attack. Contributing to the accident was the pilot’s impairment due to alcohol and drugs.
- [NTSB CEN15CA312](https://openairdocs.org/ntsb/CEN15CA312.md): Eurocopter EC 130 B4 · Somerset, CO · Accident · No injuries · Data collection · Final report · Jul 3, 2015 · N974BR · Substantial damage
  > The pilot's decision to fly at a low altitude when he was aware that there were wires in the area which resulted in the helicopter contacting a wire.
- [NTSB GAA15CA196](https://openairdocs.org/ntsb/GAA15CA196.md): Robinson Helicopter R44 II · Forest City, SD · Accident · No injuries · Data collection · Final report · Jul 2, 2015 · N824DK · Substantial damage
  > The pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.
- [NTSB WPR15FA204](https://openairdocs.org/ntsb/WPR15FA204.md): Hughes 269C · Asotin, WA · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2015 · N9490F · Destroyed
  > The pilot's failure to maintain adequate clearance from power lines while maneuvering in a canyon.
- [NTSB WPR15FA200](https://openairdocs.org/ntsb/WPR15FA200.md): Maniscalco Great Lakes · Corona, CA · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2015 · N7LM · Destroyed
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while maneuvering, which resulted in a stall/spin at too low an altitude to allow recovery. Contributing to the accident was the pilot's improper…
- [NTSB CEN15LA297](https://openairdocs.org/ntsb/CEN15LA297.md): Piper PA 25-235 · Galveston, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2015 · N94MC · Substantial damage
  > The loss of engine power due to a failure of a crankshaft idler gear shaft.
- [NTSB CEN15FA282](https://openairdocs.org/ntsb/CEN15FA282.md): Christen Industries Pitts S-2B · Cameron, MO · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2015 · N877UP · Substantial damage
  > The pilot’s failure to maintain airplane control during a low-level aerobatic flight maneuver.
- [NTSB GAA15CA154](https://openairdocs.org/ntsb/GAA15CA154.md): Robinson Helicopter R22 Beta · Eagle Lake, TX · Accident · No injuries · Data collection · Final report · Jun 25, 2015 · N842SH · Substantial damage
  > The pilot's failure to secure the iPad during flight, resulting in an inadvertent cyclic input, and collision with terrain.
- [NTSB GAA15CA141](https://openairdocs.org/ntsb/GAA15CA141.md): Schweizer SGS 2 32 · Middlefield, OH · Accident · No injuries · Data collection · Final report · Jun 25, 2015 · N275P · Substantial damage
  > The student pilot's incorrect pitch and roll rate control inputs which resulted in an aerodynamic stall and incipient spin at a low altitude.
- [NTSB WPR15FA195](https://openairdocs.org/ntsb/WPR15FA195.md): Short Brothers S312 Tucano T MK1 · Maricopa, CA · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2015 · N206PZ · Destroyed
  > The pilot's failure to maintain clearance from terrain during low-level airwork, which resulted in uncontrolled collision with terrain. Contributing to the accident was the pilot's impairment from the combined effects of butalbital and codeine.
- [NTSB CEN15LA285](https://openairdocs.org/ntsb/CEN15LA285.md): Robinson Helicopter R44 II · Danville, AR · Accident · No injuries · Limited investigation · Final report · Jun 21, 2015 · N305CG · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR15LA193](https://openairdocs.org/ntsb/WPR15LA193.md): Bell 47G 5 · Salinas, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 20, 2015 · N4427F · Substantial damage
  > The non-instrument-rated pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control. Contributing to the accident was the pilot's impairment by high-dose opioid use.
- [NTSB WPR15LA185](https://openairdocs.org/ntsb/WPR15LA185.md): Cessna 182A · Moab, UT · Accident · No injuries · Limited investigation · Final report · Jun 14, 2015 · N5143D · Substantial damage
  > The pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15LA272](https://openairdocs.org/ntsb/CEN15LA272.md): Weatherly 620A · Van Horn, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 2015 · N4659N · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN15LA271](https://openairdocs.org/ntsb/CEN15LA271.md): Grumman Acft ENG Cor-Schweizer G 164B · Foster, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 2015 · N48687 · Substantial damage
  > The total loss of engine power during a low-level aerial application flight due to fuel exhaustion following the pilot’s inadequate preflight inspection that led to his assumption that sufficient fuel was on board for the flight based on his reliance on a…
- [NTSB GAA15CA109](https://openairdocs.org/ntsb/GAA15CA109.md): Kretsinger Bensen B8M · Maple Plain, MN · Accident · Minor injuries · Data collection · Final report · Jun 7, 2015 · N2436 · Substantial damage
  > The pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.
- [NTSB CEN15WA260](https://openairdocs.org/ntsb/CEN15WA260.md): Vans RV-7A · Zagreb, Croatia · Accident · 2 fatal · Foreign investigation · Jun 7, 2015 · 9A-DVM · Destroyed
  > On June 7, 2015, at 1430 coordinated universal time, a Van's Aircraft RV-7A, Croatian registered 9A-DVM, owned and piloted by the accident pilot, was destroyed when it impacted terrain near Zagreb, Croatia. Visual meteorological conditions prevailed at the…
- [NTSB ERA15WA246](https://openairdocs.org/ntsb/ERA15WA246.md): Piper PA-25-235 · Patrocínio Municipality,Minas Gerais, Brazil · Accident · 1 fatal · Foreign investigation · Jun 5, 2015 · PR-ACH · Substantial damage
  > On June 5, 2015, about 1506 universal coordinated time, Piper PA-25-235, Brazilian registration PR-ACH, was substantially damaged by collision with terrain while maneuvering at low altitude in Patrocinio Municipality, Minas Gerais, Brazil. The Brazilian…
- [NTSB CEN15FA255](https://openairdocs.org/ntsb/CEN15FA255.md): Cub Crafters CC18-180 · Raton, NM · Accident · 2 fatal · Field investigation · Final report · Jun 5, 2015 · N162WR · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA15WA235](https://openairdocs.org/ntsb/ERA15WA235.md): Cessna A188 · Puerto Gaitan, Colombia · Accident · 1 fatal · Foreign investigation · Jun 4, 2015 · HK-1364 · Substantial damage
  > On June 4, 2015, about 1715 coordinated universal time, a Cessna A188, Colombian registration HK-1364, was substantially damaged when it impacted power lines and then terrain during an aerial application flight near Puerto Gaitan, Colombia. The commercial…
- [NTSB WPR15LA176](https://openairdocs.org/ntsb/WPR15LA176.md): Ayres S2R T34 · Blythe, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2015 · N4018Q · Destroyed
  > The 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.
- [NTSB WPR15FA174](https://openairdocs.org/ntsb/WPR15FA174.md): Piper PA 22-135 · Livermore, CA · Accident · 1 fatal · Field investigation · Final report · Jun 2, 2015 · N1348C · Destroyed
  > A loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.
- [NTSB CEN15FA249](https://openairdocs.org/ntsb/CEN15FA249.md): Monnett John T JR Sonex SA · Oshkosh, WI · Accident · 2 fatal · Field investigation · Final report · Jun 2, 2015 · N123SX · Substantial damage
  > The pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…
- [NTSB ANC15LA034](https://openairdocs.org/ntsb/ANC15LA034.md): Piper PA 22 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2015 · N2828P · Substantial damage
  > The pilot's failure to follow the airplane's operating limitations by rapidly opening the throttle, which resulted in a loss of engine power. Contributing to the accident was the pilot's decision to maneuver the airplane at low altitude even though he was not…
- [NTSB WPR15LA178](https://openairdocs.org/ntsb/WPR15LA178.md): Garlick Helicopters UH 1H · Cove, OR · Accident · No injuries · Limited investigation · Final report · May 31, 2015 · N462CC · Substantial damage
  > The failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.
- [NTSB GAA15LA101](https://openairdocs.org/ntsb/GAA15LA101.md): Air Tractor AT 502B · Archer City, TX · Accident · Serious injuries · Limited investigation · Final report · May 31, 2015 · N120TF · Substantial damage
  > The pilot’s failure to maintain adequate clearance from power transmission lines during an aerial application flight.
- [NTSB ERA15WA233](https://openairdocs.org/ntsb/ERA15WA233.md): Vans RV8 · Corropoli, Italy · Accident · 1 fatal · Foreign investigation · May 31, 2015 · I-LOVI · 2 aircraft · Destroyed
  > On May 31, 2015, about 1430 universal coordinated time, a Vans RV8, I-LOVI, and a Vans RV7, I-AMEL, were destroyed after colliding midair and then subsequently colliding with the Adriatic Sea, near Corropoli, Italy. The Italian certificated pilot of the RV8…
- [NTSB WPR15LA170](https://openairdocs.org/ntsb/WPR15LA170.md): Duenas Pulsar III · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · May 29, 2015 · N747N · Substantial damage
  > An elevated oil temperature and subsequent total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA15CA102](https://openairdocs.org/ntsb/GAA15CA102.md): Bell 206 - B11 · Caledonia, MI · Accident · No injuries · Data collection · Final report · May 29, 2015 · N206ED · Substantial damage
  > A loss of tail rotor effectiveness while maneuvering at low altitude, resulting in a collision with trees.
- [NTSB WPR15WA172](https://openairdocs.org/ntsb/WPR15WA172.md): Robinson R22 - Beta · Mitchell, Australia · Accident · 1 fatal · Foreign investigation · May 28, 2015 · VH-HRW · Substantial damage
  > On May 28, 2015 about 1620 local time, a Robinson R-22 helicopter, Australian registration VH-HRW, collided with terrain near Mitchell, Queensland, Australia. The helicopter sustained substantial damage, and the pilot was fatally injured. The investigation is…
- [NTSB WPR15LA168](https://openairdocs.org/ntsb/WPR15LA168.md): Hiller UH 12E · Wasco, CA · Accident · 1 fatal · Limited investigation · Final report · May 27, 2015 · N138HA · Substantial damage
  > An in-flight impact with terrain for reasons that could not be determined based on available evidence.
- [NTSB GAA15CA089](https://openairdocs.org/ntsb/GAA15CA089.md): Cessna 188 · Polson, MT · Accident · No injuries · Data collection · Final report · May 26, 2015 · N53141 · Substantial damage
  > The pilot's failure to maintain airplane pitch, power, and turn coordination while maneuvering at low altitude, resulting in an aerodynamic stall and a collision with terrain.
- [NTSB CEN15LA241](https://openairdocs.org/ntsb/CEN15LA241.md): Garratt Mansfield W IV-P · Hamilton, TX · Accident · No injuries · Limited investigation · Final report · May 25, 2015 · N725HP · Substantial damage
  > The pilot’s decision to continue flight into known severe thunderstorm conditions, which resulted in the loss of engine power during the descent due to the engine’s ingestion of water and ice and a subsequent forced landing.
- [NTSB CEN15FA240](https://openairdocs.org/ntsb/CEN15FA240.md): Yakovlev YAK 52 · Syracuse, KS · Accident · 1 fatal · Field investigation · Final report · May 25, 2015 · N124FS · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB ERA15FA220](https://openairdocs.org/ntsb/ERA15FA220.md): Gulfstream American AA-5A · Rowdy, KY · Accident · 1 fatal · Field investigation · Final report · May 21, 2015 · N26886 · Destroyed
  > The noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN15WA390](https://openairdocs.org/ntsb/CEN15WA390.md): Avions Robin DR400 · Arras, France · Accident · 2 fatal · Foreign investigation · May 21, 2015 · F-GBUP · Destroyed
  > On May 21, 2015 about 1245 UTC, a Robin DR400-140B airplane, French registration F-GBUP, impacted into a cultivated field near the Arras-Roclincourt Airport (LFQD), Arras, France. One pilot and a passenger were killed. Another pilot was seriously injured. The…
- [NTSB GAA15CA081](https://openairdocs.org/ntsb/GAA15CA081.md): Citabria 7GCBC · Winnsboro, SC · Accident · Serious injuries · Data collection · Final report · May 20, 2015 · N50595 · Substantial damage
  > The pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.
- [NTSB ERA15LA218](https://openairdocs.org/ntsb/ERA15LA218.md): Bell 206L-3 · Kearny, NJ · Accident · No injuries · Limited investigation · Final report · May 20, 2015 · N210MH · Substantial damage
  > The deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.
- [NTSB WPR15FA161](https://openairdocs.org/ntsb/WPR15FA161.md): Bellanca 7GCBC · Juntura, OR · Accident · 1 fatal · Field investigation · Final report · May 14, 2015 · N5042P · Substantial damage
  > The pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.
- [NTSB ERA15WA213](https://openairdocs.org/ntsb/ERA15WA213.md): Cessna 182 · Bajo Hondo, Argentina · Accident · 2 fatal · Foreign investigation · May 13, 2015 · LV-CXM · Destroyed
  > On May 13, 2015, about 1835 coordinated universal time (UTC), a Cessna 182, Argentine registration LV-CXM, impacted power lines while maneuvering during an aerial survey flight near Bajo Hondo, Argentina. The pilot and passenger were fatally injured, and the…
- [NTSB CEN15LA231](https://openairdocs.org/ntsb/CEN15LA231.md): Robinson Helicopter R44 II · Columbia, IL · Accident · No injuries · Limited investigation · Final report · May 13, 2015 · N165RV · Substantial damage
  > A total loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.
- [NTSB CEN15LA238](https://openairdocs.org/ntsb/CEN15LA238.md): Piper PA-25-235 · Omega, OK · Accident · No injuries · Limited investigation · Final report · May 11, 2015 · N7279Z · Substantial damage
  > Improper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.
- [NTSB WPR15LA159](https://openairdocs.org/ntsb/WPR15LA159.md): Garlick UH-1B · Kettle Falls, WA · Accident · Minor injuries · Limited investigation · Final report · May 8, 2015 · N46969 · Substantial damage
  > A total loss of engine power due to foreign object (towel) ingestion. Contributing to the accident was maintenance personnel’s inadequate postmaintenance inspection of the engine.
- [NTSB ERA15WA216](https://openairdocs.org/ntsb/ERA15WA216.md): Thrush S2R-T34 · Puebloviejo, Ecuador · Accident · 1 fatal · Foreign investigation · May 5, 2015 · HC-CBY · Substantial damage
  > On May 5, 2015, a Thrush Aircraft, Inc., S2R-T34, Ecuador registration HC-CBY, registered to and operated by Aerovic C.A., collided with terrain near Puebloviejo, Ecuador. Meteorological conditions and flight plan information are unknown for the flight from…
- [NTSB CEN15LA222](https://openairdocs.org/ntsb/CEN15LA222.md): Air Tractor AT 502B · Basile, LA · Accident · 1 fatal · Limited investigation · Final report · May 5, 2015 · N4221G · Destroyed
  > The pilot’ failure to maintain adequate clearance from trees while maneuvering during an aerial application flight.
- [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.

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

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

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