# Major NTSB investigations: Enroute

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 5 · 226 cases

## Latest cases

- [NTSB WPR25MA128](https://openairdocs.org/ntsb/WPR25MA128.md): Mitsubishi MU-2B-40 · Copake, NY · Accident · 6 fatal · Class 3 · Major · Preliminary report · Apr 12, 2025 · N635TA · Destroyed
  > On April 12, 2025, about 1203 eastern daylight time, a Mitsubishi MU-2B-40, N635TA, was destroyed when it was involved in an accident near Copake, New York. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25MA171](https://openairdocs.org/ntsb/ERA25MA171.md): Bell 206L-4 · Jersey City, NJ · Accident · 6 fatal · Class 2 · Major · Preliminary report · Apr 10, 2025 · N216MH · Destroyed
  > On April 10, 2025, about 1515 eastern daylight time, a Bell 206L-4 helicopter, N216MH, was destroyed when it was involved in an accident near Jersey City, New Jersey. The pilot and five passengers were fatally injured. The helicopter was operated as a Title…
- [NTSB CEN25MA115](https://openairdocs.org/ntsb/CEN25MA115.md): Eurocopter Deutschland EC 135 P2+ · Canton, MS · Accident · 3 fatal · Class 2 · Major · Preliminary report · Mar 10, 2025 · N835CS · Destroyed
  > On March 10, 2025, about 1237 central daylight time, an Airbus Helicopters (formerly Eurocopter Deutschland) EC135 P2+ helicopter, N835CS, operated as AirCare 3, was destroyed when it was involved in an accident near Canton, Mississippi. The commercial pilot,…
- [NTSB ANC25MA018](https://openairdocs.org/ntsb/ANC25MA018.md): Textron 208B · Nome, AK · Accident · 10 fatal · Class 1 · Major · Final report · Feb 6, 2025 · N321BA · Destroyed
  > The National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…
- [NTSB CEN24MA111](https://openairdocs.org/ntsb/CEN24MA111.md): Airbus Helicopters EC 130 · Halloran Springs, CA · Accident · 6 fatal · Class 2 · Major · Final report · Feb 10, 2024 · N130CZ · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the company’s inadequate oversight of its…
- [NTSB DCA24MA063](https://openairdocs.org/ntsb/DCA24MA063.md): Boeing 737-9 · Portland, OR · Accident · Minor injuries · Class 1 · Major · Final report · Jan 6, 2024 · N704AL · Substantial damage
  > the in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…
- [NTSB WPR23MA113](https://openairdocs.org/ntsb/WPR23MA113.md): Pilatus PC-12/45 · Stagecoach, NV · Accident · 5 fatal · Class 2 · Major · Final report · Feb 25, 2023 · N273SM · Substantial damage
  > The pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…
- [NTSB DCA22MA193](https://openairdocs.org/ntsb/DCA22MA193.md): Dehavilland DHC-3 · Freeland, WA · Accident · 10 fatal · Class 1 · Major · Final report · Sep 4, 2022 · N725TH · Destroyed
  > The in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…
- [NTSB DCA20MA059](https://openairdocs.org/ntsb/DCA20MA059.md): Sikorsky S76 · Calabasas, CA · Accident · 9 fatal · Class 1 · Major · Final report · Jan 26, 2020 · N72EX · Destroyed
  > The pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…
- [NTSB ANC20MA010](https://openairdocs.org/ntsb/ANC20MA010.md): Airbus AS350B2 · Kekaha, HI · Accident · 7 fatal · Class 1 · Major · Final report · Dec 27, 2019 · N985SA · Destroyed
  > The pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…
- [NTSB DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB CEN19FA072](https://openairdocs.org/ntsb/CEN19FA072.md): Bell 407 · Zaleski, OH · Accident · 3 fatal · Class 1 · Field · Final report · Jan 29, 2019 · N191SF · Destroyed
  > The NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…
- [NTSB DCA18MA142](https://openairdocs.org/ntsb/DCA18MA142.md): Boeing 737 7H4 · Philadelphia, PA · Accident · 1 fatal · Class 1 · Major · Final report · Apr 17, 2018 · N772SW · Substantial damage
  > A low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…
- [NTSB ERA17MA316](https://openairdocs.org/ntsb/ERA17MA316.md): Eurocopter Deutschland MBB BK 117 · Hertford, NC · Accident · 4 fatal · Class 2 · Major · Final report · Sep 8, 2017 · N146DU · Destroyed
  > A failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…
- [NTSB ANC17MA001](https://openairdocs.org/ntsb/ANC17MA001.md): Cessna 208B · Togiak, AK · Accident · 3 fatal · Class 1 · Major · Final report · Oct 2, 2016 · N208SD · Destroyed
  > The flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…
- [NTSB ERA15MA259](https://openairdocs.org/ntsb/ERA15MA259.md): Cessna 150M · Moncks Corner, SC · Accident · 2 fatal · Class 2 · Major · Final report · Jul 7, 2015 · N3601V · 2 aircraft · Destroyed
  > The approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…
- [NTSB ANC15MA041](https://openairdocs.org/ntsb/ANC15MA041.md): Dehavilland DHC-3 · Ketchikan, AK · Accident · 9 fatal · Class 1 · Major · Final report · Jun 25, 2015 · N270PA · Substantial damage
  > (1) the pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in his geographic disorientation and controlled flight into terrain; and (2) Promech's company culture, which tacitly endorsed flying in…
- [NTSB ERA14MA060](https://openairdocs.org/ntsb/ERA14MA060.md): Fairchild SA227-AC · La Alianza, PR · Accident · 2 fatal · Major investigation · Final report · Dec 3, 2013 · N831BC · Destroyed
  > The flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…
- [NTSB DCA12MA020](https://openairdocs.org/ntsb/DCA12MA020.md): Eurocopter France AS350B2 · Las Vegas, NV · Accident · 5 fatal · Class 1 · Major · Final report · Dec 8, 2011 · N37SH · Destroyed
  > Sundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…
- [NTSB WPR12MA046](https://openairdocs.org/ntsb/WPR12MA046.md): Rockwell 690 · Apache Junction, AZ · Accident · 6 fatal · Major investigation · Final report · Nov 24, 2011 · N690SM · Destroyed
  > The pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…
- [NTSB CEN11FA599](https://openairdocs.org/ntsb/CEN11FA599.md): Eurocopter AS-350-B2 · Mosby, MO · Accident · 4 fatal · Class 1 · Field · Final report · Aug 26, 2011 · N352LN · Substantial damage
  > The pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…
- [NTSB DCA11MA039](https://openairdocs.org/ntsb/DCA11MA039.md): Boeing 737 · Yuma, AZ · Accident · Minor injuries · Major investigation · Final report · Apr 1, 2011 · N632SW · Substantial damage
  > the improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…
- [NTSB ANC10MA068](https://openairdocs.org/ntsb/ANC10MA068.md): Dehavilland DHC-3 · Aleknagik, AK · Accident · 5 fatal · Class 1 · Major · Final report · Aug 9, 2010 · N455A · Substantial damage
  > The pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…
- [NTSB ERA10MA188](https://openairdocs.org/ntsb/ERA10MA188.md): Eurocopter AS-350-B3 · Brownsville, TN · Accident · 3 fatal · Major investigation · Final report · Mar 25, 2010 · N855HW · Substantial damage
  > The pilot's decision to attempt the flight into approaching adverse weather, resulting in an encounter with a thunderstorm with localized instrument meteorological conditions, heavy rain, and severe turbulence that led to a loss of control.
- [NTSB ERA09MA447](https://openairdocs.org/ntsb/ERA09MA447.md): Piper PA-32R-300 · Hoboken, NJ · Accident · 9 fatal · Class 1 · Major · Final report · Aug 8, 2009 · N71MC · 2 aircraft · Substantial damage
  > (1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…
- [NTSB ERA09MA157](https://openairdocs.org/ntsb/ERA09MA157.md): Cessna 206H · Quebradillas, PR · Accident · 6 fatal · Major investigation · Final report · Feb 8, 2009 · N118ME · Destroyed
  > The pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.
- [NTSB CEN09MA117](https://openairdocs.org/ntsb/CEN09MA117.md): Sikorsky S-76C · Morgan City, LA · Accident · 8 fatal · Major investigation · Final report · Jan 4, 2009 · N748P · Destroyed
  > (1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…
- [NTSB CEN09MA019](https://openairdocs.org/ntsb/CEN09MA019.md): Bell 222 · Aurora, IL · Accident · 4 fatal · Major investigation · Final report · Oct 16, 2008 · N992AA · Destroyed
  > The pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…
- [NTSB MIA08MA051](https://openairdocs.org/ntsb/MIA08MA051.md): Cessna 525 · West Gardiner, ME · Accident · 2 fatal · Major investigation · Final report · Feb 1, 2008 · N102PT · Destroyed
  > The pilot's spatial disorientation and subsequent failure to maintain airplane control.
- [NTSB DCA07MA310](https://openairdocs.org/ntsb/DCA07MA310.md): Mcdonnell Douglas DC-9-82 (MD-82) · St. Louis, MO · Accident · No injuries · Class 1 · Major · Final report · Sep 28, 2007 · N454AA · Substantial damage
  > American Airlines’ maintenance personnel’s use of an inappropriate manual engine start procedure, which led to the uncommanded opening of the left engine air turbine starter valve, and a subsequent left engine fire, which was prolonged by the flight crew’s…
- [NTSB NYC07MA162](https://openairdocs.org/ntsb/NYC07MA162.md): Cessna 310R · Sanford, FL · Accident · 5 fatal · Class 1 · Major · Final report · Jul 10, 2007 · N501N · Destroyed
  > Actions and decisions by National Association for Stock Car Auto Racing's corporate aviation division's management and maintenance personnel to allow the accident airplane to be released for flight with a known and unresolved discrepancy, and the accident…
- [NTSB CHI07MA160](https://openairdocs.org/ntsb/CHI07MA160.md): Cessna 550 · Milwaukee, WI · Accident · 6 fatal · Class 1 · Major · Final report · Jun 4, 2007 · N550BP · Destroyed
  > The National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…
- [NTSB CHI07MA083](https://openairdocs.org/ntsb/CHI07MA083.md): McDonnell Douglas 369FF · Haena, HI · Accident · 1 fatal · Major investigation · Final report · Mar 11, 2007 · N911VC · Substantial damage
  > The fatigue failure of the tail rotor blade root fitting due to a manufacturing defect which resulted in the separation of the tail rotor system and loss of tail rotor control. A contributing factor to the accident were the trees that the helicopter struck…
- [NTSB DEN06MA119](https://openairdocs.org/ntsb/DEN06MA119.md): Mitsubishi MU-2B-35 · Argyle, FL · Accident · 1 fatal · Major investigation · Final report · Sep 1, 2006 · N6569L · Destroyed
  > the pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…
- [NTSB NYC06MA208](https://openairdocs.org/ntsb/NYC06MA208.md): Mitsubishi MU-2B-40 · Bunnell, FL · Accident · 2 fatal · Major investigation · Final report · Aug 25, 2006 · N171MA · Destroyed
  > The pilot's inadvertent encounter with thunderstorms.
- [NTSB CHI06MA121](https://openairdocs.org/ntsb/CHI06MA121.md): General Atomics Predator B · Nogales, AZ · Accident · No injuries · Major investigation · Final report · Apr 25, 2006 · UNREG · Substantial damage
  > The pilot's failure to use checklist procedures when switching operational control from PPO-1 to PPO-2, which resulted in the fuel valve inadvertently being shut off and the subsequent total loss of engine power, and lack of a flight instructor in the GCS, as…
- [NTSB CHI06MA115](https://openairdocs.org/ntsb/CHI06MA115.md): Cessna 210A · Ludville, GA · Accident · 1 fatal · Major investigation · Final report · Apr 19, 2006 · N6579X · Destroyed
  > The pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…
- [NTSB DCA06MA022](https://openairdocs.org/ntsb/DCA06MA022.md): Douglas DC-8 · Philadelphia, PA · Accident · Minor injuries · Class 1 · Major · Final report · Feb 8, 2006 · N748UP · Destroyed
  > an in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…
- [NTSB DCA06MA010](https://openairdocs.org/ntsb/DCA06MA010.md): Grumman G-73T · Miami, FL · Accident · 20 fatal · Class 1 · Major · Final report · Dec 19, 2005 · N2969 · Destroyed
  > The in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…
- [NTSB DFW05MA230](https://openairdocs.org/ntsb/DFW05MA230.md): Sikorsky S76 · Gulf of Mexico, TX · Accident · Serious injuries · Major investigation · Final report · Sep 6, 2005 · N90421 · Destroyed
  > The pilots' delayed response to the No. 1 engine fire warning and the loss of power to both engines, which occurred for undetermined reasons. The pilots' delayed response was most likely due to stress and fatigue. Contributing to the delay of the initiation…
- [NTSB DCA05MA083](https://openairdocs.org/ntsb/DCA05MA083.md): Boeing 767-232 · Raleigh-Durham, NC · Accident · Serious injuries · Major investigation · Final report · Jul 11, 2005 · N113DA · No damage
  > An inadvertent in-flight encounter with clear air turbulence.
- [NTSB NYC05MA083](https://openairdocs.org/ntsb/NYC05MA083.md): Boeing 717-200 · Union Star, MO · Incident · No injuries · Major investigation · Final report · May 13, 2005 · N910ME · No damage
  > A loss of reliable airspeed indication due to an accumulation of ice on the air data/pitot sensors. Contributing to the incident was the flight crew's improper response to the erroneous airspeed indications, their lack of coordination during the initial…
- [NTSB CHI05MA111](https://openairdocs.org/ntsb/CHI05MA111.md): McDonnell Douglas DC-9-51 · Minneapolis, MN · Accident · Serious injuries · Major investigation · Final report · May 11, 2005 · N763NC · 2 aircraft · Substantial damage
  > the Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…
- [NTSB NYC05MA039](https://openairdocs.org/ntsb/NYC05MA039.md): Eurocopter Deutschland EC 135 P2 · Oxon Hill, MD · Accident · 2 fatal · Major investigation · Final report · Jan 11, 2005 · N136LN · Destroyed
  > The pilot's failure to identify and arrest the helicopter's descent, which resulted in controlled flight into terrain. Contributing to the accident were the dark night conditions, limited outside visual references, and the lack of an operable radar altimeter…
- [NTSB IAD05FA023](https://openairdocs.org/ntsb/IAD05FA023.md): CASA 212-200-CC · Bamiyan, Afghanistan · Accident · 6 fatal · Class 1 · Field · Final report · Nov 27, 2004 · N960BW · Destroyed
  > the captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…
- [NTSB CHI05MA011](https://openairdocs.org/ntsb/CHI05MA011.md): Boeing 747-132 · Lake Michigan · Accident · No injuries · Major investigation · Final report · Oct 21, 2004 · N709CK · Substantial damage
  > The number one engine separated from the airplane during climb due to the uncontained separation of a portion of the second stage turbine disk rim after the second stage turbine vanes contacted the disk. The second stage turbine vanes contacted the second…
- [NTSB DCA05MA003](https://openairdocs.org/ntsb/DCA05MA003.md): Canadair CL-600 · Jefferson City, MO · Accident · 2 fatal · Class 1 · Major · Final report · Oct 14, 2004 · N8396A · Destroyed
  > (1) the pilots’ unprofessional behavior, deviation from standard operating procedures, and poor airmanship, which resulted in an in-flight emergency from which they were unable to recover, in part because of the pilots’ inadequate training; (2) the pilots’…
- [NTSB SEA04MA167](https://openairdocs.org/ntsb/SEA04MA167.md): Bell 407 · Battle Mountain, NV · Accident · 5 fatal · Major investigation · Final report · Aug 22, 2004 · N2YN · Destroyed
  > The pilot's failure to maintain clearance from mountainous terrain. Contributing factors were the pilot's improper decision to take the direct route over mountainous terrain, the dark night conditions, and the pressure to complete the mission induced by the…
- [NTSB DCA04MA061](https://openairdocs.org/ntsb/DCA04MA061.md): Boeing 777 · Miami, FL · Accident · Serious injuries · Major investigation · Final report · Jul 25, 2004 · N797AN · No damage
  > the in-flight encounter with unforecasted clear air turbulence.
- [NTSB DCA04MA030](https://openairdocs.org/ntsb/DCA04MA030.md): Sikorsky S76A++ · Gulf of Mexico · Accident · 10 fatal · Class 1 · Major · Final report · Mar 23, 2004 · N579EH · Destroyed
  > the flight crew's failure to identify and arrest the helicopter's descent for undetermined reasons, which resulted in controlled flight into terrain.

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

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