# Major NTSB investigations: Maneuvering

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.

## Latest cases

- [NTSB CEN23MA034](https://openairdocs.org/ntsb/CEN23MA034.md): Boeing B17 · Dallas, TX · Accident · 6 fatal · Class 1 · Major · Final report · Nov 12, 2022 · N7227C · 2 aircraft · Destroyed
  > the air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…
- [NTSB CEN19MA141](https://openairdocs.org/ntsb/CEN19MA141.md): De Havilland DHC-2 · Ketchikan, AK · Accident · 6 fatal · Class 1 · Major · Final report · May 13, 2019 · N952DB · 2 aircraft · Destroyed
  > The inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…
- [NTSB ANC13GA036](https://openairdocs.org/ntsb/ANC13GA036.md): Eurocopter AS350 · Talkeetna, AK · Accident · 3 fatal · Class 1 · Final report · Mar 31, 2013 · N911AA · Destroyed
  > The pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…
- [NTSB ERA12MA122](https://openairdocs.org/ntsb/ERA12MA122.md): Bell 206B · Green Cove Springs, FL · Accident · 3 fatal · Major investigation · Final report · Dec 26, 2011 · N5016M · Destroyed
  > The pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.
- [NTSB WPR12MA034](https://openairdocs.org/ntsb/WPR12MA034.md): Eurocopter EC 130 B4 · Pukoo, HI · Accident · 5 fatal · Major investigation · Final report · Nov 10, 2011 · N11QV · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…
- [NTSB WPR11MA454](https://openairdocs.org/ntsb/WPR11MA454.md): North American/Aero Classics P-51D · Reno, NV · Accident · 11 fatal · Class 1 · Major · Final report · Sep 16, 2011 · N79111 · Substantial damage
  > The reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…
- [NTSB CEN09PA348](https://openairdocs.org/ntsb/CEN09PA348.md): Agusta A109E · Santa Fe, NM · Accident · 2 fatal · Class 1 · Final report · Jun 10, 2009 · N606SP · Destroyed
  > The pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…
- [NTSB WPR09MA159](https://openairdocs.org/ntsb/WPR09MA159.md): Pilatus PC-12/45 · Butte, MT · Accident · 14 fatal · Class 1 · Major · Final report · Mar 22, 2009 · N128CM · Substantial damage
  > (1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…
- [NTSB LAX08MA007](https://openairdocs.org/ntsb/LAX08MA007.md): Cessna 208B · Naches, WA · Accident · 10 fatal · Major investigation · Final report · Oct 8, 2007 · N430A · Destroyed
  > The pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…
- [NTSB ANC07MA083](https://openairdocs.org/ntsb/ANC07MA083.md): de Havilland DHC-2 · Ketchikan, AK · Accident · 5 fatal · Major investigation · Final report · Aug 17, 2007 · N345KA · Destroyed
  > An inadvertent aerodynamic stall resulting from the pilot's poor decision-making and inadequate planning and execution when he took off toward nearby rising terrain, in strong winds, under circumstances where his options for maneuvering were severely limited…
- [NTSB DEN07MA134](https://openairdocs.org/ntsb/DEN07MA134.md): Beech E90B · Ruidoso, NM · Accident · 5 fatal · Major investigation · Final report · Aug 6, 2007 · N369CD · Destroyed
  > Failure to maintain clearance from terrain due to spatial disorientation.
- [NTSB LAX07MA231](https://openairdocs.org/ntsb/LAX07MA231.md): Eurocopter AS350-B2 · Phoenix, AZ · Accident · 4 fatal · Class 1 · Major · Final report · Jul 27, 2007 · N613TV · 2 aircraft · Destroyed
  > Both pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…
- [NTSB NYC07MA073](https://openairdocs.org/ntsb/NYC07MA073.md): Aerospatiale AS350BA · Princeville, HI · Accident · 4 fatal · Major investigation · Final report · Mar 9, 2007 · N354NT · Substantial damage
  > The failure of maintenance personnel to properly tighten (torque) the flight control servo lower attachment clevis, and reinstall a functioning lock washer, which resulted in a flight control disconnect and a complete loss of helicopter control. Contributing…
- [NTSB DCA07MA003](https://openairdocs.org/ntsb/DCA07MA003.md): Cirrus Design SR-20 · Manhattan, NYC, NY · Accident · 2 fatal · Class 1 · Major · Final report · Oct 11, 2006 · N929CD · Destroyed
  > The pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.
- [NTSB SEA05MA202](https://openairdocs.org/ntsb/SEA05MA202.md): Agusta A109A II · Edmonds, WA · Accident · 3 fatal · Major investigation · Final report · Sep 30, 2005 · N655GS · Destroyed
  > Loss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.
- [NTSB SEA05MA199](https://openairdocs.org/ntsb/SEA05MA199.md): Aerospatiale AS350BA · Haena, HI · Accident · 3 fatal · Class 1 · Major · Final report · Sep 24, 2005 · N355NT · Substantial damage
  > The pilot's decision to continue flight into adverse weather conditions, which resulted in a loss of control due to an encounter with a microburst. Contributing to the accident was inadequate Federal Aviation Administration surveillance of Special Federal…
- [NTSB IAD05MA078](https://openairdocs.org/ntsb/IAD05MA078.md): Sikorsky S-76C · New York, NY · Accident · Serious injuries · Major investigation · Final report · Jun 17, 2005 · N317MY · Substantial damage
  > An inadvertent encounter with a left quartering tailwind. Factors in the accident were settling with power, the high gross weight of the helicopter, and the crew's failure to accurately assess the winds in the area.
- [NTSB SEA05MA085](https://openairdocs.org/ntsb/SEA05MA085.md): Lockheed P-3B · Chico, CA · Accident · 3 fatal · Major investigation · Final report · Apr 21, 2005 · N926AU · Destroyed
  > Terrain clearance was not maintained while maneuvering for undetermined reasons. Mountainous terrain was a factor.
- [NTSB LAX04FA329](https://openairdocs.org/ntsb/LAX04FA329.md): Bell 206B · Kalaheo, HI · Accident · 5 fatal · Class 1 · Field · Final report · Sep 25, 2004 · N16849 · Destroyed
  > The pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…
- [NTSB LAX03MA292](https://openairdocs.org/ntsb/LAX03MA292.md): Aerospatiale AS350BA · GrandCanyonWest, AZ · Accident · 7 fatal · Class 1 · Major · Final report · Sep 20, 2003 · N270SH · Destroyed
  > The pilot's disregard of safe flying procedures and misjudgment of the helicopter's proximity to terrain, which resulted in an in-flight collision with a canyon wall. Contributing to the accident was the failure of Sundance Helicopters and the Federal…
- [NTSB LAX01MA272](https://openairdocs.org/ntsb/LAX01MA272.md): Eurocopter AS350-B2 · Meadview, AZ · Accident · 6 fatal · Major investigation · Final report · Aug 10, 2001 · N169PA · Destroyed
  > The pilot’s loss of control of the helicopter for undetermined reasons.
- [NTSB CHI01MA163](https://openairdocs.org/ntsb/CHI01MA163.md): Learjet 25D · Salina, KS · Accident · Serious injuries · Major investigation · Final report · Jun 12, 2001 · N333CG · Destroyed
  > The PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…
- [NTSB LAX99MA251](https://openairdocs.org/ntsb/LAX99MA251.md): Schempp-Hirth Nimbus 4DM · Minden, NV · Accident · 2 fatal · Class 1 · Major · Final report · Jul 13, 1999 · N807BB · Destroyed
  > The pilot's excessive use of the elevator control during recovery from an inadvertently entered spin and/or spiral dive during which the glider exceeded the maximum permissible speed, which resulted in the overload failure of the wings at loadings beyond the…
- [NTSB CHI98MA260](https://openairdocs.org/ntsb/CHI98MA260.md): North American NA-265-80 · Florence, KS · Accident · 2 fatal · Major investigation · Final report · Jul 18, 1998 · N547JL · Destroyed
  > the pilot's overconfidence in his personal ability, his improper in-flight decision to attempt aerobatics, and his loss of control of the airplane.
- [NTSB ANC97MA161](https://openairdocs.org/ntsb/ANC97MA161.md): Cessna 208B · Wainwright, AK · Accident · 5 fatal · Major investigation · Final report · Apr 11, 1997 · N408GV · Destroyed
  > The pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.
- [NTSB DCA94GA010](https://openairdocs.org/ntsb/DCA94GA010.md): Beech 300/F · Front Royal, VA · Accident · 3 fatal · Class 1 · Final report · Oct 26, 1993 · N82 · Destroyed
  > the failure of the pilot-in-command to ensure that the airplane remained in visual meteorological conditions over mountainous terrain, and the failure of the Federal Aviation Administration executives and managers responsible for the FAA flying program to:…
- [NTSB CHI93MA276](https://openairdocs.org/ntsb/CHI93MA276.md): Canadair CL-600-2B19 · Byers, KS · Accident · 3 fatal · Major investigation · Final report · Jul 26, 1993 · CFCRJ · Destroyed
  > The captain's failure to adhere to the agreed upon flight test plan for ending the test maneuver at the onset of prestall stick shaker, and the flightcrew's failure to assure that all required switches were properly positioned for anti-spin chute deployment.…
- [NTSB CHI93MA143](https://openairdocs.org/ntsb/CHI93MA143.md): Beech C99 · Shelton, NE · Accident · 2 fatal · Major investigation · Final report · Apr 29, 1993 · N115GP · Destroyed
  > The deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…
- [NTSB DCA89MA058](https://openairdocs.org/ntsb/DCA89MA058.md): Beech H18 · Waipio Valley, HI · Accident · 11 fatal · Major investigation · Final report · Jun 11, 1989 · N34AP · Destroyed
  > The pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…
- [NTSB CHI89MA095](https://openairdocs.org/ntsb/CHI89MA095.md): Douglas DC3C-S13CG · Waterman, IL · Accident · 3 fatal · Major investigation · Final report · May 22, 1989 · N47CE · Destroyed
  > The pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…
- [NTSB ATL88MA184](https://openairdocs.org/ntsb/ATL88MA184.md): Learjet 35A · West Paterson, NJ · Accident · 4 fatal · Major investigation · Final report · May 24, 1988 · N500RW · Destroyed
  > Witnesses rpted a normal takeoff. Radar indicated the acft turned right as cleared and began cruise at 1900 ft, hdg nw at 235 KTS. 65 secs after calling clear of the control zone the acft's radar track ended. The acft was fragmented by theimpact with all flt…
- [NTSB SEA88MA015](https://openairdocs.org/ntsb/SEA88MA015.md): Cessna 310N · Bellingham, WA · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1987 · N4178Q · Destroyed
  > The acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…
- [NTSB DEN87MA168](https://openairdocs.org/ntsb/DEN87MA168.md): Beech D18S · Lakeside, MT · Accident · 10 fatal · Major investigation · Final report · Jul 5, 1987 · N132E · Destroyed
  > The plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…
- [NTSB DCA87MA018](https://openairdocs.org/ntsb/DCA87MA018.md): Swearingen SA-226TC · Kearns, UT · Accident · 10 fatal · Class 1 · Major · Final report · Jan 15, 1987 · N163SW · 2 aircraft · Destroyed
  > The two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…
- [NTSB LAX87MA068](https://openairdocs.org/ntsb/LAX87MA068.md): Piper PA-28-181 · Long Beach, CA · Accident · No injuries · Major investigation · Final report · Dec 26, 1986 · N7646F · 2 aircraft · Substantial damage
  > A Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS…
- [NTSB CHI87MA053](https://openairdocs.org/ntsb/CHI87MA053.md): Hughes 269B · Cross Plaines, IN · Accident · 2 fatal · Major investigation · Final report · Dec 10, 1986 · N8982F · Destroyed
  > The plt & observer were on a power line patrol flt. While proceeding southbound, they apchd an area were the lines were about 23 ft AGL & were crossed by another set of power lines, oriented in an east-west direction. The other power lines were about 45 ft…
- [NTSB NYC87MA024](https://openairdocs.org/ntsb/NYC87MA024.md): Enstrom F-28F · Manhattan, NY · Accident · 1 fatal · Major investigation · Final report · Oct 22, 1986 · N8617B · Destroyed
  > The aircraft was contracted by nbc to make daily highway traffic observations in the new york city area. The pilot and passenger, an nbc radio traffic reporter, were flying in a northerly direction along Manhattan's west side at an altitude of about 75 feet.…
- [NTSB LAX86MA311](https://openairdocs.org/ntsb/LAX86MA311.md): Bell 206B · Alamo, CA · Accident · 2 fatal · Major investigation · Final report · Aug 3, 1986 · N49606 · Destroyed
  > Witnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…
- [NTSB DCA86AA028](https://openairdocs.org/ntsb/DCA86AA028.md): de Havilland DHC-6-300 · Grand Canyon, AZ · Accident · 25 fatal · Final report · Jun 18, 1986 · N76GC · 2 aircraft · Destroyed
  > At about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…
- [NTSB MIA86MA182](https://openairdocs.org/ntsb/MIA86MA182.md): Hughes 369HE · Jacksonville, FL · Accident · 2 fatal · Major investigation · Final report · Jun 16, 1986 · N9045F · Destroyed
  > A LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft…
- [NTSB LAX86MA238](https://openairdocs.org/ntsb/LAX86MA238.md): Aerospatiale AS-355F-1 · Kameula, HI · Accident · Minor injuries · Major investigation · Final report · May 31, 1986 · N909CH · Substantial damage
  > The plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…
- [NTSB LAX86MA186](https://openairdocs.org/ntsb/LAX86MA186.md): LTV Aerospace Industries A7E · Warner Springs, CA · Accident · No injuries · Major investigation · Final report · Apr 20, 1986 · USN · 2 aircraft · Substantial damage
  > A rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating…
- [NTSB ATL86MA087](https://openairdocs.org/ntsb/ATL86MA087.md): Piper PA-32-300 · Andalusia, AL · Accident · 1 fatal · Major investigation · Final report · Mar 7, 1986 · N1099X · Destroyed
  > The accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…
- [NTSB FTW85MA317](https://openairdocs.org/ntsb/FTW85MA317.md): Beech 200 · Quinlan, TX · Accident · 3 fatal · Major investigation · Final report · Aug 12, 1985 · N100HC · 2 aircraft · Destroyed
  > N100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…
- [NTSB SEA84MA016](https://openairdocs.org/ntsb/SEA84MA016.md): de Havilland DHC-2 · Challis, ID · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1983 · N9006 · Destroyed
  > The plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the…
- [NTSB LAX82AA274](https://openairdocs.org/ntsb/LAX82AA274.md): Bell UH-1B · Valencia, CA · Accident · 3 fatal · Final report · Jul 23, 1982 · N87701 · Substantial damage
  > Acft being used to film movie scene depicting attack of village typical of villges in viet nam. Acft was about 25 ft AGL & above location where special effects explosives were detonated. As the plt turned acft for camera coverage, acft'stail section was…

## 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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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