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

## Cases, newest first

- [NTSB DCA20IA014](https://openairdocs.org/ntsb/DCA20IA014.md): Embraer ERJ170 · Atlanta, GA · Incident · No injuries · Class 3 · Incident · Final report · Nov 7, 2019 · N117HQ · No damage
  > The captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…
- [NTSB ERA20FA022](https://openairdocs.org/ntsb/ERA20FA022.md): Beech 58 · Ocala, FL · Accident · 2 fatal · Class 3 · Field · Final report · Oct 31, 2019 · N959CM · Destroyed
  > The pilot’s failure to maintain control of the airplane due to an acute medical event and/or his use of impairing medications.
- [NTSB DCA20WA011](https://openairdocs.org/ntsb/DCA20WA011.md): Boeing 737 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Oct 31, 2019 · D2-TBK · No damage
  > The CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA20FA021](https://openairdocs.org/ntsb/ERA20FA021.md): Piper PA28R · Atlanta, GA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 30, 2019 · N56258 · Destroyed
  > The pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.
- [NTSB DCA20CA010](https://openairdocs.org/ntsb/DCA20CA010.md): De Havilland DHC8 · Boise, ID · Accident · No injuries · Data collection · Final report · Oct 29, 2019 · N402QX · Substantial damage
  > a bird strike during climb out.
- [NTSB ERA20LA023](https://openairdocs.org/ntsb/ERA20LA023.md): Piper J3C · Grand Bay, AL · Accident · No injuries · Class 3 · Limited · Final report · Oct 27, 2019 · N7009H · Substantial damage
  > A loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.
- [NTSB WPR20WA137](https://openairdocs.org/ntsb/WPR20WA137.md): Robinson R44 · Pretoria, South Africa · Accident · No injuries · Foreign investigation · Oct 25, 2019 · ZT-RAL · Substantial damage
  > The government of South African Civil Aviation Authority has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on October 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South…
- [NTSB GAA20WA077](https://openairdocs.org/ntsb/GAA20WA077.md): Cessna 310 · La Piedad, Mexico · Accident · 2 fatal · Foreign investigation · Oct 20, 2019 · XB-SIG · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA 310 airplane that occurred on October 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB WPR20LA009](https://openairdocs.org/ntsb/WPR20LA009.md): Cessna 206 · Stockton, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 18, 2019 · N11379 · Substantial damage
  > A total loss of engine power after takeoff for reasons that could not be determined based on the available information.
- [NTSB ENG20WA007](https://openairdocs.org/ntsb/ENG20WA007.md): BAE AVRO146RJ · Cape Town, South Africa · Incident · No injuries · Foreign investigation · Oct 9, 2019 · ZS-TCP · No damage
  > On October 9, 2019, a South African Airlink British Aerospace Avro 146-RJ85, registered in South Africa as ZS-TCP, experienced a No. 3 engine fire warning on departure from Cape Town International Aerodrome, Cape Town, South Africa. The airplane is equipped…
- [NTSB ERA20LA008](https://openairdocs.org/ntsb/ERA20LA008.md): Raytheon Hawker · Fort Myers, FL · Accident · No injuries · Class 3 · Limited · Final report · Oct 8, 2019 · N86MN · Substantial damage
  > Maintenance personnel's improper installation of the nose landing gear assembly, which resulted in separation of the actuator arm and the failure of a nose landing gear to lock in place.
- [NTSB CEN20LA004](https://openairdocs.org/ntsb/CEN20LA004.md): Beech B36 · Ranger, TX · Accident · No injuries · Class 3 · Limited · Final report · Oct 6, 2019 · N36LS · Substantial damage
  > A lack of climb performance after takeoff for reasons that could not be determined based on the available information.
- [NTSB WPR20LA001](https://openairdocs.org/ntsb/WPR20LA001.md): Buckeye Breeze · Moore, UT · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 5, 2019 · N582UT · Substantial damage
  > The pilot’s improper preflight inspection and detection of a pinch point in the steering line, which resulted in a loss of control in flight and impact with terrain.
- [NTSB CEN20LA005](https://openairdocs.org/ntsb/CEN20LA005.md): Zenair Zenith CH 701 · Garden Ridge, TX · Accident · No injuries · Limited investigation · Final report · Oct 5, 2019 · N701BJ · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ENG19WA041](https://openairdocs.org/ntsb/ENG19WA041.md): Embraer ERJ190 · Buenos Aires, Argentina · Incident · No injuries · Foreign investigation · Sep 29, 2019 · LV-CIG · Minor damage
  > The Junta de Investigación de Accidentes de Aviación Civil (JIAAC) República ARGENTINA has notified the NTSB of an incident involving an Embraer ERJ190, which occurred on September 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…
- [NTSB ANC19TA055](https://openairdocs.org/ntsb/ANC19TA055.md): Stinson 108 · Tyonek, AK · Accident · Serious injuries · Class 4 · Final report · Sep 26, 2019 · N6533M · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a short field takeoff, which resulted in an aerodynamic stall and loss of control.
- [NTSB ANC19LA054](https://openairdocs.org/ntsb/ANC19LA054.md): Piper PA 18 · Beluga, AK · Accident · No injuries · Class 3 · Limited · Final report · Sep 23, 2019 · N7071B · Substantial damage
  > The pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.
- [NTSB WPR19FA262](https://openairdocs.org/ntsb/WPR19FA262.md): Cessna 177 · Torrance, CA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 19, 2019 · N2323Y · Destroyed
  > The pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.
- [NTSB GAA19CA555](https://openairdocs.org/ntsb/GAA19CA555.md): Cessna 175 · Toklat, AK · Accident · Serious injuries · Data collection · Final report · Sep 15, 2019 · N6837E · Substantial damage
  > The pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.
- [NTSB GAA19WA595](https://openairdocs.org/ntsb/GAA19WA595.md): Cozy Mark IV · Rio Verda, GO, Brazil · Accident · 2 fatal · Foreign investigation · Sep 13, 2019 · PR-ZQA · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a COZY Mark IV airplane that occurred on September 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB CEN19LA317](https://openairdocs.org/ntsb/CEN19LA317.md): Piper PA28 · Boca Raton, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 11, 2019 · N2890T · Destroyed
  > The total loss of engine power for reasons that could not be determined based on available evidence and the pilot’s decision to take off without fully troubleshooting the partial loss of engine power that occurred during the previous flight.
- [NTSB CEN19LA311](https://openairdocs.org/ntsb/CEN19LA311.md): Cessna 172 · Grassy Butte, ND · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 10, 2019 · N5347T · Substantial damage
  > A total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.
- [NTSB WPR19FA252](https://openairdocs.org/ntsb/WPR19FA252.md): Beech C24 · Las Vegas, NV · Accident · 2 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N24030 · Destroyed
  > The pilot’s operation of the airplane over its maximum gross weight and outside of center of gravity limits at a high-density altitude, which resulted in the exceedance of the airplane's critical angle of attack while maneuvering and subsequent aerodynamic…
- [NTSB ERA19FA266](https://openairdocs.org/ntsb/ERA19FA266.md): Cessna 210 · Marathon, FL · Accident · 2 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N9436X · Substantial damage
  > The pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.
- [NTSB CEN19LA306](https://openairdocs.org/ntsb/CEN19LA306.md): Pietenpol Sky Scout · Kingsbury, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 7, 2019 · N1932G · Substantial damage
  > The total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.
- [NTSB CEN19LA297](https://openairdocs.org/ntsb/CEN19LA297.md): Piper J3C · Independence Charter Township, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 2, 2019 · N98278 · Substantial damage
  > The reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.
- [NTSB DCA19WA215](https://openairdocs.org/ntsb/DCA19WA215.md): Boeing 737 · Cape Town, South Africa · Incident · No injuries · Foreign investigation · Aug 31, 2019 · ZS-ZWU · No damage
  > The government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…
- [NTSB CEN19LA295](https://openairdocs.org/ntsb/CEN19LA295.md): Air Tractor AT502 · Olney, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 29, 2019 · N8517Q · Substantial damage
  > A loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.
- [NTSB WPR19LA242](https://openairdocs.org/ntsb/WPR19LA242.md): Lockheed C130 · Santa Barbara, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 26, 2019 · N119TG · Substantial damage
  > The failure of the No. 3 bleed air duct due to corrosion, which resulted in numerous system failures and the pilot’s inability to maintain directional control during the landing roll.
- [NTSB GAA19WA532](https://openairdocs.org/ntsb/GAA19WA532.md): Cessna 182 · Warintza, Morona Santiago, Ecuador · Accident · 4 fatal · Foreign investigation · Aug 23, 2019 · HC-CJN · Destroyed
  > The government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…
- [NTSB ERA19FA256](https://openairdocs.org/ntsb/ERA19FA256.md): Moriarty Marvin Aventura II · Minneola, FL · Accident · 1 fatal · Class 3 · Field · Final report · Aug 23, 2019 · N9143M · Substantial damage
  > The pilot’s improper modifications to the airplane’s engine, which resulted in the partial loss of engine power. Contributing to the outcome was the pilot's exceedance of the airplane’s critical angle of attack during an attempted return to the airport…
- [NTSB GAA19CA506](https://openairdocs.org/ntsb/GAA19CA506.md): Grob G103 · San Antonio, TX · Accident · No injuries · Data collection · Final report · Aug 22, 2019 · N901BG · Substantial damage
  > The failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.
- [NTSB CEN19FA276](https://openairdocs.org/ntsb/CEN19FA276.md): Shirley Carl Sportcopter Vortex · Viroqua, WI · Accident · 1 fatal · Class 2 · Field · Final report · Aug 19, 2019 · N634SC · Destroyed
  > The noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…
- [NTSB ERA19FA250](https://openairdocs.org/ntsb/ERA19FA250.md): Beech 95B55 · Wilmington, DE · Accident · 2 fatal · Class 3 · Field · Final report · Aug 18, 2019 · N678DM · Substantial damage
  > The pilots’ failure to place the left fuel selector into the proper position, which resulted in a total loss of the left engine’s power due to fuel starvation. Contributing was their failure to properly secure the left engine and their failure to maintain…
- [NTSB ERA19WA270](https://openairdocs.org/ntsb/ERA19WA270.md): Embraer EMB710 · Itaituba, Brazil · Accident · 3 fatal · Class 5 · Foreign · Aug 11, 2019 · PT-NKK · Destroyed
- [NTSB ERA19LA245](https://openairdocs.org/ntsb/ERA19LA245.md): Schweizer 269C · Allentown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 11, 2019 · N1831A · Substantial damage
  > Inadequate maintenance of the helicopter’s magnetos, which resulted in a partial loss of engine power during the initial climb due to a failure of the left magneto and malfunction of the right magneto.
- [NTSB CEN19LA262](https://openairdocs.org/ntsb/CEN19LA262.md): Pietenpol Aircamper · Newark, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 10, 2019 · N899DA · Substantial damage
  > The engine’s failure to produce full power for reasons that could not be determined.
- [NTSB CEN19LA257](https://openairdocs.org/ntsb/CEN19LA257.md): Piper PA28 · Jacksonville, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 3, 2019 · N951TS · Substantial damage
  > The pilot's failure to select a fuel tank with adequate fuel, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA19LA239](https://openairdocs.org/ntsb/ERA19LA239.md): Cessna 210 · Chattanooga, TN · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2019 · N2362F · Substantial damage
  > The improper maintenance of the airplane’s landing gear system, which resulted in a hydraulic fluid leak and insufficient pressure to extend and lock the landing gear during the accident flight.
- [NTSB CEN19LA242](https://openairdocs.org/ntsb/CEN19LA242.md): Icon A5 · Lake, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 2019 · N663BA · Substantial damage
  > The pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…
- [NTSB ERA19FA234](https://openairdocs.org/ntsb/ERA19FA234.md): Cirrus SR22 · Americus, GA · Accident · 2 fatal · Class 2 · Field · Final report · Jul 24, 2019 · N921CD · Destroyed
  > The pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…
- [NTSB CEN19LA244](https://openairdocs.org/ntsb/CEN19LA244.md): Air Tractor AT 602 · Walls, MS · Accident · No injuries · Class 3 · Limited · Final report · Jul 24, 2019 · N50634 · Substantial damage
  > The improper fuel servicing of the airplane, which resulted in water contamination of the airplane's fuel supply and a subsequent loss of engine power.
- [NTSB CEN19LA231](https://openairdocs.org/ntsb/CEN19LA231.md): Ayres S2R · Breckenridge, MI · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2019 · N766BF · Substantial damage
  > A total loss of engine power due to a lack of oil in the engine. The source of the inflight oil leak could not be determined based on the available information.
- [NTSB ERA19LA232](https://openairdocs.org/ntsb/ERA19LA232.md): Vans RV7 · Ocean City, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 19, 2019 · N849GS · Substantial damage
  > The disconnection of the propeller governor control arm from the propeller governor due to a missing attachment bolt, which resulted in a partial loss of engine power during takeoff when the governor control vibrated to a high pitch, low rpm setting.
- [NTSB ERA19LA226](https://openairdocs.org/ntsb/ERA19LA226.md): Cessna 120 · Summit, SC · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2019 · N3886V · Substantial damage
  > A total loss of engine power during initial climb due to carburetor ice formation.
- [NTSB ERA19LA224](https://openairdocs.org/ntsb/ERA19LA224.md): Zenith CH601 · Carlisle, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2019 · N601MR · Substantial damage
  > Water contamination of the fuel system, which resulted in a total loss of engine power. Contributing to the accident was the pilot's inadequate preflight inspection, which failed to remove all the water from the airplane's fuel system.
- [NTSB ERA19FA225](https://openairdocs.org/ntsb/ERA19FA225.md): Quicksilver Mxii · Oliver Springs, TN · Accident · 1 fatal · Class 3 · Field · Final report · Jul 13, 2019 · N3889Z · Substantial damage
  > The noncertificated pilot’s decision to continue to takeoff and climb after encountering an undetermined airplane control issue that he was unable to counteract, which resulted in collision with trees and subsequent impact with terrain.
- [NTSB GAA19WA459](https://openairdocs.org/ntsb/GAA19WA459.md): De Havilland DHC2 · Hawk Junction ON-Canada, Canada · Accident · 2 fatal · Foreign investigation · Jul 11, 2019 · C-FBBG · Destroyed
  > The government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…
- [NTSB ERA19FA210](https://openairdocs.org/ntsb/ERA19FA210.md): Agusta AW139 · Big Grand Cay, Bahamas · Accident · 7 fatal · Class 2 · Field · Final report · Jul 4, 2019 · N32CC · Substantial damage
  > The pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…
- [NTSB DCA19WA190](https://openairdocs.org/ntsb/DCA19WA190.md): Boeing 777 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jul 3, 2019 · G-YMMU · No damage
  > The Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.