# Major NTSB investigations: Landing

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 · 60 cases

## Latest cases

- [NTSB DCA26MA352](https://openairdocs.org/ntsb/DCA26MA352.md): Boeing 767 · Miami, FL · Accident · 5 fatal · Class 1 · Major · Preliminary report · Sep 6, 2026 · N1997A · Substantial damage
  > On September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…
- [NTSB DCA26MA161](https://openairdocs.org/ntsb/DCA26MA161.md): Mitsubishi CL-600 · New York, NY · Accident · 2 fatal · Class 1 · Major · Preliminary report · Mar 23, 2026 · C-GNJZ · Substantial damage
  > On March 22, 2026, at 2337 eastern daylight time, Jazz Aviation LP flight 646 (doing business as Air Canada flight 8646), an MHI (Mitsubishi Heavy Industries) RJ Aviation (formerly Bombardier) CL-600-2D24 (CRJ-900) airplane, registration C-GNJZ, was…
- [NTSB WPR26MA063](https://openairdocs.org/ntsb/WPR26MA063.md): Cessna 550 · Statesville, NC · Accident · 7 fatal · Class 2 · Major · Preliminary report · Dec 18, 2025 · N257BW · Substantial damage
  > On December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR25FA088](https://openairdocs.org/ntsb/WPR25FA088.md): Gates Learjet 35A · Scottsdale, AZ · Accident · 1 fatal · Class 2 · Field · Preliminary report · Feb 10, 2025 · N81VN · Substantial damage
  > On February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously…
- [NTSB DCA20MA002](https://openairdocs.org/ntsb/DCA20MA002.md): Saab 2000 · Unalaska, AK · Accident · 1 fatal · Class 1 · Major · Final report · Oct 18, 2019 · N686PA · Substantial damage
  > The landing gear manufacturer’s incorrect wiring of the wheel speed transducer harnesses on the left main landing gear during overhaul. The incorrect wiring caused the antiskid system not to function as intended, resulting in the failure of the left outboard…
- [NTSB ERA20MA001](https://openairdocs.org/ntsb/ERA20MA001.md): Boeing B17 · Windsor Locks, CT · Accident · 7 fatal · Class 2 · Major · Final report · Oct 2, 2019 · N93012 · Destroyed
  > The pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…
- [NTSB DCA19MA143](https://openairdocs.org/ntsb/DCA19MA143.md): Boeing 737 · Jacksonville, FL · Accident · Minor injuries · Class 2 · Major · Final report · May 4, 2019 · N732MA · Substantial damage
  > An extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…
- [NTSB DCA17MA022](https://openairdocs.org/ntsb/DCA17MA022.md): Mcdonnell Douglas MD 10-10F · Fort Lauderdale, FL · Accident · No injuries · Major investigation · Final report · Oct 28, 2016 · N370FE · Substantial damage
  > The failure of the left main landing gear (MLG) due to fatigue cracking that initiated at a corrosion pit. The pit formed in the absence of a required protective cadmium coating the cause of which could not be determined from available evidence. Contributing…
- [NTSB DCA15FA085](https://openairdocs.org/ntsb/DCA15FA085.md): Mcdonnell Douglas MD 88 · New York, NY · Accident · No injuries · Class 1 · Field · Final report · Mar 5, 2015 · N909DL · Substantial damage
  > the captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…
- [NTSB DCA11IA015](https://openairdocs.org/ntsb/DCA11IA015.md): Boeing 757-223 · Jackson Hole, WY · Incident · No injuries · Class 1 · Incident · Final report · Dec 29, 2010 · N668AA · No damage
  > a manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…
- [NTSB DCA08MA085](https://openairdocs.org/ntsb/DCA08MA085.md): Raytheon Corporate Jets BAE 125-800A · Owatonna, MN · Accident · 8 fatal · Class 1 · Major · Final report · Jul 31, 2008 · N818MV · Destroyed
  > The captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…
- [NTSB DCA07FA037](https://openairdocs.org/ntsb/DCA07FA037.md): Bombardier CL-600-2B19 · Traverse City, MI · Accident · No injuries · Class 1 · Field · Final report · Apr 12, 2007 · N8905F · Substantial damage
  > The pilots' decision to land at Cherry Capital Airport (TVC), Traverse City, Michigan, without performing a landing distance assessment, which was required by company policy because of runway contamination initially reported by TVC ground operations personnel…
- [NTSB DCA07MA072](https://openairdocs.org/ntsb/DCA07MA072.md): Embraer ERJ-170 · Cleveland, OH · Accident · No injuries · Class 1 · Major · Final report · Feb 18, 2007 · N862RW · Substantial damage
  > the failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…
- [NTSB SEA06MA047](https://openairdocs.org/ntsb/SEA06MA047.md): Cessna 560 · Carlsbad, CA · Accident · 4 fatal · Major investigation · Final report · Jan 24, 2006 · N86CE · Destroyed
  > The captain's delayed decision to execute a balked landing (go-around) during the landing roll. Factors contributing to the accident include the captain's improper decision to land with a tailwind, his excessive airspeed on final approach, and his failure to…
- [NTSB DCA06MA009](https://openairdocs.org/ntsb/DCA06MA009.md): Boeing 737-700 · Chicago, IL · Accident · 1 fatal · Class 1 · Major · Final report · Dec 9, 2005 · N471WN · Substantial damage
  > The pilots' failure to use available reverse thrust in a timely manner to safely slow or stop the airplane after landing, which resulted in a runway overrun. This failure occurred because the pilots' first experience and lack of familiarity with the…
- [NTSB DCA05MA099](https://openairdocs.org/ntsb/DCA05MA099.md): Airbus A321-231 · Fort Lauderdale, FL · Accident · No injuries · Major investigation · Final report · Sep 18, 2005 · N583NK · Substantial damage
  > Following a bounced landing, the pilot in command activated his sidestick controller while the first officer was in control of the airplane, which subsequently resulted in the overcontrol of pitch and a tailstrike. Contributing to the circumstances of this…
- [NTSB DCA05MA095](https://openairdocs.org/ntsb/DCA05MA095.md): Boeing 747-200 · Agana · Accident · Minor injuries · Major investigation · Final report · Aug 19, 2005 · N627US · Substantial damage
  > the flight crews' failure to verify that the number of landing gear annunciations on the second officer’s panel was consistent with the number specified in the abnormal/emergency procedures checklist, which led to a landing with the nose gear retracted.
- [NTSB DCA04MA082](https://openairdocs.org/ntsb/DCA04MA082.md): Boeing MD-11 · Memphis, TN · Accident · No injuries · Major investigation · Final report · Sep 19, 2004 · N601FE · Substantial damage
  > The pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.
- [NTSB DCA04MA049](https://openairdocs.org/ntsb/DCA04MA049.md): Raytheon Corporate Jets 390 Premier I · North Las Vegas, NV · Accident · No injuries · Major investigation · Final report · May 27, 2004 · N5010X · Substantial damage
  > The flight's unstabilized approach and excessive speed. Contributing to the excessive touchdown speed was the presence of a tailwind at landing.
- [NTSB DCA04MA045](https://openairdocs.org/ntsb/DCA04MA045.md): ATR 72 · San Juan, PR · Accident · Serious injuries · Class 1 · Major · Final report · May 9, 2004 · N438AT · Destroyed
  > the captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.
- [NTSB DCA04MA011](https://openairdocs.org/ntsb/DCA04MA011.md): McDonnell Douglas MD-10-10F · Memphis, TN · Accident · Minor injuries · Class 1 · Major · Final report · Dec 18, 2003 · N364FE · Destroyed
  > 1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…
- [NTSB NYC03MA183](https://openairdocs.org/ntsb/NYC03MA183.md): Beech 1900D · Yarmouth, MA · Accident · 2 fatal · Major investigation · Final report · Aug 26, 2003 · N240CJ · Destroyed
  > The improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…
- [NTSB ANC00MA125](https://openairdocs.org/ntsb/ANC00MA125.md): Piper PA-31T3 · Nuiqsut, AK · Accident · 5 fatal · Major investigation · Final report · Sep 18, 2000 · N220CS · Destroyed
  > The pilot's failure to extend the landing gear, his improper aborted landing procedure, and inadvertent stall/mush. Factors in the accident were an improper adjustment of the landing gear warning horn system by company maintenance personnel, and the failure…
- [NTSB DCA00MA030](https://openairdocs.org/ntsb/DCA00MA030.md): Boeing 737-300 · Burbank, CA · Accident · Serious injuries · Class 1 · Major · Final report · Mar 6, 2000 · N668SW · Destroyed
  > the flight crew's excessive airspeed and flightpath angle during the approach and landing and its failure to abort the approach when stabilized approach criteria were not met. Contributing to the accident was the controller's positioning of the airplane in…
- [NTSB DCA99MA060](https://openairdocs.org/ntsb/DCA99MA060.md): McDonnell Douglas MD-82 · Little Rock, AR · Accident · 11 fatal · Class 1 · Major · Final report · Jun 2, 1999 · N215AA · Destroyed
  > The flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…
- [NTSB DCA97MA055](https://openairdocs.org/ntsb/DCA97MA055.md): McDonnell Douglas MD-11 · Newark, NJ · Accident · Minor injuries · Class 1 · Major · Final report · Jul 31, 1997 · N611FE · Destroyed
  > The captain's overcontrol of the airplane during the landing and his failure to execute a go-around from a destabilized flare. Contributing to the accident was the captain's concern with touching down early to ensure adequate stopping distance.
- [NTSB DCA97MA053](https://openairdocs.org/ntsb/DCA97MA053.md): McDonnell Douglas MD-11 · Honolulu, HI · Accident · No injuries · Major investigation · Final report · Jun 21, 1997 · EICDK · Substantial damage
  > The pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…
- [NTSB DCA97MA009](https://openairdocs.org/ntsb/DCA97MA009.md): Beech 1900C · Quincy, IL · Accident · 14 fatal · Class 1 · Major · Final report · Nov 19, 1996 · N87GL · 2 aircraft · Destroyed
  > the failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…
- [NTSB FTW96FA118](https://openairdocs.org/ntsb/FTW96FA118.md): McDonnell Douglas DC-9-32 · Houston, TX · Accident · Minor injuries · Class 1 · Field · Final report · Feb 19, 1996 · N10556 · Substantial damage
  > the captain's decision to continue the approach contrary to Continental Airlines (COA) standard operating procedures that mandate a go-around when an approach is unstabilized below 500 feet or a ground proximity warning system alert continues below 200 feet…
- [NTSB CHI94MA290](https://openairdocs.org/ntsb/CHI94MA290.md): McDonnell Douglas MD-11F · Chicago, IL · Accident · No injuries · Major investigation · Final report · Aug 19, 1994 · IDUPO · Substantial damage
  > The first officer's improper flare and improper use of flight controls during the landing flare/touchdown.
- [NTSB DCA94MA053](https://openairdocs.org/ntsb/DCA94MA053.md): Piper PA31 · Stratford, CT · Accident · 8 fatal · Class 1 · Major · Final report · Apr 28, 1994 · N990RA · Destroyed
  > The failure of the captain to use the available ILS glideslope, his failure to execute a go-around when conditions were not suitable for landing, and his failure to land the airplane at a point sufficient to allow for a safe stopping distance; the fatalities…
- [NTSB DCA93MA040](https://openairdocs.org/ntsb/DCA93MA040.md): Douglas DC-10-30 · Dallas/Ft Worth, TX · Accident · Serious injuries · Class 1 · Major · Final report · Apr 14, 1993 · N139AA · Substantial damage
  > The national transportation safety board determines that the probable cause of the accident was the failure of the captain to use proper directional control techniques to maintain the airplane on the runway.
- [NTSB CHI93MA061](https://openairdocs.org/ntsb/CHI93MA061.md): Saab-Scania 340A · Hibbing, MN · Accident · No injuries · Major investigation · Final report · Jan 3, 1993 · N342PX · Substantial damage
  > The first officer's failure to maintain a proper descent rate during the landing, and the captain's inadequate supervision by not taking timely action to ensure a safe landing. Factors which contributed to the accident were: the company's failure to provide…
- [NTSB DCA91MA018](https://openairdocs.org/ntsb/DCA91MA018.md): Boeing 737-300 · Los Angeles, CA · Accident · 34 fatal · Class 1 · Major · Final report · Feb 2, 1991 · N388US · 2 aircraft · Destroyed
  > The failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…
- [NTSB DCA90MA017](https://openairdocs.org/ntsb/DCA90MA017.md): Beech A100 · Atlanta, GA · Accident · 1 fatal · Class 1 · Major · Final report · Jan 19, 1990 · N44UE · 2 aircraft · Destroyed
  > (1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…
- [NTSB DCA89MA076](https://openairdocs.org/ntsb/DCA89MA076.md): de Havilland DHC-6-300 · Grand Canyon, AZ · Accident · 10 fatal · Class 1 · Major · Final report · Sep 27, 1989 · N75GC · Destroyed
  > Improper pilot techniques and crew coordination during the landing attempt, bounce, and attempted go-around.
- [NTSB CHI89MA047](https://openairdocs.org/ntsb/CHI89MA047.md): Dassault-Breguet Falcon 900 · South Bend, IN · Accident · No injuries · Major investigation · Final report · Jan 20, 1989 · N901B · Substantial damage
  > Failure of the thrust reverser actuator links due to a manufacturing/design problem. Factors related to the accident were: the adverse runway conditions and the crosswind.
- [NTSB DEN88MA203](https://openairdocs.org/ntsb/DEN88MA203.md): Mcdonnell Douglas DC-10-10 · Denver, CO · Accident · Minor injuries · Major investigation · Final report · Sep 12, 1988 · N1830U · Substantial damage
  > As the capt was deploying reversers drg lndg, #2 & #3 reversers unlocked & deployed (green lgt cond), but #1 reverser was binding & only moved to the unlocked psn (amber lgt cond). Capt was not warned of this cond, though 2nd officer should have monitored…
- [NTSB NYC87MA236](https://openairdocs.org/ntsb/NYC87MA236.md): Mcdonnell Douglas DC-8-63 · Newburgh, NY · Accident · No injuries · Major investigation · Final report · Aug 20, 1987 · N951R · 2 aircraft · Substantial damage
  > The wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…
- [NTSB DCA87MA012](https://openairdocs.org/ntsb/DCA87MA012.md): Lockheed L1011 · Newark, NJ · Accident · No injuries · Major investigation · Final report · Nov 13, 1986 · N714DA · Substantial damage
  > On November 13, 1986, the rear main spar of the right wing failed as delta flt 194 touched down on rwy 29 at Newark airport. The pilots stated that there was moderate turbulence on final approach and initial touchdown was on the right main gear first. The…
- [NTSB DCA87AA006](https://openairdocs.org/ntsb/DCA87AA006.md): Boeing 737-222 · Charlotte, NC · Accident · Serious injuries · Final report · Oct 26, 1986 · N752N · Destroyed
  > Drg arr, piedmont flt 467 was vectored for an ILS rwy 36R apch. At 2001 CDT (aprx 7 min bfr lndg), all arrg flts were adzd the wx was (in part): 400' ovc, vis 2 mi with lgt rain & fog, wnd fm 090 at 8 KTS. Rwy 5/32 was out-of-svc at that time. Flt 467 was…
- [NTSB CHI86MA056](https://openairdocs.org/ntsb/CHI86MA056.md): Mcdonnell Douglas DC-10-10 · Detroit, MI · Incident · No injuries · Major investigation · Final report · Jan 3, 1986 · N101AA · No damage
  > N101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step…
- [NTSB FTW86MA018](https://openairdocs.org/ntsb/FTW86MA018.md): Bell 222UT · East Cameron · Accident · 2 fatal · Major investigation · Final report · Oct 24, 1985 · N3194M · Destroyed
  > Three pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a…
- [NTSB DCA84AA018](https://openairdocs.org/ntsb/DCA84AA018.md): Mcdonnell Douglas DC-10-30 · Jamaica, NY · Accident · Serious injuries · Final report · Feb 28, 1984 · LNRKB · Substantial damage
  > During an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…
- [NTSB ANC84MA037](https://openairdocs.org/ntsb/ANC84MA037.md): Embraer EM-110P1 · Cordova, AK · Accident · No injuries · Major investigation · Final report · Feb 22, 1984 · N103VA · Substantial damage
  > During a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…
- [NTSB DCA84AA005](https://openairdocs.org/ntsb/DCA84AA005.md): Douglas DC-8-63F · Norfolk, VA · Accident · No injuries · Final report · Oct 25, 1983 · N797FT · Destroyed
  > During arrival at nas Norfolk, the aircrew were vectored for a gca apch to rwy 10. They were advised that the wx was 200 ft scattered, 600 ft overcast, visibility 1 mi with rain, wind was from 360 deg at 20 KTS. Also, they were given a PIREP of 'heavy…
- [NTSB DCA83AA023](https://openairdocs.org/ntsb/DCA83AA023.md): Gates Learjet 25 · Newark, NJ · Accident · 2 fatal · Final report · Mar 30, 1983 · N51CA · Destroyed
  > The acft was on a ngt check courier flt. During arrival, the indicated airspeed was well above the legal limit of 250 ktfor flt below 10,000 ft. rwy 4R was selected for landing after the crew were advised that their original choice (rwy 11)was noise…
- [NTSB DCA83AA013](https://openairdocs.org/ntsb/DCA83AA013.md): Convair 580-11-A · Brainerd, MN · Accident · 1 fatal · Final report · Jan 10, 1983 · N8444H · Substantial damage
  > During arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…
- [NTSB DCA81AA013](https://openairdocs.org/ntsb/DCA81AA013.md): Boeing 727 · Jamaica, NY · Incident · No injuries · Closed · Apr 8, 1981 · N8140N · Minor damage
- [NTSB DCA80AA017](https://openairdocs.org/ntsb/DCA80AA017.md): Lear Jet 23 · Richmond, VA · Accident · 2 fatal · Closed · May 6, 1980 · N866JS · Destroyed

Next page: https://openairdocs.org/ntsb-phases/550/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 = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/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.