# 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 33 of 412 · 20,559 cases

## Cases, newest first

- [NTSB ERA16RA021](https://openairdocs.org/ntsb/ERA16RA021.md): Beech 60 · Bogota, Colombia · Accident · 10 fatal · Foreign investigation · Oct 18, 2015 · HK3917G · Substantial damage
  > On October 18, 2015 at 2119 UTC, a Beechcraft B60, Colombian registration HK3917G, registered to and operated by Sky Hub Aviation, was destroyed during a collision with a building in Barrio El Lujan, Bogota, Colombia. The pilot, three passengers, and six…
- [NTSB WPR16FA012](https://openairdocs.org/ntsb/WPR16FA012.md): Bucker Jungmeister BU 133 · Missoula, MT · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2015 · N1940J · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while executing a return to the runway after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot’s…
- [NTSB ERA16LA014](https://openairdocs.org/ntsb/ERA16LA014.md): Gross Michael E Stol CH 701 · Eufala, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 2015 · N4931M · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no evidence of any preimpact mechanical malfunctions or failures. Also causal was the pilot's decision to continue the takeoff…
- [NTSB CEN16FA013](https://openairdocs.org/ntsb/CEN16FA013.md): Cessna 421B · Hammond, LA · Accident · 2 fatal · Field investigation · Final report · Oct 14, 2015 · N33FA · Destroyed
  > The loss of right engine power on takeoff due to maintenance personnel's failure to properly tighten the crankcase through-studs during cylinder replacement, which resulted in crankshaft fracture. Also causal were the pilot's failure to feather the propeller…
- [NTSB ERA16FA005](https://openairdocs.org/ntsb/ERA16FA005.md): Piper PA 38-112 · Jasper, GA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2015 · N4313E · Substantial damage
  > The student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…
- [NTSB ERA16LA003](https://openairdocs.org/ntsb/ERA16LA003.md): Beech S35 · Knoxville, TN · Accident · Serious injuries · Class 2 · Limited · Final report · Oct 7, 2015 · N449CT · Substantial damage
  > The pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.
- [NTSB ERA15FA378](https://openairdocs.org/ntsb/ERA15FA378.md): Piper PA 30 · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2015 · N21ND · Substantial damage
  > The pilot's failure to maintain single-engine minimum controllable airspeed following a loss of right engine power during initial climb. Also causal was the loss of right engine power for reasons that could not be determined because examination of the…
- [NTSB WPR15FA268](https://openairdocs.org/ntsb/WPR15FA268.md): Cessna 150F · Port Townsend, WA · Accident · Serious injuries · Field investigation · Final report · Sep 28, 2015 · N8529G · Substantial damage
  > The loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…
- [NTSB CEN15FA426](https://openairdocs.org/ntsb/CEN15FA426.md): Jones Ralph D Zodiac CH 601 HD · Ama, LA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 2015 · N401 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…
- [NTSB CEN15FA425](https://openairdocs.org/ntsb/CEN15FA425.md): Cessna T310Q · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2015 · N301JA · Destroyed
  > The separation of the attachment hardware connecting the elevator trim tab pushrod to the elevator trim actuator, which resulted in the elevator trim tab jamming in a position outside the limits of normal travel and a subsequent loss of airplane control.
- [NTSB CEN15FA422](https://openairdocs.org/ntsb/CEN15FA422.md): Pierce, Henry Bushby Mustang II · Granbury, TX · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2015 · N929DS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.
- [NTSB ERA15LA373](https://openairdocs.org/ntsb/ERA15LA373.md): Vanek Jim Sport Copter Vortex · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 2015 · N179V · Substantial damage
  > A loss of engine power due to a lean fuel/air mixture as a result of a disconnected fuel primer line.
- [NTSB WPR15LA266](https://openairdocs.org/ntsb/WPR15LA266.md): Piper PA 28 · Elko, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2015 · N56897 · Substantial damage
  > The pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.
- [NTSB WPR15IA263](https://openairdocs.org/ntsb/WPR15IA263.md): Cessna T206H · Idaho Falls, ID · Incident · Minor injuries · Incident investigation · Final report · Sep 21, 2015 · N7269T · Minor damage
  > An in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.
- [NTSB GAA15CA268](https://openairdocs.org/ntsb/GAA15CA268.md): Helio H 395 · Bethel, AK · Accident · No injuries · Data collection · Final report · Sep 18, 2015 · N910SP · Substantial damage
  > The pilot's failure to maintain a positive climb rate during takeoff initial climb, resulting in an uncontrolled descent and collision with trees and terrain.
- [NTSB DCA15WA198](https://openairdocs.org/ntsb/DCA15WA198.md): Boeing 777 · Miami, FL · Incident · No injuries · Foreign investigation · Sep 16, 2015 · A7-BAC · Minor damage
  > The National Transportation Safety Board (NTSB) has delegated the investigation of an incident involving a Qatar Airways Boeing 777-300, that occurred on September 15, 2015, to the Civil Aviation Authority (CAA) of Qatar. The NTSB has appointed a U.S.…
- [NTSB ANC15FA071](https://openairdocs.org/ntsb/ANC15FA071.md): Dehavilland DHC 3T · Iliamna, AK · Accident · 3 fatal · Field investigation · Final report · Sep 15, 2015 · N928RK · Substantial damage
  > The pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…
- [NTSB ERA15LA358](https://openairdocs.org/ntsb/ERA15LA358.md): Bellanca 7KCAB · Manteo, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 2015 · N86705 · Substantial damage
  > The inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.
- [NTSB ERA15FA353](https://openairdocs.org/ntsb/ERA15FA353.md): Aero Vodochody L39 · Oneida, TN · Accident · 1 fatal · Field investigation · Final report · Sep 12, 2015 · N139RT · Destroyed
  > The pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.
- [NTSB ERA15FA348](https://openairdocs.org/ntsb/ERA15FA348.md): Aerofab Lake LA-4-250 · Somerset, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2015 · N1401P · Destroyed
  > The pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…
- [NTSB CEN15LA402](https://openairdocs.org/ntsb/CEN15LA402.md): Viking Dragonfly · Freeport, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 2015 · N24TL · Substantial damage
  > The airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.
- [NTSB CEN15LA404](https://openairdocs.org/ntsb/CEN15LA404.md): Cessna TR182 · Midland, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 5, 2015 · N4707S · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR15FA256](https://openairdocs.org/ntsb/WPR15FA256.md): Piper PA28 · Santee, CA · Accident · 2 fatal · Field investigation · Final report · Sep 3, 2015 · N8441B · Substantial damage
  > The pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.
- [NTSB CEN15RA452](https://openairdocs.org/ntsb/CEN15RA452.md): Piper PA28 · Bergen, Norway · Incident · No injuries · Foreign investigation · Aug 31, 2015 · LN-BGQ · No damage
  > import
- [NTSB CEN15LA392](https://openairdocs.org/ntsb/CEN15LA392.md): Cessna T240 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Aug 31, 2015 · N452CS · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from the pilot’s inadequate fuel management and the flight instructor’s failure to verify the fuel level and fuel selector position in flight.
- [NTSB ERA15LA332](https://openairdocs.org/ntsb/ERA15LA332.md): Lancair IV · Fort Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2015 · N864KM · Destroyed
  > The mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.
- [NTSB CEN15FA388](https://openairdocs.org/ntsb/CEN15FA388.md): Cirrus Design SR22 · Kewanee, IL · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2015 · N765CD · Substantial damage
  > The pilot's loss of control due to spatial disorientation shortly after takeoff into low instrument meteorological conditions.
- [NTSB ERA15LA334](https://openairdocs.org/ntsb/ERA15LA334.md): Beech B19 · Dexter, ME · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 2015 · N2013G · Substantial damage
  > The flight instructor’s inadequate preflight planning, which resulted in collision with trees and terrain during takeoff.
- [NTSB WPR15LA251](https://openairdocs.org/ntsb/WPR15LA251.md): Dova DV-1 · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Aug 28, 2015 · N919E · Substantial damage
  > A partial loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.
- [NTSB CEN15FA362](https://openairdocs.org/ntsb/CEN15FA362.md): Zenair CH 2000 · McAllen, TX · Accident · 2 fatal · Field investigation · Final report · Aug 17, 2015 · N26ZA · Destroyed
  > The flight instructor's loss of airplane control while departing in gusting wind conditions that were conducive to low-level wind shear.
- [NTSB ERA15FA312](https://openairdocs.org/ntsb/ERA15FA312.md): Cessna T206H · West Caldwell, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 15, 2015 · N63TV · Destroyed
  > A loss of engine power due to a malfunction of the turbocharging system likely due to contaminated oil. Also causal were the pilot's decision to continue the takeoff although the airplane was not performing normally and his failure to maintain adequate…
- [NTSB ERA15CA321](https://openairdocs.org/ntsb/ERA15CA321.md): Quicksilver MXL II Sport · Pittsboro, NC · Accident · Serious injuries · Data collection · Final report · Aug 15, 2015 · UNREG · Substantial damage
  > The pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.
- [NTSB ERA15LA311](https://openairdocs.org/ntsb/ERA15LA311.md): Thomas A Siminski Zenith CH 750 · Allentown, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 2015 · N1750Z · Substantial damage
  > A partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…
- [NTSB CEN15LA360](https://openairdocs.org/ntsb/CEN15LA360.md): North American T 28A · Las Cruces, NM · Accident · 1 fatal · Limited investigation · Final report · Aug 14, 2015 · N14124 · Substantial damage
  > Failure of the No. 6 cylinder connecting rod, due to improper rotation of the propeller during a previous hydraulic lock.
- [NTSB ERA15FA299](https://openairdocs.org/ntsb/ERA15FA299.md): Piper PA-28R · Marathon, FL · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2015 · N54380 · Destroyed
  > The pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation while turning after takeoff in dark night conditions in a sparsely populated area, which resulted in the airplane’s descent into water. Contributing to the…
- [NTSB CEN15LA350](https://openairdocs.org/ntsb/CEN15LA350.md): Jal R Dennis Trixy Princess · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 2015 · N743SS · Substantial damage
  > The pilot's inadequate preflight planning during which he failed to account for the high-density altitude conditions and high gross weight, which degraded the gyroplane's climb performance and resulted in a hard landing.
- [NTSB WPR15FA238](https://openairdocs.org/ntsb/WPR15FA238.md): Aviat A 1 · Compton, CA · Accident · 1 fatal · Field investigation · Final report · Aug 9, 2015 · N6090U · Destroyed
  > The pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…
- [NTSB ERA15LA300](https://openairdocs.org/ntsb/ERA15LA300.md): Cessna 182 · Hot Springs, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2015 · N7506S · Substantial damage
  > A partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.
- [NTSB CEN15LA343](https://openairdocs.org/ntsb/CEN15LA343.md): Cessna 172G · Hartington, NE · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2015 · N5800R · Substantial damage
  > The pilot’s decision to use an excessive, unapproved flap setting for takeoff, which significantly increased the induced drag and resulted in an aerodynamic stall when the airplane flew out of ground effect.
- [NTSB WPR15LA235](https://openairdocs.org/ntsb/WPR15LA235.md): Cleveland Allan B Nieuport 11# · Bellingham, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2015 · N917AB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB ERA15LA304](https://openairdocs.org/ntsb/ERA15LA304.md): Board James A Zenith 601 HD · Danville, KY · Accident · No injuries · Limited investigation · Final report · Aug 7, 2015 · N740JB · Substantial damage
  > The pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.
- [NTSB ERA15FA297](https://openairdocs.org/ntsb/ERA15FA297.md): Piper PA46 · Saranac Lake, NY · Accident · 4 fatal · Field investigation · Final report · Aug 7, 2015 · N819TB · Destroyed
  > The pilot’s loss of airplane control during takeoff, which resulted from his impairment or incapacitation due to an acute cardiac event.
- [NTSB ENG15RA038](https://openairdocs.org/ntsb/ENG15RA038.md): ATR ATR72 · Lampedusa, Italy · Incident · No injuries · Foreign investigation · Aug 7, 2015 · I-ADLW
  > The Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred August 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of…
- [NTSB CEN15WA363](https://openairdocs.org/ntsb/CEN15WA363.md): Bell 206 - L1 · Lake Peten Izta, Guatemala · Accident · Minor injuries · Foreign investigation · Aug 7, 2015 · TG-MIX · Substantial damage
  > On August 7, 2015, about 1128 Universal Coordinated Time, a Bell 206-L1, Guatemalan-registered TG-MIX, operated by Aereo Services, was substantially damaged when it impacted Lake Peten Itza, Guatemala. Visual meteorological conditions prevailed at the time of…
- [NTSB CEN15LA336](https://openairdocs.org/ntsb/CEN15LA336.md): Beech A36 · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2015 · N17544 · Substantial damage
  > A total loss of engine power due to an excessively rich fuel mixture as a result of the improper adjustment of the fuel pump aneroid.
- [NTSB CEN15LA329](https://openairdocs.org/ntsb/CEN15LA329.md): O'Dell Aeromaster · Sulphur Springs, TX · Accident · 1 fatal · Limited investigation · Final report · Jul 31, 2015 · N55J · Destroyed
  > A total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…
- [NTSB ERA15LA283](https://openairdocs.org/ntsb/ERA15LA283.md): Cessna 195A · Iuka, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2015 · N195AP · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a postaccident examination of the engine and fuel system found no mechanical anomalies that would have precluded normal operation.
- [NTSB ANC15WA061](https://openairdocs.org/ntsb/ANC15WA061.md): Cessna 182 · Seibert Lake, Canada · Accident · 1 fatal · Foreign investigation · Jul 26, 2015 · C-FWVQ
  > On July 26, 2015, about 1738 mountain daylight time, a Cessna 182 airplane, C-FWVQ, impacted terrain shortly after takeoff from Seibert Lake, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…
- [NTSB ERA15LA281](https://openairdocs.org/ntsb/ERA15LA281.md): Cessna A188B · Albertson, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 25, 2015 · N731MB · Substantial damage
  > The pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.
- [NTSB ERA15LA282](https://openairdocs.org/ntsb/ERA15LA282.md): North American Navion · Waynesboro, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2015 · N91418 · Substantial damage
  > The pilot's early rotation of the airplane and his failure to attain a positive climb rate during takeoff with the airplane near its aft center of gravity limit from a runway with little margin for error.

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

## 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=33

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