# NTSB investigations, 2016: 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 4 · 177 cases

## Latest cases

- [NTSB ERA17LA075](https://openairdocs.org/ntsb/ERA17LA075.md): Cessna 172 · Bridgeport, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2016 · N3772F · Substantial damage
  > The pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.
- [NTSB ERA17LA070](https://openairdocs.org/ntsb/ERA17LA070.md): Beech A36 · Ormond Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2016 · N410BC · Substantial damage
  > The pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.
- [NTSB ERA17WA079](https://openairdocs.org/ntsb/ERA17WA079.md): Air Tractor AT502 · Primavera do Leste, Brazil · Accident · 1 fatal · Foreign investigation · Dec 13, 2016 · PR-AJF · Destroyed
  > On December 13, 2016, about 1930 coordinated universal time, an Air Tractor AT-502B, Brazilian registration PR-AJF, was destroyed after it impacted terrain and was subject to a postcrash fire, during an agricultural spraying operation near Primavera do Leste,…
- [NTSB WPR17WA039](https://openairdocs.org/ntsb/WPR17WA039.md): Robinson R44 · Juhu, India · Accident · 1 fatal · Foreign investigation · Dec 11, 2016 · VT-PHB · Destroyed
- [NTSB CEN17FA050](https://openairdocs.org/ntsb/CEN17FA050.md): Cub Crafters PA18 · Basin, WY · Accident · 1 fatal · Field investigation · Final report · Dec 7, 2016 · N444GB · Substantial damage
  > The pilot exceeded the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.
- [NTSB ANC17FA009](https://openairdocs.org/ntsb/ANC17FA009.md): Bellanca 7GCBC · Fairbanks, AK · Accident · 1 fatal · Class 3 · Field · Final report · Dec 7, 2016 · N88452 · Substantial damage
  > The pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…
- [NTSB ERA17FA066](https://openairdocs.org/ntsb/ERA17FA066.md): Fairchild SA227 · Camilla, GA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2016 · N765FA · Destroyed
  > The pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.
- [NTSB CEN17WA052](https://openairdocs.org/ntsb/CEN17WA052.md): PZL Bielsko SZD51 · Husbands Bosworth, United Kingdom · Accident · 1 fatal · Foreign investigation · Dec 4, 2016 · G-CSFT · 2 aircraft · Destroyed
  > On December 4, 2016, about 1230 coordinated universal time, a PZL Bielsko SZD-51-1 glider, G-CSFT, and a Cessna 150L airplane, G-CSFC, collided in midair near Husbands Bosworth, Leicestershire, United Kingdom. The glider impacted terrain and the pilot was…
- [NTSB ERA17WA303](https://openairdocs.org/ntsb/ERA17WA303.md): Schempp Hirth VENTUS2C · San Carlos de Bolivar, Argentina · Accident · 1 fatal · Foreign investigation · Dec 3, 2016 · LV-EDB · Substantial damage
  > On December 3, 2016, about 1750 coordinated universal time, a Schempp Hirth Ventus-2C motorized glider, Argentine registration LV-EDB, operated by a private individual, was substantially damaged when it impacted terrain after the left wing detached from the…
- [NTSB WPR17WA026](https://openairdocs.org/ntsb/WPR17WA026.md): Air Tractor AT802 · Trangie, Australia · Accident · 1 fatal · Foreign investigation · Nov 21, 2016 · VH-NIA · Destroyed
- [NTSB WPR17FA021](https://openairdocs.org/ntsb/WPR17FA021.md): Hughes 369 · Pukoo, HI · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2016 · N81GG · Destroyed
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.
- [NTSB WPR17WA022](https://openairdocs.org/ntsb/WPR17WA022.md): Robinson R66 · Winton, New Zealand · Accident · No injuries · Foreign investigation · Nov 14, 2016 · ZK-HAG · Substantial damage
  > On November 14, 2016, at 0230 universal coordinated time, a Robinson R-66, ZK-HAG, operated by Heliops Southland Limited under the pertinent regulations of the government of New Zealand, was substantially damaged after the helicopter experienced a low rotor…
- [NTSB WPR17LA020](https://openairdocs.org/ntsb/WPR17LA020.md): Piper PA 28-235 · Taylor, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 2016 · N9398W · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.
- [NTSB CEN17LA038](https://openairdocs.org/ntsb/CEN17LA038.md): Weatherly 620B · Coleman, TX · Accident · No injuries · Limited investigation · Final report · Nov 12, 2016 · N2035J · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA17FA038](https://openairdocs.org/ntsb/ERA17FA038.md): Quad City Challenger · Crescent City, FL · Accident · 2 fatal · Field investigation · Final report · Nov 9, 2016 · N327SH · Destroyed
  > An abrupt pitch-up maneuver following a descent, which resulted in the in-flight separation of the right wing due to the overload failure of both the forward and aft right wing attachment brackets.
- [NTSB WPR17WA028](https://openairdocs.org/ntsb/WPR17WA028.md): Air Tractor AT502 · Walgett, Australia · Accident · 1 fatal · Foreign investigation · Nov 5, 2016 · VH-LIK · Destroyed
- [NTSB ERA17LA031](https://openairdocs.org/ntsb/ERA17LA031.md): Haddow William H Pitts Special S 1 · New Bern, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 2016 · N27832 · Substantial damage
  > A loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.
- [NTSB CEN17LA033](https://openairdocs.org/ntsb/CEN17LA033.md): North American TB 25N · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Oct 29, 2016 · N25YR · Substantial damage
  > The overstress failure of the landing gear connecting rod and the improper installation of the arresting cables, which allowed the landing gear door to depart in flight and impact the airplane.
- [NTSB ANC17FA003](https://openairdocs.org/ntsb/ANC17FA003.md): Cessna 172 · Palmer, AK · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2016 · N6353E · Substantial damage
  > The student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.
- [NTSB WPR17LA014](https://openairdocs.org/ntsb/WPR17LA014.md): Aerospatiale AS350 · Starbuck, WA · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N369BD · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.
- [NTSB ERA17CA030](https://openairdocs.org/ntsb/ERA17CA030.md): Kolb Fire FLY · West Middlesex, PA · Accident · Minor injuries · Data collection · Final report · Oct 28, 2016 · UNREG · Substantial damage
  > The noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.
- [NTSB CEN17LA099](https://openairdocs.org/ntsb/CEN17LA099.md): Robinson R22 Beta · Asherton, TX · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N522KC · Substantial damage
  > The partial loss of engine power due to the failure of the magneto's internal timing during low-altitude maneuvering.
- [NTSB CEN17LA027](https://openairdocs.org/ntsb/CEN17LA027.md): Air Tractor AT 502B · Hereford, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 2016 · N8525G · Substantial damage
  > The pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.
- [NTSB ERA17FA027](https://openairdocs.org/ntsb/ERA17FA027.md): Nanchang CJ6 · Blackshear, GA · Accident · 1 fatal · Field investigation · Final report · Oct 21, 2016 · N10EB · 2 aircraft · Substantial damage
  > The Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collision
- [NTSB ERA17LA024](https://openairdocs.org/ntsb/ERA17LA024.md): Cessna 172 · Cedar Key, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2016 · N1827Y · Substantial damage
  > A partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…
- [NTSB GAA17CA030](https://openairdocs.org/ntsb/GAA17CA030.md): Air Tractor AT 502 · Paragould, AR · Accident · Minor injuries · Data collection · Final report · Oct 18, 2016 · N4218E · Substantial damage
  > The pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.
- [NTSB ERA17WA021](https://openairdocs.org/ntsb/ERA17WA021.md): Cessna 172 · Peloponnese, Greece · Accident · 2 fatal · Foreign investigation · Oct 16, 2016 · 5B-CLB · Destroyed
  > On October 16, 2016, about 1415 universal coordinated time, a Cessna 172P, Greek registration 5B-CLB, was destroyed when it impacted mountainous terrain while performing a cross-country training flight near Peloponnese, Greece. The Greek certificated…
- [NTSB CEN17FA016](https://openairdocs.org/ntsb/CEN17FA016.md): Makela RV-4 · Oregonia, OH · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2016 · N2626C · Destroyed
  > The pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.
- [NTSB ERA17LA007](https://openairdocs.org/ntsb/ERA17LA007.md): James Bruton Flying Flea · Plymouth, CT · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2016 · N83165 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR17LA002](https://openairdocs.org/ntsb/WPR17LA002.md): Tamarack Helicopters UH-1H · Gila Bend, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2016 · N175SF · Substantial damage
  > The separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.
- [NTSB CEN17LA006](https://openairdocs.org/ntsb/CEN17LA006.md): Cessna 172K · Wilmot, WI · Accident · No injuries · Limited investigation · Final report · Oct 4, 2016 · N46377 · Substantial damage
  > A failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.
- [NTSB CEN17FA005](https://openairdocs.org/ntsb/CEN17FA005.md): Beech D95A · Hitchcock, TX · Accident · 1 fatal · Field investigation · Final report · Oct 4, 2016 · N76S · Destroyed
  > The flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…
- [NTSB ERA17FA001](https://openairdocs.org/ntsb/ERA17FA001.md): Culver PQ 14A · Hickory, NC · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2016 · N4648V · Destroyed
  > The loss of engine power due to carburetor icing. Contributing to the accident was the pilot's use of automobile gasoline, which increased the likelihood of carburetor icing.
- [NTSB ANC16RA074](https://openairdocs.org/ntsb/ANC16RA074.md): Pitts S2 · Seoul, South Korea · Accident · 1 fatal · Foreign investigation · Sep 24, 2016 · HL1161 · Substantial damage
  > On September 24, 2016, about 1132 local time, an Aviat Pitts S-2B airplane, Republic of Korea registration number HL1161, operated by the pilot, was destroyed following an impact with terrain during an airshow at Taean Airfield, Republic of Korea. The pilot…
- [NTSB CEN16WA377](https://openairdocs.org/ntsb/CEN16WA377.md): Piper PA28 · Gödöllo, Pest, Hungary, Hungary · Accident · 4 fatal · Foreign investigation · Sep 18, 2016 · HA-APZ · 2 aircraft · Destroyed
- [NTSB WPR16LA184](https://openairdocs.org/ntsb/WPR16LA184.md): OGG Richard A OGG Glasair I · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2016 · N70GG · Substantial damage
  > The failure of an induction elbow following an engine backfire, which resulted in an in-flight fire and loss of engine power.
- [NTSB WPR16LA181](https://openairdocs.org/ntsb/WPR16LA181.md): Dehavilland DH115 Vampire · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2016 · N4861K · Substantial damage
  > The in-flight failure of the canopy and subsequent loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA16FA316](https://openairdocs.org/ntsb/ERA16FA316.md): Cessna A188 · Alapaha, GA · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2016 · N3547Q · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.
- [NTSB WPR16WA186](https://openairdocs.org/ntsb/WPR16WA186.md): Little Eagle LE500 · Shijiazhuang City, China · Accident · 4 fatal · Foreign investigation · Sep 15, 2016 · B-9246 · Destroyed
  > On September 15, 2016, about 0308 Universal Time, a Little Eagle LE500 single-engine airplane, Chinese registration B-9246, impacted flat terrain about 1,640 feet from the approach end of runway 18, at the Luan Cheng General Aviation Airport, Shijiazhuang…
- [NTSB GAA16CA488](https://openairdocs.org/ntsb/GAA16CA488.md): Robinson Helicopter R44 II · Cedar City, UT · Accident · No injuries · Data collection · Final report · Sep 14, 2016 · N46HF · Substantial damage
  > The flight instructor’s delayed remedial action while providing hover instruction in gusting wind conditions, which resulted in dynamic roll-over.
- [NTSB CEN16FA370](https://openairdocs.org/ntsb/CEN16FA370.md): Piper PA 11 · Arcanum, OH · Accident · 2 fatal · Field investigation · Final report · Sep 14, 2016 · N4910M · Substantial damage
  > The student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.
- [NTSB ANC16FA065](https://openairdocs.org/ntsb/ANC16FA065.md): Hefty Polar Cub · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Sep 11, 2016 · N62905 · Destroyed
  > The pilot's severe impairment from carbon monoxide poisoning in flight, which resulted in a loss of control and a subsequent collision with trees and terrain.
- [NTSB GAA16CA482](https://openairdocs.org/ntsb/GAA16CA482.md): Piper PA18 · Gulkana, AK · Accident · No injuries · Data collection · Final report · Sep 9, 2016 · N13833 · Substantial damage
  > The pilot’s failure to maintain clearance from a tree while maneuvering at low altitude.
- [NTSB GAA16CA480](https://openairdocs.org/ntsb/GAA16CA480.md): Hughes 369 · Peach Orchard, MO · Accident · No injuries · Data collection · Final report · Sep 9, 2016 · N500TN · Substantial damage
  > The helicopter pilot’s failure to maintain sufficient separation between the main rotor blade and a power line during line guard installation, which resulted in an electrical arc to the main rotor.
- [NTSB ERA16CA314](https://openairdocs.org/ntsb/ERA16CA314.md): Quicksilver Manufacturing Sport 2S · Cleveland, GA · Accident · Minor injuries · Data collection · Final report · Sep 9, 2016 · N396DF · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB GAA16CA469](https://openairdocs.org/ntsb/GAA16CA469.md): Rainbow Sky Reach Bushcat · Frankfort, KY · Accident · Minor injuries · Data collection · Final report · Sep 6, 2016 · N2899X · Substantial damage
  > The pilot's exceedance of the airplane's critical angle-of-attack while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB ERA16FA311](https://openairdocs.org/ntsb/ERA16FA311.md): Sikorsky S61 · Palm Bay, FL · Accident · 3 fatal · Field investigation · Final report · Sep 6, 2016 · N805AR · Destroyed
  > A dual loss of engine power for undetermined reasons after the pilot's improper decision to attempt another maneuver after recovering from a perceived compressor stall, rather than returning to the airport.
- [NTSB GAA16CA462](https://openairdocs.org/ntsb/GAA16CA462.md): Air Tractor AT · Hondo, TX · Accident · No injuries · Data collection · Final report · Sep 5, 2016 · N31627 · Substantial damage
  > The pilot’s failure to maintain clearance from an antenna atop a tower while maneuvering at a low altitude and the airplane’s subsequent impact with terrain during an attempted off-airport landing.
- [NTSB ANC16WA064](https://openairdocs.org/ntsb/ANC16WA064.md): Bell 206B · Fox Creek, Canada · Accident · 1 fatal · Foreign investigation · Sep 5, 2016 · C-GHHU · Substantial damage
  > On September 5, 2016, about 1520 mountain daylight time, a Bell 206B helicopter, Canadian registration C-GHHU, impacted terrain during an aerial survey flight subsequent to a power loss about 12 miles southwest of Fox Creek, Alberta, Canada. The helicopter…
- [NTSB CEN16LA353](https://openairdocs.org/ntsb/CEN16LA353.md): Stanton DR-1 · Plain City, OH · Accident · Serious injuries · Limited investigation · Final report · Sep 4, 2016 · N500PY · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?year=2016&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") = 2016
  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=2016

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