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

## Cases, newest first

- [NTSB SEA84LA079](https://openairdocs.org/ntsb/SEA84LA079.md): Piper PA28-140 · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N1436X · Substantial damage
  > The student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…
- [NTSB LAX84LA242](https://openairdocs.org/ntsb/LAX84LA242.md): Cessna 210 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N9889M · Substantial damage
  > The acft had a hydraulic line failure during an attempt to lower the landing gear. The hydraulic fluid was lost and a gear up landing was made. The retaining ring of the main door actuator had failed allowing the piston to pop out of the actuator. There was a…
- [NTSB MIA84FU003](https://openairdocs.org/ntsb/MIA84FU003.md): Pterodactyl Ascender II · Palm Bay, FL · Accident · 1 fatal · Final report · Apr 1, 1984 · UNREG · Destroyed
  > The plts of 2 ultralight vehicles were accompanying each other & were flying west at 500 ft AGL in calm air when an acft crossed ahead of their flt path. The acft was estimate to be flying at about 140 KTS & aprx 40 ft above the ultralights' alt. The…
- [NTSB FTW84LA179](https://openairdocs.org/ntsb/FTW84LA179.md): Cessna U206G · Lake Charles, LA · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1984 · N7383N · Substantial damage
  > The acft hit a tree and a ditch during a forced landing on a road after the engine lost power. Examination of the engineafter the accident revealed that the throttle rod had disconnected from the throttle control arm at the bolt hole. The hole had worn…
- [NTSB FTW84FA180](https://openairdocs.org/ntsb/FTW84FA180.md): Cessna 210-5(205) · Beaumont, TX · Accident · 4 fatal · Field investigation · Final report · Apr 1, 1984 · N8150Z · Destroyed
  > The acft was flown into IMC wx after the flt had been advised by the wx service that VFR flt was barely feasible. No wx briefing by FAA was recorded & no flt plan was filed. The accident occurred during the hrs of darkness. A witness near the accident site…
- [NTSB DEN84FA122](https://openairdocs.org/ntsb/DEN84FA122.md): Cessna 414A · Douglas, WY · Accident · Serious injuries · Field investigation · Final report · Apr 1, 1984 · N414EM · Substantial damage
  > During an approach for a downwind landing, the acft stalled & impacted the ground 192 ft short of rwy 28. The plane had encountered icing conditions during flt & ice was still adhering to the acft as the plt made an approach for landing. Instrument conditions…
- [NTSB MKC84FA115](https://openairdocs.org/ntsb/MKC84FA115.md): Piper PA-28R-200 · Garden City, KS · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1984 · N40846 · Destroyed
  > The plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…
- [NTSB FTW84LA187](https://openairdocs.org/ntsb/FTW84LA187.md): Owen Robert R Quickie 2 · Ponder, TX · Accident · No injuries · Limited investigation · Final report · Mar 31, 1984 · N419Q · Substantial damage
  > The plt reported that he had a loss or power & the acft flipped over during an emergency landing in a wheat field. The acft owner stated the loss of power was because of fuel mismanagement.
- [NTSB SEA84LA075](https://openairdocs.org/ntsb/SEA84LA075.md): Cessna T210N · Seaside, OR · Accident · No injuries · Limited investigation · Final report · Mar 30, 1984 · N7972N · Substantial damage
  > The acft nosed over during a forced landing in a soft field after a loss of power. The plt said that while the acft was descending thru about 6000 ft MSL, he ran the left fuel tank dry before switching tanks. His attempt to restart the engine, using the right…
- [NTSB ATL84IA135](https://openairdocs.org/ntsb/ATL84IA135.md): Piper PA-28R-200 · Clayton, NC · Incident · No injuries · Incident investigation · Final report · Mar 30, 1984 · N4999S · Minor damage
  > During flt, the plt & a passenger noted a loss of eng power accompanied by a metallic sound. Subsequently, a wheels-up forced landing was made in a plowed field. An eng teardown revealed that the crankshaft, p/n 54297-1, had failed from fatigue. A…
- [NTSB LAX84LA236](https://openairdocs.org/ntsb/LAX84LA236.md): Cessna 152 · Escalon, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N757RU · Substantial damage
  > The acft was damaged during a forced landing. The acft collided with trees and nosed down. Post accident examination of the acft showed 1 gallon of fuel on board the acft. The flt had lasted 3 and 1/3 hours. The endurance of a Cessna 152 under the stated…
- [NTSB LAX84LA233](https://openairdocs.org/ntsb/LAX84LA233.md): Piper PA-28 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N82858 · Substantial damage
  > The acft was ditched in san pablo bay following a power loss during x-country cruise flt. The plt admitted 'to running out of fuel.'
- [NTSB FTW84LA188](https://openairdocs.org/ntsb/FTW84LA188.md): Cessna 150L · New Boston, TX · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N11273 · Substantial damage
  > The non-rated plt/owner was flying at night when he noticed that the fuel quanity was low. About 15 mins later, the eng lost power from fuel exhaustion. During an emergency night landing, the acft struck several tree stumps & was damaged. Police officers…
- [NTSB DEN84LA112](https://openairdocs.org/ntsb/DEN84LA112.md): Cessna 175 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N7270M · Substantial damage
  > After takeoff, the eng began to smoke & lose power. During a forced landing in a muddy plowed field, the acft nosed over. A compression check was accomplished & the #5 cylinder was found to have zero compression. The cylinder was removed & found to be cracked…
- [NTSB ATL84IA134](https://openairdocs.org/ntsb/ATL84IA134.md): Beech C90 · Herndon, VA · Incident · No injuries · Incident investigation · Final report · Mar 29, 1984 · N66KA · Minor damage
  > The acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…
- [NTSB ATL84FLT07](https://openairdocs.org/ntsb/ATL84FLT07.md): Weatherly 201C · South Fulton, TN · Accident · No injuries · Final report · Mar 29, 1984 · N1296W · Substantial damage
  > Five miles after takeoff the acft engine began sputtering and losing power. The plt dumped his load and still could not maintain flight. The acft could not be stopped before colliding with fence and trees during a downwind landing on wet pasture grass.…
- [NTSB MIA84FA122](https://openairdocs.org/ntsb/MIA84FA122.md): Cessna 402C · Mineral Springs, FL · Accident · 4 fatal · Field investigation · Final report · Mar 27, 1984 · N620AC · Destroyed
  > The acft collided with trees and the ground during flt in adverse weather. There is no record of the plt receiving a pre-flt briefing and no flt plan was filed. Witnesses heard an acft flying low followed by a loud thud. About 16 mi north at sarasota, FL, the…
- [NTSB FTW84LA178](https://openairdocs.org/ntsb/FTW84LA178.md): Piper PA-32-301T · Haskell, TX · Accident · No injuries · Limited investigation · Final report · Mar 27, 1984 · N8194E · Substantial damage
  > The plt received a wx briefing and said, 'today was not the day to go', but later went. En route weather encouraged him to land at an arpt with a 1600 ft rwy with winds of 30 KTS gusting to 50 KTS, according to a witness. The plt landedwith no flaps and…
- [NTSB FTW84LA174](https://openairdocs.org/ntsb/FTW84LA174.md): Cessna 150M · Bryan, TX · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N6494K · Destroyed
  > The eng lost power from fuel exhaustion before the plt reached his final destination. During a subsequent emergency landing at night the acft collided with a fence as it was touching down. The plt stated that he estimated there was 1.5 gals of usable fuel on…
- [NTSB CHI84LA140](https://openairdocs.org/ntsb/CHI84LA140.md): Cessna 182L · New Hudson, MI · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N42855 · Substantial damage
  > Shortly after leveling off at 3000 ft the cabin of the acft filled with smoke and the acft lost all oil pressure. Shortly after this the engine quit. During the forced landing in a corn field the acft nosed over. During a post accident investigation it was…
- [NTSB NYC84LA116](https://openairdocs.org/ntsb/NYC84LA116.md): Cessna 336 · Hogansburg, NY · Accident · No injuries · Limited investigation · Final report · Mar 24, 1984 · N1711Z · Substantial damage
  > The acft nosed down in a soggy muddy field during a forced landing. The plt reported a power loss on the rear eng and when attempts to restart were unsuccessful made the forced landing into a soggy muddy field.
- [NTSB DEN84FTG01](https://openairdocs.org/ntsb/DEN84FTG01.md): Lee M. Brown Taterbug SB-1 · Sawyer, ND · Accident · No injuries · Final report · Mar 22, 1984 · N9026T · Substantial damage
  > The plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…
- [NTSB MKC84FA106](https://openairdocs.org/ntsb/MKC84FA106.md): Beech B36 · Webb City, MO · Accident · 2 fatal · Field investigation · Final report · Mar 20, 1984 · N6665X · Destroyed
  > The plt was advised by springfield tower that icing conditions existed along his proposed route of flt. However, he elected to takeoff, & about 4 min later, the plt advised that he had encountered rime ice. He continued the flt to joplin, picking up more ice…
- [NTSB ATL84LA125](https://openairdocs.org/ntsb/ATL84LA125.md): Hughes 269 · Supply, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 1984 · N8782F · Substantial damage
  > The plt and passg stated that as the flt approached Supply, NC, the wx conditions deterioriated and the helicopter encountered a fog bank. The passg recalled that the visibility reduced completely and visual contact with the ground was lost. The plt decided…
- [NTSB MKC84FA110](https://openairdocs.org/ntsb/MKC84FA110.md): Piper PA-28-181 · Gasconade, MO · Accident · 2 fatal · Field investigation · Final report · Mar 19, 1984 · N30667 · Destroyed
  > The plt landed at an arpt where, by his own description, the wx was near zero in rain. He then received 2 wx briefings. During the 1st briefing the plt indicated that he could make the flt IFR. The plt was advised of a SIGMET for severe icing conditions at…
- [NTSB MIA84LA118](https://openairdocs.org/ntsb/MIA84LA118.md): Cessna 310C · Key West, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 19, 1984 · N12T · Destroyed
  > While en route, the plt had switched from the main tanks to the aux tanks, then back to the main tanks. About 10 min later, both engs lost power. He was able to restart the right eng, but it lost power again. Subsequently, he ditched the acft at sea. Both…
- [NTSB LAX84LA223](https://openairdocs.org/ntsb/LAX84LA223.md): Cessna 152 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N68159 · Substantial damage
  > The acft was landed on a highway during a forced landing following a power loss. About 1 quart of fuel was drained from the acft after the accident.
- [NTSB ATL84LA124](https://openairdocs.org/ntsb/ATL84LA124.md): Cessna 172 · Flemingburg, KY · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N6870X · Substantial damage
  > According to the plt, the flt was about 12 miles from the airport at 2000 ft when the engine failed. The plt establishedan emerg descent to an open field, ran through a small pond and flipped inverted. Investigation revealed wx conditions conducive to…
- [NTSB ATL84FKG07](https://openairdocs.org/ntsb/ATL84FKG07.md): Cessna 172P · Atlanta, GA · Accident · No injuries · Final report · Mar 19, 1984 · N53655 · Substantial damage
  > The plt was having trouble with his radios, electrical system, fuel/eng gages & ammeter, so he turned off his electrical equipment & prepared to make an emergency landing. Because he was afraid of fuel exhaustion, his spacing behind another acft in the…
- [NTSB MIA84LA115](https://openairdocs.org/ntsb/MIA84LA115.md): Bengtson Swallow B · Belleview, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 1984 · N3261E · Substantial damage
  > The homebuilt acft crashed after experiencing an eng failure in cruise flight. The plt reported that he turned the acft to avoid cows in a pasture and the wing hit the ground. The reason for eng failure was not determined.
- [NTSB LAX84LA222](https://openairdocs.org/ntsb/LAX84LA222.md): Vari EZE · Rancho, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1984 · N3VE · Substantial damage
  > The acft made a forced landing and collided with a ditch after propeller failure during climb after takeoff. The plt hadmade his propeller of fiberglass instead of recommended wood. This was the first flt with this propeller.
- [NTSB CHI84LA132](https://openairdocs.org/ntsb/CHI84LA132.md): Cessna 337A · Genesee, WI · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 1984 · N6271F · Substantial damage
  > The acft made a forced landing after the engine lost power. The acft was inspected after the accident and found to contain no usable fuel. When the fuel was drained from the auxiliary tanks, the fuel quantity indicators showed five gallons in each tank.
- [NTSB ATL84LKG06](https://openairdocs.org/ntsb/ATL84LKG06.md): Homebuilt Dragon FLY 294 · Franklin, GA · Accident · No injuries · Final report · Mar 16, 1984 · N83WH · Substantial damage
  > The Homebuilt acft with 3 persons aboard lost its propeller after the crankshaft failed during cruise. A forced landing was executed on a state highway. The plt said he lost directional control at about 30 mph and contacted a ditch and two fence posts. The…
- [NTSB SEA84FA071](https://openairdocs.org/ntsb/SEA84FA071.md): Piper PA-28RT-201T · Humphrey, ID · Accident · 1 fatal · Field investigation · Final report · Mar 15, 1984 · N29033 · Destroyed
  > While on a x-country flt, the acft entered an area of rising terrain & blowing snow & the plt initiated a turn to reverse direction. During the turn, he encountered reduced visibility & the acft collided with the top of a knoll on snow covered rolling…
- [NTSB MKC84LA102](https://openairdocs.org/ntsb/MKC84LA102.md): Hiller UH-12B · Ulysses, KS · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N1021Y · Substantial damage
  > The plt made an autorotative precautionary landing after feeling vibrations in the anti-torque pedals. The acft was turned into the wind but landed hard in a field. The plt upon exiting the acft found the anti-torque rotor and gearbox missing. They were found…
- [NTSB MIA84LA111](https://openairdocs.org/ntsb/MIA84LA111.md): Cessna U206F · Arecibo, PR · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N51032 · Substantial damage
  > The plt related that the flt dept st croix with 28 gal of fuel aboard. In the vicinity of arecilo, PR the eng lost power. Examination of the fuel tanks showed more than 8 gal of fuel but 'the fuel bladder trapped the fuel from flowing into the engine.
- [NTSB MIA84LA110](https://openairdocs.org/ntsb/MIA84LA110.md): Shark BI-PLANE · Winter Garden, FL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N67SC · Substantial damage
  > The acft crashed during a forced landing after the engine quit. The plt said the power loss was due to fuel exaustion. He stated that when the tanks were full when he departed savannah and a siphon effect might have been created accountingfor the loss of…
- [NTSB FTW84LA168](https://openairdocs.org/ntsb/FTW84LA168.md): Cessna 172P · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 1984 · N54647 · Substantial damage
  > The non-instrument rated plt departed dallas, TX, and was on a VFR flight plan to Houston gulf port arpt. Unable to landthere due to wx, the plt requested ATC vectors to Houston intercontinental (iah). Iah ATC gave the plt vectors for an ILS apch to rwy 08.…
- [NTSB DEN84FA106](https://openairdocs.org/ntsb/DEN84FA106.md): Aerospatiale SA-316B · Story, WY · Accident · Serious injuries · Field investigation · Final report · Mar 13, 1984 · N8655 · Substantial damage
  > On the day prior to the accident, the plt noted that the fuel gage indicated 30 to 35 gal remaining. He added 40 gal & made a flt of about 15 min. On the next day, he noted that the gage indicated about 40 gal of fuel remaining. The reported fuel consumption…
- [NTSB SEA84FA068](https://openairdocs.org/ntsb/SEA84FA068.md): Piper PA-28RT-201 · Hood River, OR · Accident · 6 fatal · Field investigation · Final report · Mar 12, 1984 · N8301T · Destroyed
  > After crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…
- [NTSB MIA84LA107](https://openairdocs.org/ntsb/MIA84LA107.md): Cessna 210N · Lacrosse, FL · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N6006P · Substantial damage
  > The plt reported that the right fuel tank went dry when the fuel gage indicated it had 6 gal remaining. He switched fuel tanks, & shortly thereafter, the left tank emptied when the gage indicated it had 13 gal remaining. He tried to land in a pasture, but was…
- [NTSB MIA84LA105](https://openairdocs.org/ntsb/MIA84LA105.md): Cessna 150 · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1984 · N704WZ · Substantial damage
  > While on a flt to lakeland, FL, the plt elected to divert to Ocala, FL, when his fuel gages indicated that each fuel tank was about 1/4 full. However, before landing, the eng lost power. The plt selected an open field for an emergency landing, but stated he…
- [NTSB MIA84FA104](https://openairdocs.org/ntsb/MIA84FA104.md): Gross Benson B-8M · Sanford, FL · Accident · 1 fatal · Field investigation · Final report · Mar 12, 1984 · N3154A · Destroyed
  > The student plt & the plts of 2 other benson gyrocopters took off from a private strip & proceeded to fly in a loose formation. The plts of the other 2 gyrocopters did not witness the accident, but noticed that 1 of the 3 was missing. Witnesses on the ground…
- [NTSB FTW84LA161](https://openairdocs.org/ntsb/FTW84LA161.md): American AA-1A · Smithville, TX · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N9460L · Substantial damage
  > The pvt non-instrument plt received two wx briefings for his route of flt from madison, MS, to lufkin, TX, to college station, TX, to san antonio, TX. The last briefing from college station fss informed the plt that marginal VFR conditions exsisted along the…
- [NTSB DEN84FA223](https://openairdocs.org/ntsb/DEN84FA223.md): Cessna 310H · Questa, NM · Accident · 3 fatal · Field investigation · Final report · Mar 12, 1984 · N1111Q · Destroyed
  > The acft collided with rising terrain at the 12500 ft level. The summit was about 200 ft above the crash site. A friend of the plt was interviewed by the iic from NTSB. This friend was the host of the 3 accident victims for the weekend at his gunnison ranch.…
- [NTSB FTW84LA167](https://openairdocs.org/ntsb/FTW84LA167.md): Cessna 150G · Kingsville, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1984 · N3337J · Destroyed
  > While flying over a water basin the plt and pax both stated they felt an updraft. They said that they next remember climbing out of the acft which was inverted and under water.
- [NTSB MIA84LA102](https://openairdocs.org/ntsb/MIA84LA102.md): Piper J-3 · Indian Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N88168 · Substantial damage
  > During a banner towing operation, the plt descended from 1200 ft to 500 to tow over water near a Beach. When he advanced the throttle to level off there was no response to throttle movement. The eng continued operating at about 1500 RPM. Subsequently, he…
- [NTSB LAX84LA213](https://openairdocs.org/ntsb/LAX84LA213.md): Cessna 172M · Lebec, CA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N880LS · Destroyed
  > In a preliminary oral statement, the plt said that they encountered an unforcasted overcast & rising mountainous terrain. Later, she stated they were trying to maintain VFR flt in mountains with scattered clouds in the area; then when they were initiating a…
- [NTSB FTW84IA160](https://openairdocs.org/ntsb/FTW84IA160.md): Boeing 727-23 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Mar 10, 1984 · N1993 · Minor damage
  > The crew stated that while at FL370, the cabin alt began to climb. An emergency descent was initiated & after landing the passengers deplaned in a normal manner. Investigation revealed a 9X18' hole in the fuselage about 3 ft foward of the acft cargo door.…
- [NTSB NYC84FA189](https://openairdocs.org/ntsb/NYC84FA189.md): Taylorcraft BC12-D · South Paris, ME · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1984 · N95040 · Destroyed
  > Before the accident, the plt was last seen on 3/9/84 at 1530 EST & had not expressed any intentions of flying. At 1730, his car was located at the arpt & his acft, which had been kept there, was gone. The acft was found on 5/24/84 where it had crashed on…

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

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

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