# 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 388 of 718 · 35,889 cases

## Cases, newest first

- [NTSB FTW82FA071](https://openairdocs.org/ntsb/FTW82FA071.md): Robinson R22 · San Marcos, TX · Accident · 1 fatal · Field investigation · Final report · Feb 26, 1982 · N9061Z · Destroyed
  > The helicopter was observed rotating in a counter clockwise motion. A small explosion was seen at the tail section with pieces flying off. The outboard sections of the t/r blades were found about 800 ft from the main wreckage. Examination of the fractures…
- [NTSB ATL82FA059](https://openairdocs.org/ntsb/ATL82FA059.md): Cessna 210L · Hilton Head, SC · Accident · 4 fatal · Field investigation · Final report · Feb 26, 1982 · CGMYL · Destroyed
  > The aircraft departed dulles international airport at 1630 EST, no flight plan was filed. The next radio contact with the aircraft was by beaufort marine corps air station approach control when the controller transmitted the altimeter setting and the pilot…
- [NTSB MIA82DA077](https://openairdocs.org/ntsb/MIA82DA077.md): Cessna 210 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Final report · Feb 24, 1982 · N761MG · Destroyed
  > The pilot reported departing valkaria, Florida on a VFR round robin flight to great abaco island, Bahamas and return. While on the return leg of the flight, the engine lost power. The pilot was unable to restore power or glide to land; therefore, he ditched…
- [NTSB LAX82FUJ31](https://openairdocs.org/ntsb/LAX82FUJ31.md): Rockwell Commander 114 · San Simon, AZ · Accident · Serious injuries · Final report · Feb 24, 1982 · N4802W · Destroyed
  > After refueling at abilene the aircraft departed around noon on the second leg of a flight to repossess the aircraft. The pilot stated that he ran the engine at full rich with the fuel flow meter reading 18 gph. Using this figure the aircraft should have run…
- [NTSB FTW82FQA15](https://openairdocs.org/ntsb/FTW82FQA15.md): Bell 206B · Watrous, NM · Accident · 1 fatal · Final report · Feb 24, 1982 · N2272D · Destroyed
  > The helicopter struck power and communication lines after taking off at night. After hitting the lines, it crashed into a railroad grade and bridge. The crash site was about one mile from the departure point. An inspection of the engine revealed no preimpact…
- [NTSB ATL82DA058](https://openairdocs.org/ntsb/ATL82DA058.md): Eagle DW-1 · Clarksdale, MS · Accident · No injuries · Final report · Feb 24, 1982 · N8803H · Substantial damage
  > The pilot reported no indication of engine malfunction during takeoff and climb-out. However, after turning in a downwind direction, he noted a loss of airspeed and power. He stated that the power loss was so gradual that he noticed nothing unusual until the…
- [NTSB NYC82DA049](https://openairdocs.org/ntsb/NYC82DA049.md): Cessna 421C · Westerly, RI · Accident · No injuries · Final report · Feb 23, 1982 · N5358J · Substantial damage
  > The aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…
- [NTSB LAX82FA084](https://openairdocs.org/ntsb/LAX82FA084.md): Piper PA-28-180 · Truckee, CA · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1982 · N3646R · Destroyed
  > The non-instrument rated pilot was on a return flight from livermore, CA to Truckee. The aircraft crashed on a dark night at an elevation of about 6700 ft MSL in mountainous terrain. The angle of impact was about 25 degrees downward on a down hill slope. A…
- [NTSB DEN82FA062](https://openairdocs.org/ntsb/DEN82FA062.md): Bellanca 14-19-3A · Selfridge, ND · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1982 · N8869R · Destroyed
  > On the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…
- [NTSB MKC82DA036](https://openairdocs.org/ntsb/MKC82DA036.md): Piper PA-32R-301T · Marceline, MO · Accident · No injuries · Final report · Feb 21, 1982 · N8424B · Substantial damage
  > The pilot stated that while cruising at 7000 feet the engine began vibrating, lost power, and eventually stopped. He elected to land in an open field resulting in substantial damage to the aircraft. Examination of the engine revealed that the intake valve…
- [NTSB LAX82FA080](https://openairdocs.org/ntsb/LAX82FA080.md): Cessna 172N · Catalina Island, CA · Accident · Minor injuries · Field investigation · Final report · Feb 21, 1982 · N4906G · Substantial damage
  > While circling around Catalina Island turning in an out of canyons at 1700 feet MSL the engine lost power. At los angeles international airport, 38 miles to the nnw, the temperature was 65 degrees and the dew point was 45 degrees. All attemps to restart the…
- [NTSB DCA82AA016](https://openairdocs.org/ntsb/DCA82AA016.md): de Havilland DHC-6 · Providence, RI · Accident · 1 fatal · Final report · Feb 21, 1982 · N127PM · Destroyed
  > Aprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…
- [NTSB NYC82DA039](https://openairdocs.org/ntsb/NYC82DA039.md): Piper PA-44-180T · Mount Pocono, PA · Accident · No injuries · Final report · Feb 20, 1982 · N8226A · Substantial damage
  > Before takeoff, the pilot got a weather briefing and called the airport manager at the destination. Reportedly, the destination airport was open and usable at that time. In flight, the pilot asked ATC about reports of icing in the mt Pocono area and got a…
- [NTSB ANC82DA020](https://openairdocs.org/ntsb/ANC82DA020.md): Grumman G-21A · N Cape Yakataga, AK · Accident · No injuries · Final report · Feb 20, 1982 · N2845D · Substantial damage
  > Aircraft departed merrill field at 1110 with 220 gallons of fuel. Two hours later both engines quit while flying at an altitude of 6500 feet approximately 10 miles offshore. The crew was unable to restart the engines and the aircraft was ditched into 12 to 15…
- [NTSB LAX82FA077](https://openairdocs.org/ntsb/LAX82FA077.md): Bell 47G2 · Brawley, CA · Accident · No injuries · Field investigation · Final report · Feb 19, 1982 · N4021A · Substantial damage
  > The pilot visually checked the gas tank before takeoff and estimated there was about 1/4 tank of fuel. He then started the engine and hovered over to the water tanker and loaded 60 gallons of water in the spray tank in order to calibrate the number of gallons…
- [NTSB DEN82FTM09](https://openairdocs.org/ntsb/DEN82FTM09.md): Beech A36 · St. George, UT · Accident · 1 fatal · Final report · Feb 19, 1982 · N4295S · Destroyed
  > The aircraft was on a flight from las vegas, Nevada to St. George, Utah when it flew past the destination and struck the side of a mountain. The crash site was located about 15 miles beyond the destination at an elevation of about 7600 ft MSL. The site was…
- [NTSB ATL82FA057](https://openairdocs.org/ntsb/ATL82FA057.md): Piper PA-28-140 · Hytop, AL · Accident · 1 fatal · Field investigation · Final report · Feb 19, 1982 · N5552F · Destroyed
  > The pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…
- [NTSB FTW82FQA13](https://openairdocs.org/ntsb/FTW82FQA13.md): Piper PA-28RT-201T · Toadlena, NM · Accident · Serious injuries · Final report · Feb 18, 1982 · N29665 · Substantial damage
  > The non-instrument rated pilot in Piper PA-28RT, N29665, was using a call sign, N1104X, which was the registration number of a destroyed PA-32. He was cleared to climb to FL200, but as he continued, his speech became slurred. He acknowledged an artc…
- [NTSB MKC82DA033](https://openairdocs.org/ntsb/MKC82DA033.md): Piper PA-28-151 · Des Moines, IA · Accident · No injuries · Final report · Feb 16, 1982 · N44710 · Substantial damage
  > The aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…
- [NTSB CHI82DA057](https://openairdocs.org/ntsb/CHI82DA057.md): Beech 90 · Columbus, OH · Accident · No injuries · Final report · Feb 16, 1982 · N3DS · Substantial damage
  > With OAT 25 degrees below zero and the aircraft flying through heavy rain the pilot reported the elevator trim tab became inoperative. While attempting to stabilize the aircraft manually during an ILS approach the aircraft descended below glideslope and…
- [NTSB CHI82FA048](https://openairdocs.org/ntsb/CHI82FA048.md): Piper PA-23 · Corydon, IN · Accident · 1 fatal · Field investigation · Final report · Feb 15, 1982 · N1108P · Destroyed
  > Prior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…
- [NTSB LAX82FA078](https://openairdocs.org/ntsb/LAX82FA078.md): Cessna 172K · Hollister, CA · Accident · 4 fatal · Field investigation · Final report · Feb 14, 1982 · N99WM · Destroyed
  > The aircraft flew into the side of a mountain in level cruise. The accident happened during weather in which VFR flight had not been recommended. Clouds were obscuring the mountains. The aircraft was on the return leg of a cross-country flight. No flight plan…
- [NTSB LAX82FA074](https://openairdocs.org/ntsb/LAX82FA074.md): Piper PA-34 · Near Sonoma, CA · Accident · 1 fatal · Field investigation · Final report · Feb 14, 1982 · N8455Y · Destroyed
  > The pilot proceeded VFR toward a private strip after an instrument approach to napa county airport. The visibility was not good and the aircraft collided with a hillside while en route. About 5 mi north, the weather at the napa county airport was 500 ft…
- [NTSB LAX82FA073](https://openairdocs.org/ntsb/LAX82FA073.md): Rockwell 112A · Near Los Banos, CA · Accident · 2 fatal · Field investigation · Final report · Feb 14, 1982 · N1433J · Destroyed
  > During a preflight briefing, the pilot was advised that the mountains were obscured by clouds, the outlook was for marginal VFR ceilings, and the weather conditions in northern California were deteriorating faster than forcasted. The pilot took off at 1333…
- [NTSB LAX82DUG06](https://openairdocs.org/ntsb/LAX82DUG06.md): Cessna 150 · Daggett, CA · Accident · Serious injuries · Final report · Feb 14, 1982 · N4539U · Destroyed
  > While descending through 4000 ft MSL to land, the engine began to surge. The pilot moved the mixture to full rich and selected carburetor heat, but the engine lost all power. Reportedly, the aircraft was demolished during a forced landing. Disassembly of the…
- [NTSB CHI82DA046](https://openairdocs.org/ntsb/CHI82DA046.md): Cessna 150 · Altamont, IL · Accident · Minor injuries · Final report · Feb 14, 1982 · N9447U · Substantial damage
  > About five to ten minutes after takeoff at night, the engine began to lose power and then suddenly stopped. Pilot elected to land in a light colored area that was surrounded by darker areas. During the approach, the aircraft struck a tree which damaged the…
- [NTSB LAX82FA071](https://openairdocs.org/ntsb/LAX82FA071.md): Beech J35 · Gilroy, CA · Accident · 4 fatal · Field investigation · Final report · Feb 13, 1982 · N8385D · Destroyed
  > The plt was advised during the wx briefing that VFR flight was not recommeded across the mountains & that san jose was reporting 3,000 ft scattered; 4,000 ft broken; 9,000 ft overcast with 10 mi visibility with light rain. Approximately 36 min after takeoff…
- [NTSB CHI82FEG02](https://openairdocs.org/ntsb/CHI82FEG02.md): Piper PA-24-250 · Pleasant Hill, OH · Accident · Serious injuries · Final report · Feb 13, 1982 · N5266P · Destroyed
  > While enroute, the pilot elected to climb over the weather rather than fly through it. At about 12,000 ft MSL over the weather, he encountered an engine problem. He initiated emergency procedures and informed dayton approach control of his problem. Unable to…
- [NTSB NYC82IA036](https://openairdocs.org/ntsb/NYC82IA036.md): de Havilland DHC-6-100 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Feb 12, 1982 · N80701 · No damage
  > During cruise flight, the aircraft experienced a power failure and fire in the left engine. The crew secured the engine and discharged the fire extinguisher without effect on the fire. During descent to jfk international the fire extinguished itself. A normal…
- [NTSB MIA82FA045](https://openairdocs.org/ntsb/MIA82FA045.md): Cessna 421 · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Feb 11, 1982 · N24CC · Destroyed
  > The flight departed the tamiami airport, Miami, Florida at approximately 2100 EST on February 9, 1982. There was no flight plan filed and the purpose, destination, and locations of possible enroute stops were not determined. The next reported communication…
- [NTSB LAX82FA069](https://openairdocs.org/ntsb/LAX82FA069.md): Beech 95-C55 · Twentynine Palm, CA · Accident · 2 fatal · Field investigation · Final report · Feb 11, 1982 · N200WJ · Destroyed
  > At 1605, the flt called blythe fss stating he was 25 mi east for landing. When he heard that his business associates in another acft were preparing to depart blythe for Twentynine palms, the plt cancelled his landing intentions & stated that they will be…
- [NTSB ATL82FA052](https://openairdocs.org/ntsb/ATL82FA052.md): Cessna 401 · Jessup, GA · Accident · No injuries · Field investigation · Final report · Feb 10, 1982 · N8299F · Substantial damage
  > After reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…
- [NTSB LAX82FA072](https://openairdocs.org/ntsb/LAX82FA072.md): Cessna P210N · 6 Nm North Of S, AZ · Accident · 4 fatal · Field investigation · Final report · Feb 8, 1982 · N731NQ · Destroyed
  > The pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…
- [NTSB LAX82FA070](https://openairdocs.org/ntsb/LAX82FA070.md): Cessna 172N · Santa Ysabel, CA · Accident · 1 fatal · Field investigation · Final report · Feb 8, 1982 · N733ZR · Destroyed
  > Drg wx briefings at 1024 & 1247 the plt was advised that VFR flt was not recommended due to low ceilings & icing conditions. At about 1418 the acft departed. At 1439 the plt contacted flight watch (fw) & reported picking up leading edge ice 6.4 mi east of the…
- [NTSB ATL82DA049](https://openairdocs.org/ntsb/ATL82DA049.md): Cessna C-172 · Brownsville, KY · Accident · Minor injuries · Final report · Feb 8, 1982 · N13165 · Destroyed
  > While climbing after takeoff, the pilot noticed smoke in the cockpit. He reported that flames started to come in as he was turning back to the airstrip. When he saw that he could land back on the strip, he reportedly shut- off the fuel, master switch and…
- [NTSB MIA82FA044](https://openairdocs.org/ntsb/MIA82FA044.md): Cessna 182B · W. Of Homestead, FL · Accident · 8 fatal · Field investigation · Final report · Feb 7, 1982 · N2280G · 2 aircraft · Destroyed
  > Cessna N2280G and Piper N7361P collided in midair in a remote area of the everglades national park, Florida.
- [NTSB CHI82DA040](https://openairdocs.org/ntsb/CHI82DA040.md): Cessna 152 · Canton, MI · Accident · No injuries · Final report · Feb 7, 1982 · N46733 · Substantial damage
  > The student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…
- [NTSB MIA82FA042](https://openairdocs.org/ntsb/MIA82FA042.md): Robinson R-22 · Ormand Beach, FL · Accident · 2 fatal · Field investigation · Final report · Feb 5, 1982 · N90286 · Destroyed
  > After being told by the operator to remain on the ground until the weather improved the instructor pilot departed ormond Beach airport. The pilot radioed daytona Beach approach control and requested a special VFR clearance and vectors to daytona Beach…
- [NTSB MIA82DA050](https://openairdocs.org/ntsb/MIA82DA050.md): Piper PA-28 · 120 Nm Sse Of M, FL · Accident · 2 fatal · Final report · Feb 5, 1982 · N1306H · Destroyed
  > At about 1216 the pilot of a Cessna 402, N69400, heard N1306H announce on the radio that he was 100 miles south of bimini and had 15 minutes of fuel remaining. The captain of American airlines flight 603 heard the pilot state that he was going in and he…
- [NTSB ATL82FA047](https://openairdocs.org/ntsb/ATL82FA047.md): Piper PA-32R-300 · Lambsburg, VA · Accident · 4 fatal · Field investigation · Final report · Feb 5, 1982 · N75225 · Destroyed
  > The aircraft was on an air taxi flight to transport 2 prisoners and was to be operated on a VFR flight plan in VFR conditions only. Prior to takeoff, the pilot had obtained 12 weather briefing. In 2 of the briefings, VFR flight was not recommended. At about…
- [NTSB ATL82DA046](https://openairdocs.org/ntsb/ATL82DA046.md): Cessna T210L · Luverne, AL · Accident · Serious injuries · Final report · Feb 5, 1982 · N123WL · Substantial damage
  > The engine abruptly quit during takeoff after the pilot reduced power and started a crosswind turn. The nose gear collapsed rearward during landing roll in a soft terraced pasture and the aircraft flipped to an inverted position. Two ounces of water were…
- [NTSB LAX82FUJ27](https://openairdocs.org/ntsb/LAX82FUJ27.md): Mooney M20J · Paradise Valley, AZ · Accident · 1 fatal · Final report · Feb 4, 1982 · N11578 · Destroyed
  > The pilot picked up the new aircraft from the factory at kerrville, Texas on the day of the accident. He was ferrying the plane to his home in new jersey by way of las vegas, Nevada. He declined an offer to be checked out in the plane and departed kerrville…
- [NTSB CHI82DA034](https://openairdocs.org/ntsb/CHI82DA034.md): Bell 206L-1 · Indianapolis, IN · Accident · No injuries · Final report · Feb 3, 1982 · N2777B · Substantial damage
  > The engine lost power during a night flight while enroute to obtain fuel. The low RPM audio and warning light were noted when the loss of power occurred. The pilot entered an autorotative descent and turned to land on an interstate highway. As he started to…
- [NTSB FTW82FRA15](https://openairdocs.org/ntsb/FTW82FRA15.md): Aerospatiale SA-360C · Hitchcock, TX · Accident · Serious injuries · Final report · Feb 2, 1982 · N213EH · Destroyed
  > During a return flight from an offshore platform, the pilot encountered strong headwinds and elected to land at lake jackson, Texas for fuel. He lacked a proper mode of payment; therefore, he was unable to purchase fuel. He departed for galveston, Texas with…
- [NTSB DEN82DA028](https://openairdocs.org/ntsb/DEN82DA028.md): Piper PA-32 · Rock Springs, WY · Accident · Serious injuries · Final report · Feb 2, 1982 · N8178F · Substantial damage
  > The aircraft departed vernal,ut at 1810 MST after refueling. During the VFR flight the pilot reported to Rock Springs fss that he was 20 miles south and was given current weather and runway in use. No other transmissions were received. The aircraft struck a…
- [NTSB MKC82DA024](https://openairdocs.org/ntsb/MKC82DA024.md): Beech 36 · Malden, MO · Accident · Serious injuries · Final report · Jan 31, 1982 · N5005M · Substantial damage
  > The pilot was briefed on the enroute weather prior to departure. Records indicate that sigmets on icing and turbulence along the route were provided to the pilot. When the pilot encountered icing conditions in flight, he continued instead of turning back to…
- [NTSB LAX82DA057](https://openairdocs.org/ntsb/LAX82DA057.md): Cessna 177B · Elko, NV · Accident · No injuries · Final report · Jan 30, 1982 · N35289 · Substantial damage
  > The owner of the aircraft stated that he had "topped the tanks" after the previous flight. The pilot of this flight said that he did not visually check the fuel before takeoff. During flight, the right fuel gauge continued to indicate full. About 15 miles…
- [NTSB LAX82DA055](https://openairdocs.org/ntsb/LAX82DA055.md): Mooney M20J · Avalon, CA · Accident · No injuries · Final report · Jan 30, 1982 · N4510H · Destroyed
  > The pilot stated that upon touchdown at santa catalina airport she discovered that the trim was stuck. As the aircraft reached midfield the pilot elected to make a go-around. During climbout while passing through 1700 feet the pilot stated that she smelled…
- [NTSB MKC82FA023](https://openairdocs.org/ntsb/MKC82FA023.md): Cessna 172N · 5m E. Greensbur, KS · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1982 · N1589E · Destroyed
  > The plt received a wx briefing for a flt to dodge city,KS. The fss specialist asked the plt if he was proposing his flight under IFR since his destination was reporting IMC. The plt replied that he was. A ground witness at haviland,KS located about 5 miles…
- [NTSB LAX82FVM09](https://openairdocs.org/ntsb/LAX82FVM09.md): Piper 28-151 · Los Gatos, CA · Accident · 1 fatal · Final report · Jan 29, 1982 · N32678 · Destroyed
  > The pilot prepared to depart on a scheduled courier run in a Piper PA-32, but was unable to start the engine. After consulting with company personnel, he rented a Piper PA-28-151, transferred the cargo and departed monterey, CA on a flight to oakland, CA.…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=389

## 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."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?page=388

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.