# NTSB investigations, 1983: 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 1 of 15 · 734 cases

## Latest cases

- [NTSB NYC84LA064](https://openairdocs.org/ntsb/NYC84LA064.md): Beech 35 · Altamont, NY · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N3034V · Substantial damage
  > The eng started running rough shortly after take off & the plt made a forced landing in a snow covered field.
- [NTSB MKC84LA051](https://openairdocs.org/ntsb/MKC84LA051.md): Beech BE-23 · Grimes, IA · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1983 · N9225S · Substantial damage
  > The acft made a forced landing after engine failure during a night x-country. The landing gear collapsed during the landing. The plt reported that the fuel pressure went to zero and the engine quit as he approached des moines. Attempts to restart the engine…
- [NTSB MKC84IA053](https://openairdocs.org/ntsb/MKC84IA053.md): Piper PA-28RT-201T · Trenton, NE · Incident · No injuries · Incident investigation · Final report · Dec 31, 1983 · N2082Y · Minor damage
  > During a precautionary landing due to a partial power loss the acft nose gear failed after colliding with a snow bank. The no. 6 cylinder wall was found broken.
- [NTSB MKC84LA047](https://openairdocs.org/ntsb/MKC84LA047.md): Cessna 172A · Hospers, IA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N7229T · Substantial damage
  > The plt said he was on a power line patrol flt & was flying aprx 60 to 80 ft AGL. Reportedly, he applied carburetor heat for about 1 min. When the carburetor heat was turned off, the eng quit. The plt reapplied the heat & the eng restarted for a moment & then…
- [NTSB MIA84LA052](https://openairdocs.org/ntsb/MIA84LA052.md): Boeing 737-201 · Near Tampa, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1983 · N811N · No damage
  > Prior to departure, the captain reviewed available wx reports & was aware of the wx conditions, including current sigmets. He decided to fly a course that was parallel to a frontal sys until he could get to an area where he could continue to his destination.…
- [NTSB LAX84FA118](https://openairdocs.org/ntsb/LAX84FA118.md): Piper PA28-235 · Irwindale, CA · Accident · No injuries · Field investigation · Final report · Dec 28, 1983 · N55665 · Substantial damage
  > According to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…
- [NTSB DEN84LA052](https://openairdocs.org/ntsb/DEN84LA052.md): Lake LA-4-200 · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Dec 28, 1983 · N39451 · Substantial damage
  > The acft was damaged in a forced landing on a highway after the engine seized. The plt said 'the engine made unusual sounds of an engine running bad.' Then it lost compression and seized. He made a forced landing on a highway and damagedthe hull. Examination…
- [NTSB ATL84FA078](https://openairdocs.org/ntsb/ATL84FA078.md): Beech BE-36 · St. Catherines, GA · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1983 · N4829M · Destroyed
  > The plt received a wx briefing at 1037 EST before departing on an IFR x-country. At 1051, a severe thunderstorm warning (#537) was issued by the national wx svc. When the plt requested an IFR clearance at 1107, he was advised of the frontal activity. About 3…
- [NTSB LAX84FA116](https://openairdocs.org/ntsb/LAX84FA116.md): Beech P35 · Mckittrick, CA · Accident · 4 fatal · Field investigation · Final report · Dec 27, 1983 · N258C · Destroyed
  > After departing on an IFR x-country flt, the acft was climbing from 7000 to 11,000 ft, when the plt was asked (at 1126) to increasing her rate of climb because of other traffic. At 1926:13, she was asked to say her alt & she said she was at 9500 ft. at…
- [NTSB FTW84FA104](https://openairdocs.org/ntsb/FTW84FA104.md): Beech 58 · Marquez, NM · Accident · 4 fatal · Field investigation · Final report · Dec 27, 1983 · N9121S · Destroyed
  > The acft was flown at altitudes up to 15000 ft in areas of forecast icing. The acft was not equipped with oxygen. The acft was flown above 14000 ft for about 20 minutes after which it descended into icing conditions. Shortly thereafter, the acft made a climb…
- [NTSB CHI84LA067](https://openairdocs.org/ntsb/CHI84LA067.md): Piper PA-28R-200 · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · Dec 27, 1983 · N44042 · Substantial damage
  > The acft made an off arpt forced landing after the engine quit. According to the plt, the flt departed wichita falls, TX at 1516 with 48 gallons of fuel on board. When about 7 miles south-southeast of Terre Haute, IN, the engine quit. Theplt tried to restart…
- [NTSB DEN84LA051](https://openairdocs.org/ntsb/DEN84LA051.md): Bellanca 7GCBC · Escalante, UT · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1983 · N53846 · Substantial damage
  > About 15 min after takeoff, the plt reduced the power to aprx 40 to 50% & descended to about 300 ft AGL. When he tried to increase power, the eng faltered. He applied carburetor (carb) heat, but was unable to restore power in time to prevent a forced landing.…
- [NTSB ANC84FAG02](https://openairdocs.org/ntsb/ANC84FAG02.md): Cessna 170B · Mcgrath, AK · Accident · No injuries · Final report · Dec 26, 1983 · N2601D · Substantial damage
  > The plt reported that the eng had a partial loss of power & the application of carburetor heat did not improve the situation. He decided to land at the nearest arpt. According to the plt, the rwy was covered with aprx 2 ft of snow, and during the landing, the…
- [NTSB DEN84FA049](https://openairdocs.org/ntsb/DEN84FA049.md): Beech P35 · Near Dove Creek, CO · Accident · 1 fatal · Field investigation · Final report · Dec 25, 1983 · N8675M · Destroyed
  > The acft collided with mountainous terrain about 30 miles northwest of cortez co. the plt was on an IFR flt plan and had been advised before flt of hazardous icing conditions enroute. When the acft iced up the plt reversed course and even though descending…
- [NTSB ATL84LA074](https://openairdocs.org/ntsb/ATL84LA074.md): Cessna R182 · Pennington Gap, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1983 · N736NJ · Substantial damage
  > Enroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…
- [NTSB FTW84FA103](https://openairdocs.org/ntsb/FTW84FA103.md): Beech H35 · Taos, NM · Accident · 1 fatal · Field investigation · Final report · Dec 23, 1983 · N7933D · Substantial damage
  > The plt stated that a new fuel system had just recently been installed in miami, FL & he forgot about the new system while switching tanks & accidently turned it to the off position. When the eng quit he realized what he had done & switched back to a full…
- [NTSB ATL84LA073](https://openairdocs.org/ntsb/ATL84LA073.md): Piper PA-28-140 · Oak Mountain, AL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1983 · N56494 · Substantial damage
  > While en route, the plt arrived at a check point 18 min behind schedule. Aprx 25 min later, he tuned in an incorrect VOR frequency that he had written down on his flt plan. The station that he tuned in was east of the desired station & the geographic features…
- [NTSB LAX84FA114](https://openairdocs.org/ntsb/LAX84FA114.md): Cessna 182E · Humbolt, NV · Accident · 3 fatal · Field investigation · Final report · Dec 22, 1983 · CGCGA · Destroyed
  > While on a x-country flt in a mountainous area, the acft crashed into the side of a snow covered mountain. Impact occurred at the 8200 ft level in prince royal canyon. The canyon sloped upward to the south & terminated at an elevation of about 8900 ft. the…
- [NTSB DEN84LA046](https://openairdocs.org/ntsb/DEN84LA046.md): Gates Learjet 25D · Eagle, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1983 · N300PL · Substantial damage
  > While en route, the aricrew encountered stronger headwinds than expected. They realized there would not be enough fuel reserved for an IFR flt to aspen, so the elected to divert to Eagle, CO. However, their landing at engle was delayed due to a snowplow (with…
- [NTSB ATL84LA070](https://openairdocs.org/ntsb/ATL84LA070.md): Piper PA-28-181 · Waverly, KY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N2767M · Substantial damage
  > About 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…
- [NTSB MKC84LA042](https://openairdocs.org/ntsb/MKC84LA042.md): Piper PA-32-260 · Schuyler, NE · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N43302 · Substantial damage
  > While descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…
- [NTSB MKC84LA041](https://openairdocs.org/ntsb/MKC84LA041.md): Cessna 310 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N809AA · Substantial damage
  > The plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the…
- [NTSB CHI84LA072](https://openairdocs.org/ntsb/CHI84LA072.md): Beech BE-77 · Covington, IN · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N3706W · Substantial damage
  > The acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained…
- [NTSB SEA84LA027](https://openairdocs.org/ntsb/SEA84LA027.md): Cessna 150F · Prosser, WA · Accident · No injuries · Limited investigation · Final report · Dec 17, 1983 · N6841F · Substantial damage
  > According to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…
- [NTSB CHI84FA063](https://openairdocs.org/ntsb/CHI84FA063.md): Cessna 150M · Stockwell, IN · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1983 · N63398 · Destroyed
  > The plt had been wx briefed & filed a flight plan at the lafayette fss. About 1 hr later he returned to the fss & asked if the fss had heard him calling on 119.6. He was advised that he had not been heard. The plt stated he would try to call when airborne. On…
- [NTSB MKC84LA038](https://openairdocs.org/ntsb/MKC84LA038.md): Piper PA-32-260 · Sikeston, MO · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N321HF · Substantial damage
  > The acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed…
- [NTSB FTW84LA099](https://openairdocs.org/ntsb/FTW84LA099.md): Hiller UH-12C · Imperial, TX · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N63MC · Substantial damage
  > The plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by…
- [NTSB ANC84LA025](https://openairdocs.org/ntsb/ANC84LA025.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N2894Z · Substantial damage
  > The plt reported that during flt, he encountered freezing rain. Although he applied carburetor heat, the eng ceased operating. During a forced landing, the right main gear collapsed & the right outboard wing panel was damaged. The plt reported that freezing…
- [NTSB MKC84LA037](https://openairdocs.org/ntsb/MKC84LA037.md): Piper PA-32-300 · Garnett, KS · Accident · No injuries · Limited investigation · Final report · Dec 15, 1983 · N4026R · Substantial damage
  > While enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.…
- [NTSB DEN84FA225](https://openairdocs.org/ntsb/DEN84FA225.md): Piper PA-32 · Alma, CO · Accident · 3 fatal · Field investigation · Final report · Dec 14, 1983 · N47403 · Destroyed
  > The plt, his brother & his sister-in-law were on a flt to attend his mother's funeral. Before taking off, the pilot received a wx briefing & was advised that VFR flt was not recommended. The plt then asked for wx reports for a southerly route & he was advised…
- [NTSB FTW84LA097](https://openairdocs.org/ntsb/FTW84LA097.md): Beech A-36 · Harrison, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1983 · N2149L · Substantial damage
  > The acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the…
- [NTSB ATL84FA064](https://openairdocs.org/ntsb/ATL84FA064.md): Piper PA-24-260B · Mcdonald, TN · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1983 · N8981P · Destroyed
  > The plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both…
- [NTSB ANC84LA023](https://openairdocs.org/ntsb/ANC84LA023.md): Piper PA-32R-301 · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Dec 12, 1983 · N3575A · Substantial damage
  > The plt stated that shortly after reaching cruise altitude the eng failed. A forced landing was made on tundra covered by encrusted snow & ice nad the gear collapsed. During the on-scene investigation the fuel injector was found to allow only a small amount…
- [NTSB NYC84LA050](https://openairdocs.org/ntsb/NYC84LA050.md): Bellanca 7GCBC Citabria · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N5041N · Substantial damage
  > The acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…
- [NTSB MIA84FA042](https://openairdocs.org/ntsb/MIA84FA042.md): Piper PA-22 · Port Richie, FL · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1983 · N3719 · Destroyed
  > The acft crashed into trees during a night forced landing after the engine quit. The surviving passenger said he had metthe two plts in a bar where they drank beer. They later went to the arpt and flew x-country about 70 miles to eat & have more beer. They…
- [NTSB FTW84LA092](https://openairdocs.org/ntsb/FTW84LA092.md): Cessna 175 · Washington, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 10, 1983 · N7666M · Destroyed
  > About 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…
- [NTSB FTW84LA091](https://openairdocs.org/ntsb/FTW84LA091.md): Cessna 152 · Winslow, AR · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 1983 · N67863 · Destroyed
  > During a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had…
- [NTSB CHI84FA058](https://openairdocs.org/ntsb/CHI84FA058.md): Cessna 207 · Put-In-Bay, OH · Accident · 4 fatal · Field investigation · Final report · Dec 10, 1983 · N208JP · Substantial damage
  > The plt & 3 passengers took off at night on an over water flt to an island in lake erie to provide help to a heart patient. No flt plan was filed & no record of a wx briefing was found. Reportedly, after takeoff, the acft disappeared in a cloud or haze. Also…
- [NTSB SEA84FA101](https://openairdocs.org/ntsb/SEA84FA101.md): Cessna T210M · East Sound, WA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1983 · N761PW · Destroyed
  > The acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…
- [NTSB LAX84FA096](https://openairdocs.org/ntsb/LAX84FA096.md): Piper PA-28-161 · Danville, CA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1983 · N2862C · Destroyed
  > The acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly…
- [NTSB CHI84LA055](https://openairdocs.org/ntsb/CHI84LA055.md): Cessna 310L · West Lafayette, IN · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 1983 · N2222F · Substantial damage
  > The plt was unable to start the eng with the batteries & made a start by using an APU. About 10 min after taking off, he noticed an off flag on the HSI. A further check was made & he discovered the left alternator was not functioning. He then checked the…
- [NTSB MKC84FA034](https://openairdocs.org/ntsb/MKC84FA034.md): Cessna 21ON · Wentzville, MO · Accident · Serious injuries · Field investigation · Final report · Dec 6, 1983 · N5209C · Substantial damage
  > The acft was landed with the landing gear partially extended during a forced landing after an engine failure. The plt delayed the extension of the gear because of the condition of the landing area. Examination of the engine showed a failure of the #2…
- [NTSB NYC84LA045](https://openairdocs.org/ntsb/NYC84LA045.md): Maule M-5 · Somersworth, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1983 · N62042 · Substantial damage
  > The acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and…
- [NTSB FTW84FA084](https://openairdocs.org/ntsb/FTW84FA084.md): Piper PA-22-108 · Pawnee, OK · Accident · 2 fatal · Field investigation · Final report · Dec 4, 1983 · N4579Z · Destroyed
  > The acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…
- [NTSB CHI84FA054](https://openairdocs.org/ntsb/CHI84FA054.md): Beech 77 · Sidney, OH · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1983 · N37253 · Destroyed
  > The aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported…
- [NTSB LAX84LA092](https://openairdocs.org/ntsb/LAX84LA092.md): Schweizer I-26D · Black Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N7740S · Substantial damage
  > The glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…
- [NTSB FTW84FA083](https://openairdocs.org/ntsb/FTW84FA083.md): Bellanca 17-30A · Hebbronville, TX · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1983 · N4097B · Destroyed
  > The flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised…
- [NTSB DEN84FA038](https://openairdocs.org/ntsb/DEN84FA038.md): Bell 206B · Ft. Morgan, CO · Accident · Serious injuries · Field investigation · Final report · Dec 3, 1983 · N1078V · Substantial damage
  > The helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…
- [NTSB LAX84FA087](https://openairdocs.org/ntsb/LAX84FA087.md): Piper PA-32-260 · Holtville, CA · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1983 · N3206W · Destroyed
  > The plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…
- [NTSB FTW84LA081](https://openairdocs.org/ntsb/FTW84LA081.md): Bell 206L-1 · Ardmore, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1983 · N2005A · Substantial damage
  > The plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=1983&page=2

## 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 year(c."eventDate") = 1983
  AND 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?year=1983

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