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

## Cases, newest first

- [NTSB GAA16CA180](https://openairdocs.org/ntsb/GAA16CA180.md): Lamb-Robin Bowers FLY Baby · Guthrie, OK · Accident · Minor injuries · Data collection · Final report · Apr 3, 2016 · N359RJ · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall and a collision with terrain.
- [NTSB ERA16WA136](https://openairdocs.org/ntsb/ERA16WA136.md): Comp Air CA9 · Sao Paulo, Brazil · Accident · 7 fatal · Foreign investigation · Mar 19, 2016 · PR-ZRA · Substantial damage
  > On March 19, 2016, about 1853 coordinated universal time, an experimental amateur-built Comp Air CA9, Brazilian registration PR-ZRA, was destroyed by impact and fire after collision with a building shortly after takeoff in Sao Paulo, Brazil. There was a…
- [NTSB ERA16LA135](https://openairdocs.org/ntsb/ERA16LA135.md): Cessna 210L · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Mar 19, 2016 · N59196 · Substantial damage
  > A complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…
- [NTSB ERA16FA133](https://openairdocs.org/ntsb/ERA16FA133.md): Cessna 340 · Tampa, FL · Accident · 2 fatal · Field investigation · Final report · Mar 18, 2016 · N6239X · Destroyed
  > The intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB CEN16LA128](https://openairdocs.org/ntsb/CEN16LA128.md): Grumman AA5 · Longview, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2016 · N9582L · Substantial damage
  > The noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.
- [NTSB ERA16LA130](https://openairdocs.org/ntsb/ERA16LA130.md): Grumman Acft ENG Cor-Schweizer G-164 · Myakka, FL · Accident · No injuries · Limited investigation · Final report · Mar 14, 2016 · N6654K · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.
- [NTSB CEN16WA124](https://openairdocs.org/ntsb/CEN16WA124.md): Cessna 525 · Lugano, Switzerland · Incident · No injuries · Foreign investigation · Mar 14, 2016 · HB-VWM · Minor damage
- [NTSB WPR16FA084](https://openairdocs.org/ntsb/WPR16FA084.md): Cessna 182A · Alpine, WY · Accident · 4 fatal · Field investigation · Final report · Mar 13, 2016 · N2230G · Substantial damage
  > The noninstrument-rated pilot's failure to maintain airspeed during the initial climb in dark night conditions with no visual reference, which resulted in a stall and collision with terrain.
- [NTSB WPR16LA088](https://openairdocs.org/ntsb/WPR16LA088.md): Thomas D. Parkes Lancair ES · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 10, 2016 · N44AZ · Substantial damage
  > A partial loss of engine power due to an over-temperature event, which thermally damaged the blade tips of the turbocharger wheel and resulted in a slowing or stoppage in the rotation of the turbocharger.
- [NTSB ERA16LA126](https://openairdocs.org/ntsb/ERA16LA126.md): Mooney M20 · Pottstown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 9, 2016 · N242TS · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.
- [NTSB ERA16WA339](https://openairdocs.org/ntsb/ERA16WA339.md): Piper PA28 · Johannesburg, South Africa · Accident · 2 fatal · Foreign investigation · Mar 7, 2016 · ZS-EXV · Destroyed
  > On March 7, 2016, about 1410 coordinated universal time, Piper PA28-140, South African registration ZS-EXV, was destroyed when it impacted terrain during an emergency landing to Mountain View Airfield (FAMV), Johannesburg, South Africa. The pilot and a…
- [NTSB WPR16LA080](https://openairdocs.org/ntsb/WPR16LA080.md): North Wing Apache · Queen Creek, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2016 · N242WT · Substantial damage
  > A loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…
- [NTSB ERA16LA116](https://openairdocs.org/ntsb/ERA16LA116.md): Cessna 150L · Gettysburg, PA · Accident · No injuries · Limited investigation · Final report · Feb 27, 2016 · N976HB · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.
- [NTSB ERA16LA115](https://openairdocs.org/ntsb/ERA16LA115.md): Beech 95 C55 · Plymouth, MA · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 2016 · N482S · Substantial damage
  > The pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.
- [NTSB WPR16LA074](https://openairdocs.org/ntsb/WPR16LA074.md): Mooney M20J · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Feb 22, 2016 · N201KY · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation.
- [NTSB CEN16WA110](https://openairdocs.org/ntsb/CEN16WA110.md): Piper PA23 · Saint François, Guadeloupe · Accident · No injuries · Foreign investigation · Feb 22, 2016 · N539EG · Destroyed
  > On February 22, 2016, a Piper PA-23-250 airplane, N539EG, sank after ditching near the Saint François Airport (TFFC), Saint François, Guadeloupe (France). The pilot was not injured.This investigation is under the jurisdiction and control of the French…
- [NTSB DCA16WA087](https://openairdocs.org/ntsb/DCA16WA087.md): Boeing 777 · Punta Cana, Dominican Republic · Incident · No injuries · Foreign investigation · Feb 10, 2016 · VP-BHB · Minor damage
  > The Dominican Republic Comisión Investigadora de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 777-200 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…
- [NTSB CEN16LA096](https://openairdocs.org/ntsb/CEN16LA096.md): Raymond Z Brown Condor · Centralia, IL · Accident · 1 fatal · Limited investigation · Final report · Feb 1, 2016 · N41852 · Substantial damage
  > The failure of the prerotator belt, which impeded the engine's timing belt and resulted in a loss of engine power at low altitude.
- [NTSB ERA16FA097](https://openairdocs.org/ntsb/ERA16FA097.md): Brook Aaron D Lancair IV P · Albany, GA · Accident · 3 fatal · Field investigation · Final report · Jan 30, 2016 · N401PT · Destroyed
  > The pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…
- [NTSB DCA16WA084](https://openairdocs.org/ntsb/DCA16WA084.md): Boeing 747 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jan 30, 2016 · G-CIVX · No damage
  > The Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on January 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB WPR16LA057](https://openairdocs.org/ntsb/WPR16LA057.md): Enstrom 280 · Phoenix, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2016 · N133AB · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR16LA056](https://openairdocs.org/ntsb/WPR16LA056.md): Robinson Helicopter R22 · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Jan 22, 2016 · N7020U · Substantial damage
  > The loss of helicopter control as a result of the loss of tail rotor effectiveness.
- [NTSB WPR16LA050](https://openairdocs.org/ntsb/WPR16LA050.md): Moore Onex · Fresno, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 10, 2016 · N1950J · Substantial damage
  > The pilot/builder's failure to properly align the Force One Main Bearing, which resulted in a blockage of the oil transfer hole and culminated with a total engine power loss. Contributing to the accident was the pilot's failure to arrest the bank and sink…
- [NTSB ERA16LA086](https://openairdocs.org/ntsb/ERA16LA086.md): Wayland John H Avid Mark IV · Minneola, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 2016 · N72MT · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the pilot's exceedance of the airplane’s critical angle…
- [NTSB ERA16FA084](https://openairdocs.org/ntsb/ERA16FA084.md): Eros 1600 · Lebanon, TN · Accident · 1 fatal · Field investigation · Final report · Jan 7, 2016 · N508AH · Substantial damage
  > A failure of the front cylinder piston due to the pilot's improper maintenance, which resulted in a total loss of engine power after takeoff. Contributing to the accident was the pilot's decision to return to the runway at low altitude following the loss of…
- [NTSB ERA16LA082](https://openairdocs.org/ntsb/ERA16LA082.md): Pilatus PC-12 · Savannah, GA · Accident · Minor injuries · Limited investigation · Final report · Jan 6, 2016 · N978AF · Substantial damage
  > The pilots’ failure to follow proper procedures in response to a crew alerting system warning for high engine torque values, which necessitated an off-runway emergency landing during which the airplane sustained substantial damage due to postimpact fire.…
- [NTSB WPR16LA043](https://openairdocs.org/ntsb/WPR16LA043.md): Aerostar Acft Corp Of Texas M20F · Nogales, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 26, 2015 · N6811V · Substantial damage
  > The airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.
- [NTSB ERA16LA078](https://openairdocs.org/ntsb/ERA16LA078.md): Piper PA-46 · Corinth, MS · Accident · Serious injuries · Limited investigation · Final report · Dec 24, 2015 · N891CR · Substantial damage
  > The pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA16LA077](https://openairdocs.org/ntsb/ERA16LA077.md): Beech A36 · Myerstown, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2015 · N4314S · Substantial damage
  > The pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.
- [NTSB ANC16LA010](https://openairdocs.org/ntsb/ANC16LA010.md): Robinson Helicopter R44 II · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Dec 16, 2015 · N255VS · Substantial damage
  > The overhaul facility’s improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.
- [NTSB WPR16LA039](https://openairdocs.org/ntsb/WPR16LA039.md): Mooney M20E · Corona, CA · Accident · No injuries · Limited investigation · Final report · Dec 14, 2015 · N5863Q · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s decision to conduct the takeoff with observed engine deficiencies.
- [NTSB ERA16LA068](https://openairdocs.org/ntsb/ERA16LA068.md): Mccorkle Robert B Rans S-12 Airaile · Benton, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 12, 2015 · N6202N · Substantial damage
  > The pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.
- [NTSB ERA16LA065](https://openairdocs.org/ntsb/ERA16LA065.md): Dehavilland Tiger Moth DH 82A · Modena, NY · Accident · No injuries · Class 3 · Limited · Final report · Dec 12, 2015 · N9410 · Substantial damage
  > A partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.
- [NTSB CEN16LA061](https://openairdocs.org/ntsb/CEN16LA061.md): Globe GC 1B · Lake Elmo, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 2015 · N78067 · Substantial damage
  > A loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.
- [NTSB ERA16LA062](https://openairdocs.org/ntsb/ERA16LA062.md): Beech D35 · Vine Grove, KY · Accident · No injuries · Limited investigation · Final report · Dec 4, 2015 · N2991B · Substantial damage
  > The pilot’s failure to ensure that the fuel selector was properly positioned before takeoff, which resulted in the subsequent total loss of engine power due to fuel starvation.
- [NTSB ERA16LA061](https://openairdocs.org/ntsb/ERA16LA061.md): Piper PA-24 · Millville, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2015 · N88F · Substantial damage
  > The total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA16LA053](https://openairdocs.org/ntsb/ERA16LA053.md): Piper PA-32 · Opa Locka, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2015 · N5568J · Substantial damage
  > Maintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.
- [NTSB ERA16LA051](https://openairdocs.org/ntsb/ERA16LA051.md): Piper PA28 · Lawrenceville, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2015 · N3971R · Substantial damage
  > The flight instructor's inadequate fuel management, which resulted in a total loss of engine power during initial climb due to fuel starvation and a subsequent forced landing.
- [NTSB ERA16LA046](https://openairdocs.org/ntsb/ERA16LA046.md): Mooney M20 · Fort Meade, MD · Accident · No injuries · Limited investigation · Final report · Nov 22, 2015 · N5512Q · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16FA043](https://openairdocs.org/ntsb/ERA16FA043.md): Beech A36TC · Orlando, FL · Accident · 2 fatal · Field investigation · Final report · Nov 20, 2015 · N7FG · Destroyed
  > The pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…
- [NTSB WPR16LA031](https://openairdocs.org/ntsb/WPR16LA031.md): Cessna 210 · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 2015 · N9824G · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16WA047](https://openairdocs.org/ntsb/ERA16WA047.md): Cessna 402B · Choco, Colombia · Accident · 2 fatal · Foreign investigation · Nov 17, 2015 · HK4981G · Destroyed
  > On November 17, 2015, about 1550 coordinated universal time, a Cessna 402B, Colombian registration HK4981G, was destroyed when it descended and impacted the ground in a residential area, during takeoff from Acandi Airport (SKAD), Choco, Colombia. The pilot…
- [NTSB ERA16LA041](https://openairdocs.org/ntsb/ERA16LA041.md): Woodrow Larry W Sonex · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Nov 15, 2015 · N7035Z · Substantial damage
  > The pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.
- [NTSB WPR16LA023](https://openairdocs.org/ntsb/WPR16LA023.md): Thorp T 18 · Independence, OR · Accident · No injuries · Limited investigation · Final report · Nov 6, 2015 · N1488 · Substantial damage
  > A separation of the canopy mechanism during flight, which resulted in the pilot’s precautionary landing and the airplane’s subsequent collision with a fence post.
- [NTSB CEN16LA033](https://openairdocs.org/ntsb/CEN16LA033.md): Cessna 120 · Gonzales, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2015 · N2942N · Substantial damage
  > Maintenance personnel’s improper installation of the carburetor during recent maintenance, including the omission of a required cotter pin, which resulted in a total loss of engine power.
- [NTSB GAA16CA067](https://openairdocs.org/ntsb/GAA16CA067.md): Taylorcraft BC12 65 · New Lisbon, WI · Accident · Minor injuries · Data collection · Final report · Nov 2, 2015 · N33939 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.
- [NTSB DCA16WA081](https://openairdocs.org/ntsb/DCA16WA081.md): Gulfstream G1159 · Kinshasa, Congo - Kinshasa · Accident · No injuries · Foreign investigation · Nov 1, 2015 · 9Q-CND · Substantial damage
  > The government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a Gulfstream G1159 airplane that occurred on November 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's…
- [NTSB CEN16LA025](https://openairdocs.org/ntsb/CEN16LA025.md): Champion 7ECA · Sheridan, AR · Accident · No injuries · Limited investigation · Final report · Oct 30, 2015 · N9105L · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB CEN16FA024](https://openairdocs.org/ntsb/CEN16FA024.md): Raytheon A36 · Pottsville, AR · Accident · 4 fatal · Field investigation · Final report · Oct 29, 2015 · N3BE · Destroyed
  > The pilot's failure to maintain a sufficient climb rate during departure in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA16FA023](https://openairdocs.org/ntsb/ERA16FA023.md): Mooney M20M · Worcester, MA · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2015 · N243CW · Substantial damage
  > A total loss of engine power during the initial climb due to a fatigue failure of the engine's crankshaft. Contributing to the accident was the pilot's failure to maintain control of the airplane, which resulted in an aerodynamic stall.

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

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

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