# NTSB investigations: Takeoff 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 156 of 281 · 14,038 cases ## Cases, newest first - [NTSB ATL83LA137](https://openairdocs.org/ntsb/ATL83LA137.md): Cessna 182L · Fort Belvoir, VA · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1983 · N42587 · Destroyed > The aircraft was being taxied to the runway for takeoff when it was overturned by the wind. Local weather station had issued a 'point warning' of winds at 25 KTS, gusting to 35 KTS. The aircraft was taxied from its protected place behind a hangar to an… - [NTSB DEN83LA076](https://openairdocs.org/ntsb/DEN83LA076.md): Cessna 152 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Mar 10, 1983 · N46546 · Substantial damage > The aircraft piloted by a solo student ran off the runway and nosed over in a snow bank during landing. The pilot was practicing short field landings. The accident occurred during the first touch and go. The landing was good and the pilotretracted flaps to 10… - [NTSB LAX83LA145](https://openairdocs.org/ntsb/LAX83LA145.md): Schweizer SGS2-33A · Fremont, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 1983 · N7547 · Minor damage > The acft banged into the ground during the takeoff ground run. The glider had swerved off the rwy during the tow into a muddy grass area, the plt attempted a premature takeoff to prevent getting struck in the mud. He stated that lack of forward speed and the… - [NTSB ATL83LA130](https://openairdocs.org/ntsb/ATL83LA130.md): Rockwell Intl S-2R · Marshallville, GA · Accident · No injuries · Limited investigation · Final report · Mar 7, 1983 · N8515V · Substantial damage > The plt reported that he was taking off with a load of fertilizer from a newly constructed strip that was wet and soft. He stated that he failed to clear a mud-hole at the end of the strip, the wheels mired in the mud, and the acft nosed over. - [NTSB CHI83LA128](https://openairdocs.org/ntsb/CHI83LA128.md): Cessna 150D · Wilmington, OH · Accident · No injuries · Limited investigation · Final report · Mar 5, 1983 · N3064S · Substantial damage > The aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and… - [NTSB ANC83LA051](https://openairdocs.org/ntsb/ANC83LA051.md): Cessna 150M · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Mar 3, 1983 · N704VT · Substantial damage > The student plt & his instructor had just completed a dual instruction flt & the student was on his 1st solo. He took off from the uncontrolled arpt which had snow on the rwy, except the middle 10 ft of the rwy was clear & dry. As the student was in the… - [NTSB NYC83FHJ01](https://openairdocs.org/ntsb/NYC83FHJ01.md): Harrison Volmer VJ-22 Amphibian · Schinnecock Bay, NY · Accident · Minor injuries · Final report · Feb 27, 1983 · N3509 · Substantial damage > While gaining speed on step to make water takeoff the hull of the aircraft collided with something not seen in the waterand began to sink. The aircraft filled with water and sank until it rested on the bottom with only the prop tip showing the weather was VFR… - [NTSB DEN83LA094](https://openairdocs.org/ntsb/DEN83LA094.md): Bellanca 7GCBC · Havre, MT · Accident · No injuries · Limited investigation · Final report · Feb 26, 1983 · N7917S · Substantial damage > The plt reported that he was taking off from a dirt strip on his farm to check on some cattle from the air. During the takeoff roll, the left main gear went into some mud & pulled the acft to the left. Subsequently, the acft contacted frozen dirt piles & some… - [NTSB FTW83LA129](https://openairdocs.org/ntsb/FTW83LA129.md): Piper PA-28-140 · Midlothian, TX · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N6164W · Substantial damage > While on a local flt, the plt noticed fluctuating oil pressure & elected to make a precautionary landing in a field. He stated that after landing, he checked the oil & ran up the eng, but noted no malfunctions, so he elected to takeoff again. While attempting… - [NTSB DEN83LA066](https://openairdocs.org/ntsb/DEN83LA066.md): Piper PA-38-112 · Cut Bank, MT · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N9929T · Substantial damage > The acft nosed over after overrunning the end of the runway during an aborted takeoff. The runway was grass and there was a 90 degree crosswind. During takeoff a downdraft put the acft back on the ground. The pilot decided to abort the takeoff and retarded… - [NTSB FTW83LA127](https://openairdocs.org/ntsb/FTW83LA127.md): Cessna 152 · Sugarland, TX · Accident · No injuries · Limited investigation · Final report · Feb 23, 1983 · N66730 · Substantial damage > The student plt had become lost & landed on a dirt road to ask for directions back to his home arpt. After receiving directions, he turned the acft around & started to takeoff. However, before reaching flying speed, the acft struck a partially buried pipe &… - [NTSB NYC83LA069](https://openairdocs.org/ntsb/NYC83LA069.md): Cessna 152 · Mountville, PA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N757ER · Substantial damage > The turf rwy was wet from melting snow with snowbanks on both sides. The plt decided to take off from the left side staying clear of mud. Acceleration was slower than normal due to the wet grass & as the plt tried to rotate a loud bang was heard. The plt… - [NTSB NYC83LA067](https://openairdocs.org/ntsb/NYC83LA067.md): Mooney M20E · Butler, PA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N2694W · Substantial damage > After landing on rwy 25 the plt exited onto a taxiway near midfield to wait for another acft departing rwy 7. The wind was calm & the plt elected to depart rwy 7 as did the other acft. The gear was prematurely retracted during the takeoff roll. - [NTSB LAX83FA104](https://openairdocs.org/ntsb/LAX83FA104.md): Piper 601P · San Diego, CA · Accident · 5 fatal · Field investigation · Final report · Feb 18, 1983 · N90353 · Destroyed > While taking off, the acft climbed aprx 100 to 200 ft, then began loosing alt. During a forced landing on a street, it hit a parked car & a light pole & burst in flames. The plt, who later expired, said that neither eng developed full power (2575 RPM). He… - [NTSB FTW83LA120](https://openairdocs.org/ntsb/FTW83LA120.md): Piper PA-28-140 · Winslow, AR · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 1983 · N9981W · Substantial damage > During dual instructional flt, the student plt was practicing a short field takeoff. After lifting off into ground effect, he elected to abort the takeoff when he did not think the acft was accelerating fast enough. The instructor pilot (CFI) stated that he… - [NTSB ATL83LA107](https://openairdocs.org/ntsb/ATL83LA107.md): Piper PA-32R-301 · Leonardtown, MD · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N8425T · Substantial damage > Pilot did not maintain alignment during takeoff and collided with a pile driver. The aircraft was then landed gear up inan adjacent field. The wind was calm and there was no known reason for failure to maintain runway alignment. - [NTSB MIA83FA074](https://openairdocs.org/ntsb/MIA83FA074.md): Rockwell 690A · Winter Haven, FL · Accident · 2 fatal · Field investigation · Final report · Feb 13, 1983 · N81416 · Destroyed > The acft crashed into a ditch off the departure end of the rwy and burst into flames during takeoff. Witnesses said the acft did not sound like it was developing normal RPM for takeoff. One mechanic said the engines sounded like they were still in ground idle… - [NTSB CHI83LA115](https://openairdocs.org/ntsb/CHI83LA115.md): Cessna 152 · Bellefontaine, OH · Accident · No injuries · Limited investigation · Final report · Feb 13, 1983 · N5089P · Substantial damage > The acft ground looped off the runway during a takeoff. The solo student said he encountered nosewheel shimmy during thetakeoff roll. He raised the nose to stop the shimmy and looked at his airspeed indicator. At about that time, the acft weathervaned to the… - [NTSB ANC83FAG04](https://openairdocs.org/ntsb/ANC83FAG04.md): Cessna 140 · Iliamna, AK · Accident · No injuries · Final report · Feb 12, 1983 · N7G · Substantial damage > The aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a… - [NTSB ATL83LA101](https://openairdocs.org/ntsb/ATL83LA101.md): Beech H18 · Talladega, AL · Accident · No injuries · Limited investigation · Final report · Feb 11, 1983 · N1461G · Substantial damage > The plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as… - [NTSB ANC83IA044](https://openairdocs.org/ntsb/ANC83IA044.md): Cessna 207A · Kwigillingok, AK · Incident · No injuries · Incident investigation · Final report · Feb 9, 1983 · N75551 · Minor damage > While on takeoff the right main landing gear broke through the crust of a snow drift. The aircraft then veered to the right into a snowbank. - [NTSB ANC83IA043](https://openairdocs.org/ntsb/ANC83IA043.md): Cessna 207A · Kivalina, AK · Incident · No injuries · Incident investigation · Final report · Feb 9, 1983 · N73100 · Minor damage > The acft departed the left side of the runway on its takeoff roll due to misting or frosting of the windshield reducing visibility. The phenomenon is common to the area. The rwy is in poor condition with precautions to use the center only for takeoff &… - [NTSB LAX83LA094](https://openairdocs.org/ntsb/LAX83LA094.md): Piper PA-32 · So. Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1983 · N4069R · Substantial damage > The takeoff was initiated downwind on runway 36, which was 8544 ft long and was wet. The field elevation was 6264 ft. the aircraft was observed by tower personnel to rotate about 3000 ft down the runway, then climb to about 50 ft AGL. The pilot elected to… - [NTSB MIA83LA067](https://openairdocs.org/ntsb/MIA83LA067.md): Pace THORP-T-18 · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Jan 31, 1983 · N679JB · Substantial damage > The acft drifted left during takeoff and collided with a VASI light. The pilot stated to a witness that he knew he was going left but thought he would be airborne before leaving the runway. The left rudder cable was frayed and broke sometime in the takeoff… - [NTSB ATL83LA094](https://openairdocs.org/ntsb/ATL83LA094.md): Robinson R-22 · Dyersburg, TN · Accident · No injuries · Limited investigation · Final report · Jan 31, 1983 · N9069N · Substantial damage > The helicopter crashed shortly after takeoff on a solo training flight. The weather was VMC and no flight plan was filed. The pilot was uninjured. The pilot lost directional control at liftoff and started drifting toward parked acft. He attempted to go over… - [NTSB NYC83LA058](https://openairdocs.org/ntsb/NYC83LA058.md): Cessna 172P · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Jan 30, 1983 · N62264 · Substantial damage > After practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane… - [NTSB LAX83LA086](https://openairdocs.org/ntsb/LAX83LA086.md): Cessna 172N · Lake Wohlford, CA · Accident · No injuries · Limited investigation · Final report · Jan 30, 1983 · N517OK · Substantial damage > The acft ran off the departure end of the runway during an aborted takeoff and nosed over. The pilot started a takeoff on a 1500 foot dry runway. After about 1000 feet of runway had been used the pilot decided to abort the takeoff. Brakes were applied and the… - [NTSB NYC83LA057](https://openairdocs.org/ntsb/NYC83LA057.md): Cessna 152 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Jan 28, 1983 · N6279P · Substantial damage > The student plt was taking off on rwy 08 with a wind from the northeast at 11 KTS. He reported that he was aprx 100 ft into the takeoff roll when the acft swerved to the left. Subsequently, the acft collided with a snowbank on the left edge of the rwy. - [NTSB FTW83LA099](https://openairdocs.org/ntsb/FTW83LA099.md): Bell 206L-1 · Grand Isle B43q · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1983 · N5012T · Substantial damage > Due to the location of a gas separator, the plt started to takeoff from an oil rig platform with a left cross- wind at aprx 30 KTS, gusting 35 to 40 KTS. After lifting off to a hover, wind gusts were encountered. The plt reported that the acft turned 10 to 15… - [NTSB CHI83FA092](https://openairdocs.org/ntsb/CHI83FA092.md): Obryon Mustang II · West Chicago, IL · Accident · No injuries · Field investigation · Final report · Jan 26, 1983 · N77HJ · Substantial damage > The home built acft was on its 1st flt after being constructed. The takeoff was initiated on rwy 33 with the wind from 030 deg at 10 KTS. The plt reported that during the takeoff, the right wing lifted, but the left wing would not come up. When control became… - [NTSB LAX83LA078](https://openairdocs.org/ntsb/LAX83LA078.md): Stinson 108-2 · Yucca Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 1983 · N9923K · Destroyed > The pilot was attempting a takeoff from Yucca Valley airport when he lost control of the aircraft and it swerved off therunway into a wash where it flipped over onto its back. The pilot said he encountered a dust devil which made the aircraft uncontrollable.… - [NTSB NYC83LA053](https://openairdocs.org/ntsb/NYC83LA053.md): Israel Aircraft Industries 1124 · New Cumberland, PA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1983 · N250RA · Substantial damage > During the takeoff roll at about 117 KTS, the acft began to vibrate, pull to the left and decelerate. The takeoff was aborted. The acft continued off the left side of the rwy and came to stop against a small embankment. An exam of the rwy reveal tire markings… - [NTSB LAX83LA075](https://openairdocs.org/ntsb/LAX83LA075.md): Cessna 188 · Five Points, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1983 · N5636J · Substantial damage > The pilot lost control of his aircraft during takeoff in a cross wind. The aircraft ground looped collapsed the right main landing gear and nosed over. The agricultural operations were canceled at this provisional strip because of wind and the aircraft was… - [NTSB DEN83FA049](https://openairdocs.org/ntsb/DEN83FA049.md): Robinson R22 · Sisseton, SD · Accident · 1 fatal · Field investigation · Final report · Jan 15, 1983 · N9079B · Destroyed > The helicopter crashed in an open field shortly after takeoff in adverse weather. The pilot was not instrument rated andhad received weather briefings by telephone from a flight service station. The forecast was not favorable, but the pilotstated 'well I… - [NTSB SEA83FA040](https://openairdocs.org/ntsb/SEA83FA040.md): Bell 206B · Newport, OR · Accident · No injuries · Field investigation · Final report · Jan 12, 1983 · N644PH · Substantial damage > The helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a… - [NTSB FTW83LA081](https://openairdocs.org/ntsb/FTW83LA081.md): Cessna 170A · Temple, TX · Accident · No injuries · Limited investigation · Final report · Jan 11, 1983 · N1781D · Substantial damage > The student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed. - [NTSB ATL83LA087](https://openairdocs.org/ntsb/ATL83LA087.md): Lockheed 18-56 · Madison, GA · Accident · No injuries · Limited investigation · Final report · Jan 11, 1983 · N520R · Substantial damage > The plt reported that after he taxied to the rwy, the #1 oil temp was not up to the minimum temp. He set the parking & advanced the #1 throttle to 1500 RPM until the engine warmed up. When both oil temps were within limits, he advanced both throttles to 30… - [NTSB ANC84LA001](https://openairdocs.org/ntsb/ANC84LA001.md): Cessna 185 · Togiak, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 6, 1983 · N4924E · Substantial damage > According to the plt, he was assisted by a wing walker while taxiing to the takeoff position. The wind had been increasing steadily during his stop & it changed direction as he arrived at the takeoff position. As he turned the acft into position on rwy 27,… - [NTSB FTW83LA073](https://openairdocs.org/ntsb/FTW83LA073.md): Beech V-35B · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Jan 2, 1983 · N9435Q · Substantial damage > The aircraft crashed shortly after takeoff from a slush-covered runway. The pilot stated that preflight, engine start, taxi and run up were normal. He further stated that takeoff from the slush covered runway was routine to an altutide of approx 200 ft AGL… - [NTSB MKC83LA050](https://openairdocs.org/ntsb/MKC83LA050.md): Cessna 182P · Maryville, MO · Accident · No injuries · Limited investigation · Final report · Jan 1, 1983 · N58664 · Substantial damage > Aircraft ran off runway during takeoff. Pilot said he was unable to control veer and the aircraft continued off into soft terrain and nosed down. - [NTSB ANC83LAG01](https://openairdocs.org/ntsb/ANC83LAG01.md): Cessna 152 · Chugiak, AK · Accident · No injuries · Final report · Dec 31, 1982 · N68291 · Substantial damage > The student pilot reported that he was practicing touch-and-go landings on a runway with patches of ice. He stated that on his second touch-and-go, he touched down to the right of the centerline. Reportedly, he retracted the flaps, added full power, and… - [NTSB ANC83LA038](https://openairdocs.org/ntsb/ANC83LA038.md): Piper PA-32 · Nunapitchuk, AK · Accident · No injuries · Limited investigation · Final report · Dec 31, 1982 · N4246T · Substantial damage > The aircraft was taking off from a frozen seaplane landing area when it struck several snow banks and crashed. The pilot stated that he had selected an area of ice, about 1100 ft long, and began taking off in an 8 kt crosswind with 6 passengers on board.… - [NTSB MIA83FA054](https://openairdocs.org/ntsb/MIA83FA054.md): Cessna 310R · Ft. Lauderdale, FL · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1982 · N4055C · Destroyed > The aircraft crashed while the pilot was apparently attempting to return to land after takeoff. No radio calls were made, but landing gear had been lowered. High speed and excessive rate of descent are not consistant with a normal or even emergency attempt to… - [NTSB ATL83LA074](https://openairdocs.org/ntsb/ATL83LA074.md): Piper PA-28-140 · Nelly'S Ford, VA · Accident · No injuries · Limited investigation · Final report · Dec 25, 1982 · N32804 · Substantial damage > During takeoff roll the aircraft swerved to the left. The pilot applied full right rudder but was not able to straighten the aircraft. The pilot reduced the power and applied brakes. The aircraft collided with a fence at the end of the runway. Fifteen knot… - [NTSB SEA83IA034](https://openairdocs.org/ntsb/SEA83IA034.md): Swearingen SA-226TC · Klamath Falls, OR · Incident · No injuries · Incident investigation · Final report · Dec 23, 1982 · N5475M · Minor damage > During takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires… - [NTSB ATL83LA072](https://openairdocs.org/ntsb/ATL83LA072.md): Cessna 152 · Ft. Benning, GA · Accident · No injuries · Limited investigation · Final report · Dec 23, 1982 · N129SC · Substantial damage > Student was doing a touch and go landing. While changing flap, carb heat and applying full throttle aircraft veered left. Recovery was attempted throttle off but aircraft left runway and collapsed nose gear, before flipping over. - [NTSB NYC83LA046](https://openairdocs.org/ntsb/NYC83LA046.md): Beech 56TC · Gasport, NY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1982 · N12WB · Substantial damage > During the takeoff roll from a snow covered runway the aircraft slid to the left of the runway and into a snow bank. The left main and nose gear collapsed. - [NTSB DEN83LA036](https://openairdocs.org/ntsb/DEN83LA036.md): Swearingen SA-227AC · Gillette, WY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1982 · N2671V · Substantial damage > Directional control was lost in the early stage of the takeoff roll. The acft departed the rwy 400 ft down the rwy & travelled 85 ft off the side of the rwy. One rwy light was destroyed. The acft had come from the factory equipped with an anti-skid brake… - [NTSB LAX83LVW02](https://openairdocs.org/ntsb/LAX83LVW02.md): Piper PA-28-161 · Beatty, NV · Accident · No injuries · Final report · Dec 19, 1982 · N8154X · Substantial damage > The pilot landed on a 1700 long strip at the elevation of about 3500 ft MSL. He elected to takeoff to the north in calm wind conditions and avoid sun glare off the cover of his engine and on the windshield. He stated that soft field procedures were used in… - [NTSB MIA83LA052](https://openairdocs.org/ntsb/MIA83LA052.md): Bellanca 7GCBC · New Port Richey, FL · Accident · No injuries · Limited investigation · Final report · Dec 18, 1982 · N88214 · Substantial damage > According to the instructor (CFI), the tail wheel equipped aircraft veered left and headed toward trees after the tail rose, but while the main wheels were still on the ground. He attempted to recover with right rudder and brakes. Fearing a ground loop, the… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=157 ## 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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=156 --- 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.