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

## Cases, newest first

- [NTSB ERA15FA049](https://openairdocs.org/ntsb/ERA15FA049.md): Mooney M20C · Lewisburg, WV · Accident · Serious injuries · Field investigation · Final report · Nov 10, 2014 · N6581U · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were abnormal engine operation due to improper…
- [NTSB WPR15LA038](https://openairdocs.org/ntsb/WPR15LA038.md): Cessna 210B · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Nov 8, 2014 · N9578X · Substantial damage
  > The failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.
- [NTSB CEN15FA034](https://openairdocs.org/ntsb/CEN15FA034.md): Raytheon B200 · Wichita, KS · Accident · 4 fatal · Field investigation · Final report · Oct 30, 2014 · N52SZ · Destroyed
  > The pilot's failure to maintain lateral control of the airplane after a reduction in left engine power and his application of inappropriate rudder input. Contributing to the accident was the pilot's failure to follow the emergency procedures for an engine…
- [NTSB DCA15RA018](https://openairdocs.org/ntsb/DCA15RA018.md): Short Bros Shorts SD3 60 · Sint Maartin -Juliana, NT · Accident · 2 fatal · Foreign investigation · Oct 29, 2014 · N380MQ · Destroyed
  > import
- [NTSB ERA15LA028](https://openairdocs.org/ntsb/ERA15LA028.md): Piper PA-28-140 · Valley Point, WV · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2014 · N5601U · Substantial damage
  > Undetermined based on a lack of available information.
- [NTSB ERA15LA029](https://openairdocs.org/ntsb/ERA15LA029.md): Piper PA 22-150 · Tompkins, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 2014 · N8064Y · Substantial damage
  > A total loss of engine power for reasons that could not be determined during postaccident examinations and testing.
- [NTSB ERA15LA030](https://openairdocs.org/ntsb/ERA15LA030.md): North American T 6G · Naples, FL · Accident · No injuries · Limited investigation · Final report · Oct 23, 2014 · N22NA · Substantial damage
  > The total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…
- [NTSB WPR15LA015](https://openairdocs.org/ntsb/WPR15LA015.md): Piper PA28 151 · Bullhead City, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2014 · N56873 · Substantial damage
  > A partial loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15CA020](https://openairdocs.org/ntsb/ERA15CA020.md): Airborne Windsports PTY Edge XT 912 L · Sebring, FL · Accident · No injuries · Data collection · Final report · Oct 18, 2014 · N29ME · Substantial damage
  > The student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.
- [NTSB ERA15FA017](https://openairdocs.org/ntsb/ERA15FA017.md): Aeronca 7EC · Cordele, GA · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2014 · N946DR · Substantial damage
  > An in-flight loss of control for reasons that could not be determined based on the available evidence.
- [NTSB ERA15FA016](https://openairdocs.org/ntsb/ERA15FA016.md): Rockwell International 112 · Gainesville, GA · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2014 · N1148J · Destroyed
  > The partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.
- [NTSB ENG15IA037](https://openairdocs.org/ntsb/ENG15IA037.md): Boeing 787-8 · London, United Kingdom · Incident · No injuries · Incident investigation · Final report · Oct 10, 2014 · N26906 · Minor damage
  > A shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…
- [NTSB ERA14LA462](https://openairdocs.org/ntsb/ERA14LA462.md): Quicksilver Eipper Acft GT 400 · Lebanon, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2014 · N3740A · Substantial damage
  > The pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.
- [NTSB WPR14FA393](https://openairdocs.org/ntsb/WPR14FA393.md): Tifft Kitfox III · Lake Stevens, WA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2014 · N307KF · Substantial damage
  > The pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…
- [NTSB WPR14FA382](https://openairdocs.org/ntsb/WPR14FA382.md): Piper PA 28R-180 · Saratoga, WY · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2014 · N4618J · Substantial damage
  > The pilot’s failure to maintain a positive climb rate after takeoff in dark, night conditions, which resulted in his controlled flight into terrain due to the lack of ground references or natural horizon.
- [NTSB ENG14IA027](https://openairdocs.org/ntsb/ENG14IA027.md): Boeing 747 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Sep 21, 2014 · N669US · No damage
  > Turbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…
- [NTSB CEN14LA508](https://openairdocs.org/ntsb/CEN14LA508.md): Brupbacher Chris CB2000 · Reserve, LA · Accident · 2 fatal · Limited investigation · Final report · Sep 21, 2014 · N5002E · Destroyed
  > The failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.
- [NTSB ERA14LA450](https://openairdocs.org/ntsb/ERA14LA450.md): Barger Jerry L Challenger II · Clarion, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2014 · N4017C · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…
- [NTSB ENG14IA028](https://openairdocs.org/ntsb/ENG14IA028.md): Airbus A320 232 · Long Beach, CA · Incident · No injuries · Incident investigation · Final report · Sep 18, 2014 · N656JB · Minor damage
  > The probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…
- [NTSB ANC14CA079](https://openairdocs.org/ntsb/ANC14CA079.md): Piper PA 18-135 · Susitna, AK · Accident · No injuries · Data collection · Final report · Sep 13, 2014 · N959E · Substantial damage
  > The pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.
- [NTSB ERA14CA430](https://openairdocs.org/ntsb/ERA14CA430.md): Cessna 172M · Watertown, CT · Accident · Minor injuries · Data collection · Final report · Sep 9, 2014 · N20469 · Substantial damage
  > The pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…
- [NTSB ERA14FA428](https://openairdocs.org/ntsb/ERA14FA428.md): Cessna 172 · Selkirk, NY · Accident · 2 fatal · Field investigation · Final report · Sep 8, 2014 · N79438 · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA14LA418](https://openairdocs.org/ntsb/ERA14LA418.md): Lorenz Stephen Kitfox Series 5 · Greene, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2014 · N94SL · Destroyed
  > The pilot’s failure to attain adequate airspeed during the initial climb, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the…
- [NTSB ERA14FA417](https://openairdocs.org/ntsb/ERA14FA417.md): Cessna 180 · North Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Sep 1, 2014 · N6510A · Substantial damage
  > The pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…
- [NTSB ANC14LA071](https://openairdocs.org/ntsb/ANC14LA071.md): Dehavilland DHC 2 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2014 · N93E · Substantial damage
  > The loss of engine power during takeoff due to a malfunction of the engine-driven fuel pump.
- [NTSB ERA14FA416](https://openairdocs.org/ntsb/ERA14FA416.md): Piper PA-25-260 · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2014 · N254AB · Substantial damage
  > The pilot's improper deployment of the banner-tow hook, which resulted in it becoming entangled between the left elevator and horizontal stabilizer, restricted the movement of the elevator, and led to a loss of airplane control.
- [NTSB WPR14LA361](https://openairdocs.org/ntsb/WPR14LA361.md): Travel Air C 4000 · Williams, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2014 · N9952 · Substantial damage
  > The failure of the elevator control tube due to corrosion, which resulted in a loss of elevator control and collision with terrain.
- [NTSB WPR14FA355](https://openairdocs.org/ntsb/WPR14FA355.md): Thomas C Sikes Loehle 5151 Mustang · Chehalis, WA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2014 · N73144 · Destroyed
  > The pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…
- [NTSB CEN14LA456](https://openairdocs.org/ntsb/CEN14LA456.md): Maule MT 7-235 · Edon, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2014 · N627RK · Substantial damage
  > The pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.
- [NTSB ERA14LA404](https://openairdocs.org/ntsb/ERA14LA404.md): Piper PA-28-180 · Gaithersburg, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2014 · N9095J · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.
- [NTSB WPR14CA350](https://openairdocs.org/ntsb/WPR14CA350.md): Schweizer SGS 1 34 · Marana, AZ · Accident · Minor injuries · Data collection · Final report · Aug 19, 2014 · N7628 · Substantial damage
  > The pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.
- [NTSB CEN14LA439](https://openairdocs.org/ntsb/CEN14LA439.md): Air Tractor AT-401 · Wray, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 2014 · N4542W · Substantial damage
  > A loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…
- [NTSB CEN14FA437](https://openairdocs.org/ntsb/CEN14FA437.md): Lancair LC 40 550FG · Ranger, TX · Accident · 3 fatal · Field investigation · Final report · Aug 17, 2014 · N6500Z · Destroyed
  > The pilot's loss of airplane control shortly after takeoff as a result of spatial disorientation due to dark night conditions, the pilot's low overall night and instrument flight time, and his lack of recent night flights.
- [NTSB CEN14FA435](https://openairdocs.org/ntsb/CEN14FA435.md): Cessna 172N · Natchitoches, LA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2014 · N734YW · Substantial damage
  > The partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…
- [NTSB ERA14LA388](https://openairdocs.org/ntsb/ERA14LA388.md): Piper PA-28-161 · Buffalo, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2014 · N706GS · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA14FA387](https://openairdocs.org/ntsb/ERA14FA387.md): Cessna 150 · Mount Pleasant, SC · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2014 · N66241 · Substantial damage
  > The commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…
- [NTSB CEN14LA432](https://openairdocs.org/ntsb/CEN14LA432.md): Cessna 188 - Undesignat · Columbus, NM · Accident · No injuries · Limited investigation · Final report · Aug 13, 2014 · N9849V · Substantial damage
  > The pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…
- [NTSB WPR14LA338](https://openairdocs.org/ntsb/WPR14LA338.md): Nelson RV 3M · North Plains, OR · Accident · No injuries · Class 3 · Limited · Final report · Aug 10, 2014 · N43AZ · Substantial damage
  > A partial loss of engine power for undetermined reasons which resulted in a landing gear collapse during the precautionary landing to a field.
- [NTSB WPR14LA336](https://openairdocs.org/ntsb/WPR14LA336.md): Piper PA 32R-300 · West Jordan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2014 · N4646F · Destroyed
  > A partial loss of engine power during initial climb for reasons that could not be determined due to the severity of the damage to the engine.
- [NTSB WPR14LA335](https://openairdocs.org/ntsb/WPR14LA335.md): Cessna 180A · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Aug 10, 2014 · N7784A · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14CA333](https://openairdocs.org/ntsb/WPR14CA333.md): Kitfox Series 5 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Aug 9, 2014 · N910MK · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.
- [NTSB ERA14FA377](https://openairdocs.org/ntsb/ERA14FA377.md): Cessna 150 · Senoia, GA · Accident · 2 fatal · Field investigation · Final report · Aug 9, 2014 · N7968Z · Destroyed
  > The noninstrument-rated 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 subsequent collision with terrain.
- [NTSB ERA14CA385](https://openairdocs.org/ntsb/ERA14CA385.md): Cote James Rans S 6S · New Berlin, PA · Accident · No injuries · Data collection · Final report · Aug 4, 2014 · N502CW · Substantial damage
  > The passenger's inadvertent interference with the rudder controls during the takeoff.
- [NTSB ERA14FA372](https://openairdocs.org/ntsb/ERA14FA372.md): Cessna 182F · Gansevoort, NY · Accident · 2 fatal · Field investigation · Final report · Aug 2, 2014 · N1DZ · Destroyed
  > The pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.
- [NTSB WPR14FA320](https://openairdocs.org/ntsb/WPR14FA320.md): Mooney M20L - NO Series · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Jul 31, 2014 · N147MP · Substantial damage
  > The pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…
- [NTSB ERA14LA363](https://openairdocs.org/ntsb/ERA14LA363.md): Temco GC 1B · Yulee, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2014 · N1CY · Substantial damage
  > The pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.
- [NTSB ERA14FA359](https://openairdocs.org/ntsb/ERA14FA359.md): Piper PA-46-310P · Clayton, GA · Accident · 1 fatal · Field investigation · Final report · Jul 26, 2014 · N248SP · Destroyed
  > The pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.
- [NTSB CEN14CA392](https://openairdocs.org/ntsb/CEN14CA392.md): Bellanca 7GCBC · Caputa, SD · Accident · No injuries · Data collection · Final report · Jul 26, 2014 · N5530K · Substantial damage
  > The student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.
- [NTSB ERA14LA351](https://openairdocs.org/ntsb/ERA14LA351.md): Siler Ronald E Ultrastar · Halifax, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2014 · N4425W · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…
- [NTSB WPR14LA309](https://openairdocs.org/ntsb/WPR14LA309.md): Beech A36 · Pago Pago, Antarctica · Accident · 2 fatal · Limited investigation · Final report · Jul 22, 2014 · N20TC · Destroyed
  > A loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.

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

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

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