# 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 182 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL87FA004](https://openairdocs.org/ntsb/ATL87FA004.md): Beech A-23-24 · Meldrim, GA · Accident · Serious injuries · Field investigation · Final report · Oct 11, 1986 · N60BL · Substantial damage > The pilot flight planned a total time enroute of 2HRS. 45 min. The aircraft fuel endurance was four hours. The pilot used about 1 hr. 15 min. Attempting to complete an instrument procedure. Sav was VFR throughout the entire flight and prior to the accident.… - [NTSB CHI87LA003](https://openairdocs.org/ntsb/CHI87LA003.md): Cessna 150L · East Jordan, MI · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N1420Q · Substantial damage > The pilot stated that after extending 10 degrees of flaps and applying carburetor heat on final apch, he reduced throttle. Upon throttle reduction, the engine quit. Inspection of the engine revealed a broken mixture control cable housing. The engine operated… - [NTSB CHI87LA002](https://openairdocs.org/ntsb/CHI87LA002.md): Let L-13 · White Bear Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N142AS · Substantial damage > The plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated… - [NTSB MKC87LA003](https://openairdocs.org/ntsb/MKC87LA003.md): Cessna 150J · Peculiar, MO · Accident · No injuries · Limited investigation · Final report · Oct 5, 1986 · N6578S · Substantial damage > The plt reported that the acft encountered a downdraft as he made his apch to land at his pvt strip. The wind was from 250 degs at 7 KTS, a headwind for the landing acft. The plt reported no mechanical control difficulty during final apch. The plt reported… - [NTSB CHI87LA001](https://openairdocs.org/ntsb/CHI87LA001.md): Cessna 152 · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1986 · N5488B · Substantial damage > The student pilot assumed he had full fuel tanks prior to takeoff. He then proceeded to fly the aircraft for approximately 4.4 hours. Just prior to his final landing he was forced to go around due to an aircraft on the runway. Following this go around he… - [NTSB ATL87FA001](https://openairdocs.org/ntsb/ATL87FA001.md): Piper J3-65C · Goldsboro, NC · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1986 · N70414 · 2 aircraft · Destroyed > The J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The… - [NTSB LAX87LA006](https://openairdocs.org/ntsb/LAX87LA006.md): Burkhart Grob G103 Twin II · Calistoga, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1986 · N914G · Substantial damage > At the end of a local pleasure flight near clistoga, claifornia, the pilot stated the nose of his glider was pushed down while on base leg at calistaga airpark. Due to a loss in altitude to increase airspeed, the pilot was unable to reach the runway. A forced… - [NTSB NYC87LA005](https://openairdocs.org/ntsb/NYC87LA005.md): Cessna C-150 · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1986 · N704PY · Substantial damage > The student pilot flared long during landing and the instructor initiated a go around. During a right turn away from buildings, the aircraft stalled and collided with the ground on its nose and flipped over. - [NTSB LAX87LA008](https://openairdocs.org/ntsb/LAX87LA008.md): Cessna 172N · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1986 · N6366D · Substantial damage > A Cessna 172N landed adjacent to rwy 28L. According to the FAA the solo student plt was unable to correct for a strong wind and landed in a grass area south of the runway. The winds were reported from 360 deg at 17 KTS at the time of the accident. The pilot's… - [NTSB MIA87FA002](https://openairdocs.org/ntsb/MIA87FA002.md): Piper PA-60-600 · Tallahassee, FL · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1986 · N217HM · Destroyed > Witnesses stated seeing the acft enter a left downwind apch to rwy 16, turn base to final normally then veer to the left of the runway in a nose high attitude & disappear behind a line of trees & crash aprx 500 feet east of rwy 16. Post crash examination of… - [NTSB SEA87LA001](https://openairdocs.org/ntsb/SEA87LA001.md): Cessna 185-F II · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Oct 1, 1986 · N4631E · Substantial damage > Pilot attempted overwater approach to VFR airport through fog bank in conditions decreasing to 200 ft clg and one mi viz. On encountering total IMC, climbing turn took acft over land. Acft collided with trees at 800 ft level. - [NTSB LAX86LA358](https://openairdocs.org/ntsb/LAX86LA358.md): Bellanca 8GCBC · Chino, CA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1986 · N87020 · Substantial damage > The acft ground looped in a freshly plowed field during a forced landing after completing a banner tow operation. The plt indicated that he had just entered a downwind traffic pattern for the banner release area when the eng began to run rough and lose power.… - [NTSB BFO86FA050](https://openairdocs.org/ntsb/BFO86FA050.md): Mooney M20F · Leesburg, VA · Accident · 1 fatal · Field investigation · Final report · Sep 29, 1986 · N6443Q · Destroyed > Drg arrival, the plt was clrd for a VOR rwy 35 apch. Also, he was advised that there were problems with the rwy lights &that other plts had made missed apchs that evening due to dim arpt lighting. He was then clrd to UNICOM freq & told to cancel his IFR clnc… - [NTSB NYC86LA240](https://openairdocs.org/ntsb/NYC86LA240.md): Piper PA-28-161 · Atlantic City, NJ · Accident · No injuries · Limited investigation · Final report · Sep 24, 1986 · N9422C · Substantial damage > The flight was on approach for landing when engine power was lost due to fuel exhaustion. The aircraft crashed in a tidal marsh and nosed over slightly in the soft marsh and was substantially damaged. - [NTSB SEA86LA250](https://openairdocs.org/ntsb/SEA86LA250.md): Cessna 180 · Dry Bay, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1986 · N9138T · Destroyed > Gusty winds were present at the airstrip when the plt elected to go-around during the apch. During the go-around, a downdraft was encountered. The plt lost control of the acft which rolled inverted and struck the ground. The plt reported the wind velocity… - [NTSB SEA86FYE01](https://openairdocs.org/ntsb/SEA86FYE01.md): Jerome Dodge B-8-M · Deer Park, WA · Accident · 1 fatal · Final report · Sep 23, 1986 · N4621N · Destroyed > The gyrocopter was observed oscillating in flight prior to descending to ground impact. Investigation revealed inflight contact between the main rotor and vertical fin/pusher propeller had taken place. No mechanical failure was found which would have resulted… - [NTSB MIA86LA251](https://openairdocs.org/ntsb/MIA86LA251.md): Piper PA-28-161 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Sep 23, 1986 · N8200Z · Substantial damage > While on approach to runway the pilots vision was restricted by the glare from the rising sun. The pilot failed to see the operating approach light system which is located in the closed first 2000 feet of runway, and collided with the approach light system.… - [NTSB CHI86LA226](https://openairdocs.org/ntsb/CHI86LA226.md): Cessna 150M · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N66023 · Substantial damage > The acft was equipped with an O-320-E2D eng, but the plt calculated his fuel consumption based on the original eng, which was an O-200-A. The O-200-A eng used aprx 8 gal/hr, whereas, the O-320-E2D used about 10 gal/hr. Before reaching the destination on the… - [NTSB CHI86FEP09](https://openairdocs.org/ntsb/CHI86FEP09.md): Piper PA-32R-300 · Wisconsin Rapid, WI · Accident · 1 fatal · Final report · Sep 20, 1986 · N4909F · Destroyed > ATC had cleared the aircraft for an approach to an airport with several nonprecision instrument approaches and to maintain an altitude until established on a segment of an approach to that airport. Shortly after that time witnesses located 4.5 miles northwest… - [NTSB CHI86LA224](https://openairdocs.org/ntsb/CHI86LA224.md): Cessna 182M · Quincy, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1986 · N71650 · Substantial damage > According to the ATC report, N71650 indicated he would use the ILS rwy 04 and circle to rwy 18. The plt stated that he was in and out of fog while on downwind for rwy 18 and that he then encountered a 'bank of ground fog' as he turned short final. According… - [NTSB ATL86LA258](https://openairdocs.org/ntsb/ATL86LA258.md): Schweizer SGS 2-33 · Chardon, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1986 · N5722S · Substantial damage > During final landing approach to runway 14, the sutdent pilot deployed spoilers and attempted to maintain altitude. The glider collided with trees and descended out of control to the ground 200 feet short of the runway. The student pilot had a total flight… - [NTSB NYC86LA235](https://openairdocs.org/ntsb/NYC86LA235.md): Piper PA-24-250 · Geneseo, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1986 · N7215P · Substantial damage > The aircraft lost power on approach to Geneseo airport. Investigation did not reveal any preimpact malfunction/failure. Conditions conducive to carburetor icing existed at the time of the accident. - [NTSB LAX86LA349](https://openairdocs.org/ntsb/LAX86LA349.md): Piper PA-22-108 · El Monte, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1986 · N5066Z · Substantial damage > The aircraft rolled to the right as the student pilot and his instructor neared the runway. The instructor took the controls and the acft continued the right turn. The acft impacted storage buildings approximately 300 feet to the right of the rwy. A business… - [NTSB LAX86LA348](https://openairdocs.org/ntsb/LAX86LA348.md): Beech 35-B33 · Thermal, CA · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N917Q · Substantial damage > The pilot departed on a local flight to put 'some break in time' on a newly installed engine cylinder. The pilot stated that he' departed with a low fuel level but was only going to be up for a little while.' After 40 minutes of flight time, the pilot… - [NTSB DEN86FTG02](https://openairdocs.org/ntsb/DEN86FTG02.md): Rarsch RV-4 · Erie, ND · Accident · Serious injuries · Final report · Sep 13, 1986 · N319ER · Substantial damage > The plt said he was making a short field apch to a private, sod, strip. He said he was in a shallow lt bank on final apch when he noticed the acft was in a slip and descending too fast to avoid a collision with trees 500 ft from the apch end of the strip. The… - [NTSB ATL86LA253](https://openairdocs.org/ntsb/ATL86LA253.md): Schleicher ASW-19B · Griffin, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1986 · N15FW · Destroyed > The glider departed on an aerial tow and was released at 1700' AGL. Intention of the flt was an out and back x-country. During the flt the plt could not find lift and radioed a friend, also in a glider, that he intended to land at a sod strip. The plt stated… - [NTSB FTW86LA165](https://openairdocs.org/ntsb/FTW86LA165.md): Temco Glode Swift · Temple, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1986 · N2311B · Destroyed > The plt departed rwy 36 at charping field to perform touch and go landings. The plt stated that the acft eng quit on final apch. The plt elected to land short of the airfield with the landing gear retracted because of a power line along the final apch path.… - [NTSB LAX86LA342](https://openairdocs.org/ntsb/LAX86LA342.md): Beech A-36 · Visalia, CA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1986 · N6650Y · Substantial damage > The airplane departed monterey airport, monterey, CA on a VFR night flight. The plt entered the downwind leg for runway 30 and observed an airplane depart on the runway at what she thought was about midfield. The airplane had departed from the runway… - [NTSB DEN86LA251](https://openairdocs.org/ntsb/DEN86LA251.md): Cessna 172K · Monte Vista, CO · Accident · No injuries · Limited investigation · Final report · Sep 7, 1986 · N79910 · Substantial damage > The flt departed winslow, AZ, and was en route to erie, CO, when the accident occurred. The plt said he decided to divert to Monte Vista to 'take a break' and visit with his parents who lived nearby. The plt said the winds were light and variable with some… - [NTSB ATL86LA249](https://openairdocs.org/ntsb/ATL86LA249.md): Cessna 172N · Fuguay-Varina, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1986 · N4892G · Substantial damage > Plt said he saw fog around rwy lights as he flew over airport to enter downwind leg for rwy 16. On short final, below level of trees that bordered rwy east side. He lost ground references. Flaps were retracted to reduce drag but acft was not accelerated to… - [NTSB ATL86LA247](https://openairdocs.org/ntsb/ATL86LA247.md): Piper PA-24 180 · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1986 · N6309P · Substantial damage > The stated purpose of this flt was a bfr for the plt. Both the CFI and the plt stated that the bfr part of the flt was complete and that the plt was practicing a short field landing when the accident occurred. The approach was too low and the left main… - [NTSB MKC86LA187](https://openairdocs.org/ntsb/MKC86LA187.md): Cessna P337 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N90BK · Substantial damage > After a touch-&-go landing, the flt crew noted a problem with the landing gear. A check of the hydraulic sys revealed a lack of fluid in the reservoir; the plts were unable to either retract or extend the gear. Subsequently, they landed the acft with the nose… - [NTSB CHI86LA220](https://openairdocs.org/ntsb/CHI86LA220.md): Cessna 152 · Dwight, IL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N24980 · Substantial damage > The tail of the aircraft struck the cab of a truck while on final approach. The CFI stated that, as they were passing over the road at the approach end of the runway, the aircraft entered a downdraft and the empennage struck the truck which was approaching… - [NTSB FTW86LA163](https://openairdocs.org/ntsb/FTW86LA163.md): Cessna 172N · Vick, LA · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N737XJ · Substantial damage > The pilot was given incorrect information as to the location of his destination airstrip. However, he found an airstrip at that approximate location. It was a 2500 foot grass strip as opposed to the 3600 foot grass strip which he was expecting. While on the… - [NTSB ATL86LA245](https://openairdocs.org/ntsb/ATL86LA245.md): Cessna 150G · Smithville, TN · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N3287J · Substantial damage > The plt reported the acft had 6-7 gallons of fuel at takeoff, enough for about 30 minutes of flight. He flew for aprx 1 hour and on takeoff from a touch and go landing, the eng quit due to fuel exhaustion. The plt stated he had built this acft from several… - [NTSB CHI86FA218](https://openairdocs.org/ntsb/CHI86FA218.md): Learjet 24 · Ypsilanti, MI · Accident · Minor injuries · Field investigation · Final report · Sep 3, 1986 · N88JF · Substantial damage > Crew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down… - [NTSB FTW86LA159](https://openairdocs.org/ntsb/FTW86LA159.md): Boeing A75N1 · Laporte, TX · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N44WR · Substantial damage > During a landing, the acft encountered turbulence, so the plt initiated a go-around. However, the acft would not climb, even with full power. The flt path was toward power lines & a road, so the plt elected to land in a grass area. During the landing, the… - [NTSB ATL86LA238](https://openairdocs.org/ntsb/ATL86LA238.md): Joe Almon Falcon XP · Mt Olive, AL · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N548YA · Substantial damage > While apchg to land, the registered ultralight acft encountered a downdraft which exceeded its climb performance. The acft was headed twd power lines, so the plt elected to fly under the lines. As the ultralight was crossing under the power lines, one of its… - [NTSB SEA86LA230](https://openairdocs.org/ntsb/SEA86LA230.md): Aero Commander 100 · Priest River, ID · Accident · No injuries · Limited investigation · Final report · Aug 31, 1986 · N4156X · Substantial damage > The pilot was attempting to land while a thunderstorm was within two miles of the airport. Strong turbulence was present during the approach but the pilot elected to continue the approach. A strong downdraft occurred when the aircraft was about 50 feet AGL.… - [NTSB LAX86LA336](https://openairdocs.org/ntsb/LAX86LA336.md): Cessna 172E · Lower Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1986 · N3651S · Substantial damage > The airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high… - [NTSB FTW86LA157](https://openairdocs.org/ntsb/FTW86LA157.md): Piper PA-28R-200 · Afton, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1986 · N214PR · Substantial damage > The pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness. - [NTSB SEA86LA236](https://openairdocs.org/ntsb/SEA86LA236.md): Cessna 172N · Lord Flat, OR · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · N737NT · Substantial damage > The plt elected to go-around at about four feet AGL. Flaps were reduced from 40 degrees of flaps to 20 degrees of flaps and a gentle right turn was made due to rising terrain. The acft then settled onto the ground and crossed two ditches before coming to… - [NTSB CHI86MA212](https://openairdocs.org/ntsb/CHI86MA212.md): Piper PA-31-T1 · Montgomery, NY · Accident · 1 fatal · Major investigation · Final report · Aug 29, 1986 · N284MC · 2 aircraft · Substantial damage > After canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he… - [NTSB MKC86FA179](https://openairdocs.org/ntsb/MKC86FA179.md): Lockheed 18-56 (Howard 250) · Texarkana, AR · Accident · 2 fatal · Field investigation · Final report · Aug 28, 1986 · N252K · Destroyed > While apchg for a lndg, the acft pitched up, rolled inverted & impacted the terrain to the left of the rwy. No preimpactpart failure/malfunction was fnd; however, an inv revealed the acft had been loaded with the center-of-gravity (CG) wellbehind the aft… - [NTSB CHI86FEE06](https://openairdocs.org/ntsb/CHI86FEE06.md): Friling/Cothern Longeze · Plainfield, IL · Accident · Minor injuries · Final report · Aug 28, 1986 · N45FC · Substantial damage > The pilot made a steep right bank while entering the downwind leg on approach to land when the engine quit and the pilot was forced to make an emergency landing in a field short of the runway. Upon examination of the fuel system there was a lack of fuel in… - [NTSB SEA86LA226](https://openairdocs.org/ntsb/SEA86LA226.md): Hegsted S16B · Kelso, WA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N10LH · Substantial damage > The student pilot was on final when the engine ceased operating. A forced landing was accomplished with touchdown being about 100 yards short of the runway. A hard landing was made with the aircraft coming to rest inverted. The needle valve to the carburetor… - [NTSB MKC86LA180](https://openairdocs.org/ntsb/MKC86LA180.md): Piper PA-28-150C · Junction City, KS · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N5969W · Substantial damage > The c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft… - [NTSB ANC86LA138](https://openairdocs.org/ntsb/ANC86LA138.md): Piper PA-18 · Dry Creek, AK · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N5582C · Substantial damage > The pilot stated that he had adequate clearance over the trees during the approach, the aircraft just seemed to stall mush into the tree tops. The aircraft's airspeed was below stall speed. - [NTSB DEN86LA236](https://openairdocs.org/ntsb/DEN86LA236.md): Mayala Dragonfly · Helena, MT · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1986 · N4478V · Substantial damage > The acft was on final apch after completing a x-country from billings, MT, when the accident occurred. The plt stated the acft was low after intercepting the VASI so power was added; however, the eng did not respond. The acft struck a small hill 300 ft short… - [NTSB CHI86LA213](https://openairdocs.org/ntsb/CHI86LA213.md): Piper PA-38-112 · Clintonville, WI · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N2352N · Substantial damage > Following at least three successful practice low approaches to a farm field, the student pilot climbed over a small wooded area and did a 180 degree turn to perform an approach to another field. He flew down to within 20 feet of the ground, then applied full… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=183 ## 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=182 --- 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.