# 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 234 of 377 · 18,850 cases ## Cases, newest first - [NTSB MIA82DA087](https://openairdocs.org/ntsb/MIA82DA087.md): Champion 7GCBC · New Smyrna Beac, FL · Accident · No injuries · Final report · Mar 26, 1982 · N7552F · Substantial damage > The pilot reported that during a banner pick up, he missed the banner, and on climb out, he encounter windshear and stalled. The plane crashed before recovering from the stall. He reported that the wind was gusting to 20 knots. - [NTSB FTW82FRG27](https://openairdocs.org/ntsb/FTW82FRG27.md): Bell 206 · Austin, TX · Accident · 1 fatal · Final report · Mar 26, 1982 · N5739Y · Destroyed > During a low pass over lake Austin the aircraft collided with power cables about 300 feet above the lake. Witnesses reported two loud cracking sounds and that the helicopter pitched up and gyrated wildly then continued in the original direction of flight and… - [NTSB MKC82DA049](https://openairdocs.org/ntsb/MKC82DA049.md): Cessna 172 · Jetmore, KS · Accident · No injuries · Final report · Mar 22, 1982 · N4915F · Substantial damage > The aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground. - [NTSB SEA82DA077](https://openairdocs.org/ntsb/SEA82DA077.md): Robinson R-22 · Hillsboro, OR · Accident · No injuries · Final report · Mar 21, 1982 · N1KH · Substantial damage > The instructor pilot was demonstrating a hovering autorotation to the student from approximately an 18 inch altitude. Shortly after touchdown, which was level and without movement in any direction, the aircraft started to roll to the left. The pilot reported… - [NTSB ATL82FLT03](https://openairdocs.org/ntsb/ATL82FLT03.md): Cessna 172N · Greenfield, TN · Accident · 1 fatal · Final report · Mar 20, 1982 · N737QS · Destroyed > Witnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a… - [NTSB MIA82FA078](https://openairdocs.org/ntsb/MIA82FA078.md): Beech F35 · Leesburg, FL · Accident · 3 fatal · Field investigation · Final report · Mar 19, 1982 · N567LT · Destroyed > The pilot, who was a rock group driver, took an aircraft from the hangar without permission to joy ride members of the group. During the 2nd flight, the aircraft wing hit the bus during one of several low passes over the area. The aircraft then hit a tree and… - [NTSB NYC82DA056](https://openairdocs.org/ntsb/NYC82DA056.md): Bell 47J-2A · Emmaus, PA · Accident · Serious injuries · Final report · Mar 18, 1982 · N8565F · Substantial damage > While maneuvering at approximately 200 feet AGL for an aerial photography mission a sudden and complete power failure occurred. The pilot initiated autorotation procedures and set a course for the only open area, a small field with a 15 degree upslope. A… - [NTSB FTW82FQG16](https://openairdocs.org/ntsb/FTW82FQG16.md): Piper PA-18-150 · Near Sterling C, TX · Accident · 1 fatal · Final report · Mar 17, 1982 · N82622 · Destroyed > The student pilot departed his ranch strip reportedly to check on cattle. The plane crashed on rolling terrain in a nose down, left bank attitude and burned. There was no indication that the aircraft moved after impact. Both propeller blades were twisted and… - [NTSB ATL82DA073](https://openairdocs.org/ntsb/ATL82DA073.md): Hiller UH12E · Lydia, SC · Accident · No injuries · Final report · Mar 17, 1982 · N4029R · Substantial damage > The pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered… - [NTSB NYC82DA054](https://openairdocs.org/ntsb/NYC82DA054.md): Cessna 172 · Canastota, NY · Accident · No injuries · Final report · Mar 15, 1982 · N9243H · Substantial damage > While on a local flight, the pilot made a low pass at a grass landing strip. During pull-up, the left wing hit the tops of trees and was damaged. The pilot maintained control and continued on the return flight. However, approaching the runway, he was unable… - [NTSB FTW82DA094](https://openairdocs.org/ntsb/FTW82DA094.md): Gulfstream American G-164B · Holly Grove, AR · Accident · No injuries · Final report · Mar 15, 1982 · N8059K · Substantial damage > The agricultural pilot was aligning the aircraft to begin a swath run when the engine began to lose power. He noted a loss of manifold and oil pressure as well as black smoke from the exhaust. He turned away from the field and collided with trees rather than… - [NTSB ATL82FKQ11](https://openairdocs.org/ntsb/ATL82FKQ11.md): Cessna T188C · Mahew, MS · Accident · 1 fatal · Final report · Mar 14, 1982 · N2965J · Destroyed > During return flight to airport the pilot flew into a previously treated field for a cleanup swath run. Approximately 1700 feet from the south end of the field the aircraft collided with a 3-strand steel twisted cable powerline running east-west across the… - [NTSB NYC82FA053](https://openairdocs.org/ntsb/NYC82FA053.md): Robinson R22 · Spangler, PA · Accident · 1 fatal · Field investigation · Final report · Mar 12, 1982 · N9079M · Destroyed > The helicopter struck a set of north-south powerlines while the pilot was patrolling a set of east-west powerlines. The powerlines being patrolled passed under the lines that were struck. The accident occurred over hilly, wooded terrain. - [NTSB FTW82DA089](https://openairdocs.org/ntsb/FTW82DA089.md): Rockwell S-2R · Oberlin, LA · Accident · No injuries · Final report · Mar 10, 1982 · N8466V · Destroyed > As the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to… - [NTSB CHI82IA082](https://openairdocs.org/ntsb/CHI82IA082.md): Swearingen SA-266TC · South Bend, IN · Incident · No injuries · Incident investigation · Final report · Mar 10, 1982 · N323BA · Minor damage > The captain reported that at lift-off above VI speed, he heard a loud pop that sounded like a tire had failed. A "bright yellowish" illumination was then seen in front of the right engine. There was insufficient runway to abort, so the takeoff was continued.… - [NTSB LAX82DA101](https://openairdocs.org/ntsb/LAX82DA101.md): Beech V35B · Taft, CA · Accident · No injuries · Final report · Mar 9, 1982 · N7266R · Substantial damage > The aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing. - [NTSB LAX82DA100](https://openairdocs.org/ntsb/LAX82DA100.md): Hiller 12E · Delano, CA · Accident · No injuries · Final report · Mar 9, 1982 · N99242 · Substantial damage > During the spraying operation of a field border the helicopter main rotor blades came in contact with power lines. The loose wire wrapped around the ballast arms and the landing was accomplished with cyclic steering only. - [NTSB DEN82DA040](https://openairdocs.org/ntsb/DEN82DA040.md): Bell 206B III · Trenton, ND · Accident · Serious injuries · Final report · Mar 7, 1982 · N16867 · Substantial damage > The aircraft was hovering during a sling load operation when the engine lost power. The pilot released the load but due to low rotor RPM the aircraft landed hard, substantially damaging the aircraft. Investigaton revealed a failure of the forward male splines… - [NTSB LAX82DA091](https://openairdocs.org/ntsb/LAX82DA091.md): Beech B35 · La Jolla, CA · Accident · No injuries · Final report · Mar 4, 1982 · N180L · Destroyed > During flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore. - [NTSB FTW82FQG15](https://openairdocs.org/ntsb/FTW82FQG15.md): Piper PA-36 · Floydada, TX · Accident · 1 fatal · Final report · Mar 4, 1982 · N2394Y · Destroyed > The aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No… - [NTSB NYC82FGT08](https://openairdocs.org/ntsb/NYC82FGT08.md): Cessna A152 · Scotland, PA · Accident · 2 fatal · Final report · Mar 2, 1982 · N7378L · Destroyed > The aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent. - [NTSB FTW82DA082](https://openairdocs.org/ntsb/FTW82DA082.md): Starduster II · Taylor, TX · Accident · No injuries · Final report · Mar 1, 1982 · N2361 · Substantial damage > During a slow roll to the left, the aircraft developed a high rate of descent. The roll was completed just before ground impact which demolished the aircraft. - [NTSB ATL82DA062](https://openairdocs.org/ntsb/ATL82DA062.md): Piper PA-25-235 · Griffin, GA · Accident · 1 fatal · Final report · Mar 1, 1982 · N4732Y · Minor damage > The pilot was hired to perform for the filming of an agricultural spraying operation. During one of the low passes the aircraft struck two of the ground crew. The cameraman received fatal injuries. Pieces of the wooden propeller, used to drive the spray pump,… - [NTSB FTW82DPM10](https://openairdocs.org/ntsb/FTW82DPM10.md): Cessna 140A · Wagoner, OK · Accident · Serious injuries · Final report · Feb 28, 1982 · N9688A · Substantial damage > During a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level. - [NTSB FTW82DA077](https://openairdocs.org/ntsb/FTW82DA077.md): Cessna 152 · Arkadelphia, AR · Accident · No injuries · Final report · Feb 28, 1982 · N4912H · Substantial damage > The pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of… - [NTSB SEA82FYK08](https://openairdocs.org/ntsb/SEA82FYK08.md): Kaman HH-43F · Sutherlin, OR · Accident · Minor injuries · Final report · Feb 22, 1982 · N4524 · Destroyed > The helicopter was being used on a logging operation. After releasing a load from a hover out of ground effect, the pilot began to turn and accelerate. About two-thirds to three-fourths of the way through a 180 degree turn, the aircraft began a sudden, very… - [NTSB LAX82FVM12](https://openairdocs.org/ntsb/LAX82FVM12.md): Pitts 51 · Morgan Hill, CA · Accident · Minor injuries · Final report · Feb 21, 1982 · N8WA · Destroyed > While performing acrobatic maneuvers the pilot noticed smokeand oil streaming back from the engine and a loss of oil pressure. He throttled back immediately and started a descent towards a vacant field. In an attempt to clear some telephone lines in his path… - [NTSB FTW82FRJ08](https://openairdocs.org/ntsb/FTW82FRJ08.md): Bellanca 7GCBC · Near Texarkana, AR · Accident · 2 fatal · Final report · Feb 21, 1982 · N53731 · Substantial damage > During flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83… - [NTSB FTW82FQA14](https://openairdocs.org/ntsb/FTW82FQA14.md): Cessna 182Q · Fort Sumner, NM · Accident · 2 fatal · Final report · Feb 20, 1982 · N759QR · Destroyed > The plane crashed and burned on a dark moonless night after impacting in a nose low attitude. The crash site was located near the home of the pilot's friend where the pilot had visited earlier in the evening. After impacting in soft, level, sandy soil, the… - [NTSB FTW82FPD09](https://openairdocs.org/ntsb/FTW82FPD09.md): Piper PA-36-375 · Saint Jo, TX · Accident · 1 fatal · Final report · Feb 20, 1982 · N3802E · Destroyed > After taking off to the south, the plane was observed to climb to about 300 ft AGL, then turn to the southwest. P0WER was reduced, and within three to five miles, the aircraft was turned back toward the airstrip. While approaching the airstrip at about 500 ft… - [NTSB FTW82DA063](https://openairdocs.org/ntsb/FTW82DA063.md): Cessna 140 · Krotz Springs, LA · Accident · No injuries · Final report · Feb 20, 1982 · N77029 · Substantial damage > During the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed… - [NTSB NYC82FNC04](https://openairdocs.org/ntsb/NYC82FNC04.md): Aeronca 7EC · New Gloucester, ME · Accident · 1 fatal · Final report · Feb 14, 1982 · N4393C · Destroyed > The pilot flew the ski equipped aircraft to a frozen lake where he met two friends who were ice fishing. Later, after he visited with his friends and had given each of them a ride in the aircraft, the pilot took off again. After takeoff, the pilot turned back… - [NTSB FTW82FRG22](https://openairdocs.org/ntsb/FTW82FRG22.md): Beech V35A · Cibolo, TX · Accident · 1 fatal · Final report · Feb 10, 1982 · N7148N · Destroyed > Before starting the flight, the pilot was involved in an automobile accident. He called an employee and asked to be picked up. The employee reported that the pilot was drinking when he arrived. The pilot insisted on going to the airport to get keys from his… - [NTSB SEA82DA025](https://openairdocs.org/ntsb/SEA82DA025.md): Cessna 150J · Nr. Colbert, WA · Accident · No injuries · Final report · Feb 3, 1982 · N5527G · Substantial damage > During flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose… - [NTSB FTW82FQG14](https://openairdocs.org/ntsb/FTW82FQG14.md): Cessna 182 · Pampa, TX · Accident · 2 fatal · Final report · Feb 1, 1982 · N58947 · Destroyed > N58947 was purchased by the pilot the day of the accident. According to a flight instructor who sold the aircraft, the pilot received dual instruction for a checkout in the aircraft and currency for night flight. According to witnesses, the pilot did not… - [NTSB DEN82DA025](https://openairdocs.org/ntsb/DEN82DA025.md): Cessna 172 · Near Gillete, WY · Accident · No injuries · Final report · Jan 29, 1982 · N758RD · Substantial damage > The purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid… - [NTSB ATL82FLG10](https://openairdocs.org/ntsb/ATL82FLG10.md): Cessna 150 · Darlington, SC · Accident · 1 fatal · Final report · Jan 29, 1982 · N1434Q · Destroyed > Witnesses observed the aircraft performing aerobatic type of manuevers before entering a spin and crashing into a field. Although the pilot was known never to drink alcoholic beverages before flying, the pilot's blood alcohol level was 266MG/DL. - [NTSB LAX82FA061](https://openairdocs.org/ntsb/LAX82FA061.md): Bell UH1B · Lagunitas, CA · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1982 · N96142 · Destroyed > Helicopter crashed into a reservoir and sank in 60 feet of water after tail boom separated during a log slinging operation. The pilot had lifted and began to back up when a loud noise was heard and the tail separated. The log was released and an auto-rotation… - [NTSB FTW82FPM09](https://openairdocs.org/ntsb/FTW82FPM09.md): Cessna A188B · Muskogee, OK · Accident · Serious injuries · Final report · Jan 26, 1982 · N9413G · Destroyed > The pilot made two passes to survey the field to be sprayed. He stated that on his third pass, he pulled up, made a shallow left turn, leveled off, and started looking to the right for obstructions. Reportedly, the aircraft started into a 10 degree dive at… - [NTSB LAX82DA051](https://openairdocs.org/ntsb/LAX82DA051.md): Bell 47G-2 · Watsonville, CA · Accident · No injuries · Final report · Jan 23, 1982 · N10194 · Substantial damage > During a preceding spray operation, the pilot noted that some of the spray nozzles were not functioning properly. He flushed the tanks with fresh water and partially refilled them with water to perform an airborne nozzle check. While performing the check at… - [NTSB SEA82DA020](https://openairdocs.org/ntsb/SEA82DA020.md): Sikorsky S-58J · Near Kingston, ID · Accident · No injuries · Final report · Jan 22, 1982 · N97AR · Substantial damage > The aircraft was engaged in logging operations. While in a hover to pick up a second load of logs, the engine lost power. An autorotation was made into a creek bed. An inspection revealed that snow and water from the cabin interior had penetrated the cabin… - [NTSB LAX82FUJ25](https://openairdocs.org/ntsb/LAX82FUJ25.md): Piper PA-23-250 · Bagdad, AZ · Accident · Serious injuries · Final report · Jan 21, 1982 · N40291 · Destroyed > The pilot attempted to fly from phoenix to Bagdad, AZ under a low overcast. When it became obvious that weather conditions were too poor for a landing the pilot attempted to reverse direction and the aircraft struck high terrain. - [NTSB FTW82FPJ12](https://openairdocs.org/ntsb/FTW82FPJ12.md): Beech G35 · Stillwater, OK · Accident · 2 fatal · Final report · Jan 20, 1982 · N4438D · Destroyed > The aircraft departed on a dark night with no record of a flight plan filed or a weather briefing received. Witnesses observed the aircraft climb out of sight into a fog layer when 2/3 down the runway then reappear and continue to fly at tree top level… - [NTSB LAX82FUQ08](https://openairdocs.org/ntsb/LAX82FUQ08.md): Bede BD-5B · Mojave, CA · Accident · 1 fatal · Final report · Jan 17, 1982 · N381JH · Destroyed > After takeoff the amateur built Bede-5 entered left traffic and circled the airport once at 700 to 1000 feet AGL. During the second 180 degree turn from the downwind leg to the runway heading a witness reported that the bank angle suddenly increased and the… - [NTSB DEN82FA020](https://openairdocs.org/ntsb/DEN82FA020.md): Piper PA-31T · Delta, UT · Accident · Minor injuries · Field investigation · Final report · Jan 17, 1982 · N91TW · Destroyed > Approximately 1/2 mi from the arpt after takeoff, the plt noticed the left front baggage door partly open & made a left turn back toward the airstrip. After the turn, the baggage door came completely open, the left wing dropped immediately & the acft stalled.… - [NTSB DEN82DA019](https://openairdocs.org/ntsb/DEN82DA019.md): Cessna 180E · Cedar City, UT · Accident · No injuries · Final report · Jan 17, 1982 · N2600Y · Substantial damage > The pilot stated that he intended to fly close to the field surface dragging the tailwheel of the aircraft to determine snow/field conditions. During the low pass he used three notches of flap and added full power with the propeller at full pitch. When the… - [NTSB ATL82DA036](https://openairdocs.org/ntsb/ATL82DA036.md): Bell 206B · Centerville, AL · Accident · No injuries · Final report · Jan 17, 1982 · N203AL · Substantial damage > The mishap occurred during a practice hover with a 100 ft cable in preparation for an external load operation. While hovering about 100 ft AGL, the fuel boost pump light illuminated and the boost pump pressure dropped to zero. A descent was started; however,… - [NTSB LAX82DA035](https://openairdocs.org/ntsb/LAX82DA035.md): Bellanca 7GCBC · San Clementine, CA · Accident · Minor injuries · Final report · Jan 4, 1982 · N8630V · Substantial damage > During flight, the pilot observed an area of sloping terrain that appealed to him as a prospective piece of land to purchase. He stated that he got too low and slow with the sun in his eyes as he circled the area. The right wing struck the ground and the… - [NTSB FTW82FPG06](https://openairdocs.org/ntsb/FTW82FPG06.md): Piper J3C-65 · Star City, AR · Accident · 1 fatal · Closed · Dec 26, 1981 · N20886 · Substantial damage - [NTSB LAX82FVG10](https://openairdocs.org/ntsb/LAX82FVG10.md): Hiller Acft UH-12E · Angels Camp, CA · Accident · No injuries · Closed · Dec 10, 1981 · N93478 · Substantial damage Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=235 ## 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=234 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.