# NTSB investigations, 2017: 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 · 201 cases

## Latest cases

- [NTSB CEN18FA063](https://openairdocs.org/ntsb/CEN18FA063.md): Cessna 208 · Punta Islita, Costa Rica · Accident · 12 fatal · Field investigation · Final report · Dec 31, 2017 · TI-BEI · Destroyed
  > The flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…
- [NTSB WPR18FA063](https://openairdocs.org/ntsb/WPR18FA063.md): Cessna 172M · Ogden, UT · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2017 · N4395R · Substantial damage
  > The pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.
- [NTSB CEN18LA064](https://openairdocs.org/ntsb/CEN18LA064.md): Pipistrel Doo Ajdovscina Virus SW · Paulding, OH · Accident · No injuries · Limited investigation · Final report · Dec 28, 2017 · N4JW · Substantial damage
  > The loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.
- [NTSB ERA18WA069](https://openairdocs.org/ntsb/ERA18WA069.md): Cessna A188 · Montecristi, Dominican Republic · Incident · No injuries · Foreign investigation · Dec 23, 2017 · HI 907 · Minor damage
  > The government of Dominican Republic has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…
- [NTSB CEN18FA060](https://openairdocs.org/ntsb/CEN18FA060.md): X-Air XA85 · Oskaloosa, IA · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2017 · N20XA · Substantial damage
  > The pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.
- [NTSB WPR18LA050](https://openairdocs.org/ntsb/WPR18LA050.md): Gray Jim Robert Exec · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Dec 17, 2017 · N716JB · Substantial damage
  > Failure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.
- [NTSB GAA18CA073](https://openairdocs.org/ntsb/GAA18CA073.md): Brock Steiner Sport Copter Vortex · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N395SC · Substantial damage
  > The pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.
- [NTSB ERA18FA030](https://openairdocs.org/ntsb/ERA18FA030.md): Mooney M20C · Starke, FL · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2017 · N6894N · Destroyed
  > The pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.
- [NTSB CEN18WA046](https://openairdocs.org/ntsb/CEN18WA046.md): MD Helicopter 369HS · La Morita, Mexico · Accident · 2 fatal · Foreign investigation · Nov 22, 2017 · XC-TIJ · Destroyed
  > On November 22, 2017, about 1437 pacific standard time, a MD Helicopters 369HS single-engine helicopter, serial number 920414S, Mexican registration XC-TIJ, crashed while providing aerial support for police activity near La Morita, Mexico. The pilot and his…
- [NTSB WPR18FA035](https://openairdocs.org/ntsb/WPR18FA035.md): Cessna 152 · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2017 · N24987 · Destroyed
  > The pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.
- [NTSB CEN18LA034](https://openairdocs.org/ntsb/CEN18LA034.md): Ercoupe 415 CD · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Nov 20, 2017 · N3067H · Substantial damage
  > The failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.
- [NTSB CEN18FA035](https://openairdocs.org/ntsb/CEN18FA035.md): Robinson Helicopter R22 Beta · Electra, TX · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2017 · N4179M · Substantial damage
  > The pilot's failure to maintain clearance from powerlines while maneuvering at low altitude.
- [NTSB GAA18CA054](https://openairdocs.org/ntsb/GAA18CA054.md): Quicksilver MXL Sport · Point Mugu, CA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2017 · N7712 · Substantial damage
  > The pilot’s failure to see and avoid power wires.
- [NTSB ERA18WA160](https://openairdocs.org/ntsb/ERA18WA160.md): Piper PA-25-235 · Itapolis, Brazil · Accident · 1 fatal · Foreign investigation · Nov 14, 2017 · PR-AAV · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…
- [NTSB ERA18LA021](https://openairdocs.org/ntsb/ERA18LA021.md): Socata TB200 · Annapolis, MD · Accident · No injuries · Class 2 · Limited · Final report · Nov 10, 2017 · N207GT · Substantial damage
  > A loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.
- [NTSB CEN18FA030](https://openairdocs.org/ntsb/CEN18FA030.md): Temco GC 1B · Pineville, LA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2017 · N2363B · Substantial damage
  > The loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.
- [NTSB WPR18LA029](https://openairdocs.org/ntsb/WPR18LA029.md): Bell 206 · Rolling Fork, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 7, 2017 · N93PH · Substantial damage
  > An uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.
- [NTSB GAA18CA044](https://openairdocs.org/ntsb/GAA18CA044.md): Cessna 172 · Bonners Ferry, ID · Accident · No injuries · Data collection · Final report · Nov 7, 2017 · N55234 · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering at a low altitude.
- [NTSB CEN18LA026](https://openairdocs.org/ntsb/CEN18LA026.md): Hughes 369D · Sulphur, LA · Accident · 2 fatal · Limited investigation · Final report · Nov 7, 2017 · N138WH · No damage
  > The pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.
- [NTSB ANC18FA007](https://openairdocs.org/ntsb/ANC18FA007.md): Icon A5 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · Nov 7, 2017 · N922BA · Substantial damage
  > The pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.
- [NTSB CEN18LA025](https://openairdocs.org/ntsb/CEN18LA025.md): Robinson Helicopter R44 · Larchwood, IA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2017 · N7085M · Substantial damage
  > The pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.
- [NTSB GAA18CA034](https://openairdocs.org/ntsb/GAA18CA034.md): Airbus Helicopters EC 130 · La Paloma, TX · Accident · No injuries · Data collection · Final report · Oct 26, 2017 · N22TZ · Substantial damage
  > The separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.
- [NTSB GAA18CA029](https://openairdocs.org/ntsb/GAA18CA029.md): Six Chuter West Legend XL · Mabton, WA · Accident · Serious injuries · Data collection · Final report · Oct 26, 2017 · N781SC · Substantial damage
  > The pilot’s failure to see and avoid transmission wires.
- [NTSB WPR18FA016](https://openairdocs.org/ntsb/WPR18FA016.md): Robinson R22 · Arlington, WA · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2017 · N8537J · Substantial damage
  > The pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.
- [NTSB ERA18WA029](https://openairdocs.org/ntsb/ERA18WA029.md): Cessna A188 · Sao Felix do Xingu, Brazil · Accident · 1 fatal · Foreign investigation · Oct 24, 2017 · PR-RBA · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on October 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN18LA019](https://openairdocs.org/ntsb/CEN18LA019.md): Air Tractor AT 502B · Olton, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 24, 2017 · N502G · Destroyed
  > The pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.
- [NTSB ERA18WA017](https://openairdocs.org/ntsb/ERA18WA017.md): Cessna 210 · Itaituba, Brazil · Accident · 5 fatal · Foreign investigation · Oct 22, 2017 · PT-ORU · Destroyed
  > On October 22, 2017, about 2105 universal coordinated time, a Cessna 210N, Brazilian registration PT-ORU, operated by a private individual, was destroyed when it collided with terrain following a low altitude maneuver near Itaituba, Brazil. The two foreign…
- [NTSB WPR18FA013](https://openairdocs.org/ntsb/WPR18FA013.md): Flugzeugproduktions-und Vertri EA 300/L · Four Corners, CA · Accident · 2 fatal · Field investigation · Final report · Oct 21, 2017 · N414MT · Destroyed
  > Collision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…
- [NTSB GAA18CA012](https://openairdocs.org/ntsb/GAA18CA012.md): Eurocopter Deutschland MBB BK 117 · Canton, IL · Accident · No injuries · Data collection · Final report · Oct 13, 2017 · N140SF · Substantial damage
  > The flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.
- [NTSB CEN18FA011](https://openairdocs.org/ntsb/CEN18FA011.md): Cessna 172M · Ramsey, MN · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N7CF · Destroyed
  > The pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…
- [NTSB CEN18FA009](https://openairdocs.org/ntsb/CEN18FA009.md): Cessna 182H · Las Cruces, NM · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N8338S · Substantial damage
  > Controlled flight into terrain in dark night conditions.
- [NTSB CEN18FA004](https://openairdocs.org/ntsb/CEN18FA004.md): Aero Vodochody L39C · Vernon, TX · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2017 · N580LL · Destroyed
  > An in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.
- [NTSB ERA18WA009](https://openairdocs.org/ntsb/ERA18WA009.md): Zlin Z50 · Gauteng Province, South Africa · Accident · 1 fatal · Foreign investigation · Oct 6, 2017 · ZS-VAR · Destroyed
  > On October 6, 2017, about 1530 coordinated universal time, a Zlin Z-50L, South African registration ZS-VAR, was destroyed when it impacted terrain shortly after takeoff from Kitty Hawk Airport (FAKT), Gauteng Province, South Africa. The pilot was fatally…
- [NTSB CEN18WA005](https://openairdocs.org/ntsb/CEN18WA005.md): Piper PA25 · Cerro de Ortega, Mexico · Accident · 1 fatal · Foreign investigation · Oct 5, 2017 · XB-DLL · Substantial damage
- [NTSB ERA18FA004](https://openairdocs.org/ntsb/ERA18FA004.md): Cessna 401 · Salters, SC · Accident · 2 fatal · Field investigation · Final report · Oct 4, 2017 · N401HH · Destroyed
  > The pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…
- [NTSB CEN18FA001](https://openairdocs.org/ntsb/CEN18FA001.md): Brantly B 2B · Midland, MI · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2017 · N2284U · Substantial damage
  > The pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…
- [NTSB ANC18RA001](https://openairdocs.org/ntsb/ANC18RA001.md): Robinson R44 · Campbell River, Canada · Accident · 1 fatal · Foreign investigation · Oct 1, 2017 · C-FMBO · Substantial damage
- [NTSB ERA17LA340](https://openairdocs.org/ntsb/ERA17LA340.md): Waco UPF 7 · Ocklawaha, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2017 · N29909 · Substantial damage
  > A failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.
- [NTSB CEN17LA372](https://openairdocs.org/ntsb/CEN17LA372.md): Piper PA 25-235 · Westphalia, KS · Accident · No injuries · Limited investigation · Final report · Sep 28, 2017 · N7336Z · Substantial damage
  > A total loss of engine power due to a fatigue failure of the crankshaft that resulted from main bearing shift and lack of lubrication.
- [NTSB GAA17CA562](https://openairdocs.org/ntsb/GAA17CA562.md): Eurocopter AS 350 · Fullerton, CA · Accident · Minor injuries · Data collection · Final report · Sep 27, 2017 · N515ET · Substantial damage
  > The pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.
- [NTSB WPR17FA213](https://openairdocs.org/ntsb/WPR17FA213.md): Cessna 172L · Perkinsville, AZ · Accident · 2 fatal · Field investigation · Final report · Sep 22, 2017 · N7070Q · Destroyed
  > The pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.
- [NTSB GAA17CA555](https://openairdocs.org/ntsb/GAA17CA555.md): Godwin Jeff E Safari · Fayetteville, NC · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N186KW · Substantial damage
  > The student pilot’s failure to maintain lateral control during a hover pedal turn.
- [NTSB CEN17WA383](https://openairdocs.org/ntsb/CEN17WA383.md): Bell 47G · Llano Bonito de Pococí, Costa Rica · Accident · 1 fatal · Foreign investigation · Sep 18, 2017 · TI-BGH · Substantial damage
  > On September 18, 2017, at 0720 central daylight time, a Bell 47G2 helicopter, Costa Rican registration TI-BGH, serial number 1459, impacted terrain during an aerial application flight, near Llano Bonito de Pococí, Costa Rica. The pilot was fatally injured,…
- [NTSB WPR17LA209](https://openairdocs.org/ntsb/WPR17LA209.md): Trudel GP 4 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2017 · C-GTPX · 2 aircraft · Minor damage
  > The other pilot's failure to maintain clearance from the airplane during the line-abreast formation.
- [NTSB WPR17LA206](https://openairdocs.org/ntsb/WPR17LA206.md): Bell 47G 5 · Salinas, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2017 · N3285T · Substantial damage
  > The pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.
- [NTSB ERA17LA328](https://openairdocs.org/ntsb/ERA17LA328.md): Piper J3C · Hanover Township, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 2017 · N38365 · Substantial damage
  > The pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.
- [NTSB CEN17FA354](https://openairdocs.org/ntsb/CEN17FA354.md): Cirrus Design SR22 · Glenwood Springs, CO · Accident · 4 fatal · Field investigation · Final report · Sep 16, 2017 · N462SR · Destroyed
  > The non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…
- [NTSB CEN17WA353](https://openairdocs.org/ntsb/CEN17WA353.md): Mooney M 20K · Braunwald, Switzerland · Accident · 2 fatal · Foreign investigation · Sep 12, 2017 · D-EPPW · Destroyed
- [NTSB CEN17LA375](https://openairdocs.org/ntsb/CEN17LA375.md): Hiller UH 12A · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Sep 11, 2017 · N2686 · Substantial damage
  > The loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.
- [NTSB CEN17FA342](https://openairdocs.org/ntsb/CEN17FA342.md): Rans S-6 · Stonewall, TX · Accident · 2 fatal · Field investigation · Final report · Sep 10, 2017 · N112CD · Substantial damage
  > The pilot's failure to maintain terrain clearance while conducting aerobatic flight maneuvers with insufficient altitude to recover.

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

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