# 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 219 of 378 · 18,851 cases ## Cases, newest first - [NTSB MIA83LA243](https://openairdocs.org/ntsb/MIA83LA243.md): Boeing A75N1 · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 1983 · N66524 · Substantial damage > On the previous flt, the plt noted that the left brake was weaker than the right brake. Before taking off again, he added fluid to the left brake sys. After flying about 1 hr, he returned & landed. During the landing roll, the left brake failed to operate.… - [NTSB LAX83LA441](https://openairdocs.org/ntsb/LAX83LA441.md): Cessna 188 · Winkelman, AZ · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1983 · N21613 · Destroyed > The right wing collided with wires at the end of a swath run and the acft was pulled to the ground about 300 ft from the wires. - [NTSB FTW83LA432](https://openairdocs.org/ntsb/FTW83LA432.md): Ayres S2R · Bay City, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1983 · N5049X · Substantial damage > During a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly… - [NTSB MIA83FA231](https://openairdocs.org/ntsb/MIA83FA231.md): Pitts S-2A · Green Cove Spr., FL · Accident · 2 fatal · Field investigation · Final report · Sep 15, 1983 · N80041 · Substantial damage > The acft collided with the ground and was destroyed during a pleasure flt. Examination of the wreckage and the accident site revealed evidence to suggest that the acft collided with the ground while in a steep left bank, nose low attitude and a high rate of… - [NTSB LAX83LA467](https://openairdocs.org/ntsb/LAX83LA467.md): de Havilland B-206 · Davenport, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 15, 1983 · N206TB · Destroyed > The acft collided or ditched in the water while attempting to evade customs officials. Custom officials had been watching this acft and followed it from Mexico. After a touch and go landing at compton the acft left the los angeles area at 200 ft MSL trying to… - [NTSB LAX83FVG17](https://openairdocs.org/ntsb/LAX83FVG17.md): Hiller UH12L · Tulelake, CA · Accident · 1 fatal · Final report · Sep 15, 1983 · N871H · Destroyed > The helicopter was on an agricultural spraying operation. While performing a turn-around, a spray boom struck a raised dirt bank beside a ditch at the edge of the field. Subsequently, the helicopter was pitched down & to the right, then impacted an upright… - [NTSB SEA83LA201](https://openairdocs.org/ntsb/SEA83LA201.md): Hughes H-369D · Wrangell, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 1983 · N10915 · Destroyed > The helicopter landed hard and rolled over out of an autorotation attempt after a power loss. The acft was in the progress of a line-pull through trees when the attitude changed sufficiently to allow the fuel pump to entrain air into the fuel system. There… - [NTSB LAX83FA439](https://openairdocs.org/ntsb/LAX83FA439.md): Piper PA-38-112 · S. Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Sep 13, 1983 · N9734T · Destroyed > The acft crashed during low alt turn following takeoff from the so. Lake Tahoe arpt. The tower controller advised the plt, after takeoff, that he could turn and circle the valley to gain alt before proceeding on course. The acft made one 360 deg turn and… - [NTSB FTW83LA085](https://openairdocs.org/ntsb/FTW83LA085.md): Hiller H-23D · Humble, TX · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N3201F · Substantial damage > The helicopter made a hard autorotative landing after a power loss. The pilot stated he was hovering about 75 ft AGL waiting for ground personnel to attach a line to his external sling load when the engine decelerated to flt idle and he could not regain… - [NTSB DEN83LA213](https://openairdocs.org/ntsb/DEN83LA213.md): Piper PA-28B-150 · Watford City, ND · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N5821W · Substantial damage > The acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he… - [NTSB DEN83FA215](https://openairdocs.org/ntsb/DEN83FA215.md): Hughes 369D · Woodruff, UT · Accident · Minor injuries · Field investigation · Final report · Sep 12, 1983 · N8667F · Substantial damage > The helicopter was being used to lift seismic materials on a 100 ft long line. After lifting the load to a hover at about 10 to 20 ft, the plt heard a loud 'bang' which was followed by a loss of directional control. The helicopter began uncontrolled spinning… - [NTSB FTW83FA424](https://openairdocs.org/ntsb/FTW83FA424.md): Partenavia P68C · Plainview, TX · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1983 · N29561 · Destroyed > The plt was executing a high speed pass over the rwy at about 250 ft AGL. The plt then began a rapid pull-up & both wings separated just outboard of the eng nacelles. Reconstruction of the sequence from a videotape revealed that the acft's speed at the time… - [NTSB ATL83FA365](https://openairdocs.org/ntsb/ATL83FA365.md): North American SNJ · Millington, TN · Accident · 2 fatal · Field investigation · Final report · Sep 11, 1983 · N9789Z · Destroyed > Th plt was giving free rides to spectators at an air show. The acft was observed making what appeared to be a loop which was initiated at a low altitude. As the acft reached the top of the loop, it was estimated to be 1,000 to 1,200 ft AGL. The nose then… - [NTSB ANC83LA169](https://openairdocs.org/ntsb/ANC83LA169.md): Cessna C-152 · Eagle River, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1983 · N94547 · Destroyed > The acft collided with rising terrain while maneuvering during a training flt at an alt of 3000 ft MSL. The acft was destroyed and the 2 occupants seriously injured. The CFI stated that there were no mechanical malfunctions which contributed to the accident… - [NTSB LAX83FA435](https://openairdocs.org/ntsb/LAX83FA435.md): Cassutt 3-M · Mesa, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1983 · N2309E · Destroyed > The acft collided with a street lamp while pulling up from a low pass over a dry river bed. This experimental amateur built acft was operating outside the prescribed boundaries for this acft. Witnesses disagreed on the engine sounds. Somedescribed the engine… - [NTSB FTW83LA444](https://openairdocs.org/ntsb/FTW83LA444.md): Clarks Pitt Special S1S · Manvel, TX · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N2050 · Substantial damage > The acft buffetted abnormally during an aerobatic maneuver so the plt relaxed the 'g' loading on the airframe. The plt noted a concave deformity in the bottom of the left upper wing. Level flt was achieved to test the flt characteristics of the acft. Flt… - [NTSB ATL83LA363](https://openairdocs.org/ntsb/ATL83LA363.md): Eipper Quicksilver MX II · Manteo, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1983 · N242KH · Substantial damage > The plt reported that while he was demonstrating a stall, the eng lost power & would not recover. Subsequently, he landed in a marsh & the ultralight acft nosed over. During an exam, water was found in the carburetor & fuel pump. The fuel tank cap was… - [NTSB ATL83FIG07](https://openairdocs.org/ntsb/ATL83FIG07.md): Bellanca 8GCBC · Berlin, MD · Accident · 1 fatal · Final report · Sep 10, 1983 · N90916 · Destroyed > The acft crashed into trees after the acfts landing gear became entangled in the banners tow bridle during an attempted banner pick-up. According to one witness who was a member of the banner crew on the field, the acft came in too low and caught the left… - [NTSB LAX83LA430](https://openairdocs.org/ntsb/LAX83LA430.md): Piper PA-36 · Huron, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N56070 · Substantial damage > The plt was spraying lettuce fields on a dark night. According to him, the wind was blowing from the north northwest & gusting to 12 KTS. He reported that during a turn-around over a plowed field, the wind was blowing dust which affected his visibility &… - [NTSB LAX83FA436](https://openairdocs.org/ntsb/LAX83FA436.md): Cessna 172N · Newport Beach, CA · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1983 · N734RL · Destroyed > About 30 mins before the accident, the two plts stopped by a hangar to say hello to an individual. This person reported that the plt appeared to be intoxicated; his speech was slurred, he couldn't focus his eyes on things very easily & he giggled a lot. The… - [NTSB ATL83LA361](https://openairdocs.org/ntsb/ATL83LA361.md): Cessna 188 · Slocomb, AL · Accident · No injuries · Limited investigation · Final report · Sep 8, 1983 · N9829V · Substantial damage > The plt stated that he pulled up from a swath run and the eng began loosing power. He climbed to 300 ft & started back to the airstrip, then a total power loss occurred. During an emergency landing, he was unable to stop before the acft collided with trees at… - [NTSB MKC83LA213](https://openairdocs.org/ntsb/MKC83LA213.md): Grumman G-164 · Odessa, MO · Accident · No injuries · Limited investigation · Final report · Sep 7, 1983 · N459Y · Substantial damage > The acft was making an aerial application turn when according to the pilot the engine quit. The landing was made in a stubble terraced field which collapsed the left main landing gear. During the landing the acft struck the rising terrainof a terrace and… - [NTSB ATL83LA358](https://openairdocs.org/ntsb/ATL83LA358.md): Grumman G-164A · Estill, SC · Accident · No injuries · Limited investigation · Final report · Sep 7, 1983 · N4698 · Destroyed > During a swath run, the acft began to lose power, so the plt aborted the mission & started back to the arpt to land. However, before reaching the arpt, the eng quit running & the plt landed in a field. During the landing, the acft was extensively damaged. An… - [NTSB MIA83FA225](https://openairdocs.org/ntsb/MIA83FA225.md): Cessna A152 · Homosassa Sprgs, FL · Accident · 1 fatal · Field investigation · Final report · Sep 6, 1983 · N7597L · Destroyed > The acft was first observed making low passes, almost striking trees & power lines. It then continued in a steep bank through about 90 deg of turn, rolled inverted & pitched down simultaneously. The acft impacted the ground in the parkinglot of a convenience… - [NTSB FTW83LA420](https://openairdocs.org/ntsb/FTW83LA420.md): Cessna 172N · Los Alamos, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1983 · N2380E · Destroyed > The acft was unable to climb above local mountainous terrain & attempted to make a 180 deg turn. The acft stalled & crashed on redondo peak. - [NTSB ATL83LA355](https://openairdocs.org/ntsb/ATL83LA355.md): Hiller UH-12E · Cameron, SC · Accident · No injuries · Limited investigation · Final report · Sep 5, 1983 · N4029R · Substantial damage > The plt stated that he was on a trimming/swath run at about 15 ft AGL & 15 mph when he heard a strange noise which was followed by a 180 deg yaw. Subsequently, the helicopter crash landed, damaging the tail boom & tail rotor blades and spreading the landing… - [NTSB NYC83LA234](https://openairdocs.org/ntsb/NYC83LA234.md): Cessna 305A · Seaside Heights, NJ · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N5179G · Substantial damage > The acft collided with a ditch during landing and nosed down. The pilot had made a low approach to pick up a banner but was unable to maintain airspeed and altitude. The banner was dropped but the acft continued to descend. The pilot flaredfor a normal… - [NTSB LAX83FA419](https://openairdocs.org/ntsb/LAX83FA419.md): Eaa Biplane A-1 · Mesa, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 3, 1983 · N369Y · Destroyed > The acft was observed performing 2 or 3 consecutive loops at an altitude of about 1,000 ft. following the last loop, theacft pulled up to a near vertical attitude, stalled, slid straight down & entered a spin. The eng was heard running in an apparent normal… - [NTSB CHI83LU012](https://openairdocs.org/ntsb/CHI83LU012.md): Weedhopper B · Fall Creek, WI · Accident · Serious injuries · Final report · Sep 3, 1983 · UNREG · Destroyed > The ultralight collided with a powerline during maneuvering after takeoff. The pilot had made a normal takeoff and circled a hayfield and decided to return for landing. The pilot stated he had trouble controlling the acft in a left turn. During a turn the… - [NTSB ANC83LA159](https://openairdocs.org/ntsb/ANC83LA159.md): Cessna P206C · Kenai, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1983 · N8698Z · Substantial damage > According to the pilot, after a reduced power descent and cirling a moose at an alt of aprx 300 ft AGL, when throttle was added for climb, the eng failed to respond but continuedto operate at the reduced power level. In attempting a reduced power glide to a… - [NTSB MKC83LA210](https://openairdocs.org/ntsb/MKC83LA210.md): Cessna 188A · Klemme, IA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1983 · N9921G · Substantial damage > The acft inadvertently descended into the tops of a corn crop while dispensing smoke in preparation for spraying. The induced drag slowed the acft and it landed hard. The plt stated he diverted his his attn to the spray nozzles. - [NTSB DEN83LA206](https://openairdocs.org/ntsb/DEN83LA206.md): Cessna 182 · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Sep 2, 1983 · N8739T · Substantial damage > The CFI stated that while practicing emergency landings, smoke started billowing into the cockpit. She also noticed a lot of heat near her legs. Thinking that there might be a fire on the other side of the firewall, the CFI decided to land in a corn field.… - [NTSB CHI83FA407](https://openairdocs.org/ntsb/CHI83FA407.md): Cessna 152 · Anoka, MN · Accident · 2 fatal · Field investigation · Final report · Sep 2, 1983 · N4975A · Destroyed > The plt rented the acft & reported that he & his friend would be going on a local flt. A witness stated that he saw the acft fly over at an estimated 1000 to 1500 ft AGL. Reportedly, the acft was in level flt when the plt 'cut' the power, the acft 'nosed up a… - [NTSB ATL83LA352](https://openairdocs.org/ntsb/ATL83LA352.md): Schweizer G-164B · Tyler, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1983 · N8438K · Destroyed > The plt reported that while he was spray a field, he was flying under 2 transmission lines. He reported that as he began spraying the field, there was a thunderstorm aprx 2 to 3 mi away & the air became 'rough.' As the acft was crossing under the 2nd wire on… - [NTSB ATL83FU006](https://openairdocs.org/ntsb/ATL83FU006.md): Condor II · Slate Hill, VA · Accident · 1 fatal · Final report · Sep 2, 1983 · UNREG · Substantial damage > During a local flt, the ultralight vehicle was observed approaching a residence in a shallow descent & with little eng noise. A witness stated that just prior to hitting a tall tree, the eng sound increased, the nose pitched up & the empennage struck tree… - [NTSB ANC83LA157](https://openairdocs.org/ntsb/ANC83LA157.md): Champion 7KCAB · Soldotna, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1983 · N7536F · Substantial damage > While sightseeing the plt stated he saw a moose & made a sharp turn. The acft stalled but the plt recovered from the stall. During recovery the acft hit the top 8 ft of an 80 ft tree. The acft then spun to the ground. - [NTSB CHI83LA408](https://openairdocs.org/ntsb/CHI83LA408.md): Cessna 188 · Little York, IN · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1983 · N9986G · Destroyed > The plt stated that he circled & looked for wires & obstructions prior to spraying. During a run he flew over a first set of wires but struck a second set of wires which were not marked & the poles were difficult to see because they were in trees. From the… - [NTSB DEN83LA204](https://openairdocs.org/ntsb/DEN83LA204.md): Hiller UH-12E · Manning, ND · Accident · No injuries · Limited investigation · Final report · Aug 31, 1983 · N400AH · Substantial damage > The acft collided with the ground after an eng failure while stringing power lines. The acft was in a right side low, nose high attitude pulling a wire attached to the left side of the acft. The wind was from the right rear quarter when the loss of power… - [NTSB DEN83FTE12](https://openairdocs.org/ntsb/DEN83FTE12.md): Piper PA-25-260 · Lamar, CO · Accident · Serious injuries · Final report · Aug 31, 1983 · N7606Z · Substantial damage > The acft collided with the ground during an aerial application maneuver. The pilot stated that he finished the second spray run and while in a turn the acft hit the ground on flat terrain. The pilot stated that he did not remember anymoreabout the flt. A fuel… - [NTSB ATL83LA348](https://openairdocs.org/ntsb/ATL83LA348.md): Grumman G-164A · Clinton, KY · Accident · No injuries · Limited investigation · Final report · Aug 31, 1983 · N5256 · Substantial damage > The plt reported that he was spraying a field that was bordered by obstacles. When he was about half way thru a procedure turn, the eng began 'backfiring & losing power.' The plt moved the throttle to about the 1/2 power setting, hoping the condition would be… - [NTSB ATL83LA347](https://openairdocs.org/ntsb/ATL83LA347.md): Snow 600-S2C · Blackshear, GA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1983 · N1635S · Substantial damage > The pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed… - [NTSB CHI83FA402](https://openairdocs.org/ntsb/CHI83FA402.md): Beech 58P · Cassopolis, MI · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1983 · N88AX · Destroyed > The acft entered a flat spin while practicing VMC maneuvers. The right fuel valve was in the off position. - [NTSB ATL83LA346](https://openairdocs.org/ntsb/ATL83LA346.md): Piper PA-25-235 · Falkland, NC · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N4633Y · Substantial damage > The plt reported that during a pull-up from a swath run, the acft began to shake & lose power. He continued to climb with full throttle & was able to maintain altitude for a short time, then the eng had a total power loss. Reportedly, the acft collided with… - [NTSB ATL83FKG11](https://openairdocs.org/ntsb/ATL83FKG11.md): Cessna A188A · Jesup, GA · Accident · 1 fatal · Final report · Aug 29, 1983 · N5633J · Substantial damage > The plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered… - [NTSB SEA83FA187](https://openairdocs.org/ntsb/SEA83FA187.md): Cessna 182C · Near Elk River, ID · Accident · 3 fatal · Field investigation · Final report · Aug 28, 1983 · N8807T · Destroyed > The acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.… - [NTSB LAX83FU014](https://openairdocs.org/ntsb/LAX83FU014.md): Davis Homebuilt · Byron, CA · Accident · 1 fatal · Final report · Aug 28, 1983 · UNREG · Substantial damage > Ground witnesses reported that the ultralight departed the private airstrip to the east. After departure the plt negotiated a 90 deg lt turn, followed by a 270 deg rt turn. After the 90/270 deg turn was completed, the plt negotiated a rt traffic pattern but… - [NTSB SEA83FA186](https://openairdocs.org/ntsb/SEA83FA186.md): Cessna 150F · Bellingham, WA · Accident · Serious injuries · Field investigation · Final report · Aug 27, 1983 · N7751F · Destroyed > The plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point. - [NTSB MKC83LA202](https://openairdocs.org/ntsb/MKC83LA202.md): Cessna 188A · Wayne, NE · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1983 · N4777R · Substantial damage > The acft collided with the ground during an aerial application maneuver. The pilots attention was diverted when he was looking for 3 wheel vehicles so he 'wouldn't spray them'. He did not realize that a hill was in his path and could not pull-up soon enough. - [NTSB CHI83LU011](https://openairdocs.org/ntsb/CHI83LU011.md): Pioneer Flightstar · Robinson, IL · Accident · Serious injuries · Final report · Aug 27, 1983 · UNREG · Substantial damage > The plt reported that after taking off, he stayed low over farm fields. He reported that he traveled about 1 1/4 mi from the arpt & decided to return & land. However, during a left turn, the ultralight vehicle crashed. The plt was seriously injured & did not… - [NTSB DEN83LA199](https://openairdocs.org/ntsb/DEN83LA199.md): Piper PA-25B-235 · Montrose, SD · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1983 · N4473Y · Destroyed > The pilot stated that he was spraying a field that was divided in half by a 60 foot high powerline. As he made a turn to enter the south side of the field, parallel to the powerlines, flying east into the sun, he struck the unseen guy cables out in the field.… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=220 ## 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=219 --- 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.