# NTSB investigations: Initial climb 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 181 of 412 · 20,559 cases ## Cases, newest first - [NTSB DEN86LA013](https://openairdocs.org/ntsb/DEN86LA013.md): Cessna 170B · Coloradosprings, CO · Accident · No injuries · Limited investigation · Final report · Oct 23, 1985 · N170CE · Substantial damage > The pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the… - [NTSB ATL86LMG02](https://openairdocs.org/ntsb/ATL86LMG02.md): Aeronca 11AC · Wallace, NC · Accident · Serious injuries · Final report · Oct 21, 1985 · N86097 · Destroyed > The acft collided with the terrain following a loss of control during initial takeoff climb. The plt reported that after clearing trees at an alt of aprx 200 ft the acft drifted to the right. The tail of the acft then rose pushing the nose down until the acft… - [NTSB MIA86FA015](https://openairdocs.org/ntsb/MIA86FA015.md): Beech BE 35 · Zellwood, FL · Accident · Serious injuries · Field investigation · Final report · Oct 20, 1985 · N2805V · Substantial damage > The private pilot landed at a turf strip utilizing full flaps and 6 units of nose up trim. The pilot stated that when preparing for departure he was in a hurry to avoid inclement weather at his destination and did not utilize a check list he never re-trimmed… - [NTSB NYC86FA015](https://openairdocs.org/ntsb/NYC86FA015.md): Piper PA-28-236 · Tobyhanna, PA · Accident · 2 fatal · Field investigation · Final report · Oct 19, 1985 · N4298K · Destroyed > At about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about… - [NTSB MIA86MA013](https://openairdocs.org/ntsb/MIA86MA013.md): Mcdonnell Douglas DC-9-51 · Tampa, FL · Incident · No injuries · Major investigation · Final report · Oct 19, 1985 · N412EA · Minor damage > Shortly after lift-off, the flt crew heard a loud noise (similar, but louder than a tire blow-out) as the #1 eng failed. They secured the #1 eng, remained in the traffic pattern & landed on the same rwy. After landing, an exam revealed the combustion chamber… - [NTSB FTW86FRA01](https://openairdocs.org/ntsb/FTW86FRA01.md): Cessna 172 M · Houston, TX · Accident · Minor injuries · Final report · Oct 19, 1985 · N9892Q · Substantial damage > The acft made a forced landing on a golf course and nosed over after the engine quit during takeoff. Post accident investigation revealed that the gascolator was full of water and the carburetor contained 25 percent water. No other discrepancies in equipment… - [NTSB ATL86LA008](https://openairdocs.org/ntsb/ATL86LA008.md): Piper PA-28-201T · Chattanooga, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1985 · N2854S · Substantial damage > The aircraft lost total power during takeoff initial climb and attempted an forced landing in a shopping center parking lot. During the landing attempt the aircraft collided with a utility pole and slid inverted approximately 250 ft before coming to rest.… - [NTSB SEA86LA014](https://openairdocs.org/ntsb/SEA86LA014.md): Cessna 150 · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1985 · N3231V · 2 aircraft · Substantial damage > The pilot of the landing aircraft failed to see and avoid the departing aircraft. The aircraft struck the departing aircrafts vertical stabilizer and rudder with the propeller. Approximately 40% of the vertical stabilizer and rudder separated from the… - [NTSB LAX86FA016](https://openairdocs.org/ntsb/LAX86FA016.md): Ofria Glanair · Van Nuys, CA · Accident · 2 fatal · Field investigation · Final report · Oct 15, 1985 · N179SH · Destroyed > Wintesses stated that the acft had just departed and, during the initial steep climb, it appeared to attempt to return to the arpt, stalled, and spun to gound contact 1/4 mile north of the arpt. Post accident examination failed to discloseany preimpact… - [NTSB NYC86LA008](https://openairdocs.org/ntsb/NYC86LA008.md): Waco UPF-7 · Norwood, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1985 · N39714 · Substantial damage > According to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided… - [NTSB CHI86LA010](https://openairdocs.org/ntsb/CHI86LA010.md): Beech K35 · New Lisbon, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 1985 · N6060E · Destroyed > According to the plt, acft preflight, engine runup and warm up were normal. Takeoff and initial climb up to approx 300 ft AGL were normal also. At this point the engine quit and the plt performed a forced landing in a clover field below him. The acft was… - [NTSB LAX86FA014](https://openairdocs.org/ntsb/LAX86FA014.md): Boeing A75N1 · Schellville, CA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1985 · N46871 · Destroyed > The acft crashed while attempting a slow roll immediately after departing from rwy 34 at the sonoma valley arpt. The plt stated to witnesses that he liked to roll his acft after takeoff. Witnesses indicated the acft became airborne after a 300 to 400 ft… - [NTSB CHI86LA009](https://openairdocs.org/ntsb/CHI86LA009.md): Piper PA-28R-200 · Troy, MI · Accident · No injuries · Limited investigation · Final report · Oct 13, 1985 · N9422N · Destroyed > The pilot reported a partial loss of power on takeoff. Altitude could not be maintained. During an attempt to return to the airport, the aircraft descended and landed on railroad tracks. The engine was test run at all power settings without discrepancies. - [NTSB DEN86FA008](https://openairdocs.org/ntsb/DEN86FA008.md): Cessna 175A · Jal, NM · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1985 · N6959E · Destroyed > A witness watched the acft takeoff and disappear in the darkness. The plt had intended to make 3 takeoffs and landings to regain currency for night flying. The acft never returned. The wreckage was found 2 miles north of the arpt the following morning. Wx was… - [NTSB CHI86LA012](https://openairdocs.org/ntsb/CHI86LA012.md): Cessna 421C · Wooster, OH · Accident · No injuries · Limited investigation · Final report · Oct 11, 1985 · N59EP · Substantial damage > The plt stated that the right eng manifold pressure decreased to 22 inches just after liftoff. He aborted the takeoff and put the acft back on the rwy. The acft ran off the end of the rwy, crossed a road and hit a ditch shearing the landing gear. Post… - [NTSB FTW86FA008](https://openairdocs.org/ntsb/FTW86FA008.md): Piper PA-28-180 · Pecos, TX · Accident · 1 fatal · Field investigation · Final report · Oct 10, 1985 · N711OW · Destroyed > The non-instrument rated pvt plt departed on a night flt with wx reported as 300 and 2 in fog and drizzle. Acft impacted terrain shortly thereafter in a 60 degree nose down attitude. The plt had told a friend that after depature he would acquire and then… - [NTSB ATL86LA004](https://openairdocs.org/ntsb/ATL86LA004.md): Cessna 305A(0-1A) · Marietta, GA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1985 · N9623Q · Substantial damage > Aircraft was on touch and go landing. Pilot allowed aircraft to become airborne prematurely. Flaps were not raised during go around and pilot stated he lost it. Aircraft veered to left after initial lift off for go around touched down repeatedly,with second… - [NTSB MIA86LA006](https://openairdocs.org/ntsb/MIA86LA006.md): North American Navion · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1985 · N4007K · Substantial damage > The plt stated that while doing touch-and-go landings at quincy, FL, the left main strut fell off the acft. He then returned to Tallahassee and made an intentional gear-up landing. Examination of the main landing gear scissor ass'y revealed that it failed due… - [NTSB MIA86LA002](https://openairdocs.org/ntsb/MIA86LA002.md): Piper PA-36-375 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Oct 4, 1985 · N2443X · Substantial damage > The plt stated that upon takeoff from hickory farms airstirp, the aircraft began losing power. He then dumped his load of chemicals and on descent, struck sugar cane and cartwheeled into a canal. No determination could be made as to the nature of the loss of… - [NTSB NYC86FA001](https://openairdocs.org/ntsb/NYC86FA001.md): Mooney M20J · Robbinsville, NJ · Accident · 1 fatal · Field investigation · Final report · Oct 3, 1985 · N5750L · Destroyed > During IFR departure from an uncontrolled arpt, the acft was instructed to squawk the discrete freq that had been issued in pre-flt clearance. The plt acknowledged the freq. The acft disappeared from radar. Ground witnesses saw the acft descend out of the low… - [NTSB MKC86LA001](https://openairdocs.org/ntsb/MKC86LA001.md): Piper PA-28-140 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Oct 3, 1985 · N8047N · Substantial damage > The Piper PA-28-140 was departing the Kansas City, MO area for a VFR, no flight-plan flight to warrensburg, MO. Witnesses stated that the airplane appeared to lift off prematurely and remained effectively stalled until impact two min later in a… - [NTSB CHI86FEX01](https://openairdocs.org/ntsb/CHI86FEX01.md): Piper PA-38-112 · Terre Haute, IN · Accident · No injuries · Final report · Oct 2, 1985 · N3768U · Substantial damage > The acft rt main & nose gear collapsed during a forced landing after a power loss during takeoff. The student plt was at the controls when the eng quit at about 300 ft AGL. The CFI took the controls and turned left toward a taxiway for the landing. The acft… - [NTSB MKC85LA224](https://openairdocs.org/ntsb/MKC85LA224.md): Bellanca Citabria 7ECA · Council Bluffs, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1985 · N1008E · Substantial damage > On climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the… - [NTSB SEA85LA232](https://openairdocs.org/ntsb/SEA85LA232.md): Taylorcraft BC12-D · Lopez Island, WA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N95515 · Substantial damage > Shortly after takeoff the acft's eng ceased operating for unknown reasons. During the landing rollout, the acft struck a fence and nosed over. - [NTSB ATL85MA286](https://openairdocs.org/ntsb/ATL85MA286.md): Cessna 208 · Jenkinsburg, GA · Accident · 17 fatal · Major investigation · Final report · Sep 29, 1985 · N551CC · Destroyed > As the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the… - [NTSB FTW85LA361](https://openairdocs.org/ntsb/FTW85LA361.md): Cessna 182G · Maypearl, TX · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N3414S · Substantial damage > Plt stated that shortly after takeoff, the engine failed completely without warning. He set up for and executed a forced landing in a field. During the flare, one wing tip struck the top of a tree and during the landing roll the acft crossed several terraces,… - [NTSB ATL85FLT14](https://openairdocs.org/ntsb/ATL85FLT14.md): Cessna 150H · Lebanon, TN · Accident · Minor injuries · Final report · Sep 28, 1985 · N7086S · Substantial damage > The acft crashed during a forced lndg after a power loss during takeoff. According to reports the plt took off on a check ride with an instructor. At 150 ft AGL pwr dropped to 2000 RPM. The CFI took over and shortly thereafter the pwr dropped to 1800 RPM. In… - [NTSB ANC85LA186](https://openairdocs.org/ntsb/ANC85LA186.md): Cessna A185F · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N9676H · Substantial damage > The pilot took off in turbulent wind conditions and lost control of the airplane; striking ground and upending. - [NTSB SEA85LA229](https://openairdocs.org/ntsb/SEA85LA229.md): Cessna 185 · San Juan Island, WA · Accident · No injuries · Limited investigation · Final report · Sep 27, 1985 · N9644H · Destroyed > The pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid… - [NTSB ATL85FLT13](https://openairdocs.org/ntsb/ATL85FLT13.md): Piper PA-38-112 · Springfield, TN · Accident · No injuries · Final report · Sep 26, 1985 · N2438C · Substantial damage > The acft was substantially damaged after contacting thres during a landing following a loss of pwr on takeoff. Post accident inspection revealed the carburetor valve ass'y had separated from the lever ass'y allowing the valve to seat flat against the… - [NTSB SEA85LA230](https://openairdocs.org/ntsb/SEA85LA230.md): Bellanca 17-30A · Burlington, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1985 · N6627V · Substantial damage > During initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left… - [NTSB NYC85FA245](https://openairdocs.org/ntsb/NYC85FA245.md): Bell 206B · Chalkhill, PA · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1985 · N32TV · Destroyed > The helicopter was being used on an external load operation with a 100 ft cable attached. When a 618 lb load was ready to be moved, the plt started the eng, lifted off & moved the helicopter to a hover over the load. The loaders hooked the load to the cable &… - [NTSB CHI85FER03](https://openairdocs.org/ntsb/CHI85FER03.md): Univair 108-1 · Mcgregor, MN · Accident · Minor injuries · Final report · Sep 22, 1985 · N8403K · Substantial damage > The acft contacted trees off the departure end of rwy 18 during a forced landing following a loss of pwr on takeoff. Post accident inspection revealed the fuel selector was positioned for the left tank and the left tank contained no fuel. The carburetor did… - [NTSB ATL85FIJ01](https://openairdocs.org/ntsb/ATL85FIJ01.md): Starduster SA-100 · Point Pleasant, WV · Accident · Minor injuries · Final report · Sep 22, 1985 · N21GT · Substantial damage > The plt stated that she made a normal preflt. She reported that the float type fuel gage indicated that the main fuel tank, which had a capacity of 12 gal, was half full. While climbing thru about 500 ft AGL after takeoff, the eng sputtered & lost power. The… - [NTSB LAX85LA398](https://openairdocs.org/ntsb/LAX85LA398.md): Cessna 172N · Huntington Bch, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1985 · N4840G · Substantial damage > The plt stated that he aborted his first takeoff because of reduced acceleration. He taxied back, via a parallel taxiwayand made run-on type takeoff. He said that as the acft climbed to an alt of aprx 50 to 60 ft above the rwy he heard a thud and the airspeed… - [NTSB CHI85LA386](https://openairdocs.org/ntsb/CHI85LA386.md): Cessna 172 M · Freemont, OH · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N9391H · Substantial damage > The pilot stated that just after liftoff a gust of wind pushed him back down almost on the runway. He could not accelerate but did keep the aircraft straight and level as he drifted off the runway through a fence and into some trees at a low airspeed. When… - [NTSB MKC85LA220](https://openairdocs.org/ntsb/MKC85LA220.md): Cessna 172K · Kalona, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1985 · N78227 · Substantial damage > The plt reported that on the initial indication of rain, he elected to takeoff from the harvested soybean field before it became muddy. The field was soft & was about 2100 ft long. Before the acdnt, the wind was from the south, so the plt began his takeoff in… - [NTSB FTW85LA351](https://openairdocs.org/ntsb/FTW85LA351.md): Piper PA-32-300 · Mt. Pleasant, TX · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N95RA · Substantial damage > The pilot stated he lost engine power shortly after takeoff. He made an emergency forced landing in a grassy field. An examination showed a collapsed flex air duct from the air filter to the fuel injector. A forty five degree metal duct was not installed… - [NTSB BFO85FA077](https://openairdocs.org/ntsb/BFO85FA077.md): Cessna 150E · Clinton, MD · Accident · Serious injuries · Field investigation · Final report · Sep 18, 1985 · N3518J · Destroyed > Plt stated that on initial climb from a normal takeoff, a partial engine pwr loss was experienced. Control of the airplane was lost while maneuvering for a suitable forced landing area. A flight instructor that witnessed the takeoff stated that it appeared to… - [NTSB NYC85LA237](https://openairdocs.org/ntsb/NYC85LA237.md): Piper J-3 · Chenango Bridge, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 15, 1985 · N41440 · Substantial damage > According to the pax after takeoff the aircraft climbed to about 300 feet. The pilot then made a right turn. During the turn the pilot yelled out 'we're losing it, we're losing it.' Afterwards the aircraft descended and impacted the ground. The pax does not… - [NTSB MIA85LA256](https://openairdocs.org/ntsb/MIA85LA256.md): Cessna 150L · Indiantown, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1985 · N1767Q · Destroyed > The acft attempted a take-off from an intermediate point of a damp, soft, turf rwy. A 70 deg. Left x-wind of approx 25 KTS existed at the time. The acft became airborne but was unable to clear trees at the end of the rwy. Thee acft was destroyed in the crash… - [NTSB SEA85LA213](https://openairdocs.org/ntsb/SEA85LA213.md): Todd KR-II · Boise, ID · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1985 · N5CJ · Substantial damage > The acft settled back onto the rwy shortly after takeoff pushing both main gear up through the wings. The plt did not have any previous experience in this type acft. - [NTSB CHI85FET03](https://openairdocs.org/ntsb/CHI85FET03.md): Vanbenthuysen John Bede BD-5B · Elkhart, IN · Accident · 1 fatal · Final report · Sep 14, 1985 · N23105 · Substantial damage > The acft rolled inverted & collided with the ground after an overtemperature reading, an RPM loss and loss of airspeed were recognized by the plt during the recording of the takeoff. The plt had a portable recorder on board and was using it during the… - [NTSB NYC85LA234](https://openairdocs.org/ntsb/NYC85LA234.md): Piper PA-32-260 · East Swanzey, NH · Accident · No injuries · Limited investigation · Final report · Sep 12, 1985 · N42722 · Destroyed > The acft was preflighted & determined to have 10 qts of oil in the eng. While climbing thru about 1000 ft MSL after takeoff, the propeller RPM began rising to the redline. The plt reduced power & proceeded to make an emerg landing. During a turn toward the… - [NTSB MIA85FA251](https://openairdocs.org/ntsb/MIA85FA251.md): Jodel D-9 · Okeechobee, FL · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1985 · N12HD · Destroyed > The plt had flown only 4 has in the last 6 months in a Cessna 150 type acft & had never flown a Jodel 09 before. The plt boarded the acft, declined a cockpit check by the owner & made an immediate take off. The plt took off from the grass strip without… - [NTSB CHI85LA373](https://openairdocs.org/ntsb/CHI85LA373.md): Schweizer G-164A · Irwin, OH · Accident · No injuries · Limited investigation · Final report · Sep 11, 1985 · N48514 · Destroyed > At an alt of aprx 20 ft AGL after takeoff, the #1 cylinder failed. A straight ahead landing was made in a corn field during which the acft was destroyed. The eng had under gone a major overhaul 197 hrs prior to this accident. - [NTSB SEA85LA210](https://openairdocs.org/ntsb/SEA85LA210.md): Beech A23 · Winnemucca, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 1985 · N2377J · Destroyed > The student had recently purchased the acft. On 9/5/85, an instructor plt, who had delivered the acft to the Winnemucca arpt, gave the student a total of 0.4 hr dual instruction, which included 2 landings. The instructor then indorsed the student's log book… - [NTSB FTW85LA345](https://openairdocs.org/ntsb/FTW85LA345.md): Great Lakes 2T-1A-2 · Caddo Mills, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 1985 · N6262L · Destroyed > The CFI PIC stated the eng lost power with the acft about 400 to 500 ft AGL. He couldn't return to the arpt due to lack of altitude. He elected to land in the plowed field. The acft touched down and flipped inverted. The air induction duct was found… - [NTSB ANC85LA175](https://openairdocs.org/ntsb/ANC85LA175.md): Cessna 180 · Farewell, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1985 · N3657C · Substantial damage > Acft failed to gain alt & crashed on takeoff from gravel bar weight & balance. CG, & winds were questionable. - [NTSB MKC85LA212](https://openairdocs.org/ntsb/MKC85LA212.md): Cessna 152 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Sep 8, 1985 · N67463 · Substantial damage > Student plt on first solo takeoff experienced left yaw after liftoff. While plt attempted to correct for the yaw the acft touched down beside the rwy, traveled a short distance, collided with a dirt bank and nosed over. The plt said there was a left crosswind… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=182 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=181 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.