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

## Cases, newest first

- [NTSB ENG19WA018](https://openairdocs.org/ntsb/ENG19WA018.md): Airbus A320 · Jaipur, India · Incident · No injuries · Foreign investigation · Apr 1, 2019 · VT-IVB · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 1, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…
- [NTSB ERA19LA145](https://openairdocs.org/ntsb/ERA19LA145.md): Bell 222 · Montgomery, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 30, 2019 · N222ML · Substantial damage
  > A partial loss of engine power, as reported by the pilot, during takeoff for reasons that could not be determined based on available information.
- [NTSB GAA19CA177](https://openairdocs.org/ntsb/GAA19CA177.md): Champion 7EC · Fayetteville, AR · Accident · Minor injuries · Data collection · Final report · Mar 24, 2019 · N815PB · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.
- [NTSB ERA19LA135](https://openairdocs.org/ntsb/ERA19LA135.md): Piper PA22 · Blanch, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 24, 2019 · N1933P · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB WPR19LA101](https://openairdocs.org/ntsb/WPR19LA101.md): Dennis l Zumbalt SKY Bolt · Deming, NM · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 23, 2019 · N254PM · Substantial damage
  > The pilot’s failure to properly position the fuel selector before takeoff, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA19WA223](https://openairdocs.org/ntsb/GAA19WA223.md): Cessna A185 · Bocona, Venezuela · Accident · 1 fatal · Foreign investigation · Mar 22, 2019 · YV1606 · Destroyed
  > The government of Venezuela has notified the NTSB of an accident involving a CESSNA A185 airplane that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…
- [NTSB CEN19FA104](https://openairdocs.org/ntsb/CEN19FA104.md): Israel Aircraft Industries 1124 · Yukon, OK · Accident · 2 fatal · Class 3 · Field · Final report · Mar 18, 2019 · N4MH · Destroyed
  > The airplane’s unairworthy thrust reverser (T/R) system due to inadequate maintenance that resulted in an asymmetric T/R deployment during an approach to the airport and the subsequent loss of airplane control.
- [NTSB WPR19FA096](https://openairdocs.org/ntsb/WPR19FA096.md): Beech 50 · Riverside, CA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 16, 2019 · N800DC · Substantial damage
  > The pilot’s failure to maintain airspeed and control of the airplane following a loss of right engine power for reasons that could not be determined based on the available information.
- [NTSB DCA19RA101](https://openairdocs.org/ntsb/DCA19RA101.md): Boeing 737 · Addis Ababa, Ethiopia · Accident · 157 fatal · Foreign investigation · Mar 10, 2019 · ET-AVJ · Destroyed
  > The government of Ethiopia has notified the NTSB of an accident involving a BOEING 737 that occurred on March 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ethiopia's investigation under the provisions of ICAO…
- [NTSB CEN19LA101](https://openairdocs.org/ntsb/CEN19LA101.md): Cessna 150 · Granite Shoals, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 6, 2019 · N6917F · Substantial damage
  > The pilot's decision to takeoff with a limited amount of fuel onboard, which unported during a turn, resulting in fuel starvation and a subsequent loss of engine power.
- [NTSB ERA19FA116](https://openairdocs.org/ntsb/ERA19FA116.md): Piper PA28 · Fellsmere, FL · Accident · 1 fatal · Class 2 · Field · Final report · Mar 5, 2019 · N556PU · Substantial damage
  > The student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…
- [NTSB ERA19FA113](https://openairdocs.org/ntsb/ERA19FA113.md): Cessna 182 · Louisburg, NC · Accident · 3 fatal · Field investigation · Final report · Mar 2, 2019 · N26617 · Destroyed
  > The pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.
- [NTSB CEN19FA088](https://openairdocs.org/ntsb/CEN19FA088.md): Piper PA46 · Shreveport, LA · Accident · 2 fatal · Field investigation · Final report · Feb 28, 2019 · N428CD · Substantial damage
  > The pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…
- [NTSB ERA19FA107](https://openairdocs.org/ntsb/ERA19FA107.md): Cessna 172 · Mansfield, MA · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2019 · N224TA · Substantial damage
  > The flight instructor's failure to maintain airplane control during initial climb after a touch-and-go landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.
- [NTSB ERA19FA106](https://openairdocs.org/ntsb/ERA19FA106.md): Stol UC-1 · Winter Haven, FL · Accident · 1 fatal · Class 2 · Field · Final report · Feb 23, 2019 · N65NE · Substantial damage
  > A total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…
- [NTSB ENG19IA013](https://openairdocs.org/ntsb/ENG19IA013.md): Boeing 737 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Feb 21, 2019 · N30401 · No damage
  > A No. 1 (left) engine high pressure compressor stage 2 blade separation. The blade separated due to a mixed-mode fatigue crack that originated on a blade disk post and was initiated by a misaligned (out-of-schedule) high pressure compressor stage 1 variable…
- [NTSB CEN19LA085](https://openairdocs.org/ntsb/CEN19LA085.md): Tecnam P92 · Englewood, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 21, 2019 · N108TE · Substantial damage
  > The loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.
- [NTSB DCA19CA075](https://openairdocs.org/ntsb/DCA19CA075.md): Boeing 737 · Bluefields, Nicaragua · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 5, 2019 · N852NN · No damage
  > An inadvertent encounter with clear air turbulence.
- [NTSB WPR19FA079](https://openairdocs.org/ntsb/WPR19FA079.md): Cessna 414 · Yorba Linda, CA · Accident · 5 fatal · Class 3 · Field · Final report · Feb 3, 2019 · N414RS · Destroyed
  > The pilot’s failure to maintain airplane control after entering instrument meteorological conditions (IMC) while climbing due to spatial disorientation, which resulted in the exceedance of the airplane’s design stress limits and subsequent in-flight break-up.…
- [NTSB DCA19WA072](https://openairdocs.org/ntsb/DCA19WA072.md): Boeing 787 · Casablanca, Morocco · Incident · No injuries · Foreign investigation · Feb 3, 2019 · CN-RAM · Minor damage
  > The BEA of Morocco has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on February 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of Morocco's investigation under the provisions of ICAO Annex…
- [NTSB GAA19WA342](https://openairdocs.org/ntsb/GAA19WA342.md): Raytheon B200 · Lausanne-Switzerland, Switzerland · Incident · No injuries · Foreign investigation · Feb 2, 2019 · N7779V · No damage
  > The government of Switzerland has notified the NTSB of an accident involving a RAYTHEON B200 airplane that occurred on February 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…
- [NTSB ERA19LA094](https://openairdocs.org/ntsb/ERA19LA094.md): Airborne Windsports Edge X · Ocala, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 2, 2019 · N123NY · Substantial damage
  > The noncertificated pilot's exceedance of the aircraft's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB WPR19LA076](https://openairdocs.org/ntsb/WPR19LA076.md): Whittman 8-W Modified · Prospect, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 29, 2019 · N12037 · Substantial damage
  > The non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR19FA075](https://openairdocs.org/ntsb/WPR19FA075.md): Piper PA28 · Oceanside, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 29, 2019 · N37RV · Substantial damage
  > The pilot’s improper decision to depart on the night visual flight rules flight into deteriorating weather conditions, which resulted in an in-flight encounter with instrument meteorological conditions and collision with rising terrain.
- [NTSB ENG19WA009](https://openairdocs.org/ntsb/ENG19WA009.md): Airbus A320 · Lucknow, India · Incident · No injuries · Foreign investigation · Jan 21, 2019 · VT-ITQ · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…
- [NTSB CEN19LA056](https://openairdocs.org/ntsb/CEN19LA056.md): Douglas DC3C · Kidron, OH · Accident · 2 fatal · Limited investigation · Final report · Jan 21, 2019 · N467KS · Substantial damage
  > The loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.
- [NTSB CEN19LA065](https://openairdocs.org/ntsb/CEN19LA065.md): Robinson R44 · Uvalde, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 2019 · N484AB · Substantial damage
  > The slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.
- [NTSB WPR19LA058](https://openairdocs.org/ntsb/WPR19LA058.md): Beech A36 · Colusa, CA · Accident · 2 fatal · Class 2 · Limited · Final report · Jan 7, 2019 · N100JB · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation shortly after takeoff in instrument meteorological conditions.
- [NTSB WPR19WA059](https://openairdocs.org/ntsb/WPR19WA059.md): Cessna 182 · Tooradin, Australia · Accident · No injuries · Foreign investigation · Jan 6, 2019 · VH-DGF · Substantial damage
  > On January 6, 2019, at 1045 local time, a Cessna 182G, VH-DGF, collided with trees following a loss of engine power during the initial climb near Tooradin, Australia. The pilot and four passengers were not injured. The airplane was substantially damaged. The…
- [NTSB ENG21WA016](https://openairdocs.org/ntsb/ENG21WA016.md): Boeing 737 · Lagos, Nigeria · Incident · No injuries · Class 5 · Foreign · Jan 3, 2019 · 5N-AIS · Minor damage
- [NTSB ENG19WA010](https://openairdocs.org/ntsb/ENG19WA010.md): Airbus A320 · Chennai, India · Incident · No injuries · Foreign investigation · Jan 3, 2019 · VT-ITW · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…
- [NTSB CEN19LA051](https://openairdocs.org/ntsb/CEN19LA051.md): Piper PA 23 · Beaver Island, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 2018 · N2146P · Destroyed
  > The pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…
- [NTSB WPR19LA050](https://openairdocs.org/ntsb/WPR19LA050.md): Piper PA28 · Santa Ana, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 23, 2018 · N15321 · Substantial damage
  > A total loss of engine power due to a loose carburetor bowl.
- [NTSB ERA19LA078](https://openairdocs.org/ntsb/ERA19LA078.md): BRM Aero Bristell S-LSA · Lakeland, FL · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 2018 · N587BL · Destroyed
  > The student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.
- [NTSB ERA19FA071](https://openairdocs.org/ntsb/ERA19FA071.md): Cessna 560 · Atlanta, GA · Accident · 4 fatal · Field investigation · Final report · Dec 20, 2018 · N188CW · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.
- [NTSB DCA19WA049](https://openairdocs.org/ntsb/DCA19WA049.md): Boeing 777 · Belo Horizonte, Brazil · Incident · No injuries · Foreign investigation · Dec 20, 2018 · PT-MUG · Minor damage
  > The CENIPA of Brazil has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on December 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR19FA042](https://openairdocs.org/ntsb/WPR19FA042.md): Piper PA-24-250 · Aberdeen, ID · Accident · 1 fatal · Class 2 · Field · Final report · Dec 17, 2018 · N6283P · Substantial damage
  > The pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.
- [NTSB CEN19FA044](https://openairdocs.org/ntsb/CEN19FA044.md): Piper PA24 · Valparaiso, IN · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2018 · N6785P · Destroyed
  > The pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.
- [NTSB ERA19FA060](https://openairdocs.org/ntsb/ERA19FA060.md): Cessna 335 · Fort Lauderdale, FL · Accident · 2 fatal · Class 2 · Field · Final report · Dec 1, 2018 · N79HP · Destroyed
  > The pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.
- [NTSB ERA19FA059](https://openairdocs.org/ntsb/ERA19FA059.md): Cessna 210 · Apalachicola, FL · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2018 · N3995Y · Destroyed
  > The pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.
- [NTSB CEN19FA036](https://openairdocs.org/ntsb/CEN19FA036.md): Cessna 525 · Memphis, IN · Accident · 3 fatal · Class 3 · Field · Final report · Nov 30, 2018 · N525EG · Destroyed
  > The pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.
- [NTSB CEN19FA035](https://openairdocs.org/ntsb/CEN19FA035.md): Piper PA 30 · Marion, IN · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2018 · N7751Y · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…
- [NTSB WPR19LA029](https://openairdocs.org/ntsb/WPR19LA029.md): BKF Backcountry Supercub · Casper, WY · Accident · No injuries · Class 3 · Limited · Final report · Nov 19, 2018 · N59BK · Substantial damage
  > The seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.
- [NTSB ERA19LA052](https://openairdocs.org/ntsb/ERA19LA052.md): Piper PA28 · Barnesville, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 2018 · N111TA · Substantial damage
  > The student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.
- [NTSB ERA19FA048](https://openairdocs.org/ntsb/ERA19FA048.md): Vans RV-12 · Niceville, FL · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2018 · N232VA · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…
- [NTSB WPR19FA025](https://openairdocs.org/ntsb/WPR19FA025.md): Cessna 182 · Redding, CA · Accident · 2 fatal · Class 2 · Field · Final report · Nov 16, 2018 · N2629R · Substantial damage
  > The pilot's spatial disorientation and subsequent loss of control after takeoff in dark night instrument meteorological conditions.
- [NTSB GAA19CA060](https://openairdocs.org/ntsb/GAA19CA060.md): Beech 36 · Williams, AZ · Accident · Minor injuries · Data collection · Final report · Nov 14, 2018 · N264PC · Substantial damage
  > The pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.
- [NTSB ERA19LA041](https://openairdocs.org/ntsb/ERA19LA041.md): Piper PA28R · Lake City, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 2018 · N52737 · Substantial damage
  > The pilot's failure to attain adequate airspeed before attempting the takeoff with a tailwind, which resulted in the airplane being unable to sustain flight.
- [NTSB WPR19LA023](https://openairdocs.org/ntsb/WPR19LA023.md): Vans RV7A · Ramona, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 10, 2018 · N5433T · Destroyed
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA19TA042](https://openairdocs.org/ntsb/ERA19TA042.md): Mooney M20C · Wildwood, NJ · Accident · Serious injuries · Class 3 · Final report · Nov 10, 2018 · N78870 · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation during the initial climb. Contributing to the accident was the pilot’s decision to initiate a 180° turn following the loss of power.

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

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

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