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

## Cases, newest first

- [NTSB NYC83FA052](https://openairdocs.org/ntsb/NYC83FA052.md): Robinson R22 · Milford, CT · Accident · No injuries · Field investigation · Final report · Jan 8, 1983 · N9017Y · Substantial damage
  > The helicopter collided with a telephone pole during an autorotation forced landing after an engine malfunction. The aircraft was cruising at 500 feet when there was an audible decrease in main rotor and engine RPM. The rotor RPM was between 80-85 percent…
- [NTSB DEN83LA048](https://openairdocs.org/ntsb/DEN83LA048.md): Cessna P210N · Glade Park, CO · Accident · No injuries · Limited investigation · Final report · Jan 8, 1983 · N3886P · Substantial damage
  > The acft landing gear collapsed during a forced landing after an engine failure. The pilot said he lost manifold and oilpressure and turned back toward grand junction when the engine began making loud noises. A landing was made on a slippery road and the acft…
- [NTSB LAX83LXQ03](https://openairdocs.org/ntsb/LAX83LXQ03.md): Cessna 152 · 2 Mi East Mina, NV · Accident · No injuries · Final report · Jan 7, 1983 · N25334 · Substantial damage
  > The aircraft made a forced landing on a dirt road, collided with some rocks and nosed over. The engine had failed because of fuel exhaustion. The pilot said he refueled the previous day but did not physically check the fuel the day of the accident. The…
- [NTSB SEA83FA037](https://openairdocs.org/ntsb/SEA83FA037.md): Cessna T210N · Portland, OR · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1983 · N5370Y · Destroyed
  > The acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…
- [NTSB NYC83FA049](https://openairdocs.org/ntsb/NYC83FA049.md): Piper PA-30 · Atlantic City, NJ · Accident · 2 fatal · Field investigation · Final report · Jan 6, 1983 · N7619Y · Destroyed
  > The plt had landed at Atlantic City, NJ at aprx 1545 while en route to oxford, CT. Before taking off, he contacted two fss's and both advised that VFR flt was not recommended. The non-instrument rated plt took off at aprx 1920 local time with no flt plan. At…
- [NTSB DEN83FA045](https://openairdocs.org/ntsb/DEN83FA045.md): Bell 206B III · Sula, MT · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1983 · N55LW · Substantial damage
  > The helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…
- [NTSB NYC83LA048](https://openairdocs.org/ntsb/NYC83LA048.md): North American AT-6D · Granville, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1983 · N29947 · Destroyed
  > Aircraft on cross-country flight ran out of fuel and made an emergency landing in a field and collided with a few scattered apple trees. Ironically there was an airport adjacent to the landing site. The pilot had encountered cloud cover at his destination and…
- [NTSB ATL83LA082](https://openairdocs.org/ntsb/ATL83LA082.md): Cessna T210L · Horse Cave, KY · Accident · No injuries · Limited investigation · Final report · Jan 5, 1983 · N1741X · Substantial damage
  > The pilot reported that he encountered turbulence, and at about the same time, the engine began running rough. He began troubleshooting and discovered that the roughness was directly proportional to throttle movement; when the throttle was advanced, the…
- [NTSB SEA83FA038](https://openairdocs.org/ntsb/SEA83FA038.md): Cessna T303 · Willard, WA · Accident · 5 fatal · Field investigation · Final report · Jan 4, 1983 · N6087C · Destroyed
  > Before takeoff, the plt received a wx briefing & filed an IFR flt plan to Idaho falls, id at 1300 ft. he took off at 1804 PST. At 1814 PST, just prior to calling level at 13,000 ft, he reported he was encountering light turbulence & light rime ice. Aprx 4 min…
- [NTSB LAX83FXQ02](https://openairdocs.org/ntsb/LAX83FXQ02.md): Piper PA-28-235 · Mammoth Lakes, CA · Accident · No injuries · Final report · Jan 4, 1983 · N1931T · Substantial damage
  > After departure from the Mammoth Lakes arpt (elev 7128 ft), the acft was slow to climb & eng power began to deteriorate. It was dark & the plt was unable to reach the departure arpt, so he began an emergency landing on the northbound lanes of highway 395. All…
- [NTSB FTW83LA075](https://openairdocs.org/ntsb/FTW83LA075.md): Cessna T210N · Orla, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 3, 1983 · N5289Y · Substantial damage
  > On the 2nd leg of his daily check run from dallas to el paso the pilot reported to ft worth ARTCC that he had an engine failure and was going to land on a road. He did not make the road and landed in open terrain with the landing gear up. Fuel system…
- [NTSB CHI83LA070](https://openairdocs.org/ntsb/CHI83LA070.md): Cessna 172 · Greenburg, IN · Accident · No injuries · Limited investigation · Final report · Jan 2, 1983 · N7230G · Substantial damage
  > The pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…
- [NTSB ATL83LA080](https://openairdocs.org/ntsb/ATL83LA080.md): Swearingen SA-226TC · Laurel, MS · Accident · No injuries · Limited investigation · Final report · Jan 2, 1983 · N5291M · Substantial damage
  > At 11,000 ft MSL during cruise a prop separated from the left eng. The eng was feathered & the plt observed the eng displaced inboard & downward. An emergency landing was made & upon landing the left main gear was found to be retracted. The acft slid to a…
- [NTSB ATL83FA081](https://openairdocs.org/ntsb/ATL83FA081.md): Piper PA-24-250 · Beaufort, SC · Accident · 3 fatal · Field investigation · Final report · Jan 2, 1983 · N8066P · Destroyed
  > While en route in IMC, the ATC controller noted that the acft began to reverse course & asked the plt if he was having a problem. The plt responded that the acft was in clouds, he was having problem with his artificial horizon & that he didn't realize he was…
- [NTSB CHI83LA067](https://openairdocs.org/ntsb/CHI83LA067.md): Cessna T210N · Cassville, WI · Accident · No injuries · Limited investigation · Final report · Jan 1, 1983 · N6594N · Destroyed
  > The pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…
- [NTSB FTW83LA074](https://openairdocs.org/ntsb/FTW83LA074.md): Cessna 210N · Houston, TX · Accident · No injuries · Limited investigation · Final report · Dec 31, 1982 · N6610Y · Substantial damage
  > Enroute in IMC the acft had a complete electrical failure. The plt descended to VFR conditions & elected to land at weiser arpt. The plt lowered the gear electrically but did not receive a green down & locked indication. He then pumped the emergency extension…
- [NTSB LAX83LA031](https://openairdocs.org/ntsb/LAX83LA031.md): Cessna 150M · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 1982 · N6066K · Substantial damage
  > The pilot stated that due to visibility restrictions caused by haze, he was flying by reference to interstate highway I-5 at low altitude. He estimated that the visibility was between 3 and 5 miles. At the intersection of I-5 and panoche road, the aircraft…
- [NTSB FTW83IA072](https://openairdocs.org/ntsb/FTW83IA072.md): Mcdonnell-Douglas DC-10-30 · Thermal, CA · Incident · Minor injuries · Incident investigation · Final report · Dec 30, 1982 · N137AA · No damage
  > At about 1458 PST, the aircraft encountered moderate to severe clear air turbulence for a period of 8 to 10 seconds while climbing through 35,500 ft. seven passengers and seven flight attendants received minor injuries. The seat belt sign had been turned on…
- [NTSB CHI83LA066](https://openairdocs.org/ntsb/CHI83LA066.md): Cessna 182N · Jeffersonville, IN · Accident · No injuries · Limited investigation · Final report · Dec 30, 1982 · N9180G · Substantial damage
  > The aircraft engine quit at 2500 feet after takeoff. The pilot could not restart engine. A forced landing was made in anopen field and the aircraft nosed over during the rollout. No reason for the engine power loss was determined.
- [NTSB ATL83LA077](https://openairdocs.org/ntsb/ATL83LA077.md): Beech 58P · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Dec 30, 1982 · N2038P · Substantial damage
  > About 40 mi from destination in heavy rain, both alternators failed. Electrical load was reduced & a radar monitored ILS apch was made. After descent through the clouds into VMC an attempt was made to lower the landing gear electrically. At that time all…
- [NTSB ATL83FKG07](https://openairdocs.org/ntsb/ATL83FKG07.md): Piper PA-28R-200 · Lumber City, GA · Accident · Serious injuries · Final report · Dec 30, 1982 · N2805R · Destroyed
  > During flight, the oil pressure began dropping rapidly just after the engine RPM abruptly increased. Minutes later, the RPM decreased and the engine failed. While the pilot was making a forced landing in darkness, the aircraft struck an object just before…
- [NTSB DEN83FA041](https://openairdocs.org/ntsb/DEN83FA041.md): Cessna T210M · Robertson, WY · Accident · 1 fatal · Field investigation · Final report · Dec 28, 1982 · N6252B · Destroyed
  > The acft collided with gently rolling snow covered terrain. A small empty plastic medicine bottle labeled nadalol was found at the wreckage. Nadalol is used to control dizziness, fatigue & mental depression, & is basically a beta blocker. According to the…
- [NTSB FTW83LA069](https://openairdocs.org/ntsb/FTW83LA069.md): Cessna A185F · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1982 · N121BJ · Substantial damage
  > The eng quit while the amphibious acft was over the city. The acft had insufficient altitude to reach the Mississippi river & the plt made a forced landing on a residential street. The left main tank contained 14 gals of fuel & no usable fuel was in the right…
- [NTSB FTW83LA067](https://openairdocs.org/ntsb/FTW83LA067.md): Beech C23 · Childress, TX · Accident · No injuries · Limited investigation · Final report · Dec 26, 1982 · N9256S · Substantial damage
  > During flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…
- [NTSB FTW83FRD01](https://openairdocs.org/ntsb/FTW83FRD01.md): Piper PA-28R-200 · Henderson, LA · Accident · 3 fatal · Final report · Dec 26, 1982 · N5369T · Destroyed
  > The pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…
- [NTSB FTW83FA087](https://openairdocs.org/ntsb/FTW83FA087.md): Piper PA-32-300 · Animas, NM · Accident · 7 fatal · Field investigation · Final report · Dec 26, 1982 · XAHIJ · Destroyed
  > The acft departed ague prieta, sonora, Mexico with no flt plan on a flt to janos, chihuahua, Mexico. Drg departure, the plt's son observed a dark threatening cloud bank in the direction of flt near a mtn range. When the acft did not arrive at the destination,…
- [NTSB CHI83LA065](https://openairdocs.org/ntsb/CHI83LA065.md): Cessna 177 · Dayton, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1982 · N3136T · Substantial damage
  > The pilot took off with an estimate 4 hrs of fuel on board. While en route, he encountered headwinds that were stronger than expected. After about 3 hrs and 48 min of flight, he was still about 27 to 28 mi from his destination and diverted to the Dayton…
- [NTSB ANC83LA027](https://openairdocs.org/ntsb/ANC83LA027.md): Piper PA-18-150 · Hope, AK · Accident · No injuries · Limited investigation · Final report · Dec 25, 1982 · N8653Y · Substantial damage
  > The aircraft lost power during descent and crashed into trees. The weather was VMC and no flight plan was filed. The pilot said he was descending with reduced power and when he turned carburetor heat on the engine began to miss so he turned carburetor heat…
- [NTSB FTW83FA066](https://openairdocs.org/ntsb/FTW83FA066.md): Bell 206B · San Antonio, TX · Accident · 3 fatal · Field investigation · Final report · Dec 23, 1982 · N206H · Destroyed
  > The acft departed brackettville at 0715 & at 0740 contacted uvalde UNICOM for their wx. When informed that uvalde was "zero-zero" the flt continued east. The acft was later observed & heard flying above the low indefinite ceiling shortly before impacting the…
- [NTSB FTW83LA065](https://openairdocs.org/ntsb/FTW83LA065.md): Cessna 150 · Nash, OK · Accident · No injuries · Limited investigation · Final report · Dec 22, 1982 · N14084 · Substantial damage
  > Pilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.
- [NTSB MKC83FA041](https://openairdocs.org/ntsb/MKC83FA041.md): Piper PA-28-161 · Bancroft, IA · Accident · 3 fatal · Field investigation · Final report · Dec 20, 1982 · N2838V · Destroyed
  > The acft impacted the ground in a near wings level, 20 deg nose down attitude at a high rate of speed. Witnesses statedthat the weather was clear & visibility good but it was a very dark night with only a very small portion of the moon showing. The only…
- [NTSB NYC83FA045](https://openairdocs.org/ntsb/NYC83FA045.md): Cessna 182N · Ringwood, NJ · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1982 · N92612 · Substantial damage
  > The plt declared an emergency due to power loss & the acft crashed into a reservoir. Engine examination disclosed numerous pieces of the induction air filter throughout the engine. Filter paper was found lodged between the intake valve & valve seat of the #5…
- [NTSB CHI83LA061](https://openairdocs.org/ntsb/CHI83LA061.md): Cessna 310R · Gaylord, MI · Accident · No injuries · Limited investigation · Final report · Dec 18, 1982 · N1777E · Substantial damage
  > Prior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…
- [NTSB SEA83FYM02](https://openairdocs.org/ntsb/SEA83FYM02.md): Enstrom 280C · North Plains, OR · Accident · 2 fatal · Final report · Dec 17, 1982 · N5686Z · Destroyed
  > At about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…
- [NTSB MKC83FA038](https://openairdocs.org/ntsb/MKC83FA038.md): Piper PA-32R-300 · Dewitt, NE · Accident · No injuries · Field investigation · Final report · Dec 17, 1982 · N6855F · Substantial damage
  > As the flt approached destination the alternator began to malfunction. Plt continued to destination which was IMC, and as the gear was lowered during an instrument approach the nose gear indicated unsafe. The approach was discontinued and the plt climbed back…
- [NTSB MIA83LA051](https://openairdocs.org/ntsb/MIA83LA051.md): Cessna 172 · Near Ramey, PR · Accident · No injuries · Limited investigation · Final report · Dec 17, 1982 · N4481L · Destroyed
  > During cross-country VFR day flight pilot became lost and was receiving radio help in orientation when fuel was exhausted and aircraft ditched about 68 nmi north of Ramey, PR.
- [NTSB FTW83FA060](https://openairdocs.org/ntsb/FTW83FA060.md): Beech A36 · Carlsbad, TX · Accident · 4 fatal · Field investigation · Final report · Dec 17, 1982 · N6662Y · Destroyed
  > The pilot and passengers had departed the san angelo airport at about 1800 CST on the day of the accident. They stopped at midland, TX where they borrowed a courtesy car and drove to a restaurant. Later, the aircraft departed on a return flight. At about 2320…
- [NTSB DEN83LA035](https://openairdocs.org/ntsb/DEN83LA035.md): Piper PA-28R-200 · Cut Bank, MT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1982 · CGKBJ · Substantial damage
  > The aircraft experienced a total electrical failure while enroute. On arrival, the pilot selected gear down, however it would not lower. He misidentified the operation of the emergency gear down switch and pushed it up instead of down. The pilot stated that…
- [NTSB DEN83LA034](https://openairdocs.org/ntsb/DEN83LA034.md): Cessna TR182 · Billings, MT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1982 · N756AX · Substantial damage
  > After power failure pilot landed on a highway and collided with an auto. No evidence of fuel was found in the aircraft.
- [NTSB SEA83LA032](https://openairdocs.org/ntsb/SEA83LA032.md): Hughes 369HS · Chemult, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1982 · N90876 · Substantial damage
  > The flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…
- [NTSB LAX83FUJ08](https://openairdocs.org/ntsb/LAX83FUJ08.md): Cessna T210M · Phoenix, AZ · Accident · Minor injuries · Final report · Dec 15, 1982 · N761CH · Substantial damage
  > Aircraft landed gear up short of destination in open field when fuel was exhausted. Pilot did not visually check tanks because a ladder was not available at the last stop before accident.
- [NTSB MKC83IA035](https://openairdocs.org/ntsb/MKC83IA035.md): Beech 100 · Wichita, KS · Incident · No injuries · Incident investigation · Final report · Dec 13, 1982 · N85BH · Minor damage
  > Pilot reported that while cruising at 18000 feet, the pressurized portion of the second window blew out. The inside window remained intact and the cabin slowly depressurized. The pilot made an uneventful landing. The window was replaced by a later production…
- [NTSB ATL83LA062](https://openairdocs.org/ntsb/ATL83LA062.md): Cessna 182 · Phenix City, AL · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N52742 · Substantial damage
  > Aircraft had power loss during cruise and during the off airport landing a soft spot was hit and aircraft nosed over. Contaminates were found in fuel. Tank caps did not seal properly. Visual inspection of the fuel cell bladder disclosed permanent 1/2 to 3/4…
- [NTSB ANC83LA021](https://openairdocs.org/ntsb/ANC83LA021.md): Piper PA-34-200T · Gambell, AK · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N8225Y · Substantial damage
  > On 12/12/82, the aircraft departed on a flight from savoonga to nome, AK. After departure, the pilot noted a problem with the left engine and diverted to Gambell, AK. While en route to Gambell, there was a gradual loss of oil pressure. After landing, the…
- [NTSB NYC83FA041](https://openairdocs.org/ntsb/NYC83FA041.md): Cessna 177B · Starrucca, PA · Accident · 1 fatal · Field investigation · Final report · Dec 12, 1982 · N34595 · Destroyed
  > During a weather briefing before takeoff, the student pilot was advised of icing conditions, turbulence, snowshowers and snow squalls along ridges north of the wilkes-barre/scranton, PA area. The weather briefer indicated that VFR flight was not recommended.…
- [NTSB ATL83FA060](https://openairdocs.org/ntsb/ATL83FA060.md): Grumman American AA-1B · Summerville, WV · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1982 · N1621R · Substantial damage
  > On 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…
- [NTSB CHI83IA054](https://openairdocs.org/ntsb/CHI83IA054.md): Gates Lear Jet 35A · Over Fargo, ND · Incident · No injuries · Incident investigation · Final report · Dec 10, 1982 · N1500E · Minor damage
  > While level at FL370 Over Fargo, ND, the crew heard a loud bang in the engine area and the aircraft experienced a sudden loss of cabin pressure. At the same time, the crew noticed that they had lost power on the #2 engine. After securing the engine and…
- [NTSB ATL83LA058](https://openairdocs.org/ntsb/ATL83LA058.md): Piper PA-28-181 · Heflin, AL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1982 · N22199 · Substantial damage
  > While on a pleasure flight the pilot experienced a fluctuation in his alternator indicator. Soon afterwards the alternator panel warning light came on. The pilot assumed his battery had gone dead after his radio lights also ceased to operate. At that point…
- [NTSB LAX83IA056](https://openairdocs.org/ntsb/LAX83IA056.md): Cessna 551 · Near Palm Sprin, CA · Incident · No injuries · Incident investigation · Final report · Dec 9, 1982 · N1218V · Minor damage
  > Shortly after takeoff and climbout, the autopilot malfunctioned after the aircraft entered an overcast and encountered rain and turbulence. The pilot returned to bermuda dunes, CA. After landing he had the electrical, avionics and auto pilot systems checked.…
- [NTSB LAX83FA055](https://openairdocs.org/ntsb/LAX83FA055.md): Piper PA-31-350 · 500 Nm E, Honolulu, HI · Accident · 2 fatal · Field investigation · Final report · Dec 9, 1982 · N74957 · Destroyed
  > The acft departed oakland, CA at 1733 PST on a night flight to honolulu, HI. The flt proceeded without incident until aprx 0050 PST when the plt advised that the left eng was slowly losing oil pressure. At that time, the acft was at an alt of 6000 ft. at…

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

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

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