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

## Cases, newest first

- [NTSB CHI84LA367](https://openairdocs.org/ntsb/CHI84LA367.md): Cessna 182G · Crawfordsville, IN · Accident · No injuries · Limited investigation · Final report · Aug 27, 1984 · N2124R · Substantial damage
  > Plt stated that while en route the generator circuit breaker popped and attempts to reset it proved futile. A loss of pwr occurred later in the flt and a forced landig was made in a field during which the acft was damaged. No fuel was found in the acft after…
- [NTSB CHI84LA365](https://openairdocs.org/ntsb/CHI84LA365.md): Meyers OTW · New Athens, OH · Accident · No injuries · Limited investigation · Final report · Aug 27, 1984 · N26490 · Substantial damage
  > The acft nosed over in an open field during a forced landing after the engine quit. 2 witnesses, one an A&P mechanic, reported that there was no evidence of fuel on board the acft after the accident. The plt stated to the highway patrol trooper at the scene…
- [NTSB CHI84LA362](https://openairdocs.org/ntsb/CHI84LA362.md): Brantly Helicopter B-2 · Michigan City, IN · Accident · No injuries · Limited investigation · Final report · Aug 26, 1984 · N5983X · Destroyed
  > The engine quit as a result of fuel exhaustion. Twenty ounces of fuel remained in the tank. The pilot stated he was flying on the aircraft's fuel gage which indicated three eights of a tank remained. An autorotation was initiated, but the landing skid caught…
- [NTSB MKC84FA262](https://openairdocs.org/ntsb/MKC84FA262.md): Shindler-Smiley THE Blue MAX · Lawrence, KS · Accident · Serious injuries · Field investigation · Final report · Aug 25, 1984 · N1915S · Substantial damage
  > While in cruise flt, plt noted rising oil temp and decreasing oil press, and elected to make a precuationary landing in open alfalfa field. During landing flare, acft stalled, right wing dropped then left wing dropped to ground contact. Engine exam disclosed…
- [NTSB DEN84MA266](https://openairdocs.org/ntsb/DEN84MA266.md): Aero Commander 690 · Little America, WY · Accident · 4 fatal · Major investigation · Final report · Aug 25, 1984 · N9150N · Destroyed
  > About 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…
- [NTSB CHI84LA368](https://openairdocs.org/ntsb/CHI84LA368.md): Piper PA-28RT-201T · Naperville, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1984 · N8317R · Substantial damage
  > Plt stated eng had been 'running rough' since 100 hr inspection. Eng had 130 hrs total time. On run-up, eng was misfiring until plt leaned mixture and allowed full warm up. Eng then performed normally. Takeoff and climb to cruise uneventful. After about 45…
- [NTSB LAX84FA453](https://openairdocs.org/ntsb/LAX84FA453.md): Cessna 320C · Monterey, CA · Accident · 5 fatal · Field investigation · Final report · Aug 24, 1984 · N7AE · Destroyed
  > The flt arrived in Monterey, CA, that afternoon. After dinner the flt was returning to the point of original departure. When the plt contacted the twr for taxi instruction he was informed that Monterey wx was below VFR minimums. After a discussion of wx…
- [NTSB DCA84AA034](https://openairdocs.org/ntsb/DCA84AA034.md): Beech C-99 · San Luis Obispo, CA · Accident · 17 fatal · Class 1 · Final report · Aug 24, 1984 · N6399U · 2 aircraft · Destroyed
  > At about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…
- [NTSB CHI84LA359](https://openairdocs.org/ntsb/CHI84LA359.md): Piper PA-32-260 · Woodstock, IL · Accident · No injuries · Limited investigation · Final report · Aug 24, 1984 · N5541J · Substantial damage
  > The acft collided with the terrain during a forced landing. The wx was VMC & no flt plan was filed. During the forced landing in a farm field the right main gear was sheared off and the nose gear bent. The left wing was also substantiallydamaged. The engine…
- [NTSB LAX84FA452](https://openairdocs.org/ntsb/LAX84FA452.md): Piper PA-28-161 · Vista, CA · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1984 · N8451V · Destroyed
  > According to a statement from the passenger who initially survived, the acft encountered fog shortly after takeoff and the plt was attempting to head inland to get out of the fog by reference to street lights. Shortly thereafter, while in a climb, ground…
- [NTSB DEN84LA262](https://openairdocs.org/ntsb/DEN84LA262.md): Hiller UH-12C · Kindred, ND · Accident · No injuries · Limited investigation · Final report · Aug 22, 1984 · N96168 · Substantial damage
  > The practice autorotation to touchdown began at 500 ft AGL. Shortly after initiating the flare the tail rotor contacted the ground. The pilot was scheduled for a private pilot helicopter check ride on the afternoon of the accident.
- [NTSB ANC84LA134](https://openairdocs.org/ntsb/ANC84LA134.md): Aeronca 15AC · Murphy Dome, AK · Accident · No injuries · Limited investigation · Final report · Aug 22, 1984 · N1067H · Substantial damage
  > The CFI said the engine quit in 'straight and level flight' & 'acted like fuel starvation.' The prop was windmilling. Restarts were attempted without success. A forced landing was made in a wooded area. The landing was cushioned by the acft floats and wings.…
- [NTSB SEA84LA208](https://openairdocs.org/ntsb/SEA84LA208.md): Piper PA-25-235 · Shelley, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1984 · N6474L · Destroyed
  > The pilot indicated that he was en route to spray a local field when the engine began to run rough. He diverted to an ag strip nearby, but the engine ceased operation prior to reaching the strip. The aircraft struck an irrigation pivot during the forced…
- [NTSB MKC84FPG01](https://openairdocs.org/ntsb/MKC84FPG01.md): Robinson R22 · Frenchman'Bayou, AR · Accident · Serious injuries · Final report · Aug 21, 1984 · N9073Y · Substantial damage
  > The acft crashed during autorotation into a soy bean field after the engine lost power. The plt was a student who did not have authorization to fly nor the proper certificate and endorsement from the CFI. The acft engine stopped due to fuel exhaustion. The…
- [NTSB MKC84LA259](https://openairdocs.org/ntsb/MKC84LA259.md): Beech A36 · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Aug 20, 1984 · N67908 · Substantial damage
  > The acft landing gear collapsed during landing. After electrical failure the plt had cranked the gear down in flt. Inspection revealed that a nut on the alternator ground wire had come off. The landing gear manual extension system had no deficiencies.
- [NTSB MIA84FA234](https://openairdocs.org/ntsb/MIA84FA234.md): Piper PA-46-310P · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Aug 20, 1984 · N4371Y · Destroyed
  > On post-production test flt, plt noted symptoms of uncommanded lean mixture and turned to return for landing. En route to airport, eng lost pwr completely. On base leg for forced landing (off airport) fire broke out in eng area and burned through hydraulic…
- [NTSB ANC84LA142](https://openairdocs.org/ntsb/ANC84LA142.md): Piper PA-18-150 · Chandalar, AK · Accident · No injuries · Limited investigation · Final report · Aug 20, 1984 · N4052Z · Destroyed
  > During flt at about 4500 ft MSL, the eng began a severe knocking, then a cylinder separated from the eng & oil completely covered the windshield. The plt tried to make an emergency landing beside the Chandalar river. However, the acft came to rest in the…
- [NTSB NYC84LA284](https://openairdocs.org/ntsb/NYC84LA284.md): Hughes 369D · Fishers Island, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1984 · N6666C · Substantial damage
  > The certified flt instructor (CFI) stated that he was teaching his student autorotation's to touchdown. He continued to state that his student applied too much left pedal just prior to touchdown. This caused the helicopter to yaw to the left. The CFI stated…
- [NTSB SEA84LA203](https://openairdocs.org/ntsb/SEA84LA203.md): Whitman W - 8 · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1984 · N7599V · Substantial damage
  > Shortly after takeoff, plt switched from front to rear fuel tank at which time a ttl loss of pwr occurred. Remedial action was attempted but no pwr was regained. Unable to return to the arpt, plt applied full flaps and stalled the acft aprx 15 ft AGL over the…
- [NTSB SEA84FA201](https://openairdocs.org/ntsb/SEA84FA201.md): Cessna 182E · Prineville, OR · Accident · 3 fatal · Field investigation · Final report · Aug 18, 1984 · N3159Y · Destroyed
  > The acft hit a tree during a forced landing approach to a large open field after an engine failure. Post accident investigatiion revealed that a rod cap bolt had failed which started the internal destruction of the engine. This bolt was installed as a new…
- [NTSB LAX84LA443](https://openairdocs.org/ntsb/LAX84LA443.md): Cessna 150G · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1984 · N8424J · Substantial damage
  > During flt, the eng began losing power, then stopped running. The plt found a dry lake bed that had been plowed & elected to land there. When he landed, the acft nosed over. An exam of the eng revealed that the #2 connecting rod had failed. Due to the severe…
- [NTSB LAX84LA442](https://openairdocs.org/ntsb/LAX84LA442.md): Cessna 172N · Auburn, CA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1984 · N733XQ · Substantial damage
  > The acft made a forced landing on an abandoned airstrip after the engine quit during a x-country. The solo student plt said he encountered head winds and lower than expected ground speeds even with increased power. He said that the fuel gages indicated 1/8…
- [NTSB FTW84LA359](https://openairdocs.org/ntsb/FTW84LA359.md): Maule M6-235 · Corpus Christi, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1984 · N5648D · No damage
  > On a heading of 165 deg at 3,500 ft the plt saw another acft at the same altitude on a collision course. Evasive action was taken by pushing the nose over forcing both occupants into the cabin overhead. According to the plt, both seatbelts and shoulder…
- [NTSB LAX84FA444](https://openairdocs.org/ntsb/LAX84FA444.md): Cessna T210N · Cone, AZ · Accident · Serious injuries · Field investigation · Final report · Aug 17, 1984 · N6462N · Substantial damage
  > The acft made a forced lndg after a loss of power during in flt cruise at 9500 ft MSL. The plt squawked 'indent' following radio contact with artc during a 'may day' call. Later, the transponder was used for 'emer 7700' squawking. The plt spotted a road he…
- [NTSB CHI84LA355](https://openairdocs.org/ntsb/CHI84LA355.md): Piper PA-28R-200 · La Salle, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1984 · N2841T · Substantial damage
  > The acft made a forced landing in a corn field after a power loss. The plt said that the engine seemed to be running rough at start-up. After leaning and a run-up it smoothed out. Twenty minutes after takeoff the engine started vibratingand the EGT went up to…
- [NTSB CHI84LA350](https://openairdocs.org/ntsb/CHI84LA350.md): Piper PA-28R-200 · Put-In-Bay, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1984 · N4428T · Substantial damage
  > Plt departed on flt with 30 gals fuel. En route weather required route deviation, extending flt. Calculated fuel reserve was consumed before reaching destination. When fuel exhaustion occurred, plt attempted forced landing on curving road. Acft departed road…
- [NTSB CHI84LA349](https://openairdocs.org/ntsb/CHI84LA349.md): Bellanca 17-31ATC · Antigo, WI · Accident · No injuries · Limited investigation · Final report · Aug 16, 1984 · N4001B · Destroyed
  > The acft was forced to land after the engine failed. The plt heard an explosion and saw part of the cowling come off before the engine quit. His passenger said that oil covered the windshield. Post accident inspection showed a failed cylinder. The cylinder…
- [NTSB MKC84FU007](https://openairdocs.org/ntsb/MKC84FU007.md): Gemini Int'l. Hummingbird · Mount Hope, AR · Accident · Serious injuries · Final report · Aug 15, 1984 · UNREG · Substantial damage
  > The newly acquired ultralight had been flown for about 10 hours during the 2 week period of ownership. On this day, the wind was blowing at 15 mph and the owner was flying downwind over a hay field at about 50 ft AGL when the right engine on the twin engine…
- [NTSB SEA84LA220](https://openairdocs.org/ntsb/SEA84LA220.md): Piper PA-12 · Juneau, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1984 · N92740 · Destroyed
  > Over a mountain pass the acft encountered turbulence the plt described as 'severe'. The acft lost 500 to 1,000 ft and turned 180 deg. A 180 deg climbing turn was initiated and the acft again flew into the turbulence. After the second encounter aileron and…
- [NTSB NYC84FNE05](https://openairdocs.org/ntsb/NYC84FNE05.md): Mooney M20C · Danbury, CT · Accident · Serious injuries · Final report · Aug 14, 1984 · N74558 · Destroyed
  > An eng compartment fire occurred shortly after takeoff & smoke entered the cockpit. The plt then made a forced landing in a sand pit aprx 1 mi fm the arpt. He & the pax exited the acft with serious burns. An inv revealed an exhaust pipe had failed at a…
- [NTSB ATL84LA256](https://openairdocs.org/ntsb/ATL84LA256.md): Grumman G-164A · Adams, TN · Accident · No injuries · Limited investigation · Final report · Aug 14, 1984 · N9888 · Substantial damage
  > After completing a spray run the plt climbed to 75 ft AGL to fly aprx 2 miles to the next field. The elevation of the destination field was higher than the last one sprayed; no estimate of elevation change was provided. While attempting to climb over a hill…
- [NTSB ATL84FMG05](https://openairdocs.org/ntsb/ATL84FMG05.md): Beech A36 · Banner Elk, NC · Accident · No injuries · Final report · Aug 14, 1984 · N2864W · Destroyed
  > According to the plt, he took off & climbed to about 4800 ft where 'a cloud bank rolled in on us without warning.' He attempted to climb & clear the mountains. However, the left wing tip 'clipped a tree' & subsequently, he crash landed. The elevation of the…
- [NTSB NYC84FNA02](https://openairdocs.org/ntsb/NYC84FNA02.md): Air & Space Gyroplane 18A · Harwich, MA · Accident · No injuries · Final report · Aug 13, 1984 · N6129S · Substantial damage
  > Cruising at 500 ft over water the plt encountered fog. In an effort to maintain visual contact with the shoreline the plt began a descent and began a turn to avoid the fog. During the descending turn the acft got low and slow and the plt was unable to control…
- [NTSB LAX84LA437](https://openairdocs.org/ntsb/LAX84LA437.md): Cessna 150 · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Aug 13, 1984 · N4130U · Substantial damage
  > The plt was on x-country flt. Before landing at lakeview, OR, the tachometer failed & began making a noise. At lakeview, the plt disconnected the tachometer & had 7.5 gals of fuel added to 1 tank. He estimated that he had 15 gals of which 3.5 gals were…
- [NTSB LAX84LA435](https://openairdocs.org/ntsb/LAX84LA435.md): Cessna 182P · Pacific Ocean (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1984 · N8032M · Destroyed
  > On a ferry flight from California to Hawaii, a gradual loss of oil pressure led to complete engine pwr loss. Accompanying acft observed no leaks or smoke. First indication came 11 hrs into flt, oil pressure dropped 5 PSI to read 50 PSI. 30 min later, press…
- [NTSB FTW84FA347](https://openairdocs.org/ntsb/FTW84FA347.md): Bakeman-Chapman Cassutt III M · Olin, TX · Accident · Serious injuries · Field investigation · Final report · Aug 13, 1984 · N520BC · Destroyed
  > Plt had purchased the acft earlier on day of accident. He had no previous time in the acft. He flew for 220 miles and made first landing. Acft serviced with fuel only. Takeoff was made and he flew for 60 miles. Eng began to vibrate and black smoke observed.…
- [NTSB ATL84IA255](https://openairdocs.org/ntsb/ATL84IA255.md): Swearingen SA226TC · Memphis, TN · Incident · Minor injuries · Incident investigation · Final report · Aug 13, 1984 · N501SS · Minor damage
  > During level off at 16,000 ft with a sea level cabin pressure (6 PSI differential pressure), the crew heard a 'pop', then the coplt's window blew out. Debris, including the glareshield, exited the cockpit & injured the copilot. The window was a single…
- [NTSB ANC84LA133](https://openairdocs.org/ntsb/ANC84LA133.md): Republic RC-3 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Aug 13, 1984 · N87459 · Destroyed
  > During cruise, plt was troubleshooting rhythmic power interruption (missing) when fire broke out in the engine compartment. Plt headed for arpt, gear down, but elected to make a precautionary landing off arpt when the fire intensified. Landing gear sheared in…
- [NTSB SEA84LA195](https://openairdocs.org/ntsb/SEA84LA195.md): Cessna 210-5(205) · Mountain Home, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 1984 · N8337Z · Substantial damage
  > During climb the rpms started to decrease. The acft was unable to maintain alt and a forced landing was made. During investigation a bogus fuel filter was found between the fuel control unit and the fuel injector. The filter was clogged with debris. The…
- [NTSB LAX84LA436](https://openairdocs.org/ntsb/LAX84LA436.md): Cessna 210L · Chinle, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 1984 · N29359 · Substantial damage
  > At about 1400 MST, the plt took off. He climbed & leveled off at 8500 ft. he was using fuel from the right tank which ran dry, then he switched to the left tank. At that time, he thought he had 30 mins of fuel remaining. He decided to land at Chinle, AZ, &…
- [NTSB NYC84MA270](https://openairdocs.org/ntsb/NYC84MA270.md): Sikorsky S-76A · Fort Dix, NJ · Accident · 1 fatal · Major investigation · Final report · Aug 11, 1984 · N63WW · Destroyed
  > The aircrew of the helicopter contacted mcguire rapcon & obtained clearance to proceed thru the mcguire afb control zone at 1500 ft. a short time later, the crew declared an emergency. Witnesses on the ground heard a loud 'bang' & observed the helicopter…
- [NTSB LAX84LA434](https://openairdocs.org/ntsb/LAX84LA434.md): Cessna 150H · Lincoln, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1984 · N22971 · Substantial damage
  > During acft pre-flight, plt checked fuel quantity by reference to gages only. Both gages indicated full. After 1 hr and 10 min flt, complete pwr loss occurred. Plt stated gages still indicated full. Forced landing on open field executed but plt flared high,…
- [NTSB FTW84FA344](https://openairdocs.org/ntsb/FTW84FA344.md): Piper PA-28-161 · Reed, OK · Accident · 3 fatal · Field investigation · Final report · Aug 11, 1984 · N3233Q · Destroyed
  > Arpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…
- [NTSB CHI84FA342](https://openairdocs.org/ntsb/CHI84FA342.md): Piper PA28-140E · Montmorenci, IN · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1984 · N5770U · Destroyed
  > The acft crashed while on a x-country personal transportation flt. Prior to departure, the plt telephoned a relative at the destination, 118 miles away, & had been informed that the flt conditions (wx) at brazil were good. The plt did not obtain a wx briefing…
- [NTSB SEA84LA194](https://openairdocs.org/ntsb/SEA84LA194.md): Beech C-23 · Adel, OR · Accident · No injuries · Limited investigation · Final report · Aug 10, 1984 · N6183X · Substantial damage
  > Plt made forced landing in sagebrush covered hilly terrain following a ttl loss of pwr resulting from fuel exhaustion.
- [NTSB MKC84FA245](https://openairdocs.org/ntsb/MKC84FA245.md): Cessna 188 · Bloom, KS · Accident · Serious injuries · Field investigation · Final report · Aug 10, 1984 · N9841V · Destroyed
  > The acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…
- [NTSB DEN84FA308](https://openairdocs.org/ntsb/DEN84FA308.md): Cessna L-19E · Tabernash, CO · Accident · 2 fatal · Field investigation · Final report · Aug 10, 1984 · N4584A · Destroyed
  > The airplane departed grandby 8/10/84 and failed to arrive at its destination. On 8/23/87, it was found on the slope of a high tree-covered ridge. Video tape recovered from the wreckage provided a visual and audio record of the flight from takeoff to impact.…
- [NTSB MIA84LA223](https://openairdocs.org/ntsb/MIA84LA223.md): Beech D-55 · Atlantic Ocean (Atlantic Ocean) · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1984 · N1888L · Destroyed
  > The plt stated that he set the throttles for 45 percent power after climbing to 1500 ft MSL. After about 4 hrs of flight the left eng failed followed by a right engine failure moments later. The acft was ditched and never recoveredbecause it sank into the…
- [NTSB FTW84FA342](https://openairdocs.org/ntsb/FTW84FA342.md): Piper PA-32R-300 · Tulsa, OK · Accident · Serious injuries · Field investigation · Final report · Aug 9, 1984 · N5105F · Substantial damage
  > On climbout from a night takeoff, a complete power loss occurred. The plt attempted to return to the airport, but insufficient altitude was available. During an ensuing forced landing, the acft collided with trees before ground impact. An investigation…
- [NTSB CHI84LA334](https://openairdocs.org/ntsb/CHI84LA334.md): Cessna 180 · Chesapeake, OH · Accident · No injuries · Limited investigation · Final report · Aug 8, 1984 · N2449C · Substantial damage
  > The acft was forced to land off arpt after the engine quit. The plt normally refueled after landing and forgot that he did not on this occasion. The fuel gages were misread during pre-flt. The acft ran out of fuel after about 1 hour flt time.

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

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

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