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

## Cases, newest first

- [NTSB CEN17LA305](https://openairdocs.org/ntsb/CEN17LA305.md): Burkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2017 · N102BK · Substantial damage
  > The pilot’s failure to follow the before takeoff checklist, which resulted in an improper takeoff configuration and subsequent uncontrolled descent into terrain during a departure climb.
- [NTSB WPR17LA181](https://openairdocs.org/ntsb/WPR17LA181.md): Rans S9 · Athol, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2017 · N519TB · Substantial damage
  > The pilot's loss of pitch attitude and ground proximity awareness, which resulted in an unintentionally steep initial climb and an overcorrection into a steep descent and ground impact.
- [NTSB GAA17CA466](https://openairdocs.org/ntsb/GAA17CA466.md): AB Sportine Aviacija LAK 17 · Uvalde, TX · Accident · No injuries · Data collection · Final report · Aug 2, 2017 · N128LA · Destroyed
  > The ground crewmember’s failure to fully engage the tow hook release arm during preflight, which resulted in the premature release of the glider at insufficient altitude to complete a safe landing.
- [NTSB WPR17LA175](https://openairdocs.org/ntsb/WPR17LA175.md): Grumman AA1 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2017 · N6216L · Substantial damage
  > The partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…
- [NTSB CEN17LA298](https://openairdocs.org/ntsb/CEN17LA298.md): Cessna 150F · Bullard, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2017 · N8879S · Substantial damage
  > The partial loss of engine power due to carburetor icing and the pilot's inability to maintain adequate airspeed during the soft-field takeoff, which resulted in an exceedance of the airplane's critical angle-of-attack and an aerodynamic stall.
- [NTSB ERA17LA261](https://openairdocs.org/ntsb/ERA17LA261.md): Cessna 172 · Danbury, CT · Accident · 1 fatal · Limited investigation · Final report · Jul 30, 2017 · N612DF · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…
- [NTSB WPR17FA171](https://openairdocs.org/ntsb/WPR17FA171.md): Cessna 172N · Big Bear, CA · Accident · 2 fatal · Field investigation · Final report · Jul 29, 2017 · N5381J · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff in high density altitude conditions, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.
- [NTSB ERA17WA291](https://openairdocs.org/ntsb/ERA17WA291.md): Mitsubishi MU2B · San Fernando, Argentina · Accident · 3 fatal · Foreign investigation · Jul 24, 2017 · LV-MCV · Destroyed
  > The government of Argentina has notified the NTSB of an accident involving a MITSUBISHI MU2B airplane that occurred on July 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…
- [NTSB CEN17LA283](https://openairdocs.org/ntsb/CEN17LA283.md): Cessna 180 · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2017 · N3119D · Substantial damage
  > The pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…
- [NTSB ERA17WA259](https://openairdocs.org/ntsb/ERA17WA259.md): Cirrus Design SR20 · Santo Antonio do Leverger, Brazil · Accident · 2 fatal · Foreign investigation · Jul 20, 2017 · PR-PRF · Substantial damage
  > On July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…
- [NTSB ERA17FA248](https://openairdocs.org/ntsb/ERA17FA248.md): Aircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PA · Accident · 1 fatal · Field investigation · Final report · Jul 19, 2017 · N601PH · Destroyed
  > A partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…
- [NTSB WPR17LA153](https://openairdocs.org/ntsb/WPR17LA153.md): Clark James T Vans RV8 · Spokane, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 14, 2017 · N559JC · Substantial damage
  > An inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.
- [NTSB WPR17FA152](https://openairdocs.org/ntsb/WPR17FA152.md): Jansen Pazmany PL 2 · El Monte, CA · Accident · 1 fatal · Field investigation · Final report · Jul 14, 2017 · N186EJ · Substantial damage
  > A total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence. Also causal was the pilot's decision to return to the runway following the loss of engine power, and his failure to maintain airspeed…
- [NTSB WPR17FA150](https://openairdocs.org/ntsb/WPR17FA150.md): Cirrus Design SR22T · Schellville, CA · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2017 · N821SG · Destroyed
  > The pilot's failure to maintain adequate airspeed after a loss of engine power, which resulted in an aerodynamic stall at a low altitude from which the pilot was unable to recover. The loss of engine power resulted from the pilot's improper selection for the…
- [NTSB CEN17FA266](https://openairdocs.org/ntsb/CEN17FA266.md): Piper PA31T · Tyler, TX · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2017 · N47GW · Destroyed
  > The loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.
- [NTSB ERA17LA239](https://openairdocs.org/ntsb/ERA17LA239.md): Cessna 210L · Wilkes-Barre/Scranton, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2017 · N732FJ · Substantial damage
  > Failure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.
- [NTSB CEN17LA263](https://openairdocs.org/ntsb/CEN17LA263.md): Cirrus Design SR22 · Corydon, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2017 · N929DE · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA17LA237](https://openairdocs.org/ntsb/ERA17LA237.md): Beech C23 · Bartow, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2017 · N6682U · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR17LA142](https://openairdocs.org/ntsb/WPR17LA142.md): Cessna 177RG · Vacaville, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N7532V · Substantial damage
  > The total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no mechanical failure or malfunction that would have precluded normal operation.
- [NTSB ERA17FA232](https://openairdocs.org/ntsb/ERA17FA232.md): Morrisey 2150A · Honesdale, PA · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2017 · N917JL · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's use of two psychoactive substances, which led to his impaired decision to attempt to takeoff after engine issues became evident.
- [NTSB ERA17LA227](https://openairdocs.org/ntsb/ERA17LA227.md): Piper PA28 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Jul 4, 2017 · N9427J · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB CEN17LA254](https://openairdocs.org/ntsb/CEN17LA254.md): Cessna 208B · Alpine, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2017 · N9714B · Substantial damage
  > Fracture of a compressor turbine (CT) blade due to operational overtemperatures and the failure of a maintenance technician to detect an existing crack in the CT blade during the last engine inspection.
- [NTSB ERA17FA223](https://openairdocs.org/ntsb/ERA17FA223.md): Slip Stream Genesis · Linesville, PA · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2017 · N3449 · Substantial damage
  > The pilot's failure to maintain airspeed during a climbing turn after takeoff and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery. Contributing to the accident was the…
- [NTSB WPR17LA138](https://openairdocs.org/ntsb/WPR17LA138.md): Piper PA 28-140 · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2017 · N4244T · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.
- [NTSB WPR17LA136](https://openairdocs.org/ntsb/WPR17LA136.md): Cessna 310R · Santa Ana, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 30, 2017 · N87297 · Substantial damage
  > The pilot’s inability to maintain adequate airspeed after a loss of power to the right engine while maneuvering in the pattern to return to the airport. Contributing to the accident were the loss of power to the right engine for reasons that could not be…
- [NTSB GAA17CA375](https://openairdocs.org/ntsb/GAA17CA375.md): Urbanczyk Miroslaw Radio Flyer · Tehachapi, CA · Accident · No injuries · Data collection · Final report · Jun 30, 2017 · N385MU · Substantial damage
  > The noncertificated pilot’s failure to maintain clearance from residential buildings and trees in gusting wind conditions.
- [NTSB ERA17LA220](https://openairdocs.org/ntsb/ERA17LA220.md): Nunley KR2 · Baker, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2017 · N269HJ · Destroyed
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA17LA215](https://openairdocs.org/ntsb/ERA17LA215.md): Beech B23 · Ocean Isle Beach, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2017 · N4023T · Substantial damage
  > The pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.
- [NTSB GAA17CA387](https://openairdocs.org/ntsb/GAA17CA387.md): Piper PA 12 · Chickaloon, AK · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N2737M · Substantial damage
  > The pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.
- [NTSB ERA17FA211](https://openairdocs.org/ntsb/ERA17FA211.md): Buckeye Powered Parachutes Dream Machine 582 · Federalsburg, MD · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2017 · N50130 · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with power lines. Contributing to the accident was the pilot's lack of experience in powered parachutes.
- [NTSB CEN17WA243](https://openairdocs.org/ntsb/CEN17WA243.md): Piper L4 · Liberecký, Czechia · Accident · 2 fatal · Foreign investigation · Jun 25, 2017 · OM-M038 · Destroyed
  > On June 25, 2017, at 1200 Coordinated Universal Time, a Piper L4, OM-M038, impacted terrain after takeoff from Hodkovice Airport (LKHD), Liberecký, Czech Republic. The airplane was destroyed. The pilot sustained serious injuries, and the passenger sustained…
- [NTSB ERA17FA210](https://openairdocs.org/ntsb/ERA17FA210.md): Piper PA28 · Fort Myers, FL · Accident · 1 fatal · Field investigation · Final report · Jun 24, 2017 · N199PA · Destroyed
  > A partial loss of engine power during initial climb for reasons that could not be determined because extensive fire damage precluded thorough examination of the engine and its associated systems.
- [NTSB CEN17LA236](https://openairdocs.org/ntsb/CEN17LA236.md): Wells John L JR Stol CH 701 · Canon City, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2017 · N999WX · Substantial damage
  > Fuel starvation due to the deterioration of a fuel hose.
- [NTSB GAA17CA342](https://openairdocs.org/ntsb/GAA17CA342.md): Air Tractor AT 802 · Pocahontas, AR · Accident · Minor injuries · Data collection · Final report · Jun 15, 2017 · N915AJ · Substantial damage
  > The pilot's failure to maintain lateral/bank control during the initial climb in turbulent conditions.
- [NTSB GAA17CA340](https://openairdocs.org/ntsb/GAA17CA340.md): Sportine Aviacija LAK 12 · Reno, NV · Accident · Minor injuries · Data collection · Final report · Jun 14, 2017 · N4206N · Substantial damage
  > The glider pilot’s failure to maintain proper pitch during an aerotow takeoff.
- [NTSB ERA17LA202](https://openairdocs.org/ntsb/ERA17LA202.md): Cessna 172P · Tamiami, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 10, 2017 · N881AV · Substantial damage
  > A partial loss of engine power during the initial climb due to carburetor icing.
- [NTSB CEN17LA228](https://openairdocs.org/ntsb/CEN17LA228.md): Thompson Angel Hawk II · Homer, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 2017 · N335JT · Substantial damage
  > A total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…
- [NTSB CEN17LA220](https://openairdocs.org/ntsb/CEN17LA220.md): Bellanca 17 30 · Watkins, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2017 · N7328V · Substantial damage
  > The pilot's in-flight fuel mismanagement, which resulted in fuel starvation and a total loss of engine power.
- [NTSB DCA17WA136](https://openairdocs.org/ntsb/DCA17WA136.md): Boeing 737 · Cusco, Peru · Incident · No injuries · Foreign investigation · Jun 6, 2017 · OB-2135-P · No damage
  > The Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…
- [NTSB WPR17LA121](https://openairdocs.org/ntsb/WPR17LA121.md): Bob Frederick Titan T-51 · Goodyear, AZ · Accident · No injuries · Limited investigation · Final report · Jun 4, 2017 · N51FB · Substantial damage
  > Failure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.
- [NTSB ERA17FA195](https://openairdocs.org/ntsb/ERA17FA195.md): Piper PA23 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2017 · N21WW · Destroyed
  > The pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.
- [NTSB CEN17LA212](https://openairdocs.org/ntsb/CEN17LA212.md): Cessna 210F · Anoka, MN · Accident · No injuries · Limited investigation · Final report · Jun 3, 2017 · N1854F · Substantial damage
  > The failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.
- [NTSB CEN17FA208](https://openairdocs.org/ntsb/CEN17FA208.md): Michael S. Logan Kitfox · New Berlin, TX · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2017 · N956ML · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available information, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and experiencing…
- [NTSB WPR17FA118](https://openairdocs.org/ntsb/WPR17FA118.md): Cessna 150M · Banning, CA · Accident · 1 fatal · Field investigation · Final report · Jun 2, 2017 · N66117 · Substantial damage
  > The flight instructor's decision to continue the takeoff in gusting tailwind and high density altitude conditions, which significantly reduced airplane performance, and his subsequent exceedance of the airplane's critical angle of attack during the initial…
- [NTSB GAA17CA319](https://openairdocs.org/ntsb/GAA17CA319.md): Magnaghi Aeronautica SKY Arrow LSA · Chapman, KS · Accident · Minor injuries · Data collection · Final report · Jun 2, 2017 · N600US · Substantial damage
  > The pilot's failure to maintain lateral/bank control during the takeoff climb in gusting crosswind conditions.
- [NTSB CEN17WA193](https://openairdocs.org/ntsb/CEN17WA193.md): Quicksilver GT500 · Barcelona, Spain · Accident · 1 fatal · Foreign investigation · May 20, 2017 · EC-BQ3 · Substantial damage
  > On May 20, 2017, at 1000 local time, a Quicksilver GT-500, EC-BQ3, impacted terrain after making a steep left turn during takeoff from Gurb Aerodrome in Barcelona, Spain. The aircraft was destroyed, and the pilot was fatally injured. The flight was being…
- [NTSB ERA17LA182](https://openairdocs.org/ntsb/ERA17LA182.md): Stinson 108 · West Creek, NJ · Accident · Minor injuries · Limited investigation · Final report · May 17, 2017 · N9366K · Substantial damage
  > A total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.
- [NTSB CEN17LA181](https://openairdocs.org/ntsb/CEN17LA181.md): AS+ AC 4 · Blair, NE · Accident · 1 fatal · Limited investigation · Final report · May 13, 2017 · N358R · Substantial damage
  > The pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.
- [NTSB CEN17LA180](https://openairdocs.org/ntsb/CEN17LA180.md): Brokaw Bergon F Zodiac · Orangeville, IL · Accident · Serious injuries · Limited investigation · Final report · May 12, 2017 · N1041N · Substantial damage
  > The total loss of engine power due to fuel starvation.
- [NTSB ERA17LA175](https://openairdocs.org/ntsb/ERA17LA175.md): Mooney M20R · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · May 9, 2017 · N20835 · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because the airplane sank in the ocean and was not recovered.

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

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

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