# NTSB investigations, 1982: 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 16 · 786 cases ## Latest cases - [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… - [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. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=1982&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") = 1982 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=1982 --- 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.