# NTSB investigations, 2015: 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 1 of 5 · 217 cases

## Latest cases

- [NTSB ANC16LA011](https://openairdocs.org/ntsb/ANC16LA011.md): Cessna 172 · Anchorage, AK · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 2015 · N914CP · Destroyed
  > The pilot's intentional flight into a building.
- [NTSB CEN16LA084](https://openairdocs.org/ntsb/CEN16LA084.md): Schweizer 269C · Warrenton, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2015 · N292B · Destroyed
  > The noninstrument-rated pilot's continued flight into instrument meteorological conditions at night, which resulted in the loss of visual reference to the ground and his subsequent failure to maintain clearance from trees.
- [NTSB GAA16CA102](https://openairdocs.org/ntsb/GAA16CA102.md): Piper PA 18A · Girdwood, AK · Accident · No injuries · Data collection · Final report · Dec 21, 2015 · N2791P · Substantial damage
  > Fuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.
- [NTSB WPR16FA040](https://openairdocs.org/ntsb/WPR16FA040.md): Airbus Helicopters AS350 · Superior, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2015 · N74317 · Substantial damage
  > The pilot's loss of helicopter control in mountainous terrain as the result of operating the helicopter outside the performance envelope of its hydraulic system and encountering the servo transparency phenomenon. Contributing to the accident was the pilot's…
- [NTSB ERA16LA070](https://openairdocs.org/ntsb/ERA16LA070.md): Cirrus Design SR20 · Charles Town, WV · Accident · No injuries · Limited investigation · Final report · Dec 16, 2015 · N614CD · Substantial damage
  > The flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.
- [NTSB GAA16CA082](https://openairdocs.org/ntsb/GAA16CA082.md): Aeronca 7BCM · Reidsville, NC · Accident · No injuries · Data collection · Final report · Dec 13, 2015 · N1316V · Substantial damage
  > The pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.
- [NTSB GAA16CA080](https://openairdocs.org/ntsb/GAA16CA080.md): Aviat A1 · Broadus, MT · Accident · Minor injuries · Data collection · Final report · Dec 13, 2015 · N29712 · Substantial damage
  > The pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.
- [NTSB WPR16FA036](https://openairdocs.org/ntsb/WPR16FA036.md): Barnett Allen S RV7 · Hurricane, UT · Accident · 2 fatal · Class 3 · Field · Final report · Dec 10, 2015 · N307AB · Substantial damage
  > The pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.
- [NTSB CEN16LA058](https://openairdocs.org/ntsb/CEN16LA058.md): Mcdonnell Douglas Helicopter 600N · Angleton, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 2015 · N607BP · Substantial damage
  > A loss of control while hovering for reasons that could not be determined, because postaccident examination revealed no mechanical anomalies or failures that would have precluded normal operation.
- [NTSB CEN16FA054](https://openairdocs.org/ntsb/CEN16FA054.md): Cessna 140 · Keytesville, MO · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2015 · N90123 · Substantial damage
  > The non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…
- [NTSB CEN16WA060](https://openairdocs.org/ntsb/CEN16WA060.md): Sikorsky S92 · Wexford, Ireland · Incident · No injuries · Foreign investigation · Dec 6, 2015 · EI-ICG · No damage
  > On December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…
- [NTSB CEN16FA059](https://openairdocs.org/ntsb/CEN16FA059.md): Cessna 182C · Pattonsburg, MO · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2015 · N8777T · Destroyed
  > The pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.
- [NTSB ANC16WA008](https://openairdocs.org/ntsb/ANC16WA008.md): Robinson R22 · Annaka City, Japan · Accident · 2 fatal · Foreign investigation · Nov 22, 2015 · JA7963 · Destroyed
  > On November 22, 2015, at 0157 coordinated universal time, a Japanese registered Robinson R22 helicopter, JA7963, operated by a private individual, impacted the slope face of a speedway in Annaka City, Gunma Prefecture, Japan. The pilot and sole passenger…
- [NTSB ANC16WA007](https://openairdocs.org/ntsb/ANC16WA007.md): Bell 206 · New Taipei City, Taiwan · Accident · 2 fatal · Foreign investigation · Nov 22, 2015 · B31127 · Destroyed
  > On November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…
- [NTSB CEN16LA043](https://openairdocs.org/ntsb/CEN16LA043.md): Hickham Lancair IV-P · Shawano, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 2015 · N10UU · Substantial damage
  > A total loss of engine power due to a dual magneto failure, as a result of an exceedance of the engine’s operating limitations while maneuvering.
- [NTSB CEN16LA040](https://openairdocs.org/ntsb/CEN16LA040.md): Robinson Helicopter R22 Beta · Sugarland, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 2015 · N7058Z · Substantial damage
  > The overspeed of the main rotor system for reasons that could not be determined based on the available information.
- [NTSB CEN16LA039](https://openairdocs.org/ntsb/CEN16LA039.md): Robinson Helicopter R44 II · Alpine, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2015 · N449MC · Substantial damage
  > The pilot’s failure to maintain adequate rotor speed while maneuvering at low altitude, which resulted in a descent from which he was unable to recover. Contributing to the accident was the pilot's decision to conduct the flight at or near the helicopter's…
- [NTSB CEN16WA041](https://openairdocs.org/ntsb/CEN16WA041.md): Cessna 182 · Parry Sound, Canada · Accident · 2 fatal · Foreign investigation · Nov 10, 2015 · C-GKNZ · Destroyed
  > On November 10, 2015, at 0020 universal coordinated time, a Canadian registered Cessna 182H airplane, C-GKNZ, impacted terrain shortly after takeoff from the Parry Sound Area Municipal Airport (CNK4), Parry Sound, Ontario, Canada. The pilot and passenger were…
- [NTSB ERA16FA031](https://openairdocs.org/ntsb/ERA16FA031.md): Flight Design Ctls · Queens, NY · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2015 · N622BT · Substantial damage
  > The noninstrument-rated pilot's spatial disorientation and subsequent loss of airplane control while maneuvering at low altitude, over water with no visible horizon, in dark night conditions, which resulted in a collision with the water.
- [NTSB CEN16LA031](https://openairdocs.org/ntsb/CEN16LA031.md): American Autogyro Sparrowhawk · Wakeman, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 2015 · N80825 · Substantial damage
  > A loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR16LA021](https://openairdocs.org/ntsb/WPR16LA021.md): MD Helicopter 369D · Sedro-Woolley, WA · Accident · No injuries · Limited investigation · Final report · Nov 3, 2015 · N510PA · Substantial damage
  > The loss of engine power due to fuel starvation as a result of naphthenate fuel contamination, which blocked the fuel flow through the start pump.
- [NTSB CEN16LA027](https://openairdocs.org/ntsb/CEN16LA027.md): Bell 407 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Nov 3, 2015 · N496AE · Substantial damage
  > The failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…
- [NTSB WPR16LA020](https://openairdocs.org/ntsb/WPR16LA020.md): Bell 206B · Dallas, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2015 · N22743 · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB DCA16RA014](https://openairdocs.org/ntsb/DCA16RA014.md): Bell Helicopter Textron 609 · Tronzano Vercellese, Italy · Accident · 2 fatal · Foreign investigation · Oct 30, 2015 · N609AG · Destroyed
  > import
- [NTSB GAA16CA027](https://openairdocs.org/ntsb/GAA16CA027.md): Cessna A188A · Elberta, UT · Accident · No injuries · Data collection · Final report · Oct 24, 2015 · N4401Q · Substantial damage
  > The pilot's failure to compensate for wind while maneuvering at a low altitude, resulting in a collision with terrain and a postcrash fire.
- [NTSB WPR16LA016](https://openairdocs.org/ntsb/WPR16LA016.md): Cessna 310C · Primm, NV · Accident · No injuries · Limited investigation · Final report · Oct 23, 2015 · N310CD · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…
- [NTSB GAA16CA026](https://openairdocs.org/ntsb/GAA16CA026.md): Rans S-7 · Gerlach, NV · Accident · No injuries · Data collection · Final report · Oct 21, 2015 · N272X · Substantial damage
  > The pilot's failure to maintain pitch and airspeed control, in conjunction with full flaps, while maneuvering at a low altitude, resulting in a tail-stall and subsequent impact with the ground.
- [NTSB CEN16LA015](https://openairdocs.org/ntsb/CEN16LA015.md): Bobby Martin Autogyro MTO Sport · Wallisville, TX · Accident · No injuries · Limited investigation · Final report · Oct 17, 2015 · N3232Z · Substantial damage
  > Fracture of the pusher propeller blade due to impact damage from an unknown object while in flight, which resulted in a severe vibration and a loss of thrust.
- [NTSB CEN16FA014](https://openairdocs.org/ntsb/CEN16FA014.md): Zidek Vans RV-4 · Cortland, NE · Accident · 2 fatal · Field investigation · Final report · Oct 17, 2015 · N999ZF · Destroyed
  > The pilot's decision to intentionally maneuver at a low altitude and his failure to maintain adequate airspeed during the climbing right turn, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA16LA015](https://openairdocs.org/ntsb/ERA16LA015.md): Bell 206L 3 · Dickinson, AL · Accident · No injuries · Limited investigation · Final report · Oct 15, 2015 · N206CJ · Substantial damage
  > The improper installation by company maintenance personnel of the securing hardware of a tail rotor driveshaft section, which resulted in that section of tail rotor driveshaft disconnecting and a complete loss of tail rotor thrust.
- [NTSB ERA16LA008](https://openairdocs.org/ntsb/ERA16LA008.md): Cessna 172S · Seville, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 10, 2015 · N5295Y · Substantial damage
  > The airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.
- [NTSB ANC16FA001](https://openairdocs.org/ntsb/ANC16FA001.md): Cessna 150F · Big Lake, AK · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2015 · N7064 · Substantial damage
  > 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 at too low an altitude to allow recovery.
- [NTSB WPR16FA002](https://openairdocs.org/ntsb/WPR16FA002.md): Cessna 152 · Cedar City, UT · Accident · 2 fatal · Field investigation · Final report · Oct 5, 2015 · N6449M · Destroyed
  > The failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.
- [NTSB CEN16LA004](https://openairdocs.org/ntsb/CEN16LA004.md): Cessna 150 · Dexter, MO · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2015 · N3174J · Substantial damage
  > The pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.
- [NTSB CEN16LA003](https://openairdocs.org/ntsb/CEN16LA003.md): Bell 47G · Huntsville, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2015 · N160CS · Substantial damage
  > The pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.
- [NTSB CEN16WA010](https://openairdocs.org/ntsb/CEN16WA010.md): Piper PA31 · Veracruz, Nicaragua · Accident · 1 fatal · Foreign investigation · Oct 2, 2015 · C-GCMD · Substantial damage
- [NTSB CEN15LA437](https://openairdocs.org/ntsb/CEN15LA437.md): Capella Aircraft Corporation ( FW2TDXLS · Bartlesville, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2015 · N903AB · Substantial damage
  > The pilot’s failure to maintain airplane control after takeoff.
- [NTSB CEN15LA428](https://openairdocs.org/ntsb/CEN15LA428.md): Sukhoi SU-26 · Slidell, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2015 · N596TJ · Destroyed
  > The pilot's attempt to recover from an aerobatic maneuver at too low of an altitude to make a safe recovery.
- [NTSB CEN15FA424](https://openairdocs.org/ntsb/CEN15FA424.md): Beech S35 · Pagosa Springs, CO · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2015 · N193Q · Destroyed
  > Improper engine assembly by unknown maintenance personnel, which resulted in the failure of the No. 6 connecting rod due to oil starvation from the shifting of the crankshaft's No. 4 main bearing.
- [NTSB GAA15LA296](https://openairdocs.org/ntsb/GAA15LA296.md): Bell 206 · Ozark, AL · Accident · No injuries · Limited investigation · Final report · Sep 24, 2015 · N49660 · Substantial damage
  > The pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.
- [NTSB ERA15LA375](https://openairdocs.org/ntsb/ERA15LA375.md): Schempp-Hirth Ventus 2CT · Blacksburg, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2015 · N710JC · Substantial damage
  > A loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.
- [NTSB CEN15LA423](https://openairdocs.org/ntsb/CEN15LA423.md): Bell 206B · Woodville, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2015 · N648CA · Substantial damage
  > The loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…
- [NTSB WPR15LA262](https://openairdocs.org/ntsb/WPR15LA262.md): Graves Bryon S Vans RV-7A · Byron, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 2015 · N507RV · Substantial damage
  > Improper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.
- [NTSB ERA15LA366](https://openairdocs.org/ntsb/ERA15LA366.md): Cessna 172 · Bally, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2015 · N347SP · Substantial damage
  > The pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…
- [NTSB ERA15FA362](https://openairdocs.org/ntsb/ERA15FA362.md): Cessna 150H · Morrisville, NY · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2015 · N22721 · Destroyed
  > The pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…
- [NTSB ERA15LA363](https://openairdocs.org/ntsb/ERA15LA363.md): Cessna 172E · Gettysburg, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2015 · N3647S · Substantial damage
  > The total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's failure to maintain a proper approach speed during the forced landing, which resulted in impact with trees.
- [NTSB ANC15LA073](https://openairdocs.org/ntsb/ANC15LA073.md): Robinson Helicopter R44 · Fort Glenn, AK · Accident · No injuries · Limited investigation · Final report · Sep 19, 2015 · N7162R · Substantial damage
  > The separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.
- [NTSB WPR15LA261](https://openairdocs.org/ntsb/WPR15LA261.md): Schweizer 269C · Forest Grove, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2015 · N290R · Substantial damage
  > A partial loss of engine power during cruise flight 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 GAA15CA266](https://openairdocs.org/ntsb/GAA15CA266.md): Schweizer G 164B · Paxton, NE · Accident · Minor injuries · Data collection · Final report · Sep 16, 2015 · N3628Z · Substantial damage
  > The pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.
- [NTSB ERA15FA359](https://openairdocs.org/ntsb/ERA15FA359.md): Boatright Waylon RV10 · Alma, GA · Accident · 5 fatal · Field investigation · Final report · Sep 16, 2015 · N122WK · Destroyed
  > The noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?year=2015&page=2

## 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 year(c."eventDate") = 2015
  AND 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?year=2015

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