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

## Cases, newest first

- [NTSB LAX88LA039](https://openairdocs.org/ntsb/LAX88LA039.md): Cessna 210A · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1987 · N9505X · Substantial damage
  > While approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…
- [NTSB MIA88LA040](https://openairdocs.org/ntsb/MIA88LA040.md): Piper PA-31-310 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1987 · N112AG · Substantial damage
  > The plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…
- [NTSB LAX88DUJ02](https://openairdocs.org/ntsb/LAX88DUJ02.md): Sadler Vampire · Mesa, AZ · Accident · No injuries · Final report · Nov 11, 1987 · N3153Y · Substantial damage
  > During a local pleasure flight, while climbing to altitude, the engine quit. A forced landing was made on a dirt road where during the landing roll the aircraft collided with a ditch. Examination of the engine revealed that the rear cylinder next to the gear…
- [NTSB ATL88LA034](https://openairdocs.org/ntsb/ATL88LA034.md): Boeing 737-232 · Raleigh, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1987 · N315DL · No damage
  > The acft encountered moderate to severe turbulence during the nighttime flt, when it passed through clouds momentarily at FL225. A flt attendant sustained a broken ankle. The captain rptd that radar gave no indication of any wx ahead prior to the encounter.…
- [NTSB MIA88LA030](https://openairdocs.org/ntsb/MIA88LA030.md): Cessna T-210N · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1987 · N4612C · Substantial damage
  > During ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…
- [NTSB LAX88LA034](https://openairdocs.org/ntsb/LAX88LA034.md): Piper PA-12 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1987 · N92783 · Substantial damage
  > The acft lost engine pwr during cruise and during the ensuing forced landing the acft collided with an object and was damaged. The post acc inspection revealed that the acft fuel tanks were empty and the fuel lines lacked fuel. No other malfunctions were…
- [NTSB NYC88LA033](https://openairdocs.org/ntsb/NYC88LA033.md): Cessna 152 · Groucester Twsp, NJ · Accident · No injuries · Limited investigation · Final report · Nov 7, 1987 · N6385M · Destroyed
  > The student pilot was on a cross country training flight. He stated that the VOR was inoperative but he recognized the VOR by a road that passed near it. The pilot became disoriented and was not able to locate a checkpoint. He descended to 1500 feet, spotted…
- [NTSB DEN88FA023](https://openairdocs.org/ntsb/DEN88FA023.md): Cessna 172RG · Pintura, UT · Accident · 3 fatal · Field investigation · Final report · Nov 7, 1987 · N9447B · Destroyed
  > Bfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…
- [NTSB CHI88LA018](https://openairdocs.org/ntsb/CHI88LA018.md): Cessna 172P · Danville, IL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1987 · N52263 · Substantial damage
  > During an emergency off airport landing, subsequent to a power failure, the aircraft experienced a nose over and suffered substantial damage. The pilot reported no injuries. Investigation after the accident revealed a valve sticking problem in the engine.…
- [NTSB ATL88LA031](https://openairdocs.org/ntsb/ATL88LA031.md): Cessna 401A · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1987 · N6250Q · Substantial damage
  > The plt related that he was climbing through 4,300 ft when he lost the left turbocharger. He then noted sparks and then fire from the engine. He shut off the fuel, waited for the fire to go out and feathered the propeller. The flt was continued to montgomery,…
- [NTSB NYC88LA031](https://openairdocs.org/ntsb/NYC88LA031.md): Cessna 172 · Stamford, CT · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N9538L · Substantial damage
  > The instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…
- [NTSB MKC88LA015](https://openairdocs.org/ntsb/MKC88LA015.md): Piper PA-28-161 · Bonne Terre, MO · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N8303Y · Substantial damage
  > The plt rprtd the eng lost pwr fm fuel exhaustion as he was cruising at ngt on a x-country flt at 6500' MSL. He declaredan emerg with st louis apch & reqd vectors to the nearest arpt. The controller (ctlr) provided vectors to the Bonne Terre arpt which was…
- [NTSB CHI88LA017](https://openairdocs.org/ntsb/CHI88LA017.md): Cessna T210N · Sugar Grove, IL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N5360U · Substantial damage
  > While descending for landing the aircraft experienced total power failure due to fuel exhaustion. An emergency landing was made on a road and on short final, the aircraft collided with power lines which ran along the south side of the road. According to the…
- [NTSB ATL88LA028](https://openairdocs.org/ntsb/ATL88LA028.md): Globe GC-1B · Beaufort, SC · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N78169 · Substantial damage
  > The airplane engine lost pwr at cruise and the plt made a forced lng in a salt-water marsh. Investigation revealed that the plt was ferrying the acft to another arpt to have maintenance performed on the fuel selector valve, which was stuck in the aux tank…
- [NTSB FTW88FA023](https://openairdocs.org/ntsb/FTW88FA023.md): Piper PA-32-260 · Fulton, TX · Accident · 2 fatal · Field investigation · Final report · Nov 4, 1987 · N3666W · Destroyed
  > Acft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…
- [NTSB MKC88LA013](https://openairdocs.org/ntsb/MKC88LA013.md): Cessna 172 · Sweet Springs, MO · Accident · No injuries · Limited investigation · Final report · Nov 2, 1987 · N46094 · Substantial damage
  > During a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…
- [NTSB NYC88LA022](https://openairdocs.org/ntsb/NYC88LA022.md): Schweizer 2-33 · Blairstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 1987 · N2669H · Destroyed
  > As the glider was being towed it lifted too high above the tow plane. At an altitude of about 55 to 65 feet it was disconnected. However the glider was tilting slightly to the right and as the pilot attempted to correct, it stalled and crashed.
- [NTSB MKC88FA012](https://openairdocs.org/ntsb/MKC88FA012.md): Merchant Pitts S-1S · Vinton, IA · Accident · Serious injuries · Field investigation · Final report · Oct 31, 1987 · N76EM · Substantial damage
  > The plt was rprtd to be on a maint ferry flt to another state. He rprtd that before the flt, he topped off the fuel tank & that the preflt, takeoff & departure were normal. Due to low clouds, he leveled off at aprx 2000' AGL. Shortly thereafter, the eng RPM…
- [NTSB LAX88LA029](https://openairdocs.org/ntsb/LAX88LA029.md): Cessna 182A · Laveen, AZ · Accident · No injuries · Limited investigation · Final report · Oct 31, 1987 · N3804D · Substantial damage
  > The pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…
- [NTSB CHI88LA014](https://openairdocs.org/ntsb/CHI88LA014.md): Enstrom F-28A · Lapeer, MI · Accident · No injuries · Limited investigation · Final report · Oct 31, 1987 · N9583 · Substantial damage
  > The helicopter was in cruise flt when the rgt side horizontal stabilizer attach tube failed & separated from the tail boom, then contacted the tail rotor. This resulted in failure of the tail rotor drive shaft flex coupling at the tail rotor gear box. In…
- [NTSB LAX88FA028](https://openairdocs.org/ntsb/LAX88FA028.md): Piper PA-24-250 · Buttonwillow, CA · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1987 · N5431P · Destroyed
  > A Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…
- [NTSB LAX88LA027](https://openairdocs.org/ntsb/LAX88LA027.md): Piper PA-18-150 · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Oct 28, 1987 · N4101E · Substantial damage
  > During an instructional flt, the student was performing climbs, descents and turns when the engine sputtered and lost power. The flight instructor took control of the aircraft but was unable to restart the engine. The aircraft was landed on a dirt road where…
- [NTSB FTW88MA021](https://openairdocs.org/ntsb/FTW88MA021.md): Convair 640 (340D) · Bartlesville, OK · Accident · Minor injuries · Major investigation · Final report · Oct 28, 1987 · N3411 · Destroyed
  > The capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…
- [NTSB FTW88LA019](https://openairdocs.org/ntsb/FTW88LA019.md): Beech 95-C55 · Fort Supply, OK · Accident · No injuries · Limited investigation · Final report · Oct 28, 1987 · N2LU · Substantial damage
  > The acft was forced to land due to loss of eng power. The plt attempted to land on a roadway. During the landing the acft rt wing struck a fence post. The landing gear collapsed during a groundloop after lndg. Post acc investigation revealed that the eng was…
- [NTSB CHI88IA011](https://openairdocs.org/ntsb/CHI88IA011.md): Mcdonnell Douglas DC-10-10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Oct 28, 1987 · N1813U · Minor damage
  > A wing panel separated from the airplane while in cruise flight. Crew declared an emergency and landed without further incident. Examination revealed that maintenance personnel did not fasten 4 of the 5 rod end assembilies used to secure the panel to the top…
- [NTSB ANC88LA015](https://openairdocs.org/ntsb/ANC88LA015.md): Piper PA-32-301 · Iliamna, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 1987 · N43639 · Substantial damage
  > The acft eng lost oil pressure during cruise. The plt attempted to land on a small airstrip. He did not make it to the strip and overran nearby tundra into Iliamna lake. The oil pump housing was broken; one gear was split and the other had a broken tooth. The…
- [NTSB NYC88LA019](https://openairdocs.org/ntsb/NYC88LA019.md): Beech 19A · Buena, NJ · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1987 · N5082T · Substantial damage
  > a loss of electrical power for undetermined reasons, which necessitated a precautionary landing. Factors were rain, clouds, dark night, and the pole. This report was modified on February 9, 2005.
- [NTSB SEA88LA014](https://openairdocs.org/ntsb/SEA88LA014.md): Bell 47G2 · Lebanon, OR · Accident · No injuries · Limited investigation · Final report · Oct 26, 1987 · N6141 · Substantial damage
  > The student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…
- [NTSB SEA88LA013](https://openairdocs.org/ntsb/SEA88LA013.md): Piper PA-28-161 · Snoqualamie Pss, WA · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 1987 · N44856 · Destroyed
  > The pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…
- [NTSB LAX88DUJ01](https://openairdocs.org/ntsb/LAX88DUJ01.md): Warnke Sonerie II · Patagonia, AZ · Accident · Serious injuries · Final report · Oct 26, 1987 · N505BW · Substantial damage
  > During a local flight, the engine lost power. Subsequently, the aircraft was extensively damaged during a forced landingin mountainous terrain. The reason for the power loss was reported to be from an electrical malfunction of the ignition system.
- [NTSB NYC88LA017](https://openairdocs.org/ntsb/NYC88LA017.md): Piper J-4 · St. Paul, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1987 · N28205 · Substantial damage
  > The flight was enroute from mount pleasant to winchester, Virginia on a heading of 140 degrees and at 4500 feet. About 25-30 minutes into the flight, engine power loss was experienced. The pilot switched from the auxilliary to the main fuel tank and applied…
- [NTSB NYC88LA016](https://openairdocs.org/ntsb/NYC88LA016.md): Gulfstream American AA-5B · Barre, MA · Accident · No injuries · Limited investigation · Final report · Oct 25, 1987 · N333FG · Substantial damage
  > The aircraft was in the traffic pattern when it experienced a power loss. The plt made an off-airport landing in a wooded area. The pilot reported that he was in a slip prior to and at the time of the reported power loss. The FAA reported that the engine…
- [NTSB NYC88LA015](https://openairdocs.org/ntsb/NYC88LA015.md): Cessna 152 · Pepperell, MA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1987 · N310DW · Substantial damage
  > A student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…
- [NTSB MIA88LA018](https://openairdocs.org/ntsb/MIA88LA018.md): Bell 47J-2 · Key Colony Bch., FL · Accident · No injuries · Limited investigation · Final report · Oct 24, 1987 · N73201 · Substantial damage
  > The plt stated that he did not check the fuel system for contaminates after refueling but an eighteen minute flt after refueling was uneventful. He then landed the helicopter, remained on the ground aprx 20 minutes, performed a walk around insp, again without…
- [NTSB SEA88FA012](https://openairdocs.org/ntsb/SEA88FA012.md): Piper PA-28-180 · Colville, WA · Accident · 2 fatal · Field investigation · Final report · Oct 23, 1987 · N15653 · Destroyed
  > Although the recently certificated private pilot was not checked out by the fixed base operator for night flight and had been warned to return before sunset, he departed the airport during dark night conditions. Witnesses reported observing the aircraft climb…
- [NTSB LAX88FA020](https://openairdocs.org/ntsb/LAX88FA020.md): Cessna 208A · Fairfield, CA · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1987 · N828FE · Destroyed
  > Pilot's encounter with severe turbulence which precipitated a loss of aircraft control.
- [NTSB FTW88LA020](https://openairdocs.org/ntsb/FTW88LA020.md): Cessna 152 · New Caney, TX · Accident · No injuries · Limited investigation · Final report · Oct 23, 1987 · N4870P · Substantial damage
  > Acft took off in marginal VFR conditions on a pipeline patrol flt. En route, the plt encountered deteriorating wx conditions and experienced a rough running eng, due to what he suspected was carb ice. His attempts to remedy the roughness were unsuccessful and…
- [NTSB FTW88FA011](https://openairdocs.org/ntsb/FTW88FA011.md): Cessna 172M · Midway, TX · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1987 · N4357R · Destroyed
  > The plt (a co-owner) was on the 1st flt of the acft after its 150 HP Lycoming O-320 eng had been replaced with a 180 HP Lycoming O-360 eng. He took off at about 1115 CDT. The flt progressed w/o rprtd incident until 1437 CDT, when the plt stated the acft was…
- [NTSB FTW88FA009](https://openairdocs.org/ntsb/FTW88FA009.md): Cessna 172RG · Llano, TX · Accident · 2 fatal · Field investigation · Final report · Oct 23, 1987 · N9875B · Destroyed
  > The pilot departed lubbock, Texas in VFR conditions. As the flight progressed the ceiling and visibility deteriorated and the pilot encountered instrument meteorological conditions. No evidence was found to indicate that the pilot obtained a weather briefing…
- [NTSB CHI88FA010](https://openairdocs.org/ntsb/CHI88FA010.md): Smith, Ted Aerostar Aerostar 600 · Oshtemo Townshp, MI · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1987 · N554AC · Destroyed
  > The aircraft was at cruise altitude (9,000 feet) for approximately 20 minutes when the pilot reported the loss of right engine power. Chicago ARTCC reported the closest airport was kalamazoo, 28 miles west. The aircraft began to descend and at 0330:53 chicago…
- [NTSB ATL88LA021](https://openairdocs.org/ntsb/ATL88LA021.md): Cessna 172P · Swainsboro, GA · Accident · No injuries · Limited investigation · Final report · Oct 23, 1987 · N4946G · Substantial damage
  > The acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…
- [NTSB DEN88FA014](https://openairdocs.org/ntsb/DEN88FA014.md): Cessna 340A · Bailey, CO · Accident · 1 fatal · Field investigation · Final report · Oct 21, 1987 · N4132G · Destroyed
  > The aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…
- [NTSB CHI88FA008](https://openairdocs.org/ntsb/CHI88FA008.md): Cessna 310 · Brownton, MN · Accident · 4 fatal · Field investigation · Final report · Oct 20, 1987 · N57DS · Destroyed
  > Acft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…
- [NTSB SEA88LA010](https://openairdocs.org/ntsb/SEA88LA010.md): Cessna 150-M · Myrtle Creek, OR · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N7695U · Substantial damage
  > A loss of power occurred shortly after takeoff due to fuel exhaustion. A field was chosen for the off airport landing. During the landing rollout the aircraft struck a fence and raspberry bushes, collapsing the nose gear.
- [NTSB NYC88LA010](https://openairdocs.org/ntsb/NYC88LA010.md): Stinson 108-3 · Henryville, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1987 · N990C · Destroyed
  > On takeoff from a private airport, the flight encountered downdrafts and the left wing dropped. As the pilot attempted to level the wings, he realized that the aircraft was no longer climbing but descending at a rapid rate. The aircraft crashed on rising…
- [NTSB DEN88LA011](https://openairdocs.org/ntsb/DEN88LA011.md): Cessna R172K · Aspen, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1987 · N736KT · Destroyed
  > The plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…
- [NTSB BFO88LA004](https://openairdocs.org/ntsb/BFO88LA004.md): Beech 23 · Front Royal, VA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1987 · N2387Q · Substantial damage
  > While flying at abt 2000 ft AGL, the plt noticed a change in eng sound. The tach indcn dropped below 1000 RPM & the suction gauge went below the green arc. During a subsequent emerg lndg, the nose & left main gear collapsed in soft terrain. No preimpact part…
- [NTSB NYC88LA084](https://openairdocs.org/ntsb/NYC88LA084.md): Piper PA-12 · Hammondsport, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1987 · N7817H · Destroyed
  > Shortly after takeoff, the Piper PA-12 experienced a loss of power and made an off airport landing. During the landing, the aircraft impacted in a corn field. Examination of the aircraft did not disclose any malfunctions or mechanical failures. Auto fuel was…
- [NTSB ATL88LA015](https://openairdocs.org/ntsb/ATL88LA015.md): Piper PA-28R-200 · Homer, GA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N1547X · Substantial damage
  > The pilot reported a gradual decrease in power after reaching 4000 feet. The plt was unable to obtain a restart. He then elected to attempt a forced landing in a field. The aircraft collided with a tree prior to landing. The aircraft collided with and came to…
- [NTSB LAX88LA017](https://openairdocs.org/ntsb/LAX88LA017.md): Piper PA-24-260 · San Mateo, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1987 · N9097P · Substantial damage
  > While over the ocean, the pilot noted that the engine did not sound right and that the oil pressure indication had dropped to zero. Shortly afterward, the engine began to vibrate violently and seized. The pilot planned for a forced landing to an open field…

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

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

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