# 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 196 of 420 · 20,992 cases ## Cases, newest first - [NTSB SEA85FA050](https://openairdocs.org/ntsb/SEA85FA050.md): Cessna 175 · White City, OR · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1985 · N7277M · Destroyed > The acft crashed after stalling during a go-around attempt. Witnesses said the acft was on final approach to the unlighted arpt with 40 degrees of flap when the go-around attempt was made. The acft rolled and turned 180 degrees before impacting the ground… - [NTSB FTW85LA102](https://openairdocs.org/ntsb/FTW85LA102.md): Piper PA-28-181 · League City, TX · Accident · No injuries · Limited investigation · Final report · Jan 27, 1985 · N82048 · Substantial damage > The acft collided with a ditch about 75 yards short of rwy 13 during a practice night forced landing. The pvt plt, an employee of the FBO operator, had taken the acft without permission and had been flying for approx 1.7 hrs when the accident occurred. The 18… - [NTSB ANC85FA041](https://openairdocs.org/ntsb/ANC85FA041.md): Piper PA-31-350 · Savoonga, AK · Accident · No injuries · Field investigation · Final report · Jan 27, 1985 · N4112D · Substantial damage > The plt reported that during arrival, he overflew the arpt & made a right turn while watching the village. As he maneuvered, he encountered white-out conditions, turned too FAR & subsequently collided with rising terrain. The wx over the general area prior to… - [NTSB CHI85IA097](https://openairdocs.org/ntsb/CHI85IA097.md): Boeing 727-51 · St. Paul, MN · Incident · No injuries · Incident investigation · Final report · Jan 26, 1985 · N463US · Minor damage > Shortly after takeof, the aircraft experienced an uncontained 7th to 8th stage removable sleeve compressor spacer failure in the number 3 engine. Pieces of the spacer passed through the number 2 engines duct causing compressor stalls in that engine. The… - [NTSB ATL85LA082](https://openairdocs.org/ntsb/ATL85LA082.md): Beech BE-55 · Vicksburg, MS · Accident · No injuries · Limited investigation · Final report · Jan 25, 1985 · N3057 · Destroyed > During the landing attempt, the pilot failed to ensure that the landing gear was extended. He was preoccupied with trying to locate a runway sweeper reported by the airport manager. When the gear failed to extend the pilot continued the approach knowing that… - [NTSB NYC85LA055](https://openairdocs.org/ntsb/NYC85LA055.md): Cessna 206G · Endicott, NY · Accident · No injuries · Limited investigation · Final report · Jan 20, 1985 · N9940Z · Substantial damage > The plt stated that the eng RPM dropped to idle when he made his second pwr reduction on downwind in preparation for landing. The throttle could not be pushed in when an attempt to add pwr was made. The acft touched down short of the rwy and came to rest aprx… - [NTSB FTW85LA097](https://openairdocs.org/ntsb/FTW85LA097.md): Cessna 182A · Wichita Falls, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1985 · N5162D · Substantial damage > Plt intentionally ran the rt fuel tank empty and switched to the left tank which was 1/2 to 3/4 full on takeoff. Plt maintained a left side slip during the landing apch to compensate for x-wind conditions. Plt stated, at 400 ft AGL he noticed a pwr loss.… - [NTSB LAX85LA112](https://openairdocs.org/ntsb/LAX85LA112.md): Hughes 369D · Kahului,Maui, HI · Accident · No injuries · Limited investigation · Final report · Jan 16, 1985 · N58399 · Substantial damage > According to the plt, about 1.4 hours into a local photo flt, the fuel gage showed 125 pounds and he elected to return to the arpt for more fuel. With the fuel gage showing just under 100 pounds, engine flamed out on approach to the arpt and plt executed an… - [NTSB LAX85LA107](https://openairdocs.org/ntsb/LAX85LA107.md): Piper PA-38-112 · Compton, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1985 · N9755T · Destroyed > As the student plt was about to touchdown on rwy 25L the acft swerved to the left. He attempted a go-around & in order to avoid parked acft to the south of the adjacent taxiway he applied aft elevator & stalled the acft, landing upon & destroying two other… - [NTSB LAX85FA106](https://openairdocs.org/ntsb/LAX85FA106.md): Cessna 177B · El Monte, CA · Accident · Serious injuries · Field investigation · Final report · Jan 12, 1985 · N34212 · Destroyed > The engine lost pwr & was restarted twice before it quit. The acft landed in a dry riverbed two miles south of the arpt. Two ounces of fuel were found at the scene. Winds were slightly greater than forecast. Four taxi/runup/takeoff/ climbs had been made since… - [NTSB ANC85LA039](https://openairdocs.org/ntsb/ANC85LA039.md): Cessna C-207 · Nome, AK · Accident · No injuries · Limited investigation · Final report · Jan 11, 1985 · N7396U · Substantial damage > Plt obtained a special VFR to land at Nome arpt. Plt saw apch lights and made a left circle to line up with rwy. Plt stated, ceiling was 300 ft AGL, low visibility and freezing drizzle was present. Aprx 3/8 inch of ice was on airframe and windshield. Plt… - [NTSB LAX85FA102](https://openairdocs.org/ntsb/LAX85FA102.md): Cessna T210L · Hesperia, CA · Accident · Serious injuries · Field investigation · Final report · Jan 10, 1985 · N210NF · Destroyed > The plt reptd that shortly after entering the downwind leg for ry 03 he completed the prelanding checklist. While on final approach the acft experienced a total loss of engine powe. The acft altitude was too low to negotiate a landing on the ry & the plt… - [NTSB DCA85AA009](https://openairdocs.org/ntsb/DCA85AA009.md): Lockheed 188A · Kansas City, KS · Accident · 3 fatal · Final report · Jan 9, 1985 · N357Q · Destroyed > During arrival to the Kansas City downtown arpt, the flt was vectored for a VOR rwy 3 apch, then was cleared for the apch & to circle & land on rwy 36. On final apch, the acft was hi & was not in a position to land, so the flt was cleared to circle left for… - [NTSB CHI85LA086](https://openairdocs.org/ntsb/CHI85LA086.md): Cessna 310Q · Plato Center, IL · Accident · No injuries · Limited investigation · Final report · Jan 9, 1985 · N7513Q · Substantial damage > The acft experienced a nose gear collapse during landing. The plt stated that while on final apch the acft contacted a 3-4 ft high snowbank near the end of the rwy which resulted in the nose gear collapse. He continued to state the snowbank was difficult to… - [NTSB NYC85LA053](https://openairdocs.org/ntsb/NYC85LA053.md): Cessna C207 · North East, PA · Accident · No injuries · Limited investigation · Final report · Jan 8, 1985 · N91046 · Substantial damage > The acft was damaged during a forced landing in a grape vineyard. The plt stated that a ttl loss of pwr occurred during an apch to erie int'l arpt while passing through 3200 ft MSL. The plt performed emergency procedures and was able to regain partial pwr… - [NTSB CHI85IA084](https://openairdocs.org/ntsb/CHI85IA084.md): Swearingen SA-227-AC · Covington, KY · Incident · No injuries · Incident investigation · Final report · Jan 8, 1985 · N3110J · No damage > The aircrew reported that during flt at 6000 ft MSL, they encountered icing conditions & used the de-ice & anti-ice equipment. After they descended & were clear of icing, they deactivated the de-ice & anti-ice equipment. The capt said hechecked the prop… - [NTSB BFO85FA011](https://openairdocs.org/ntsb/BFO85FA011.md): Mitsubishi MU-2B-25 · West Point, VA · Accident · 1 fatal · Field investigation · Final report · Jan 4, 1985 · N275MA · Destroyed > After being delayed at least 2 days at youngstown, OH, due to maintenance problems the plt departed at aprx 1725 hrs with the knowledge that the wx at his destination was ift to lifr. In addition, the plt was scheduled for a vacation and had expressed hopes… - [NTSB NYC85FNC02](https://openairdocs.org/ntsb/NYC85FNC02.md): Piper PA-34-200T · Hopkinton, NH · Accident · Serious injuries · Final report · Jan 1, 1985 · N47364 · Destroyed > The acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the… - [NTSB FTW85LA091](https://openairdocs.org/ntsb/FTW85LA091.md): Cessna 210L · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1984 · N2127S · Substantial damage > The acft suffered a collapsed nose gear after losing and regaining power during an ILS approach and finally completing an emergency landing two miles from the rwy of intended landing. There were no injuries and no fire. Examination of the acft in the field… - [NTSB ATL85FA071](https://openairdocs.org/ntsb/ATL85FA071.md): Cessna 172N · Dothan, AL · Accident · Serious injuries · Field investigation · Final report · Dec 30, 1984 · N6527D · Substantial damage > The plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums. - [NTSB SEA85LA037](https://openairdocs.org/ntsb/SEA85LA037.md): Piper PA-34-200T · Boise, ID · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · CGTQE · Substantial damage > On final approach, the pilot's wife, also a rated pilot, was reviewing the landing check list. At item 'heaters off' she inadvertently turned fuel selectors to off. Both engines lost pwr and pilot executed a forced landing short of runway in rough terrain,… - [NTSB MKC85LA041](https://openairdocs.org/ntsb/MKC85LA041.md): Piper PA-28-180 · Stuttgart, AR · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1984 · N2320T · Substantial damage > Plt stated he had attempted an NDB approach to rwy 18 but executed a missed approach when he could not see the rwy when the acft was at 800 ft. the plt pitched the acft to a climb attitude and added full throttle. He continued to state that the acft felt… - [NTSB MKC85FA040](https://openairdocs.org/ntsb/MKC85FA040.md): Beech S35 · Hot Springs, AR · Accident · 3 fatal · Field investigation · Final report · Dec 27, 1984 · N69WF · Destroyed > The acft collided with trees & crashed on the east side of west mountain after the plt had made an ILS rwy 5 apch & overflew the arpt. The last wx observation before the accident was: partial obscuration, ceiling 300 ft, visibility 1 mi. The decision height… - [NTSB ATL85LA069](https://openairdocs.org/ntsb/ATL85LA069.md): Cessna 172H · Fairburn, GA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N9347H · Substantial damage > The aircraft reportedly suffered a loss of power while on the x-wing leg for a touch-&-go landing. The plt attempted to land the aircraft on the reciprical rwy from which he departed. The aircraft touched down long and ran off of the end of the runway into… - [NTSB ATL85LA066](https://openairdocs.org/ntsb/ATL85LA066.md): Piper PA-24-250 · Ft Knox, KY · Accident · No injuries · Limited investigation · Final report · Dec 25, 1984 · N6666P · Substantial damage > N6666P, contacted the ground 100 yds short of rwy 36 during landing at Ft Knox, KY, while on a personal flight. The acft sustained substantial damage to the nose, left main landing gear, both wings and the propeller. Investigation revealed the acft exceeded… - [NTSB ATL85LA065](https://openairdocs.org/ntsb/ATL85LA065.md): Mooney M20E · Monroeville, AL · Accident · No injuries · Limited investigation · Final report · Dec 25, 1984 · N9418V · Substantial damage > Plt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to… - [NTSB FTW85FA084](https://openairdocs.org/ntsb/FTW85FA084.md): Beech A36 · Lake Charles, LA · Accident · 4 fatal · Field investigation · Final report · Dec 24, 1984 · N2049G · Destroyed > The acft crashed 3 miles short of the Lake Charles airport while on an ILS approach. Instrument meteorological conditions prevailed at the time of the accident, and an IFR flight plan was filed by the non-instrument rated pilot. A review of the radio… - [NTSB CHI85LA075](https://openairdocs.org/ntsb/CHI85LA075.md): Piper PA-28-140 · Troy, MI · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1984 · N9645W · Substantial damage > The plt reported a loss of power while in the traffic pattern. During his manuvering to position the acft for landing, the acft stalled & impacted in a field. Investigation did not reveal any fuel/eng malfunction that would have contributed to the accident. - [NTSB LAX85LA080](https://openairdocs.org/ntsb/LAX85LA080.md): Hardy Quickie · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N7NH · Substantial damage > The plt was conducting a high speed taxi run on a newly built acft when it became airborne. He continued the takeoff & flew the acft for a short period of time, then prepared for a landing with partial power. While on final & about 15 ft AGL, he believed he… - [NTSB DEN85LA047](https://openairdocs.org/ntsb/DEN85LA047.md): Piper PA-22-135 · Taylor, UT · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N3648A · Substantial damage > Acft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely. - [NTSB MKC85FA037](https://openairdocs.org/ntsb/MKC85FA037.md): Aero Commander 690A · Pea Ridge, AR · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1984 · N9229Y · Destroyed > Plt was cleared for vor/dme approach to rogers arpt by fayetteville apch control; fayetteville altimeter setting of 29.85 (confirmed by recorded transcript) furnished. Plt did not read back. During apch, acft impacted trees 25 ft AGL at aprx 1320 ft MSL, 3… - [NTSB BFO85IA056](https://openairdocs.org/ntsb/BFO85IA056.md): Boeing 747-200 · New Orleans, LA · Incident · No injuries · Incident investigation · Final report · Dec 20, 1984 · DABYP · 2 aircraft · No damage > During arrival, a Boeing 747, registration number d-abyp, lufthansa flight 5432, was vectored for an ILS localizer backcourse apch to rwy 19 at the new orlean intl arpt. While on the apch at 2000 ft MSL, the aircrew were instructed by the arrival controller… - [NTSB ATL85FA061](https://openairdocs.org/ntsb/ATL85FA061.md): Piper PA-28-161 · Glasgow, KY · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N6077H · Destroyed > The acft crashed one mi short of rwy 07 at Glasgow municipal airport while on sdf rwy 07 inst app. There were no witnesses to the actual accident other then the surviving passenger who stated that the plt had asked her to look for the rwy lights. She stated… - [NTSB FTW85FA079](https://openairdocs.org/ntsb/FTW85FA079.md): Piper PA-38-112 · Laredo, TX · Accident · 2 fatal · Field investigation · Final report · Dec 19, 1984 · N9249T · Destroyed > The acft was observed to enter a downwind leg of the traffic pattern at a low alt (estimated 100 ft AGL). The witness looked away for a moment. When he looked back, he did not see the acft. A search was intiated & the acft was found where it had crashed in a… - [NTSB NYC85FA044](https://openairdocs.org/ntsb/NYC85FA044.md): Piper PA-23-250 · Bainbridge, NY · Accident · 4 fatal · Field investigation · Final report · Dec 18, 1984 · N6099Y · Destroyed > VFR conditions prevailed when the flt departed binghamton, NY. The destination was reported as clear until just prior to the estimated time of arrival, then fog began to form. Witnesses who heard the acft, just prior to the accident, reported heavy fog. After… - [NTSB FTW85LA080](https://openairdocs.org/ntsb/FTW85LA080.md): Cessna 421C · Vancourt, TX · Accident · No injuries · Limited investigation · Final report · Dec 17, 1984 · N6865D · Substantial damage > After a complete wx brf the plt departed into known IFR cond well below apch min at the dest arpt with inadequate fuel reserves and no field alternate. After 2 missed apchs the plts desired alternate was below minimums. En route to a second alternate airport… - [NTSB BFO85FA009](https://openairdocs.org/ntsb/BFO85FA009.md): Grumman AA-5A · Manassas, VA · Accident · Serious injuries · Field investigation · Final report · Dec 17, 1984 · N14LC · Destroyed > After a higher and faster apch than usual due to conflicting traffic, the acft touched down on the nosewheel and began to porpoise, according to witnesses. After the second bounce, power was added for a go around, the pilot later stated. Witnesses saw the… - [NTSB LAX85LA072](https://openairdocs.org/ntsb/LAX85LA072.md): Cessna 150F · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Dec 15, 1984 · N7967F · Substantial damage > The acft lost power & nosed over while making an emergency landing in a muddy field. Investigation revealed that fuel was being siphoned from the fuel tank vent. - [NTSB ATL85FA055](https://openairdocs.org/ntsb/ATL85FA055.md): Piper PA-32-300 · Burlington, KY · Accident · 2 fatal · Field investigation · Final report · Dec 14, 1984 · N5211S · Destroyed > Acft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded… - [NTSB MIA85FA058](https://openairdocs.org/ntsb/MIA85FA058.md): Piper PA-31-350 · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Dec 13, 1984 · N40790 · Substantial damage > Plt judged by reference to acft gages that he had 156 gals of fuel remaining when infact only 120 gals of fuel remained. On approach for lndg, while operating on aux tanks, low fuel flow warning light illuminated. Plt switched to main tanks and both engines… - [NTSB ATL85LA053](https://openairdocs.org/ntsb/ATL85LA053.md): Hughes 269C · Albermarle, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1984 · N7401F · Substantial damage > Plt saw unfamiliar mountain range and decided to land in a residential construction site to find out his exact location. Plt failed to see electrical wires during the descent until too late. Plt lost control of acft in last minute attempt to avoid wires. Acft… - [NTSB ATL85FA054](https://openairdocs.org/ntsb/ATL85FA054.md): Beech D18S · Norfolk, VA · Accident · Serious injuries · Field investigation · Final report · Dec 13, 1984 · N8517Z · Destroyed > The acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened… - [NTSB CHI85LA069](https://openairdocs.org/ntsb/CHI85LA069.md): Cessna 210M · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1984 · N22FP · Destroyed > The plt reported that he did not have the acft refueled prior to departure & once airborne encountered a stronger head wind than anticipated. He stated that most of the possible en route fuel stops were 'down due to fog.' When aprx 18 mi past port Columbus… - [NTSB ANC85FA027](https://openairdocs.org/ntsb/ANC85FA027.md): Cessna 140 · Wasilla, AK · Accident · No injuries · Field investigation · Final report · Dec 10, 1984 · N77227 · Substantial damage > On go-around during a simulated forced landing over a dirt landing strip engine began to sputter and run rough. Plt stated power was reduced and engine began to run smooth. Fuel tank was switched and 15 to 20 seconds later, engine quit. Forced landing was… - [NTSB ATL85MA049](https://openairdocs.org/ntsb/ATL85MA049.md): Beech 58 · Charleston, SC · Accident · 1 fatal · Major investigation · Final report · Dec 6, 1984 · N7230R · Destroyed > Plt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an… - [NTSB LAX85LA058](https://openairdocs.org/ntsb/LAX85LA058.md): Cessna P210N · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Dec 4, 1984 · N7606P · Substantial damage > Plt elected to make a precautionary landing at Lancaster due to a low fuel state. Eng quit while on downwind in traffic pattern. Unable to make it to the rwy, an off arpt landing was made during which the acft was damaged. - [NTSB FTW85LA068](https://openairdocs.org/ntsb/FTW85LA068.md): Cessna T310R · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Dec 4, 1984 · N4864A · Substantial damage > According to the plt icing conditions were encountered during the asr apch. Deicing equipment was utilized several times during the apch and worked normally. The acft broke out at 400 ft AGL. Ice accumulation on the wings resulted in an excessive rate of… - [NTSB SEA85LA023](https://openairdocs.org/ntsb/SEA85LA023.md): Cessna 310R · Pocatello, ID · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1984 · N37279 · Substantial damage > The acft had descended to about 900 AGL after passing through icing conditions with a light accumulation of ice. When the landing gear was lowered the acft started yawing and the acft engine instruments were flucuating. The plt thought that the engines were… - [NTSB MKC85LA028](https://openairdocs.org/ntsb/MKC85LA028.md): Cessna 421B · Mason City, IA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1984 · N41097 · Substantial damage > The ATP PIC knew that he would be flying into area of surface icing. Boots on horizontal stabilizer did not remove ice. Over rwy at 30 ft, acft stalled & hit the rwy hard. Manufactorer states acft cannot be certified for flt into known icing. Deice and… - [NTSB ATL85LA045](https://openairdocs.org/ntsb/ATL85LA045.md): Cessna 172M · Ahoskie, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1984 · N12946 · Destroyed > While on a night VFR local area flight the pilot noticed haze obscuring the lights on the ground. He returned to the airport and activated the REIL lights, he lost sight of the lights as he entered the traffic pattern. During the left turn to base, he entered… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=197 ## 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=196 --- 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.