# NTSB investigations, 1982: Approach 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 9 · 433 cases ## Latest cases - [NTSB MKC83LA048](https://openairdocs.org/ntsb/MKC83LA048.md): Cessna 152 · Olathe, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1982 · N94291 · Substantial damage > The aircraft was on downwind when the engine stopped. The aircraft touched down 1000 ft short of the runway. Investigation revealed there was no fuel in the fuel tanks. - [NTSB MIA83FA055](https://openairdocs.org/ntsb/MIA83FA055.md): Piper PA-28RT-201T · St. Augustine, FL · Accident · Serious injuries · Field investigation · Final report · Dec 31, 1982 · N8412F · Destroyed > Approach control advised the flt at the time of the initiation of the approach that weather for the general area was 300 ft overcast, 2 mi in fog. The flt was cleared for the VOR rwy 13 approach. The acft struck trees about 65 ft AGL in an area about 4 mi nw… - [NTSB LAX83LVG06](https://openairdocs.org/ntsb/LAX83LVG06.md): Beech G35 · Chico, CA · Accident · No injuries · Final report · Dec 29, 1982 · N4428D · Substantial damage > The aircraft was on a flight from arcata, CA to sacramento, CA with en route stops at redding, red bluff and Chico. The pilot reported that when he was on final approach to land at Chico, the engine lost power. Subsequently, the aircraft struck elements of… - [NTSB ATL83IA085](https://openairdocs.org/ntsb/ATL83IA085.md): Boeing 737-222 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Dec 28, 1982 · N752N · No damage > The acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach… - [NTSB FTW83LA068](https://openairdocs.org/ntsb/FTW83LA068.md): Cessna 172M · Portales, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1982 · N20EB · Substantial damage > Acft collided with power lines short of the rwy. Winds were gusty 27K. - [NTSB ATL83LA075](https://openairdocs.org/ntsb/ATL83LA075.md): Cessna 210 · Valdosta, GA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1982 · N1685X · Substantial damage > Plt stated he departed adel with 12 gals of fuel. Purpose of flt was to refuel at Valdosta (25 mi). Eng quit due to fuel exhaustion 1/2 mi short of Valdosta arpt. - [NTSB FTW83IA086](https://openairdocs.org/ntsb/FTW83IA086.md): Boeing 727-223 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Dec 26, 1982 · N6810 · Minor damage > During a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The… - [NTSB ATL83FA071](https://openairdocs.org/ntsb/ATL83FA071.md): Luscombe 8A · Apex, NC · Accident · Serious injuries · Field investigation · Final report · Dec 26, 1982 · N76T · 2 aircraft · Substantial damage > The Luscombe had departed the e-w rwy in an easterly direction, had reversed course & was on a straight-in apch to rwy 27. The PA-22 entered the arpt traffic via a standard left downwind & base pattern. During final the PA-22 ended up above & slightly behind… - [NTSB MKC83FA045](https://openairdocs.org/ntsb/MKC83FA045.md): Piper PA-31-350 · Dubuque, IA · Accident · 2 fatal · Field investigation · Final report · Dec 25, 1982 · N4091U · Destroyed > At 2015 the flt contacted ARTCC & requested Dubuque wx. They were advised that Dubuque was 500 ft indefinite ceiling, sky obscured, visibility 1/2 mi fog & they would be vectored for a back course rwy 13 apch. The flt then requested the front course apch to… - [NTSB LAX83LVG05](https://openairdocs.org/ntsb/LAX83LVG05.md): Cessna TU206F · Franklin, CA · Accident · No injuries · Final report · Dec 23, 1982 · N59263 · Substantial damage > Final approach was slightly high & the student plt reduced power. As the throttle was advanced from 1400 RPM the eng quit. The acft touched down approximately 300 ft short of the rwy & rolled into a fence. The fence caught the nose gear & turned the acft… - [NTSB LAX83FUJ10](https://openairdocs.org/ntsb/LAX83FUJ10.md): Cessna T210L · Phoenix, AZ · Accident · Minor injuries · Final report · Dec 20, 1982 · N732HM · Substantial damage > After engine quit on final approach aircraft landed on the roof of a house. No evidence of fuel was found in the aircraft, pilot indicated he did not usually inspect fuel tanks for quantity. - [NTSB FTW83FRG04](https://openairdocs.org/ntsb/FTW83FRG04.md): Cessna 182L · Near Mcallen, TX · Accident · 2 fatal · Final report · Dec 20, 1982 · N42717 · Destroyed > The aircraft departed Mcallen, TX at 1903 CST to an unknown destination. During departure, it was observed heading northwest. About 1 1/2 hrs later, it was again observed in the vicinity, about 7 miles northwest of Mcallen, TX. Witnesses stated that the plane… - [NTSB MKC83LA040](https://openairdocs.org/ntsb/MKC83LA040.md): Piper PA-32RT · Sullivan, MO · Accident · No injuries · Limited investigation · Final report · Dec 19, 1982 · N39487 · Substantial damage > Aircraft landed short of runway and collapsed right main landing gear. As aircraft slid into some brush the nose gear collapsed. - [NTSB LAX83FUG10](https://openairdocs.org/ntsb/LAX83FUG10.md): Norman Negus KR-2 · Hemet, CA · Accident · Serious injuries · Final report · Dec 18, 1982 · N2NN · Destroyed > The owner of the home built aircraft was checking out the other pilot who was second-in-command (SIC). The SIC also had a home built of the same make and model. The objective was to provide familiarization to the SIC. During an approach to land, they elected… - [NTSB FTW83FRG03](https://openairdocs.org/ntsb/FTW83FRG03.md): Cessna 340 · Benavides, TX · Accident · 2 fatal · Final report · Dec 17, 1982 · N5906M · Destroyed > A deer hunter saw the aircraft on a final approach to an open field at dusk, with the gear and flaps down. He stated that when it was at about 100 ft AGL, the nose pitched down and the plane struck the ground and burst into flames. The aircraft was loaded… - [NTSB CHI83FA059](https://openairdocs.org/ntsb/CHI83FA059.md): Cessna T210 · Defiance, OH · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1982 · N297EB · Destroyed > Aircraft crashed during non-precision approach in weather that was below minimums for that type of approach. - [NTSB ATL83LA065](https://openairdocs.org/ntsb/ATL83LA065.md): Piper PA-28-180 · Midland, VA · Accident · No injuries · Limited investigation · Final report · Dec 14, 1982 · N7243W · Substantial damage > The pilot and flight instructor (CFI) were on an instructional flight for a biennial flight review. The pilot reported that during the landing, the sun was in his eyes. He stated that on final approach, the aircraft encountered a downdraft and struck a… - [NTSB LAX83FUM02](https://openairdocs.org/ntsb/LAX83FUM02.md): Beech C24R · Ramona, CA · Accident · Minor injuries · Final report · Dec 13, 1982 · N38034 · Substantial damage > The acft collided with a steel supporting cable attached to a power line pole during a go-around (missed approached). It was a dark night with varying degrees of visibility near the ground due to fog. There were two plts on board the accident acft but the one… - [NTSB LAX83LA058](https://openairdocs.org/ntsb/LAX83LA058.md): Cessna 206 · Merced, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1982 · N4687F · Substantial damage > The transcript revealed that the plt was cleared for an ILS rwy 30 apch approximately 2 mi from the outer marker. The wx given to the plt at that time was indefinite ceiling zero, sky obscured & visibility zero with fog. The plt stated an instrument apch was… - [NTSB ATL83AA059](https://openairdocs.org/ntsb/ATL83AA059.md): Cessna 421B · Savannah, GA · Accident · 4 fatal · Final report · Dec 11, 1982 · N8001Q · Destroyed > Plt reported he was on a missed approach & was returning to charleston "heading 360 degrees..." The acft crashed about 1/4 mi south & 100 ft short of the departure end of rwy 27. The wreckage scatter pattern was oriented on a heading of 155 deg. Missed… - [NTSB ATL83LA057](https://openairdocs.org/ntsb/ATL83LA057.md): Cessna 182B · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Dec 9, 1982 · N4718S · Substantial damage > The aircraft collided with trees during a landing approach in instrument meeorological conditions on a dark night. A VFR flight plan was filed. The aircraft was damaged in the collision but the pilot managed to continue the approach and land. No injuries were… - [NTSB LAX83FA051](https://openairdocs.org/ntsb/LAX83FA051.md): Cessna 172N · Casa Grande, AZ · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1982 · N734MU · Destroyed > The aircraft flew into wires 34 feet above ground 800 feet from the runway at dusk. The wires were marked and both the student pilot and the instructor were aware of them. A no flap landing was being attempted. This was one of several landings made. All… - [NTSB ATL83IA050](https://openairdocs.org/ntsb/ATL83IA050.md): Boeing 737-201 · Winston-Salem, NC · Incident · No injuries · Incident investigation · Final report · Dec 6, 1982 · N798N · Minor damage > The flt from buffalo was reported as choppy & the chop continued during the descent. Wx was noted on the airborne radar sw & nw of the arpt. As the acft approached the outer marker the crew observed cloud to ground lightning near the arpt & were infromed that… - [NTSB MKC83FA032](https://openairdocs.org/ntsb/MKC83FA032.md): Cessna 340 · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Dec 4, 1982 · N4094L · Substantial damage > The plt listed a total fuel endurance of 5+30 on his flt plan & a total of 182 gals at takeoff on his plt/operator accident report. The total acft fuel capacity is 162 gals. The flt departed a 1055. At 1527 the plt received destinationwx of ceiling indefinite… - [NTSB LAX83LA045](https://openairdocs.org/ntsb/LAX83LA045.md): Cessna 195B · Peoria, AZ · Accident · No injuries · Limited investigation · Final report · Dec 4, 1982 · N195JB · Substantial damage > The pilot reported that he took off to flight test the aircraft. After takeoff, he turned downwind to stay in the traffic pattern. On downwind, the power was reduced to maintain spacing behind a Cessna 150. When this was accomplished, the engine power began… - [NTSB NYC83LA038](https://openairdocs.org/ntsb/NYC83LA038.md): Mooney M20F · North Caldwell, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1982 · N6871V · Substantial damage > The pilot stated that he encountered a fog bank while making a straight in landing at essex county airport. The pilot attempted to climb and still maintain visual contact with the ground, however the aircraft collided with a tree. - [NTSB NYC83FA039](https://openairdocs.org/ntsb/NYC83FA039.md): Cessna 401 · Monticello, NY · Accident · No injuries · Field investigation · Final report · Dec 3, 1982 · N4073Q · Substantial damage > The aircraft collided with trees during an instrument approach to sullivan county international airport. An IFR flight plan was filed and the weather was IMC. It appears that the pilot did not receive a complete and current weather briefings and got his… - [NTSB FTW83FA051](https://openairdocs.org/ntsb/FTW83FA051.md): Bell 206L1 · Gulf Of Mexico · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1982 · N2252Z · Destroyed > The plt reported that the acft was higher than he intended to be over the platform & had set up a right downwind apch. He had trouble keeping up the ground track due to strong gusty winds. He was almost over the platform & made a large correction & began… - [NTSB NYC83FA037](https://openairdocs.org/ntsb/NYC83FA037.md): Piper PA-32-260 · Douglassville, PA · Accident · 3 fatal · Field investigation · Final report · Dec 2, 1982 · N32750 · Destroyed > At aprx 1540 EST, the acft was dispatched to philadelphia, PA on a pax flt. After arriving, the plt remained there to pick up 4 other pax that were arriving at approx 2100 EST. At 2007, the plt received a partial wx brief & filed an IFR flt plan to rtn to… - [NTSB DEN83FA027](https://openairdocs.org/ntsb/DEN83FA027.md): Cessna P210 · Sioux Falls, SD · Accident · 2 fatal · Field investigation · Final report · Dec 1, 1982 · N4721P · Destroyed > At 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy… - [NTSB CHI83FA050](https://openairdocs.org/ntsb/CHI83FA050.md): Cessna 177 · Medina, OH · Accident · 1 fatal · Field investigation · Final report · Dec 1, 1982 · N29528 · Destroyed > At about 1430 EST, the pilot took off from freedom field, Medina, OH in VFR conditions. When he returned about 3 hrs later at dusk, the weather was estimated to be: 400 ft overcast, 3/4 mi visibility with fog. A flight instructor heard the plane fly over the… - [NTSB MIA83LA040](https://openairdocs.org/ntsb/MIA83LA040.md): Cessna 172J · Lowell, FL · Accident · No injuries · Limited investigation · Final report · Nov 28, 1982 · N79412 · Substantial damage > While attempting a go-around maneuver, the aircraft tail struck treetops that were located at the departure end of runway 18. The pilot landed the aircraft safely and discovered damage to the right horizontal stabilizer and the fuselage. - [NTSB ATL83FKG05](https://openairdocs.org/ntsb/ATL83FKG05.md): Piper PA-28-161 · Pine Moutain, GA · Accident · No injuries · Final report · Nov 26, 1982 · N8451R · Substantial damage > Due to local wx conditions, the acft was receiving radar vectors to columbus, GA. Enroute to columbus, the plt elected to land at the callay gardens-harris county arpt. During final approach, he encountered a downdraft & struck several trees. He then added… - [NTSB ANC83LA017](https://openairdocs.org/ntsb/ANC83LA017.md): Piper PA-22 · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Nov 22, 1982 · N1461A · Substantial damage > The plt stated as he approached Cordova he smelled & observed smoke in the cockpit. He reduced power & commenced a modified approach to rwy 9 which was nearest his position. When he elected to add power the engine did not respond. The plt turned & landed on a… - [NTSB CHI83LA046](https://openairdocs.org/ntsb/CHI83LA046.md): Stinson 108 · Milan, MI · Accident · No injuries · Limited investigation · Final report · Nov 21, 1982 · N8836K · Substantial damage > While on downwind the pilot stated he "pulled the carburator heat on and almost immediately reduced the power." At this point the engine stopped. Although he attempted to restart the engine while executing emergency procedures, the engine failed to respond.… - [NTSB CHI83LA045](https://openairdocs.org/ntsb/CHI83LA045.md): Pitts S1S · Wonewoc, WI · Accident · No injuries · Limited investigation · Final report · Nov 21, 1982 · N22WB · Substantial damage > The pilot stated that when he turned on final and slipped the aircraft to lose altitude. While reducing the power to idle the gear tangled in high grass (weeds), causing the aircraft to lose additional altitude. He stated the aircraft tumbled forward,… - [NTSB LAX83FA038](https://openairdocs.org/ntsb/LAX83FA038.md): Cessna P206B · Near Shafter, NV · Accident · 5 fatal · Field investigation · Final report · Nov 20, 1982 · N8606Z · Destroyed > Pilot flew into the ground turning on final approach. Left wing and landing gear made first ground contact. The night was dark and terrain lacked lights. The runway was lighted. There were no known malfunctions to equipment. None of the occupants on board had… - [NTSB ATL83FA040](https://openairdocs.org/ntsb/ATL83FA040.md): Cessna 411 · Aiken, SC · Accident · 2 fatal · Field investigation · Final report · Nov 20, 1982 · N544JW · Destroyed > The plt requested an instrument approach to the arpt & advised approach control (a/c) that he did not have an approach plate for the arpt. A/c cleared the acft for a NDB approach to rwy 24 & read the approach information to the plt. When the plt reported… - [NTSB FTW83LA040](https://openairdocs.org/ntsb/FTW83LA040.md): Bell 206B · Port O'Connor, TX · Accident · No injuries · Limited investigation · Final report · Nov 19, 1982 · N16659 · Substantial damage > The pilot reported that when he took off at 1348 CST, the weather was 400 ft overcast, 2 to 5 mi visibility with rain. About 10 min later, he arrived at the Port O'Connor jetty and could see across matagorda bay to Port O'Connor. About halfway across the bay,… - [NTSB ATL83FA036](https://openairdocs.org/ntsb/ATL83FA036.md): Mooney M20J · Sardis, AL · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1982 · N7201Y · Destroyed > The aircraft was on an IFR flight from memphis, TN to selma, AL. During arrival, he was cleared for an NDB approach to the craig airport. At that time, the weather was reported as measured 400 ft overcast, visibility 1/2 mi with fog. The weather minimums for… - [NTSB CHI83LA040](https://openairdocs.org/ntsb/CHI83LA040.md): Piper 601P · Sheboygan, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 1982 · N6078U · Destroyed > The plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around. - [NTSB DEN83LA020](https://openairdocs.org/ntsb/DEN83LA020.md): Piper 28-140 · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Nov 15, 1982 · N6385R · Substantial damage > The pilot failed to enrich mixture during descent from 10,000 feet. Power was lost during the approach and a forced landing made in a pasture. During the landing the aircraft collided with a fence and ground-looped collapsing the landing gear. - [NTSB MKC83LA020](https://openairdocs.org/ntsb/MKC83LA020.md): Piper PA-28-180 · Marengo, IA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1982 · N1443T · Substantial damage > Pilot overflew the area and saw no obstructions. Planned to land well down the runway. Saw wires 75 feet from runway. He says wires were 70 feet high and 50 feet from runway. - [NTSB LAX83LVW01](https://openairdocs.org/ntsb/LAX83LVW01.md): Amateur Built Quickie Q2 · Death Valley, CA · Accident · Serious injuries · Final report · Nov 14, 1982 · N1234 · Destroyed > The pilot reported that when he was about 100 from the touchdown point, "the bottom fell out and we hit ground." An investigation revealed that the plane initially impacted with a 6 ft sand dune about 60 ft from the approach end of the runway. There was… - [NTSB MKC83FA019](https://openairdocs.org/ntsb/MKC83FA019.md): Cessna 501 · Wichita, KS · Accident · No injuries · Field investigation · Final report · Nov 12, 1982 · N2627U · Substantial damage > A non-pilot mechanic employed at the manufacturer's facility took off in the acft. The acft was observed entering a very steep climb & appeared to stall. The nose was lowered & the acft turned left & entered a downwind leg to rwy 1R. It then turned onto a low… - [NTSB NYC83LA027](https://openairdocs.org/ntsb/NYC83LA027.md): Cessna 402 · Danielson, CT · Accident · No injuries · Limited investigation · Final report · Nov 10, 1982 · N4032Q · Substantial damage > On final the pilot realized he was late in reducing power and attempted to correct by abruptly bringing power back. A high sink rate was experienced and the pilot immediately applied full power. The aircraft impacted short of the runway. - [NTSB ANC83LA013](https://openairdocs.org/ntsb/ANC83LA013.md): Beech A36 · Fort Yukon, AK · Accident · No injuries · Limited investigation · Final report · Nov 10, 1982 · N36829 · Substantial damage > During a night approach to runway 03 at Fort Yukon, AK, the pilot neglected to activate the runway lights, as prescribed on the jeppeson approach chart, and mistook a row of white lights on buildings as the runway lights. Upon landing on a parking ramp the… - [NTSB MKC83FA017](https://openairdocs.org/ntsb/MKC83FA017.md): Grumman American GA-7 · Norfolk, NE · Accident · 1 fatal · Field investigation · Final report · Nov 9, 1982 · N715GA · Destroyed > The aircraft collided with trees and crashed in an open meadow during an instrument approach at night. The pilot said the landing lights reflected in his eyes during approach so he turned them off. The pilot failed to obtain the latest weather before his… - [NTSB FTW83FPM03](https://openairdocs.org/ntsb/FTW83FPM03.md): Cessna 152 · Tulsa, OK · Accident · Minor injuries · Final report · Nov 8, 1982 · N67798 · Substantial damage > On the day before the accident the plt flew the acft to excelsor springs, MO for refueling, returning to liberty. On 11/7/82 at 1545 the flt departedliberty on an IFR flt plan. Approximately 7 mi north of Tulsa intl arpt the plt elected to land at Tulsa for… - [NTSB MKC83FCA02](https://openairdocs.org/ntsb/MKC83FCA02.md): Bensen M8M · Gerald, MO · Accident · Serious injuries · Final report · Nov 7, 1982 · N31048 · Substantial damage > The eng quit on the downwind leg of the traffic pattern after takeoff. The flexible fuel supply line from the fuel tank to the fuel pump was disconnected. The hose clamp was positioned & tightened so that the line could not have been properly installed on the… Next page: https://openairdocs.org/ntsb-phases/500/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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/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.