# 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 183 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL86LA225](https://openairdocs.org/ntsb/ATL86LA225.md): Beech BE-19 · Ardmore, AL · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N285G · Substantial damage > During the landing attempt, the pilot elected to go-around after he realized that a safe landing could not be completed. During the go-around the acft settled to the rwy after the pilot retracted the flaps. The acft rolled off the departure end of the rwy at… - [NTSB BFO86LA041](https://openairdocs.org/ntsb/BFO86LA041.md): Bellanca Citabria · Pasadena, MD · Accident · No injuries · Limited investigation · Final report · Aug 23, 1986 · N41464 · Substantial damage > One witness who watched N41464 make the approach indicated that the aircraft appeared to be too fast as it passed the 1/2 way point on the runway and that it bounced back up into the air after nosing down onto the turf runway. The nose of the aircraft came up… - [NTSB LAX86LA327](https://openairdocs.org/ntsb/LAX86LA327.md): Cessna P210N · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1986 · N4831A · Substantial damage > The flight was a repositioning flight back to the aircraft's home base at the conclusion of an on demand air taxi flight. The pilot said that he departed without visually checking the fuel tank level. The pilot said the fuel gauges indicated one half tanks… - [NTSB CHI86LA210](https://openairdocs.org/ntsb/CHI86LA210.md): Piper PA-38-112 · Lodi, WI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1986 · N2430E · Substantial damage > During a practice emergency landing approach, the instructor told the student to go around at an altitude of about 600 feet AGL. The student failed to add power and pulled the yoke all the way back. The aircraft then stalled. The instructor took control,… - [NTSB MKC86LA172](https://openairdocs.org/ntsb/MKC86LA172.md): Aeronca 7AC · Republic, MO · Accident · No injuries · Limited investigation · Final report · Aug 17, 1986 · N84055 · Substantial damage > The pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is… - [NTSB MKC86FCD03](https://openairdocs.org/ntsb/MKC86FCD03.md): Roger Warnell KR-1 · Waterloo, IA · Accident · Serious injuries · Final report · Aug 17, 1986 · N49RW · Destroyed > The pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft. - [NTSB CHI86LA208](https://openairdocs.org/ntsb/CHI86LA208.md): Schleicher ASW-20 · Ionia, MI · Accident · No injuries · Limited investigation · Final report · Aug 17, 1986 · N12GH · Substantial damage > According to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient… - [NTSB BFO86FA042](https://openairdocs.org/ntsb/BFO86FA042.md): Piper PA-30 · Bowleys Qrtrs, MD · Accident · 3 fatal · Field investigation · Final report · Aug 17, 1986 · N31AB · Destroyed > Drg arr, TRACON gave the plt the arpt wx & provided vectors for an ILS rwy 32 apch. The plt inquired about a cell that he understood was over the arpt & was advised to standby while the controller (ctlr) checked on it. The ctlr contacted twr psnl who adzd the… - [NTSB FTW86LA149](https://openairdocs.org/ntsb/FTW86LA149.md): Cessna 210 · Tulsa, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 1986 · N9998Y · Substantial damage > The pilot was on an approach into Tulsa international airport when the engine began to surge after the landing gear had been lowered. The pilot informed the tower he thought he was experiencing fuel exhaustion. The aircraft landed 2,000 feet short of runway… - [NTSB SEA86LA206](https://openairdocs.org/ntsb/SEA86LA206.md): Cessna 340 · Prairie City, OR · Accident · No injuries · Limited investigation · Final report · Aug 13, 1986 · N2696U · Substantial damage > The plt was attempting to land the acft on an unlit airstrip during dusk conditions. While attempting to align the acft with the center of the 30 foot wide airstrip the plt heard the stall warning horn sounding. During an attempted go around an inadvertent… - [NTSB ATL86FA220](https://openairdocs.org/ntsb/ATL86FA220.md): Bellanca 14-19-3A · Toccoa, GA · Accident · Serious injuries · Field investigation · Final report · Aug 13, 1986 · N1297R · Destroyed > The plt checked on the acft the day prior to this flt and stated that he did not want it refueled. On the day of the flt he was observed draining fuel from the acft. He air filed an IFR flt plan and stated that he had 3 hrs and 45 mins of fuel and his en… - [NTSB MIA86LA231](https://openairdocs.org/ntsb/MIA86LA231.md): Piper PA24-180 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Aug 11, 1986 · N55UA · Substantial damage > Plt was unable to completely extend landing gear via electric and manual means. A landing was made with gear partially extended. Examination of the aircraft after the accident revealed the landing gear extention mechanism was binding in the manual extention… - [NTSB LAX86LA318](https://openairdocs.org/ntsb/LAX86LA318.md): Glasflugel Standard Libelle · Markleville, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1986 · N7190 · Substantial damage > The pilot of the glass fugel glider reported no malfunctions with the airplane prior to the crash after attempting a circle to land maneuver. The pilot indicated he misjudged his altitude with the up hill sloping runway. During the circling maneuver he forgot… - [NTSB NYC86LA205](https://openairdocs.org/ntsb/NYC86LA205.md): Cessna T-210 · Spring Valley, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1986 · N4879U · Substantial damage > The pilot took off in the Cessna T-210N with 3 passengers. The landing gear would not retract, so he returned for landing. Just prior to touchdown, the aircraft dropped and bounced. The pilot initiated a go-around and the aircraft bounced once more lightly.… - [NTSB FTW86LRA12](https://openairdocs.org/ntsb/FTW86LRA12.md): Molino PIK-20B · College Station, TX · Accident · No injuries · Final report · Aug 9, 1986 · N20EK · Substantial damage > The glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area. - [NTSB DEN86LA226](https://openairdocs.org/ntsb/DEN86LA226.md): Schweizer SGS 2-33A · Durango, CO · Accident · No injuries · Limited investigation · Final report · Aug 9, 1986 · N7590 · Substantial damage > The plt was attempting to land his glider. He said that he was unable to reach the airport and elected to land in a nearby pasture. Prior to touchdown he discovered some cattle in the field but was unable to avoid a collision with one of the animals. The… - [NTSB DEN86LA228](https://openairdocs.org/ntsb/DEN86LA228.md): E. E. Schilling Q-2 · Billings, MT · Accident · No injuries · Limited investigation · Final report · Aug 8, 1986 · N21QQ · Substantial damage > Plt stated after accident that he had a minor eng problem prior to departure from big timber. He stated that the problem was corrected and the flight commenced to Billings. While on final approach to rwy 04 at Billings the plt experienced a partial loss of… - [NTSB DEN86LA224](https://openairdocs.org/ntsb/DEN86LA224.md): Piper PA-24-260 · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Aug 8, 1986 · N8544P · Substantial damage > The plt was on an approach for landing when the acft began to settle. He said that increasing power did not seem to have an effect. Subsequently, the acft landed hard, collapsing the nose gear. The plt believed that he had encountered wind shear during the… - [NTSB ATL86LA221](https://openairdocs.org/ntsb/ATL86LA221.md): Temco GC-1B · Bowling Green, KY · Accident · No injuries · Limited investigation · Final report · Aug 8, 1986 · N78261 · Substantial damage > Plt reported that he failed to reposition the fuel selector from auxillary fuel tank to main fuel tank during the landing check. Engine quit due to fuel starvation on short final approach at too low an altitude for corrective action. - [NTSB SEA86LA196](https://openairdocs.org/ntsb/SEA86LA196.md): Cessna 210 · Stibnite, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1986 · N7459E · Destroyed > The pilot executed a steep, reduced power descent into the destination airstrip. He then reported that when he attempted to reduce the rate of descent with a power application, the engine did not respond. There was no evidence of any mechanical malfunction… - [NTSB FTW86FRG30](https://openairdocs.org/ntsb/FTW86FRG30.md): Schleicher ASW-20 · Uvalde, TX · Accident · Serious injuries · Final report · Aug 4, 1986 · N20TS · Destroyed > Acft was competing in the natl soaring championships and had just crossed the finish line at 50' AGL and 85 kns a/s when it entered a maneuver to reverse direction and climb to pattern alt for landing. During the turn the acft stalled and struck a power line… - [NTSB MIA86LA226](https://openairdocs.org/ntsb/MIA86LA226.md): Cessna 152 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N914DF · Destroyed > The acft had been in the air for about 1 hr & was aprching the arpt. While on final aprch, the eng quit & the plt radioed 'mayday,mayday,fuel exhaustion' & ditched the acft in the water. The CFI plt stated that he checked the fuel supply by looking at the… - [NTSB SEA86LA197](https://openairdocs.org/ntsb/SEA86LA197.md): Schempp-Hirth Nimbus Iiit · Hawthorne, NV · Accident · No injuries · Limited investigation · Final report · Jul 30, 1986 · N141V · Substantial damage > After a 5 hour flight in the motorized glider during which the engine was utilized on several occasions the pilot returned to his destination. Upon arrival he executed a number of low passes over the runway for photographers. The pilot executed a fly by… - [NTSB SEA86LA160](https://openairdocs.org/ntsb/SEA86LA160.md): Cessna 172G · Carson City, NV · Accident · No injuries · Limited investigation · Final report · Jul 30, 1986 · N41041 · Substantial damage > The plt stated a dust devil was encountered during final approach. He then added full power, but neglected to lower the nose of the acft. A full stall occurred and recovery was not possible due to the low altitude. The acft then struck the ground, nose first,… - [NTSB NYC86FGM06](https://openairdocs.org/ntsb/NYC86FGM06.md): Kenneth Patsch FLY Baby II · Franklin Center, PA · Accident · 1 fatal · Final report · Jul 28, 1986 · N14OP · Destroyed > The plt reported that the acft banked excessively during the left turn from base to final. Opposite control input was applied, however, the plt reported the 'stick seemed to have no right movement.' Full power was applied but the bank steepened so power was… - [NTSB ATL86FA212](https://openairdocs.org/ntsb/ATL86FA212.md): Cessna 172 · Bridgeport, WV · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1986 · N96701 · Destroyed > The aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi… - [NTSB SEA86LA180](https://openairdocs.org/ntsb/SEA86LA180.md): Cessna 140A · Colville, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1986 · N9425A · Substantial damage > While making a power off approach to simulate a forced landing an over shoot was assured. The plt added pwr and the engine ceased operating. In order to avoid trees at the end of the runway the pilot made a 90 degree turn to land in a plowed field. The acft… - [NTSB LAX86LA305](https://openairdocs.org/ntsb/LAX86LA305.md): Navion A · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N111T · Substantial damage > A Navion a landed hard on rwy 01 after an attempted go-around. The plt indicated that he was landing to the north with full flaps and discovered he had a gusting tailwind. He initiated a go-around and at 50 ft AGL he brought the flaps up halfway. The acft… - [NTSB ATL86LA210](https://openairdocs.org/ntsb/ATL86LA210.md): Bellanca 8KCAB · Huntersville, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1986 · N7689S · Substantial damage > Plt was practicing touch-and-go and emer proc. He was high on base and attempted to correct alt, struck a ditch 200 feet short of the rwy with rt ldg gear. Acft came to a stop 100 feet short of rwy in second grass filled ditch. - [NTSB ANC86LA109](https://openairdocs.org/ntsb/ANC86LA109.md): Piper PA-22 · Umiat, AK · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N3366Z · Substantial damage > Pilot stated the engine quit due to fuel exhaustion during final approach, forcing him to land on a short unsuitable gravel bar. Aircraft nosed over upon landing and came to rest in 10 feet of water. - [NTSB MKC86LA160](https://openairdocs.org/ntsb/MKC86LA160.md): Huizenga SEA Hawk · Clinton, IA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N85CK · Substantial damage > During a test flt of an experimental sea plane, the plt rptd a loss of eng pwr during a turn in the traffic pattern at Clinton airport. The plt stated he had 5 gallons of fuel onboard and had flown about 2 tenths of an hour. Inspection of the fuel system… - [NTSB SEA86LA209](https://openairdocs.org/ntsb/SEA86LA209.md): Let L-13 · Issaquah, WA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1986 · N65141 · Substantial damage > Plt undershot approach after encountering downdraft, collided with perimeter fence. - [NTSB ATL86LA207](https://openairdocs.org/ntsb/ATL86LA207.md): Piper PA-34-200T · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1986 · N2952D · Substantial damage > The plt received a wx briefing prior to takeoff which forecasted widely scattered thunderstorms. On arrival at destination a thunderstorm was over the arpt. The plt executed an ILS rwy 14 apch. A preceding DC-9 made a missed approach due to tower reported… - [NTSB NYC86DNC06](https://openairdocs.org/ntsb/NYC86DNC06.md): Hansen Hawk 304 · Wolfeboro, NH · Accident · Minor injuries · Final report · Jul 22, 1986 · N13CH · Substantial damage > The experimental aircraft equipped with a buick V-8 aluminum block engine experienced power loss on approach for landing. The pilot decided that the distance and terrain was too great for a glide to the airport, and an emergency water landing in a nearby lake… - [NTSB MKC86LA154](https://openairdocs.org/ntsb/MKC86LA154.md): Piper PA-23-250T · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N62719 · Substantial damage > A fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to… - [NTSB NYC86LA186](https://openairdocs.org/ntsb/NYC86LA186.md): Mooney M20F · West Milford, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1986 · N7040V · Destroyed > Drg the landing roll, the plt believed there was insufficient braking, so he initiated a go-around. He rprtd that on climb-out, the tail of the acft impacted a 'hill.' The acft then crashed nose down & was destroyed. No preimpact part failure or malfunction… - [NTSB LAX86LA296](https://openairdocs.org/ntsb/LAX86LA296.md): Glasflugel ST Libelle · Vacaville, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 1986 · N74162 · Substantial damage > According to witnesses the sailplane was too low on the landing appraoch and in an attempt to stretch the glide the pilot stalled the sailplane and entered a spin prior to contact with the ground. - [NTSB MIA86IA213](https://openairdocs.org/ntsb/MIA86IA213.md): Boeing 727-225 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jul 19, 1986 · N8872Z · Minor damage > Flt was unable to extend nose gear and a nose gear up landing was made. Investigation revealed the nose gear drag brace to be locked in the up position. Disassembly of the drag brace revealed the link assemblies which connect the locking pawls to the locking… - [NTSB LAX86MA309](https://openairdocs.org/ntsb/LAX86MA309.md): Aerospatiale AS-355F-1 · Morgan City, LA · Accident · No injuries · Major investigation · Final report · Jul 18, 1986 · N57967 · Destroyed > The plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The… - [NTSB CHI86LA173](https://openairdocs.org/ntsb/CHI86LA173.md): Lake LA-250 · Frankfort, MI · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N1402X · Destroyed > The plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting… - [NTSB SEA86LA171](https://openairdocs.org/ntsb/SEA86LA171.md): Cessna A185F · Ketchikan, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1986 · N6336E · Destroyed > The plt was attempting to land when the engine ceased operating as the throttle was advanced. Subsequently, the acft struck an embankment short of the runway. The plt had selected the right fuel tank, although the normal procedures in the operating manual… - [NTSB CHI86FA172](https://openairdocs.org/ntsb/CHI86FA172.md): Cessna 441 · Norton Shores, MI · Accident · 3 fatal · Field investigation · Final report · Jul 16, 1986 · N6857E · Destroyed > N6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from… - [NTSB CHI86FA171](https://openairdocs.org/ntsb/CHI86FA171.md): Aero Commander 100 · Crivitz, WI · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1986 · N3667X · Destroyed > Following one approach to land under conditions of low visibility (less than 1/4 mile) the pilot attempted to land again. On base leg, according to witnesses, the aircraft fell to the ground. In the wreckage the stall warning light bulb filament was grossly… - [NTSB ANC86LA108](https://openairdocs.org/ntsb/ANC86LA108.md): Cessna 170B · Blackburn, AK · Accident · No injuries · Limited investigation · Final report · Jul 15, 1986 · N4649C · Substantial damage > Acft undershot apch and crashed into a river while executing a low circling apch to land at a nearby gravel bar. Plt stated that he had been on duty for about 18 hrs, had flown 8.4 hrs that day hauling fish and that he was tired and 'playing around'. Acft… - [NTSB LAX86FA288](https://openairdocs.org/ntsb/LAX86FA288.md): Cessna T210N · Bullhead City, AZ · Accident · 6 fatal · Field investigation · Final report · Jul 13, 1986 · N5534Y · Destroyed > The private pilot, who had accumulated approximately 450 hours of flight experience and his 5 passengers, arrived at the destination airport during darkness. This was the pilot's first landing at the uncontrolled airport and he was not familiar with the… - [NTSB CHI86LA169](https://openairdocs.org/ntsb/CHI86LA169.md): Piper PA-28R-201 · Benson, MN · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N3731T · Substantial damage > The pilot reported that he ran the right fuel tank dry before switching to the left tank in cruise flight. On final approach for a landing the engine began to falter and quit running shortly thereafter. The aircraft was landed short of the runway gear up in… - [NTSB ATL86LA204](https://openairdocs.org/ntsb/ATL86LA204.md): Cessna C-152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N6521B · Substantial damage > The acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a… - [NTSB DEN86LA199](https://openairdocs.org/ntsb/DEN86LA199.md): Schleicher ASW-20 · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N13JR · Substantial damage > The plt was participating in a soaring competion meet. While on the return portion of the flt, the plt encountered an area of insufficient lift & was unable to reach the arpt. During an off arpt landing, the left wing of the glider struck a mesquite bush &… - [NTSB DEN86LA195](https://openairdocs.org/ntsb/DEN86LA195.md): Cessna 320C · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N3030T · Substantial damage > The plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond… - [NTSB SEA86FA165](https://openairdocs.org/ntsb/SEA86FA165.md): Thorp T-18 · Richland, WA · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1986 · N2056 · Destroyed > At time of mishap, acft presumed to be in rt-hand approach to land in 20-KT, 40 degree rt crosswind. Witnesses first observed acft descending vertically, out of control, in an area consistent with the 90 degree approach position. Evidence indicates acft… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=184 ## 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=183 --- 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.