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

## Cases, newest first

- [NTSB ATL82IA042](https://openairdocs.org/ntsb/ATL82IA042.md): Beech B200 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Jan 29, 1982 · N1851S · No damage
  > While at cruise with recommended power settings, the left engine oil pressure and torque indications began fluctuating and dropping. As the power lever was retarded a popping sound was heard and the engine was shut down. A precautionary landing was made in…
- [NTSB DEN82DA024](https://openairdocs.org/ntsb/DEN82DA024.md): Hughes 369D · 10mi. Nw Walsen, CO · Accident · Minor injuries · Final report · Jan 26, 1982 · N58214 · Substantial damage
  > The helicopter was flying 200-300 AGL over 8,000 ft terrain elevation at 80 knots. The plt reported encountering wind gusts slowing his ground speed to zero. The acft then started a rapid vertical descent while still indicating 80 k. the plt attempted to…
- [NTSB ANC82FA017](https://openairdocs.org/ntsb/ANC82FA017.md): Cessna 152II · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Jan 25, 1982 · N4825B · Substantial damage
  > While descending to about 3000 ft the student pilot stated that the engine started sputtering. Since the fuel gages read empty he attempted a landing at sky harbor/o'malley airstrip but came in high on the initial approach. As he maneuvered for another…
- [NTSB ANC82DAG16](https://openairdocs.org/ntsb/ANC82DAG16.md): Cessna 182M · Bethel, AK · Accident · 2 fatal · Final report · Jan 25, 1982 · N71734 · Destroyed
  > The pilot filed a VFR, round robin, flight plan. When the time on the flight plan had elapsed, a search was initiated. Later, the plane was found where it had crashed on a frozen lake surrounded by low terrain. An examination of the wreckage revealed that the…
- [NTSB CHI82FA032](https://openairdocs.org/ntsb/CHI82FA032.md): Beech A23A · London, OH · Accident · 1 fatal · Field investigation · Final report · Jan 24, 1982 · N6940Q · Destroyed
  > The pilot received two weather briefings for a flight from columbus to springfield, Ohio. VFR flight was not recommended. The pilot took off after the tower closed at 2300 EST. At about 2341 a witness near the crash site heard the loud sound of an aircraft…
- [NTSB ATL82DA040](https://openairdocs.org/ntsb/ATL82DA040.md): Cessna 177 · Athens, GA · Accident · No injuries · Final report · Jan 24, 1982 · N34975 · Substantial damage
  > During an enroute refueling stop on 1/21 the pilot noticed fuel leaking around the left tank cap. After arriving at sanford the acft was refueled with appx 50 gals & a local flight of about 12 min was flown. The acft has a usable fuel capacity of 59 gals. The…
- [NTSB LAX82FA050](https://openairdocs.org/ntsb/LAX82FA050.md): Piper PA-28-235 · 10nm N. Of Mcna, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1982 · N41664 · Destroyed
  > While on a cross country flight the pilot flew into weather which included severe to moderate icing conditions. Although the weather was forecast for the intended route of flight in a SIGMET it was not provided to the pilot during the initial weather…
- [NTSB ATL82IA041](https://openairdocs.org/ntsb/ATL82IA041.md): Dassault/Sud Falcon 20 · Louisville, KY · Incident · No injuries · Incident investigation · Final report · Jan 22, 1982 · N18FE · No damage
  > During a cruise descent from FL 330 in clear air (RAT-22 deg c) a double engine flameout occurred. Pwr had been adjusted to 86 pct with engine anti-ice on prior to the descent. When the throttles were advanced at FL 220, there was no engine response.…
- [NTSB SEA82FA032](https://openairdocs.org/ntsb/SEA82FA032.md): Cessna P210N · Boise, ID · Accident · 4 fatal · Field investigation · Final report · Jan 21, 1982 · N4947K · Destroyed
  > After takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…
- [NTSB LAX82FA045](https://openairdocs.org/ntsb/LAX82FA045.md): Cessna 182N · Escondido, CA · Accident · 3 fatal · Field investigation · Final report · Jan 21, 1982 · N92387 · Destroyed
  > Before takeoff, the pilot received a complete weather briefing. The briefer warned him that the weather system in southern California was extremely hazardous and advised him several times not to go. The briefing included numerous pilot reports that confirmed…
- [NTSB LAX82FA048](https://openairdocs.org/ntsb/LAX82FA048.md): Beech 58 · Cherry Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jan 20, 1982 · N9395Q · Destroyed
  > At 0702 the plt received a weather briefing for a VFR flight to fresno. The area forecast contained flight precautions for obscured mountains & IMC in the sierra nevadas, and occassional moderate icing below 15,000 ft. the flight departed at 0728. The…
- [NTSB DEN82FTA09](https://openairdocs.org/ntsb/DEN82FTA09.md): Cessna 177B · Wolf Pt., MT · Accident · 1 fatal · Final report · Jan 20, 1982 · N35147 · Destroyed
  > The pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…
- [NTSB ATL82IA038](https://openairdocs.org/ntsb/ATL82IA038.md): de Havilland DHC-6-300 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jan 20, 1982 · N9240N · Minor damage
  > Aircraft was being ferried to Washington, DC following rework in toronto, Canada. During letdown in IFR conditions and moderate icing, pilot noticed a glow on the right wing. As he leaned over to check it, the right engine fire warning light and fire bell…
- [NTSB NYC82DA024](https://openairdocs.org/ntsb/NYC82DA024.md): Cessna 152 · Enfield, NH · Accident · No injuries · Final report · Jan 19, 1982 · N68292 · Substantial damage
  > While the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…
- [NTSB MKC82DA018](https://openairdocs.org/ntsb/MKC82DA018.md): Cessna 182P · Topeka, KS · Accident · Minor injuries · Final report · Jan 19, 1982 · N52757 · Substantial damage
  > During an aerial line patrol flight the pilot encountered low stratus clouds and started to return to billard airport when the engine ceased to operate. The pilot attempted to restart the aircraft but could not. A forced landing was made into a mowed pasture…
- [NTSB MKC82DA017](https://openairdocs.org/ntsb/MKC82DA017.md): Cessna 177RG · Urbandale, IA · Accident · No injuries · Final report · Jan 19, 1982 · N1969Q · Substantial damage
  > After takeoff, the engine lost power at about 2000 ft MSL. The plane was damaged during a forced landing on an interstate highway. When checked after the accident, the engine would start but lost power when accelerated above 1000 RPM. The bendix servo fuel…
- [NTSB LAX82FUJ26](https://openairdocs.org/ntsb/LAX82FUJ26.md): Beachner Quick Silver · Kingman, AZ · Accident · Minor injuries · Final report · Jan 19, 1982 · N824CB · Substantial damage
  > After climbing up to pattern altitude the engine lost power. The pilot made a turn back towards the airport while trying to restart the engine but had to land in an old B-17 parking area. The aircraft struck a fence and ditch during rollout and nosed over.…
- [NTSB CHI82DA056](https://openairdocs.org/ntsb/CHI82DA056.md): Cessna 340A · Near Lansing, MI · Accident · No injuries · Final report · Jan 19, 1982 · N4140G · Substantial damage
  > During flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…
- [NTSB SEA82FYM08](https://openairdocs.org/ntsb/SEA82FYM08.md): Beech C23 · Orchards, WA · Accident · Serious injuries · Final report · Jan 18, 1982 · N2127W · Destroyed
  > During a descent with the carburetor heat on, the pilot added power 2 times to verify the engine performance. No difficulty was noted. However, when the throttle was advanced to level off at 1800 ft MSL, the engine sputtered and lost power. The pilot was…
- [NTSB LAX82FA047](https://openairdocs.org/ntsb/LAX82FA047.md): Cessna 172M · Downieville, CA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1982 · N5295R · Destroyed
  > The aircraft departed yuba city about 1030 PST after the pilot received a partial weather briefing from the marysville flight service station in which VFR flight was not recommended. Radar plots on the aircraft indicate a non-linear flight path from the…
- [NTSB ATL82FA039](https://openairdocs.org/ntsb/ATL82FA039.md): Piper PA-28-180 · Blairsville, GA · Accident · 3 fatal · Field investigation · Final report · Jan 18, 1982 · N4583J · Destroyed
  > The aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…
- [NTSB FTW82FA041](https://openairdocs.org/ntsb/FTW82FA041.md): Bell Helicopter 206L-1 · Houma, LA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1982 · N1081H · Destroyed
  > The acft was enroute to the ship shoal area in the gulf of Mexico. Another plt who departed earlier advised the plt that he & another acft had turned around & was returning after encountering a low ceiling & reduced visibility. The surviving pax stated that…
- [NTSB DEN82FA018](https://openairdocs.org/ntsb/DEN82FA018.md): Cessna T210N · 28 Mi Ene Ogden, UT · Accident · 3 fatal · Field investigation · Final report · Jan 16, 1982 · N6520Y · Destroyed
  > During an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…
- [NTSB FTW82FPJ11](https://openairdocs.org/ntsb/FTW82FPJ11.md): Piper PA-28R-201T · Watonga, OK · Accident · No injuries · Final report · Jan 14, 1982 · N47442 · Substantial damage
  > The pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…
- [NTSB MIA82DA033](https://openairdocs.org/ntsb/MIA82DA033.md): Grumman AA5B · Monticello, FL · Accident · No injuries · Final report · Jan 13, 1982 · N28607 · Destroyed
  > After being denied a special VFR clearance to land at tampa-st. petersburg the pilot elected to cancel his flight plan to tallahassee and fly to new orleans. About 5 1/2 hours into the flight he decided to divert to gulfport, ms and tuned in the gulfport VOR…
- [NTSB CHI82IA026](https://openairdocs.org/ntsb/CHI82IA026.md): Lockheed L-1011 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jan 13, 1982 · N31031 · No damage
  > The aircraft had departed boston on a scheduled flight with the #1 generator placarded inoperative and noted in the minimum equipment list. En route to los angeles, CA at FL 350, about 80 mi northeast of bay city, MN., the crew noted a simultaneous loss of #2…
- [NTSB FTW82FPA10](https://openairdocs.org/ntsb/FTW82FPA10.md): Beech P35 · Addison, TX · Accident · Serious injuries · Final report · Jan 12, 1982 · N8678M · Substantial damage
  > The aircraft was attempting to go around from an ILS approach when the pilot made visual contact with the runway. The pilot attempted to land, stalled the aircraft, and dropped to the runway. Ice had accumulated on the leading edge of the wings, the tail, and…
- [NTSB ATL82FKQ09](https://openairdocs.org/ntsb/ATL82FKQ09.md): Cessna 414 · Aberdeen, MS · Accident · Minor injuries · Final report · Jan 12, 1982 · N7706 · Destroyed
  > The non-instrument rated pilot crashed about 3 hrs after taking off with 4 1/2 hours of fuel on board. He crashed while attempting an off-airport landing in a large field. The field was located less than half way to his destination. The sheriff reported…
- [NTSB DEN82FTI10](https://openairdocs.org/ntsb/DEN82FTI10.md): Piper PA-28-140 · Near Bozeman, MT · Accident · Serious injuries · Final report · Jan 11, 1982 · N7273J · Destroyed
  > The pilot was on an early morning flight over mountainous terrain at 8500 feet. While inbound to his destination, he encountered an area of restricted visibility with snow. As he started a right turn to correct to his desired course, his passenger alerted him…
- [NTSB ATL82FA032](https://openairdocs.org/ntsb/ATL82FA032.md): Mooney M20G · Henderson, NC · Accident · 1 fatal · Field investigation · Final report · Jan 10, 1982 · N3688N · Destroyed
  > The pilot and his wife were at 6000 ft on a VFR cross-country when he became unconscious. The aircraft was equipped with a wing leveler and continued in level flight while the pilot's wife attended to him. When the pilot's wife could do nothing more for him,…
- [NTSB ANC82DA013](https://openairdocs.org/ntsb/ANC82DA013.md): Cessna U206 · Quinhagak, AK · Accident · Minor injuries · Final report · Jan 10, 1982 · N756YN · Substantial damage
  > Enroute the center seat passenger unfastened his seat belt and crawled up between the two front seats. While approaching Quinhagak the pilot had difficulty making the passenger return to his seat. After finally getting the passenger settled down he turned…
- [NTSB NYC82DA019](https://openairdocs.org/ntsb/NYC82DA019.md): Cessna 152 · Cutchogue, NY · Accident · No injuries · Final report · Jan 8, 1982 · N46681 · Substantial damage
  > After experiencing a partial loss of engine power in flight, the instructor took control of the aircraft. He applied carburetor heat, and headed back toward the airport. There was a gradual loss of power and the instructor elected to land in an open field.…
- [NTSB DEN82FA016](https://openairdocs.org/ntsb/DEN82FA016.md): Cessna 210 · Helena, MT · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1982 · N9763X · Destroyed
  > The aircraft crashed into a mountain at the 9300 foot level. The pilot was on course for his destination. The minimum obstacle clearance altitude for his location was 10,800 feet. Weather was not a problem but the accident did occur during hours of darkness.…
- [NTSB LAX82FUM06](https://openairdocs.org/ntsb/LAX82FUM06.md): Navion A · Ramona, CA · Accident · 3 fatal · Final report · Jan 6, 1982 · N4520K · Destroyed
  > The accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…
- [NTSB LAX82DVA10](https://openairdocs.org/ntsb/LAX82DVA10.md): Boeing A75 · Near Bakersfiel, CA · Accident · Serious injuries · Final report · Jan 6, 1982 · N59737 · Substantial damage
  > The pilot was enroute to las vegas, Nevada for a banner towing operation. As he proceeded eastbound along highway 58, he encountered fog that was forming in the tehachapi foothills. He initiated a 180 degree turn to go back, but inadvertently entered IFR…
- [NTSB DEN82DA015](https://openairdocs.org/ntsb/DEN82DA015.md): Beech 35 · Jackson, WY · Accident · No injuries · Final report · Jan 6, 1982 · N8070Q · Substantial damage
  > The temperature was approximately a minus 15 degrees fahrenheit. The pilot reported the engine was preheated for 30 minutes and that everything was in the green before takeoff. Shortly after takeoff, the engine began to overspeed. The pilot throttled back and…
- [NTSB SEA82FA015](https://openairdocs.org/ntsb/SEA82FA015.md): Piper PA-28-161 · Pleasant Hill, OR · Accident · 4 fatal · Field investigation · Final report · Jan 5, 1982 · N8265A · Destroyed
  > The plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…
- [NTSB LAX82FA038](https://openairdocs.org/ntsb/LAX82FA038.md): Piper PA-34-200T · Near Las Vegas, NV · Accident · 2 fatal · Field investigation · Final report · Jan 5, 1982 · N1956H · Destroyed
  > The aircraft, a Piper PA-34, was on a VFR flight to transport bank checks on a part 135 operation. Another company pilot in a Cessna 207 stated that he encountered instrument conditions at 9500 ft while he was flying from tonopah to las Vegas, NV. The Cessna…
- [NTSB LAX82FA036](https://openairdocs.org/ntsb/LAX82FA036.md): Piper PA-22 · Black Canyon Ci, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1982 · N4696Z · Destroyed
  > The wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.
- [NTSB FTW82DA037](https://openairdocs.org/ntsb/FTW82DA037.md): Piper PA-24-250 · Lonoke, AR · Accident · Serious injuries · Final report · Jan 5, 1982 · N5304P · Substantial damage
  > The pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…
- [NTSB ATL82IA029](https://openairdocs.org/ntsb/ATL82IA029.md): Rockwell 114 · Pensacola, FL · Incident · No injuries · Incident investigation · Final report · Jan 5, 1982 · N5782N · Minor damage
  > Pilot advised approach control that he smelled smoke and had erratic engine instrument readings when 20 miles from destination. The gear was extended and three green lights observed but shortly afterwards the warning light and horn activated. During the…
- [NTSB ATL82DA028](https://openairdocs.org/ntsb/ATL82DA028.md): Piper PA-28R-200 · Gastonia, NC · Accident · No injuries · Final report · Jan 5, 1982 · N2139T · Substantial damage
  > During flight, the engine surged and the propeller speed went to 3000 RPM. The pilot retarded the prop control, and maintained 2400 RPM. He proceeded to the Gastonia airport and landed without further incident. A ground run-up was made and all instruments and…
- [NTSB LAX82FA040](https://openairdocs.org/ntsb/LAX82FA040.md): Grumman AA-5B · 10 Nm W Lee Vin, CA · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1982 · N28912 · Destroyed
  > While on the ground the pilot was refused a route over the sierra mountains, after departure the pilot requested and was given a change in his flight plan that cleared him over the mountains. At 1654 the pilot advised oakland center that he was climbing…
- [NTSB FTW82DA035](https://openairdocs.org/ntsb/FTW82DA035.md): Piper PA-28R-200 · Estancia, NM · Accident · Minor injuries · Final report · Jan 4, 1982 · N32335 · Substantial damage
  > The pilot stated he experienced an engine stoppage in flight and attempted to land on a dirt road. Both fuel tanks were found empty and a total of 3 to 4 ounces of fuel was drained from the aircraft fuel system.
- [NTSB CHI82FA019](https://openairdocs.org/ntsb/CHI82FA019.md): Cessna T337G · Fort Wayne, IN · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1982 · N2CU · Destroyed
  > On 1/31/83 at 2134 CST, the acft departed grand island, NE on an IFR flt plan to toledo, OH, with appx 125 gal of fuel on board. While en route, the plt received updated wx for toledo. At that time, the toledo wx was indefinite 100 ft obscd, vis 1-1/2 mi with…
- [NTSB MIA82DA030](https://openairdocs.org/ntsb/MIA82DA030.md): Cessna 210L · Cocoa, FL · Accident · Minor injuries · Final report · Jan 3, 1982 · N94252 · Substantial damage
  > Upon arriving in the vicinity of the destination airport the pilot started to reduce power in preparation for the descent when he observed that the engine experienced a power loss. All attempts made to restore power on the engine were to no avail and the…
- [NTSB MIA82DA029](https://openairdocs.org/ntsb/MIA82DA029.md): North American Navion L-17B · Jacksonville, FL · Accident · Minor injuries · Final report · Jan 2, 1982 · N3906K · Substantial damage
  > The flight experienced engine roughness and a drop in oil pressure while in instrument weather conditions. The pilot elected to make a precautionary landing and was vectored to runway 7. The prevailing weather was sky obscured, ceiling and visibility zero.…
- [NTSB MIA82DA028](https://openairdocs.org/ntsb/MIA82DA028.md): Smith WCS-222 (Bell 47G) · Miami, FL · Accident · No injuries · Final report · Jan 2, 1982 · N23BS · Substantial damage
  > During flight, the engine lost power and fire erupted on the engine compartment. Subsequently, the engine driven hydraulic boost for the flight control system became inoperative. The pilot was flying over a populated area. During his forced landing, he was…
- [NTSB FTW82FRJ07](https://openairdocs.org/ntsb/FTW82FRJ07.md): Bellanca 17-30A · Homer, LA · Accident · Minor injuries · Final report · Jan 2, 1982 · N14779 · Destroyed
  > During an IFR flight at 5000 ft MSL, the engine began running rough. The pilot attempted to restore power, but eventually, the engine began to windmill with no apparent thrust. Unable to maintain altitude, the pilot descended through a cloud layer and broke…
- [NTSB FTW82FPJ10](https://openairdocs.org/ntsb/FTW82FPJ10.md): Navion A · Chickasha, OK · Accident · 1 fatal · Final report · Jan 2, 1982 · N4876K · Destroyed
  > The aircraft departed from a private airport 2 miles south of Chickasha at 0330. At 0336 power was interrupted on electric power lines southwest of Chickasha. The wreckage was found 6 miles south and 4 and 1/2 miles west of Chickasha a few feet west of a 35…

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

## 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=389

---
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.