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

## Cases, newest first

- [NTSB ATL83LA056](https://openairdocs.org/ntsb/ATL83LA056.md): Beech A-36 · Holly Springs, MS · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 1982 · N9115S · Substantial damage
  > The acft was at 4,000 ft in cruise flight when the eng failed. The acft crashed 1/4 mi short of an arpt. The right wing bladder was completely torn in two & the left wing bladder contained a minute amount of fuel. There was reportedly a lot of fuel spillage…
- [NTSB LAX83LA052](https://openairdocs.org/ntsb/LAX83LA052.md): Cessna 172M · South Lake Taho, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 1982 · N20016 · Substantial damage
  > The student pilot and a passenger departed the south lake tahoe airport at 1515 PST. He stated that he had climbed to about 1200 ft AGL when he encountered extreme turbulence and downdrafts. He lost control of the aircraft until just prior to ground impact. A…
- [NTSB LAX83FA414](https://openairdocs.org/ntsb/LAX83FA414.md): Piper PA-28-140 · Tahoe City, CA · Accident · 2 fatal · Field investigation · Final report · Dec 8, 1982 · N5468T · Destroyed
  > The owner, a student plt, & an ATP plt departed olympia, WA at aprx 1111 PST on a flt to the lake Tahoe/reno area. When the acft did not arrive, a search was made until 12/22/82. On 8/28/83, the acft was found where it crashed on rising terrain (50 deg slope)…
- [NTSB DEN83AA033](https://openairdocs.org/ntsb/DEN83AA033.md): Bell 206B · Larkspur, CO · Accident · 2 fatal · Final report · Dec 8, 1982 · N2752Y · Destroyed
  > N2752Y, a Bell 206B helicopter, crashed in hilly terrain while on a flt to obtain video tape news of an aircraft accident. Plt was warned by FBO personnel of adverse wx conditions. Another plt who had just landed tried to persuade the plt not to fly. After…
- [NTSB DEN83AA032](https://openairdocs.org/ntsb/DEN83AA032.md): Swearingen SA-227AC · Pueblo, CO · Accident · 2 fatal · Final report · Dec 8, 1982 · N30093 · Destroyed
  > At 1906 the flt was cleared to descend & maintain 7,500 ft, turn right to a heading 040 for an asr apch to Pueblo memorial arpt, & that the mda is 5,200. The flt read back "left to one forty five two zero zero." Approach control advised the flt that the…
- [NTSB ATL83LA052](https://openairdocs.org/ntsb/ATL83LA052.md): Cessna 150L · Snow Hill, NC · Accident · No injuries · Limited investigation · Final report · Dec 7, 1982 · N19488 · Destroyed
  > The pilot stated that the aircraft was descending about 10 mi from the destination airport when the engine failed. Subsequently, the plane collided with a ditch during a night landing. An examination revealed that the quick drain oil plug had failed…
- [NTSB FTW83LA052](https://openairdocs.org/ntsb/FTW83LA052.md): Piper PA-28-140 · Garland, TX · Accident · No injuries · Limited investigation · Final report · Dec 6, 1982 · N6745W · Substantial damage
  > While flying at night, the engine began to back fire and there was a loss of RPM and metal-to-metal sounds. The pilot attempted to restore the power, but to no avail. During a forced landing in darkness, the pilot saw trees when the plane was about 50 ft AGL,…
- [NTSB FTW83FA054](https://openairdocs.org/ntsb/FTW83FA054.md): Beech A36 · Midland, AR · Accident · 2 fatal · Field investigation · Final report · Dec 6, 1982 · N767T · Destroyed
  > When the plt filed his VFR flt plan he was observed using an IFR enroute chart. About 7 minutes after takeoff the plt requested a frequency to call for a clearance to climb on top of the overcast. Approximately 5 minutes later, as the plt was giving his…
- [NTSB MKC83LA031](https://openairdocs.org/ntsb/MKC83LA031.md): Beech C23 · Near Vichy, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1982 · N60171 · Destroyed
  > While enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…
- [NTSB SEA83IA027](https://openairdocs.org/ntsb/SEA83IA027.md): Mcdonnell Douglas DC-9-51 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Dec 2, 1982 · N785NC · No damage
  > Shortly after climbout from denver the first officer noticed the captain twitch and asked if he was okay. The captain answered affirmatively but donned his oxygen mask at the co-pilot's suggestion. About 20 minutes later the captain stiffened with his left…
- [NTSB FTW83IA053](https://openairdocs.org/ntsb/FTW83IA053.md): Bell 412 · Intercoastal Ci, LA · Incident · No injuries · Incident investigation · Final report · Dec 2, 1982 · N2258F · No damage
  > While in cruise flight, the pilots heard a loud pop and felt a severe cyclic control vibration. An immediate precautionary landing was made. An examination revealed that there was a fatigue crack in the trailing edge of the blue, main rotor yoke flexure, pn…
- [NTSB NYC83FA035](https://openairdocs.org/ntsb/NYC83FA035.md): Mooney M20B · Auburn, NY · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1982 · N13213 · Destroyed
  > During departure on an IFR climb-out radar and radio contact was lost. The pilot's last reported altitude was passing through 4,500 ft. the aircraft crashed into a wooded area at an elevation of 1,700 ft MSL. Initial contact was with trees approximately 40 ft…
- [NTSB LAX83FUG07](https://openairdocs.org/ntsb/LAX83FUG07.md): Cessna 172N · Near Rialto, CA · Accident · 3 fatal · Final report · Nov 29, 1982 · N3579E · Destroyed
  > The pilot and his passengers had flown from van nuys, CA to palm spring, CA during the afternoon. After arrival, they spent several hours on the ground. At 1740, the pilot called a fss to obtain a weather briefing for a flight to concord, CA. During the…
- [NTSB LAX83FA047](https://openairdocs.org/ntsb/LAX83FA047.md): Cessna 172N · 12nm East Of An, CA · Accident · 3 fatal · Field investigation · Final report · Nov 29, 1982 · N737LA · Destroyed
  > During the preflight wx briefing from thermal fss the plt was advised that VFR flt was not recommended into the san diego area. Although the plt requested a briefing to san diego, it is believed that the initial destination was carlsbad to deplane the rear…
- [NTSB LAX83FA042](https://openairdocs.org/ntsb/LAX83FA042.md): Cessna 152 · Ramona, CA · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1982 · N67707 · Destroyed
  > The aircraft crashed into rising terrain at the 3500 foot level in IFR weather. The pilot had been advised of bad weather along his route. His flight plan was VFR. No malfunctions to equipment was found.
- [NTSB LAX83FA041](https://openairdocs.org/ntsb/LAX83FA041.md): Cessna T210L · 13 Se Of Linden, CA · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1982 · N732BQ · Destroyed
  > Pilot encountered weather on a cross-country flight and reported icing at 10,000 feet at 1828. He had been at 10000 feetsince 1745. At 1831, the pilot requested 8,000 feet to get out of ice and at 1836 requested 6,000 and was approved. At 1857 level at 6,000…
- [NTSB NYC83FA033](https://openairdocs.org/ntsb/NYC83FA033.md): Cessna 172M · Williamsport, PA · Accident · Minor injuries · Field investigation · Final report · Nov 28, 1982 · N1498U · Substantial damage
  > The aircraft departed the airport with ice on the airframe. The pilot encountered more icing in flight and decided to return to the airport, but was unable to maintain his altitude. The aircraft collided with trees during a forced landing. The pilot had been…
- [NTSB MKC83FA028](https://openairdocs.org/ntsb/MKC83FA028.md): Piper PA-34 · Kansas City, MO · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1982 · N8189H · Destroyed
  > Drg the 1027 wx briefing, the plt was advised that Kansas City was reporting very light rime icing from 4,000 to 11,000 ft & a PIREP of light to moderate rime ice between 6,000 & 8,000 ft 30 mi south of Kansas City. The plt announcedhis intentions of…
- [NTSB MIA83LA039](https://openairdocs.org/ntsb/MIA83LA039.md): Cessna 152 · Ft. Myers, FL · Accident · No injuries · Limited investigation · Final report · Nov 28, 1982 · N25341 · Substantial damage
  > During a night, VFR flight to opa locka, Florida, the pilot experienced a loss of power and was forced to make an emergency landing in the everglade swamps. The aircraft was recovered from 3 feet of water in an upside down position. Examination of the…
- [NTSB FTW83DA046](https://openairdocs.org/ntsb/FTW83DA046.md): Piper PA-24-250 · Corsicana, TX · Accident · Serious injuries · Final report · Nov 28, 1982 · N8080P · Substantial damage
  > The eng seized at 6,000 ft. due to unsuitable surrounding terrain the plt elected to land on a highway. The plt left the gear up until 50 ft AGL to clear a power line crossing the highway. The acft touched down with the gear partially extended. Eng teardown…
- [NTSB ATL83FKG03](https://openairdocs.org/ntsb/ATL83FKG03.md): Cessna 150M · Stone Mountain, GA · Accident · Minor injuries · Final report · Nov 28, 1982 · N66103 · Substantial damage
  > The pilot reported that while flying in marginal weather, he came to Stone Mountain and turned to avoid it. The aircraft crashed on the side of the Mountain about 300 ft from the base. About 9 mi east southeast of the crash site, the weather was reported as…
- [NTSB NYC83FA032](https://openairdocs.org/ntsb/NYC83FA032.md): Cessna 172H · Mount Alton, PA · Accident · Serious injuries · Field investigation · Final report · Nov 27, 1982 · N9511H · Substantial damage
  > While enroute the plt reported he was icing up & would have to divert to bradford. About 12 mi from the arpt the plt declared an emergency stating he didn't think he could make a missed approach with the ice buildup. The plt then reported a rough engine & an…
- [NTSB LAX83FA040](https://openairdocs.org/ntsb/LAX83FA040.md): Beech 23 · 10 M.N. Of Gilr, CA · Accident · 1 fatal · Field investigation · Final report · Nov 27, 1982 · N6049B · Destroyed
  > Aircraft hit a 2721 foot ridge just below the top while cruising in bad weather on a dark night. He was on a VFR flight plan and was not instrument rated. Low overcast obscured the mountain tops.
- [NTSB MIA83LA035](https://openairdocs.org/ntsb/MIA83LA035.md): Maule M-5-220C · Near Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1982 · N2VB · Destroyed
  > The pilot reported that during flight, the engine stopped and the cockpit filled with smoke. He shut down fuel to the engine and started to glide toward an airport, but it was too FAR away. He then selected a field, but had to stay high on final approach to…
- [NTSB MKC83LA026](https://openairdocs.org/ntsb/MKC83LA026.md): Piper PA28-18 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Nov 25, 1982 · N9582J · Substantial damage
  > When power was applied after a long 20 mile descent the engine would not respond except for a "chugging idle." The pilot stated that he did use some carburetor heat during the early part of the descent. FAA advisory circular AC-20-113 recommends "heat should…
- [NTSB LAX83FA050](https://openairdocs.org/ntsb/LAX83FA050.md): Bellanca 17-30A · Williams, AZ · Accident · 4 fatal · Field investigation · Final report · Nov 25, 1982 · N14748 · Destroyed
  > The original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…
- [NTSB CHI83LA043](https://openairdocs.org/ntsb/CHI83LA043.md): Cessna 150L · Red Wing, MN · Accident · No injuries · Limited investigation · Final report · Nov 25, 1982 · N18236 · Substantial damage
  > The pilot stated that while enroute to Red Wing, MN he ran into deteriorating weather and the engine started to run rough. He decided to execute a precautionary landing into a hay field rather than encounter darkness and adverse weather conditions with a…
- [NTSB ATL83LA042](https://openairdocs.org/ntsb/ATL83LA042.md): Piper PA-31-350 · Richmond, VA · Accident · No injuries · Limited investigation · Final report · Nov 23, 1982 · N3528U
  > The aircraft had an engine fire a short time after take-off from Richmond, VA. The pilot declared an emergency and dove the aircraft from 6000 feet to put out the fire. Since the fire went out the plan to land at petersburg was changed to Richmond because of…
- [NTSB ATL83FA045](https://openairdocs.org/ntsb/ATL83FA045.md): Cessna 150M · Edgewater, MD · Accident · Serious injuries · Field investigation · Final report · Nov 23, 1982 · N2806V · Substantial damage
  > Approximately 45 min after takeoff, the eng started to run rough. The plt headed toward the nearest arpt with the eng still running rough. The plt entered downwind & proceeded to follow a normal landing pattern. As he turned final, the eng quit completely.…
- [NTSB FTW83LA047](https://openairdocs.org/ntsb/FTW83LA047.md): Cessna 150L · Vinton, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1982 · N18632 · Substantial damage
  > The aircraft had been stolen by a noncertificated pilot sometime during the evening of 11/21/82. The purpose and destination of the flight was not determined. It was found laying upside down in a swamp on 11/29/82. The pilot was extracted by helicopter and…
- [NTSB FTW83FA043](https://openairdocs.org/ntsb/FTW83FA043.md): Bell 206B · Buccaneer Oil F · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1982 · N144AL · Substantial damage
  > The acft was found floating inverted about 1.5 mi from the point of departure. The tailboom had separated & there was evidence that the m/r blades had struck the tailboom. The windshield & chin bubble was broken out. An oil pump gear tooth was found adhering…
- [NTSB SEA83FA057](https://openairdocs.org/ntsb/SEA83FA057.md): Cessna TU206G · Soda Springs, ID · Accident · 1 fatal · Field investigation · Final report · Nov 21, 1982 · N4606U · Destroyed
  > A search for the aircraft was begun after the pilot's relatives reported it was overdue and residents near the crash site heard the sounds of a low flying plane suddenly terminate. Unofficial reports of the weather indicated it was about 200 ft obscured, 1/4…
- [NTSB LAX83FUD01](https://openairdocs.org/ntsb/LAX83FUD01.md): Bell 47D1 · Pasadena, CA · Accident · No injuries · Final report · Nov 21, 1982 · N6324X · Substantial damage
  > Aircraft engine quit while cruising to refueling port. A power off autorotation was made to a street. The rotor hit trees and result was a hard landing.
- [NTSB ATL83FA039](https://openairdocs.org/ntsb/ATL83FA039.md): Aero Commander 680W · Atlanta, GA · Accident · Serious injuries · Field investigation · Final report · Nov 21, 1982 · N5058E · Destroyed
  > The plt reported that on the previous flt, the center fuel tank gauge was malfunctioning and indicated 800 lbs even when it was full with 1400 lbs. After lndg at charlotte,NC, it was still indicating 800 lbs. Bfr tkof, the center tank was refilled. While en…
- [NTSB SEA83LA023](https://openairdocs.org/ntsb/SEA83LA023.md): Piper PA-24-250 · Cascade Locks, OR · Accident · No injuries · Limited investigation · Final report · Nov 20, 1982 · N8185P · Substantial damage
  > While cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…
- [NTSB MIA83LA034](https://openairdocs.org/ntsb/MIA83LA034.md): Cessna 182P · La Belle, FL · Accident · No injuries · Limited investigation · Final report · Nov 20, 1982 · N4678K · Substantial damage
  > After experiencing an eng failure the plt made a forced landing on the arpt. The acft overran the rwy & collided with a ditch causing the nose gear to collapse. The #3 cylinder exhaust valve rocker shaft housing failed due to high-cycle low-stress fatigue.
- [NTSB LAX83IA036](https://openairdocs.org/ntsb/LAX83IA036.md): Cessna 172RG · Santa Ana, CA · Incident · Minor injuries · Incident investigation · Final report · Nov 20, 1982 · N6428V · No damage
  > While cruising at 6500 MSL during a night cross country, the cabin filled with smoke. The pilot declared an emergency and landed after securing all of the electrical equipment. The pilot required hospitalization due to smoke inhalation and an irregular…
- [NTSB DCA83AA006](https://openairdocs.org/ntsb/DCA83AA006.md): Cessna 182Q · Livingston, NJ · Accident · 3 fatal · Final report · Nov 20, 1982 · N96402 · 2 aircraft · Destroyed
  > Aero commander 560E, N3827C (27C), was returning from blairstown where it had been flown for minor maint. The plt was on an IFR flt plan, cleared by new york TRACON to proceed at 2000 ft MSL on a radar vector of 170 deg for an ILS apch to the teterboro arpt.…
- [NTSB FTW83FPG03](https://openairdocs.org/ntsb/FTW83FPG03.md): Cessna 182L · Mt. Vernon, AR · Accident · 1 fatal · Final report · Nov 19, 1982 · N42562 · Destroyed
  > The flt of two acft (a C-150 & N42562) departed heber springs & were in radio contact during the flt. N42562 reported over the conway, AR arpt at 2,000 ft with good visibility but indicated that there was an area of rain between conway & heber springs. The…
- [NTSB ATL83FLG01](https://openairdocs.org/ntsb/ATL83FLG01.md): Piper 22 · Clinton, SC · Accident · Serious injuries · Final report · Nov 19, 1982 · N6116D · Substantial damage
  > The aircraft was refueled before departing greenville, KY. The pilot reported that as he approached his destination, he proceeded along a radial from the greenwood VOR but could not find newberry. He stated that he hunted too long before diverting back to…
- [NTSB ATL83FA041](https://openairdocs.org/ntsb/ATL83FA041.md): Piper PA-24-260 · Culpepper, VA · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1982 · N555CE · Destroyed
  > About 16 min after takeoff the plt reported to ARTCC that he had lost the artificial horizon, gyro & vacuum pump. Radio & radar contact was lost shortly thereafter. Examination of the vacuum pump failed to reveal a pre-impact failure or malfunction. The acft…
- [NTSB MKC83FA023](https://openairdocs.org/ntsb/MKC83FA023.md): Piper PA-28-140 · Sharon, KS · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1982 · N500FL · Destroyed
  > The acft crashed 12 mi from the departure point in hilly terrain on a direct route to the destination in a 40 deg nose low & 75 deg right wing low attitude. There are no wx reporting facilities near the accident site. The 1851 wx observation at enid,ok (62 mi…
- [NTSB LAX83FA035](https://openairdocs.org/ntsb/LAX83FA035.md): Piper 601P · Tonopah, NV · Accident · No injuries · Field investigation · Final report · Nov 17, 1982 · N3642A · Substantial damage
  > As the acft reached 15,500 ft, aprx 30 mi from the dep arpt, the plt & pax noted fumes that irritated the eyes & caused dizziness & breathing difficulties. The plt reversed course, then elected to make an emerg lndg on a dirt road. Drg the lndg roll-out, the…
- [NTSB SEA83FA022](https://openairdocs.org/ntsb/SEA83FA022.md): Cessna 210 · Gorst, WA · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1982 · N9557T · Destroyed
  > The acft collided with a mtn drg a VFR flt under IMC. An arts-iii radar printout showed the acft was maintaining a fairly continuous heading until radar coverage was lost. The wreckage was located about 3.4 mi north of the last radar plot. ATC confirmed loss…
- [NTSB LAX83FJA02](https://openairdocs.org/ntsb/LAX83FJA02.md): Piper PA-28-140 · Honolulu, HI · Accident · No injuries · Final report · Nov 16, 1982 · N56351 · Destroyed
  > The eng quit & the plt ditched in the ocean near the beach. The #4 connecting rod shank was found broken at the crankpin bearing housing. One rod bolt head was broken off & the bolt grip was necked down. The nut on this bolt was still on the bolt & flush with…
- [NTSB ATL83IA034](https://openairdocs.org/ntsb/ATL83IA034.md): Beech G18S · Huntsville, AL · Incident · No injuries · Incident investigation · Final report · Nov 16, 1982 · N5BA · Minor damage
  > The left cargo door separated from the acft. The door was a hamilton cargo door installed under an STC which required 3 hinges on top & 3 pins on bottom with an overcenter locking mechanism on the handle for the pins. This door had 2 hinges installed. Only 2…
- [NTSB NYC83LA029](https://openairdocs.org/ntsb/NYC83LA029.md): Piper PA-28-161 · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Nov 15, 1982 · N2221N · Substantial damage
  > Enroute to destination through a mountain pass the pilot saw approaching snow & decided to return & land. While returning, a rapidly moving snow squall was approaching the arpt. At about 1/4 mi from the end of rwy 1 visibility dropped to about 1/8 mi in heavy…
- [NTSB MIA83LA030](https://openairdocs.org/ntsb/MIA83LA030.md): Gulfstream American AA5A · Nr.Chubeay, Bahamas · Accident · No injuries · Limited investigation · Final report · Nov 14, 1982 · N26287 · Destroyed
  > The pilot stated that engine lost power while over the ocean waters and the pilot was forced to ditch the plane. The pilot and passenger were rescued by a yacht in the vicinity of the crash site. The aircraft sank and the wreckage was not recovered.
- [NTSB LAX83FA034](https://openairdocs.org/ntsb/LAX83FA034.md): Cessna 340A · Orinda, CA · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1982 · N29HT · Destroyed
  > After departing san jose, CA, the plt climbed to an alt of 4600 ft MSL & proceeded toward novato, CA. From 1528 to 1533 PST, radar data showed that the acft was level at 4600 ft on a heading of 330 deg at 180 fts ground speed. Radar info showed that the acft…
- [NTSB DEN83AA019](https://openairdocs.org/ntsb/DEN83AA019.md): Piper 601P · Fountain, CO · Accident · 2 fatal · Final report · Nov 13, 1982 · N3641T · Destroyed
  > After taking off at aprx 2250, the acft was identified on radar & observed to climb on course to an alt of 10,700 ft. the acft then descended thru 10,500 ft & the crew reported they would maintain that alt. At about 2301 the acft was about 5 mi se of Colorado…

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

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

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