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

## Cases, newest first

- [NTSB ATL83FA230](https://openairdocs.org/ntsb/ATL83FA230.md): Grumman AA1 · Locust Grove, GA · Accident · Serious injuries · Field investigation · Final report · Jun 16, 1983 · N5941L · Substantial damage
  > The acft crashed during a forced landing after the engine quit while the flt was in cruise at 3000 ft. the pilot stated that he experienced what was described as a drop in oil pressure followed by a complete power failure. The pilot attempted a forced landing…
- [NTSB NYC83LA143](https://openairdocs.org/ntsb/NYC83LA143.md): Piper PA-32 · Marlboro, MA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N8167Y · Substantial damage
  > The acft ran off the end of the runway while making a precautionary landing due to weather. During the overrun the acft collided with a fence. The pilot was not injured.
- [NTSB DEN83LA139](https://openairdocs.org/ntsb/DEN83LA139.md): Piper PA-23 · Jamestown, ND · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N2054P · Destroyed
  > The acft landed wheels-up with one engine feathered and nosed over during the slide-out. The pilot had intentionally feathered the left engine to 'try out' the acft. The left engine has the only engine driven hydraulic pump. This pump isnecessary to lower…
- [NTSB DCA83AA030](https://openairdocs.org/ntsb/DCA83AA030.md): Meyers OTW · Woodbridge, VA · Accident · Minor injuries · Final report · Jun 14, 1983 · N26475 · Substantial damage
  > While en route at an altitude of aprx 2000 ft MSL, the plt noticed a definite loss of power & RPM, which was followed by a loss of oil pressure. He reversed course intending to land at an arpt that he had passed. A clattering noise was heard in the eng, which…
- [NTSB CHI83LA282](https://openairdocs.org/ntsb/CHI83LA282.md): Lombard Dilley 68 · Camp Douglas, WI · Accident · No injuries · Limited investigation · Final report · Jun 13, 1983 · N301LS · Substantial damage
  > The experimental acft lost a blade of its propeller during cruise flt. The propeller had been modified to obtain more RPM. About 18 inches of one blade separated during cruise at 6000 ft with 2900 RPM at 200 KTS airspeed. The engine remained attached to the…
- [NTSB NYC83LA139](https://openairdocs.org/ntsb/NYC83LA139.md): Aeronca 65-LB · Auburn, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1983 · N31772 · Substantial damage
  > According to the plt, he was en route when the eng lost power. He maneuvered for a forced landing in a nearby hay/corn field. During the flare, the eng regained power momentarily & lifted about 50 ft. at about the same time, the acft encountered wind gusts,…
- [NTSB MKC83FA127](https://openairdocs.org/ntsb/MKC83FA127.md): Piper PA-32-260 · Newton, IA · Accident · 2 fatal · Field investigation · Final report · Jun 12, 1983 · N5509V · Destroyed
  > The non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…
- [NTSB LAX83LA281](https://openairdocs.org/ntsb/LAX83LA281.md): Piper J3C-65 · Tuba City, AZ · Accident · No injuries · Limited investigation · Final report · Jun 12, 1983 · N42762 · Substantial damage
  > The pilot had landed in a river bed due to an encounter with and downdrafts while flying in canyons. Then a storm and flash flood threatened so he decided to takeoff. During takeoff roll a wing struck river rocks.
- [NTSB FTW83LA274](https://openairdocs.org/ntsb/FTW83LA274.md): Hughes 369D · S. Padre Island, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1983 · N58258 · Substantial damage
  > The helicopter made a hard touchdown during a precautionary landing after the plt felt a tail rotor vibration. The landing was made on a beach and the touchdown collapsed the left side of the landing gear cross tube. This separated thetail boom. Examination…
- [NTSB FTW83IA279](https://openairdocs.org/ntsb/FTW83IA279.md): Aerospatiale AS 355 F · High Island 582 · Incident · No injuries · Incident investigation · Final report · Jun 12, 1983 · N5796A · No damage
  > Acft developed a severe vertical vibration and made a precautionary landing. Fatigue cracks were found which originated in a corrosion pit located in an area of chipped paint which had been covered with a coat of primer contrary to Aerospatiale service…
- [NTSB CHI83LA252](https://openairdocs.org/ntsb/CHI83LA252.md): Piper PA-12 · Blackduck, MN · Accident · No injuries · Limited investigation · Final report · Jun 12, 1983 · N2487M · Substantial damage
  > The acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…
- [NTSB SEA83LA122](https://openairdocs.org/ntsb/SEA83LA122.md): Bell 47G-2 · Zillah, WA · Accident · No injuries · Limited investigation · Final report · Jun 11, 1983 · N41721 · Substantial damage
  > The rotorcraft made a hard landing after colliding with trees during an autorotation. The acft had experienced an enginefailure while on a repositioning flight between aerial application operations and was forced to land. The acft was autorotated into an…
- [NTSB LAX83FA279](https://openairdocs.org/ntsb/LAX83FA279.md): Beech 95-B55 · Van Nuys, CA · Accident · 2 fatal · Field investigation · Final report · Jun 11, 1983 · N6610K · Destroyed
  > The acft crashed in a residential area after a loss of control by the plt. The acft was climbing through an overcast in IFR conditions and last reported 'four' in response to a request for altitude. This was the last radio transmission received from the flt.…
- [NTSB LAX83LA278](https://openairdocs.org/ntsb/LAX83LA278.md): Piper PA-25 · New River, AZ · Accident · No injuries · Limited investigation · Final report · Jun 10, 1983 · N6073Z · Substantial damage
  > The pilot stated that he refueled his aircraft and secured the gas cap after which he made four fifteen minutes aero tow flights. During the fifth aero tow, as the aircraft was climbing, the pilot heard an object strike the wind shield and he saw that the gas…
- [NTSB LAX83FA277](https://openairdocs.org/ntsb/LAX83FA277.md): Bell 212 · Goleta, CA · Accident · 2 fatal · Field investigation · Final report · Jun 10, 1983 · N59636 · Substantial damage
  > The plt stated that as he approached the oil rig & reduced power to start his descent from 500 ft, the tail rotor (t/r) pedals began to vibrate. The vibrations became worse with a further reduction of power to reduce airspeed. The plt then planned a descent…
- [NTSB CHI83FU003](https://openairdocs.org/ntsb/CHI83FU003.md): Sunburst 1 · Fraser, MI · Accident · Serious injuries · Final report · Jun 9, 1983 · UNREG · Destroyed
  > A witness reported that this ultralight was 1 of 3 that took off on rwy 18, then turned 180 deg to a northerly heading. He reported that the ultralight was in level flt at aprx 200 ft when it suddenly pitched nose down, then it nosed up. At about that time,…
- [NTSB ATL83LA225](https://openairdocs.org/ntsb/ATL83LA225.md): Air Tractor AT-301 · Fort Valley, GA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1983 · N5071S · Substantial damage
  > The eng quit at 200 ft AGL as the plt was returning to a strip. A forced landing was made in a wheat field & the acft rolled through a narrow tree line. The carb float was found cracked & leaking.
- [NTSB SEA83FYM06](https://openairdocs.org/ntsb/SEA83FYM06.md): Cessna T210L · Hermiston, OR · Accident · Serious injuries · Final report · Jun 8, 1983 · N393AC · Substantial damage
  > The acft stalled into the ground in a semi-controlled crash forced landing after the engine quit due to fuel exhaustion.a post accident examination revealed only one ounce of fuel aboard the acft. The acft release form from Boeing aircraft to the pilot for…
- [NTSB SEA83FA118](https://openairdocs.org/ntsb/SEA83FA118.md): Piper PA28RT-201T · Gov'T Camp, OR · Accident · 4 fatal · Field investigation · Final report · Jun 8, 1983 · N8402P · Destroyed
  > Wx conditions along the flt route indicated ceilings of 25,000 ft & unrestricted visibility except for the area south & west of mount hood. Mount hood, elevation 11,239 ft MSL, on the sw side of government Camp & clear lake (accident site),was covered by…
- [NTSB DEN83LA135](https://openairdocs.org/ntsb/DEN83LA135.md): Cessna TU206G · Molina, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1983 · N732ZQ · Substantial damage
  > The pilot had leveled off at 17500 ft MSL when the engine made a detonating sound and lost power. Manifold pressure went to about 12 inches. Fuel pressure was normal but the cylinder head temperature fell rapidly. At 9000 ft MSL the engine surged to about 16…
- [NTSB DCA83AA029](https://openairdocs.org/ntsb/DCA83AA029.md): Lockheed 188C · Cold Bay, AK · Accident · No injuries · Final report · Jun 8, 1983 · N1968R · Substantial damage
  > During a cruise climb, the aircrew noted an unusual vibration; however, attempts to isolate the vibration were unsuccessful. While climbing from FL190 to FL250, the flt engineer went aft to observe the engs & props, but noted nothing unusual. A flt attendant…
- [NTSB SEA83LA117](https://openairdocs.org/ntsb/SEA83LA117.md): Cessna 150H · Yakima, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1983 · N22670 · Substantial damage
  > The acft nosed over during an off airport forced landing. The student pilot had checked with her father and flight instructor for her cross-country flight. Her father supplied information on the fuel supply and the student and instructor used this information…
- [NTSB LAX83FA266](https://openairdocs.org/ntsb/LAX83FA266.md): Enstrom F28C · Mesa, AZ · Accident · Serious injuries · Field investigation · Final report · Jun 7, 1983 · N51684 · Destroyed
  > The pilot had taken off, went into a normal hover, then traveled about 200 feet for a pattern climb-out when he radioed the tower that the acft did not feel right. The acft started to fishtail. The pilot tried to autorotate but could not stop the rate of…
- [NTSB ANC83FA090](https://openairdocs.org/ntsb/ANC83FA090.md): Cessna 185-E · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 6, 1983 · N1693M · Substantial damage
  > The acft was damaged in a forced landing after a loss of power in cruise flt. The pilot said he checked the throttle position then advanced it with no reaction. The pilot declared an emergency on frequency 121.5 the emergency fuel pump was turned on but…
- [NTSB MIA83FA152](https://openairdocs.org/ntsb/MIA83FA152.md): Piper PA-32-260 · Sebastian, FL · Accident · 6 fatal · Field investigation · Final report · Jun 5, 1983 · N4724S · Destroyed
  > During the flt, the plt contacted vero beach tower & requested the wx. He was advised that vero beach & ft pierce, FL were VFR, but there was wx north of vero beach, a convective SIGMET was in effect & there were thunderstorms in the area. The plt…
- [NTSB LAX83LA285](https://openairdocs.org/ntsb/LAX83LA285.md): Cessna 150F · Porterville, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1983 · N828OS · Substantial damage
  > The acft nosed over during an off arpt forced landing after power loss. The pilot stated that they were in flt cruise AT3500 ft MSL when the engine lost power. Full carburetor heat was applied and power increased after 5 seconds from 700 RPM to 2500 RPM. The…
- [NTSB LAX83LA262](https://openairdocs.org/ntsb/LAX83LA262.md): Mcdonnell Douglas DC-10-10 · Yuma, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1983 · N68043 · No damage
  > During cruise flight the acft experienced a pitch excursion up then down while in autopilot on operation. A cracked strain gage bridge wire was found in the electrical system.
- [NTSB FTW83LA264](https://openairdocs.org/ntsb/FTW83LA264.md): Piper PA-25-235 · Rio Grande City, TX · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N8533L · Destroyed
  > The acft was destroyed by fire during an emergency landing. Shortly after depature the acft cockpit filled with heavy smoke. The plt attempted to return to the arpt but could not because of the heavy smoke in the cockpit. Efforts to eliminate it were…
- [NTSB FTW83LA263](https://openairdocs.org/ntsb/FTW83LA263.md): Piper PA-34-200 · Texarkana, AR · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N57328 · Substantial damage
  > The acft landed short of the rwy and the landing gear collapsed during a night landing. Electrical failure occurred on the acft shortly after takeoff. When elect recal power could not be restored the plt elected to return to Texarkana and land using VASI. The…
- [NTSB ATL83FA215](https://openairdocs.org/ntsb/ATL83FA215.md): Cessna 172N · Franklin, TN · Accident · Serious injuries · Field investigation · Final report · Jun 5, 1983 · N6429F · Destroyed
  > The plt stated that aprx 45 min after takeoff, he smelled an odor like something burning,then noted a loss of power. He stated that the eng did not quit, but had lost power to about the 1000 RPM range. Also, he stated that the oil pressure dropped to about 10…
- [NTSB SEA83LA136](https://openairdocs.org/ntsb/SEA83LA136.md): Snow S2C · Hepner, OR · Accident · No injuries · Limited investigation · Final report · Jun 3, 1983 · N1665S · Substantial damage
  > The acft slid sideways on a sloping field during a forced landing and damaged a wing. The pilot said he had sprayed two fields and was enroute to spray another when a complete loss of power occurred. The pilot stated that he found no usablefuel in either fuel…
- [NTSB DEN83FA131](https://openairdocs.org/ntsb/DEN83FA131.md): Aero Commander 680FL · Monticello, UT · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1983 · N271VT · Destroyed
  > The acft crashed while doing magnetometer surveys at low altitude. The right engine had lost power then regained it for a short period and lost it again. A videotape in the acft recorded the plt saying, 'I changed that # just in time.' The acft yawed and the…
- [NTSB DCA83AA028](https://openairdocs.org/ntsb/DCA83AA028.md): Douglas DC-9-32 · Covington, KY · Accident · 23 fatal · Final report · Jun 2, 1983 · CFTLU · Substantial damage
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…
- [NTSB MIA83LA151](https://openairdocs.org/ntsb/MIA83LA151.md): Piper PT 6A-28 · W. Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1983 · N831PC · Destroyed
  > While on an over water flt, both engs lost power & the plt ditched the acft at sea. Before ditching, the plt reported that the acft was out of fuel, the ATC controller contacted a us coast guard helicopter that was on his frequency & requested assistance. The…
- [NTSB ANC83IA089](https://openairdocs.org/ntsb/ANC83IA089.md): Boeing Vertol 234ER · Mekoryuk, AK · Incident · No injuries · Incident investigation · Final report · Jun 1, 1983 · N234BV · No damage
  > While climbing in IFR conditions after takeoff, the #1 eng lost power. The plt dumped fuel & landed on an oil exploration platform. While dumping fuel, the #1 jettison sys operated normally, but the ciruit breaker popped on the #2 sys. The aircrew reset the…
- [NTSB LAX83LA263](https://openairdocs.org/ntsb/LAX83LA263.md): Piper PA-28-181 · Molokai, HI · Accident · No injuries · Limited investigation · Final report · May 31, 1983 · N31914 · Substantial damage
  > The pilot had just been checked out in a C-172 which he had been flying the past 3 days. He then switched acft and this flt was in a PA-28. The C-172 tank selector has a both tanks position and the PA-28 does not. The tank selector was on left tank when the…
- [NTSB DEN83FA129](https://openairdocs.org/ntsb/DEN83FA129.md): Cessna 182 · Colorado Sprgs, CO · Accident · No injuries · Field investigation · Final report · May 31, 1983 · N735FW · Substantial damage
  > The acft made a controlled hard emergency landing in an open field off airport after an encounter with icing. The pilot was making a turn during an instrument approach procedure and felt the acft begin to stall and buffet and slow in its response to roll. He…
- [NTSB SEA83FA115](https://openairdocs.org/ntsb/SEA83FA115.md): Cessna 180J · North Bend, WA · Accident · 1 fatal · Field investigation · Final report · May 30, 1983 · N42917 · Destroyed
  > The plt had requested a VFR departure eastbound to waterville & radar flt following. He stated he would be going VFR through stampede pass. After takeoff the acft was tracked on a radar heading of ene at an altitude of 2,500 ft MSL. Shortly thereafter the plt…
- [NTSB MKC83LA118](https://openairdocs.org/ntsb/MKC83LA118.md): Gulfstream American AA1A · Wichita, KS · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N9284L · Substantial damage
  > Prior to the flt to Wichita, the plt received a local night checkout with a CFI at olathe. The flt then departed olthe a 2030. As the plt began his descent for a landing at witchita mid-continent arpt the eng quit. He was given a vector tocol. James jabara…
- [NTSB LAX83LA254](https://openairdocs.org/ntsb/LAX83LA254.md): Cessna 210 · Winslow, AZ · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N7369E · Substantial damage
  > While en route at 10,000 ft MSL, the #3 cylinder, piston & rod separated from the eng & departed thru the cowling. The plt said that although the oil left the eng rapidly, he was able to maintain partial power for aprx 12 mins. During that time, he was able…
- [NTSB FTW83FA254](https://openairdocs.org/ntsb/FTW83FA254.md): Piper PA-28-180 · Haskell, TX · Accident · 5 fatal · Field investigation · Final report · May 30, 1983 · N5170S · Destroyed
  > The acft crashed while on a flt in an area where thunderstorm warnings were in effect. There were no known witnesses to the actual crash, but 2 or 3 local residents heard an acft eng at about the estimated time of the accident. One resident about 1/4 mi from…
- [NTSB DEN83FTE03](https://openairdocs.org/ntsb/DEN83FTE03.md): Balloon Works Firefly 7 · Del Norte, CO · Accident · Serious injuries · Final report · May 30, 1983 · N1516S · No damage
  > While circumnavigating snow showers at night in mountainous terrain the plt elected to make a precautionary landing on a highway. The acft struck trees on a hillside that the plt hadn't seen in the darkness.
- [NTSB DEN83FA123](https://openairdocs.org/ntsb/DEN83FA123.md): Piper 24-180 · Horse Creek, WY · Accident · 1 fatal · Field investigation · Final report · May 30, 1983 · N7079P · Destroyed
  > The acft crashed in rolling terrain minus about 6 ft of its left wing. This portion of wing was found about 339 ft east of the main wreckage. Exam revealed evidence that the outboard portion of the wing separated in an upward and aft direction indicative of…
- [NTSB MIA83FA148](https://openairdocs.org/ntsb/MIA83FA148.md): Piper PA-32-260 · Lake Butler, FL · Accident · Serious injuries · Field investigation · Final report · May 29, 1983 · N43499 · Destroyed
  > At 0953 EDT, the plt departed on an IFR flt with full fuel tanks. The left main fuel tank was used for aprx 1 hr, then the right main was selected. Just before starting a descent, while still using the right main tank, the eng quit. The plt switched fuel…
- [NTSB LAX83LA258](https://openairdocs.org/ntsb/LAX83LA258.md): Cessna 150M · Phelan, CA · Accident · No injuries · Limited investigation · Final report · May 29, 1983 · N3437V · Substantial damage
  > The student plt departed ramona, CA on a flt to palomar, CA where he planned to refuel. He reported that he missed the 'palomar turn off', and thereafter, flew to hesperia, CA & landed. No fuel was available at hesperia. The fuel gauges indicated there still…
- [NTSB ATL83LA222](https://openairdocs.org/ntsb/ATL83LA222.md): Cessna 182F · Tallassee, AL · Accident · Minor injuries · Limited investigation · Final report · May 28, 1983 · N3112U · Substantial damage
  > As the student jumper was getting out of the aircraft and onto the step in preparation for a parachute jump the pack tray prematurely opened and the canopy blossomed under the tail pulling the jumper into the horizontal stabilizer causing a cut on his left…
- [NTSB MKC83IA116](https://openairdocs.org/ntsb/MKC83IA116.md): Lockheed L-1011-385-1 · Kansas City, MO · Incident · No injuries · Incident investigation · Final report · May 27, 1983 · N11006 · Minor damage
  > During descent an electric wire bundle shorted behind the flight engineers panel, a fire erupted with smoke. The flight engineer used a portable fire extinguisher to put out the fire.
- [NTSB LAX83FA253](https://openairdocs.org/ntsb/LAX83FA253.md): Piper PA-28-151 · Norco, CA · Accident · 1 fatal · Field investigation · Final report · May 27, 1983 · N54363 · Destroyed
  > The student plt had flown to the riverton arpt to attend a ground school. Reportedly, prior to his departure at aprx 2235 PDT, stars were visible overhead, but the horizontal visibility was poor & there was a haze layer at about 500 ft AGL. At aprx 2250, a…
- [NTSB DEN83LA121](https://openairdocs.org/ntsb/DEN83LA121.md): Piper PA-22-150 · Ennis, MT · Accident · Minor injuries · Limited investigation · Final report · May 27, 1983 · N9975D · Substantial damage
  > During a night flight, oil began spreading over the windshield & heavy smoke came in the cockpit through the cabin heater. The plt opened the cabin windows, reduced power & turned back toward the arpt. The oil pressure dropped to 5 PSI & the plt descended to…
- [NTSB NYC83FA125](https://openairdocs.org/ntsb/NYC83FA125.md): Piper PA-28-140 · Haines Falls, NY · Accident · 1 fatal · Field investigation · Final report · May 26, 1983 · N1316T · Destroyed
  > On the previous day, the plt had flown to poughkeepsie, NY. Before he departed on the retrun trip, the manager of a flt school informed him that the wx was bad; however, he took off at about 0912 EDT. While enroute, the acft collided with trees near the top…

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

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

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