# 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 220 of 378 · 18,851 cases ## Cases, newest first - [NTSB CHI83FA393](https://openairdocs.org/ntsb/CHI83FA393.md): Piper PA-25-150 · Graceville, MN · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1983 · N6253Z · Destroyed > While spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires. - [NTSB NYC83LA225](https://openairdocs.org/ntsb/NYC83LA225.md): Cessna 182C · New Salem, MA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N8596T · Substantial damage > The acft collided with high tension wires while flying at about 100 ft AGL. The plt landed in the water and all 4 occupants evacuated safely. The ditching was controlled but the acft nosed over after impact. The passengers said they had no trouble until they… - [NTSB FTW83LA396](https://openairdocs.org/ntsb/FTW83LA396.md): Air Tractor AT-301 · Addis, LA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N4348S · Substantial damage > The acft made a forced landing in a plowed field after colliding with a low hanging transmission wire over a field beingsprayed. The plt applied full power after the collision but a damaged and locked up elevator caused excursions of climbing, stalling and… - [NTSB ATL83FKQ03](https://openairdocs.org/ntsb/ATL83FKQ03.md): Air Tractor AT-301 · Redwood, MS · Accident · No injuries · Final report · Aug 25, 1983 · N8511S · Substantial damage > The acft made a forced landing in a soybean field after severe vibration developed during a spraying operation. The pilot stated that the powerplant and flt controls were functioning normally at the time of the accident. An on-scene investigation revealed… - [NTSB ANC83FA152](https://openairdocs.org/ntsb/ANC83FA152.md): Cessna A-185F · Farewell, AK · Accident · 3 fatal · Field investigation · Final report · Aug 25, 1983 · N1725R · Destroyed > The acft collided with mountainous terrain in a narrow canyon, the acft was heading in a general direction to leave the canyon. The propeller damage indicates the engine was at high power at impact. The plt had given a PIREP to farewellfss when he was 40… - [NTSB MKC83FA199](https://openairdocs.org/ntsb/MKC83FA199.md): Champion 7KCAB · Boonville, MO · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1983 · N5270X · Destroyed > The acft crashed in a nose low, left wing low attitude during an aerobatic training flt. There were no signs of stretch on the seat belts of both seats. The instructor plt's body was found in the wreckage; however, the private plt's body was found about 900… - [NTSB ATL83FA339](https://openairdocs.org/ntsb/ATL83FA339.md): Piper PA-38-112 · Lexington, GA · Accident · Serious injuries · Field investigation · Final report · Aug 24, 1983 · N2490P · Destroyed > The plt was on a cable patrol/aerial observation mission. While patrolling, he missed a turn in the cable route & turn to relocate it. After relocating the route, he looked back to observe a portion that he had missed & saw a logging operation. The plt turned… - [NTSB NYC83FA221](https://openairdocs.org/ntsb/NYC83FA221.md): Robinson R-22 · Nashua, NH · Accident · Serious injuries · Field investigation · Final report · Aug 23, 1983 · N9078Z · Substantial damage > As the instructor watched the third liftoff from in front of the hangar, he observed the helicopter lift off the ground rapidly, its nose swinging quickly to the right as it did. During the yaw, the helicopter lost altitude rapidly until the right skid hit… - [NTSB CHI83LA392](https://openairdocs.org/ntsb/CHI83LA392.md): Ayres S2R-R1820 · Essexville, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1983 · N4025R · Destroyed > While on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under… - [NTSB LAX83FA398](https://openairdocs.org/ntsb/LAX83FA398.md): Champion 7GCAA · La Jolla, CA · Accident · 1 fatal · Field investigation · Final report · Aug 21, 1983 · N100ES · Destroyed > Prior to departure, the acft was observed being run up with the eng sputtering & backfiring quite badly. The acft returned to the hanger & 3 lower plugs were changed. The flt was then resumed. The acft was next observed off shore, with the eng sputtering &… - [NTSB CHI83LA389](https://openairdocs.org/ntsb/CHI83LA389.md): Cessna 172K · Canton, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1983 · N84843 · Destroyed > The acft collided with a tree about 20-30 ft AGL in IMC weather after calling rochester approach at 1244 CDT to say that he was lost and in a thunderstorm. The plt was not instrument rated. Radio contact was lost at 1247 CDT. The flt originated in alton, IL… - [NTSB ANC83LA151](https://openairdocs.org/ntsb/ANC83LA151.md): de Havilland DHC-2 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1983 · N3129S · Destroyed > The acft got into a downdraft and collided with hilly terrain. The pilot stated that he was spotting caribou and settled into the side of a hill. According to the passengers the acft was about 300 ft AGL prior to the descent to ground contact. - [NTSB LAX83FA395](https://openairdocs.org/ntsb/LAX83FA395.md): Boeing Vertol BV-107-II · Shaver Lake, CA · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1983 · N190CH · Destroyed > The only witness, the hooker, who gets logs ready for transport by the helicopter, stated that he heard noises and the rotor blades began coming apart as the acft started downhill with a log. Examination of the wreckage revealed that #3 sychronizing shaft… - [NTSB CHI83FA387](https://openairdocs.org/ntsb/CHI83FA387.md): Aerotek Pitts S-2A · Waukegan, IL · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1983 · N80016 · Destroyed > While on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight… - [NTSB LAX83LA389](https://openairdocs.org/ntsb/LAX83LA389.md): Piper PA25-235 · Somerton, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 1983 · N7104Z · Destroyed > The acft collided with the ground during a turn in turbulent air to abort an aerial application mission because of weather. The pilot stated that he had made two passes at the field he was spraying when he noticed the flagman and farmers waving him off due to… - [NTSB LAX83FA388](https://openairdocs.org/ntsb/LAX83FA388.md): Cessna P206B · Kernville, CA · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1983 · N4738F · Destroyed > The acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL. - [NTSB ATL83LA335](https://openairdocs.org/ntsb/ATL83LA335.md): Piper PA-25-235 · Baxley, GA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1983 · N6953Z · Substantial damage > The acft collided with trees during an emergency landing after the cockpit filled with smoke. A mechanic who examined the acft after the accident reported that exhaust gases had burned through the muffler shroud & had burned the ignition wires. - [NTSB ATL83LA326](https://openairdocs.org/ntsb/ATL83LA326.md): Grumman G-164A · Hatley, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1983 · N7904 · Destroyed > The pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.… - [NTSB SEA83FYA02](https://openairdocs.org/ntsb/SEA83FYA02.md): Piper PA-22-108 · Nr Jackpot, NV · Accident · 1 fatal · Final report · Aug 14, 1983 · N5533Z · Substantial damage > Prior to the accident, the acft was observed maneuvering in the vicinity. Subsequently, the acft collided with the ground while it was being flown under a 40 ft power line. Both of the occupants had student plt certificates that had expired. One of the… - [NTSB SEA83FA178](https://openairdocs.org/ntsb/SEA83FA178.md): Cessna 150 · Granite Falls, WA · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1983 · N4446U · Destroyed > The acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into… - [NTSB NYC83FFA02](https://openairdocs.org/ntsb/NYC83FFA02.md): Cessna 150M · So. Fallsburgh, NY · Accident · Serious injuries · Final report · Aug 14, 1983 · N704AL · Substantial damage > The acft was observed performing low level steep turns, climbs & dives over a hotel. The acft collided with the tops of trees, nosed over & crashed. The student plt resides at, & is employed by, the hotel. - [NTSB NYC83AA209](https://openairdocs.org/ntsb/NYC83AA209.md): Aerospatiale AS350D · Dover Township, NJ · Accident · 5 fatal · Final report · Aug 14, 1983 · N900JA · Destroyed > Witnesses observed the helicopter fly along the beach at alt of about 100-150 MSL, enter a bank to the right and descendinto the water at an angle of about 45 deg. Examination of the wreckage failed to reveal any pre-impact discrepancies of the aircraft or… - [NTSB LAX83LA384](https://openairdocs.org/ntsb/LAX83LA384.md): Cessna 150K · N. Palm Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 1983 · N6379G · Substantial damage > The plt reported he originally intended to fly aprx 19 mi to the Palm Springs arpt to perform night landings to acquire night currency. However, due to a radio malfunction, he was unable to communicate with the control tower. Therefore, he decided to return… - [NTSB LAX83FA386](https://openairdocs.org/ntsb/LAX83FA386.md): Schweizer SGS 1-35C · Jamul, CA · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1983 · N2941H · Destroyed > Reportedly, after waiting almost 2 hrs, the plt decided he would fly the sailplane, either for 1 hr or until the owner arrived, when the owner arrived, he observed the sailplane flying back & forth along the north side of ridge area. Subsequently, the acft… - [NTSB CHI83LER03](https://openairdocs.org/ntsb/CHI83LER03.md): Boeing A75N1 · Sabin, MN · Accident · Serious injuries · Final report · Aug 14, 1983 · N51125 · Substantial damage > Acft collided with power lines. - [NTSB SEA83LA175](https://openairdocs.org/ntsb/SEA83LA175.md): Pitts S-1S · Madras, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1983 · N8067 · Destroyed > The acft collided with the ground while performing low level aerobatics over the arpt. The pilot stated that was practicing a low level pass over the arpt and that while rolling he felt the acft was not responding correctly. He said his rate of descent was… - [NTSB MKC83FA189](https://openairdocs.org/ntsb/MKC83FA189.md): Piper PA-25-260 · Whittemore, IA · Accident · Serious injuries · Field investigation · Final report · Aug 13, 1983 · N8559L · Destroyed > The plt reported he was making a trim swath in a low area toward rising terrain when he approached an unexpected 'high line' wire. The wire was positioned diagonally across the field. He reported that while avoiding the wire, he was unable to clear nearby… - [NTSB FTW83LA383](https://openairdocs.org/ntsb/FTW83LA383.md): Pierce GS-1 · Sand Springs, OK · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N111JP · Substantial damage > The acft collided with the lake after maneuvering around at low alt for some time. A lake patrolman reported the acft alt before the crash at about 20 ft AGL. According to the plts statement he was about 50 ft high when he initiated a 30 to 40 degree angle of… - [NTSB DEN83LA190](https://openairdocs.org/ntsb/DEN83LA190.md): Cessna T188L · Wahpeton, ND · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N2070J · Substantial damage > The acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision… - [NTSB ANC83LA145](https://openairdocs.org/ntsb/ANC83LA145.md): Piper PA-18-150 · Teller, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 1983 · N4065Z · Substantial damage > According to the pilot. He made a pass over the airstrip to determine the wind direction. While maneuvering to land the acft stalled, probably because of the gusty winds. He recovered from the first stall and was preparing to depart the area when the acft… - [NTSB ANC83FA144](https://openairdocs.org/ntsb/ANC83FA144.md): Bell 206L-1 · Bettles, AK · Accident · No injuries · Field investigation · Final report · Aug 13, 1983 · N1081K · Substantial damage > According to the plt, the low fuel warning light illuminated when the fuel gage was indicating 200 lbs. He reported he could see the arpt lights & elected to continue the flt. After arriving, he terminated his apch to a 30 to 50 ft hover with no forward… - [NTSB CHI83FU008](https://openairdocs.org/ntsb/CHI83FU008.md): Eipper Quicksilver MX · Shelby Township, MI · Accident · 1 fatal · Final report · Aug 10, 1983 · UNREG · Destroyed > The ultralight was flying low over a gravel pit and suddenly pulled up and went into a dive. The acft engine was runningthroughout the maneuver according to witnesses. The acft did not pull out of the dive and the acft dove into the water. One witness thought… - [NTSB FTW83LA372](https://openairdocs.org/ntsb/FTW83LA372.md): Cessna 172P · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N52456 · Substantial damage > During a pre-solo flt, the flt instructor (CFI) asked the student to make a simulated forced landing apch to a road. The student made the apch, but while he was making a go-around maneuver, the acft's right wing tip collided with a tree on a rise in the… - [NTSB ATL83LA318](https://openairdocs.org/ntsb/ATL83LA318.md): Aeronca 7AC · Kenton, TN · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1983 · N1094E · Substantial damage > The pilot stated that while flying low and slow to observe crops, the aircraft stalled during a turn. The nose was lowered which placed the acft on a heading for a large oak tree. A turn was attempted to avoid the tree; the acft stalled again, struck tree… - [NTSB SEA83LA170](https://openairdocs.org/ntsb/SEA83LA170.md): Aerospatiale SA-315B · Montpelier, ID · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N49532 · Substantial damage > The plt & 3 passengers were on a flt to find drilling supplies that had been dropped off of a truck on the previous day. The plt reported that he was hovering down an abandoned road at about 5 to 10 mph & 15 to 20 ft AGL when the helicopter collided with… - [NTSB FTW83FA361](https://openairdocs.org/ntsb/FTW83FA361.md): Piper PA-28RT-201T · Seminole, TX · Accident · 3 fatal · Field investigation · Final report · Aug 7, 1983 · N2122Z · Destroyed > Prior to the flt, the plt & passengers were observed drinking beer in a lounge. They told witnesses that they were going to the arpt to eat & were later seen at a restaurant on the arpt. After that, they decided to fly. The takeoff time & purpose of the flt… - [NTSB DEN83LU002](https://openairdocs.org/ntsb/DEN83LU002.md): Mitchell P-38 · Olathe, CO · Accident · Serious injuries · Final report · Aug 7, 1983 · UNREG · Substantial damage > The owner of the ultralight reported that this was the plts 1st flt in this vehicle. Reportedly, he was learning to fly ultralights & had just completed several high speed runs to become familiar with the operation of the vehicle. The owner stated he saw the… - [NTSB CHI83FA366](https://openairdocs.org/ntsb/CHI83FA366.md): Rockwell 114 · Richmond, OH · Accident · 3 fatal · Field investigation · Final report · Aug 7, 1983 · N4778W · Destroyed > The acft was borrowed by the pilot to give a friend a familiarization flt in a retractable landing gear acft. The acft was observed by campers as it performed a stall and recovery. A 2nd stall was done but this time the acft entered a spin and after at least… - [NTSB LAX83LA376](https://openairdocs.org/ntsb/LAX83LA376.md): Piper PA-18-150 · Flagstaff, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 1983 · N7699Y · Substantial damage > The plt reported that during a pleasure flt, when he was flying over rising terrain north of Flagstaff, AZ, he realized a need for more altitude. He turned toward a downhill direction, but the acft crashed into the tree tops when he was unable to maintain… - [NTSB CHI83FA371](https://openairdocs.org/ntsb/CHI83FA371.md): Siai-Marchetti F.260C · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1983 · IRAID · Substantial damage > The foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin… - [NTSB ATL83LA315](https://openairdocs.org/ntsb/ATL83LA315.md): Bell 47D1 · Moultrie, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 1983 · N68632 · Substantial damage > After completing a swath run, the plt pulled up, made a turn, then started a let down for another pass. As he increased power, the eng RPM went from 3000 to 3100. At the same time, the plt heard a whining noise and noted that the rotor RPM was decreasing. The… - [NTSB ANC83FA139](https://openairdocs.org/ntsb/ANC83FA139.md): Bellanca 7ECA · Mccarthy, AK · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1983 · N5052E · Substantial damage > The acft was observed by another pilot to fly into a box canyon. The witness stated that the acft then atmptd what looked like a chandelle to reverse direction but stalled and came to rest on the side of the canyon wall. - [NTSB SEA83LA167](https://openairdocs.org/ntsb/SEA83LA167.md): Grumman G-164A · Klamath Falls, OR · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N6664Q · Destroyed > The acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and… - [NTSB MKC83LA179](https://openairdocs.org/ntsb/MKC83LA179.md): Piper PA-25-235 · Ludell, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1983 · N4739Y · Destroyed > The acft stalled and crashed during an aerial application maneuver. The pilot said the heavily loaded acft stalled during a turn. The accident site elevation is about 3000 ft and the temperature was 90 degrees f. the density alt was about 5500 ft. the pilot… - [NTSB MKC83FA177](https://openairdocs.org/ntsb/MKC83FA177.md): Piper PA-25-235 · Bentley, KS · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1983 · N7620Z · Destroyed > The acft stalled, crashed, nosed over and burned during an aerial application maneuver. The owner of the acft was spraying the same field in another acft and saw the accident. He stated, the acft pulled up at the completion of a run, was in a turn around when… - [NTSB FTW83LA365](https://openairdocs.org/ntsb/FTW83LA365.md): Sikorsky S-58 · Westwego, LA · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 1983 · N2518M · Substantial damage > The helicopter was being used to string power lines by carrying a 500 lb wt, to which, the respective wire was attached. While hovering at about 120 ft AGL & in close proximity to a power line tower, the eng loss power abruptly. An autorotative landing was… - [NTSB CHI83LA358](https://openairdocs.org/ntsb/CHI83LA358.md): Piper PA-25 · Baroda, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1983 · N4880Y · Substantial damage > The acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing… - [NTSB LAX83LA378](https://openairdocs.org/ntsb/LAX83LA378.md): Rockwell S2R · Cantua Creek, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1983 · N8874Q · Substantial damage > The plt report that while he was applying sulfur to a tomatoe field, sulfur dust, which had accumulated in the cockpit, ignited. He elected to make an emergency landing in an adjacent cotton field which was muddy from irrigation. After touchdown, the main… - [NTSB ATL83LA310](https://openairdocs.org/ntsb/ATL83LA310.md): Cessna T188C · Semmes, AL · Accident · No injuries · Limited investigation · Final report · Aug 4, 1983 · N3195J · Substantial damage > The acft collided with a power line during an aerial application maneuver. There were 2 set of wires crossing the area, a low set and a high set. The pilot suddenly came upon the low set and climbed over them but collided with the high set. The vertical… - [NTSB NYC83FNA04](https://openairdocs.org/ntsb/NYC83FNA04.md): Sikorsky H-19D · Halifax, MA · Accident · No injuries · Final report · Aug 3, 1983 · N37799 · Substantial damage > After arriving at the field to be sprayed, the plt initiated a descent to begin aerial application. At aprx 40 ft AGL & 50 KTS, the eng failed. The plt entered an autorotation, but could not avoid telephone wires. He was able to avoid hitting a dike, but in… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=221 ## 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=220 --- 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.