# NTSB investigations: 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 29 of 412 · 20,559 cases

## Cases, newest first

- [NTSB WPR17LA096](https://openairdocs.org/ntsb/WPR17LA096.md): Piper PA 32-260 · Mukilteo, WA · Accident · Minor injuries · Limited investigation · Final report · May 2, 2017 · N3457W · Substantial damage
  > The improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.
- [NTSB CEN17FA168](https://openairdocs.org/ntsb/CEN17FA168.md): Pilatus PC 12 · Amarillo, TX · Accident · 3 fatal · Class 2 · Field · Final report · Apr 29, 2017 · N933DC · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during the initial climb after takeoff in night instrument meteorological conditions and moderate turbulence.
- [NTSB WPR17LA088](https://openairdocs.org/ntsb/WPR17LA088.md): Piper PA 22-150 · Kernville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 21, 2017 · N9975D · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/mush.
- [NTSB ERA17FA156](https://openairdocs.org/ntsb/ERA17FA156.md): Luscombe 8 · East Windsor, CT · Accident · 2 fatal · Field investigation · Final report · Apr 18, 2017 · N8554Y · Substantial damage
  > The flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…
- [NTSB CEN17RA158](https://openairdocs.org/ntsb/CEN17RA158.md): Piper PA31T · Cascais, Portugal · Accident · 5 fatal · Foreign investigation · Apr 17, 2017 · HB-LTI · Destroyed
  > On April 17, 2017, about 1104 hours universal coordinated time, a Piper PA-31T, serial number 31T-8020091, Swiss registration HB-LTI, was destroyed during impact and a postimpact fire following a loss of control during initial climb from runway 17 at the…
- [NTSB CEN17LA156](https://openairdocs.org/ntsb/CEN17LA156.md): Loomis Xenon 4 · Knoxville, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N912XV · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.
- [NTSB ERA17FA155](https://openairdocs.org/ntsb/ERA17FA155.md): Cessna 170 · Williston, FL · Accident · 4 fatal · Field investigation · Final report · Apr 15, 2017 · N4244V · Destroyed
  > The pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.
- [NTSB ERA17CA152](https://openairdocs.org/ntsb/ERA17CA152.md): Lazear John T Zenair Stol CH 701 · Windsor Twp, PA · Accident · Minor injuries · Data collection · Final report · Apr 11, 2017 · N3846T · Substantial damage
  > The pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.
- [NTSB ERA17WA142](https://openairdocs.org/ntsb/ERA17WA142.md): Quest Kodiak · Moretecocha, Ecuador · Accident · Serious injuries · Foreign investigation · Mar 28, 2017 · HC-CPR · Substantial damage
  > On March 28, 2017, at 1600 Universal Coordinated Time (UTC), a Quest Kodiak 100, Ecuadorian registration HC-CRF, operated by Alas De Socorro, received substantial damage following a collision with trees and terrain during takeoff at Moretecocha Airstrip,…
- [NTSB ERA17FA139](https://openairdocs.org/ntsb/ERA17FA139.md): Mooney M20J · Aberdeen, MS · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2017 · N643RJ · Substantial damage
  > The pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.
- [NTSB ERA17CA137](https://openairdocs.org/ntsb/ERA17CA137.md): Cirrus Design SR20 · Cleveland, TN · Accident · No injuries · Data collection · Final report · Mar 26, 2017 · N782JR · Substantial damage
  > The flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.
- [NTSB CEN17LA171](https://openairdocs.org/ntsb/CEN17LA171.md): John Goodman Air Camper · Oronogo, MO · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 2017 · N23RT · Substantial damage
  > A detached throttle cable support block, which resulted in the pilot’s inability to control the throttle and the subsequent stall while maneuvering for an emergency landing.
- [NTSB WPR17LA078](https://openairdocs.org/ntsb/WPR17LA078.md): Swearingen SA226 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Mar 20, 2017 · N158WA · Substantial damage
  > Company maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.
- [NTSB ERA17WA132](https://openairdocs.org/ntsb/ERA17WA132.md): Bell 206 · Araucária Municipality, Brazil · Accident · Serious injuries · Foreign investigation · Mar 17, 2017 · PT-YHH · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB ERA17LA128](https://openairdocs.org/ntsb/ERA17LA128.md): Piper PA28 · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Mar 12, 2017 · N8447R · Substantial damage
  > A collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.
- [NTSB CEN17LA117](https://openairdocs.org/ntsb/CEN17LA117.md): Jude Mike C Side Winder · Paynesville, MN · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 2017 · N7524V · Substantial damage
  > The pilot’s inadequate preflight inspection, during which he failed to ensure that there was sufficient coolant in the engine reservoir, which resulted in the engine getting too hot and the engine control module shutting down the engine.
- [NTSB WPR17LA072](https://openairdocs.org/ntsb/WPR17LA072.md): Bellanca 17-30A · Carson City, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 2017 · N39894 · Substantial damage
  > A total loss of engine power due to internal corrosion of the fuel manifold valve. Also causal was the pilot's decision to return to the runway following the loss of engine power shortly after takeoff, and his exceedance of the airplane's critical angle of…
- [NTSB ERA17LA122](https://openairdocs.org/ntsb/ERA17LA122.md): Xtremeair XA42 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 1, 2017 · N342AW · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.
- [NTSB ERA17LA113](https://openairdocs.org/ntsb/ERA17LA113.md): Cirrus SR20 · Daytona Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 2017 · N255JB · Substantial damage
  > The pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.
- [NTSB ERA17FA112](https://openairdocs.org/ntsb/ERA17FA112.md): Piper PA38 · East Haven, CT · Accident · 1 fatal · Field investigation · Final report · Feb 22, 2017 · N2452C · Destroyed
  > The failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…
- [NTSB CEN17RA106](https://openairdocs.org/ntsb/CEN17RA106.md): Raytheon B200 · Melbourne, Australia · Accident · 5 fatal · Foreign investigation · Feb 20, 2017 · VH-ZCR · Destroyed
  > On February 20, 2017, at 2159 hours universal coordinated time (0859 hours Australian eastern daylight time on February 21, 2017), a Raytheon model B200 (King Air) airplane, Australian registration VH-ZCR, impacted a building and roadway shortly after takeoff…
- [NTSB CEN17FA108](https://openairdocs.org/ntsb/CEN17FA108.md): Macleod Homebuilt · Springfield, OH · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2017 · N62888 · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.
- [NTSB ANC17RA055](https://openairdocs.org/ntsb/ANC17RA055.md): Cessna 172 · Giseong-ri, South Korea · Incident · No injuries · Foreign investigation · Feb 10, 2017 · HL1171 · Minor damage
  > On February 10, 2017, about 0952 local time, a Cessna 172 airplane, Republic of Korea registration number HL1171, operated by a flight school, sustained minor damage following a forced landing in a shallow river near Giseong-ri, Republic of Korea. The pilot…
- [NTSB ENG17WA012](https://openairdocs.org/ntsb/ENG17WA012.md): Airbus A320 · Dehli, India · Incident · No injuries · Foreign investigation · Feb 8, 2017 · VT-WGB · No damage
  > On February 8, 2017, about 1932 local (1402 UTC), a Go Air (Indian air carrier) A320 equipped with Pratt & Whitney PW1127G engines experienced a loss of power in the No. 1 engine. The airplane had to return to Delhi immediately after takeoff because of a low…
- [NTSB ERA17LA102](https://openairdocs.org/ntsb/ERA17LA102.md): Shell John Super SIX · Morganton, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 6, 2017 · N426KS · Substantial damage
  > A loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.
- [NTSB ERA17LA100](https://openairdocs.org/ntsb/ERA17LA100.md): Piper PA32R · Friendly, MD · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2017 · N21HD · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA098](https://openairdocs.org/ntsb/CEN17LA098.md): Robinson Michael E Cozy Mark IV · Anthony, NM · Accident · No injuries · Limited investigation · Final report · Feb 1, 2017 · N294MV · Substantial damage
  > A total loss of engine power during climbout for reasons an examination of the engine and fuel system was not able to determine, which resulted in a forced landing on unsuitable terrain.
- [NTSB CEN17LA093](https://openairdocs.org/ntsb/CEN17LA093.md): Piper J3C · Brenham, TX · Accident · No injuries · Limited investigation · Final report · Jan 30, 2017 · N7039H · Substantial damage
  > The reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.
- [NTSB ERA17LA097](https://openairdocs.org/ntsb/ERA17LA097.md): Piper PA22 · Georgetown, DE · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 2017 · N3659Z · Destroyed
  > An in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.
- [NTSB WPR17FA057](https://openairdocs.org/ntsb/WPR17FA057.md): Beech 300 · Tucson, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 23, 2017 · N385KA · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.
- [NTSB ERA17LA092](https://openairdocs.org/ntsb/ERA17LA092.md): Hawker Beechcraft G36 · West Caldwell, NJ · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 21, 2017 · N979BA · Destroyed
  > The pilot’s failure to maintain airplane control after takeoff, which resulted in an aerodynamic stall.
- [NTSB WPR17LA056](https://openairdocs.org/ntsb/WPR17LA056.md): Beech 99 · Billings, MT · Accident · No injuries · Limited investigation · Final report · Jan 19, 2017 · N326CA · Substantial damage
  > The fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.
- [NTSB ERA17CA089](https://openairdocs.org/ntsb/ERA17CA089.md): Cessna 182 · Mobile, AL · Accident · Minor injuries · Data collection · Final report · Jan 14, 2017 · N707RB · Substantial damage
  > The pilot’s failure to maintain airplane control during the initial climb.
- [NTSB CEN17WA087](https://openairdocs.org/ntsb/CEN17WA087.md): Cessna 560 · Gardermoen, Norway · Accident · No injuries · Foreign investigation · Jan 11, 2017 · LN-IDB · Substantial damage
  > On January 11, 2017, about 1521 UTC, a Cessna 560, Norwegian registration LN-IDB, experienced a control upset during departure from the Oslo Airport (ENGM), Gardermoan, Norway. The two pilots on board were not injured. The airplane sustained substantial…
- [NTSB ERA17LA078](https://openairdocs.org/ntsb/ERA17LA078.md): Aircraft Mfg & Development CH 2000 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 2017 · N683AM · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.
- [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.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=30

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=29

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