# 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 315 of 718 · 35,885 cases

## Cases, newest first

- [NTSB DEN87LA065](https://openairdocs.org/ntsb/DEN87LA065.md): Raven S60A · Grand Lake, CO · Accident · No injuries · Limited investigation · Final report · Mar 7, 1987 · N2803L · Substantial damage
  > The balloon encountered turbulence during normal cruise at 100 to 150 feet AGL, while crossing a ridgeline. Gusts extinguished both burner plt lights and partially collapsed the envelope. The balloon began an uncontrolled descent. The plt re-ignited both…
- [NTSB BFO87FA027](https://openairdocs.org/ntsb/BFO87FA027.md): Rockwell 112 · Edgewood, MD · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1987 · N112BB · Destroyed
  > On the day of the accident and before the accident flight, the inlet fuel hose to the fuel flow divider was replaced. The hose assembly was fabricated by maint personnel. An inspection flight afterwards revealed engine roughness during fuel mixture leaning.…
- [NTSB MKC87LA057](https://openairdocs.org/ntsb/MKC87LA057.md): Embraer EMB-110 · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N890AC · Substantial damage
  > The crew stated they were descending for landing when they flew through a flock of geese that were traveling in the same direction. They received three or four bird stikes. The aircraft landed without further incident.
- [NTSB MKC87LA055](https://openairdocs.org/ntsb/MKC87LA055.md): Cessna 150 · Newton, KS · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N704QT · Substantial damage
  > The stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…
- [NTSB LAX87FA136](https://openairdocs.org/ntsb/LAX87FA136.md): Bellanca 7KCAB · Lebec, CA · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1987 · N8713V · Destroyed
  > Prior to the flt, the plt rcvd 2 wx briefings & was adzd of low ceilings, restricted visibilities & mtn obscurement along the route. Also, he was adzd that VFR flt was not recommended. The surviving pax said that after entering the mtn area, they contd 'in…
- [NTSB DEN87LA062](https://openairdocs.org/ntsb/DEN87LA062.md): Beech 58 · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N9025V · Substantial damage
  > The plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…
- [NTSB DEN87FA064](https://openairdocs.org/ntsb/DEN87FA064.md): Cessna P210N · Roswell, NM · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1987 · N6115W · Destroyed
  > The plt, who never flew at night and who told relatives that he was exhausted after all-day business meetings, nevertheless departed albuquerque, NM, at 1756, en route to Roswell, NM. He contacted Roswell twr at 1844 but never arrived. The wreckage was…
- [NTSB LAX87FA134](https://openairdocs.org/ntsb/LAX87FA134.md): Mooney M20J · Weed, CA · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1987 · N201LF · Destroyed
  > Before takeoff, the plt was adzd that strong head winds, mod to svr turbc, mtn obscurement, multiple layers of icing & deteriorating wx were forecast along his route of flt. He filed an IFR clnc & took off at 1115 PST. While en route, he reqd the medford wx &…
- [NTSB MKC87LA060](https://openairdocs.org/ntsb/MKC87LA060.md): Piper PA-25-235 · Carlisle, AR · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1987 · N6540Z · Substantial damage
  > The PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…
- [NTSB FTW87DRA01](https://openairdocs.org/ntsb/FTW87DRA01.md): Strissel Pitts S1S · Friendswood, TX · Accident · Minor injuries · Final report · Mar 2, 1987 · N815DB · Substantial damage
  > The prop separated during flt and the plt was forced to land the acft on rough terrain. Investigation revealed that the prop had separated as a result of a previously existing crack in the eng crankshaft. The eng had been rebuilt from components salvaged from…
- [NTSB SEA87LA061](https://openairdocs.org/ntsb/SEA87LA061.md): Consolidated Aeronautics Lake LA-4-200 · Haines, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 1987 · N200LK · Destroyed
  > While at cruise a total loss of engine oil pressure occurred with the engine seizing shortly afterwards. The aircraft was force landed into trees in a remote area. The aircraft came to rest inverted. Due to the position of the aircraft, examination of the…
- [NTSB LAX87LA132](https://openairdocs.org/ntsb/LAX87LA132.md): Piper PA-28-160 · Redlands, CA · Accident · No injuries · Limited investigation · Final report · Mar 1, 1987 · N5466W · Substantial damage
  > During a pleasure cross-country flt, the plt reported that he was descending from 8500 ft MSL to 4000 ft MSL with power reduced to 2000 RPM. The plt stated that he did not use the carburetor heat while descending. When pwr was added, the eng did not respond.…
- [NTSB LAX87FA128](https://openairdocs.org/ntsb/LAX87FA128.md): British Aerospace BA146-200A · Fresno, CA · Accident · No injuries · Field investigation · Final report · Feb 28, 1987 · N356PS · Substantial damage
  > Failure of company maintenance personnel to adequately examine the engine lubrication system when contamination was detected.
- [NTSB LAX87FA126](https://openairdocs.org/ntsb/LAX87FA126.md): Boeing 747-236B · Los Angeles, CA · Accident · Serious injuries · Field investigation · Final report · Feb 27, 1987 · GBDXK · No damage
  > A Boeing 747-236B crew evacuated all occupants via escape slides after returning to Los Angeles after receiving a specific bomb threat. One passenger sustained serious injury during the evacuation. According to a witness, the 370 passengers evacuated the acft…
- [NTSB NYC87FA098](https://openairdocs.org/ntsb/NYC87FA098.md): Cessna 402 · Montgomery, NY · Accident · No injuries · Field investigation · Final report · Feb 26, 1987 · N36139 · 2 aircraft · Minor damage
  > Both acft were operating under visual flight rules in the vicinity of active airports. The Cessna 402 was in a cruise descent. The decathlon was in level flight. Neither pilot in the 402 recalls seeing the decathlon, which was struck on the rt wing. The…
- [NTSB CHI87LA088](https://openairdocs.org/ntsb/CHI87LA088.md): Beech C-35 · Lake Station, IN · Accident · No injuries · Limited investigation · Final report · Feb 26, 1987 · N99QE · Substantial damage
  > The aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…
- [NTSB LAX87FA142](https://openairdocs.org/ntsb/LAX87FA142.md): Cessna P206B · Green Valley, CA · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1987 · N58RS · Destroyed
  > A Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…
- [NTSB LAX87FA121](https://openairdocs.org/ntsb/LAX87FA121.md): Beech F33A · Anza, CA · Accident · 4 fatal · Field investigation · Final report · Feb 23, 1987 · N59AB · Destroyed
  > The non-instrument rated plt & 3 pax planned a pleasure flt to mx. The weather was below VFR minimums however the plt elected to attempt the flt. Several minutes after departure the acft was observed to enter an area where it was snowing, the cloud base was…
- [NTSB LAX87LA120](https://openairdocs.org/ntsb/LAX87LA120.md): Raven S-55A · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1987 · N4261R · No damage
  > During a pleasure flight, the pilot reported that upon take-off, the wind was calm. While in-flight the wind increased and the pilot prepared for a high wind landing. The balloon touched-down hard and hit a bush. The pilot and one passenger were ejected from…
- [NTSB ATL87FA074](https://openairdocs.org/ntsb/ATL87FA074.md): Cessna 182P · Crossville, TN · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1987 · N5824J · Destroyed
  > The rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…
- [NTSB MIA87LA088](https://openairdocs.org/ntsb/MIA87LA088.md): Piper PA-38-112 · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N25459 · Substantial damage
  > While in cruise flt at an alt of aprx 800 feet the plt reported that the eng began to lose RPM. Unable to maintain alt a forced landing was made on a road. The acft then ground looped due to contact with scrub oak trees, which resulted in severing of the left…
- [NTSB CHI87LA086](https://openairdocs.org/ntsb/CHI87LA086.md): Cessna 172RG · Camp Douglas, WI · Accident · 1 fatal · Limited investigation · Final report · Feb 20, 1987 · N4601V · Substantial damage
  > The passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…
- [NTSB LAX87DVA05](https://openairdocs.org/ntsb/LAX87DVA05.md): Hiller OH23D · Coalinga, CA · Accident · No injuries · Final report · Feb 19, 1987 · N46991 · Substantial damage
  > The plt reported that before he began the agricultural aerial application flight he noted that the fuel gauge was inoperative. The plt completed two flights, returning to the loading area after each flight. After completing the third flight and while…
- [NTSB ATL87LA073](https://openairdocs.org/ntsb/ATL87LA073.md): Piper PA-32RT-300 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Feb 19, 1987 · N31590 · Destroyed
  > The plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…
- [NTSB DEN87IA058](https://openairdocs.org/ntsb/DEN87IA058.md): Beech 58 · Colorado Spring, CO · Incident · 1 fatal · Incident investigation · Final report · Feb 18, 1987 · N328WT · No damage
  > The PIC became unconscious while at the controls during cruise. The co-owner of the acft, a rated pilot who was in the right front seat, took control and diverted to a nearby apt. The PIC was transported to a hospital where he was pronounced doa. An autopsy…
- [NTSB DEN87LA055](https://openairdocs.org/ntsb/DEN87LA055.md): Cessna 172H · Carrizozo, NM · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 1987 · N1741F · Substantial damage
  > The acft entered clouds over mountainous terrain. The plt's next visual contact was a mountain in his flt path. During maneuvering to avoid a crash the acft struck rough terrain and nosed over.
- [NTSB MIA87FA084](https://openairdocs.org/ntsb/MIA87FA084.md): Cessna 152 · Ochopee, FL · Accident · Serious injuries · Field investigation · Final report · Feb 15, 1987 · N773WA · Destroyed
  > The student pilot while on a cross-country flight encountered poor weather conditions. During a turn and descent to maintain visual contact with terrain the aircraft collided with the ground.
- [NTSB LAX87FA117](https://openairdocs.org/ntsb/LAX87FA117.md): Cessna 180J · Newhall, CA · Accident · 1 fatal · Field investigation · Final report · Feb 15, 1987 · N52184 · Destroyed
  > Based on available evidence, it is believed that the accident occurred between 0700 and 0830 hrs during a period of low ceilings and restricted visibilities in the area where the accd took place. The accd site is located in a mountain pass area between two…
- [NTSB CHI87LA082](https://openairdocs.org/ntsb/CHI87LA082.md): Piper PA-28-235 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N9451W · Substantial damage
  > According to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…
- [NTSB BFO87FA022](https://openairdocs.org/ntsb/BFO87FA022.md): Robinson R22 · Myersville, MD · Accident · 2 fatal · Field investigation · Final report · Feb 12, 1987 · N9073Y · Destroyed
  > The non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…
- [NTSB DEN87LA052](https://openairdocs.org/ntsb/DEN87LA052.md): Cessna 185C · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Feb 9, 1987 · N2691Z · Substantial damage
  > During normal descent at seven-thousand ft MSL, acft struck a bird. The left wing tip leading edge incurred a dent twenty-four inches long and twelve inches deep. Directional control became difficult so plt made a precautionary landing on highway I-15, and…
- [NTSB NYC87FA138](https://openairdocs.org/ntsb/NYC87FA138.md): Beech 95-B55 · Lanesville, NY · Accident · 4 fatal · Field investigation · Final report · Feb 8, 1987 · N973E · Destroyed
  > The plt and his family dptd 2/8/87 on a ski trip to VT. The flt did not arrive. The acft was fnd on a mtn plateau on 5/2/87. Wx conditions rptdly deteriorated and darkness was apching at the estimated time of the acdt, shortly after sunset. The acft impacted…
- [NTSB LAX87LA113](https://openairdocs.org/ntsb/LAX87LA113.md): Cessna 152 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Feb 8, 1987 · N24317 · Substantial damage
  > During a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…
- [NTSB BFO87FA020](https://openairdocs.org/ntsb/BFO87FA020.md): Piper PA-38-112 · Mount Airy, MD · Accident · Serious injuries · Field investigation · Final report · Feb 8, 1987 · N2459F · Destroyed
  > The instructor pilot simulated an engine out emergency by retarding the throttle. The student, who had not soloed, became engrossed in handling the emergency. The instructor kept his hand on the throttle throughout the practice maneuver. When he applied full…
- [NTSB NYC87LA078](https://openairdocs.org/ntsb/NYC87LA078.md): Cessna 150C · Downingtown, PA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N66270 · Substantial damage
  > A precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.
- [NTSB LAX87LA109](https://openairdocs.org/ntsb/LAX87LA109.md): Schweizer 2-32 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N17871 · Substantial damage
  > During a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…
- [NTSB FTW87FA064](https://openairdocs.org/ntsb/FTW87FA064.md): Cessna 210N · Diboll, TX · Accident · 2 fatal · Field investigation · Final report · Feb 7, 1987 · N6497N · Destroyed
  > Acft was destroyed when it impacted the ground in an uncontrolled attitude at high speed. The non-instrument rated pvt plt had filed IFR and departed into M80VC 5 l-f weather with tops above 8,000'. About 20 minutes after departure, the plt reported to the…
- [NTSB FTW87LA060](https://openairdocs.org/ntsb/FTW87LA060.md): Piper PA-28-140 · Waxahachie, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1987 · N43542 · Substantial damage
  > The aircraft received substantial damage during an emergency landing. According to the pilot, the engine failed because of carburetor icing. Atmospheric conditions at the time of the accident were conducive to carburetor icing. No mechanical failure or…
- [NTSB NYC87LA076](https://openairdocs.org/ntsb/NYC87LA076.md): Cessna 172M · Marienville, PA · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1987 · CGCGP · Substantial damage
  > The Cessna 172 experienced a total loss of power while cruising at 4000 ft on an IFR flight plan. The pilot made a landing on a road and clipped a road sign after touchdown, the aircraft swerved into a ditch and received susbtantial damage. The two occupants…
- [NTSB FTW87LA057](https://openairdocs.org/ntsb/FTW87LA057.md): Bell 206L-1 · Matagorda 665 · Accident · 2 fatal · Limited investigation · Final report · Feb 5, 1987 · N5012Z · Substantial damage
  > The plt took off fm an off-shore oil platform with 3 pax on board. Shortly after depg, he transmitted a 'mayday,' but did not state the nature of the emerg. A pax rprtd that the eng sound changed & the plt told him to 'get the raft out.' Subsequently, the…
- [NTSB FTW87FA059](https://openairdocs.org/ntsb/FTW87FA059.md): Sikorsky S-76A · Angleton, TX · Accident · 2 fatal · Field investigation · Final report · Feb 5, 1987 · N767AL · Destroyed
  > Shortly after tkof, the plt contacted his company (opns) & said he had inadvertently enctrd IFR conds. He asked opns to relay info to him fm the apch plate for the ILS rwy 17 apch to brazoria county arpt. After rcvg the info, he contacted houston apch ctl &…
- [NTSB FTW87FA054](https://openairdocs.org/ntsb/FTW87FA054.md): Piper PA-22-135 · Floresville, TX · Accident · Serious injuries · Field investigation · Final report · Feb 3, 1987 · N3554A · Destroyed
  > The pilot heard a sudden change in engine sounds during flight and realized his muffler had failed. He was flying about 1000 feet above ground level and initiated a descent to 250 feet. Heat and flames started entering the cockpit through the cabin heat inlet…
- [NTSB FTW87DRD03](https://openairdocs.org/ntsb/FTW87DRD03.md): Sikorsky S-55C · Kurthwood, LA · Accident · Serious injuries · Final report · Feb 3, 1987 · N418A · Substantial damage
  > The engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.
- [NTSB NYC87LA074](https://openairdocs.org/ntsb/NYC87LA074.md): Cessna 152C · Washington, CT · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N757TZ · Substantial damage
  > The flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…
- [NTSB DEN87FA050](https://openairdocs.org/ntsb/DEN87FA050.md): Cessna TR-182 · Moran, WY · Accident · 1 fatal · Field investigation · Final report · Feb 2, 1987 · N6089T · Destroyed
  > The pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…
- [NTSB NYC87LA072](https://openairdocs.org/ntsb/NYC87LA072.md): Cessna 172 · Lawrence, MA · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N80116 · Substantial damage
  > During a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.
- [NTSB MIA87FA080](https://openairdocs.org/ntsb/MIA87FA080.md): Piper PA-28-161 · Venice, FL · Accident · 3 fatal · Field investigation · Final report · Feb 1, 1987 · N3655M · Destroyed
  > Aircraft was seen maneuvering at between 200 and 300 feet in attempts to locate a lost radio controlled model airplane. As the aircraft completed 2 and one half turns it leveled out and began a climb to the north at which time it collided with a 504 foot…
- [NTSB LAX87FA102](https://openairdocs.org/ntsb/LAX87FA102.md): Cessna 172P · Cuyama, CA · Accident · 2 fatal · Field investigation · Final report · Jan 31, 1987 · N62127 · Destroyed
  > The plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…
- [NTSB FTW87LA055](https://openairdocs.org/ntsb/FTW87LA055.md): Cessna 175 · Jacksonville, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1987 · N175RF · Substantial damage
  > The pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…
- [NTSB DEN87LA049](https://openairdocs.org/ntsb/DEN87LA049.md): Piper PA-28-181 · Taos, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 1987 · N6913L · Substantial damage
  > The non-instrument rated plt inadvertently flew into IMC wx; snow, fog, freezing temperatures and low visibility, in mountainous terrain. He made a forced landing on a trail due to lowering visibility, 15 miles southwest of the destination arpt. The terrain…

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

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

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