# 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 204 of 420 · 20,992 cases ## Cases, newest first - [NTSB MKC84FA084](https://openairdocs.org/ntsb/MKC84FA084.md): Piper PA-31P · El Dorado, AR · Accident · 1 fatal · Field investigation · Final report · Feb 26, 1984 · N33BP · Destroyed > The acft crashed into trees 2 miles short of the rwy during an instrument approach in IMC weather. A plt in the right front seat said that just prior to impact, the acft was descending at 2500 fpm, & when he looked ahead, he saw trees. Hesaid he yelled at the… - [NTSB ATL84LA109](https://openairdocs.org/ntsb/ATL84LA109.md): Cessna 172M · Alma, GA · Accident · No injuries · Limited investigation · Final report · Feb 26, 1984 · N23JT · Substantial damage > The plt was on downwind and reduced power,he stated,before application of carburetor heat. The engine lost RPM and when the plt tried to regain RPM. The engine stopped. The plt said he tried to restart but failed and then made a forced off arpt landing. The… - [NTSB ATL84LA108](https://openairdocs.org/ntsb/ATL84LA108.md): Piper PA-24-250 · Walterboro, SC · Accident · No injuries · Limited investigation · Final report · Feb 26, 1984 · N6720P · Substantial damage > The plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The… - [NTSB NYC84FA092](https://openairdocs.org/ntsb/NYC84FA092.md): Cessna 425 · Dryden, NY · Accident · Minor injuries · Field investigation · Final report · Feb 25, 1984 · N6886D · Destroyed > The plt stated that he was utilizing the autopilot and flt director to execute the ILS appch to rwy 32. The autopilot was tracking the localizer while the pilot controlled the rate of descent along the glideslope with pitch command wheel on the autopilot,… - [NTSB CHI84FA118](https://openairdocs.org/ntsb/CHI84FA118.md): Cessna 310K · Monticello, IN · Accident · 2 fatal · Field investigation · Final report · Feb 25, 1984 · N3805X · Destroyed > After taking off, the acft was observed to climb to about 400 ft AGL, then enter a steep left bank. The acft then leveled off & rolled out on a downwind that was angling toward the rwy. On downwind, the aircrew transmitted that they were 'coming back.'… - [NTSB NYC84FA090](https://openairdocs.org/ntsb/NYC84FA090.md): Beech 76 · Beverly, MA · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1984 · N60132 · Destroyed > A commercially rated plt (student) was receiving multi-eng training from an instructor plt (CFI). The student stated that on final apch to landing, he noticed the airspeed was slow when the CFI shut down the right eng by using the mixture control. The acft… - [NTSB CHI84IA114](https://openairdocs.org/ntsb/CHI84IA114.md): Beech 99 · Champaign, IL · Incident · No injuries · Incident investigation · Final report · Feb 22, 1984 · N313BA · Minor damage > The plt reported that during arrival to the destination arpt, he heard a loud bang & the acft began rolling to the right. He reported that he was unable to control the roll with the ailerons, so he reduced power on the left eng & applied left rudder. The crew… - [NTSB MKC84LA081](https://openairdocs.org/ntsb/MKC84LA081.md): Cessna 172 · Mountain View, AR · Accident · No injuries · Limited investigation · Final report · Feb 21, 1984 · N3826L · Substantial damage > The acft collided with trees during a forced landing after the engine lost power. The plt had taken off for a x-country without full fuel tanks. After the accident a mechanic found no useable fuel aboard the acft. - [NTSB SEA84FA058](https://openairdocs.org/ntsb/SEA84FA058.md): Piper PA-28-J3A5D · Mountaindale, OR · Accident · 3 fatal · Field investigation · Final report · Feb 20, 1984 · N83382 · Destroyed > The acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of… - [NTSB LAX84LA185](https://openairdocs.org/ntsb/LAX84LA185.md): Cessna 310 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N667R · Substantial damage > The acft was for sale & the plt, who represented himself as being qualified to fly it, was performing a pre-purchase flt. He reported that he initially felt uncomfortable flying this acft although he had prevously owned a Cessna 310. He was unfamiliar with… - [NTSB LAX84FA183](https://openairdocs.org/ntsb/LAX84FA183.md): Beech A36 · Santa Monica, CA · Accident · No injuries · Field investigation · Final report · Feb 19, 1984 · N9876T · Substantial damage > The plt stated that after takeoff, the electrical sys failed as he retracted the gear. He elected to return to the arpt & land. Shortly thereafter, the eng lost power. He further stated that he hand cranked the gear to the down position & received a light… - [NTSB DEN84LA094](https://openairdocs.org/ntsb/DEN84LA094.md): Weatherly 201B · Townsend, MT · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N1264W · Substantial damage > The acft engine lost power on the base leg when the plt retarded the throttle. The plt landed on the rwy, but the acft started to veer to the right. The plt said he applied the brakes which did not seem to operate. Later, he said he may have had his feet on… - [NTSB ATL84MA101](https://openairdocs.org/ntsb/ATL84MA101.md): Beech V35B · Charlottesville, VA · Accident · 4 fatal · Major investigation · Final report · Feb 17, 1984 · N9353Q · Destroyed > While proceeding on an IFR flt plan, the plt requested he be assigned an alt below 8000 ft due to 'a passenger with an ear problem.' Otherwise, the en route portion of the flt proceeded without incident. During arrival, the plt was cleared for an ILS apch to… - [NTSB FTW84LA142](https://openairdocs.org/ntsb/FTW84LA142.md): Cessna 152 · Acuff, TX · Accident · No injuries · Limited investigation · Final report · Feb 16, 1984 · N49126 · Substantial damage > The CFI simulated an engine failure during flt at about 1000 ft AGL. When throttle was advanced the engine did not respond. The CFI made a forced landing in a plowed field and the acft nosed over in the soft furrowed dirt. An exam revealed no eng problems,… - [NTSB NYC84FGM02](https://openairdocs.org/ntsb/NYC84FGM02.md): Cessna 172P · New Castle, PA · Accident · Minor injuries · Final report · Feb 15, 1984 · N64666 · Substantial damage > The flt tookoff to practice touch and go landings with about 1/4 tank of fuel showing on the gauges. After bout 15 minutes of flt and one touch and go landing the plt turned to final approach and the engine quit. A forced landing was made 1 mile off the arpt.… - [NTSB MKC84FA077](https://openairdocs.org/ntsb/MKC84FA077.md): Cessna 414A · Mena, AR · Accident · 2 fatal · Field investigation · Final report · Feb 15, 1984 · N6815Z · Substantial damage > Acft cleared for Mena NDB apch and to maintain 5000 ft MSL until established on the apch. Acft descended to 4800 ft MSL on aprx grnd track of 040 to 030 deg after NDB passage. Acft then turned to a ground track of 116 deg. After 12 seconds the acft turned to… - [NTSB ATL84LA096](https://openairdocs.org/ntsb/ATL84LA096.md): Piper PA-28-140 · Oak Grove, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1984 · N5546F · Destroyed > The acft collided with trees during an approach to land in IMC weather. The plt had taken off about 10 minutes earlier and when fog rolled in he tried to land. After one go-around he made a 2nd approach and descended to 75 ft AGL to obtainbetter visibility… - [NTSB MIA84IA074](https://openairdocs.org/ntsb/MIA84IA074.md): Beech 95-A55 · Opa Locka, FL · Incident · No injuries · Incident investigation · Final report · Feb 11, 1984 · N9707Y · Minor damage > The acft was intentionally landed with the landing gear retracted when the lt main gear could not be extended. Inspection of the acft revealed that the spring which pulls the lt main gear uplock out of the way when released had become disconnected from the… - [NTSB DEN84LA090](https://openairdocs.org/ntsb/DEN84LA090.md): Piper PA-22-150 · Laramie, WY · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1984 · N7519D · Substantial damage > The plt stated that when he was 10 miles southeast with airport lights in sight, a convair plt reported inbound on an IFR clearance to land. Not wanting to possibly cause the convair plt to make a missed approach he elected to make a turn. In the turn, he… - [NTSB DEN84FA089](https://openairdocs.org/ntsb/DEN84FA089.md): Beech 58P · Durango, CO · Accident · 2 fatal · Field investigation · Final report · Feb 11, 1984 · N6400E · Destroyed > When the plt called the fss at 1341 MST, he stated he had already received some 'real time' wx & requested only the wx at Durango & farmington, NM. He filed an IFR flt plan to Durango & took off at 1437. Drg arrival, the plt attempted to get into VFR… - [NTSB NYC84LA139](https://openairdocs.org/ntsb/NYC84LA139.md): Balloon Works Fire FLY 6B · Butler, PA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N3738H · Substantial damage > During a descent to land, the plt of a Balloon tried to level off to reach a desired touch down point. The plt added heat, but the Balloon continued to descend. After a hard bounced landing, the Balloon began to ascend, but it collided with tree limbs & was… - [NTSB CHI84LA104](https://openairdocs.org/ntsb/CHI84LA104.md): Bryan Dragon FLY · Vanolia, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1984 · N1711D · Destroyed > The plt stated that after takeoff, while on downwind, the eng failed. He attempted to land back on the runway when the left wing struck the ground. The acft then struck a 55 gal concrete drum and a chain link fence. Examination of the acftrevealed that a… - [NTSB LAX84LA166](https://openairdocs.org/ntsb/LAX84LA166.md): Cessna 150M · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Feb 5, 1984 · N3189V · Substantial damage > The plt said he was doing a precautionary landing because he heard a 'pop' during a practice spin. During the landing the wing of the acft struck a tree. The acft was successfully flown back to the arpt and landed without further incident. - [NTSB LAX84LA165](https://openairdocs.org/ntsb/LAX84LA165.md): Cessna 180J · Hayward, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 1984 · N52034 · Substantial damage > During arrival, the plt had descended to stay below the tca & was approaching his destination when the eng lost power. He turned back toward the Hayward arpt, but was unable to reach it or restart the eng. During a forced landing at night, the acft was… - [NTSB MKC84LA070](https://openairdocs.org/ntsb/MKC84LA070.md): Cessna 182 · Derby, KS · Accident · No injuries · Limited investigation · Final report · Feb 4, 1984 · N6466A · Substantial damage > During an apch from the south in gusty wind conditions, the acft crossed over wires & shrubbery with 20 deg of flaps. The plt reported that before reaching the rwy, the'lost air & descended straight down.' The acft touched down in mud, short of the rwy. The… - [NTSB MIA84FA072](https://openairdocs.org/ntsb/MIA84FA072.md): Piper PA-22-150 · Hoboken, GA · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1984 · N8771D · Destroyed > While on base leg for landing, the forward right wing strut failed causing the right wing to separate. The acft then entered an uncontrolled descent & crashed. The non-certificated plt owned the acft. He had not complied with airworthiness directive 77-03-08.… - [NTSB LAX84FA164](https://openairdocs.org/ntsb/LAX84FA164.md): Piper PA-38-112 · Fullerton, CA · Accident · No injuries · Field investigation · Final report · Feb 4, 1984 · N91522 · Substantial damage > The acft engine lost power during a go around following a long power-off glide during which carburetor heat was not used. During the forced landing in a soft cultivated field the acft nose wheel' dug in' and the acft nosed over. The weatherreport indicated… - [NTSB CHI84LA102](https://openairdocs.org/ntsb/CHI84LA102.md): Piper Aerostar 602P · Bellaire, MI · Accident · No injuries · Limited investigation · Final report · Feb 3, 1984 · N6895D · Substantial damage > During the flare round out, 100 ft from the rwy at 10 ft AGL the acft stalled at 100 KIAS. Aprx 1/8 inch of ice was present on the airfoils. Moderate rhime ice was reported in the clouds along the route of flight. The plt did not activate the de-ice boots… - [NTSB CHI84LA101](https://openairdocs.org/ntsb/CHI84LA101.md): Piper PA38-112 · Lacon, IL · Accident · No injuries · Limited investigation · Final report · Feb 1, 1984 · N91469 · Substantial damage > The plt was ferrying the acft to the Lacon arpt for winter storage. On final apch she touched down short & struck a snow bank on the apch end of the rwy. The plt stated that difficulty in depth perception due to the snow covered terrain resulted in touchdown… - [NTSB ATL84FA088](https://openairdocs.org/ntsb/ATL84FA088.md): Cessna P210N · Greensboro, NC · Accident · 2 fatal · Field investigation · Final report · Jan 30, 1984 · N4447F · Destroyed > During arrival, the plt was advised that the arpt wx had just changed to IFR. He was assigned an alt (2900 ft MSL) & provided a vector for an ILS apch. Shortly thereafter, the plt advised that he was 'having motor difficulty & needed to come straight-in.' He… - [NTSB CHI84LA094](https://openairdocs.org/ntsb/CHI84LA094.md): Piper PA-32R-300 · Greenville, IL · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1984 · N76AP · Substantial damage > The plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines. - [NTSB ATL84IA087](https://openairdocs.org/ntsb/ATL84IA087.md): British Aerospace 1-11 · Richmond, VA · Incident · No injuries · Incident investigation · Final report · Jan 26, 1984 · N1113J · No damage > Flt 498, experienced a partial power loss on one eng during the final approach. Both plts stated that the eng spool down occurred moments after selecting tcc(top temp control). A eng runup of the acft failed to repeat the discrepancy & a precautionary change… - [NTSB NYC84FA074](https://openairdocs.org/ntsb/NYC84FA074.md): Cessna P210N · Groton, CT · Accident · 3 fatal · Field investigation · Final report · Jan 25, 1984 · N900FE · Destroyed > The acft was blown off course during a procedure turn for an ILS approach. The plt made a missed approach because of themisalignment and tried a non standard means of orientation for the 2nd attempt and intercepted the middle marker unexpectedly. Radar shows… - [NTSB MKC84LA065](https://openairdocs.org/ntsb/MKC84LA065.md): Cessna 172 · Kennett, MO · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1984 · N78FR · Destroyed > The acft crashed in IMC weather after the engine lost power due to fuel exhaustion. The plt had received a briefing on the weather prior to departure. Post accident investigation revealed less than 2 gallons of fuel remained aboard the acft. - [NTSB ATL84FLT02](https://openairdocs.org/ntsb/ATL84FLT02.md): Piper PA-22-150 · Memphis, TN · Accident · Serious injuries · Final report · Jan 25, 1984 · N46RS · Substantial damage > The acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop… - [NTSB CHI84LA092](https://openairdocs.org/ntsb/CHI84LA092.md): Beech B-19 · Crystal Lake, IL · Accident · No injuries · Limited investigation · Final report · Jan 22, 1984 · N173S · Substantial damage > The acft hit a snow bank during an approach for landing. The plt added power and made a go-around. The CFI took control of the acft and made the final landing when the main landing gear collapsed. - [NTSB CHI84LA088](https://openairdocs.org/ntsb/CHI84LA088.md): Piper PA-38-112 · Holman, WI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1984 · N9555T · Substantial damage > After flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of… - [NTSB CHI84LA087](https://openairdocs.org/ntsb/CHI84LA087.md): Cessna 150L · Rock Falls, IL · Accident · No injuries · Limited investigation · Final report · Jan 18, 1984 · N10502 · Substantial damage > The instructor plt stated that the student plt was flying the aircraft. While on final approach he advised the student plt to add engine power. The student did so very rapidly causing the engine to stall. Before the engine could be restarted the aircraft… - [NTSB ATL84FA084](https://openairdocs.org/ntsb/ATL84FA084.md): Rockwell 690B · Greenville, SC · Accident · 4 fatal · Field investigation · Final report · Jan 17, 1984 · N81717 · Destroyed > As the plt was making an ILS approach in IMC weather, the acft descended into trees & crashed about 1-1/2 mi from the rwy threshold. The descision height for this approach was 1316 ft MSL & was located less than a mile from the threshold.a controller said… - [NTSB ATL84FA083](https://openairdocs.org/ntsb/ATL84FA083.md): Piper PA-32RT-300 · Attalla, AL · Accident · 2 fatal · Field investigation · Final report · Jan 16, 1984 · N31844 · Destroyed > During a VOR approach to land in IMC wx, the acft collided with a tree. The non-instrument rated plt had filed an IFR flt plan on this and other occasions even though he was not qualified. During this approach, the descent was continued past the mda of 960… - [NTSB MIA84LA059](https://openairdocs.org/ntsb/MIA84LA059.md): Cessna 411A · Gainsville, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1984 · N4500Q · Destroyed > The acft crashed while on a ILS approach to the Gainsville, airport. Investigation revealed that the plt had advised approach control that he was 'low on fuel.' After two missed approaches the plt radioed that he was 'out of fuel.' The plt did not have charts… - [NTSB LAX84IA153](https://openairdocs.org/ntsb/LAX84IA153.md): Mcdonnell Douglas DC-9-30 · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · Jan 10, 1984 · XAAMF · No damage > An aeromexico DC-9 encountered wake turbulence from a twa L-1011 on the approach to rwy 24L. The aeromexico acft was 6 miles (1 min & 10 sec) behind the twa acft & 800 ft below its glideslope at 6100 ft when the incident occurred. - [NTSB DEN84LA069](https://openairdocs.org/ntsb/DEN84LA069.md): Cessna 182J · Alamosa, CO · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1984 · N3344F · Substantial damage > The plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft… - [NTSB CHI84LA082](https://openairdocs.org/ntsb/CHI84LA082.md): Beech BE-33A · Crystal, MN · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1984 · N32637 · Substantial damage > The acft collided with trees and a residence near the destination airport after experiencing a total non-mechanical loss of power resulting from fuel starvation. The pilot reported he had estimated the fuel on board by a visual inspection of the tanks. This… - [NTSB MIA84LA057](https://openairdocs.org/ntsb/MIA84LA057.md): Schweizer 2-33A · Eustis, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 1984 · N2521H · Destroyed > The plt stated that she attempted to make a low downwind turn to final from approximately 300 ft AGL and the acft encountered a roll effect over some pine trees on the west side of the rwy. The left wing tip struck the ground and pulled the nose into the… - [NTSB ANC84LA029](https://openairdocs.org/ntsb/ANC84LA029.md): Cessna 172RG · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · N4856V · Substantial damage > The dual student and instructor were practicing emergency procedures. During the turn onto final approach the left main landing gear and left wing struck a snowbank. Flying club procedures state that no emergency practice procedure will be conducted below 500… - [NTSB DEN84FA065](https://openairdocs.org/ntsb/DEN84FA065.md): Cessna 320C · Provo, UT · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1984 · N3037T · Destroyed > The acft had been cleared for an ILS rwy 13 apch. A witness, located just north of the rwy, saw an acft pass overhead & stated that the acft was not an a correct apch. The acft then began heading west as if to circle for a 2nd apch. The witness also estimated… - [NTSB SEA84IA033](https://openairdocs.org/ntsb/SEA84IA033.md): Boeing B-727-90C · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jan 5, 1984 · N766AS · Minor damage > The acft struck the approach lights to rwy 16R while on an ILS approach. Analysis of the FDR readout showed an increased descent rate following visual sighting of the rwy environment. - [NTSB LAX84LA133](https://openairdocs.org/ntsb/LAX84LA133.md): Cessna 150 · Sedona, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1984 · N8300G · Substantial damage > The acft landed short of the rwy during an emergency landing. The plt said the acft ran out of fuel about 1 mile from the arpt at 6200 ft MSL. He said he miscalculated the fuel consumption due to head winds. - [NTSB NYC84IA066](https://openairdocs.org/ntsb/NYC84IA066.md): Lockheed 1329-25 · Teterboro, NJ · Incident · No injuries · Incident investigation · Final report · Jan 2, 1984 · N322CS · Minor damage > N322CS landed with the left main landing gear partially extended after emergency gear extention procedures failed. Investigation revealed the left actuator cover door & strut cover doors jammed where the two pass in close proximity during the gear extention… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=205 ## 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=204 --- 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.