# Major 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 1 of 2 · 89 cases

## Latest cases

- [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 CEN19MA190](https://openairdocs.org/ntsb/CEN19MA190.md): Textron B-300 · Addison, TX · Accident · 10 fatal · Class 2 · Major · Final report · Jun 30, 2019 · N534FF · Destroyed
  > The pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…
- [NTSB DCA13MA121](https://openairdocs.org/ntsb/DCA13MA121.md): Dehavilland DHC-3 · Soldotna, AK · Accident · 10 fatal · Major investigation · Final report · Jul 7, 2013 · N93PC · Destroyed
  > The operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…
- [NTSB DCA13MA081](https://openairdocs.org/ntsb/DCA13MA081.md): Boeing 747-400 BCF · Bagram, Afghanistan · Accident · 7 fatal · Class 1 · Major · Final report · Apr 29, 2013 · N949CA · Destroyed
  > National Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…
- [NTSB ERA12MA005](https://openairdocs.org/ntsb/ERA12MA005.md): Bell 206B · New York, NY · Accident · 2 fatal · Major investigation · Final report · Oct 4, 2011 · N63Q · Substantial damage
  > The pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…
- [NTSB CEN10MA367](https://openairdocs.org/ntsb/CEN10MA367.md): Cessna 421B · Alpine, TX · Accident · 5 fatal · Major investigation · Final report · Jul 4, 2010 · N31AS · Substantial damage
  > The degraded performance of the airplane due to the pilot not properly setting the flaps and retracting the landing gear after takeoff. Contributing to the accident was the pilot’s fatigue.
- [NTSB DCA09MA026](https://openairdocs.org/ntsb/DCA09MA026.md): Airbus A320 · Weehawken, NJ · Accident · Serious injuries · Class 1 · Major · Final report · Jan 15, 2009 · N106US · Substantial damage
  > The ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…
- [NTSB CHI08MA270](https://openairdocs.org/ntsb/CHI08MA270.md): Convair CV-580 · Columbus, OH · Accident · 3 fatal · Major investigation · Final report · Sep 1, 2008 · N587X · Destroyed
  > The improper (reverse) rigging of the elevator trim cables by company maintenance personnel, and their subsequent failure to discover the misrigging during required post-maintenance checks. Contributing to the accident was the captain’s inadequate…
- [NTSB LAX08MA277](https://openairdocs.org/ntsb/LAX08MA277.md): Beech A100 · Moab, UT · Accident · 10 fatal · Major investigation · Final report · Aug 22, 2008 · N601PC · Substantial damage
  > The pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.
- [NTSB LAX08PA259](https://openairdocs.org/ntsb/LAX08PA259.md): Sikorsky S-61N · Weaverville, CA · Accident · 9 fatal · Class 1 · Final report · Aug 6, 2008 · N612AZ · Destroyed
  > The following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…
- [NTSB DFW08MA076](https://openairdocs.org/ntsb/DFW08MA076.md): Cessna 500 · Oklahoma City, OK · Accident · 5 fatal · Class 1 · Major · Final report · Mar 4, 2008 · N113SH · Destroyed
  > Airplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.
- [NTSB ANC08MA038](https://openairdocs.org/ntsb/ANC08MA038.md): Piper PA-31-350 · Kodiak, AK · Accident · 6 fatal · Major investigation · Final report · Jan 5, 2008 · N509FN · Substantial damage
  > The failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…
- [NTSB LAX07MA069](https://openairdocs.org/ntsb/LAX07MA069.md): Cessna 525 · Van Nuys, CA · Accident · 2 fatal · Major investigation · Final report · Jan 12, 2007 · N77215 · Destroyed
  > The pilot's failure to maintain an adequate airspeed during the initial climb resulting in an inadvertent stall/spin. Contributing to the accident were the second pilots inadequate preflight, failure to properly secure the front baggage door, and the front…
- [NTSB LAX05FA015](https://openairdocs.org/ntsb/LAX05FA015.md): Learjet 35A · San Diego, CA · Accident · 5 fatal · Class 1 · Field · Final report · Oct 24, 2004 · N30DK · Destroyed
  > The failure of the flight crew to maintain terrain clearance during a VFR departure, which resulted in controlled flight into terrain, and the air traffic controller's issuance of a clearance that transferred the responsibility for terrain clearance from the…
- [NTSB CHI04MA182](https://openairdocs.org/ntsb/CHI04MA182.md): Bell 407 · Newberry, SC · Accident · 4 fatal · Major investigation · Final report · Jul 13, 2004 · N503MT · Destroyed
  > The pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.
- [NTSB DCA02MA001](https://openairdocs.org/ntsb/DCA02MA001.md): Airbus Industrie A300B4-605R · Belle Harbor, NY · Accident · 265 fatal · Class 1 · Major · Final report · Nov 12, 2001 · N14053 · Destroyed
  > the in-flight separation of the vertical stabilizer as a result of the loads beyond ultimate design that were created by the first officer's unnecessary and excessive rudder pedal inputs. Contributing to these rudder pedal inputs were characteristics of the…
- [NTSB CHI01MA006](https://openairdocs.org/ntsb/CHI01MA006.md): Canadair CL600-2B16 · Wichita, KS · Accident · 2 fatal · Class 1 · Major · Final report · Oct 10, 2000 · CFTBZ · Destroyed
  > the pilot’s excessive takeoff rotation, during an aft center of gravity (c.g.) takeoff, a rearward migration of fuel during acceleration and takeoff and consequent shift in the airplane’s aft c.g. to aft of the aft c.g. limit, which caused the airplane to…
- [NTSB DCA00MA079](https://openairdocs.org/ntsb/DCA00MA079.md): Douglas DC-9-32 · Greensboro, NC · Accident · Minor injuries · Major investigation · Final report · Aug 8, 2000 · N838AT · Substantial damage
  > A phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…
- [NTSB DCA00MA026](https://openairdocs.org/ntsb/DCA00MA026.md): Douglas DC-8-71F · Rancho Cordova, CA · Accident · 3 fatal · Class 1 · Major · Final report · Feb 17, 2000 · N8079U · Destroyed
  > A loss of pitch control resulting from the disconnection of the right elevator control tab. The disconnection was caused by the failure to properly secure and inspect the attachment bolt.
- [NTSB CHI99MA269](https://openairdocs.org/ntsb/CHI99MA269.md): Beech 65-A90 · Marine City, MI · Accident · 10 fatal · Major investigation · Final report · Jul 31, 1999 · N518DM · Destroyed
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.
- [NTSB FTW98MA126](https://openairdocs.org/ntsb/FTW98MA126.md): Embraer 145-ER · Beaumont, TX · Accident · Serious injuries · Major investigation · Final report · Feb 11, 1998 · N14931 · Substantial damage
  > The first officer's improper use of the rudder when given a simulated engine failure on takeoff and the pilot-in-command's delayed remedial action which resulted in a loss of control. A factor was the first officer's lack of experience in the regional jet…
- [NTSB ANC98MA008](https://openairdocs.org/ntsb/ANC98MA008.md): Cessna 208B · Barrow, AK · Accident · 8 fatal · Major investigation · Final report · Nov 8, 1997 · N750GC · Destroyed
  > The pilot's disregard for lateral fuel loading limits, his improper removal of frost prior to takeoff, and the resulting inadvertent stall/spin. Factors involved in this accident were the improper asymmetrical fuel loading which reduced lateral aircraft…
- [NTSB SEA96MA079](https://openairdocs.org/ntsb/SEA96MA079.md): Cessna 177B · Cheyenne, WY · Accident · 3 fatal · Class 1 · Major · Final report · Apr 11, 1996 · N35207 · Destroyed
  > the pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…
- [NTSB MIA96FA059](https://openairdocs.org/ntsb/MIA96FA059.md): Douglas DC-9-32 · Nashville, TN · Accident · Minor injuries · Class 1 · Field · Final report · Jan 7, 1996 · N922VV · Substantial damage
  > the flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…
- [NTSB NYC95MA220](https://openairdocs.org/ntsb/NYC95MA220.md): Beech 65 · West Point, VA · Accident · 12 fatal · Major investigation · Final report · Sep 10, 1995 · N945PA · Destroyed
  > The pilot's inadequate preflight/preparation, his failure to ensure proper weight and balance of the airplane, and his failure to obtain/maintain minimum control speed, which resulted in a loss of aircraft control after loss of power in one engine. A factor…
- [NTSB DCA95MA019](https://openairdocs.org/ntsb/DCA95MA019.md): Piper PA-31-350 · Tusayan, AZ · Accident · 8 fatal · Major investigation · Final report · Feb 13, 1995 · N27245 · Destroyed
  > a loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…
- [NTSB DCA92MA048](https://openairdocs.org/ntsb/DCA92MA048.md): Beech C-45H · Hinckley, IL · Accident · 12 fatal · Major investigation · Final report · Sep 7, 1992 · N3657G · Destroyed
  > Inadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…
- [NTSB DCA92MA044](https://openairdocs.org/ntsb/DCA92MA044.md): Lockheed L-1011-385-1 · Jamaica, NY · Accident · Serious injuries · Class 1 · Major · Final report · Jul 30, 1992 · N11002 · Destroyed
  > Design deficiencies in the stall warning system that permitted a defect to go undetected, the failure of twa's maintenance program to correct a repetitive malfunction of the stall warning system, and inadequate crew coordination between the captain and first…
- [NTSB DCA92MA040](https://openairdocs.org/ntsb/DCA92MA040.md): Cessna 402C · Meadview, AZ · Accident · 10 fatal · Major investigation · Final report · Jun 19, 1992 · N2715X · Destroyed
  > Failure of the pilot to follow the emergency procedure (engine failure after takeoff) and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were failure (disengagement) of the…
- [NTSB LAX92MA183](https://openairdocs.org/ntsb/LAX92MA183.md): de Havilland DHC-6-200 · Perris, CA · Accident · 16 fatal · Major investigation · Final report · Apr 22, 1992 · N141PV · Destroyed
  > The pilot-in-command's inadvertent feathering of the wrong propeller following an engine power loss, and the failure of the operator to assure that the pilot was provided with adequate training in the airplane. Factors related to the accident were: water…
- [NTSB DCA92MA025](https://openairdocs.org/ntsb/DCA92MA025.md): Fokker 28-4000 · Flushing, NY · Accident · 27 fatal · Class 1 · Major · Final report · Mar 23, 1992 · N485US · Destroyed
  > The failure of the airline industry and the federal aviation administration to provide flightcrews with procedures, requirements, and criteria compatible with departure delays in conditions conducive to airframe icing and the decision by the flightcrew to…
- [NTSB DCA91MA021](https://openairdocs.org/ntsb/DCA91MA021.md): Mcdonnell Douglas DC-9-15 · Cleveland, OH · Accident · 2 fatal · Class 1 · Major · Final report · Feb 17, 1991 · N565PC · Destroyed
  > The failure of the flightcrew to detect and remove ice contamination on the airplane's wings, which was largely a result of a lack of appropriate response by the federal aviation administration, Douglas aircraft company, and ryan international airlines to the…
- [NTSB DCA90MA055](https://openairdocs.org/ntsb/DCA90MA055.md): Boeing 707-321B · Marana, AZ · Accident · 1 fatal · Major investigation · Final report · Sep 20, 1990 · N320MJ · Destroyed
  > Improper preflight planning/preparation by the pilot, and his failure to use a checklist. Factors related to the accident were: the faa's inadequate surveillance of the operation, the faa's insufficient standards/requirements, the pilot's operation of the…
- [NTSB CHI90MA244](https://openairdocs.org/ntsb/CHI90MA244.md): Bell 206B · Elkhorn, WI · Accident · 5 fatal · Major investigation · Final report · Aug 27, 1990 · N16933 · Destroyed
  > Improper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…
- [NTSB FTW90MA161](https://openairdocs.org/ntsb/FTW90MA161.md): Grumman G-159 · Houston, TX · Accident · 3 fatal · Major investigation · Final report · Aug 23, 1990 · N80RD · Destroyed
  > Partial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…
- [NTSB CHI89MA046](https://openairdocs.org/ntsb/CHI89MA046.md): Boeing 737-201 · Chicago, IL · Accident · No injuries · Major investigation · Final report · Jan 20, 1989 · N242US · Substantial damage
  > Previous damage to the aft cone (engine mounting) bolt, which resulted in mismatched surfaces between the bolt and isolation mount, loss of torque during cyclic loading of the mounting bolt, and subsequent fatigue failure of the bolt.
- [NTSB DCA88MA072](https://openairdocs.org/ntsb/DCA88MA072.md): Boeing 727-232 · Dallas/Ft Worth, TX · Accident · 14 fatal · Class 1 · Major · Final report · Aug 31, 1988 · N473DA · Destroyed
  > (1) The captain and first officer's inadequate cockpit discipline which resulted in the flightcrew's attempt to takeoff without the wing flaps and slats properly configured; and (2) the failure of the takeoff configuration warning system to alert the crew…
- [NTSB DCA88MA059](https://openairdocs.org/ntsb/DCA88MA059.md): Embraer EMB-110P · Lawton, OK · Accident · Serious injuries · Major investigation · Final report · May 24, 1988 · N65DA · Destroyed
  > None submitted
- [NTSB DCA88MA032](https://openairdocs.org/ntsb/DCA88MA032.md): Fairchild SA227-AC · Cary, NC · Accident · 12 fatal · Major investigation · Final report · Feb 20, 1988 · N622AV · Destroyed
  > The aircraft departed during low ceiling, low visibility, and night conditions. Shortly after takeoff the aircraft impacted a reservoir. Analysis of radar data indicated the acft was in a 45 degree descending turn. Exam of the acft trim system showed that the…
- [NTSB DCA88MA011](https://openairdocs.org/ntsb/DCA88MA011.md): Piper PA-31-350 · Kenai, AK · Accident · 6 fatal · Major investigation · Final report · Dec 23, 1987 · N496SC · Destroyed
  > The pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…
- [NTSB DCA88MA004](https://openairdocs.org/ntsb/DCA88MA004.md): Mcdonnell Douglas DC-9-14 · Denver, CO · Accident · 28 fatal · Major investigation · Final report · Nov 15, 1987 · N626TX · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…
- [NTSB SEA87MA192](https://openairdocs.org/ntsb/SEA87MA192.md): Fairchild SA227-AC · Twin Falls, ID · Accident · Serious injuries · Major investigation · Final report · Sep 25, 1987 · N2689E · Destroyed
  > Chk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to…
- [NTSB DCA87MA046](https://openairdocs.org/ntsb/DCA87MA046.md): Mcdonnell Douglas DC-9-82 · Romulus, MI · Accident · 156 fatal · Major investigation · Final report · Aug 17, 1987 · N312RC · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…
- [NTSB DCA87MA033](https://openairdocs.org/ntsb/DCA87MA033.md): British Aerospace 3101 · Kenner, LA · Accident · Serious injuries · Major investigation · Final report · May 26, 1987 · N331CY · Destroyed
  > The acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…
- [NTSB DCA87MA031](https://openairdocs.org/ntsb/DCA87MA031.md): Learjet 35A · West Mifflin, PA · Accident · 2 fatal · Major investigation · Final report · May 12, 1987 · N100EP · Destroyed
  > The coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &…
- [NTSB DCA87MA023](https://openairdocs.org/ntsb/DCA87MA023.md): Cessna 172N · Oakland, CA · Accident · 3 fatal · Class 1 · Major · Final report · Mar 31, 1987 · N75584 · 2 aircraft · Destroyed
  > At 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…
- [NTSB CHI87MA101](https://openairdocs.org/ntsb/CHI87MA101.md): Mcdonnell Douglas DC-10-10 · Chicago, IL · Accident · Serious injuries · Major investigation · Final report · Mar 25, 1987 · N128AA · No damage
  > After arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…
- [NTSB LAX87MA125](https://openairdocs.org/ntsb/LAX87MA125.md): Boeing 727-224 · Los Angeles, CA · Accident · No injuries · Major investigation · Final report · Feb 26, 1987 · N88704 · 2 aircraft · No damage
  > After a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…
- [NTSB DCA87AA002](https://openairdocs.org/ntsb/DCA87AA002.md): Lockheed 382G · Kelly Afb, TX · Accident · 3 fatal · Final report · Oct 4, 1986 · N15ST · Destroyed
  > After the acft landed at Kelly Afb, TX, on 10/2/86, there was a crew chg bfr it depd on the next flt. Drg the next take-off, the acft lifted off near the midpoint of rwy 15 (aprx 5775' fm the apch end). When it was at aprx 100' to 200' AGL,witnesses saw it go…
- [NTSB MIA86MA048](https://openairdocs.org/ntsb/MIA86MA048.md): Boeing 727-232 · Fort Lauderdale, FL · Incident · No injuries · Major investigation · Final report · Dec 28, 1985 · N519DA · Minor damage
  > After gear retraction drg takeoff, at aprx 150' AGL, the aircrew heard a loud noise & noted the #2 eng had failed. They secured the eng, dumped fuel & landed without further incident. An exam of the #2 eng revealed the combustion chamber outer case, pn…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?major=1&page=2

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND 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?major=1

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