# Major NTSB investigations: Approach

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 4 · 164 cases

## Latest cases

- [NTSB DCA25MA108](https://openairdocs.org/ntsb/DCA25MA108.md): Bombardier CL-600-2C10 · Washington, DC · Accident · 67 fatal · Class 1 · Major · Final report · Jan 30, 2025 · N709PS · 2 aircraft · Destroyed
  > The Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…
- [NTSB CEN19MA312](https://openairdocs.org/ntsb/CEN19MA312.md): Convair 440 · Monclova, OH · Accident · 2 fatal · Class 3 · Major · Final report · Sep 11, 2019 · N24DR · Destroyed
  > The flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.
- [NTSB WPR18MA087](https://openairdocs.org/ntsb/WPR18MA087.md): Eurocopter EC130 · Peach Springs, AZ · Accident · 5 fatal · Class 3 · Major · Final report · Feb 11, 2018 · N155GC · Destroyed
  > A loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.
- [NTSB DCA17IA148](https://openairdocs.org/ntsb/DCA17IA148.md): Airbus A320-211 · San Francisco, CA · Incident · No injuries · Class 1 · Incident · Final report · Jul 8, 2017 · C-FKCK · No damage
  > The flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…
- [NTSB CEN17MA183](https://openairdocs.org/ntsb/CEN17MA183.md): Learjet 35A · Teterboro, NJ · Accident · 2 fatal · Class 1 · Major · Final report · May 15, 2017 · N452DA · Destroyed
  > The pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…
- [NTSB DCA16MA204](https://openairdocs.org/ntsb/DCA16MA204.md): Kubicek BB85 · Lockhart, TX · Accident · 16 fatal · Class 1 · Major · Final report · Jul 30, 2016 · N2469L · Destroyed
  > The pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…
- [NTSB CEN16MA036](https://openairdocs.org/ntsb/CEN16MA036.md): British Aerospace HS 125 700A · Akron, OH · Accident · 9 fatal · Class 1 · Major · Final report · Nov 10, 2015 · N237WR · Destroyed
  > The flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…
- [NTSB WPR15MA243](https://openairdocs.org/ntsb/WPR15MA243.md): Cessna 172M · San Diego, CA · Accident · 5 fatal · Major investigation · Final report · Aug 16, 2015 · N1285U · 2 aircraft · Destroyed
  > The local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…
- [NTSB DCA15MA029](https://openairdocs.org/ntsb/DCA15MA029.md): Embraer EMB-500 · Gaithersburg, MD · Accident · 6 fatal · Class 1 · Major · Final report · Dec 8, 2014 · N100EQ · Destroyed
  > the pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…
- [NTSB ANC14MA008](https://openairdocs.org/ntsb/ANC14MA008.md): Cessna 208B · Saint Marys, AK · Accident · 5 fatal · Major investigation · Final report · Nov 30, 2013 · N12373 · Substantial damage
  > The pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…
- [NTSB DCA13MA133](https://openairdocs.org/ntsb/DCA13MA133.md): Airbus A300 - F4 622R · Birmingham, AL · Accident · 2 fatal · Class 1 · Major · Final report · Aug 14, 2013 · N155UP · Destroyed
  > the flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…
- [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed
  > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…
- [NTSB ERA13MA139](https://openairdocs.org/ntsb/ERA13MA139.md): Beech 390 · Thomson, GA · Accident · 5 fatal · Major investigation · Final report · Feb 21, 2013 · N777VG · Destroyed
  > The pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…
- [NTSB DCA12FA051](https://openairdocs.org/ntsb/DCA12FA051.md): Convair 440 - NO Series · San Juan, PR · Accident · 2 fatal · Class 1 · Field · Final report · Mar 15, 2012 · N153JR · Destroyed
  > the flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.
- [NTSB CEN10MA088](https://openairdocs.org/ntsb/CEN10MA088.md): Gates Learjet 35A · Prospect Heights, IL · Accident · 2 fatal · Major investigation · Final report · Jan 5, 2010 · N720RA · Substantial damage
  > A loss of control for undetermined reasons.
- [NTSB DCA09MA027](https://openairdocs.org/ntsb/DCA09MA027.md): Bombardier DHC-8-402 · Clarence Center, NY · Accident · 50 fatal · Class 1 · Major · Final report · Feb 13, 2009 · N200WQ · Destroyed
  > The captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…
- [NTSB CEN09MA142](https://openairdocs.org/ntsb/CEN09MA142.md): Aerospatiale Alenia ATR 42-320 · Lubbock, TX · Accident · Serious injuries · Class 1 · Major · Final report · Jan 27, 2009 · N902FX · Substantial damage
  > The flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…
- [NTSB MIA08MA203](https://openairdocs.org/ntsb/MIA08MA203.md): Aerospatiale SA365N-1 D · District Heights, MD · Accident · 4 fatal · Class 1 · Major · Final report · Sep 28, 2008 · N92MD · Substantial damage
  > The pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…
- [NTSB DEN08MA116](https://openairdocs.org/ntsb/DEN08MA116.md): Bell 407 · Flagstaff, AZ · Accident · 7 fatal · Major investigation · Final report · Jun 29, 2008 · N407GA · 2 aircraft · Destroyed
  > Both helicopter pilots’ failure to see and avoid the other helicopter on approach to the helipad. Contributing to the accident were the failure of N407GA’s pilot to follow flight arrival route guidelines, and the failure of N407MJ’s pilot to follow…
- [NTSB SEA08MA136](https://openairdocs.org/ntsb/SEA08MA136.md): Aerospatiale AS-350-D · Avalon, CA · Accident · 3 fatal · Major investigation · Final report · May 24, 2008 · N67GE · Destroyed
  > Loss of engine power during approach for landing due to a fatigue fracture of a power turbine blade.
- [NTSB NYC08MA090](https://openairdocs.org/ntsb/NYC08MA090.md): Raytheon C90A · Mount Airy, NC · Accident · 6 fatal · Major investigation · Final report · Feb 1, 2008 · N57WR · Substantial damage
  > The pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…
- [NTSB NYC06MA192](https://openairdocs.org/ntsb/NYC06MA192.md): Embraer 110P1 · Pownal, VT · Accident · 1 fatal · Major investigation · Final report · Aug 4, 2006 · N59BA · Destroyed
  > The pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…
- [NTSB NYC06MA131](https://openairdocs.org/ntsb/NYC06MA131.md): Eurocopter EC-135P1 · Washington, DC · Accident · 1 fatal · Major investigation · Final report · May 30, 2006 · N601FH · Destroyed
  > The operator's inadequate training program and the pilot's failure to maintain control of the helicopter following his inadvertent disabling of the No. 1 and then the No. 2 engine full authority digital engine control system.
- [NTSB NYC06MA005](https://openairdocs.org/ntsb/NYC06MA005.md): Augusta 109E · Smethport, PA · Accident · 1 fatal · Major investigation · Final report · Oct 8, 2005 · N7YL · Destroyed
  > The pilot's failure to maintain aircraft control. Factors in the accident were, night instrument meteorological conditions, pilot workload, and improper air traffic control procedures by the approach controller.
- [NTSB DCA05MA037](https://openairdocs.org/ntsb/DCA05MA037.md): Cessna 560 · Pueblo, CO · Accident · 8 fatal · Class 1 · Major · Final report · Feb 16, 2005 · N500AT · Destroyed
  > the flight crew's failure to effectively monitor and maintain airspeed and comply with procedures for deice boot activation on the approach, which caused an aerodynamic stall from which they did not recover. Contributing to the accident was the Federal…
- [NTSB DCA05MA011](https://openairdocs.org/ntsb/DCA05MA011.md): Gulfstream Aerospace G-III · Houston, TX · Accident · 3 fatal · Class 1 · Major · Final report · Nov 22, 2004 · N85VT · Destroyed
  > the flight crew's failure to adequately monitor and cross check the flight instruments during the approach. Contributing to the accident was the flight crew's failure to select the instrument landing system frequency in a timely manner and to adhere to…
- [NTSB IAD05MA006](https://openairdocs.org/ntsb/IAD05MA006.md): Beech 200 · Stuart, VA · Accident · 10 fatal · Class 1 · Major · Final report · Oct 24, 2004 · N501RH · Destroyed
  > The flight crew's failure to properly execute the published instrument approach procedure, including the published missed approach procedure, which resulted in controlled flight into terrain. Contributing to the cause of the accident was the flight crew's…
- [NTSB DCA05MA004](https://openairdocs.org/ntsb/DCA05MA004.md): British Aerospace Jetstream 32 · Kirksville, MO · Accident · 13 fatal · Class 1 · Major · Final report · Oct 20, 2004 · N875JX · Destroyed
  > the pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…
- [NTSB DCA04MA068](https://openairdocs.org/ntsb/DCA04MA068.md): Convair Div. of Gen. Dynamics CV-340 (580) · Florence, KY · Accident · 1 fatal · Class 1 · Major · Final report · Aug 13, 2004 · N586P · Destroyed
  > fuel starvation resulting from the captain's decision not to follow approved fuel crossfeed procedures. Contributing to the accident were the captain's inadequate preflight planning, his subsequent distraction during the flight, and his lateinitiation of the…
- [NTSB DEN04MA015](https://openairdocs.org/ntsb/DEN04MA015.md): Cessna 208B · Cody, WY · Accident · 1 fatal · Major investigation · Final report · Oct 29, 2003 · N791FE · Substantial damage
  > the pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.
- [NTSB FTW03MA160](https://openairdocs.org/ntsb/FTW03MA160.md): Boeing 737-300 · Amarillo, TX · Accident · No injuries · Major investigation · Final report · May 25, 2003 · N343SW · Substantial damage
  > the flight crew's failure to align the airplane's ground track with the runway centerline before touchdown and the flight crew's failure to maintain directional control of the airplane after touchdown. Contributing to the accident was the flight crew's…
- [NTSB DCA03MA008](https://openairdocs.org/ntsb/DCA03MA008.md): Beech King Air 100 · Eveleth, MN · Accident · 8 fatal · Class 1 · Major · Final report · Oct 25, 2002 · N41BE · Destroyed
  > The flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.
- [NTSB DCA02MA054](https://openairdocs.org/ntsb/DCA02MA054.md): Boeing 727-232 · Tallahassee, FL · Accident · Serious injuries · Class 1 · Major · Final report · Jul 26, 2002 · N497FE · Destroyed
  > The captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…
- [NTSB DCA02MA042](https://openairdocs.org/ntsb/DCA02MA042.md): McDonnell Douglas MD-11F · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 2, 2002 · N601FE · Substantial damage
  > The failure of the lower outboard nut and bolt assembly of the left inboard flap's outboard hinge that resulted from stress corrosion cracking and fatigue. Factors contributing to the accident were the inadequate materials specification of the bolt, and…
- [NTSB DCA01MA034](https://openairdocs.org/ntsb/DCA01MA034.md): Grumman Gulfstream III · Aspen, CO · Accident · 18 fatal · Class 1 · Major · Final report · Mar 30, 2001 · N303GA · Destroyed
  > the flight crew's operation of the airplane below the minimum descent altitude without an appropriate visual reference for the runway. Contributing to the cause of the accident were the Federal Aviation Administration's (FAA) unclear wording of the March 27,…
- [NTSB DCA00MA052](https://openairdocs.org/ntsb/DCA00MA052.md): British Aerospace J-3101 · Bear Creek Town, PA · Accident · 19 fatal · Class 1 · Major · Final report · May 21, 2000 · N16EJ · Destroyed
  > The flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…
- [NTSB CHI00MA066](https://openairdocs.org/ntsb/CHI00MA066.md): Moravan Z242L · Zion, IL · Accident · 3 fatal · Major investigation · Final report · Feb 8, 2000 · N5ZA · 2 aircraft · Destroyed
  > Clearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.
- [NTSB DCA98MA023](https://openairdocs.org/ntsb/DCA98MA023.md): Boeing 727-223 · Chicago, IL · Accident · Minor injuries · Class 1 · Major · Final report · Feb 9, 1998 · N845AA · Substantial damage
  > the failure of the flight crew to maintain a proper pitch attitude for a successful landing or go-around. Contributing to the accident were the divergent pitch oscillations of the airplane, which occurred during the final approach and were the result of an…
- [NTSB FTW98MA096](https://openairdocs.org/ntsb/FTW98MA096.md): Gates Learjet 25B · Houston, TX · Accident · 2 fatal · Major investigation · Final report · Jan 13, 1998 · N627WS · Destroyed
  > The flight crew's continued descent of the airplane below the glideslope and through the published decision height without visual contact with the runway environment. Also, when the captain encountered difficulty tracking the localizer course, his improper…
- [NTSB DCA97MA058](https://openairdocs.org/ntsb/DCA97MA058.md): Boeing 747-300 · Nimitz Hill · Accident · 228 fatal · Class 1 · Major · Final report · Aug 6, 1997 · H7468 · Destroyed
  > the captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…
- [NTSB DCA97MA017](https://openairdocs.org/ntsb/DCA97MA017.md): Embraer EMB-120RT · Monroe, MI · Accident · 29 fatal · Class 1 · Major · Final report · Jan 9, 1997 · N265CA · Destroyed
  > The Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…
- [NTSB NYC97MA005](https://openairdocs.org/ntsb/NYC97MA005.md): McDonnell Douglas MD-88 · Flushing, NY · Accident · Minor injuries · Class 1 · Major · Final report · Oct 19, 1996 · N914DL · Substantial damage
  > The Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…
- [NTSB DCA96MA008](https://openairdocs.org/ntsb/DCA96MA008.md): McDonnell Douglas MD-83 · East Granby, CT · Accident · Minor injuries · Class 1 · Major · Final report · Nov 12, 1995 · N566AA · Substantial damage
  > the flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…
- [NTSB DCA95MA006](https://openairdocs.org/ntsb/DCA95MA006.md): British Aerospace Jetstream 3201 · Morrisville, NC · Accident · 15 fatal · Major investigation · Final report · Dec 13, 1994 · N918AE · Destroyed
  > 1) the captain's improper assumption that an engine had failed, and 2) the captain's subsequent failure to follow approved procedures for engine failure, single-engine approach and go-around, and stall recovery. Contributing to the cause of the accident was…
- [NTSB DCA94MA076](https://openairdocs.org/ntsb/DCA94MA076.md): Boeing B-737-300 · Aliquippa, PA · Accident · 132 fatal · Class 1 · Major · Final report · Sep 8, 1994 · N513AU · Destroyed
  > A loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…
- [NTSB DCA94MA065](https://openairdocs.org/ntsb/DCA94MA065.md): Douglas DC-9-31 · Charlotte, NC · Accident · 37 fatal · Class 1 · Major · Final report · Jul 2, 1994 · N954VJ · Destroyed
  > 1) The flightcrew's decision to continue an approach into severe convective activity that was conducive to a microburst; 2) the flightcrew's failure to recognize a windshear situation in a timely manner; 3)the flightcrew's failure to establish and maintain…
- [NTSB DCA94MA061](https://openairdocs.org/ntsb/DCA94MA061.md): Learjet 25D · Chantilly, VA · Accident · 12 fatal · Class 1 · Major · Final report · Jun 18, 1994 · XABBA · Destroyed
  > The poor decisionmaking, poor airmanship, and relative inexperience of the captain in initiating and continuing an unstabilized instrument approach that led to a descent below the authorized altitude without visual contact with the runway environment.…
- [NTSB DCA94MA027](https://openairdocs.org/ntsb/DCA94MA027.md): Jetstream 4101 · Columbus, OH · Accident · 5 fatal · Class 1 · Major · Final report · Jan 8, 1994 · N304UE · Destroyed
  > (1) An aerodynamic stall that occurred when the flightcrew allowed the airspeed to decay to stall speed following a very poorly planned and executed approach characterized by an absence of procedural discipline; (2) Improper pilot response to the stall…
- [NTSB DCA94MA022](https://openairdocs.org/ntsb/DCA94MA022.md): Jetstream BA-3100 · Hibbing, MN · Accident · 18 fatal · Class 1 · Major · Final report · Dec 2, 1993 · N334PX · Destroyed
  > The captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…
- [NTSB CHI94MA032](https://openairdocs.org/ntsb/CHI94MA032.md): Cessna 421B · Greensburg, IN · Accident · 5 fatal · Major investigation · Final report · Nov 6, 1993 · N41010 · Destroyed
  > an inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.

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

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