# NTSB investigations: Maneuvering 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 229 of 378 · 18,851 cases ## Cases, newest first - [NTSB FTW82FQA26](https://openairdocs.org/ntsb/FTW82FQA26.md): Cessna 150 · La Plata, NM · Accident · Serious injuries · Final report · Aug 27, 1982 · N3251V · Destroyed > Acft struck a power line which crossed a road at about 40 ft AGL. The acft was observed flying at low altitude in the area prior to the accident. - [NTSB FTW82DA351](https://openairdocs.org/ntsb/FTW82DA351.md): Air Tractor AT-400 · Alvin, TX · Accident · No injuries · Final report · Aug 27, 1982 · N3657J · Substantial damage > The pilot had finished spraying a field and was surveying another field for his next day operation when the aircraft engine flamed out. He landed the aircraft in a soybean field and ground-looped the aircraft to prevent hitting trees at the edge of the field.… - [NTSB DEN82FTG06](https://openairdocs.org/ntsb/DEN82FTG06.md): Piper PA-12 · Oakes, ND · Accident · 2 fatal · Final report · Aug 27, 1982 · N7715H · Destroyed > Several witnesses reported that the purpose of the flight was blackbird control of a sunflower field. There was speculation by local residents that the aircraft was being used to spread poisoned corn. This was substantiated when corn and a portion of an… - [NTSB ATL82DA252](https://openairdocs.org/ntsb/ATL82DA252.md): Grumman G-164C · Gunnison, MS · Accident · No injuries · Final report · Aug 27, 1982 · N6787K · Substantial damage > The pilot reported that he smelled something hot while spraying. He checked the instruments and noted that the oil temperature gauge was indicating off the high side of the scale. He started to make a precautionary landing but the engine seized during final… - [NTSB MKC82DA158](https://openairdocs.org/ntsb/MKC82DA158.md): Fairchild Hiller FH 1100 · Mason City, IA · Accident · No injuries · Final report · Aug 26, 1982 · N1345Q · Substantial damage > During a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above… - [NTSB FTW82DA350](https://openairdocs.org/ntsb/FTW82DA350.md): Air Tractor AT-301 · Winnesboro, LA · Accident · No injuries · Final report · Aug 26, 1982 · N4342S · Destroyed > The pilot was circling the field during alignment for his initial swath run when the aircraft engine failed. During the forced landing the aircraft nosed over and the pilot exited the aircraft without turning off any switches. He stated that fuel was leaking… - [NTSB FTW82FRG37](https://openairdocs.org/ntsb/FTW82FRG37.md): Champion 7GCAA · Killeen, TX · Accident · 2 fatal · Final report · Aug 25, 1982 · N2541F · Destroyed > The majority of the wreckage was contained within a small area except for the left wing tip which was found about 125 yds from the wreckage & some pieces of fabric from the left wing that were found about 525 yds from the wreckage. Both wings had separated… - [NTSB NYC82FA208](https://openairdocs.org/ntsb/NYC82FA208.md): Erco 415C · Carthage, ME · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1982 · N3728H · Destroyed > The aircraft was observed flying at low altitude during which the engine sounds ceased. The aircraft stalled and descended vertically to the ground. - [NTSB FTW82FRJ16](https://openairdocs.org/ntsb/FTW82FRJ16.md): Rockwell S-2R · Jones, LA · Accident · 2 fatal · Final report · Aug 23, 1982 · N8474V · 2 aircraft · Destroyed > Air tractor AT-400, N2342Z, and another aircraft, a Rockwell international S-2R, N8474V, collided while both aircraft were involved in spraying operatons. The AT-400 pilot was spraying a field that was surrounded by trees. He had just completed a swath run to… - [NTSB ATL82FA243](https://openairdocs.org/ntsb/ATL82FA243.md): Aeronca 7AC · Greenwood, MS · Accident · 1 fatal · Field investigation · Final report · Aug 23, 1982 · N67JH · Destroyed > Pilot was flying to spot deer. When deer were spotted pilot banked steeply to get better look, stalled and only had time to level wings before ground impact. - [NTSB MKC82DA152](https://openairdocs.org/ntsb/MKC82DA152.md): Cessna 172 · Thedford, NE · Accident · Minor injuries · Final report · Aug 22, 1982 · N3419E · Substantial damage > The pilot reported that after he took off on a dark night, he remembered there were obstacles in that area and he reversed his direction of turn. He stated that after reversing the turn, he became disoriented and the aircraft dove into the ground. - [NTSB MIA82FKT11](https://openairdocs.org/ntsb/MIA82FKT11.md): Cessna 152 · Lantana, FL · Accident · Serious injuries · Final report · Aug 21, 1982 · N68738 · Destroyed > Witnesses observed the acft flying 35-40 ft over the ocean making banks, climbs & dives. Just prior to crashing the acft was seen to be in a very steep climb. - [NTSB LAX82DA316](https://openairdocs.org/ntsb/LAX82DA316.md): Midget Mustang · Ventura, CA · Accident · No injuries · Final report · Aug 21, 1982 · N50RT · Destroyed > While flying in the vicinity of a beach area, the engine lost power. The pilot landed on a dirt parking area near the beach, but did not have room to stop. In order to avoid surfers and their parked vehicles, he intentionally ran the aircraft across an area… - [NTSB CHI82DA318](https://openairdocs.org/ntsb/CHI82DA318.md): Mustang II · Plainfield Twp, IL · Accident · 2 fatal · Final report · Aug 21, 1982 · N68099 · Destroyed > Aircraft came down vertically rolling. Just before ground contact or at about 200 feet rolling slowed and aircraft continued descent to terrain contact. No malfunction noted. - [NTSB LAX82DA306](https://openairdocs.org/ntsb/LAX82DA306.md): Hiller UH-12E · Chandler, AZ · Accident · No injuries · Final report · Aug 20, 1982 · N4026S · Substantial damage > The pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft. - [NTSB ATL82FLG13](https://openairdocs.org/ntsb/ATL82FLG13.md): Smith Miniplane · Swansea, SC · Accident · 1 fatal · Final report · Aug 19, 1982 · N1CJ · Destroyed > The pilot was on a pleasure flight to practice aerobatic maneuvers. He held a current certificate of waiver which authorized him to practice low level aerobatics below 1500 ft above the surface. Four known witnesses observed the aircraft pull up from a low… - [NTSB ANC82DAG42](https://openairdocs.org/ntsb/ANC82DAG42.md): Cessna 185 · Near Tyonek, AK · Accident · Serious injuries · Final report · Aug 19, 1982 · N3489Y · Substantial damage > The float equipped plane was being used to transport cargo. A passenger was put on the flight at the last minute, but the pilot believed the aircraft was within its maximum weight limit. After takeoff, the pilot remained at a low altitude for a time while the… - [NTSB CHI82FA312](https://openairdocs.org/ntsb/CHI82FA312.md): Taylorcraft BL-65 · Rock Falls, IL · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1982 · N29660 · Destroyed > Aircraft caught fire while performing aerobatics and crashed out of control. Gas tank cap had come off and during inverted flight fuel spilled out and ignited. - [NTSB NYC82FA203](https://openairdocs.org/ntsb/NYC82FA203.md): Champion 7ECA · Lewes, DE · Accident · 2 fatal · Field investigation · Final report · Aug 17, 1982 · N1886G · Destroyed > About 15 min after takeoff, the aircraft was observed to enter a maneuver from low altitude over a beach area. During the maneuver, the plane pulled up, entered a steep climb and then banked or rolled left and entered a nose down attitude. Before recovering,… - [NTSB MKC82DA148](https://openairdocs.org/ntsb/MKC82DA148.md): Cessna T188C · Near Traer, IA · Accident · No injuries · Final report · Aug 17, 1982 · N9975J · Substantial damage > The pilot failed to refuel during the last loading, and shortly after returning to the spray area, the engine quit. A forced landing was made in an alfala field during which the aircraft collided with a fence. During the investigation, no fuel was found in… - [NTSB FTW82DA336](https://openairdocs.org/ntsb/FTW82DA336.md): Snow AT-301A · Leachville, AR · Accident · No injuries · Final report · Aug 17, 1982 · N2321V · Destroyed > The pilot stated that while he was in the procedure turnaround for the third swath run. He lost elevator control. The aircraft impacted the ground and cartwheeled. Investigation revealed that the bolt connecting the elevator horn assembly and the elevator… - [NTSB DEN82FTK06](https://openairdocs.org/ntsb/DEN82FTK06.md): Piper PA-18 · Watertown, SD · Accident · 1 fatal · Final report · Aug 17, 1982 · N154T · Destroyed > The pilot was spraying a sunflower field next to an alfalfa field that was being irrigated. As he pulled up from his third swath run, he began a procedure turn-around over the alfalfa field. During the turn, the plane rolled to an inverted attitude, then… - [NTSB ATL82FLJ08](https://openairdocs.org/ntsb/ATL82FLJ08.md): Piper PA-25-260 · Scotland Neck, NC · Accident · Serious injuries · Final report · Aug 17, 1982 · N9780P · Substantial damage > During the fourth swath run the acft struck a 60-foot tree approximately 5 ft from the top. - [NTSB ANC82DAG45](https://openairdocs.org/ntsb/ANC82DAG45.md): Piper PA-38-112 · Eagle River, AK · Accident · No injuries · Final report · Aug 17, 1982 · N2409P · Substantial damage > During a local flight, the pilot elected to fly into the mouth of peter's creek valley to look at a friend's cabin. He stated that after he flew over the cabin at about 1500 ft MSL, he "initiated power and a 180 deg turn." He stated that on application of… - [NTSB NYC82DA200](https://openairdocs.org/ntsb/NYC82DA200.md): Bellanca 7GCAA · Coltsneck, NJ · Accident · Minor injuries · Final report · Aug 15, 1982 · N87108 · Destroyed > The pilot missed a banner pick-up, pulled up abruptly and leveled off at about 350 feet. The aircraft engine lost power and the pilot lowered the nose while in a right turn in an attempt to return to the airport. He stated that engine power was restored while… - [NTSB ATL82FKQ17](https://openairdocs.org/ntsb/ATL82FKQ17.md): Eaa Biplane · Meridan, MS · Accident · 1 fatal · Final report · Aug 14, 1982 · N1101M · Destroyed > According to three witnesses the plt was performing aerobatic maneuvers at tree-top level & the acft stalled during a pull-up & turn-around. The plt's blood alcohol level was 128 mg% & the gastric level was 287 mg%. - [NTSB ATL82DA238](https://openairdocs.org/ntsb/ATL82DA238.md): Cessna 152 · Stone Mountain, GA · Accident · No injuries · Final report · Aug 14, 1982 · N4737B · Substantial damage > The pilot reported that a split-s maneuver was performed at a low altitude and the aircraft struck the branches of a pine tree. The aircraft continued to fly and the pilot returned to the airport. There was damage to the right wing and the fuselage. - [NTSB ANC82DA072](https://openairdocs.org/ntsb/ANC82DA072.md): Piper PA-22 · Icy Bay, AK · Accident · Serious injuries · Final report · Aug 14, 1982 · N6954B · Destroyed > While on a cross country flight, the pilot landed on a small lake to add fuel to the aircraft from cans carried in the aircraft. After departing the lake he encountered weather and attempted to transition to instrument flight when a hole he was using to climb… - [NTSB FTW82DA330](https://openairdocs.org/ntsb/FTW82DA330.md): Grumman G-164A · Dimmitt, TX · Accident · No injuries · Final report · Aug 13, 1982 · N8826H · Substantial damage > The pilot reported that during a procedure turn around, the engine lost power. He elected to land in a cotton field. After touchdown, the wheels dug in the ground and the aircraft nosed over. - [NTSB DEN82DA161](https://openairdocs.org/ntsb/DEN82DA161.md): Air Tractor AT-301 · Center, CO · Accident · Minor injuries · Final report · Aug 12, 1982 · N1KL · Substantial damage > The pilot was on the first swath run of his second load. He stated that as he started to cross below transmission lines, when he saw a small boy and a dog appear from a ditch below the wires. He stated that when he pulled up to avoid the child, the aircraft… - [NTSB MIA82DA167](https://openairdocs.org/ntsb/MIA82DA167.md): Bell 206B · Miami, FL · Accident · Minor injuries · Final report · Aug 11, 1982 · N7891S · Destroyed > This was an instructional flight for recurrent training and involved an external load operation with a 10 ft line. While preparing to pick up an 800 lb load, the helicopter was maneuvered over the object with slack in the line. The instructor observed that… - [NTSB FTW82DA324](https://openairdocs.org/ntsb/FTW82DA324.md): Piper PA-25-260C · Des Arc, AR · Accident · No injuries · Final report · Aug 11, 1982 · N4952Y · Substantial damage > After pulling up from a swath run, the aircraft began to settle, then collided with the ground. This occurred after the pilot had dispensed all or nearly all of his load. - [NTSB CHI82DA303](https://openairdocs.org/ntsb/CHI82DA303.md): Enstrom F-28 · Waynesville, OH · Accident · No injuries · Final report · Aug 11, 1982 · N81HF · Substantial damage > The pilot stated that during a spraying operation he felt a vibration in the aircraft. He attempted a precautionary landing with reduced power, avoiding further stress on the rotor system. During the landing the skids dug into the soybeans and the main rotor… - [NTSB CHI82DA301](https://openairdocs.org/ntsb/CHI82DA301.md): Hiller 12E · Palisade, MN · Accident · No injuries · Final report · Aug 10, 1982 · N5594N · Substantial damage > Aircraft lost power, pilot autorotated at 20 feet AGL. Made hard forced landing and aircraft rolled over. Piston rod failed because cap bolt was undertorqued. - [NTSB FTW82DA322](https://openairdocs.org/ntsb/FTW82DA322.md): Cessna T188C · Altheimer, AR · Accident · No injuries · Final report · Aug 9, 1982 · N2881J · Destroyed > The pilot stated he encountered turbulence while flying under a power line during a crop spraying operation. The left wing pitched-up and struck the power line and the aircraft went into an uncontrolable left bank. He reduced power and landed in a bean field,… - [NTSB MKC82IA138](https://openairdocs.org/ntsb/MKC82IA138.md): Piper PA-25-235 · Wilsonville, NE · Incident · Minor injuries · Incident investigation · Final report · Aug 8, 1982 · N7043Z · Minor damage > The pilot stated that he was overcome by exposure to the organic phosphate he was deploying. According to local law enforcement authorities, the aircraft crashed in a field and came to rest inverted. Medical tests for toxic chemical exposure were inconclusive. - [NTSB MKC82DA140](https://openairdocs.org/ntsb/MKC82DA140.md): Cessna 188 · Stockton, KS · Accident · No injuries · Final report · Aug 8, 1982 · N53227 · Substantial damage > The engine lost power as the pilot pulled up from a swath run. A forced landing was made in open terraced field. Dirt was found in the engine fuel pump. Reportedly, the dirt would have restricted the fuel flow. - [NTSB FTW82DA319](https://openairdocs.org/ntsb/FTW82DA319.md): Eagle DW-1 · Cheneyville, LA · Accident · No injuries · Final report · Aug 8, 1982 · N8807Z · Substantial damage > The acft was on the approach to spray a cottonfield when a collision with an unseen power line occurred. The collision forced the acft down and the pilot made a hard landing which damaged the landing gear and the right wing. The visibilitywas about 5 miles in… - [NTSB DEN82FTE22](https://openairdocs.org/ntsb/DEN82FTE22.md): Eiriavion PIK-20D · Crested Butte, CO · Accident · 1 fatal · Final report · Aug 8, 1982 · N199A · Destroyed > The pilot was attending an "aviation weekend" sponsored by the town of Crested Butte, CO. He had flown in this area often and was acquainted with the terrain and weather. After being towed to an area near the northwest corner of mt Crested Butte, a normal… - [NTSB FTW82FQA24](https://openairdocs.org/ntsb/FTW82FQA24.md): Piper PA-22 · Lake Arthur, NM · Accident · Serious injuries · Final report · Aug 6, 1982 · N1489A · Substantial damage > The pilot and one passenger were on a flight to pick up spare parts. The passenger recalled that while en route, the pilot remarked, "oh, I can't resist" and started to descend, then made a pass at about 50 ft over a field hand. The field hand, a mexican… - [NTSB FTW82DA316](https://openairdocs.org/ntsb/FTW82DA316.md): Cessna 152 · Rockwall, TX · Accident · Minor injuries · Final report · Aug 5, 1982 · N67570 · Destroyed > The pilot stated that he encountered wind shear, dust devil or other instantaneous failure, while flying at about 100 ft AGL. He stated the aircraft dropped, fell out of control, impacted and tumbled to a stop. Reportedly, a witness observed the aircraft… - [NTSB DEN82DA155](https://openairdocs.org/ntsb/DEN82DA155.md): Bell Helicopter Textron 47G3B1 · Buena Vista, CO · Accident · No injuries · Final report · Aug 4, 1982 · N23DW · Destroyed > According to the pilot, the purpose of the flight was to track wild sheep with transmitters attached to their necks. While maneuvering at approximately 14,000 feet elevation and executing a right turn the aircraft felt "rubbery." He applied left cyclic but… - [NTSB ANC82DA070](https://openairdocs.org/ntsb/ANC82DA070.md): Cessna 150H · Near Anchorage, AK · Accident · Serious injuries · Final report · Aug 4, 1982 · N22695 · Substantial damage > While taking off from a lake, the instructor reduced the power to simulate a forced landing at about 200 ft AGL. He reported that the student elected to make a 180 deg turn to land. He stated that during the turn, the student brought the nose up and the… - [NTSB MIA82FKJ05](https://openairdocs.org/ntsb/MIA82FKJ05.md): Piper PA-25 · Jay, FL · Accident · 1 fatal · Final report · Aug 2, 1982 · N8921L · Destroyed > The acft stalled during a spraying operation. The plt received his private pilot's certificate approximately four months prior to the accident. He had no flt time logged in a PA-25 & no information could be found to indicate the plt had received any… - [NTSB ATL82DA226](https://openairdocs.org/ntsb/ATL82DA226.md): Hughes 269A · Wetumpka, AL · Accident · No injuries · Final report · Aug 2, 1982 · N8801F · Substantial damage > The pilot reported that at the end of a spray run, the engine lost power. He stated that the engine RPM dropped to zero, the airspeed was zero, and he established an autorotation. According to the pilot, the helicopter touched down on rough hilly terrain,… - [NTSB LAX82FVM17](https://openairdocs.org/ntsb/LAX82FVM17.md): Great Lakes 2T-1A-2 · Scotts Valley, CA · Accident · 1 fatal · Final report · Aug 1, 1982 · N61861 · Destroyed > While performing in an aerobatic show, the pilot entered a spin. According to a witness, he entered the spin at about 2000 ft AGL and made approximately 5 turns before starting a recovery at about 500 ft AGL. He stopped the spin, but there was insufficient… - [NTSB LAX82DA283](https://openairdocs.org/ntsb/LAX82DA283.md): Enstrom F28C · Phoenix, AZ · Accident · No injuries · Final report · Jul 31, 1982 · N5688N · Substantial damage > The helicopter made a forced landing in a cotton field after tail rotor driveshaft failure. Examination showed a ductileshear overload failure. No evidence of fatigue was reported. - [NTSB DEN82IA150](https://openairdocs.org/ntsb/DEN82IA150.md): Aerospatiale 350D · Near Winter Par, CO · Incident · No injuries · Incident investigation · Final report · Jul 31, 1982 · N49556 · Minor damage > Witnesses who were aboard the aircraft stated that the aircrafts rotor struck a tree during a "straffing run" on a railroad trestle just below the Continental divide. The pilot stated that the engine flamed out as he passed over the trestle. The aircraft was… - [NTSB NYC82FA175](https://openairdocs.org/ntsb/NYC82FA175.md): Beech B19 · South Yarmouth, MA · Accident · 1 fatal · Field investigation · Final report · Jul 30, 1982 · N783Y · Destroyed > The acft stalled & impacted trees as the plt was buzzing a residence at 150-200 ft above the tree tops. - [NTSB ATL82DA219](https://openairdocs.org/ntsb/ATL82DA219.md): Cessna 188 · Bishopville, SC · Accident · No injuries · Final report · Jul 30, 1982 · N9888V · Substantial damage > The pilot reported that as he was entering a field on his third swath, the aircraft collided with a single transmission line. The line was leading to the center of a cotton field. The pilot did not see the line. After contacting the line, the aircraft was… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=230 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=229 --- 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.