# NTSB investigations, 1982: Taxi

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 3 · 127 cases

## Latest cases

- [NTSB LAX83LUG12](https://openairdocs.org/ntsb/LAX83LUG12.md): Piper J-3 · Rubidoux, CA · Accident · No injuries · Final report · Dec 31, 1982 · N26170 · Substantial damage
  > Pilot taxiing to ramp when gust of wind blew aircraft over. Wind was variable, gusting 25 k.
- [NTSB FTW83LA071](https://openairdocs.org/ntsb/FTW83LA071.md): Cessna T337G · Pampa, TX · Accident · No injuries · Limited investigation · Final report · Dec 25, 1982 · N15U · Substantial damage
  > The plt stated he ran the battery down while trying to start the engs. After obtaining a battery charger & a long extension cord he charged the battery & was able to start the engs. While he was returning the charger to the hangar the acft rolled into a…
- [NTSB SEA83LA031](https://openairdocs.org/ntsb/SEA83LA031.md): Cessna 172L · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N3880Q · Substantial damage
  > After landing, the pilot began taxiing to the parking area. While taxiing, he came to an area where he tried to taxi between a fuel truck and a Beech baron. The pilot stated that he misjudged the distance between his right wing tip and the fuel truck and the…
- [NTSB DEN83LA026](https://openairdocs.org/ntsb/DEN83LA026.md): Boeing 737-291 · Denver, CO · Accident · No injuries · Limited investigation · Final report · Dec 10, 1982 · N7346F
  > During a "power-back" operation from the terminal gate, a ground signal person and two wing walker were used in accordance with procedures. After reverse thrust was applied and the aircraft was rolling backwards. The signal person communicated an emergency…
- [NTSB ATL83LA051](https://openairdocs.org/ntsb/ATL83LA051.md): Bellanca 8KCAB · Atkinson, NC · Accident · No injuries · Limited investigation · Final report · Dec 5, 1982 · N57423 · Substantial damage
  > The pilot decided to land on a private strip due to strong gusty winds and thunderstorms. The pilot landed without incident and began to back taxi on the runway when the left main landing gear went into a mud hole off the side of the runway. The aircraft…
- [NTSB NYC83LA036](https://openairdocs.org/ntsb/NYC83LA036.md): Fokker F-27-100 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Nov 30, 1982 · N141PM · Substantial damage
  > Aircraft collided with a power cart as taxi to takeoff began.
- [NTSB NYC83LA031](https://openairdocs.org/ntsb/NYC83LA031.md): Cessna 172RG · Middletown, PA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1982 · N5223V · Substantial damage
  > After landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…
- [NTSB ANC83LA016](https://openairdocs.org/ntsb/ANC83LA016.md): Cessna 180 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Nov 22, 1982 · N2974C · Substantial damage
  > During a power-on taxi turn the pilot reported he was about to strike a 6-FT embankment. The pilot added full power and flaps and the aircraft left the water, flew over an embankment, but the skis caught bushes on top of the bank. The landing gear was…
- [NTSB MKC83LA029](https://openairdocs.org/ntsb/MKC83LA029.md): Cessna 172M · Warrenburg, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1982 · N64029 · Substantial damage
  > Pilot had to taxi 4000 feet on runway. Aircraft became airborne, hit ground, and nosed over during this time. One witness said aircraft looked like it was taking off & stalled. Pilot said he was only going 20 mph.
- [NTSB CHI83LA039](https://openairdocs.org/ntsb/CHI83LA039.md): Piper PA-28-151 · New Hudson, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1982 · N7730C · No damage
  > The pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception…
- [NTSB ATL83LA026](https://openairdocs.org/ntsb/ATL83LA026.md): Cessna 172N · Loris, SC · Accident · No injuries · Limited investigation · Final report · Nov 7, 1982 · N2896E · Substantial damage
  > While taxiing from ramp left wingtip struck a van parked in the tie-down area.
- [NTSB MKC83LA015](https://openairdocs.org/ntsb/MKC83LA015.md): Cessna 172P · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Nov 4, 1982 · N65685 · Substantial damage
  > Pilot taxiing to takeoff went on a roadway instead of a taxiway and collided with a sign post. The taxiway was marked by signs and yellow paint lines on surface where pilot became disoriented and left taxiway to follow road.
- [NTSB ATL83LA022](https://openairdocs.org/ntsb/ATL83LA022.md): Beech B90 · Winston-Salem, NC · Accident · No injuries · Limited investigation · Final report · Nov 1, 1982 · N711GD · Substantial damage
  > The pilot was on a flight to deliver the aircraft for routine maintenance. He stated that he lost right braking action as he was approaching the maintenance hanger. He attempted to maintain directional control with propeller reversing, but the left wing hit…
- [NTSB NYC83LA044](https://openairdocs.org/ntsb/NYC83LA044.md): Piper PA-18-150 · Little Ferry, NY · Accident · No injuries · Limited investigation · Final report · Oct 31, 1982 · N3593P · Substantial damage
  > Student pilot step-taxiing from landing collided with a submerged object in the river and damaged the float. The river was at low tide.
- [NTSB CHI83LA028](https://openairdocs.org/ntsb/CHI83LA028.md): Piper PA-30 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Oct 29, 1982 · N7850Y · Substantial damage
  > The pilot taxiied onto 8 foot culvert after landing. Pilot complained of taxiway markings and lighting. He also said he never saw the culvert.
- [NTSB NYC83IA013](https://openairdocs.org/ntsb/NYC83IA013.md): Piper J3C-65 · Augusta, ME · Incident · No injuries · Incident investigation · Final report · Oct 25, 1982 · N25973 · 2 aircraft · Minor damage
  > The student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…
- [NTSB LAX83FUG04](https://openairdocs.org/ntsb/LAX83FUG04.md): Cessna 402B · Upland, CA · Accident · No injuries · Final report · Oct 24, 1982 · N7856Q · Substantial damage
  > The pilot stated that after he landed and turned off the runway to taxi, he heard a loud report (explosion) from the right wing. He evacuated the aircraft and found the skin separated from the top and bottom leading edge of the right wing. Soot was found…
- [NTSB LAX83LA017](https://openairdocs.org/ntsb/LAX83LA017.md): Cessna 182 · Deer Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1982 · N1496M · Destroyed
  > Pilot could not get aircraft started so he got out and pulled prop. Engine started and with no one aboard the aircraft taxiied into two parked aircraft.
- [NTSB ATL83LA015](https://openairdocs.org/ntsb/ATL83LA015.md): Piper PA-23-250 · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Oct 20, 1982 · N62721 · Substantial damage
  > The pilot set the parking brake after starting the aircraft and diverted his attention to the checklist. When he looked up the aircraft was moving. The pilot attempted to stop the aircraft by both pushing the toe brakes and pulling the parking brake. The…
- [NTSB MKC83LA011](https://openairdocs.org/ntsb/MKC83LA011.md): Cessna 172PII · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Oct 19, 1982 · N63648 · Substantial damage
  > Pilot made three go-arounds because of gusty winds. While taxiing to tiedown downwind the wind blew the aircraft over. Winds gusting to 25 KTS.
- [NTSB CHI83LA021](https://openairdocs.org/ntsb/CHI83LA021.md): Swearingen SA227-AC · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 17, 1982 · N173MA · Substantial damage
  > The left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.
- [NTSB MKC83LA007](https://openairdocs.org/ntsb/MKC83LA007.md): Smith Miniplane Mini · Lexington, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1982 · N28M · Destroyed
  > During taxi for takeoff the pilot smelled fuel fumes in the cockpit and noticed fuel leakage under the fuel tank, located above the pilots leg. The pilot then parked the aircraft and shutdown the engine. A fire started after he deplaned and consumed the…
- [NTSB SEA83LA005](https://openairdocs.org/ntsb/SEA83LA005.md): Beech C35 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1982 · N5894C · Substantial damage
  > While hand propping to start, the engine went to full power. The pilot gained access to the controls as the aircraft began to move against the locked brakes. However, he was unable to stop the plane before it hit a Beech 58P, N3664G. The pilot reported that…
- [NTSB FTW83LA014](https://openairdocs.org/ntsb/FTW83LA014.md): Cessna 414A · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Oct 11, 1982 · N6599C · Substantial damage
  > After takeoff, the pilot was unable to get an up-and-locked indication after attempting to retract the landing gear. He extended the gear and got a safe indication (down-and-locked). He returned to the airport and landed. While taxiing off the runway, the…
- [NTSB ATL83LA007](https://openairdocs.org/ntsb/ATL83LA007.md): Beech S35 · Macon, GA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1982 · N6138V · Substantial damage
  > After landing and coming to a stop on the runway, the pilot made a 180 degree turn to proceed to a taxiway and began cleaning up the cockpit. During the turn, the gear collapsed. The pilot stated that he inadvertently raised the gear handle instead of the…
- [NTSB LAX83LA021](https://openairdocs.org/ntsb/LAX83LA021.md): Cessna 150 · Peoria, AZ · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N6319S · Substantial damage
  > While taxiing to the ramp the aircraft's left wing struck a chain link fence causing substantial damage to the aircraft.
- [NTSB ANC83IA001](https://openairdocs.org/ntsb/ANC83IA001.md): Piper PA-32-300 · Near Port Heide, AK · Incident · No injuries · Incident investigation · Final report · Oct 3, 1982 · N4025W · Minor damage
  > According to the pilot, he was back taxiing along a beach after landing and while attempting to make a turn the nose gear collapsed. On examination, the pilot found that a bolt in the nose gear steering mechanism had failed due to excessive wear. This allowed…
- [NTSB LAX83LA004](https://openairdocs.org/ntsb/LAX83LA004.md): Piper PA-28-140 · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1982 · N7537R · Substantial damage
  > While taxiing for takeoff the aircraft's left wing struck the nose of a Cessna 337, N547SE, which spun to the left and damaged a Piper PA-28, N8163E. The pilot stated that the Cessna 337 was 3 1/2 feet beyond alignment with other aircraft and extended into…
- [NTSB CHI82DA353](https://openairdocs.org/ntsb/CHI82DA353.md): Piper PA-23-250 · Fort Wayne, IN · Accident · No injuries · Final report · Sep 16, 1982 · N642MS · Substantial damage
  > Plt taxied off rwy onto grass to give way to landing traffic. Paved taxiways are not available & 50 ft either side of runway is used for taxiing with the grass being kept mowed. Before he was able to taxi back onto the paved rwy the ground gave way & the nose…
- [NTSB MKC83LA012](https://openairdocs.org/ntsb/MKC83LA012.md): Cessna 150 · Nichols, IA · Accident · No injuries · Limited investigation · Final report · Sep 13, 1982 · N51183 · Substantial damage
  > The pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over.
- [NTSB NYC82DA231](https://openairdocs.org/ntsb/NYC82DA231.md): Piper PA-38-112 · Pomona, NJ · Accident · No injuries · Final report · Sep 9, 1982 · N2441A · Substantial damage
  > While taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.
- [NTSB CHI82DA346](https://openairdocs.org/ntsb/CHI82DA346.md): Piper PA-23-250 · Holland, MI · Accident · No injuries · Final report · Sep 8, 1982 · N54847 · Substantial damage
  > Pilot taxiing to takeoff collided with fuel pumps.
- [NTSB MKC82DA172](https://openairdocs.org/ntsb/MKC82DA172.md): Ercoupe 415C · Andover, KS · Accident · No injuries · Final report · Sep 7, 1982 · N99088 · Substantial damage
  > Pilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred.
- [NTSB SEA82DYK12](https://openairdocs.org/ntsb/SEA82DYK12.md): Cessna 210 · Rosenburg, OR · Accident · No injuries · Final report · Sep 2, 1982 · N727FK · Substantial damage
  > The pilot attempted to hand start the aircraft due to a weak battery. The pilot told passenger to hold the brakes and assumed the passenger knew how, because of his many hours of flight time (as a passenger). When the engine started the aircraft began to move…
- [NTSB ATL82DA253](https://openairdocs.org/ntsb/ATL82DA253.md): Piper PA-34 · Campbellsville, KY · Accident · No injuries · Final report · Aug 26, 1982 · N6850J · Substantial damage
  > While taxiing to a hangar the left wheel went off the taxiway causing the left gear to collapse.
- [NTSB MIA82DA178](https://openairdocs.org/ntsb/MIA82DA178.md): Douglas C-47 · Charlotte Amali · Accident · No injuries · Final report · Aug 23, 1982 · N87629 · Substantial damage
  > The pilot reported normal braking pressure failed while taxiing on the ramp. He attempted to steer clear of other aircraft, but collided with two parked DC-3 aircraft. No determination of the nature of the braking problem was made.
- [NTSB MKC82DA151](https://openairdocs.org/ntsb/MKC82DA151.md): Bell 47G-2A · Washington, IA · Accident · No injuries · Final report · Aug 22, 1982 · N73205 · Substantial damage
  > The helicopter was being air taxied to the refueling location when it crashed. The pilot said he had lifted off and was about 6 ft AGL with about 20 KTS forward speed when he suddenly felt a snap and the cyclic went full left. The helicopter became…
- [NTSB FTW82DA339](https://openairdocs.org/ntsb/FTW82DA339.md): North American AT-6A · Abilene, TX · Accident · Minor injuries · Final report · Aug 21, 1982 · N42BA · 2 aircraft · Minor damage
  > The pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.
- [NTSB FTW82DA337](https://openairdocs.org/ntsb/FTW82DA337.md): Cessna 177RG · Afton, TX · Accident · No injuries · Final report · Aug 18, 1982 · N50038 · Substantial damage
  > While en route, the piiot encountered severe weather and landed on a paved road. He stated that after about 2 hrs, the weather improved and he decided to taxi to an area where he could takeoff. While taxiing, the left wing struck a tree which pulled the…
- [NTSB ATL82DA240](https://openairdocs.org/ntsb/ATL82DA240.md): Cessna 180 · Grand Bay, AL · Accident · Minor injuries · Final report · Aug 15, 1982 · N42GC · Substantial damage
  > Reportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he…
- [NTSB NYC82DA196](https://openairdocs.org/ntsb/NYC82DA196.md): Piper PA-28-161 · Wilkes Barre, PA · Accident · No injuries · Final report · Aug 13, 1982 · N2962Q · Substantial damage
  > The student pilot stated that as he began to taxi, he proceeded about 35 ft and then the aircraft suddenly veered to the left as if the wheel had locked. He applied right rudder, then right brake. However, the aircraft struck a building and an automobile.
- [NTSB NYC82DA192](https://openairdocs.org/ntsb/NYC82DA192.md): de Havilland DH-114 · Sidney, NY · Accident · No injuries · Final report · Aug 11, 1982 · N507FW · Substantial damage
  > While taxiing on the ramp the plt experienced a brake failure & the acft collided with several parked acft. The brake system is air operated & a small threaded rod with a small locking screw disconnected from the brake valve.
- [NTSB LAX82DA295](https://openairdocs.org/ntsb/LAX82DA295.md): Aerospatiale SA-341G · Long Beach, CA · Accident · No injuries · Final report · Aug 10, 1982 · N118EF · Substantial damage
  > The helicopter was being used for dual flight instruction of several students. The instructor pilot (ip) stated that he held the controls while his second student exited and the third student got in and adjusted his seat and pedals. After performing the…
- [NTSB DEN82DA157](https://openairdocs.org/ntsb/DEN82DA157.md): Cessna 172 · Grafton, ND · Accident · No injuries · Final report · Aug 7, 1982 · N8909V · 2 aircraft · Substantial damage
  > The pilot stated that when he began to taxi he noticed a Cessna 172 with its engine running in front of a hangar, about 500 feet ahead and to his left. Continuing his taxi, the pilot's attention was diverted by an aircraft on the right. When he looked forward…
- [NTSB ATL82IA218](https://openairdocs.org/ntsb/ATL82IA218.md): Cessna 152 · Hampton, GA · Incident · No injuries · Incident investigation · Final report · Jul 29, 1982 · N714TA · Minor damage
  > During taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…
- [NTSB NYC82DA169](https://openairdocs.org/ntsb/NYC82DA169.md): North American T-6G · State College, PA · Accident · No injuries · Final report · Jul 25, 1982 · N6253C · Substantial damage
  > While taxiing in from landing the right landing gear collapsed resulting in substantial damage to the aircraft. Investigation revealed the right landing gear actuator rod failed.
- [NTSB NYC82DA164](https://openairdocs.org/ntsb/NYC82DA164.md): Cessna 172N · Jamaica, NY · Accident · Minor injuries · Final report · Jul 24, 1982 · N9426E · Substantial damage
  > An airport operations agent, in a port authority automobile monitored ground control conversation with the pilot and offered to assist N9426E in locating the active runway. When approaching the lost aircraft's position the vehicle driver experienced sun glare…
- [NTSB NYC82IA162](https://openairdocs.org/ntsb/NYC82IA162.md): Piper PA-38-112 · Westhampton Bea, NY · Incident · No injuries · Incident investigation · Final report · Jul 23, 1982 · N26005 · Minor damage
  > While taxiing in from landing during a left turn, the right main landing gear collapsed.
- [NTSB ATL82DA205](https://openairdocs.org/ntsb/ATL82DA205.md): Beech J35 · Birmingham, AL · Accident · No injuries · Final report · Jul 20, 1982 · N2TP · Substantial damage
  > The pilot reported that he had received an instrument clearance before starting the engine and noted that the battery was weak. He reported that he decided to pull the propeller through and turned the ignition switch toward the off position. As the propeller…
- [NTSB CHI82DA257](https://openairdocs.org/ntsb/CHI82DA257.md): Beech 36 · Ypsilanti, MI · Accident · No injuries · Final report · Jul 18, 1982 · N52GS · Substantial damage
  > After the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,…

Next page: https://openairdocs.org/ntsb-phases/250/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 = 250)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/250/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.