# 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 197 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC85LA033](https://openairdocs.org/ntsb/NYC85LA033.md): Piper PA-32-300 · Prospectville, PA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N31699 · Substantial damage > Plt stated he allowed the acft to go low on final approach. Collision with terrain separated the landing gear but plt recovered control as acft rebounded and executed a successful go-around. Plt diverted with escort to nearby military arpt where CFR… - [NTSB CHI85FA059](https://openairdocs.org/ntsb/CHI85FA059.md): Ercoupe 415-C · Wixom, MI · Accident · 1 fatal · Field investigation · Final report · Nov 25, 1984 · N2047H · Destroyed > The acft collided with power lines while on final approach for a landing. The passenger related that the sun was very low on the horizon, and while looking toward the sun & haze, the visibility was limited. As the acft turned on final approach, a large flock… - [NTSB NYC85FHD01](https://openairdocs.org/ntsb/NYC85FHD01.md): Piper Cherokee 140-C · Pennington, NJ · Accident · Minor injuries · Final report · Nov 24, 1984 · N5894U · Substantial damage > The plt & passg stated that the flt & approach to land seemed normal in all respects. They both have no recollection of the actual accident and only recall waking up in the ambulance. There are no witnesses of record to the accident. The groung evidence shows… - [NTSB MKC85LA026](https://openairdocs.org/ntsb/MKC85LA026.md): Cessna 150 · Van Buren, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1984 · N4561U · Destroyed > Plt stated that while on approach into setting sun, he failed to see a tree and the windsock tower due to sunglare, colliding with both before impact with the ground. The windsock was located 200 ft north of the rwy. Winds were calm and reciprocal rwy was… - [NTSB FTW85LA057](https://openairdocs.org/ntsb/FTW85LA057.md): Piper PA-38-112 · Newcastle, OK · Accident · No injuries · Limited investigation · Final report · Nov 24, 1984 · N2478B · Substantial damage > On simulated emerg landing, instructor evaluated approach as unsalvagable & at 1700 ft AGL told student to execute go-around. Student had allowed airspeed to decay in an effort to stretch glide. Student raised flaps & did not add pwr. As acft settled,… - [NTSB NYC85FHJ01](https://openairdocs.org/ntsb/NYC85FHJ01.md): Piper PA-28-140 · Hastings, NY · Accident · Serious injuries · Final report · Nov 23, 1984 · N32473 · Destroyed > Plt was occupying rt front seat, pax in left. Plt stated he noted eng oil press gage reading low and, recalling prior emerg lndg on golf course due oil starvation, elected precautionary lndg on golf course. Acft overshot intended approach. Plt initiated… - [NTSB CHI85LA055](https://openairdocs.org/ntsb/CHI85LA055.md): Beech E35 · Lagrange, IN · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 1984 · N3301C · Substantial damage > Plt was landing in gusty, crosswind conditions. On late final, a gust of wind caused the left wing to drop and strike the top of an 80 ft tree. Acft touched down nose low, collapsing the landing gear. - [NTSB ATL85LA042](https://openairdocs.org/ntsb/ATL85LA042.md): Cessna 150L · Murphy, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 1984 · N11916 · Substantial damage > The CFI and student plt initiated a go-around from a simulated forced landing when the eng failed to respond to the application of power. In order to avoid colliding with trees the CFI turned right towards a corn field. Ground impact occurred right wing low… - [NTSB FTW85LA056](https://openairdocs.org/ntsb/FTW85LA056.md): Cessna 172P · Pampa, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1984 · N54028 · Destroyed > Preflight weather briefing showed closest reporting station to destination below dest apch minimum of I mile visibility but fcst to improve to 1/2 mi by arrival. Area freezing level fcst at 3-4000 ft. flt to dest at 6000 ft was on top of clouds and… - [NTSB CHI85FEI01](https://openairdocs.org/ntsb/CHI85FEI01.md): Piper PA-32R-301T · Sandusky, OH · Accident · Serious injuries · Final report · Nov 19, 1984 · N8462U · Destroyed > The acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree… - [NTSB MKC85LA021](https://openairdocs.org/ntsb/MKC85LA021.md): Mooney M20J · Kirksville, MO · Accident · No injuries · Limited investigation · Final report · Nov 18, 1984 · N3955H · Substantial damage > According to the plt, during a localizer apch impact with an object was heard and the acft yawed left. The plt did not see what the acft hit but stated that he believed the acft struck a bird. Using a flashlight he attempted to inspect theacft in order to… - [NTSB NYC85FA029](https://openairdocs.org/ntsb/NYC85FA029.md): Piper PA-28-236 · Atlantic City, NJ · Accident · 4 fatal · Field investigation · Final report · Nov 17, 1984 · N2831Y · Destroyed > The aircraft was observed in close proximity to another aircraft in the traffic pattern. The pilot extended the downleg leg leg. During the turn to align the aircraft with the runway the pilot suffered a disabling heart attack. Unable to recover the aircraft… - [NTSB MIA85LA036](https://openairdocs.org/ntsb/MIA85LA036.md): Piper PA-11 · Parkland, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1984 · N5560H · Destroyed > The plt stated that as he approached the airstrip he flew his pattern low. As he turned base the wind caught the left wing shoving the acft down. He jammed the throttle forward but the acft crashed. - [NTSB CHI85LA052](https://openairdocs.org/ntsb/CHI85LA052.md): Beech A23 · Plato Center, IL · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N1407L · Substantial damage > On final approach with a 30-degree right crosswind of 14-16 KTS, the plt experienced a loss of headwind component as theacft passed below height of buildings in the windstream. Power was not added and the acft settled to the ground short of the runway… - [NTSB ATL85LA037](https://openairdocs.org/ntsb/ATL85LA037.md): Aero Commander 500 · Florence, SC · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1984 · N6268B · Substantial damage > The acft crashed short of the rwy after both engines lost power on the base leg. Th acft hit about 200 ft short of the rwy and slid through the fence onto the rwy destroying about 4 rwy lights. Investigation disclosed that the left fuel strainer drain was… - [NTSB ATL85LA034](https://openairdocs.org/ntsb/ATL85LA034.md): Piper PA-28R-201 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Nov 15, 1984 · N30001 · Substantial damage > The certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the… - [NTSB MIA85IA031](https://openairdocs.org/ntsb/MIA85IA031.md): Swearingen SA-226AT · Tallahassee, FL · Incident · No injuries · Incident investigation · Final report · Nov 14, 1984 · N31264 · Minor damage > N31264 crashed intentionally gear up on rwy 18 at Tallahassee, FL, while on a night, all cargo 14 CFR 135 flt. The crew attempted emergency gear extension procedures & a fly-by. Investigation revealed a broken wire, TS-70, where it connects with terminal 6.… - [NTSB ANC85FA016](https://openairdocs.org/ntsb/ANC85FA016.md): Cessna 180 · Chugiak, AK · Accident · No injuries · Field investigation · Final report · Nov 12, 1984 · N9433C · Substantial damage > Acft collided with trees aprx 2,600 ft short of rwy 19 threshold during the landing apch. The acft stopped 35-40 ft AGL in trees and after a few minutes fell to the ground. A descent was made from aprx 10,000 ft with a leaned mixture, closed throttle and no… - [NTSB NYC85LA041](https://openairdocs.org/ntsb/NYC85LA041.md): Mooney M20J · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N3515H · Substantial damage > Plt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time. - [NTSB NYC85FA025](https://openairdocs.org/ntsb/NYC85FA025.md): Cessna C337 · Taunton, MA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 1984 · N2327S · Minor damage > After departure & at an altitude of 2000 ft the plt noticed that the rear eng fuel flow was low, however, the eng was operating satisfactory. The plt, as a precaution, decided to return to the departure arpt. While returning the plt noted that there was no… - [NTSB MIA85FA029](https://openairdocs.org/ntsb/MIA85FA029.md): Gates Learjet 24F · St. Thomas · Accident · 2 fatal · Field investigation · Final report · Nov 10, 1984 · N81MC · Destroyed > While executing a night visual approach to runway 9 in visual meteorological conditions the aircraft was allowed to descend; crashing into water 2 miles short of the runway. The pilot was not familiar with the airport and failed to make use of a full… - [NTSB MKC85LA019](https://openairdocs.org/ntsb/MKC85LA019.md): Cessna R172E · Junction City, KS · Accident · No injuries · Limited investigation · Final report · Nov 9, 1984 · N13030 · Substantial damage > Pilot was experiencing communications difficulties, diverted from destination to nearby uncontrolled arpt due to traffic considerations. Plt was unable to contact UNICOM and elected to circle for traffic and wind evaluation. Best runway for wind direction was… - [NTSB NYC85LA023](https://openairdocs.org/ntsb/NYC85LA023.md): Beech BE-55E · Groton, CT · Accident · No injuries · Limited investigation · Final report · Nov 5, 1984 · N62561 · Substantial damage > As the acft broke out of the 300 overcast layer the plt saw birds flying off of the rwy threshold. Due to IFR conditions and low altitude the plt elected not to go around. The tower advised the plt of the birds on 2 mile final on the ILS apch. - [NTSB MIA85FA023](https://openairdocs.org/ntsb/MIA85FA023.md): Beech C23 · Crestview, FL · Accident · 2 fatal · Field investigation · Final report · Nov 4, 1984 · N9242S · Destroyed > During arrival, the plt was cleared for an ILS apch. The reported wx at that time was: 600 ft overcast, visibility 7 mi, wind 010 deg at 6 KTS. The plt stated that during the apch, he felt a downdraft that caused the acft to bank to the left & pitch down. The… - [NTSB FTW85FA037](https://openairdocs.org/ntsb/FTW85FA037.md): Cessna 182A · Mckinney, TX · Accident · Serious injuries · Field investigation · Final report · Nov 4, 1984 · N5176D · Substantial damage > The plt stated, he had departed the aero county airport, Mckinney, TX, on a local flt to drop sky divers. He dropped the sky divers & was returning to the arpt when he encountered a loss of eng power & made a forced landing. He stated that he pulled on… - [NTSB NYC85FA019](https://openairdocs.org/ntsb/NYC85FA019.md): Piper PA-28-140 · Beverly, MA · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1984 · N9930W · Destroyed > During an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going… - [NTSB FTW85LA033](https://openairdocs.org/ntsb/FTW85LA033.md): Stinson 108 · Sandia, TX · Accident · No injuries · Limited investigation · Final report · Oct 31, 1984 · N97476 · Substantial damage > The plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees… - [NTSB CHI85FA035](https://openairdocs.org/ntsb/CHI85FA035.md): Gulfstream 690C · Wooster, OH · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1984 · N2937A · Destroyed > While on final approach to rwy 09 the acft struck a 42 ft power pole with the right wing. The wing was torn from the acft. The acft landed inverted 400 ft east of the pole. The rwy threshold lights are displaced 165 ft from the rwy end for night operations.… - [NTSB MIA85LA020](https://openairdocs.org/ntsb/MIA85LA020.md): Aerospatiale SA-315-B · West Bay, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1984 · N49504 · Substantial damage > The acft crashed following a loss of tail rotor control while on an external load agricultural flt. Witnesses stated that during a landing attempt at a loading area the acft started spinning, the ext load was jettisoned, and the acft hit the ground and rolled… - [NTSB NYC85FA015](https://openairdocs.org/ntsb/NYC85FA015.md): Enstrom 280C · Butler, PA · Accident · 2 fatal · Field investigation · Final report · Oct 28, 1984 · N51686 · Destroyed > The helicopter struck the static line of a high voltage transmission line while on a flt to photograph an apartment complex. The owner of the complex accompanied the plt on the flt, there after the acft was to be used for passenger sightseeing flts as part of… - [NTSB LAX85LA034](https://openairdocs.org/ntsb/LAX85LA034.md): Cessna 152 · Firebird Lake, AZ · Accident · No injuries · Limited investigation · Final report · Oct 28, 1984 · N6470L · Substantial damage > The CFI reported that while flying in the flt school's designated practice area at 3800 ft MSL she reduced the throttle to idle for the purpose of simulating an in-flt emerg for her student. The student responded properly. The CFI stated she cleared the eng,… - [NTSB DEN85LA022](https://openairdocs.org/ntsb/DEN85LA022.md): Cessna R172K · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 1984 · N758CG · Substantial damage > The pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over. - [NTSB LAX85LUQ01](https://openairdocs.org/ntsb/LAX85LUQ01.md): Jack L. Bigham Bede 5B · Camarillo, CA · Accident · No injuries · Final report · Oct 27, 1984 · N721JB · Substantial damage > The plt was performing a go around when the prop drive failed. A forced landing was made on a soft fld adjacent to a taxiway during which the landing gear collapsed. Examination of the acft disclosed the prop drive belt laying in the fuselage. - [NTSB LAX85LA029](https://openairdocs.org/ntsb/LAX85LA029.md): Beech C24R · Montague, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N66342 · Substantial damage > The acft made a forced landing in a pasture and collided with a cow after the engine quit. The plt said he has noticed the landing gear in transit light come on at about 10 minute intervals during the flt. He said he had noticed a red fluid dripping from the… - [NTSB MKC85LA009](https://openairdocs.org/ntsb/MKC85LA009.md): Piper PA32RT-300T · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Oct 26, 1984 · N75DR · Substantial damage > The plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be… - [NTSB DEN85LA020](https://openairdocs.org/ntsb/DEN85LA020.md): Aerospatiale SA316B · Lima, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 1984 · N8624 · Substantial damage > Aprx 35 min prior to the accident the seismic operations being conducted about 10 mi NE were secured due to poor visibility and high winds. The plt estimated wind to have been from 180 deg at 40 KTS gusting to 60. As the plt approached the landing zone… - [NTSB MKC85LA005](https://openairdocs.org/ntsb/MKC85LA005.md): Beech A36 · North Platte, NE · Accident · No injuries · Limited investigation · Final report · Oct 25, 1984 · N1890L · Substantial damage > The plt stated that he had been using fuel from the rt wing fuel tank to compensate for a lateral imbalance during the flt. The fuel selector was on the rt tank when the eng failed. The plt said he switched tanks after the eng failed but was unable to restart… - [NTSB BFO85FA002](https://openairdocs.org/ntsb/BFO85FA002.md): Piper PA-32R-301 · Salisbury, MD · Accident · 4 fatal · Field investigation · Final report · Oct 25, 1984 · N81752 · Destroyed > After contacting millville fss 4 times for wx info the acft departed lincoln park, NY, at 1858 EDT with destination listed on the IFR flt plan as easton, MD. En route the plt diverted to Salisbury, MD, due to wx. After being cleared forthe rwy 32 ILS the acft… - [NTSB ATL85FA020](https://openairdocs.org/ntsb/ATL85FA020.md): Piper PA-22-108 · Vicksburg, MS · Accident · Serious injuries · Field investigation · Final report · Oct 25, 1984 · N4873Z · Destroyed > During preflt, plt detected water in fuel sample. After takeoff, the engine began to run roughly and on crosswind leg lost power completely. Plt stated that on approach to forced landing, he intentionally struck a tree with the left wing to slow the acft.… - [NTSB BFO85FA001](https://openairdocs.org/ntsb/BFO85FA001.md): Beech 58 · Hot Springs, VA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1984 · N777AB · Destroyed > The destn arpt was unattended at night & when the plt received his last wx briefing at 0519 CDT, no current wx info was available. During arrival, the acft was vectored for an ILS rwy 24 apch & the plt was advised that current wx info was still not available.… - [NTSB DEN85FA017](https://openairdocs.org/ntsb/DEN85FA017.md): Cessna 414 · Cheyenne, WY · Accident · Serious injuries · Field investigation · Final report · Oct 23, 1984 · N1569T · Substantial damage > The acft collided with the ground during a turn to final from a circling approach (IFR) at Cheyenne airport. According to ATC, the acft was a VFR 'pop up' & was subsequently issued an IFR clearance for an approach into the airport. Examination of the acft at… - [NTSB MIA85IA015](https://openairdocs.org/ntsb/MIA85IA015.md): MBB BO-105 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Oct 22, 1984 · N29144 · Minor damage > The purpose of the flt was to transport a 76 yr old patient, who was in critical condition. The flt was normal until it was on final apch to a 7th floor, rooftop, hospital heliport. During the apch, the plt attempted to increase the collective to slow the… - [NTSB LAX85LA028](https://openairdocs.org/ntsb/LAX85LA028.md): Cessna 172 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Oct 22, 1984 · N61739 · Substantial damage > Loss of pwr occurred on final apch. Acft contacted a dike during forced landing collapsing the nose gear. Plt said direct route was flown at 10,500 ft MSL descending lower after crossing mountainous area. Plt did not lean mixture during flt or report which… - [NTSB ANC85LA008](https://openairdocs.org/ntsb/ANC85LA008.md): Piper PA-12 · Theodore River, AK · Accident · No injuries · Limited investigation · Final report · Oct 19, 1984 · N78449 · Substantial damage > The acft crashed during a go-around attempt at Theodore River located 35 miles southwest of anchorage, AK. According to the plt, after landing on a gravel oil pad he realized that the acft would not stop before going over the edge into a swamp. He applied… - [NTSB LAX85FA024](https://openairdocs.org/ntsb/LAX85FA024.md): Cessna T207A · Sedona, AZ · Accident · No injuries · Field investigation · Final report · Oct 18, 1984 · N6262H · Destroyed > On final approach about 1.5 miles from the arpt the power loss occurred as the pilot attempted to add power. After flying over a ridge and several trees the acft touched down in the rough terrain and caught fire. The fire appeared to have started in the… - [NTSB DCA85IA003](https://openairdocs.org/ntsb/DCA85IA003.md): Boeing VC-137B-BN · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 18, 1984 · USAF · 2 aircraft · No damage > During arrival, a Boeing VC-137B-BN, USAF #58-6970, operating as air force 2 (AF-2), was cleared for a localizer back- course apch. At 1442:49, TRACON advised AF-2 of traffic at its 10 o'clock position at 2 mi, alt unkn. At 1443:11, TRACON advised AF-2 the… - [NTSB LAX85FA019](https://openairdocs.org/ntsb/LAX85FA019.md): Cessna 210 · San Pedro, CA · Accident · No injuries · Field investigation · Final report · Oct 16, 1984 · N7470E · Substantial damage > The acft was on a 3.5 mile final approach to torrence arpt when the pilot experienced an engine failure. The plt landed the acft the los angeles, west basin harbor. Examination of the engine and associated fuel lines after the accident revealed no evidence of… - [NTSB CHI85LA016](https://openairdocs.org/ntsb/CHI85LA016.md): Cessna 340 · Blue Earth, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 1984 · N5422M · Substantial damage > During arrival, the plt was cleared for a vor/dme apch to rwy 31. As he continued, he intercepted a 12 mi arc. He stated that when he applied power to level off at 2800 ft MSL & no power was available. He moved the mixtures to full rich, positioned the fuel… - [NTSB ANC85LA005](https://openairdocs.org/ntsb/ANC85LA005.md): Bellanca 7GCBC · Wasilla, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1984 · N1609G · Substantial damage > During final approach the acft struck an unmarked staic wire 40 ft AGL and more than 75 ft from intended touch down. The pilot lost control of the acft. The acft landed on a parked acft during the descent. - [NTSB NYC85LA009](https://openairdocs.org/ntsb/NYC85LA009.md): Aeronca 7AC · Ono, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1984 · N1069E · Substantial damage > After a lndg practice flight, solo student plt returned to home field at dusk. First lndg attempt resulted in overshoot and go-around. Since winds were calm, plt elected to land on reciprocal runway due to clear overrun area. This necessitated on obstacle… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=198 ## 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=197 --- 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.