# NTSB investigations: Approach 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 207 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL83FA377](https://openairdocs.org/ntsb/ATL83FA377.md): Schweizer SGS 1-23 · Battleboro, NC · Accident · 1 fatal · Field investigation · Final report · Sep 24, 1983 · N124M · Substantial damage > The acft spun into the ground short of the rwy on final approach. This glider was towed aloft and flew in the local area for over an hour prior to the accident. A witness observed the glider enter the traffic pattern, turn base and overshoot the turn to… - [NTSB MIA83IA236](https://openairdocs.org/ntsb/MIA83IA236.md): Beech E18S · Opa-Locka, FL · Incident · No injuries · Incident investigation · Final report · Sep 22, 1983 · N967 · Minor damage > Both normal and emergency landing gear systems failed duringthe landing apch. The gear motor cutout switch was struck anthe emergency instruction plate in the cockpit was installed backwards. The pilot states that he had tried turning the handle in both… - [NTSB CHI83LA436](https://openairdocs.org/ntsb/CHI83LA436.md): Enstrom 280C · Pontiac, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 1983 · N5692L · Substantial damage > While returning from a traffic reporting flt, the plt elected to practice an autorotation. He stated that while he was in the process, the eng failed. He reported that he had initiated standard autorotation procedures, but impacted hard during the landing.… - [NTSB ANC83FA180](https://openairdocs.org/ntsb/ANC83FA180.md): Cessna 185 · Valdez, AK · Accident · 2 fatal · Field investigation · Final report · Sep 21, 1983 · N4559F · Substantial damage > The plt had tried to fly to silver lake, earlier that morning, but had to abort the mission due to low ceiling & visibility. When he had returned at 1110 adt, the ceiling had improved, but there was still layers of stratus & fog below the main cloud base.… - [NTSB SEA83FU009](https://openairdocs.org/ntsb/SEA83FU009.md): CGS Hawk · Richland, WA · Accident · Serious injuries · Final report · Sep 20, 1983 · UNREG · Destroyed > After being assembled, the ultralight vehicle was taxi tested, and on 9/19/83, it was flown on its 1st flt. The next morning it was taxi tested again. At aprx 0855 PDT, the plt took off on a local flt. At aprx 0945, after making a touch-and-go landing, the… - [NTSB ANC83FA177](https://openairdocs.org/ntsb/ANC83FA177.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Sep 20, 1983 · N2810M · Substantial damage > While approaching merrill field the eng quit. The acft landed on a city road & the gear collapsed. The wx in the vicinity of the accident site had marginal conditions with both rain & fog. The temp/dew point spread was 2 deg f. the plt attributed the eng… - [NTSB MIA83LA234](https://openairdocs.org/ntsb/MIA83LA234.md): Beech M35 · Bartow, FL · Accident · No injuries · Limited investigation · Final report · Sep 19, 1983 · N658V · Substantial damage > During arrival, the plt had intended to reposition the fuel selector from the right main to the left main position. However, he left the selector positioned at the right main tank. While on final apch, the eng lost power. The plt activated the boost pump &… - [NTSB MIA83FA235](https://openairdocs.org/ntsb/MIA83FA235.md): Beech 65-80 · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Sep 19, 1983 · N55ED · Destroyed > Several days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng… - [NTSB LAX83LA445](https://openairdocs.org/ntsb/LAX83LA445.md): Cessna P210N · Burbank, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1983 · N4845W · Substantial damage > While on final apch for a night landing, the eng lost power & the plt was unable to reach the rwy. Subsequently, during an emergency landing, the acft hit the top of a cyclone fence, damaging the nose gear, then the acft slid into a blast barrier. An eng… - [NTSB FTW83FA431](https://openairdocs.org/ntsb/FTW83FA431.md): Rockwell 690A · Nacogdoches, TX · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1983 · N111QL · Destroyed > After transporting passengers from longview, TX to Oklahoma city, ok & return to longview, the acft was refueled for a flt back to Nacogdoches, TX, where the acft was based. About 12 min after takeoff, the plt was cleared for an NDB apch to Nacogdoches &… - [NTSB LAX83LA443](https://openairdocs.org/ntsb/LAX83LA443.md): Fueslein Quickie · San Andreas, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1983 · N19Q · Substantial damage > The home built acft was equipped with a kawasaki TA-440A eng & an unspecified propeller, both of which were different than the original plans called for. The plt stated that on the 1st test flt with the new eng & prop combination, the eng RPM & thrust would… - [NTSB NYC83FA244](https://openairdocs.org/ntsb/NYC83FA244.md): Sud SA316B · Pittsburgh, PA · Accident · No injuries · Field investigation · Final report · Sep 17, 1983 · N72590 · Destroyed > The helicopter was on a flt to transport an acutely ill patient from one hospital to another. The aircrew consisted of a plt & two flt nurses. During arrival at the destination, the plt began an apch to an athletic field that was surrounded by tall bldgs & a… - [NTSB LAX84LA020](https://openairdocs.org/ntsb/LAX84LA020.md): Champion 7KCAB · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1983 · N5156X · Substantial damage > The plt made his apch to land on rwy 26 with winds reportedly from 270 deg at 10 gusting 15 KTS. During the landing, the acft touched down short of the runway in an area containing deep furrows. Subsequently, the main gear collapsed & the fuselage & wings of… - [NTSB LAX83LA447](https://openairdocs.org/ntsb/LAX83LA447.md): Schweizer SGS 2-33A · Fremont, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1983 · N57835 · Substantial damage > According to the student plt, he had found an area of lift after releasing from the tow plane & had soared to 2100 ft. however, while he was returning to the arpt, he realized that he would be too low to reach the rwy. He attempted to land on a highway, but… - [NTSB MIA83LA232](https://openairdocs.org/ntsb/MIA83LA232.md): Piper PA-38-112 · Quincy, FL · Accident · No injuries · Limited investigation · Final report · Sep 15, 1983 · N4344E · Destroyed > While turning fm downwind to base the eng ran rough and quit. The acft stalled at 50 ft and came to rest in a soybean field. Examination of the wreckage revealed no evidence of fuel in the eng or the rt tk with the fuel selector positioned to the rt tk. - [NTSB MIA83FU006](https://openairdocs.org/ntsb/MIA83FU006.md): American Aerolights EAGLE-2 · Miami, FL · Accident · 2 fatal · Final report · Sep 15, 1983 · UNREG · Destroyed > After taking off from a grass field, the 2 place, ultralight vehicle remained in a normal right traffic pattern. As the vehicle was on a base leg for landing, witnesses saw the right wing trailing edge area flutter, then the right wing dropped & the… - [NTSB ATL83LA371](https://openairdocs.org/ntsb/ATL83LA371.md): Bellanca 8KCAB · Saluda, VA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1983 · N5070N · Substantial damage > The acft landed off the rwy and cartwheeled into the tiedown area after the plt lost control during landing. The plt said the wind shifted while he was on final approach. He compensated with power and rudder but does not recall his airspeed. The acft snapped… - [NTSB NYC83FA242](https://openairdocs.org/ntsb/NYC83FA242.md): Piper PA-32R-301 · Collier Twnshp, PA · Accident · 3 fatal · Field investigation · Final report · Sep 14, 1983 · N84703 · Destroyed > During arrival, the plt contacted apch control & was provided radar vectors for a visual apch. While on the apch, he was instructed to keep his speed up until he was 1 1/2 mi on final. Vectors were provide with turns as necessary until the acft was 6 1/2 to 7… - [NTSB LAX83FVM10](https://openairdocs.org/ntsb/LAX83FVM10.md): Robinson R22 · San Jose, CA · Accident · No injuries · Final report · Sep 13, 1983 · N8398Q · Substantial damage > The private plt was certificated for fixed wing, single eng, land acft, but was not rated in helicopters. While on a solo flt, practicing landings, he was on final apch to land when he encountered a decrease in eng power & rotor RPM. Subsequently, the… - [NTSB LAX83LA460](https://openairdocs.org/ntsb/LAX83LA460.md): Cessna 150 · Sparks, NV · Accident · No injuries · Limited investigation · Final report · Sep 11, 1983 · N11491 · Substantial damage > The stu plt stated he encountered wind shear on short final and applied full pwr but the nose wheel struck a dirt bank at the rwy threshold. The acft bounced back into the air and came down on the rwy at which time the nose gear departed the acft as it slid… - [NTSB LAX83LA433](https://openairdocs.org/ntsb/LAX83LA433.md): Cessna 182A · S. Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1983 · N4812D · Substantial damage > According to the flt instructor (CFI), he & the student took off with 21 gal of fuel on board. Aprx 1.3 hrs. Later, the eng lost power as the student turned onto final apch for a landing. The CFI took control of the acft & made a forced landing on a river… - [NTSB ATL83LA368](https://openairdocs.org/ntsb/ATL83LA368.md): Cessna 310J · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Sep 11, 1983 · N3199L · Substantial damage > The acft landing gear collapsed during landing. An FAA inspector said the gear made grinding noises when extended. During a fly-by the left gear door appeared to be jammed. Reportedly the landing gear transmission assembly failed. - [NTSB MKC83FU006](https://openairdocs.org/ntsb/MKC83FU006.md): Eipper Quicksilver MXL · Ozark, MO · Accident · Serious injuries · Final report · Sep 10, 1983 · UNREG · Substantial damage > The acft collided with a tree during the approach to land. A witness to the accident, who had landed his ultralight, said the plt circled to land & then aborted to make another approach to land closer to the witnesss. As he made a right descending turn to… - [NTSB MKC83FA216](https://openairdocs.org/ntsb/MKC83FA216.md): Piper PA-14 · Trenton, MO · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1983 · N372T · Substantial damage > The acft had just received extensive maintenance at buffalo, MO, which included internal & external recovering & an STC modification. During arrival at Trenton, MO, the acft was observed on a short final apch. At a position of aprx 200 ft short of the rwy &… - [NTSB MKC83FA215](https://openairdocs.org/ntsb/MKC83FA215.md): Cessna 150G · Perry, IA · Accident · Serious injuries · Field investigation · Final report · Sep 9, 1983 · N2452J · Substantial damage > The plt was participating in a spot landing contest. A witness near the apch end of the rwy reported that when the acft was on final apch, it suddenly settled below tall trees about 1/8 mi from the rwy. He reported that it then went into a right bank, nose up… - [NTSB FTW83LA426](https://openairdocs.org/ntsb/FTW83LA426.md): Cessna 210L · Austin, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N1667X · Substantial damage > The acft was landed wheels-up in an open muddy field after the engine quit. The plt said that just prior to turning downwind he reduced power and extended the landing gear. Then the RPM was increased and mixture set to full rich at which time the engine quit.… - [NTSB MKC83FA214](https://openairdocs.org/ntsb/MKC83FA214.md): Beech C35 · Grain Valley, MO · Accident · Serious injuries · Field investigation · Final report · Sep 8, 1983 · N5843C · Substantial damage > The plt reported that when he was on final apch to land, the eng quit running & he was unable to glide to the rwy. Reportedly, the acft touched down in a vacant lot about 75 ft short & 15 ft below the level of the end of the rwy. After touching down, it… - [NTSB LAX83FU016](https://openairdocs.org/ntsb/LAX83FU016.md): Eipper MX · Visalia, CA · Accident · 1 fatal · Final report · Sep 7, 1983 · UNREG · Substantial damage > This ultralight plt, according to witnesses, expressed some anxiety about flying on the day of the accident. The instructor reviewed the procedures with her on the ground, but did not fly with her. The acft, prior to takeoff, had less than 2 gallons of fuel.… - [NTSB CHI83IA418](https://openairdocs.org/ntsb/CHI83IA418.md): Boeing 727-200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 7, 1983 · N1984 · Minor damage > The acft experienced a left walking beam failure when the landing gear was extended during approach, the acft log was noted 'during gear extension at 230 KTS tremendous bang occurred which dropped panels at rows 15-7 02 masks at row 18. Three green normal… - [NTSB CHI83LA414](https://openairdocs.org/ntsb/CHI83LA414.md): Cessna 140 · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Sep 5, 1983 · N2562N · Destroyed > The plt reported that while in the traffic pattern to land, he slipped the acft on downwind, and again on final apch, to lose altitude. Also, he stated that the right control wheel had hit an attache' case on the right seat & the apch was not good, so he… - [NTSB NYC83LA237](https://openairdocs.org/ntsb/NYC83LA237.md): Cessna 150H · Boonville, NY · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N22853 · Substantial damage > During an approach, the plt lowered 40 deg of flaps for a spot landing. As he approached the rwy, he banked left & added power to avoid hitting a tree. However, contact was made & he initiated a go-around. As the acft clipped some trees to the left, the nose… - [NTSB LAX83LA421](https://openairdocs.org/ntsb/LAX83LA421.md): Piper PA-24-250 · Clearlake, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1983 · N252EZ · Destroyed > During arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with… - [NTSB DEN83LA210](https://openairdocs.org/ntsb/DEN83LA210.md): Schweizer SGS 2-33A · Durango, CO · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N7590 · Substantial damage > After releasing from an aerial tow about 2,000 ft AGL, the plt was unable to find lifting thermals. The glider began to descend about 800 fpm so the plt maneuvered to return to the airstrip. The glider collided with several small trees short of the rwy. - [NTSB ATL83LA357](https://openairdocs.org/ntsb/ATL83LA357.md): Piper PA-28R-200 · St. Simons Isl., GA · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1983 · N4992S · Substantial damage > During arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the… - [NTSB ANC83LA162](https://openairdocs.org/ntsb/ANC83LA162.md): Piper PA-18-150 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1983 · N4097Z · Substantial damage > The acft stalled into the ground on final approach landing in gusty turbulent wind conditions. The pilot stated that he was trying to land when a gust of wind flipped the acft over at 500 ft AGL. He said he corrected with left aileron but by the time he could… - [NTSB FTW83LA413](https://openairdocs.org/ntsb/FTW83LA413.md): Piper PA-31-350 · Fort Smith, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1983 · N3594G · Destroyed > The acft had departed laredo, TX, on a flt to ft Smith, AR, with an intermediate stop at brinkley, AR. The fuel tanks were 'topped' at laredo, but no fuel was added at brinkley. During arrival at ft Smith, the plt declared an emergency for 'extremely low… - [NTSB CHI83LA411](https://openairdocs.org/ntsb/CHI83LA411.md): Piper J-3 · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N99163 · Substantial damage > The plt stated the engine quit, sputtered and quit again before he landed in a bean feild and nosed over. Plt who is also an A&P mechanic had been using sloshing/sealing compound (randolph tank sealer #802) in the fuel tank. After the accident the compound… - [NTSB ATL83LA350](https://openairdocs.org/ntsb/ATL83LA350.md): Piper PA-25-235 · Odum, GA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N8636L · Substantial damage > The plt stated he ran out of fuel about 1/2 mi from the rwy. - [NTSB SEA83LA191](https://openairdocs.org/ntsb/SEA83LA191.md): Gulfstream American AA-1 · Eatonville, WA · Accident · No injuries · Limited investigation · Final report · Sep 1, 1983 · N6106L · Substantial damage > The acft collided with a tree during a go-around. The pilot was able to continue flt to another arpt and complete a landing. During the attempted landing at the accident arpt the pilot stated she 'did not touch down when I expected'. During the go-around the… - [NTSB MIA83IA218](https://openairdocs.org/ntsb/MIA83IA218.md): Mcdonnell Douglas DC-10-30 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Sep 1, 1983 · YV134 · Minor damage > The acft experienced the separation of a flap vane while on final approach to land. 50 inches of the right flap vane separated and caused slight damage to a parked auto on the street below. The acft continued on to an unevently landing. The incident was not… - [NTSB SEA83FA189](https://openairdocs.org/ntsb/SEA83FA189.md): Piper PA-28-140 · Everett, WA · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1983 · N6874J · Destroyed > The acft collided with trees and the ground in an attempt to return to the arpt after takeoff. The acft crashed one milesouth of the arpt in IMC weather in the early hours of the morning. Witnesses said dense fog existed at the time with zero visibility. The… - [NTSB CHI83LA399](https://openairdocs.org/ntsb/CHI83LA399.md): Cessna 172E · Columbia Sta., OH · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1983 · N3540S · Destroyed > According to the non-rated plt, he was on downwind to land when he applied carburetor heat, then the eng RPM began to decrease. He stated that he pushed the throttle forward, but got no response from the eng. He further stated that the acft continued to lose… - [NTSB ATL83LA356](https://openairdocs.org/ntsb/ATL83LA356.md): Cessna 172C · Portsmouth Isl., NC · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N8338X · Substantial damage > Before hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the… - [NTSB SEA83LA188](https://openairdocs.org/ntsb/SEA83LA188.md): Grumman G-164 · Quincy, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1983 · N48719 · Minor damage > The acft collided with a car on the rwy during an aborted landing at a private airstrip. The pilot saw the auto as he turned base but believed the driver would cross and clear the rwy. Instead the driver went down the rwy in the directionof landing. When the… - [NTSB NYC83LA230](https://openairdocs.org/ntsb/NYC83LA230.md): Piper PA-22 · West Bloomfield, NY · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N5185Z · Substantial damage > Reportedly, the plt was returning to the departure arpt to land when the eng lost power. Subsequently, the acft was damaged during a forced landing in a corn field. An exam of the eng revealed excessive carbon in the exhaust stack. Also, the primer was found… - [NTSB NYC83LA229](https://openairdocs.org/ntsb/NYC83LA229.md): Burkhart Grob Flugzeugbau G103 · Julian, PA · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N906BG · Substantial damage > The student plt & instructor (CFI) were practicing pattern work & landings. During the 1st 3 patterns, the wind was calm, however, by the time they were on their 4th pattern, the wind increased & became gusty. While the student was flying the pattern, he… - [NTSB NYC83FGM05](https://openairdocs.org/ntsb/NYC83FGM05.md): Cessna 152 · Butler, PA · Accident · 1 fatal · Final report · Aug 29, 1983 · N4793Q · Destroyed > The acft crashed on approach to the final destination arpt after completion of a multi-legged x-ctry flt in foggy weather. The flt had 5 enroute stops which entailed 6 takeoffs and climbs during 3.6 hours. According to the FAA the acft contained 5 or 6… - [NTSB MKC83FA205](https://openairdocs.org/ntsb/MKC83FA205.md): Piper PA-24-151 · Chesterfield, MO · Accident · 2 fatal · Field investigation · Final report · Aug 29, 1983 · N7993C · Substantial damage > The plt landed a lawrenceburg, TN, on the evening of 8/28/83. Thunderstorms were reported in the area at that time. At lawrenceburg, fuel was available during daylight hours. At 0203 the next morning, the plt called the muscle shoals fss & obtained a wx… - [NTSB LAX83LA413](https://openairdocs.org/ntsb/LAX83LA413.md): Catto Acro X · Jackson, CA · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N83AX · Destroyed > After takeoff the plt made a turn into the downwind leg. At about 500 ft AGL while the plt rocked the winged to friends on the ground, the canopy blew off & became lodged in the right wing's flying wires. The acft began to roll to the right& pitch upwards.… - [NTSB NYC83FA228](https://openairdocs.org/ntsb/NYC83FA228.md): Beech 58PA · Danbury, CT · Accident · Serious injuries · Field investigation · Final report · Aug 28, 1983 · N158JB · Destroyed > Inbound to Danbury the plt was advised that the arpt was closed, & was given the last wx which was an hour old. The acft was observed to pass over the arpt 300-400 ft AGL & circle to land rwy 8. The acft turned base & final in a tight turn with the gear down.… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=208 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=207 --- 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.