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

## Cases, newest first

- [NTSB ERA15LA279](https://openairdocs.org/ntsb/ERA15LA279.md): Kinner Sportster B · Eagles Mere, PA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2015 · NC13776 · Substantial damage
  > The total 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 ENG15RA028](https://openairdocs.org/ntsb/ENG15RA028.md): Airbus A330 - 223 · Riyadh, Saudi Arabia, Saudi Arabia · Incident · No injuries · Foreign investigation · Jul 23, 2015 · HL8211 · No damage
  > On July 23, 2015, at about 12:23 UTC, a Korean Air Airbus A330-223, registration number HL8211, experienced a No. 1 (left engine) stall after initial takeoff from the King Khalid International Airport (KSA) in Riyadh, Saudi Arabia. The flight crew received a…
- [NTSB CEN15LA319](https://openairdocs.org/ntsb/CEN15LA319.md): Cessna 182E · Rozet, WY · Accident · No injuries · Limited investigation · Final report · Jul 22, 2015 · N3344Y · Substantial damage
  > The loss of engine power for reasons that could not be determined because an examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ANC15LA056](https://openairdocs.org/ntsb/ANC15LA056.md): Piper PA 18-150 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jul 21, 2015 · N8761C · Substantial damage
  > The pilot's failure to attain adequate airspeed during initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue a takeoff even though the airplane was not airborne by the…
- [NTSB WPR15LA217](https://openairdocs.org/ntsb/WPR15LA217.md): Piper PA 28-181 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2015 · N8740E · Destroyed
  > The engine's inability to produce full-rated power due to wear on internal engine components, which resulted in a loss of altitude and subsequent landing on uneven terrain. Contributing to the accident was the airplane owner's failure to maintain the engine…
- [NTSB ERA15LA269](https://openairdocs.org/ntsb/ERA15LA269.md): Cessna 162 · Dunkirk, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2015 · N6047W · Substantial damage
  > The pilot's failure to maintain control of the airplane while attempting to close an open cabin door, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ENG15WA027](https://openairdocs.org/ntsb/ENG15WA027.md): Airbus A330 - 323 · Incheon, Republic of Korea, South Korea · Incident · No injuries · Foreign investigation · Jul 14, 2015 · HL8282 · No damage
  > On July 14, 2015 at about 0832 universal coordinated time, an Airbus A330-300, HL8282, operated by Asiana Airlines experienced No. 2 (right) engine fire and oil pressure warnings shortly after takeoff from Incheon International Airport (ICN), Incheon,…
- [NTSB CEN15LA306](https://openairdocs.org/ntsb/CEN15LA306.md): Air Creation Clipper 582 · Clark, SD · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 2015 · UNREG · Substantial damage
  > The pilot's inability to maintain control of the weight-shift control aircraft during initial climb due to his impairment from ethanol, methamphetamine, cocaine, and marijuana.
- [NTSB ERA15LA265](https://openairdocs.org/ntsb/ERA15LA265.md): Luscombe 8A · Mount Dora, FL · Accident · No injuries · Limited investigation · Final report · Jul 11, 2015 · N28864 · Substantial damage
  > Excessive particulate contamination in the fuel tank, which resulted in the interruption of the fuel flow to the engine and a partial loss of power. The source of the contamination could not be determined based on the available information.
- [NTSB GAA15CA175](https://openairdocs.org/ntsb/GAA15CA175.md): Cessna 150J · Renton, WA · Accident · Minor injuries · Data collection · Final report · Jul 9, 2015 · N12MM · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.
- [NTSB CEN15LA298](https://openairdocs.org/ntsb/CEN15LA298.md): Cirrus Design SR22 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2015 · N422PB · Substantial damage
  > Maintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.
- [NTSB ERA15WA260](https://openairdocs.org/ntsb/ERA15WA260.md): Quest Kodiac 100 · Pskov, Russia · Accident · No injuries · Foreign investigation · Jul 6, 2015 · N642RM · Substantial damage
  > On July 6, 2015, about 1312 universal coordinated time, Quest Kodiak 100, U.S. registration N642RM, was substantially damaged by collision with terrain during a forced landing following a loss of engine power after takeoff from Pskov Airport, Pskov, Russia.…
- [NTSB CEN15WA299](https://openairdocs.org/ntsb/CEN15WA299.md): Rockwell International 112TCA · Kempten (Allgäu), Germany · Accident · 1 fatal · Foreign investigation · Jul 5, 2015 · N4708W · Substantial damage
- [NTSB ANC15LA044](https://openairdocs.org/ntsb/ANC15LA044.md): Piper PA-18 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Jul 3, 2015 · N9189D · Substantial damage
  > The 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 GAA15CA157](https://openairdocs.org/ntsb/GAA15CA157.md): Balloon Works FIREFLY8 - 24 · Provo, UT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2015 · N7148P · 2 aircraft · Substantial damage
  > **This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…
- [NTSB CEN15LA294](https://openairdocs.org/ntsb/CEN15LA294.md): Boeing A75N1 (PT17) · Louisburg, KS · Accident · No injuries · Limited investigation · Final report · Jul 2, 2015 · N44SN · Substantial damage
  > A partial loss of engine power for reasons that could not be determined during postaccident examinations.
- [NTSB CEN15FA287](https://openairdocs.org/ntsb/CEN15FA287.md): Piper PA 24-250 · Quinlan, TX · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2015 · N6168P · Destroyed
  > The pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…
- [NTSB CEN15LA284](https://openairdocs.org/ntsb/CEN15LA284.md): Cessna TR182 · Casper, WY · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2015 · N4751S · Substantial damage
  > The improper repair of the carburetor heat cable sheath to clamp joint, which prevented the proper operation of the carburetor heat and resulted in the loss of engine power.
- [NTSB ERA15FA245](https://openairdocs.org/ntsb/ERA15FA245.md): Czech Sport Piper Sport · Holly Ridge, NC · Accident · 1 fatal · Field investigation · Final report · Jun 21, 2015 · N35EP · Substantial damage
  > The pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.
- [NTSB CEN15LA279](https://openairdocs.org/ntsb/CEN15LA279.md): Mooney M20K · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Jun 21, 2015 · N1168Z · Substantial damage
  > Oil starvation due to preignition in the No. 5 cylinder as a result of failed spark plugs; the top and sides of the piston head were eroded, which allowed the exhaust gases caused by the preignition to pressurize the crankcase and force engine oil out of the…
- [NTSB CEN15LA451](https://openairdocs.org/ntsb/CEN15LA451.md): Cessna 150L · Carthage, IN · Accident · No injuries · Limited investigation · Final report · Jun 20, 2015 · N17292 · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB WPR15LA190](https://openairdocs.org/ntsb/WPR15LA190.md): Piper PA 20 · Yellow Pine, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2015 · N6939K · Substantial damage
  > The pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.
- [NTSB ERA15FA241](https://openairdocs.org/ntsb/ERA15FA241.md): Piper PA-22 · Laconia, NH · Accident · Serious injuries · Field investigation · Final report · Jun 18, 2015 · N2569P · Substantial damage
  > A total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.
- [NTSB CEN15FA277](https://openairdocs.org/ntsb/CEN15FA277.md): Northwing Design Apache Sport · Taos, NM · Accident · 1 fatal · Field investigation · Final report · Jun 18, 2015 · N51311 · Substantial damage
  > The powered-lift aircraft's departure from controlled flight for reasons that could not be determined from the available information.
- [NTSB CEN15WA327](https://openairdocs.org/ntsb/CEN15WA327.md): Raytheon Corporate Jets BAE 125 800 · Kerry, Ireland, Ireland · Incident · No injuries · Foreign investigation · Jun 16, 2015 · N1310H · No damage
  > The incident investigation is under the jurisdiction and control of the government of Ireland. This report is for information purposes only and contains only information released by or obtained from the government of Ireland. Further information pertaining to…
- [NTSB ERA15CA242](https://openairdocs.org/ntsb/ERA15CA242.md): Penell Mark A Rans S-10 KIT · Kirkville, NY · Accident · Serious injuries · Data collection · Final report · Jun 15, 2015 · N693MP · Substantial damage
  > Pilot's failure to maintain airspeed while maneuvering during the initial climb, which resulted in a loss of lift and subsequent off airport landing. Contributing to the accident was the pilot's failure to abort the takeoff after recognizing the airplane's…
- [NTSB ERA15LA239](https://openairdocs.org/ntsb/ERA15LA239.md): Stinson 108 · Dushore, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 2015 · N97505 · Substantial damage
  > The total loss of engine power during the 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 ERA15LA238](https://openairdocs.org/ntsb/ERA15LA238.md): Cessna T210 · Palmyra, PA · Accident · No injuries · Limited investigation · Final report · Jun 14, 2015 · N732VN · Substantial damage
  > The pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.
- [NTSB CEN15FA269](https://openairdocs.org/ntsb/CEN15FA269.md): Grumman American Avn. AA-5 · Fredericksburg, TX · Accident · 1 fatal · Field investigation · Final report · Jun 14, 2015 · N6552L · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…
- [NTSB CEN15FA267](https://openairdocs.org/ntsb/CEN15FA267.md): Beech A36 · Huggins, MO · Accident · 4 fatal · Field investigation · Final report · Jun 12, 2015 · N3193W · Destroyed
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.
- [NTSB CEN15FA264](https://openairdocs.org/ntsb/CEN15FA264.md): Bellanca 7GCBC · Kadoka, SD · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2015 · N11698 · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB ERA15WA236](https://openairdocs.org/ntsb/ERA15WA236.md): Beech C90 - GTI · Belo Horizonte City, Brazil · Accident · 3 fatal · Foreign investigation · Jun 7, 2015 · PR-AVG · Destroyed
  > On June 7, 2015, about 1823 UTC, a Textron Aviation C90GTi, Brazil registration PR-AVG, experienced a loss of control shortly after takeoff and crashed into a house near Belo Horizonte-Pampulha Airport (SBBH), Belo Horizonte City, Minas Gerais, Brazil. The…
- [NTSB CEN15LA258](https://openairdocs.org/ntsb/CEN15LA258.md): Flight Design Ctsw · Haskell, OK · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2015 · N535CT · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident engine examination and test run did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.
- [NTSB CEN15LA276](https://openairdocs.org/ntsb/CEN15LA276.md): Air Tractor AT-602 · Branch, LA · Accident · No injuries · Limited investigation · Final report · Jun 4, 2015 · N5035R · Substantial damage
  > An exceedance of the airplane's takeoff/climb capability, which resulted in a stall during initial climb at an altitude that was too low for recovery.
- [NTSB CEN15LA242](https://openairdocs.org/ntsb/CEN15LA242.md): Bellanca 8KCAB · Superior, WI · Accident · No injuries · Limited investigation · Final report · May 27, 2015 · N102EC · Substantial damage
  > A stuck aileron due to a battery that had become jammed in the aileron bell crank.
- [NTSB GAA15LA085](https://openairdocs.org/ntsb/GAA15LA085.md): Destiny 2000 · Eltopia, WA · Accident · Serious injuries · Limited investigation · Final report · May 23, 2015 · N3376 · Substantial damage
  > The flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…
- [NTSB ERA15FA221](https://openairdocs.org/ntsb/ERA15FA221.md): BR Legend Turbine Legend · West Columbia, SC · Accident · 1 fatal · Field investigation · Final report · May 23, 2015 · N42BR · Destroyed
  > An engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…
- [NTSB DCA15CA125](https://openairdocs.org/ntsb/DCA15CA125.md): Airbus Industrie A320 212 · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · May 23, 2015 · N334NW · No damage
  > the flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.
- [NTSB WPR15FA163](https://openairdocs.org/ntsb/WPR15FA163.md): Rockwell Commander 114 · Laughlin, NV · Accident · 3 fatal · Field investigation · Final report · May 18, 2015 · N4775W · Destroyed
  > A partial loss of engine power due to the turbocharger's seizure as a result of a severely worn turbowheel. Contributing to the accident was the failure of the pilot/owner to have the turbo normalization system inspected every 100 hours as required, which…
- [NTSB WPR15LA162](https://openairdocs.org/ntsb/WPR15LA162.md): Earl Allen Miglet · Corning, CA · Accident · No injuries · Limited investigation · Final report · May 16, 2015 · N414US · Substantial damage
  > The partial loss of engine power during initial climb due to a loose set screw, which allowed the throttle cable rig within the connector to slip.
- [NTSB WPR15LA160](https://openairdocs.org/ntsb/WPR15LA160.md): Grumman Acft ENG Cor-Schweizer G 164A · Maxwell, CA · Accident · No injuries · Limited investigation · Final report · May 13, 2015 · N8875H · Substantial damage
  > The pilot’s improper preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15LA212](https://openairdocs.org/ntsb/ERA15LA212.md): Gates Lear Jet 35 · Newport News, VA · Accident · No injuries · Class 2 · Limited · Final report · May 12, 2015 · N80PG · Substantial damage
  > The flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…
- [NTSB CEN15LA226](https://openairdocs.org/ntsb/CEN15LA226.md): Air Tractor AT 502B · Dighton, KS · Accident · No injuries · Limited investigation · Final report · May 10, 2015 · N879JA · Substantial damage
  > The pilot's failure to follow the Preflight checklist and his inadequate preflight inspection, during which he failed to detect the water contamination of the fuel, which resulted in a partial loss of engine power during initial climb.
- [NTSB WPR15LA157](https://openairdocs.org/ntsb/WPR15LA157.md): Piper PA 32-300 · Redlands, CA · Accident · No injuries · Limited investigation · Final report · May 9, 2015 · N4124R · Substantial damage
  > The partial loss of engine power during takeoff due to oil starvation.
- [NTSB ERA15FA208](https://openairdocs.org/ntsb/ERA15FA208.md): Piper PA-32R-300 · Atlanta, GA · Accident · 4 fatal · Field investigation · Final report · May 8, 2015 · N5802V · Destroyed
  > A partial loss of engine power due to contamination in the fuel manifold, which resulted in a collision with terrain shortly after takeoff.
- [NTSB ERA15CA209](https://openairdocs.org/ntsb/ERA15CA209.md): Cessna 150D · Balsam Grove, NC · Accident · No injuries · Data collection · Final report · May 8, 2015 · N5981T · Substantial damage
  > The pilot's decision to attempt an off airport takeoff, and failure to maintain adequate clearance during the initial climb in crosswind conditions, which resulted in a collision with trees.
- [NTSB ANC15WA067](https://openairdocs.org/ntsb/ANC15WA067.md): Kevin D. Yarnevich Kitfox · Surrey, Canada · Accident · 1 fatal · Foreign investigation · May 8, 2015 · N688KY · Destroyed
- [NTSB GAA15CA062](https://openairdocs.org/ntsb/GAA15CA062.md): Issoire Siren PIK 30 · Deer Park, WA · Accident · No injuries · Data collection · Final report · May 6, 2015 · N350BC · Substantial damage
  > A loss of lift, which precipitated a forced off airport landing, and collision with terrain.
- [NTSB ENG15WA022](https://openairdocs.org/ntsb/ENG15WA022.md): Boeing 727-2F9 · Bogotá, Colombia, Colombia · Incident · Minor injuries · Foreign investigation · May 6, 2015 · HK4262 · Minor damage
  > On May 6, 2015 at about 1215 coordinated universal time, a Boeing 727-200F, operated by Líneas Aéreas Suramericanas experienced an uncontained No.1 engine failure shortly after takeoff from El Dorado International Airport (SKBO), Bogotá, Colombia. The…
- [NTSB ERA15FA203](https://openairdocs.org/ntsb/ERA15FA203.md): Cessna 172 · Penn Yan, NY · Accident · 1 fatal · Field investigation · Final report · May 3, 2015 · N3969L · Substantial damage
  > The student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.

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

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

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