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

## Cases, newest first

- [NTSB NYC83FA102](https://openairdocs.org/ntsb/NYC83FA102.md): Hiller FH-1100 · Gettysburg, PA · Accident · 2 fatal · Field investigation · Final report · Apr 26, 1983 · N4034K · Destroyed
  > The plt took off on a flt to york, PA to refuel the helicopter & to demonstrate it to a prospective buyer while en route. Witnesses observed the helicopter shortly after departure. Two of 4 witnesses heard a change in the sound of the helicopter, 2 witnesses…
- [NTSB FTW83LA205](https://openairdocs.org/ntsb/FTW83LA205.md): Grumman G-164A · Anahuac, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1983 · N4564 · Destroyed
  > The acft groundlooped in ruts during a forced landing after the engine quit. A ground fire destroyed the acft. The acft had approached the field to be sprayed and a witness on the ground said the engine sounded like it was being throttled back. When the pilot…
- [NTSB DEN83LA102](https://openairdocs.org/ntsb/DEN83LA102.md): Cessna 180 · Ft. Smith, MT · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N9171T · Substantial damage
  > After taking off from ft Smith, the plt leveled at 500 ft AGL & followed a river to look at some property aprx 5 mi away. While en route, the engine began to sputter & run irregularily. He performed a successful precautionary landing in a field where he made…
- [NTSB CHI83LA186](https://openairdocs.org/ntsb/CHI83LA186.md): Aerosport Scamp · Edwardsville, IL · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N15RV · Substantial damage
  > The plt was on a test flt in a homebuilt acft with only 3.7 hrs total flt time. While in a full power climb from 1000 to 2000 ft AGL, he noticed black smoke coming from the left exhaust stacks. The power was reduced to a cruise setting, and reportedly, there…
- [NTSB FTW83LA200](https://openairdocs.org/ntsb/FTW83LA200.md): Piper PA-24-260 · Anthony, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1983 · N8728P · Substantial damage
  > The acft was damaged in a forced landing after a power loss in cruise flt. The plt said the engine began to run rough & then lost power completely. His attempts to restart were unsuccessful and he made a forced landing on a dirt road. Theroad had 3 ft high…
- [NTSB ANC83IA074](https://openairdocs.org/ntsb/ANC83IA074.md): Cessna 185 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Apr 23, 1983 · N9824X · Minor damage
  > Loss of power caused by rags stuffed into the engine air induction intake duct forced the pilot to make an emergency landing on a frozen lake.
- [NTSB ATL83LA169](https://openairdocs.org/ntsb/ATL83LA169.md): Bellanca 17-30 · Prestonburg, KY · Accident · No injuries · Limited investigation · Final report · Apr 22, 1983 · N199V · Substantial damage
  > The acft had been fueled to its capacity of 72 gal. Aprx 3 1/2 hrs after takeoff, the eng quit while fuel was being used from the left main tank. At that time, the plt knew that the aux tanks were empty, but he thought there was 5 gal remaining in the left…
- [NTSB SEA83FA087](https://openairdocs.org/ntsb/SEA83FA087.md): Cessna 172P · 2nm E. Of Blyn, WA · Accident · 3 fatal · Field investigation · Final report · Apr 21, 1983 · N52363 · Destroyed
  > The plts had received a wx briefing from seattle fss earlier in the day for a flt from seattle to port angeles. Due to the time span between arrival & departure at port angeles, the wx briefing was not valid for the return flt. The acft impacted the west…
- [NTSB MKC83LA092](https://openairdocs.org/ntsb/MKC83LA092.md): Mooney M20K · Trenton, NE · Accident · No injuries · Limited investigation · Final report · Apr 20, 1983 · N231KV · Substantial damage
  > The acft was climbing through 11500 to 12000 ft MSL when the engine made a loud noise followed by a lurch. The oil pressure dropped to zero and the engine developed a roughness. The plt said he shut the engine down at this time, the plt advised denver ARTCC…
- [NTSB SEA83LA084](https://openairdocs.org/ntsb/SEA83LA084.md): Weatherly 201C · Near Almira, WA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1983 · N9219W · Destroyed
  > The acft made an emergency landing after an engine failure and fire in flt. The pilot stated that he was enroute to spray wheat when the engine lost power and oil sprayed on the windshield. The pilot smelled smoke, dumped his load and made a landing. When he…
- [NTSB ANC83FA071](https://openairdocs.org/ntsb/ANC83FA071.md): Piper PA-32-300 · Bettles, AK · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1983 · N4060W · Substantial damage
  > According to witnesses, the acft was seen flying along the trans Alaska pipeline at an estimated alt of 200 ft AGL. As the acft entered a pass, where the pipeline crossed rising terrain, a witness heard the acft's eng power increase, then the plane…
- [NTSB FTW83LA206](https://openairdocs.org/ntsb/FTW83LA206.md): Ercoupe 415-C · Prague, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1983 · N87131 · Substantial damage
  > After purchasing the acft, the new owner (a student plt) had asked his uncle (reportedly an experienced plt) to fly his acft home. During the flt, the eng lost power shortly after the plt leveled off at 4000 ft MSL (aprx 3000 ft AGL). There was no suitable…
- [NTSB CHI83LA172](https://openairdocs.org/ntsb/CHI83LA172.md): Piper PA-22 · Alexandria, MN · Accident · No injuries · Limited investigation · Final report · Apr 16, 1983 · N8034D · Substantial damage
  > The pilot decided to make a precautionary landing after he heard a noise or bang which he thought was the muffler. The pilot made a decision to land on a runway which had an unfavorable wind. Control was lost when a gust of wind raised the left wing. The…
- [NTSB SEA83LA081](https://openairdocs.org/ntsb/SEA83LA081.md): Smith Miniplane · Near Rainier, OR · Accident · No injuries · Limited investigation · Final report · Apr 15, 1983 · N94R · Substantial damage
  > Aprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…
- [NTSB FTW83FPJ02](https://openairdocs.org/ntsb/FTW83FPJ02.md): Cessna R172E · Little, OK · Accident · Serious injuries · Final report · Apr 15, 1983 · N70HP · Substantial damage
  > The acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…
- [NTSB MIA83FU002](https://openairdocs.org/ntsb/MIA83FU002.md): Rotec Rally 2B Ultralight · Palm Bay, FL · Accident · 1 fatal · Final report · Apr 13, 1983 · UNREG · Destroyed
  > The Rotec rally 2B was an unregistered ultralight vehicle that had been assembled from a kit. The plts of two other ultralight vehicles stated that they were in a very loose formation with the one that had crashed. According to them, they were flying at about…
- [NTSB MIA83LA120](https://openairdocs.org/ntsb/MIA83LA120.md): Cessna 310Q · Perry, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1983 · N852H · Destroyed
  > The acft made a forced landing in a swamp with the gear down and nosed over after both engines quit. The pilot said the acft was full of fuel at takeoff and yet it was empty less than an hour later. The pilot also did not know the quantity of fuel on board…
- [NTSB MIA83LA114](https://openairdocs.org/ntsb/MIA83LA114.md): Cessna 310R · Gulf Of Mexico · Accident · 1 fatal · Limited investigation · Final report · Apr 11, 1983 · N87498 · Destroyed
  > The plt flew from mobile, al to pensacola, FL, where a passenger enplaned for a flt to columbus, MS. After the passenger disembarked at columbus, the plt took off on an IFR flt plan back to mobile at an altutude of 7000 ft. reportedly, the flt progressed…
- [NTSB LAX83LA198](https://openairdocs.org/ntsb/LAX83LA198.md): Cessna 150J · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1983 · N61327 · Substantial damage
  > The acft was rented for a x-country flt form San Jose, CA to san luis obispo & grover city, CA, then return to San Jose. The plt departed San Jose with full fuel tanks. At san luis obispo, 5.3 gal was purchased; however, no fuel was obtained at grover city.…
- [NTSB LAX83FA188](https://openairdocs.org/ntsb/LAX83FA188.md): Cessna 182RII · Casa Grande, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 11, 1983 · N5541N · Destroyed
  > The acft collided with a lone mountain while in straight & level flight.
- [NTSB ATL83LA159](https://openairdocs.org/ntsb/ATL83LA159.md): Cessna 210F · Brunswick, GA · Accident · No injuries · Limited investigation · Final report · Apr 11, 1983 · N210AE · Substantial damage
  > The acft was intentionally landed wheels up after the landing gear extension systems failed to operate. The rt aileron control cable had chaffed a hole in the main landing gear hydraulic line causing a hydraulic leak that depleted the gearextension system of…
- [NTSB NYC83FA088](https://openairdocs.org/ntsb/NYC83FA088.md): Piper PA-28-181 · Hawthorne, NY · Accident · Minor injuries · Field investigation · Final report · Apr 10, 1983 · N8302T · Substantial damage
  > The flt departed cleveland at 1539. The flt enroute was conducted at 6,000 ft. about 45 mi w of destination the fuel gages indicated 5 gals of fuel in each of the two tanks. At about 5 mi w of the arpt the eng quit. The plt made a forcedlanding on the…
- [NTSB MIA83FA113](https://openairdocs.org/ntsb/MIA83FA113.md): Cessna 172RG · Gainesville, FL · Accident · 1 fatal · Field investigation · Final report · Apr 10, 1983 · N6418V · Destroyed
  > The acft crashed about 8 miles from the intended destination during weather on a dark night. The plt had gone outbound that afternoon with two passengers who did not return with him because of motion sickness. According to the one of his former instructors…
- [NTSB FTW83LA183](https://openairdocs.org/ntsb/FTW83LA183.md): Cessna 175 · Cresson, TX · Accident · No injuries · Limited investigation · Final report · Apr 10, 1983 · N753OM · Substantial damage
  > The acft collided with a ditch during a forced landing after the engine failed in flt. After takeoff, at 3500 ft, the engine began making noises. The plt began a descent toward the arpt a short distance away. The engine maintained some power but failed…
- [NTSB ANC83FU003](https://openairdocs.org/ntsb/ANC83FU003.md): Pteradactyl Ascender · Girdwood, AK · Accident · 1 fatal · Final report · Apr 10, 1983 · UNREG · Substantial damage
  > According to a witness, the ultralight vehicle had just taken off, had turned to a downwind heading & was climbing, when it began to oscillate longitudinally. After a few oscillations, the vehicle nosed over, the wings folded & the ultralight crashed to the…
- [NTSB CHI83FA161](https://openairdocs.org/ntsb/CHI83FA161.md): Cessna 182 · Coulterville, IL · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1983 · N92734 · Destroyed
  > During a wx briefing before takeoff, the non-instrument rated plt was advised that VFR flt was not recommended. However, he departed sheboygan, WI at aprx 1500 CST with no flt plan. At dusk, witnesses (near the crash site) heard the acft maneuvering. One…
- [NTSB NYC83FA087](https://openairdocs.org/ntsb/NYC83FA087.md): Piper PA-32RT-300 · Wellsville, NY · Accident · 6 fatal · Field investigation · Final report · Apr 8, 1983 · N3515M · Destroyed
  > Just prior to this flt, the plt had flown from hornell, NY to Wellsville, NY. Before departing hornell, he radioed that the vacuum annunciator light was on, & during a run-up, the suction gauge read zero. Ground personnel advised that with this problem, the…
- [NTSB NYC83FA086](https://openairdocs.org/ntsb/NYC83FA086.md): Cessna 210L · Avon, CT · Accident · No injuries · Field investigation · Final report · Apr 8, 1983 · N59123 · Substantial damage
  > The acft collided with a tree and broke the nose landing gear during an emergency landing after electrical failure. After the failure, using matches and a flashlight, the plt tried to land but could not find the arpt. The weather was deteriorating so when a…
- [NTSB FTW83LA184](https://openairdocs.org/ntsb/FTW83LA184.md): Bell 206B · Hempstead, TX · Accident · No injuries · Limited investigation · Final report · Apr 8, 1983 · N3898P · Substantial damage
  > Acording to the pilot the aircraft was in level flight at 800 feet AGL when the pilot experienced severe yaws in rapid rapid succession. He noticed he torque fluctuating between 30 and 100 pounds, went into autorotation and selected a landing spot heading…
- [NTSB LAX83LA181](https://openairdocs.org/ntsb/LAX83LA181.md): Hiller UH12-E · Kettleman City, CA · Accident · No injuries · Limited investigation · Final report · Apr 7, 1983 · N68024 · Substantial damage
  > The pilot reported that he began flying about 0725 with 23 gallons of fuel on board. He applied a herbicide for about an hour and came back to reload. After reloading he began a return to the area to be sprayed. About 10 minutes later all power was lost.…
- [NTSB ANC83FA068](https://openairdocs.org/ntsb/ANC83FA068.md): Britten-Norman BN-2A-8 · Selawik, AK · Accident · 2 fatal · Field investigation · Final report · Apr 7, 1983 · N37MN · Substantial damage
  > According to the FAA specialist on duty at the nome flight service station the plt of munz northern flt 601 requested only the ambler wx at 0030 gmt. The only surviving passenger stated that the flt deptd nome, AK at 1330 bst and as the flt continued north…
- [NTSB MIA83LA118](https://openairdocs.org/ntsb/MIA83LA118.md): Ercoupe G · Pempbroke Pines, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N2175H · Substantial damage
  > The acft collided with a tree during a forced landing after the engine lost power. Post accident investigation revealed that the fuel strainer was full of water and that the carburetor bowl contained one or two ounces of water. Draining of this water allowed…
- [NTSB MIA83IA117](https://openairdocs.org/ntsb/MIA83IA117.md): Gates Learjet 35A · Near Orlando, FL · Incident · No injuries · Incident investigation · Final report · Apr 5, 1983 · N369XL · Minor damage
  > During descent the pilot in command maintained red line airspeed. The aircraft then encountered clear air turbulence, followed by a loss of control. The pilot extended the landing gear to slow the aircraft and regain control.
- [NTSB FTW83LA179](https://openairdocs.org/ntsb/FTW83LA179.md): Cessna 172M · Beaumont, TX · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N73192 · Substantial damage
  > According to the pilot he departed on a trip with an ete of 3.5 hours with an estimated 4.5 hours of fuel on board. After aprx 3.8 hours of flight the engine lost power and the pilot landed the acft on a service road. On rollout the left wing struck a highway…
- [NTSB ATL83FA155](https://openairdocs.org/ntsb/ATL83FA155.md): Cessna 182 · Rocky Face, GA · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1983 · N7439N · Destroyed
  > During two wx briefings the plt was advised that wx enroute would be marginal VMC to IMC. He was given a convective SIGMET covering tenessee & north carolina. There was a possibility of thunderstorm activity, low ceiling & visibility, high surface winds,…
- [NTSB SEA83LA079](https://openairdocs.org/ntsb/SEA83LA079.md): Erco 415C · Boring, OR · Accident · No injuries · Limited investigation · Final report · Apr 4, 1983 · N87110 · Substantial damage
  > The aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…
- [NTSB NYC83FA091](https://openairdocs.org/ntsb/NYC83FA091.md): Cessna 172H · Liberty Corner, NJ · Accident · Serious injuries · Field investigation · Final report · Apr 4, 1983 · N2574L · Destroyed
  > Investigation revealed that the plt and passenger arrived at the airport at approximately 1820 EST, requested a special VFR clearance and when that clearance could not be approved requested an IFR flight plan. Attempts to activate the IFR flight plan were…
- [NTSB LAX83LA183](https://openairdocs.org/ntsb/LAX83LA183.md): Cessna T310R · Hilmar, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1983 · N4060C · Substantial damage
  > The acft lost power on the engines. Power was restored on only one engine and a precautionary landing was made off arpt in a field of alfalfa. The gear was not extended prior to ground contact. The pilot said he switched the fuel selector for power…
- [NTSB MKC83LA085](https://openairdocs.org/ntsb/MKC83LA085.md): Cessna 182F · Concordia, MO · Accident · No injuries · Limited investigation · Final report · Apr 3, 1983 · N3102U · Substantial damage
  > The acft was forced to land in a wheatfield when the engine quit. The student pilot was on a solo cross-country flight cruising at 2000 feet when the engine lost power. The flt. Had started about 30 minutes before the accident. The dew point was 32 and the…
- [NTSB ATL83FA328](https://openairdocs.org/ntsb/ATL83FA328.md): Boeing 707-323C · Baltimore, MD · Accident · Serious injuries · Field investigation · Final report · Apr 3, 1983 · N8415 · No damage
  > The flt encountered turbulence about 20-25 min prior to landing. The flt attendants were retrieving cups & trash at the conclusion of a hot meal service. An attendant was thrown upward striking the ceiling, then fell to the floor causing a lower back injury.…
- [NTSB LAX83IA174](https://openairdocs.org/ntsb/LAX83IA174.md): Douglas DC-9-82 · 20n Bryce, UT · Incident · No injuries · Incident investigation · Final report · Apr 2, 1983 · N1004F · No damage
  > While cruising at FL 350 the flt experienced a flame-out of both engines. The crew declared an emergency to salt lake artc center & the flt was vectored toward page,AZ for a possible emergency landing. At 12,200 ft the captain restarted both engines by…
- [NTSB ANC83LA065](https://openairdocs.org/ntsb/ANC83LA065.md): Cessna 180 · Palmer, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 1983 · N2345C · Destroyed
  > According to the plt's accident report, he had climbed to 3200 ft, pulled the throttle full back to descend, then the eng stopped. He stated that he tried to start the eng, but was unable, so he landed straight ahead in trees. The acft was destroyed during…
- [NTSB ANC83FA064](https://openairdocs.org/ntsb/ANC83FA064.md): Piper PA-12 · Glennallen, AK · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1983 · N2826M · Substantial damage
  > Witnesses reported that after takeoff, the plt flew by a cabin at approximately 200 ft, signaled by rocking the acft's wings, then began a gradual climb. The climb increased in steepness until 1 witness could see the entire top of the acft. It then nosed…
- [NTSB DEN83FA089](https://openairdocs.org/ntsb/DEN83FA089.md): Piper PA-32-300 · Castle Rock, CO · Accident · Serious injuries · Field investigation · Final report · Apr 1, 1983 · N4005W · Substantial damage
  > The pilot made two enroute stops at places other than planned because he was confused and disoriented. When he could notget a sectional chart he wanted he tookoff without it after one of these landings. After the second landing he took off ignoring a red…
- [NTSB MKC83FA084](https://openairdocs.org/ntsb/MKC83FA084.md): Cassutt III M Sport · Hiawatha, KS · Accident · No injuries · Field investigation · Final report · Mar 31, 1983 · N1790 · Substantial damage
  > While en route at 5500 ft MSL, the plt noticed an oil film start to cover the windshield of the home built acft. At that time, he was approaching hiawath, KS, so he diverted to the Hiawatha arpt. By the time he entered the traffic pattern to land, the oil…
- [NTSB MIA83LA108](https://openairdocs.org/ntsb/MIA83LA108.md): Cessna 182 RG · Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1983 · N55AG · Destroyed
  > The acft ditched in the atlantic ocean 5 miles east of Palm Beach FL after an electrical fire and engine failure. The pilot said he departed boca raton at 1950 EST. A few minutes later he experienced an electrical fire and electrical failure. About 2 minutes…
- [NTSB LAX83FVG10](https://openairdocs.org/ntsb/LAX83FVG10.md): Champion 7ECA · Georgetown, CA · Accident · 1 fatal · Final report · Mar 31, 1983 · N9548S · Destroyed
  > The acft collided with a mountainside at the 3500 ft level in a 45 degree nose down attitude after colliding with a 30 ft tree during IMC weather on a dark night. There is no record that the plt received a weather briefing. The pilot was not instrument rated…
- [NTSB DEN83FA090](https://openairdocs.org/ntsb/DEN83FA090.md): Cessna 150M · Kanab, UT · Accident · 2 fatal · Field investigation · Final report · Mar 31, 1983 · N714ML · Destroyed
  > The acft departed page at about 1150. At about 1238 the acft struck the south slope of a 6,280-FT canyon wall at about 6,000 ft MSL. The canyon is one of a series of about five 'finger' canyons forming the vermilion cliffs group. Sigment lima 15 in effect…
- [NTSB CHI83FA156](https://openairdocs.org/ntsb/CHI83FA156.md): Piper PA-32-300 · Miltona, MN · Accident · 3 fatal · Field investigation · Final report · Mar 31, 1983 · N4186R · Destroyed
  > Prior to separting, the plt was advised of low ceilings & poor visibility over the entire proposed route & was advised that VFR flt was not recommended. In a discussion with persons at fergus falls, MN, he stated that he was going to follow the highway. About…
- [NTSB FTW83FA170](https://openairdocs.org/ntsb/FTW83FA170.md): Beech A36 · Enid, OK · Accident · 2 fatal · Field investigation · Final report · Mar 30, 1983 · N18314 · Destroyed
  > During the early morning hours, the acft crashed at the edge of a wheat field on relatively level terrain. The main wreckage then crossed a road & came to rest in another field. There were no known witnesses. A passing farmer discovered the wreckage at about…

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

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

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