# 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 221 of 378 · 18,851 cases ## Cases, newest first - [NTSB LAX83FUJ15](https://openairdocs.org/ntsb/LAX83FUJ15.md): Grau VARI-EZE · Tucson, AZ · Accident · 1 fatal · Final report · Aug 2, 1983 · N79AA · Destroyed > Witnesses observed the acft make 4 low passes, 200-300 ft AGL. On the last pass the acft pulled up ino about a 30 deg nose high attitude & start a right roll. The nose began to drop, & as the roll was completed the acft was in about a 80 deg nose low, wings… - [NTSB CHI83FA351](https://openairdocs.org/ntsb/CHI83FA351.md): Swain Rutan Longeze · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Aug 2, 1983 · N4ZZ · Substantial damage > The acft nosed over during a forced landing after a power loss. The acft collided with tall corn during the landing rolland swerved into the corn. Examination of the carburetor revealed pieces of a soft brownish-white somewhat elastic substance in the float… - [NTSB CHI83FA347](https://openairdocs.org/ntsb/CHI83FA347.md): North American AT-6D · Muskegon, MI · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1983 · N29938 · Destroyed > The acft collided with trees after performing an aerobatic maneuver at low altitude. Witnesses near the scene said the acft was flying low; most heard the engine running. Some said that at the top of a loop the engine sounded like it stopped. On the descent… - [NTSB MIA83LA194](https://openairdocs.org/ntsb/MIA83LA194.md): Bellanca 8GCBC · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1983 · N88477 · Destroyed > The plt reported that as he was recovering from the 1st banner tow mission, he noted a line of cumulus buildups moving northerly from over the gulf toward the arpt. He elected not to pick up another banner. He planned just to drop the banner he was towing,… - [NTSB FTW83LA358](https://openairdocs.org/ntsb/FTW83LA358.md): Rockwell S2R · Eudora, AR · Accident · No injuries · Limited investigation · Final report · Aug 1, 1983 · N4903X · Substantial damage > While dispensing fertilizer, oil suddenly covered the windshield & the eng began running at reduced power. The plt made an emergency landing in a water covered rice field where the wheels hit a levee & the acft nosed over. An exam revealed that the #1 exhaust… - [NTSB CHI83LA342](https://openairdocs.org/ntsb/CHI83LA342.md): Piper PA-25-235 · Camp Point, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1983 · N4332Y · Substantial damage > The plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field. - [NTSB CHI83FA243](https://openairdocs.org/ntsb/CHI83FA243.md): Pestes RV-3 · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1983 · N45AP · Destroyed > The accident occurred during a 'showcase' flyby at the annual eaa convention. The acft was flying #4 position in a formation of 4 acft. The flt was executing a very steep, near 90 deg bank left turn at 300-500 ft when the acft's came up & over putting the… - [NTSB ANC83FA137](https://openairdocs.org/ntsb/ANC83FA137.md): Grumman G-44A · Big Lake, AK · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1983 · N1423 · Destroyed > The acft crashed in a level, wooded area. The initial impact with trees occurred aprx 40 ft AGL. Both wing tips & a portion of the left stabilizer & elevator were found at the bases of the trees that were first impacted. From the first impact point, the… - [NTSB LAX83FVG15](https://openairdocs.org/ntsb/LAX83FVG15.md): Great Lakes 2T-1A-Z · Davis, CA · Accident · 2 fatal · Final report · Jul 30, 1983 · N5761N · Destroyed > The acft collided with the ground while performing aerobatic maneuvers. The plt had scheduled a number of aerobatic fltsfor various people. During the last flt of the day the aircraft crashed in a alt open, plowed field. Weather was not a factor. The aircraft… - [NTSB FTW83FU002](https://openairdocs.org/ntsb/FTW83FU002.md): Pterodactyl Ascenger II+ · Round Rock, TX · Accident · 1 fatal · Final report · Jul 30, 1983 · UNREG · Substantial damage > The ultralight vehicle had been recently built & had been flown once by an experienced ultralight plt. He reported there were no discrepancies in the vehicle's assembly or flt characteristics. The owner & 2 other personnel met at the flying area & assembled… - [NTSB DEN83LA178](https://openairdocs.org/ntsb/DEN83LA178.md): Piper PA-25 · Fowler, CO · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N6217Z · Substantial damage > The plt & the owner thought there was enough fuel remaining for about 1 hr of aerial application. During a procedure turn, aprx 45 min after takeoff, the eng lost power. The plt reported he tried to start the eng, but the acft was so low that he didn't have… - [NTSB ATL83FA299](https://openairdocs.org/ntsb/ATL83FA299.md): Schweizer SGS 1-23G · Warrenton, VA · Accident · 1 fatal · Field investigation · Final report · Jul 30, 1983 · N3843A · Destroyed > At an altitude of about 4,500 ft the glider was ovserved to pull up into a stall & enter a spin which continued for three turns. The glider came out of the spin into a left spiral & appeared to be traveling at a very high speed. The nose then 'tucked under'… - [NTSB FTW83FA357](https://openairdocs.org/ntsb/FTW83FA357.md): Ayres S2R · Waldenburg, AR · Accident · No injuries · Field investigation · Final report · Jul 29, 1983 · N5054X · Substantial damage > This acft made a hard forced landing in a field during aerial application after the engine failed. The landing gear failed during the landing. The post accident examination of the engine showed a failure and separation of the reduction gearing. The failure… - [NTSB ATL83LA297](https://openairdocs.org/ntsb/ATL83LA297.md): Hughes 269B · Summerville, SC · Accident · No injuries · Limited investigation · Final report · Jul 29, 1983 · N9419F · Substantial damage > The helicopter was being used in controlled burning of timberland. While being operated at an alt of aprx 20 ft over wind rows of organic material, there was a partial loss of eng power. The plt stated that he was unable to maintain a hover, so he landed on… - [NTSB LAX83FA362](https://openairdocs.org/ntsb/LAX83FA362.md): Fairchild Hiller FH-1100 · Porterville, CA · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1983 · N450FH · Destroyed > On 7/27/83, mild mast bumping occurred during a pushover maneuver while a hiller FH-1180 was on a flt to certify new rotor blades. Prior to the incident, the helicopter was accelerated to 90 mph. This was followed by a pull-up & deceleration to 80 mph, then… - [NTSB MKC83FA165](https://openairdocs.org/ntsb/MKC83FA165.md): Cessna 140 · Pratt, KS · Accident · Serious injuries · Field investigation · Final report · Jul 27, 1983 · N76242 · Destroyed > The acft stalled and crashed in a plowed field during an aerial application flt while dispensing wasp eggs on a corn field. The eggs were carried in plastic tubes in a styrofoam ice chest behind the seat and were transferred by the plt as needed to the… - [NTSB DEN83FA180](https://openairdocs.org/ntsb/DEN83FA180.md): Piper PA-28-235C · Pitkin, CO · Accident · 4 fatal · Field investigation · Final report · Jul 27, 1983 · N9378W · Destroyed > The acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,… - [NTSB FTW83LA350](https://openairdocs.org/ntsb/FTW83LA350.md): Hughes 369D · Kemah, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1983 · N1109 · No damage > The plt had landed in a restaurant parking lot. When he was informed that a local ordinance had been passed prohibiting helicopter operations from restaurant parking lots & that the police had been called, he prepared to takeoff. As the plt was preparing to… - [NTSB FTW83LA351](https://openairdocs.org/ntsb/FTW83LA351.md): Grumman G-164A · Chilton, TX · Accident · No injuries · Limited investigation · Final report · Jul 25, 1983 · N4866 · Substantial damage > During the 1st swath run the prop separated from the eng. A forced landing was made in a plowed field shearing one main landing gear. The acft then went through a barbed wire fence. The #4 cylinder was removed to inspect the vibration damper pins in… - [NTSB NYC83LA190](https://openairdocs.org/ntsb/NYC83LA190.md): Let L-13 · Fredericksburg, PA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1983 · N32360 · Substantial damage > After lift-off from a tow takeoff, the towplane was unable to attain the normal tow airspeed of 65 to 75 mph & continuedat about 55 mph. The glider plt thought the towplane was having engine problems, & as the two acft circled the arpt, theglider plt released… - [NTSB DEN83LA176](https://openairdocs.org/ntsb/DEN83LA176.md): Bellanca 7GCAA · Elbert, CO · Accident · No injuries · Limited investigation · Final report · Jul 24, 1983 · N8626V · Substantial damage > The acft engine quit while the plt was performing aerobatics, an airstart was unsuccessful and a forced landing was madein an open field surrounded by trees. During the landing one wing hit a tree causing the acft to veer into a creek. The plt said he had… - [NTSB LAX83LA355](https://openairdocs.org/ntsb/LAX83LA355.md): Cessna A150K · Stonyford, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 1983 · N8353M · Destroyed > The acft collided with the ground while negotiating a low level aerobatic maneuver. The acft had departed a private ranch airstrip and according to a witness the acft was 'rolled'. After a few circles of the strip. The witness was surprised because the plt… - [NTSB LAX83LA353](https://openairdocs.org/ntsb/LAX83LA353.md): Ayres Turbo Thrush S2R-34 · Avenal, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1983 · N57SK · Substantial damage > The acft collided with wires during aerial application. The acft hopper was inadvertently set on full open for the 3rd operation of the day. There is no indicator in the cockpit to show the pilot the position of the gate stop. When the pilot opened the hopper… - [NTSB LAX83FUA06](https://openairdocs.org/ntsb/LAX83FUA06.md): Rand Robinson KR-1 · Seal Beach, CA · Accident · 1 fatal · Final report · Jul 23, 1983 · N98BB · Destroyed > According to a witness, the acft apchd at about 1000 ft, made 3 circles & headed in an easterly direction. The acft was then observed to make a steep banked turn toward the witness at an estimated altitude of 200 to 300 ft above the water. It then nosed down,… - [NTSB DEN83LA174](https://openairdocs.org/ntsb/DEN83LA174.md): Beech C35 · Salida, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1983 · N12370 · Destroyed > The acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the… - [NTSB ANC83LA130](https://openairdocs.org/ntsb/ANC83LA130.md): Bellanca Citabria 7GCBC · Seward, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1983 · N50509 · Substantial damage > The pilot stated that he was flying at 200 feet AGL, at about 65 mph in a left turn, spotting fish for a fishing vessel when a map that was on his lap fell to the floor. When he reached for it his left hand hit the throttle, reducing power. Before he could… - [NTSB LAX83LA352](https://openairdocs.org/ntsb/LAX83LA352.md): Piper PA-22-108 · Mammoth Lakes, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1983 · N5737Z · Destroyed > The acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the… - [NTSB DEN83LA172](https://openairdocs.org/ntsb/DEN83LA172.md): Cessna T188C · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Jul 22, 1983 · N2834J · Substantial damage > The acft settled into trees after the engine lost power during a swath run. The flt had been in progress for about 15 minutes. The plt started the 4th run and the acft started to settle. The plt dumped the load but did not touch the throttle or mixture. He… - [NTSB SEA83LA154](https://openairdocs.org/ntsb/SEA83LA154.md): Weatherly 201C · Tensed, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 1983 · N9089W · Substantial damage > The acft had made 3 passes since reloading, so the acft was fairly heavy and was on an uphill pass as it began a turn- around. In an attempt to maneuver and clear 100 ft trees the acft stalled and the rt wing tip hit a tree. - [NTSB CHI83LA329](https://openairdocs.org/ntsb/CHI83LA329.md): Enstrom F-28F · Springfield, OH · Accident · No injuries · Limited investigation · Final report · Jul 21, 1983 · N81HF · Substantial damage > The plt reported he had taken on a 30 lb chemical load & 45 lbs of fuel in the left tank after landing on a nurse truck. He took off again. About 10 min later, after spraying the load, the boost pump failure light illuminated. The plt turned into the wind &… - [NTSB ATL83FU004](https://openairdocs.org/ntsb/ATL83FU004.md): Condor II Special · Dahlonega, GA · Accident · 1 fatal · Final report · Jul 21, 1983 · UNREG · Destroyed > After takeoff, the ultralight vehicle was observed to climb about 600 to 700 ft over a pasture east of the rwy, then the plt began to perform aerobatic maneuvers. After completing a loop, the ultralight was observed to rotate nose up. At about that time, a… - [NTSB MKC83FA161](https://openairdocs.org/ntsb/MKC83FA161.md): American Eagle 2-PLACE · Chesterfield, MO · Accident · 2 fatal · Field investigation · Final report · Jul 20, 1983 · N911AA · Destroyed > The acft was first observed in a left 30 deg bank turn with the nose slightly down. After the first 360 deg turn, the angle of bank increased to 60 deg. During the 3rd 360 deg turn, the diameter of the turn decreased to about 100 ft & theforward speed… - [NTSB FTW83FA343](https://openairdocs.org/ntsb/FTW83FA343.md): Hughes 269C · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1983 · N8995F · Destroyed > The helicopter crashed in a relatively high speed descent while in a slight nose-low and left bank attitude. The acft had been circling at an alt of about 600 ft MSL awaiting clearance to land. The PIC in the left seat, who was not flying the acft, said he… - [NTSB LAX83LA334](https://openairdocs.org/ntsb/LAX83LA334.md): Cessna A188B · Calipatria, CA · Accident · No injuries · Limited investigation · Final report · Jul 19, 1983 · N4463Q · Substantial damage > The acft made a hard landing in a cotton field during a crop dusting operation after buffeting was felt in a turn. The pilot thought he was stalling in vortex turbulence from another acft in front of him. A toxic load of suprecide was dumped before the pilot… - [NTSB CHI83LA321](https://openairdocs.org/ntsb/CHI83LA321.md): Hiller UH-12E · Brooklyn Park, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N120NR · Substantial damage > The plt reported that he was spraying the end rows of a field when the helicopter approached some wires. He stated that he saw the wires at the last second & tried to get under them. Reportedly, the helicopter crossed below a set of power lines, but struck a… - [NTSB FTW83LA336](https://openairdocs.org/ntsb/FTW83LA336.md): Cessna 172 · Rutheron, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1983 · N8198B · Substantial damage > The acft collided with the ground inadvertantly after dropping emergency drilling equipment at a drilling site. The plt was making another pass to check on the drop when the acft started to descend. In spite of power application the acft descended into an… - [NTSB LAX83LA344](https://openairdocs.org/ntsb/LAX83LA344.md): Piper PA-28 · Columbia, CA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N5492W · Substantial damage > The acft contacted a powerline 100 ft above the water at new mellones reservoir. The acft was landed at Columbia. CA without further incident. An inspection of the acft revealed that the top portion of the vertical stabilizer was missingand the rudder was… - [NTSB LAX83LA340](https://openairdocs.org/ntsb/LAX83LA340.md): Hughes 269 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N8773F · Substantial damage > The instructor was demonstrating a power recovery autorotation to a dry river bed, which he initiated at 500 feet AGL by rolling off the throttle and lowering the collective. Aprx 5 seconds later he observed a change in sound and noticed the engine RPM at 0.… - [NTSB DEN83LA167](https://openairdocs.org/ntsb/DEN83LA167.md): Cessna 188A · Burlington, CO · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N1584M · Substantial damage > The acft stalled into the ground after a dive and accelerated pull-up during aerial application. The pilot stated that he was doing the steep pull-ups and dives because of proximity to the city of Burlington co. he said the acft was just about empty of gas… - [NTSB ATL83LA281](https://openairdocs.org/ntsb/ATL83LA281.md): Grumman G-164A · Sledge, MS · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N8526H · Destroyed > The acft collided with the ground and nosed over during an aerial application maneuver. The plt stated, the acft startedto settle while in a turn and he dumped the load after leveling the wings but was unable to stop the descent prior to ground contact. The… - [NTSB DEN83LA166](https://openairdocs.org/ntsb/DEN83LA166.md): Weatherly 201B · Thompson, ND · Accident · No injuries · Limited investigation · Final report · Jul 15, 1983 · N1279W · Substantial damage > The acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left… - [NTSB MIA83FA183](https://openairdocs.org/ntsb/MIA83FA183.md): Kaman H-43B · Near Clermont, FL · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1983 · N57996 · Destroyed > The helicopter crashed in an uncontrolled descent from a hover. A witness stated that the helicopter was slowing descending to position a 150 ft line for the ground crew when he observed something separate and the helicopter came down in a vertical descent.… - [NTSB LAX83FA335](https://openairdocs.org/ntsb/LAX83FA335.md): Bellanca 7KCAB · Fontana, CA · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1983 · N7692S · Destroyed > The acft impacted the terrain at 4600 ft MSL at a steep angle in brush and dirt near a fire road. According to the plts family the acft had recently been purchased by the plt and he frequently practiced aerobatics in the late afternoon. Hisaerobatic… - [NTSB MKC83LA155](https://openairdocs.org/ntsb/MKC83LA155.md): Cessna A188B · Edgar, NE · Accident · No injuries · Limited investigation · Final report · Jul 13, 1983 · N9114G · Destroyed > The plt reported that he was completing a turnaround when the acft encountered turbulence from another plane that was spraying the same field. The acft began to settle. When he pulled up to avoid a power line, the acft stalled & crashed. - [NTSB MKC83FA153](https://openairdocs.org/ntsb/MKC83FA153.md): Cessna 188B · Shelton, NE · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1983 · N731AC · Destroyed > The plt had dusted 1 field & had started dusting another that was located on rolling terrain. After making 3 swath runs over the 2nd field, he was maneuvering for a 4th run when the acft's right wing impacted with a power line cable. The wing's leading edge &… - [NTSB FTW83FA332](https://openairdocs.org/ntsb/FTW83FA332.md): Boeing B75N1 · Webb, TX · Accident · Serious injuries · Field investigation · Final report · Jul 12, 1983 · N59085 · Destroyed > The pilot stated that before flying under wires a bird struck and broke a plastic fuel gauge mounted under the center section of the upper wing. Fuel reportedly sprayed onto the windscreen and the pilots face restricting his forward visibility. In an effort… - [NTSB ATL83LA273](https://openairdocs.org/ntsb/ATL83LA273.md): Cessna 305A · N. Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1983 · N5172G · Substantial damage > The acft stalled into an inland waterway shortly after takeoff for a banner towing flt. The pilot reported he had just refueled and made a takeoff. He was on the crosswind leg of the traffic pattern when the accident happened. He stated that he encountered… - [NTSB ATL83FA272](https://openairdocs.org/ntsb/ATL83FA272.md): Piper J3C-65 · Ellenwood, GA · Accident · 2 fatal · Field investigation · Final report · Jul 12, 1983 · N92367 · Substantial damage > During the flt, the acft collided with 2 utility transmission lines, then crashed to the ground. According to witnesses, the accident occurred after the acft had circled the passenger's home & the plt had started a turn. An exam of the wreckage revealed no… - [NTSB LAX83LA330](https://openairdocs.org/ntsb/LAX83LA330.md): Grumman G-164 · Princeton, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1983 · N9707 · Destroyed > The acft made a forced landing and was destroyed by fire after an engine failure during a spraying operation. The plt stated that his flagger saw black smoke during the pull-up. The smoke turned white and was observed coming from the stacks. Inspection of the… - [NTSB FTW83LA327](https://openairdocs.org/ntsb/FTW83LA327.md): Bell 212 · Eugene Island · Accident · No injuries · Limited investigation · Final report · Jul 11, 1983 · N16989 · Substantial damage > After making an apch to an off-shore oil well heliport, the plt believed the tail rotor was too close to a stairwell, so he made a peddle turn to the right. During the turn, the tail rotor blades contacted a crane. The crane was located about 15 ft from the… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=222 ## 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=221 --- 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.