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

## Cases, newest first

- [NTSB ERA13LA264](https://openairdocs.org/ntsb/ERA13LA264.md): Globe GC-1B · Williamson, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2013 · N3715K · Substantial damage
  > The pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.
- [NTSB CEN13WA311](https://openairdocs.org/ntsb/CEN13WA311.md): Saab 91C · Söderhamn, Sweden · Accident · 1 fatal · Foreign investigation · Jun 1, 2013 · SE-KVZ · Substantial damage
  > On June 1, 2013, at 1215 universal coordinated time, a SAAB model 91C (Safir) airplane, Swedish registration SE-KVC, collided with terrain shortly after takeoff from the Söderhamn Airport (ESNY), near Söderhamn, Sweden. A postimpact fire destroyed the…
- [NTSB CEN13LA308](https://openairdocs.org/ntsb/CEN13LA308.md): Evektor-Aerotechnik Sportstar Plus · Elyria, OH · Accident · No injuries · Limited investigation · Final report · May 30, 2013 · N319SV · Substantial damage
  > The failure of the canopy latch spring, which caused the canopy to open during initial climb. Contributing to the accident was the installation of an improper part in the canopy latch assembly, which led to the failure of the canopy latch spring.
- [NTSB WPR13FA244](https://openairdocs.org/ntsb/WPR13FA244.md): Raytheon A36 · Mountainaire, AZ · Accident · 2 fatal · Field investigation · Final report · May 28, 2013 · N999PK · Destroyed
  > The pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…
- [NTSB WPR13LA251](https://openairdocs.org/ntsb/WPR13LA251.md): American AA-1 · Truckee, CA · Accident · Serious injuries · Limited investigation · Final report · May 23, 2013 · N5909L · Substantial damage
  > The pilot's failure to lean the fuel mixture during takeoff in high-density altitude conditions, which resulted in a loss of engine power.
- [NTSB ERA13LA252](https://openairdocs.org/ntsb/ERA13LA252.md): Beech A36 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · May 23, 2013 · N8225T · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…
- [NTSB ANC13LA048](https://openairdocs.org/ntsb/ANC13LA048.md): Piper PA-16 · Juneau, AK · Accident · Minor injuries · Limited investigation · Final report · May 19, 2013 · N5372H · Substantial damage
  > The total loss of engine power for reasons that could not be determined due to the inability to recover the airplane.
- [NTSB WPR13LA230](https://openairdocs.org/ntsb/WPR13LA230.md): Cessna T188C · Pine Bluffs, WY · Accident · No injuries · Limited investigation · Final report · May 15, 2013 · N2167J · Substantial damage
  > The loss of engine power during 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 CEN13LA273](https://openairdocs.org/ntsb/CEN13LA273.md): Phillips Zenith 250 · Taos, NM · Accident · Serious injuries · Limited investigation · Final report · May 10, 2013 · N250ZP · Substantial damage
  > The pilot’s improper decision to take off in gusting wind conditions and the airplane’s loss of climb performance following an encounter with turbulence and downdrafts.
- [NTSB ERA13LA229](https://openairdocs.org/ntsb/ERA13LA229.md): Schweizer SGS 2-33A · Erwinna, PA · Accident · Serious injuries · Limited investigation · Final report · May 4, 2013 · N2045T · Substantial damage
  > The pilot’s loss of glider control due to improper rigging of the rudder control cables, the mechanic’s inadequate flight control checks following the glider’s most recent annual inspection, and the pilot’s failure to perform a thorough preflight inspection.
- [NTSB CEN13FA267](https://openairdocs.org/ntsb/CEN13FA267.md): Beech 58 · Mena, AR · Incident · No injuries · Field investigation · Final report · May 4, 2013 · N44GC · Minor damage
  > A partial loss of power on both engines during takeoff for reasons that could not be determined because examination of the airframe and a test run of both engines revealed no mechanical anomalies that would have precluded normal operation.
- [NTSB ERA13CA228](https://openairdocs.org/ntsb/ERA13CA228.md): Piper PA-28-140 · Brogue, PA · Accident · Serious injuries · Data collection · Final report · May 2, 2013 · N33677 · Substantial damage
  > The flight instructor's inadequate supervision of the student pilot during takeoff, which resulted in a collision with a power line.
- [NTSB CEN13LA254](https://openairdocs.org/ntsb/CEN13LA254.md): Mason Robert Kolb Mark 3X · Lawrence, KS · Accident · Serious injuries · Limited investigation · Final report · May 1, 2013 · N125KP · Substantial damage
  > The noncertificated pilot’s improper decision to depart with a tailwind.
- [NTSB DCA13MA081](https://openairdocs.org/ntsb/DCA13MA081.md): Boeing 747-400 BCF · Bagram, Afghanistan · Accident · 7 fatal · Class 1 · Major · Final report · Apr 29, 2013 · N949CA · Destroyed
  > National Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…
- [NTSB WPR13LA209](https://openairdocs.org/ntsb/WPR13LA209.md): Cessna 172N · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Apr 28, 2013 · N3483E · Substantial damage
  > The pilot’s inadequate preflight planning, including operating in excess of the maximum certified gross weight and center of gravity limits at a high density altitude, which resulted in the airplane’s inability to maintain a positive rate of climb after…
- [NTSB ERA13LA220](https://openairdocs.org/ntsb/ERA13LA220.md): Piper PA-28-151 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 26, 2013 · N75148 · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.
- [NTSB ERA13CA218](https://openairdocs.org/ntsb/ERA13CA218.md): Cessna 172P · Davis, WV · Accident · Serious injuries · Data collection · Final report · Apr 26, 2013 · N96178 · Substantial damage
  > The pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.
- [NTSB ERA13LA214](https://openairdocs.org/ntsb/ERA13LA214.md): Beech 35-C33A · Knoxville, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 25, 2013 · N2713T · Substantial damage
  > The loss of engine power during takeoff for a reasons that could not be determined because postaccident examinations and testing revealed no anomalies that would have precluded normal operation.
- [NTSB CEN13LA229](https://openairdocs.org/ntsb/CEN13LA229.md): Beech N35 · Warren, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2013 · N9414Y · Substantial damage
  > The fatigue failure of the engine crankshaft due to oversized crankcase saddle bores, which resulted from maintenance personnel improperly resizing the saddle bores during engine maintenance.
- [NTSB WPR13LA191](https://openairdocs.org/ntsb/WPR13LA191.md): Ercoupe 415-C · Mesquite, NV · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2013 · N87114 · Substantial damage
  > Separation of the propeller from the engine during initial climb due to the incorrect torque applied to the propeller hub nut during maintenance.
- [NTSB ERA13WA203](https://openairdocs.org/ntsb/ERA13WA203.md): Piper PA-23-250 · Georgetown, Guyana · Accident · 2 fatal · Class 5 · Foreign · Apr 13, 2013 · N27FT · Destroyed
  > On April 13, 2013, about 1854 coordinated universal time, a Piper PA-23-250, N27FT, was destroyed when it impacted a residence shortly after departing from Ogle International Airport (SYGO), Georgetown, Guyana. The certificated airline transport pilot and one…
- [NTSB ERA13LA199](https://openairdocs.org/ntsb/ERA13LA199.md): Maxfly Inc/Mckay WM Searey · Polk City, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2013 · N914WM · Substantial damage
  > The improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…
- [NTSB ERA13FA186](https://openairdocs.org/ntsb/ERA13FA186.md): Robinson R44 · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Apr 3, 2013 · N3101H · Destroyed
  > The mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…
- [NTSB CEN13LA216](https://openairdocs.org/ntsb/CEN13LA216.md): Cessna 172 · Wonewoc, WI · Accident · No injuries · Limited investigation · Final report · Apr 1, 2013 · N8033B · Substantial damage
  > The restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA13LA180](https://openairdocs.org/ntsb/ERA13LA180.md): Schweizer 269C · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 2013 · N2099S · Substantial damage
  > An engine failure due to the separation of the engine crankcase, which resulted from the lateral movement of the center main bearing and the subsequent blocking of the oil feed hole that supplied oil to the No. 2 connecting rod, which then led to its failure…
- [NTSB WPR13LA171](https://openairdocs.org/ntsb/WPR13LA171.md): Piper PA-38-112 · Byron, CA · Accident · No injuries · Limited investigation · Final report · Mar 16, 2013 · N99DM · 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 ERA13FA168](https://openairdocs.org/ntsb/ERA13FA168.md): Piper PA-31T · Fort Lauderdale, FL · Accident · 3 fatal · Field investigation · Final report · Mar 15, 2013 · N63CA · Destroyed
  > The pilot's failure to maintain airplane control following an emergency, the nature of which could not be determined because of crash and fire damage, which resulted in an aerodynamic stall.
- [NTSB CEN13LA199](https://openairdocs.org/ntsb/CEN13LA199.md): Ryan Navion · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Mar 15, 2013 · N4276K · Substantial damage
  > The pilot's inadequate preflight planning and decision to take off at a high density altitude and in gusting wind conditions.
- [NTSB ANC13CA028](https://openairdocs.org/ntsb/ANC13CA028.md): Cessna 185B · Flat, AK · Accident · No injuries · Data collection · Final report · Mar 5, 2013 · N2550Z · Substantial damage
  > The pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.
- [NTSB CEN13FA182](https://openairdocs.org/ntsb/CEN13FA182.md): Aero Commander 500B · Broomfield, CO · Accident · Minor injuries · Field investigation · Final report · Mar 1, 2013 · N93AA · Substantial damage
  > Loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the fuel gauge to indicate the actual amount of fuel on board the airplane and the design of the airplane's fuel system, which precluded a visual confirmation of the…
- [NTSB ERA13WA176](https://openairdocs.org/ntsb/ERA13WA176.md): Cirrus Design SR-22 · Tiros, Brazil · Accident · 1 fatal · Class 5 · Foreign · Feb 27, 2013 · PR-SLS · Destroyed
  > On February 27, 2013, about 1840 coordinated universal time (UTC), a Cirrus Design Corporation, SR-22, Brazilian registration PR-SLS, was destroyed when it impacted the ground shortly after takeoff from a farm field in the Tiros Municipality, in the State of…
- [NTSB ERA13FA144](https://openairdocs.org/ntsb/ERA13FA144.md): Piper PA-28RT-201 · Lutz, FL · Accident · 1 fatal · Field investigation · Final report · Feb 24, 2013 · N2895U · Destroyed
  > The noninstrument-rated pilot’s decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in spatial disorientation and a loss of aircraft control. Contributing to the accident was the pilot’s lack of instrument…
- [NTSB WPR13CA133](https://openairdocs.org/ntsb/WPR13CA133.md): Luscombe 8A · Lebanon, OR · Accident · No injuries · Data collection · Final report · Feb 22, 2013 · N1192K · Substantial damage
  > The pilot’s failure to compensate for a crosswind during initial climb, which resulted in a loss of control.
- [NTSB CEN13FA174](https://openairdocs.org/ntsb/CEN13FA174.md): Eurocopter AS 350 B2 · Oklahoma City, OK · Accident · 2 fatal · Field investigation · Final report · Feb 22, 2013 · N917EM · Substantial damage
  > The loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…
- [NTSB ANC13FA024](https://openairdocs.org/ntsb/ANC13FA024.md): Cessna 170B · Skwentna, AK · Accident · Serious injuries · Field investigation · Final report · Feb 18, 2013 · N2814C · Substantial damage
  > The pilot’s failure to maintain airspeed during a departure turn, resulting in an aerodynamic stall and collision with terrain.
- [NTSB ERA13FA131](https://openairdocs.org/ntsb/ERA13FA131.md): Cessna T337C · New Smyrna Beach, FL · Accident · 1 fatal · Field investigation · Final report · Feb 13, 2013 · N2576S · Destroyed
  > Maintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…
- [NTSB ERA13LA127](https://openairdocs.org/ntsb/ERA13LA127.md): Hiller UH-12B · Merritt Island, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 2013 · N5072R · Substantial damage
  > A total loss of engine power due to fuel starvation, which resulted from an overstress failure of a fitting on the fuel supply line and led to an autorotation and hard landing.
- [NTSB CEN13LA147](https://openairdocs.org/ntsb/CEN13LA147.md): Webb Webb 2 · Gainsville, TX · Accident · No injuries · Limited investigation · Final report · Jan 28, 2013 · N4844W · Substantial damage
  > The pilot’s failure to follow his test plan and abort the takeoff after inadvertently lifting off during a high speed taxi test. Contributing to the accident was the pilot’s lack of flight experience in the gyroplane.
- [NTSB ERA13LA119](https://openairdocs.org/ntsb/ERA13LA119.md): Shoemaker James B KR-2 · Palmetto, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 2013 · N27CE · Substantial damage
  > The total loss of engine power for undetermined reasons, which resulted in a forced landing.
- [NTSB WPR13LA098](https://openairdocs.org/ntsb/WPR13LA098.md): Cessna 172F · Marysville, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 2013 · N5208F · Substantial damage
  > A total loss of engine power during initial climb due to fuel starvation, which resulted from maintenance personnel’s improper installation of the fuel selector handle. Contributing to the accident was an incorrectly modified fuel selector handle assembly.
- [NTSB ERA13FA115](https://openairdocs.org/ntsb/ERA13FA115.md): Pilatus PC-12/45 · Burlington, NC · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2013 · N68PK · Substantial damage
  > The pilot's failure to maintain airplane control due to spatial disorientation during the initial climb after takeoff in night instrument flight rules conditions.
- [NTSB CEN13FA135](https://openairdocs.org/ntsb/CEN13FA135.md): Cessna 208B · Pellston, MI · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2013 · N1120N · Destroyed
  > The pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.
- [NTSB ERA13FA109](https://openairdocs.org/ntsb/ERA13FA109.md): Benton Fred D Seawind 3000 · Sarasota, FL · Accident · 2 fatal · Field investigation · Final report · Jan 12, 2013 · N829GS · Destroyed
  > The pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA118](https://openairdocs.org/ntsb/CEN13LA118.md): Piper PA-24-250 · Mc Allen, TX · Accident · No injuries · Limited investigation · Final report · Dec 31, 2012 · N8053P · Substantial damage
  > A loss of engine power due to carburetor icing.
- [NTSB CEN13CA117](https://openairdocs.org/ntsb/CEN13CA117.md): Embraer EMB-145LR · Chicago, IL · Accident · Serious injuries · Data collection · Final report · Dec 29, 2012 · N619AE · No damage
  > The presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.
- [NTSB CEN13LA116](https://openairdocs.org/ntsb/CEN13LA116.md): Seguine Swift II · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 24, 2012 · N84NS · Substantial damage
  > The pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA13LA099](https://openairdocs.org/ntsb/ERA13LA099.md): Piper PA-28RT-201T · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 2012 · N4340G · Substantial damage
  > The pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.
- [NTSB ERA13LA093](https://openairdocs.org/ntsb/ERA13LA093.md): Russom Roy G Hummel H5 · Calhoun, GA · Accident · 1 fatal · Limited investigation · Final report · Dec 18, 2012 · N156FH · Substantial damage
  > The pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.
- [NTSB ERA13LA084](https://openairdocs.org/ntsb/ERA13LA084.md): Merritt Leslie R Kelly D · Brandon, MS · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2012 · N5172S · Substantial damage
  > A total loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13FA082](https://openairdocs.org/ntsb/ERA13FA082.md): Cessna 421C · Lake Worth, FL · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2012 · N297DB · Substantial damage
  > The pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…

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

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

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