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

## Cases, newest first

- [NTSB SEA87FA014](https://openairdocs.org/ntsb/SEA87FA014.md): Piper PA-38 · Port Townsend, WA · Accident · 2 fatal · Field investigation · Final report · Oct 26, 1986 · N2565P · Destroyed
  > The plt had flown this acft over the same route many times. While en route, the acft collided with tall trees on rising terrain about 3 miles south of a direct course to the destination. The wx in the vicinity was characterized by low clouds, fog & haze. Aprx…
- [NTSB ATL87LA011](https://openairdocs.org/ntsb/ATL87LA011.md): Hughes 269B · Danville, KY · Accident · No injuries · Limited investigation · Final report · Oct 26, 1986 · N9372F · Substantial damage
  > During a local pleasure flight to film the color change of autumn leaves, the low fuel warning light illuminated. Aprx 2 minutes later the engine lost power and the pilot executed an emergency landing in a field. The helicopter lost main rotor RPM prior to…
- [NTSB LAX87LA026](https://openairdocs.org/ntsb/LAX87LA026.md): Cessna 172 · Weed, CA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1986 · CGZWK · Substantial damage
  > During a cross country flight, the engine quit approximately 6 miles north of Weed, California. The pilot initiated a forced landing and the aircraft collided with the terrain 150 feet short of the airport. An examination of the aircraft revealed that both…
- [NTSB DEN87LA009](https://openairdocs.org/ntsb/DEN87LA009.md): Cessna TU206G · Greybull, WY · Accident · No injuries · Limited investigation · Final report · Oct 24, 1986 · N6277Z · Substantial damage
  > The plt departed aurora, co at 1000 en route to great falls, mt at 8000 ft MSL. At 1237 the plt advised worland fss that the eng had lost power and he was going down. The plt said that on final apch he had to pull up to avoid power lines. The acft stalled and…
- [NTSB LAX87LA025](https://openairdocs.org/ntsb/LAX87LA025.md): Piper PA-28RT-201T · Madera, CA · Accident · No injuries · Limited investigation · Final report · Oct 23, 1986 · N2853X · Substantial damage
  > During a dual instructional flight, the pilots were practicing a simulated engine out procedure. Engine power had been reduced to 15' of manifold pressure. When an attempt was made to add power at an altitude of about 500 ft, the engine quit. The instructor…
- [NTSB DEN87FA008](https://openairdocs.org/ntsb/DEN87FA008.md): Mooney M20B · Buffalo, WY · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1986 · N74739 · Destroyed
  > At aprx 1720 MDT, tower psnl at the dep arpt received a phone call from the plt. He said he wished to depart with an inop 2-WAY radio. He was advised that IMC prevailed & that a radio would be required to depart with an IFR or special VFR clnc. At 1907 (after…
- [NTSB ATL87FA009](https://openairdocs.org/ntsb/ATL87FA009.md): Bell 206B III · Nashville, TN · Accident · Minor injuries · Field investigation · Final report · Oct 20, 1986 · N2204Z · Substantial damage
  > The plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…
- [NTSB NYC87LA007](https://openairdocs.org/ntsb/NYC87LA007.md): Cessna 172N · Port Matilda, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1986 · N5094K · Substantial damage
  > The aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…
- [NTSB LAX87LA021](https://openairdocs.org/ntsb/LAX87LA021.md): Cessna 172C · Michigan Bar, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1986 · N8449X · Substantial damage
  > During a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…
- [NTSB CHI87LA005](https://openairdocs.org/ntsb/CHI87LA005.md): Cessna 152 · Galesburg, MI · Accident · No injuries · Limited investigation · Final report · Oct 19, 1986 · N69223 · Substantial damage
  > The student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…
- [NTSB LAX87MA018](https://openairdocs.org/ntsb/LAX87MA018.md): Cessna 172N · Altadena, CA · Accident · 2 fatal · Major investigation · Final report · Oct 17, 1986 · N1048F · Destroyed
  > While rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…
- [NTSB LAX87LA009](https://openairdocs.org/ntsb/LAX87LA009.md): Cessna 152 · Hana, HI · Accident · No injuries · Limited investigation · Final report · Oct 16, 1986 · N95354 · Substantial damage
  > During a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…
- [NTSB LAX87FA016](https://openairdocs.org/ntsb/LAX87FA016.md): Beech K35 · Bakersfield, CA · Accident · No injuries · Field investigation · Final report · Oct 15, 1986 · N107Q · Substantial damage
  > The flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated the…
- [NTSB SEA87LA029](https://openairdocs.org/ntsb/SEA87LA029.md): Cessna 182Q · Mountain Home, ID · Accident · No injuries · Limited investigation · Final report · Oct 14, 1986 · N94529 · Substantial damage
  > On short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…
- [NTSB SEA87LA011](https://openairdocs.org/ntsb/SEA87LA011.md): Cessna 150 · Perrydale, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1986 · N8184F · Destroyed
  > The acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.
- [NTSB MIA87LA006](https://openairdocs.org/ntsb/MIA87LA006.md): Cessna U206F · Caribbean Sea · Accident · No injuries · Limited investigation · Final report · Oct 14, 1986 · N8147Q · Destroyed
  > The acft was destroyed upon ditching in the ocean after sustaining eng failure several minutes after takeoff. The plt stated that he checked the fuel tanks with a calibrated dip-stick and determined there was 20 gals of fuel in the left tank and 15 gals in…
- [NTSB NYC87DNC02](https://openairdocs.org/ntsb/NYC87DNC02.md): Cessna 172M · Van Buren, ME · Accident · No injuries · Final report · Oct 13, 1986 · N5255R · Substantial damage
  > While climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…
- [NTSB ATL87FA042](https://openairdocs.org/ntsb/ATL87FA042.md): Piper PA-28-140 · Pell City, AL · Accident · 2 fatal · Field investigation · Final report · Oct 13, 1986 · N4576R · Destroyed
  > The aircraft departed albany Georgia for fenton Missouri without a flight plan. VFR not recommended had been given to the commercial, CFI, instrument rated pilot twice during the day. The wreckage was found two months later on the side of a mountain in…
- [NTSB LAX87LA015](https://openairdocs.org/ntsb/LAX87LA015.md): Cessna 182A · King City, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1986 · N4823D · Substantial damage
  > While cruising near King City, CA, the aircraft lost power and an attempt to restart the engine was unsuccessful. The aircraft was then landed in a field, but it collided with a tree during the landing roll. An examination of the aircraft revealed that the…
- [NTSB NYC87LA017](https://openairdocs.org/ntsb/NYC87LA017.md): Cessna C-152 · Port Jefferson, NY · Accident · No injuries · Limited investigation · Final report · Oct 11, 1986 · N67903 · Substantial damage
  > The Cessna 152 experienced a total loss of power for unknown reason while leveling off at 1800 ft. the student pilot escaped without injury from the aircraft after it was ditched in long island sound. The aircraft was not recovered.
- [NTSB NYC87DNC01](https://openairdocs.org/ntsb/NYC87DNC01.md): Enstrom F-28A · Belmont, NH · Accident · No injuries · Final report · Oct 11, 1986 · N238Q · Substantial damage
  > The helicopter was in cruise flt when an engine failure occurred. The plt entered an autorotation and made a hard landing which collapsed the left front strut. The nose lowered as the tail cone rose and the main rotor made contact with the tail rotor. The…
- [NTSB LAX87FA014](https://openairdocs.org/ntsb/LAX87FA014.md): Cessna 177RG · Happy Jack, AZ · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1986 · N34213 · Destroyed
  > The non-instrument rated private plt was informed that MVFR weather conditions existed along his planned route of flight. The plt took off & headed into the deteriorating wx. While cruising beneath clouds the acft collided with rapidly rising terrain. The plt…
- [NTSB ATL87FA003](https://openairdocs.org/ntsb/ATL87FA003.md): McDonnell Douglas 369E · Gahanna, OH · Accident · Serious injuries · Field investigation · Final report · Oct 9, 1986 · N52705 · Destroyed
  > The helicopter had been conducting a series of demo flts during the day & was on the last scheduled flt of the day. To drop off the local plt who had requested the demo flts, when the loss of power occurred. They had made a take off over the taxiway & turned…
- [NTSB MIA87LA005](https://openairdocs.org/ntsb/MIA87LA005.md): Piper PA-28-200 · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1986 · N5056S · Substantial damage
  > The plt stated the acft lost power and he was unable to make it to the arpt. The acft crashed in a field about 3/4 of a mile from the Lakeland arpt. Post crash examination of the eng revealed a complete failure of both magnetos, resulting in the loss of power…
- [NTSB LAX87LA012](https://openairdocs.org/ntsb/LAX87LA012.md): Robinson R-22 · Dolan Springs, AZ · Accident · No injuries · Limited investigation · Final report · Oct 7, 1986 · N2270C · Substantial damage
  > The pilot stated that he was climbing the helicopter up a dry wash and planned to cross a 3000 foot high ridge at about 10 feet above the terrain. As he approached the ridge the helicopter yawed to the right about 70 degrees and the acft main rotor lost RPM.…
- [NTSB LAX87LA010](https://openairdocs.org/ntsb/LAX87LA010.md): Piper PA-32R-301T · Rancho, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 1986 · N8159C · Substantial damage
  > A Piper PA-32R-301T collided with the ground after a forced landing. A renter pilot reported the aircraft was stolen. Examination of the aircraft revealed that there was no fuel present in the aircraft fuel tanks. It was also reported that the aircraft was…
- [NTSB MKC87LA005](https://openairdocs.org/ntsb/MKC87LA005.md): Stahl-Ameter Monnett Sonerai II · Arab, MO · Accident · No injuries · Limited investigation · Final report · Oct 6, 1986 · N44KC · Destroyed
  > The pilot stated that the aircraft had capacity for ten gallons of usable fuel, and that he flew for less that an hour before landing at columbia, Illinois. According to the pilot, the sight gauges were not accurate on the ground and he did not visually check…
- [NTSB MKC87LA001](https://openairdocs.org/ntsb/MKC87LA001.md): Aeronca 7AC · Tribune, KS · Accident · No injuries · Limited investigation · Final report · Oct 6, 1986 · N84911 · Substantial damage
  > The PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…
- [NTSB FTW87DRD01](https://openairdocs.org/ntsb/FTW87DRD01.md): Cessna A188B · Gilbert, LA · Accident · No injuries · Final report · Oct 6, 1986 · N53137 · Substantial damage
  > The acft was conducting aerial application operations when a decrease in fuel pressure and engine surging occurred. Examination failed to reveal a reason for the loss of fuel pressure and the subsequent surging of the engine. The emergency landing had to be…
- [NTSB NYC87LA009](https://openairdocs.org/ntsb/NYC87LA009.md): Eiriavion PIK-20E · Erwinna, PA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1986 · N12ZC · Substantial damage
  > Flight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.
- [NTSB NYC87DHJ01](https://openairdocs.org/ntsb/NYC87DHJ01.md): Cessna 150M · Farmingdale, NY · Accident · Serious injuries · Final report · Oct 5, 1986 · N66256 · Destroyed
  > The plt was returning home after flying for aprx 2 1/2 hours. The plt reported that he had started the flt with full fuel tanks. The acft experienced a loss of power and the plt attempted a forced landing at an arpt. He was unable to reach the rwy and the…
- [NTSB MIA87FA003](https://openairdocs.org/ntsb/MIA87FA003.md): Griffin STAR-LITE · Raymond, MS · Accident · 1 fatal · Field investigation · Final report · Oct 5, 1986 · N124PK · Destroyed
  > The plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…
- [NTSB FTW87LA002](https://openairdocs.org/ntsb/FTW87LA002.md): Robinson R22 · Minden, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1986 · N90455 · Substantial damage
  > The non-instrument rated plt entered IMC conditions while in cruise flt on a dark night at an altitude of 500 ft. he then entered a descent to reach VMC. During the descent, the helicopter collided with a tree at aprx 75 to 100 feet AGL,then crashed to the…
- [NTSB SEA87IA004](https://openairdocs.org/ntsb/SEA87IA004.md): Cessna 402C · Everett, WA · Incident · No injuries · Incident investigation · Final report · Oct 4, 1986 · N2651Y · Minor damage
  > While enroute from seattle to bellingham on a regularly scheduled passenger commuter flight the left engine number 3 exhaust riser burned through. The pilot visually detected a discoloration on the left engine nacelle inflight but was unable to execute a…
- [NTSB LAX87LA004](https://openairdocs.org/ntsb/LAX87LA004.md): Gillon Quickie Q2 · Goleta, CA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1986 · N22SD · Substantial damage
  > Prior to the accident flight of the experimental homebuilt, the spark plug inserts in the engine cylinders were changed to steel ones. The pilot said that during the flight he heard a loud noise emanate from the engine followed by a partial loss of power. The…
- [NTSB LAX87DVG01](https://openairdocs.org/ntsb/LAX87DVG01.md): Smith & R. Mathews RV-4 · Lincoln, CA · Accident · No injuries · Final report · Oct 4, 1986 · N63SM · Substantial damage
  > During a local test flight of an experimental home built acft, the engine experienced a total loss of power at aprx 3000 ft AGL. Unable to return to the airport, the plt landed in an open field. Aprx one ft above the two foot high grass, the plt raised the…
- [NTSB DEN87DTE01](https://openairdocs.org/ntsb/DEN87DTE01.md): Cassutt Sport Racer · Brighton, CO · Accident · No injuries · Final report · Oct 4, 1986 · N913M · Substantial damage
  > The plt rprtd that he did not properly lock the canopy & it came open drg flt at 7000 ft MSL. He reduced the speed & attempted to close the canopy, but was not successful. He diverted & attempted to land at the van aire arpt while holding the canopy with his…
- [NTSB NYC87FA006](https://openairdocs.org/ntsb/NYC87FA006.md): Piper PA-28-140 · Holyoke, MA · Accident · 3 fatal · Field investigation · Final report · Oct 3, 1986 · N38688 · Destroyed
  > The aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…
- [NTSB NYC87LA004](https://openairdocs.org/ntsb/NYC87LA004.md): Beech BE-58P · Derry, PA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N258W · Substantial damage
  > The flight suffered an engine power loss while in cruise flight due to fuel starvation. The pilot stated that a pretakeoff check of fuel gauges was made and they all indicated fuel on board.
- [NTSB MIA87LA001](https://openairdocs.org/ntsb/MIA87LA001.md): Cessna T310R · Titusville, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1986 · N29HH · Substantial damage
  > The plt stated that while at 9,000 ft, aprx 8 miles north of tico arpt, he lost fuel pressure in his left eng and while attempting to restart the eng and find the arpt he was unable to make it to the runway. The acft landed about 150 ft short and collided…
- [NTSB NYC86LA244](https://openairdocs.org/ntsb/NYC86LA244.md): Ryan Navion · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1986 · N5244K · Destroyed
  > The plt stated that the acft experienced engine problems during cruise flt and crashed about one mile northeast of Beaver Falls, PA. Post accident testing revealed that the engine was capable of developing power in accordance with the manufacturer's…
- [NTSB CHI86LA234](https://openairdocs.org/ntsb/CHI86LA234.md): Beech BE-95-55 · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Sep 29, 1986 · N562T · Substantial damage
  > While at cruise after sunset, the pilots discovered that the left panel lights and the overhead light were not operating. A white beam flashlight was used to observe the airspeed indicator, however, continued use of the flashlight blinded the pilots' vision…
- [NTSB CHI86FA233](https://openairdocs.org/ntsb/CHI86FA233.md): Beech E18S · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Sep 29, 1986 · N101VE · Destroyed
  > The acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…
- [NTSB FTW86LA172](https://openairdocs.org/ntsb/FTW86LA172.md): Cessna 150F · Sulphur, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1986 · N3578L · Substantial damage
  > The acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…
- [NTSB DEN86LA263](https://openairdocs.org/ntsb/DEN86LA263.md): Barnes AX-7 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Sep 28, 1986 · N2346H · Destroyed
  > While flying low level inside a river gorge at 200-300 feet above the water, the balloon impacted a power line and fell into the river.
- [NTSB MIA86FLT02](https://openairdocs.org/ntsb/MIA86FLT02.md): Mccoy Robert-Michael Breezy · Meridian, MS · Accident · Serious injuries · Final report · Sep 27, 1986 · N3269X · Destroyed
  > During flt testing of the newly purchased acft which was conducted prior to the x-country flt home, oil consumption/leakage was determined to be about 3 qts per hr. The plt stated that he planned the flt home in short hops so as to minimize oil usage & had…
- [NTSB LAX86FUG05](https://openairdocs.org/ntsb/LAX86FUG05.md): Schweizer SGS-1-35C · Palm Springs, CA · Accident · Serious injuries · Final report · Sep 27, 1986 · N2673H · Substantial damage
  > During a pleasure flight, the acft was not getting the lift required to maintain alt. The plt decided to return to the arpt, however, enroute the plt realized that he would not make it back to the rwy. The plt decided to land in an east west direction on a…
- [NTSB BFO86FHD04](https://openairdocs.org/ntsb/BFO86FHD04.md): White Lightning WLAC-1 · Wilmington, DE · Accident · No injuries · Final report · Sep 27, 1986 · N100WL · Substantial damage
  > During a vfr-on-top flt with no flt plan, the eng lost power from fuel starvation. The plt did not recognize that fuel was still remaining in a non-selected aux tank. Subsequently, the acft was damaged during a forced landing on the median of a highway.…
- [NTSB MIA86LA255](https://openairdocs.org/ntsb/MIA86LA255.md): Piper PA-28-140 · Arcadia, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1986 · N56522 · Substantial damage
  > While established in curise flight the engine failed and all attempts to start it were to no avail. The pilot executed a forced landing to a soft field and the aircraft nosed over. Examination of the engine revealed that the #1 engine exhaust valve had failed…
- [NTSB CHI86LA236](https://openairdocs.org/ntsb/CHI86LA236.md): Hughes 269B · Baldwin, WI · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N9427F · Substantial damage
  > After picking up his passenger at williams pipeline, minneapolis, Minnesota, the plt flew eastward along interstate 90 enroute to a pipeline near wausau, Wisconsin. While flying at approximatelly 400 feet, the plt and passenger stated that the engine started…

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

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

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