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

## Cases, newest first

- [NTSB WPR20CA160](https://openairdocs.org/ntsb/WPR20CA160.md): Champion 7ECA · Vine Grove, KY · Accident · No injuries · Class 4 · Data collection · Final report · May 28, 2020 · N9557S · Substantial damage
  > Aircraft control was not maintained during initial climb with gusting wind that resulted in a collision with power lines and the terrain.
- [NTSB DCA20LA107](https://openairdocs.org/ntsb/DCA20LA107.md): Boeing 737 · Victorville, CA · Accident · No injuries · Class 3 · Limited · Final report · May 19, 2020 · N820TJ · Substantial damage
  > Improper installation of dorsal fin attach bolts which caused the dorsal fin to separate during flight, substantially damaging the left horizontal stabilizer.
- [NTSB ERA20LA192](https://openairdocs.org/ntsb/ERA20LA192.md): Beech F90 · Knoxville, TN · Accident · No injuries · Class 3 · Limited · Final report · May 18, 2020 · N960V · Substantial damage
  > A failure of the left main landing gear scissors, which resulted in a landing gear collapse following a precautionary landing with the landing gear in an intermediate position..
- [NTSB CEN20LA172](https://openairdocs.org/ntsb/CEN20LA172.md): Cessna T210L · Burleson, TX · Accident · 1 fatal · Class 3 · Limited · Final report · May 7, 2020 · N2074S · Destroyed
  > The loss of engine power due to fuel starvation.
- [NTSB WPR20CA127](https://openairdocs.org/ntsb/WPR20CA127.md): FLIGHTstar 2 · Oakdale, CA · Accident · No injuries · Data collection · Final report · Apr 21, 2020 · UNREG · Substantial damage
  > The noncertificated pilot’s decision to take off through a large helicopter’s rotor wash, which resulted in his inability to gain altitude during takeoff.
- [NTSB WPR20LA128](https://openairdocs.org/ntsb/WPR20LA128.md): Piper PA31T · Billings, MT · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 20, 2020 · N926K · Destroyed
  > The degraded airplane performance after takeoff for reasons that could not be determined from available evidence.
- [NTSB WPR20LA123](https://openairdocs.org/ntsb/WPR20LA123.md): Cessna TU206 · Auburn, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 18, 2020 · N756TH · Destroyed
  > The total loss of engine power after takeoff due to water contamination of the fuel.
- [NTSB ERA20WA172](https://openairdocs.org/ntsb/ERA20WA172.md): Comp Air CA-8 · Campo Verde, Brazil · Accident · 1 fatal · Foreign investigation · Apr 13, 2020 · PP-XLD · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving an amateur-built COMP AIR CA-8 airplane that occurred on April 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…
- [NTSB ERA20LA150](https://openairdocs.org/ntsb/ERA20LA150.md): Arion Lightning LS-1 · Mount Pleasant, SC · Accident · 2 fatal · Class 3 · Limited · Final report · Apr 10, 2020 · N81DJ · Destroyed
  > The pilot's failure to maintain clearance from trees at the end of the runway due to spatial disorientation during initial climb in dark night conditions. Also causal was the flight instructor’s inadequate monitoring, which did not identify and prevent the…
- [NTSB WPR20LA122](https://openairdocs.org/ntsb/WPR20LA122.md): Buckman Bucks Special · Prescott, WA · Accident · No injuries · Class 3 · Limited · Final report · Apr 9, 2020 · N9065F · Substantial damage
  > Diminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…
- [NTSB WPR20LA117](https://openairdocs.org/ntsb/WPR20LA117.md): Cessna 177RG · Santa Paula, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 5, 2020 · N98SW · Substantial damage
  > The pilot’s failure to ensure adequate fuel onboard for the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR20LA116](https://openairdocs.org/ntsb/WPR20LA116.md): TL Ultralight Sro Stingsport · Hurricane, UT · Accident · No injuries · Class 3 · Limited · Final report · Mar 28, 2020 · N7997N · Substantial damage
  > A total loss of engine power due to the failure of the ignition system as a result of foreign object damage.
- [NTSB CEN20LA133](https://openairdocs.org/ntsb/CEN20LA133.md): Cessna 150 · McKinney, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 25, 2020 · N4729U · Substantial damage
  > The pilot's inadequate preflight fuel planning and inflight fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA20WA133](https://openairdocs.org/ntsb/ERA20WA133.md): Piper PA23 · Eleuthera, Bahamas · Accident · No injuries · Foreign investigation · Mar 21, 2020 · N14178
  > The government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on March 21, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions of…
- [NTSB ERA20FA124](https://openairdocs.org/ntsb/ERA20FA124.md): Cessna 177RG · Sterling, MA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 11, 2020 · N1572H · Substantial damage
  > A total loss of engine power during takeoff due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.
- [NTSB ERA20LA127](https://openairdocs.org/ntsb/ERA20LA127.md): Piper PA23 · Albemarle, NC · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2020 · N335W · Substantial damage
  > The pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.
- [NTSB DCA20WA096](https://openairdocs.org/ntsb/DCA20WA096.md): Embraer ERJ170-200LR · Apodaca, Mexico · Incident · No injuries · Foreign investigation · Mar 5, 2020 · N250NN · No damage
- [NTSB DCA20WA089](https://openairdocs.org/ntsb/DCA20WA089.md): Boeing 737 · Brazzaville, Congo - Kinshasa · Incident · No injuries · Foreign investigation · Mar 1, 2020 · CN-RNK
  > The government of Congo has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…
- [NTSB ANC20CA030](https://openairdocs.org/ntsb/ANC20CA030.md): Piper PA18 · Big Lake, AK · Accident · No injuries · Data collection · Final report · Feb 29, 2020 · N7384D · Substantial damage
  > The pilot's failure to use carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with snow.
- [NTSB CEN20CA106](https://openairdocs.org/ntsb/CEN20CA106.md): Kitfox 57 Super Sport · Kosciusko, MS · Accident · No injuries · Data collection · Final report · Feb 28, 2020 · N92MH · Substantial damage
  > The pilot's lifting off with the airplane at a high of angle of attack, which resulted in aerodynamic stall.
- [NTSB ENG20WA018](https://openairdocs.org/ntsb/ENG20WA018.md): Airbus A321 · London, United Kingdom · Incident · No injuries · Foreign investigation · Feb 26, 2020 · G-POWN · No damage
  > On February 26, 2020, an Airbus A321-211, powered by two CFM International CFM56-5B3/3 turbofan engines experienced a left (No. 1) engine surge on departure from London Gatwick Airport (LGW) and an ECAM alert for the right engine (No. 2) stall condition. The…
- [NTSB WPR20LA094](https://openairdocs.org/ntsb/WPR20LA094.md): Ercoupe 415 · Torrance, CA · Accident · No injuries · Class 3 · Limited · Final report · Feb 25, 2020 · N3437H · Substantial damage
  > The partial loss of power due to a malfunction of the throttle cable, which limited movement of the throttle body.
- [NTSB ANC20FA024](https://openairdocs.org/ntsb/ANC20FA024.md): Cessna 305 · Mokuleia, HI · Accident · 2 fatal · Class 3 · Field · Final report · Feb 22, 2020 · N65070 · Substantial damage
  > A separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.
- [NTSB ERA20LA105](https://openairdocs.org/ntsb/ERA20LA105.md): Cessna 172 · Fayetteville, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 17, 2020 · N5185R · Substantial damage
  > The passenger’s excessive control application during the takeoff and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB GAA20WA111](https://openairdocs.org/ntsb/GAA20WA111.md): Piper PA31 · Guaymaral, Colombia · Accident · 4 fatal · Foreign investigation · Feb 12, 2020 · HK4686 · Destroyed
  > The government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on February 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB ERA20CA100](https://openairdocs.org/ntsb/ERA20CA100.md): Cessna 402 · Barnstable, MA · Accident · No injuries · Data collection · Final report · Feb 12, 2020 · N409BK · Substantial damage
  > The pilot's failure to properly secure the crew hatch door before takeoff, which resulted in the door’s forward hinge assembly tearing from its fuselage mount point.
- [NTSB CEN20LA078](https://openairdocs.org/ntsb/CEN20LA078.md): Navion Navion · Fort Smith, AR · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 9, 2020 · N1011M · Substantial damage
  > The inadequate inspection of the fuel selector valve, which was degraded, allowed fuel to leak, and resulted in fuel starvation and a loss of engine power.
- [NTSB ENG20RA030](https://openairdocs.org/ntsb/ENG20RA030.md): Airbus A320 · Budapest, Hungary · Incident · No injuries · Class 5 · Foreign · Feb 3, 2020 · VP-BMF · No damage
  > import
- [NTSB ERA20FA085](https://openairdocs.org/ntsb/ERA20FA085.md): Piper PA32 · Lake City, FL · Accident · 1 fatal · Class 3 · Field · Final report · Jan 25, 2020 · N55455 · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.
- [NTSB ENG20WA017](https://openairdocs.org/ntsb/ENG20WA017.md): Airbus A320 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Jan 24, 2020 · N528VL · No damage
  > On January 24, 2020, an Airbus A320-271N neo, powered by two Pratt & Whitney PW1127G-JM geared turbofan engines, experienced a right (No. 2) engine failure while climbing through 11,500 feet after takeoff from the Mexico City Intentional Airport (MMMX). The…
- [NTSB WPR20LA068](https://openairdocs.org/ntsb/WPR20LA068.md): Cessna 172Q · Big Timber, MT · Accident · No injuries · Class 3 · Limited · Final report · Jan 17, 2020 · N96145 · Substantial damage
  > A loss of engine power during climbout for undetermined reasons.
- [NTSB CEN20LA063](https://openairdocs.org/ntsb/CEN20LA063.md): Piel CP301 · Paulding, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 17, 2020 · N4120 · Destroyed
  > The pilot’s failure to maintain control of the airplane following the loss of engine power. The loss of engine power was the result of fuel starvation due to the degraded fuel tank and fuel contamination.
- [NTSB ERA20LA079](https://openairdocs.org/ntsb/ERA20LA079.md): Rans S12 · Titusville, FL · Accident · No injuries · Class 3 · Limited · Final report · Jan 16, 2020 · N73KA · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB DCA20RA048](https://openairdocs.org/ntsb/DCA20RA048.md): Boeing 737 · Tehran, Iran · Accident · 176 fatal · Foreign investigation · Jan 8, 2020 · UR-PSR · Destroyed
  > The government of Iran has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iran's investigation under the provisions of…
- [NTSB ERA20FA063](https://openairdocs.org/ntsb/ERA20FA063.md): Vans Vans RV-6 · Cullman, AL · Accident · 2 fatal · Class 3 · Field · Final report · Jan 5, 2020 · N420PW · Destroyed
  > The pilot’s inadequate planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the runway after…
- [NTSB ERA20WA061](https://openairdocs.org/ntsb/ERA20WA061.md): Piper PA-32-301T · Vereda Cuzama, Colombia · Accident · 3 fatal · Foreign investigation · Dec 30, 2019 · HK2629 · Substantial damage
  > The government of Colombia has notified the NTSB of an accident involving a PIPER PA-32-301T airplane that occurred on December 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB ERA20FA060](https://openairdocs.org/ntsb/ERA20FA060.md): American AA5 · College Park, MD · Accident · 1 fatal · Class 3 · Field · Final report · Dec 29, 2019 · N26455 · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation after entering a climbing turn in instrument meteorological conditions.
- [NTSB ERA20LA062](https://openairdocs.org/ntsb/ERA20LA062.md): Piper PA32RT · Fletcher, NC · Accident · No injuries · Class 3 · Limited · Final report · Dec 28, 2019 · N27GB · Destroyed
  > A failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.
- [NTSB CEN20MA044](https://openairdocs.org/ntsb/CEN20MA044.md): Piper PA 31T · Lafayette, LA · Accident · 5 fatal · Class 2 · Major · Final report · Dec 28, 2019 · N42CV · Destroyed
  > The pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.
- [NTSB CEN20WA126](https://openairdocs.org/ntsb/CEN20WA126.md): Cessna 152 · San Salvador, El Salvador · Accident · No injuries · Foreign investigation · Dec 27, 2019 · YS-162PE · Destroyed
  > On December 27, 2019, about 0730 local time, a Cessna 152 airplane, YS-162PE, impacted terrain near San Salvador, El Salvador, and was destroyed. The two occupants were not injured. The accident investigation is under the jurisdiction and control of the…
- [NTSB ERA20CA058](https://openairdocs.org/ntsb/ERA20CA058.md): Cessna P210 · Gainesville, FL · Accident · Minor injuries · Data collection · Final report · Dec 21, 2019 · N6300W · Substantial damage
  > The airplane's impact by a bird during the initial climb.
- [NTSB CEN20FA032](https://openairdocs.org/ntsb/CEN20FA032.md): Cessna 208 · Victoria, TX · Accident · 1 fatal · Class 3 · Field · Final report · Dec 10, 2019 · N4602B · Destroyed
  > The pilot’s loss of control due to spatial disorientation. Contributing to the accident were the inoperative attitude indicator and horizontal situation indicator on the pilot’s side of the cockpit, and the pilot’s failure to reference the flight instruments…
- [NTSB ERA20LA050](https://openairdocs.org/ntsb/ERA20LA050.md): Zenith Zodiac CH-650 · Willow Springs, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 8, 2019 · N914AR · Substantial damage
  > Improper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.
- [NTSB CEN20FA022](https://openairdocs.org/ntsb/CEN20FA022.md): Pilatus PC12 · Chamberlain, SD · Accident · 9 fatal · Class 3 · Field · Final report · Nov 30, 2019 · N56KJ · Destroyed
  > The pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…
- [NTSB WPR20FA031](https://openairdocs.org/ntsb/WPR20FA031.md): Grumman AA5 · Jackpot, NV · Accident · 2 fatal · Class 3 · Field · Final report · Nov 23, 2019 · N310PD · Destroyed
  > The pilot’s loss of control due to spatial disorientation while departing in dark night conditions, which resulted in impact with terrain. Contributing to the accident was the pilot’s limited experience flying in night conditions.
- [NTSB ERA20LA044](https://openairdocs.org/ntsb/ERA20LA044.md): Beech E35 · Okeechobee, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 23, 2019 · N3315C · Destroyed
  > The separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…
- [NTSB CEN20FA019](https://openairdocs.org/ntsb/CEN20FA019.md): Raytheon A36 · San Marcos, TX · Accident · 1 fatal · Class 3 · Field · Final report · Nov 20, 2019 · N88855 · Destroyed
  > The pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.
- [NTSB WPR20LA022](https://openairdocs.org/ntsb/WPR20LA022.md): Cessna 150 · Red Rock, AZ · Accident · No injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N704QJ · Substantial damage
  > A total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.
- [NTSB ANC20LA004](https://openairdocs.org/ntsb/ANC20LA004.md): Piper PA32R · Goodnews Bay, AK · Accident · No injuries · Class 3 · Limited · Final report · Nov 11, 2019 · N7721C · Substantial damage
  > The pilot’s failure to monitor the airplane instruments during a night visual flight rules departure in dark light conditions, which resulted in spatial disorientation and the airplane’s descent into water.
- [NTSB CEN20LA018](https://openairdocs.org/ntsb/CEN20LA018.md): Piper PA32 · Houston, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 9, 2019 · N7703J · Substantial damage
  > The pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.

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

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

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