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

## Cases, newest first

- [NTSB CEN13FA509](https://openairdocs.org/ntsb/CEN13FA509.md): Cessna 421C · Paris, IL · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2013 · N229H · Destroyed
  > The pilot's failure to abort the takeoff during the ground roll after detecting the airplane's degraded performance. Contributing to the accident was the pilot's decision to attempt a flight with a known problem with the left engine and the likely partial…
- [NTSB ERA13LA380](https://openairdocs.org/ntsb/ERA13LA380.md): Piper PA46R-350T · Cat Cay, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2013 · N720JF · Substantial damage
  > The pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…
- [NTSB ERA13FA372](https://openairdocs.org/ntsb/ERA13FA372.md): Aeronca 7AC · Taunton, MA · Accident · 2 fatal · Field investigation · Final report · Aug 25, 2013 · N83863 · Destroyed
  > The pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…
- [NTSB DCA13WA144](https://openairdocs.org/ntsb/DCA13WA144.md): Airbus Industrie A300B4-622R · Luton, United Kingdom · Incident · No injuries · Foreign investigation · Aug 25, 2013 · N721FD · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A300 operated by Federal Express Corp, which occurred on August 25, 2013. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB WPR13LA384](https://openairdocs.org/ntsb/WPR13LA384.md): Piper PA 28 · Sacramento, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 2013 · N8223W · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined because postaccident examination revealed no evidence of preimpact mechanical malfunction or failure that would have precluded normal operation.
- [NTSB WPR13FA386](https://openairdocs.org/ntsb/WPR13FA386.md): Piper PA 28 · Tehachapi, CA · Accident · Serious injuries · Field investigation · Final report · Aug 24, 2013 · N32582 · Substantial damage
  > The pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.
- [NTSB CEN13LA502](https://openairdocs.org/ntsb/CEN13LA502.md): Anderas Tiger Moth R80 · New Franken, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2013 · N927TM · Substantial damage
  > The 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 ERA13LA370](https://openairdocs.org/ntsb/ERA13LA370.md): Beech C23 · Bingham, ME · Accident · No injuries · Limited investigation · Final report · Aug 20, 2013 · N243RG · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.
- [NTSB CEN13FA496](https://openairdocs.org/ntsb/CEN13FA496.md): Mooney M20J · Kansas City, MO · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2013 · N9201R · Substantial damage
  > The pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…
- [NTSB ERA13LA366](https://openairdocs.org/ntsb/ERA13LA366.md): Interstate S-1B1 · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Aug 17, 2013 · N46336 · Substantial damage
  > The pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…
- [NTSB ERA13CA354](https://openairdocs.org/ntsb/ERA13CA354.md): Stetson Norman B Challenger II · Orange, MA · Accident · No injuries · Data collection · Final report · Aug 6, 2013 · N94454 · Substantial damage
  > The pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.
- [NTSB ERA13CA350](https://openairdocs.org/ntsb/ERA13CA350.md): Cessna 172S · Portsmouth, NH · Accident · No injuries · Data collection · Final report · Aug 3, 2013 · N645PD · Substantial damage
  > The pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.
- [NTSB CEN13LA460](https://openairdocs.org/ntsb/CEN13LA460.md): Snyder Todd W Titan Tornado 1 · Wild Rose, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2013 · N70786 · Substantial damage
  > The improperly secured spark plug, which resulted in a total loss of engine power.
- [NTSB CEN13FA456](https://openairdocs.org/ntsb/CEN13FA456.md): Cirrus Design SR22 · Chesterfield, MO · Accident · 2 fatal · Field investigation · Final report · Aug 3, 2013 · N225CD · Destroyed
  > The pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.
- [NTSB ERA13LA346](https://openairdocs.org/ntsb/ERA13LA346.md): Fpna A-22 Valor · Wurtsboro, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 2013 · N912FP · Substantial damage
  > The pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.
- [NTSB WPR13LA347](https://openairdocs.org/ntsb/WPR13LA347.md): Airborne Windsports PTY Edge XT-912-L · Red Bluff, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 29, 2013 · N123FJ · Destroyed
  > The pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.
- [NTSB WPR13LA346](https://openairdocs.org/ntsb/WPR13LA346.md): Beech 35-B33 · Lone Pine, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2013 · N82182 · Substantial damage
  > A partial loss of engine power after takeoff 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 pilot's decision to not…
- [NTSB CEN13LA455](https://openairdocs.org/ntsb/CEN13LA455.md): Piper PA-28-140 · Lafayette, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2013 · N286P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA13LA339](https://openairdocs.org/ntsb/ERA13LA339.md): Cessna 172M · Farmingdale, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2013 · N61929 · Substantial damage
  > The airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.
- [NTSB CEN13FA432](https://openairdocs.org/ntsb/CEN13FA432.md): Piper PA-30 · Amarillo, TX · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2013 · N8306Y · Substantial damage
  > The pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.
- [NTSB WPR13FA335](https://openairdocs.org/ntsb/WPR13FA335.md): Mooney M20C · South Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2013 · N6709U · Substantial damage
  > The pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.
- [NTSB ERA13LA347](https://openairdocs.org/ntsb/ERA13LA347.md): Durfee Fred Quicksilver MXL · Lexington, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2013 · N2590B · Substantial damage
  > The student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…
- [NTSB ERA13FA325](https://openairdocs.org/ntsb/ERA13FA325.md): Beech 23 · Laurel, MD · Accident · Serious injuries · Field investigation · Final report · Jul 18, 2013 · N2333Z · Substantial damage
  > The pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.
- [NTSB ERA13LA323](https://openairdocs.org/ntsb/ERA13LA323.md): Johnson Garret W Merlin GT · Collierville, TN · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2013 · N618V · Destroyed
  > The total loss of engine power during takeoff for reasons that could not be determined during postaccident examination due to postcrash fire damage.
- [NTSB CEN13LA418](https://openairdocs.org/ntsb/CEN13LA418.md): Marino Benoist Type XIV · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Jul 16, 2013 · N613LD · Substantial damage
  > The pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.
- [NTSB WPR13CA330](https://openairdocs.org/ntsb/WPR13CA330.md): Kincaid Wade Dakota Hawk · San Simon, AZ · Accident · Serious injuries · Data collection · Final report · Jul 14, 2013 · N544WK · Substantial damage
  > The pilot's failure to maintain clearance from power lines during takeoff from an open field.
- [NTSB WPR13CA325](https://openairdocs.org/ntsb/WPR13CA325.md): Boeing E75 · Bozeman, MT · Accident · No injuries · Data collection · Final report · Jul 14, 2013 · N5176N · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a turn, which resulted in a loss of lift and collision with terrain.
- [NTSB WPR13LA321](https://openairdocs.org/ntsb/WPR13LA321.md): Raytheon A36 · Fallon, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2013 · N517DJ · Substantial damage
  > A fatigue failure of the No. 5 connecting rod, which resulted in a catastrophic engine failure during the initial climb and a subsequent forced landing.
- [NTSB WPR13CA323](https://openairdocs.org/ntsb/WPR13CA323.md): Cessna 152 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Jul 10, 2013 · N46566 · Substantial damage
  > The student pilot’s failure to maintain aircraft control during the initial climb, which resulted in a collision with a powerline.
- [NTSB DCA13MA121](https://openairdocs.org/ntsb/DCA13MA121.md): Dehavilland DHC-3 · Soldotna, AK · Accident · 10 fatal · Major investigation · Final report · Jul 7, 2013 · N93PC · Destroyed
  > The operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…
- [NTSB WPR13CA311](https://openairdocs.org/ntsb/WPR13CA311.md): Bellanca 8GCBC · Long Beach, CA · Accident · Minor injuries · Data collection · Final report · Jul 6, 2013 · N613AP · Substantial damage
  > The pilot did not maintain adequate airspeed which resulted in an inadvertent stall and loss of aircraft control. Contributing to the accident was the pilot's improper use of flaps.
- [NTSB WPR13FA300](https://openairdocs.org/ntsb/WPR13FA300.md): Allstar PZL Glider SZD-54-2 Perkoz · Jacumba, CA · Accident · 2 fatal · Field investigation · Final report · Jun 29, 2013 · N684SD · Substantial damage
  > The premature release of the towline from the glider and the glider’s subsequent right banking turn at low altitude for reasons that could not be determined because postaccident airframe examination did not reveal any evidence of a mechanical malfunction or…
- [NTSB WPR13FA298](https://openairdocs.org/ntsb/WPR13FA298.md): Ayers Less Drag Special · Oxnard, CA · Accident · 2 fatal · Field investigation · Final report · Jun 29, 2013 · N130LD · Substantial damage
  > A loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the pilot’s failure to maintain adequate airspeed, which resulted in an…
- [NTSB ANC13LA059](https://openairdocs.org/ntsb/ANC13LA059.md): Cessna 175 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 2013 · N7698M · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation..
- [NTSB WPR13CA297](https://openairdocs.org/ntsb/WPR13CA297.md): Charles Peet Zenith CH 701 · Jackson, WY · Accident · Minor injuries · Data collection · Final report · Jun 28, 2013 · N44CP · Substantial damage
  > The pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff/initial climb.
- [NTSB WPR13FA281](https://openairdocs.org/ntsb/WPR13FA281.md): Piper PA-30 · Idaho Falls, ID · Accident · 2 fatal · Field investigation · Final report · Jun 22, 2013 · N830SS · Substantial damage
  > A loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.
- [NTSB ERA13LA297](https://openairdocs.org/ntsb/ERA13LA297.md): Beech G-36 · Pompano Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 2013 · N7513 · Substantial damage
  > The pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.
- [NTSB CEN13FA364](https://openairdocs.org/ntsb/CEN13FA364.md): Cessna 172M · Waterford, MI · Accident · 4 fatal · Field investigation · Final report · Jun 21, 2013 · N9926Q · Destroyed
  > The pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.
- [NTSB CEN13LA363](https://openairdocs.org/ntsb/CEN13LA363.md): Thomsen Avid Flyer MK IV · Hibbing, MN · Accident · No injuries · Limited investigation · Final report · Jun 20, 2013 · N6240T · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA358](https://openairdocs.org/ntsb/CEN13LA358.md): Piper PA-28R-180 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jun 18, 2013 · N7444J · Substantial damage
  > The pilot's improper decision to take off with a tailwind at a high-density altitude, which resulted in the airplane’s failure to maintain the initial climb rate.
- [NTSB CEN13LA354](https://openairdocs.org/ntsb/CEN13LA354.md): Cessna 152 · Carrizo Springs, TX · Accident · No injuries · Limited investigation · Final report · Jun 17, 2013 · N49108 · Substantial damage
  > The pilot’s failure to identify the water contamination of the fuel system during his preflight inspection, which resulted in a total loss of engine power during the airplane’s initial climb.
- [NTSB WPR13LA274](https://openairdocs.org/ntsb/WPR13LA274.md): Cessna T210L · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Jun 16, 2013 · N94086 · Substantial damage
  > A hydraulic fluid leak in the nose landing gear actuator rod seal, which prevented the hydraulic system from building up sufficient pressure to fully retract or extend the main landing gear.
- [NTSB CEN13FA352](https://openairdocs.org/ntsb/CEN13FA352.md): Aero Commander 685 · Victoria, TX · Accident · Serious injuries · Field investigation · Final report · Jun 15, 2013 · N74CP · Substantial damage
  > Maintenance personnel's failure to secure the left engine idler pin during overhaul, which resulted in a catastrophic engine failure and subsequent forced landing.
- [NTSB ERA13WA287](https://openairdocs.org/ntsb/ERA13WA287.md): Piper PA22 · Taisha, Ecuador · Accident · 4 fatal · Foreign investigation · Jun 13, 2013 · HC-CMX · Substantial damage
  > On June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…
- [NTSB ERA13CA283](https://openairdocs.org/ntsb/ERA13CA283.md): Hughes TH-55A · Morgantown, WV · Accident · No injuries · Data collection · Final report · Jun 12, 2013 · N7057H · Substantial damage
  > The pilot’s inadequate planning which resulted in an encounter with settling with power and descent into terrain during takeoff.
- [NTSB WPR13CA263](https://openairdocs.org/ntsb/WPR13CA263.md): Garland Avipro Bearhawk · Sheridan, WY · Accident · Minor injuries · Data collection · Final report · Jun 7, 2013 · N540TH · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in a stall and a loss of aircraft control during the initial takeoff.
- [NTSB ERA13WA306](https://openairdocs.org/ntsb/ERA13WA306.md): Piper PA34 · Envira, Brazil · Accident · 1 fatal · Foreign investigation · Jun 7, 2013 · PT-MMX · Substantial damage
  > On June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…
- [NTSB ERA13LA270](https://openairdocs.org/ntsb/ERA13LA270.md): Maule BEE DEE M-4-210 · Cuttyhunk, MA · Accident · 1 fatal · Limited investigation · Final report · Jun 5, 2013 · N9807M · Substantial damage
  > The pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB ERA13LA269](https://openairdocs.org/ntsb/ERA13LA269.md): Stinson 108 · Elkton, KY · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2013 · N97592 · Substantial damage
  > The pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.
- [NTSB ERA13IA267](https://openairdocs.org/ntsb/ERA13IA267.md): Piper PA-34-200T · Tallahassee, FL · Incident · No injuries · Incident investigation · Final report · Jun 3, 2013 · N633TC · No damage
  > The failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.

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

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

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