# NTSB investigations, 2016: Initial climb

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 3 · 141 cases

## Latest cases

- [NTSB ERA17LA077](https://openairdocs.org/ntsb/ERA17LA077.md): Beech 76 · Dunnellon, FL · Accident · No injuries · Limited investigation · Final report · Dec 30, 2016 · N6627U · Substantial damage
  > An inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.
- [NTSB CEN17FA072](https://openairdocs.org/ntsb/CEN17FA072.md): Cessna 525 · Cleveland, OH · Accident · 6 fatal · Field investigation · Final report · Dec 30, 2016 · N614SB · Destroyed
  > Controlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…
- [NTSB WPR17FA041](https://openairdocs.org/ntsb/WPR17FA041.md): Petrus David Wayne S90 · Fresno, CA · Accident · 2 fatal · Field investigation · Final report · Dec 26, 2016 · N176PA · Destroyed
  > The pilot's abnormally steep takeoff climb followed by a loss of control and rapid descent to ground impact, for undetermined reasons.
- [NTSB ERA17FA072](https://openairdocs.org/ntsb/ERA17FA072.md): Piper PA28 · Middlebury, VT · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2016 · N31202 · Substantial damage
  > The pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…
- [NTSB ENG17WA007](https://openairdocs.org/ntsb/ENG17WA007.md): Boeing 767 · Toronto, Canada · Incident · No injuries · Foreign investigation · Dec 21, 2016 · 4X-EAM
  > On Dec. 21, 2016, an ElAl Boeing 767-300ER, powered by Pratt & Whitney PW4000 turbofan engines, registration number 4X-EAM, while climbing through 13,000 ft. from Pearson International Airport (YYZ), Toronto, Canada, experienced a loss of power of the right…
- [NTSB WPR17FA035](https://openairdocs.org/ntsb/WPR17FA035.md): Quest Kodiak 100 · Moab, UT · Accident · 1 fatal · Field investigation · Final report · Dec 12, 2016 · N772RT · Destroyed
  > The pilot's loss of control shortly after takeoff due to spatial disorientation.
- [NTSB ERA17LA067](https://openairdocs.org/ntsb/ERA17LA067.md): Mathias Linda B Lightning · Franklin, VA · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 2016 · N59JL · Substantial damage
  > A partial loss of engine power due to pre-ignition damage to the No. 2 cylinder piston and the pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall.
- [NTSB ERA17LA057](https://openairdocs.org/ntsb/ERA17LA057.md): Piper PA28 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Nov 23, 2016 · N41565 · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.
- [NTSB CEN17LA044](https://openairdocs.org/ntsb/CEN17LA044.md): Cessna 182P · Bridgeport, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 2016 · N7392Q · Substantial damage
  > The pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.
- [NTSB ANC17LA007](https://openairdocs.org/ntsb/ANC17LA007.md): Piper PA-18 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Nov 22, 2016 · N83641 · Substantial damage
  > The mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.
- [NTSB WPR17FA024](https://openairdocs.org/ntsb/WPR17FA024.md): Piper PA 31T · Elko, NV · Accident · 4 fatal · Field investigation · Final report · Nov 19, 2016 · N779MF · Destroyed
  > A loss of engine power to the left engine for reasons that could not be determined due to the extensive fire and impact damage to the airplane.
- [NTSB ERA17FA050](https://openairdocs.org/ntsb/ERA17FA050.md): Curtiss JN4 · Williamson, GA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2016 · N1662 · Destroyed
  > The in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…
- [NTSB WPR17WA219](https://openairdocs.org/ntsb/WPR17WA219.md): Cessna 208 · Solomon, Australia · Accident · No injuries · Foreign investigation · Nov 16, 2016 · VH-LNH · Substantial damage
  > On November, 16, 2016, about 7:51, Australian western standard time, a Cessna 208B airplane, VH-LNH, landed on a road near Solomon Aerodrome, Solomon, Western Australia, following an engine failure. The flight crew of 2 and 11 passengers were not injured. The…
- [NTSB CEN17LA041](https://openairdocs.org/ntsb/CEN17LA041.md): Flight Design Ctsw · Port Allen, LA · Accident · No injuries · Limited investigation · Final report · Nov 13, 2016 · N329CT · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from debris in the fuel selector valve restricting the fuel flow to the engine and led to a forced landing on rough terrain.
- [NTSB ANC17LA006](https://openairdocs.org/ntsb/ANC17LA006.md): Piper PA32R · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 2016 · N9084J · Substantial damage
  > A total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.
- [NTSB DCA17WA029](https://openairdocs.org/ntsb/DCA17WA029.md): Boeing 767 · Kagoshima, Japan · Accident · No injuries · Foreign investigation · Nov 10, 2016 · JA658J · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767, which occurred on November 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…
- [NTSB CEN17LA036](https://openairdocs.org/ntsb/CEN17LA036.md): Stinson L 5 · San Marcos, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2016 · N4252K · Substantial damage
  > The pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn.
- [NTSB ERA17LA032](https://openairdocs.org/ntsb/ERA17LA032.md): Bell OH 58C · Cameron, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2016 · N139RD · Substantial damage
  > An in-flight failure of a main rotor blade due to fatigue cracks. Contributing to the failure of the main rotor blade was the absence of guidance to the operator to inspect an area of the main rotor blade known to be susceptible to fatigue cracks and the…
- [NTSB GAA17CA198](https://openairdocs.org/ntsb/GAA17CA198.md): Aeros 2 · Blountstown, FL · Accident · Serious injuries · Data collection · Final report · Oct 29, 2016 · UNREG · Substantial damage
  > The noncertificated pilot's decision to fly the weight-shift-controlled aircraft without having received training in the aircraft type, which resulted in his loss of aircraft control shortly after takeoff.
- [NTSB ENG17IA003](https://openairdocs.org/ntsb/ENG17IA003.md): Airbus A330 223 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 26, 2016 · N855NW · No damage
  > A No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration…
- [NTSB ERA17WA051](https://openairdocs.org/ntsb/ERA17WA051.md): Embraer EMB711 · Espumoso, Brazil · Accident · 2 fatal · Foreign investigation · Oct 25, 2016 · PT-NQS · Substantial damage
  > On October 25, 2016, about 1250 coordinated universal time (1050 local time), an Embraer 711C, Brazilian registration PT-NQS, operated by a private individual, was destroyed after it impacted the ground shortly after takeoff from Espumoso Airport (SSEZ),…
- [NTSB DCA17WA015](https://openairdocs.org/ntsb/DCA17WA015.md): Lockheed Stalker · Avoca, Australia · Accident · No injuries · Foreign investigation · Oct 25, 2016 · UNREG · Substantial damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's…
- [NTSB DCA17WA014](https://openairdocs.org/ntsb/DCA17WA014.md): Lockheed Stalker · Mount Disappointment, Australia · Accident · No injuries · Foreign investigation · Oct 24, 2016 · UNREG · Substantial damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's…
- [NTSB WPR17LA015](https://openairdocs.org/ntsb/WPR17LA015.md): Ryan W Gross Arion Lighting · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Oct 22, 2016 · N235SC · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.
- [NTSB CEN17FA024](https://openairdocs.org/ntsb/CEN17FA024.md): Beech C23 · Osage Beach, MO · Accident · 2 fatal · Field investigation · Final report · Oct 22, 2016 · N20087 · Substantial damage
  > The pilot's loss of control while maneuvering shortly after takeoff. Contributing to the loss of control was the pilot's attempt to climb with the flaps fully extended.
- [NTSB CEN17LA021](https://openairdocs.org/ntsb/CEN17LA021.md): Zenith CH-750 · Morristown, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 2016 · N8681 · Substantial damage
  > A total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps.
- [NTSB ERA17LA015](https://openairdocs.org/ntsb/ERA17LA015.md): Cessna 150 · Stockbridge, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2016 · N7948F · Substantial damage
  > A partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ANC17WA030](https://openairdocs.org/ntsb/ANC17WA030.md): Cessna 500 · Kelowna, Canada · Accident · 4 fatal · Foreign investigation · Oct 14, 2016 · C-GTNG · Destroyed
  > On October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft…
- [NTSB WPR17LA005](https://openairdocs.org/ntsb/WPR17LA005.md): Mcdonnell Douglas Helicopter 369E · Waimea, HI · Accident · No injuries · Limited investigation · Final report · Oct 4, 2016 · N311VT · Substantial damage
  > Impact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.
- [NTSB CEN17LA011](https://openairdocs.org/ntsb/CEN17LA011.md): Fokker DR-1 · Fulshear, TX · Accident · No injuries · Limited investigation · Final report · Oct 3, 2016 · N83WR · Substantial damage
  > A partial loss of engine power due to the improper assembly of the mechanical fuel pump.
- [NTSB ENG16RA041](https://openairdocs.org/ntsb/ENG16RA041.md): BAE AVRO146RJ · Malmo, Sweden · Incident · No injuries · Foreign investigation · Sep 29, 2016 · SE-DSP · No damage
  > The Swedish Accident Investigation Authority has notified the NTSB of an incident involving a BAE Systems (Operations) Limited Avro 146-RJ100 which occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Swedish…
- [NTSB ERA16LA330](https://openairdocs.org/ntsb/ERA16LA330.md): Tatkovsky James G Safari · Andover, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2016 · N330JT · Destroyed
  > The noncertificated pilot’s failure to maintain helicopter control during initial climb.
- [NTSB GAA16CA514](https://openairdocs.org/ntsb/GAA16CA514.md): Cessna 205 · Ellington, CT · Accident · No injuries · Data collection · Final report · Sep 26, 2016 · N8433Z · Substantial damage
  > The pilot's exceedance of the airplane's critical angle-of-attack during the initial climb after an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB ERA16FA325](https://openairdocs.org/ntsb/ERA16FA325.md): Mooney M20J · Pittstown, NJ · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2016 · N526AM · Substantial damage
  > The pilot's improper landing touchdown attitude, which resulted in a propeller strike, and his inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and led to an aerodynamic stall during…
- [NTSB CEN16WA384](https://openairdocs.org/ntsb/CEN16WA384.md): Cessna 206 · Lake Kuashkuapishiu, Canada · Accident · 2 fatal · Foreign investigation · Sep 25, 2016 · C-FWBQ · Substantial damage
  > On September 25, 2016, a Cessna U206F airplane, C-FWBQ, collided with terrain after departing from Lake Kuashkuapishiu, Quebec. The pilot was seriously injured and two passengers were fatally injured. This investigation is under the jurisdiction and control…
- [NTSB CEN16LA394](https://openairdocs.org/ntsb/CEN16LA394.md): Piper PA 22-108 · Pearland, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2016 · N4920Z · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined based on the available information following a thorough postaccident examination.
- [NTSB CEN16LA379](https://openairdocs.org/ntsb/CEN16LA379.md): Cessna 172S · Chesterfield, MO · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2016 · N52265 · Destroyed
  > The pilot's unstable approach and subsequent loss of airplane control during an attempted go-around.
- [NTSB ERA16LA319](https://openairdocs.org/ntsb/ERA16LA319.md): Grumman G164 · Chestertown, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 18, 2016 · N75EP · Substantial damage
  > Loss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.
- [NTSB ERA16WA317](https://openairdocs.org/ntsb/ERA16WA317.md): Piper PA28 · Flanders, Colombia · Accident · 2 fatal · Foreign investigation · Sep 15, 2016 · HK1328G · 2 aircraft · Substantial damage
  > On September 15, 2016, about 1523 universal coordinated time, a Piper PA-28-140; Colombian registration, HK1328G, operated by Aeroandes Flight Training School, and a Cessna 152; Columbian registration, HK2092G, operated by Acahel Flight Training School…
- [NTSB WPR16FA178](https://openairdocs.org/ntsb/WPR16FA178.md): Piper PA 28R-201T · Reno, NV · Accident · 3 fatal · Field investigation · Final report · Sep 12, 2016 · N821ET · Destroyed
  > The pilot's decision to depart with the airplane loaded above its maximum gross weight and at or just beyond its aft center of gravity limitations, which resulted in a loss of control during the initial climb. Contributing to the accident was the pressure to…
- [NTSB CEN16LA366](https://openairdocs.org/ntsb/CEN16LA366.md): Piper PA 18 · Greenville, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 2016 · N3286Z · Substantial damage
  > The pilot's premature turn during the takeoff climb and subsequent turn to avoid trees, which resulted in his exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB CEN16CA383](https://openairdocs.org/ntsb/CEN16CA383.md): Mooney M20D · Brodhead, WI · Accident · Minor injuries · Data collection · Final report · Sep 11, 2016 · N6919U · Substantial damage
  > The pilot's loss of airplane control during initial climb due to an excessively nose-high attitude. Contributing to the accident was the pilot's failure to properly set the elevator trim before takeoff in accordance with the Before Takeoff checklist.
- [NTSB ANC16LA062](https://openairdocs.org/ntsb/ANC16LA062.md): Dehavilland DHC-2 · Kodiak, AK · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 9, 2016 · N91AK · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the initial climb and turn after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.
- [NTSB DCA16WA237](https://openairdocs.org/ntsb/DCA16WA237.md): Cessna 210 · Naivasha, Nakuru County, Kenya · Accident · No injuries · Foreign investigation · Sep 8, 2016 · 5Y-CKK · Destroyed
  > The Kenya Air Accident Investigation Department (AAID) has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on September 08, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under…
- [NTSB CEN16LA363](https://openairdocs.org/ntsb/CEN16LA363.md): CGS Hawk Aero II · Holland, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2016 · N4513S · Destroyed
  > The improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…
- [NTSB WPR16LA175](https://openairdocs.org/ntsb/WPR16LA175.md): Mcdonnell Douglas Helicopter 500N · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2016 · N5232G · No damage
  > The pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…
- [NTSB CEN16LA342](https://openairdocs.org/ntsb/CEN16LA342.md): Fairchild M 62A-3 · Madison, OH · Accident · No injuries · Limited investigation · Final report · Aug 30, 2016 · N47164 · Substantial damage
  > The pilot's failure to follow the Before Takeoff checklist and his improper use of flaps during takeoff, which degraded the airplane's climb performance and resulted in a collision with trees.
- [NTSB CEN16LA339](https://openairdocs.org/ntsb/CEN16LA339.md): Rans Coyote S 4 · Clarksville, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 2016 · N8024J · Substantial damage
  > The total loss of engine power due to a deteriorated and disconnected fuel line, which resulted in fuel starvation and a subsequent hard, off-field landing.
- [NTSB ERA16WA298](https://openairdocs.org/ntsb/ERA16WA298.md): Cessna 550 · Charallave, Venezuela · Accident · 2 fatal · Class 3 · Foreign · Aug 16, 2016 · YV3051 · Destroyed
- [NTSB CEN16LA320](https://openairdocs.org/ntsb/CEN16LA320.md): Cirrus Design SR20 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2016 · N314BF · Destroyed
  > The two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.