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

## Cases, newest first

- [NTSB CEN15FA214](https://openairdocs.org/ntsb/CEN15FA214.md): Beech B35 · Orange, TX · Accident · Serious injuries · Field investigation · Final report · May 2, 2015 · N5176C · Substantial damage
  > The impact with power lines for reasons that could not be determined based on the available information.
- [NTSB DCA15CA117](https://openairdocs.org/ntsb/DCA15CA117.md): Titan Aerospace Holdings Solara 50 · Otto, NM · Accident · No injuries · Data collection · Final report · May 1, 2015 · N950TA · Destroyed
  > structural failure of the left wing due to an overspeed condition.
- [NTSB ERA15LA200](https://openairdocs.org/ntsb/ERA15LA200.md): Diamond Aircraft Ind DA 20 C1 · Sylacauga, AL · Accident · No injuries · Limited investigation · Final report · Apr 27, 2015 · N248ME · Substantial damage
  > A partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.
- [NTSB ERA15LA197](https://openairdocs.org/ntsb/ERA15LA197.md): James Kilroy Pitts Model 12 · LaGrange, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 2015 · N488WT · Substantial damage
  > A partial loss of engine power after takeoff 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 ENG15RA023](https://openairdocs.org/ntsb/ENG15RA023.md): Boeing 400 · Islamabad, Pakistan, Pakistan · Incident · No injuries · Foreign investigation · Apr 21, 2015 · AP-BJT · No damage
  > On April 21, 2015, a Shaheen Air International (SAI) Boeing 737-400, powered by CFMI CFM56-3C1 turbofan engines, experienced a No. 1 (left engine) failure while climbing through 3,200 feet. The flight crew heard a loud band and high exhaust gas temperature…
- [NTSB WPR15LA167](https://openairdocs.org/ntsb/WPR15LA167.md): Beech F33A · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Apr 18, 2015 · N84MD · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…
- [NTSB CEN15LA199](https://openairdocs.org/ntsb/CEN15LA199.md): Cessna 421B · Diboll, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2015 · N421PK · Substantial damage
  > The total loss of engine power due to the use of an improper fuel type. Contributing to the accident were the servicing of the airplane with the improper fuel, noncompliance with an airworthiness directive, and the fuel nozzle installed on the fueling truck.
- [NTSB ERA15LA187](https://openairdocs.org/ntsb/ERA15LA187.md): Piper PA-28-140 · Lancaster, NY · Accident · No injuries · Limited investigation · Final report · Apr 15, 2015 · N7598R · Substantial damage
  > The loss of engine power during takeoff for reasons that could not be determined during postaccident examination of the engine or testing of the carburetor.
- [NTSB ERA15LA184](https://openairdocs.org/ntsb/ERA15LA184.md): Cessna 162 · Shelter Island, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2015 · N30283 · Substantial damage
  > The pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.
- [NTSB ANC15LA020](https://openairdocs.org/ntsb/ANC15LA020.md): Cessna 170B · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Apr 13, 2015 · N4697C · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no mechanical anomalies that would have precluded normal operation.
- [NTSB WPR15FA144](https://openairdocs.org/ntsb/WPR15FA144.md): Schempp-Hirth Standard Cirrus · Prescott Valley, AZ · Accident · 1 fatal · Field investigation · Final report · Apr 11, 2015 · N352D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack during the initial climb after a ground-tow launch, which resulted in an aerodynamic stall/spin.
- [NTSB WPR15LA141](https://openairdocs.org/ntsb/WPR15LA141.md): Piper PA 28R-200 · Santa Maria, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 2015 · N5469T · Substantial damage
  > The engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…
- [NTSB DCA15WA211](https://openairdocs.org/ntsb/DCA15WA211.md): Ayres S2R · Penja, Cameroon · Accident · No injuries · Foreign investigation · Apr 1, 2015 · TJ-AII · Substantial damage
  > The Cameroon Civil Aviation Authority (CCAA) has notified the NTSB of an accident involving a Ayres S2R-T34 airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…
- [NTSB CEN15FA187](https://openairdocs.org/ntsb/CEN15FA187.md): Aircraft Mfg & Dvlpmt CH601XL · Pleasanton, KS · Accident · 2 fatal · Field investigation · Final report · Mar 31, 2015 · N623HS · Destroyed
  > The pilot's excessively high angle-of-attack on rotation that prevented the airplane from climbing sufficiently to avoid the approaching trees.
- [NTSB GAA15CA028](https://openairdocs.org/ntsb/GAA15CA028.md): Let L23 - NO Series · Los Alamitos, CA · Accident · Minor injuries · Data collection · Final report · Mar 29, 2015 · N381BA · Substantial damage
  > The inadvertent deployment of the air brakes during initial climb, resulting in a loss of lift. Contributing to the accident was the pilot's failure to identify and remediate the cause.
- [NTSB ERA15FA170](https://openairdocs.org/ntsb/ERA15FA170.md): Piper PA-28-140 · Orange, VA · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2015 · N32396 · Substantial damage
  > The student pilot's failure to maintain adequate airspeed after takeoff, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN15LA183](https://openairdocs.org/ntsb/CEN15LA183.md): Beech 35 · Gordonville, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 2015 · N80462 · Substantial damage
  > The pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…
- [NTSB CEN15LA182](https://openairdocs.org/ntsb/CEN15LA182.md): Air Tractor AT 400 · Levelland, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 2015 · N136DB · Substantial damage
  > The in-flight separation of the left aileron's attachment hardware at the connection between the long aileron pushrod and the left aileron bellcrank. Contributing to the accident was maintenance personnel’s improper installation of, or failure to install, the…
- [NTSB DCA15WA106](https://openairdocs.org/ntsb/DCA15WA106.md): Boeing Boeing 737-8AS · Lametia, Italy · Incident · No injuries · Foreign investigation · Mar 25, 2015 · EI-EGC · Minor damage
  > The ANSV of Italy has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB GAA15CA020](https://openairdocs.org/ntsb/GAA15CA020.md): Cessna 150 · Flushing, MI · Accident · Minor injuries · Data collection · Final report · Mar 24, 2015 · N7987E · Substantial damage
  > Loss of engine power due to fuel contamination. A factor contributing to the accident was the pilot's inadequate preflight.
- [NTSB CEN15LA179](https://openairdocs.org/ntsb/CEN15LA179.md): Picard Roy J RV 4 · Marathon, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2015 · N945RV · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of any mechanical anomalies that would have precluded normal operation.
- [NTSB WPR15LA130](https://openairdocs.org/ntsb/WPR15LA130.md): Vans RV6A · Green Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 2015 · N811KM · Substantial damage
  > The total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.
- [NTSB ERA15RA163](https://openairdocs.org/ntsb/ERA15RA163.md): Beech B90 · Punta del Este, Uruguay · Accident · 10 fatal · Foreign investigation · Mar 19, 2015 · LV-CEO · Destroyed
  > On March 19, 2015, about 20:38 Local Time, a Beech Model B90 King Air, Argentine Registration LV-CEO, operated by Drogueria Meta, S.A., impacted water in Laguna del Sauce, Punta del Este, Uruguay. Night visual meteorological conditions prevailed, and flight…
- [NTSB ERA15LA219](https://openairdocs.org/ntsb/ERA15LA219.md): Rainbow Aerotrike · Chesnee, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 9, 2015 · UNREG · Substantial damage
  > The pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.
- [NTSB ERA15LA151](https://openairdocs.org/ntsb/ERA15LA151.md): Piper PA23 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Mar 9, 2015 · N1153P · Substantial damage
  > The total loss of right 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 WPR15FA121](https://openairdocs.org/ntsb/WPR15FA121.md): Ryan Aeronautical ST3KR · Santa Monica, CA · Accident · Serious injuries · Field investigation · Final report · Mar 5, 2015 · N53178 · Substantial damage
  > A total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…
- [NTSB WPR15CA118](https://openairdocs.org/ntsb/WPR15CA118.md): Christopher Jon Brown Stol CH750 · Palmdale, CA · Accident · No injuries · Data collection · Final report · Mar 3, 2015 · N756AC · Substantial damage
  > The pilot's failure to maintain airplane control when he exceeded the airplane's critical angle of attack during climb out which resulted in a loss of airspeed and subsequent aerodynamic stall.
- [NTSB ERA15FA139](https://openairdocs.org/ntsb/ERA15FA139.md): Adams Donald L DA1 · Sebring, FL · Accident · 1 fatal · Field investigation · Final report · Mar 2, 2015 · N797A · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR15LA104](https://openairdocs.org/ntsb/WPR15LA104.md): Scottish Bulldog - 120 121 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Feb 15, 2015 · N706BD · Substantial damage
  > A total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the pilot’s inadequate preflight inspection of the fuel system.
- [NTSB ENG15WA034](https://openairdocs.org/ntsb/ENG15WA034.md): Airbus A320 · Tehran, Iran · Incident · No injuries · Foreign investigation · Feb 15, 2015 · EP-TTB · No damage
  > The Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…
- [NTSB ERA15LA130](https://openairdocs.org/ntsb/ERA15LA130.md): Robertson James F Velocity STD/RG E · Sebastian, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 2015 · N112TH · Substantial damage
  > The pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…
- [NTSB ERA15FA128](https://openairdocs.org/ntsb/ERA15FA128.md): Piper PA28 · Greensboro, NC · Accident · 1 fatal · Field investigation · Final report · Feb 11, 2015 · N5985U · Substantial damage
  > A total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.
- [NTSB WPR15LA087](https://openairdocs.org/ntsb/WPR15LA087.md): Piper PA 28-140 · Helena, MT · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 2015 · N4666R · Substantial damage
  > Loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any evidence of an anomaly that would have precluded normal operation.
- [NTSB CEN15LA112](https://openairdocs.org/ntsb/CEN15LA112.md): Mooney M20C · Lonoke county, AR · Accident · No injuries · Limited investigation · Final report · Jan 17, 2015 · N6474U · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB CEN15LA109](https://openairdocs.org/ntsb/CEN15LA109.md): Cessna 182R · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Jan 15, 2015 · N9611H · Substantial damage
  > The pilot’s failure to remove ice from the airplane’s surfaces before departure, which resulted in the airplane’s inability to attain sufficient airspeed shortly after takeoff, the subsequent exceedance of the airplane’s critical angle-of-attack, and an…
- [NTSB WPR15LA084](https://openairdocs.org/ntsb/WPR15LA084.md): Bruct J Myers RV-9A · Prineville, OR · Accident · 1 fatal · Limited investigation · Final report · Jan 11, 2015 · N8080S · Destroyed
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.
- [NTSB ERA15WA112](https://openairdocs.org/ntsb/ERA15WA112.md): Embraer EMB-710C · Luziania, Brazil · Accident · 2 fatal · Foreign investigation · Jan 10, 2015 · PT-NAB · Substantial damage
  > On January 10, 2015, about 2105 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NAB, was substantially damaged when it impacted a residence, after experiencing a loss of engine power during the initial climb after takeoff from the…
- [NTSB WPR15FA081](https://openairdocs.org/ntsb/WPR15FA081.md): Gibbs Lancair 320 · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Jan 9, 2015 · N7ZL · Substantial damage
  > The pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…
- [NTSB ENG15RA030](https://openairdocs.org/ntsb/ENG15RA030.md): Pac 750XL - NO Series · Taupo, New Zealand, New Zealand · Accident · No injuries · Foreign investigation · Jan 7, 2015 · ZK-SDT · Destroyed
  > On 7 January 2015, a Pacific Aerospace Limited 750XL airplane, registration No. ZK-SDT, while performing commercial skydiving operations, experienced an engine failure while climbing through approximately 3000 feet, after take-off from Taupo Aerodrome in the…
- [NTSB ERA15LA094](https://openairdocs.org/ntsb/ERA15LA094.md): Cessna 172 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Jan 6, 2015 · N2102P · Substantial damage
  > The engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.
- [NTSB ERA15LA092](https://openairdocs.org/ntsb/ERA15LA092.md): Beech V35B · Long View, NC · Accident · Serious injuries · Limited investigation · Final report · Jan 6, 2015 · N246JT · Substantial damage
  > The improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.
- [NTSB CEN15FA090](https://openairdocs.org/ntsb/CEN15FA090.md): Cessna 404 · Englewood, CO · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2014 · N404MG · Substantial damage
  > The loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.
- [NTSB ERA15WA098](https://openairdocs.org/ntsb/ERA15WA098.md): Aerospatiale AS350B · Bertioga, Brazil · Accident · 5 fatal · Foreign investigation · Dec 27, 2014 · PT-HNC · Destroyed
  > On December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…
- [NTSB WPR15CA059](https://openairdocs.org/ntsb/WPR15CA059.md): Cessna 182T · Wendover, UT · Accident · Serious injuries · Data collection · Final report · Dec 12, 2014 · N961GW · Substantial damage
  > The pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.
- [NTSB CEN15IA079](https://openairdocs.org/ntsb/CEN15IA079.md): Cessna T182T · Cahokia, IL · Incident · No injuries · Incident investigation · Final report · Dec 12, 2014 · N93CL · No damage
  > The mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.
- [NTSB ERA15LA071](https://openairdocs.org/ntsb/ERA15LA071.md): Cessna 210 5(205) · Sussex, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2014 · N8296Z · Substantial damage
  > Maintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.
- [NTSB WPR15IA046](https://openairdocs.org/ntsb/WPR15IA046.md): Embraer EMB-505 · Palm Springs, CA · Incident · No injuries · Incident investigation · Final report · Nov 23, 2014 · C-GJOL · Minor damage
  > The failure of the gust lock actuator solenoid for reasons that could not be determined because postaccident examination of the rudder gust lock system revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ANC15LA004](https://openairdocs.org/ntsb/ANC15LA004.md): Helio H 295 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Nov 15, 2014 · N6465V · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical anomalies.
- [NTSB CEN15FAMS1](https://openairdocs.org/ntsb/CEN15FAMS1.md): Cessna 172K · Lake Pontchartrain, LA · Accident · 2 fatal · Missing aircraft · Final report · Nov 13, 2014 · N46707 · Destroyed
  > The airplane's collision with water for reasons that could not be determined because the wreckage was not located.
- [NTSB ERA15CA056](https://openairdocs.org/ntsb/ERA15CA056.md): Cessna 172S · Sarasota, FL · Accident · No injuries · Data collection · Final report · Nov 12, 2014 · N60155 · Substantial damage
  > The student pilot's failure to maintain airplane control during the initial climb, resulting in a runway excursion and substantial damage to the engine firewall. The student pilot's lack of overall flying experience was a factor.

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

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

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