# 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 151 of 281 · 14,038 cases ## Cases, newest first - [NTSB SEA84LA073](https://openairdocs.org/ntsb/SEA84LA073.md): Cessna 152II · Preston, ID · Accident · No injuries · Limited investigation · Final report · Mar 16, 1984 · N48757 · Substantial damage > The solo student plt was making a takeoff after a touch-and-go landing. The acft swerved to the left, collided with a snowbank, and nosed over. - [NTSB DEN84LA110](https://openairdocs.org/ntsb/DEN84LA110.md): Hiller FH 1100 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Mar 16, 1984 · N5042F · Substantial damage > The acft was landed in soggy terrain and the right skid sank into the surface. One of the occupants of the helicopter deplaned to'lighten the load'and the plt overcorrected in an attempt to takeoff. The acrt rolled over onto its left side. - [NTSB LAX84IA219](https://openairdocs.org/ntsb/LAX84IA219.md): Beech C-45G · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Mar 15, 1984 · N3657G · No damage > A Beech E18S, N3657G, operating as federal express flt 954L, was cleared for takeoff on rwy 8L after a Boeing 747, N8172G, operating as interflight 429, was cleared to cross the same rwy. The Boeing 747'S cargo included race horses. The Boeing crew were… - [NTSB ATL84LA121](https://openairdocs.org/ntsb/ATL84LA121.md): Piper PA-23-250 · Warrenton, VA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N63857 · Substantial damage > The CFI shut down one engine during takeoff for a simulated emergency and the plt taking instruction applied the incorrect rudder action during the aborted takeoff and left full power on the operating right engine. The CFI was unableto correct the resulting… - [NTSB ATL84LA139](https://openairdocs.org/ntsb/ATL84LA139.md): Cessna 150F · Bardstown, KY · Accident · No injuries · Limited investigation · Final report · Mar 14, 1984 · N7717F · Substantial damage > The CFI flew one pattern with the student and sent him solo. During the attempted takeoff the acft veered off the rwy & hit a dirt bank. The student said the rudder pedals would not move. Reportedly a wrench was found jammed in the rudder pedals. Some… - [NTSB FTW84LA173](https://openairdocs.org/ntsb/FTW84LA173.md): Stinson 108-3 · Blanco, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1984 · N4004C · Destroyed > According to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2… - [NTSB ANC84FA043](https://openairdocs.org/ntsb/ANC84FA043.md): Cessna 207A · Crooked Creek, AK · Accident · Minor injuries · Field investigation · Final report · Mar 12, 1984 · N7350U · Substantial damage > The plt was using soft field procedures to takeoff from a 1600 ft dirt/gravel strip. The strip was wet & soft from melting snow, it sloped downhill with a 3% slope & 15 to 20 ft trees were located at the departure end. Also, the plt reported there were 3… - [NTSB LAX84LA218](https://openairdocs.org/ntsb/LAX84LA218.md): Piper PA-38-112 · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1984 · N23882 · Substantial damage > The student plt had previously soloed on 12/4/83 & had accumulated about 30 hrs of total time of which 3.7 hrs were solo. Just prior to the accident flt, the student's instructor had flown with him & he had completed 4 landings on that flt. The student then… - [NTSB CHI84LA126](https://openairdocs.org/ntsb/CHI84LA126.md): Beech BE-90 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Mar 11, 1984 · N642DH · Substantial damage > While taking off on rwy 27L, the acft contacted a ridge of snow at the intersection of rwy 14, where rwy 14 had been plowed. After striking the snow, the acft drifted to the right & the plt noted a reduction of power from the right eng. The right main gear… - [NTSB LAX84LA214](https://openairdocs.org/ntsb/LAX84LA214.md): Cessna 182P · Willcox, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1984 · N52488 · Destroyed > An unknown person attempted to steal the acft. The acft was taxied out from its tie-down spot & accelerated down the mile-long dirt rwy. It failed to become airborne, impacted 5 fences, a power pole & came to rest inverted. The injury index is presumed. - [NTSB FTW84LA162](https://openairdocs.org/ntsb/FTW84LA162.md): Cessna A185F · Braithwaite, LA · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1984 · N7368H · Substantial damage > The plt said that when he applied power for takeoff he overcorrected and the acft veered right. He attempted to abort but saw a ditch and reapplied power. The acft hit the ditch and collapsed the landing gear. The plt thought maybe the brakes locked but an… - [NTSB NYC84FA096](https://openairdocs.org/ntsb/NYC84FA096.md): Cessna A185F · Waitsfield, VT · Accident · Serious injuries · Field investigation · Final report · Mar 2, 1984 · N4643C · Destroyed > The acft collided with trees during takeoff. The rwy was snow covered 4 to 6 inches deep and was only 1800 ft long. The takeoff was on a bearing of 130 degrees. The wind was from 280 degrees at 14 KTS. The skis on the acft had wheels protruding through at the… - [NTSB MKC84LA090](https://openairdocs.org/ntsb/MKC84LA090.md): Robert H. Low Mustang II · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N53BL · Substantial damage > One of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using… - [NTSB LAX84LA192](https://openairdocs.org/ntsb/LAX84LA192.md): Cessna 152 · Watsonville, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1984 · N24971 · Substantial damage > The acft ran off the left side of the rwy during the takeoff portion of a touch and go landing. After colliding with a ditch the acft nosed over. - [NTSB LAX84IA188](https://openairdocs.org/ntsb/LAX84IA188.md): Cessna 152 · Riverside, CA · Incident · No injuries · Incident investigation · Final report · Feb 21, 1984 · N6496M · 2 aircraft · Minor damage > N6496M executed a takeoff on taxiway 'a' & collided with Cessna N7831F holding short of rwy 09 at taxiway 'h'. - [NTSB MKC84LA078](https://openairdocs.org/ntsb/MKC84LA078.md): Gulfstream American AA5B · Papillion, NE · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N28673 · Substantial damage > The plt overran during an attempted takeoff on the water covered rwy. The acft failed to attain the proper airspeed for lift off. During the overrun the nose gear sheared off. The plt said the standing water on the turf rwy prevented proper acceleration. - [NTSB NYC84LA086](https://openairdocs.org/ntsb/NYC84LA086.md): Piper PA-18 · Hastings, NY · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N3264P · Substantial damage > The acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear… - [NTSB CHI84LA109](https://openairdocs.org/ntsb/CHI84LA109.md): Mooney M20E · Cleveland, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1984 · N1987Y · Substantial damage > The passenger reported that on takeoff he heard a bang & saw a puff of blue smoke. The plt pulled the pwr off but did not lower the nose so the passenger, who had flt experience, pushed the nose forward & impacted the rwy. Post crash examination of the eng… - [NTSB SEA84LA053](https://openairdocs.org/ntsb/SEA84LA053.md): Piper PA-34-200 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N16333 · Substantial damage > On departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed. - [NTSB SEA84LA051](https://openairdocs.org/ntsb/SEA84LA051.md): Cessna 172 Rgii · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N9557B · Substantial damage > During a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft… - [NTSB DEN84LA088](https://openairdocs.org/ntsb/DEN84LA088.md): Mooney M20C · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N6210U · Substantial damage > The plt reported that during takeoff, the acft slowed as it hit patches of slush. He lifted off at the end of the rwy & retracted the gear while in ground effect. The acft would not maintain flying speed & settled in snow. It then went thru a fence beyond the… - [NTSB CHI84LA103](https://openairdocs.org/ntsb/CHI84LA103.md): Cessna 177RG · Logansport, IN · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1984 · N2514V · Substantial damage > The plt stated that the acft eng was running rough at rotation. He climbed to approx 300 ft AGL and began a left trafficpattern back to rwy 27. A landing was made 225 ft short of the rwy. During the post-accident eng run-up the eng started easily and ran… - [NTSB DEN84LA084](https://openairdocs.org/ntsb/DEN84LA084.md): Piper PA-22-135 · Dixon, WY · Accident · No injuries · Limited investigation · Final report · Feb 3, 1984 · N3553A · Substantial damage > The acft began to wander back & forth across the rwy on the takeoff roll. The CFI took control as the acft veered to theleft. The left wheel hit a snowbank & the acft ground looped to the left substantially damaging the right wing before coming to rest. There… - [NTSB DEN84LA080](https://openairdocs.org/ntsb/DEN84LA080.md): Bellanca 17-30A · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Feb 1, 1984 · N4096B · Substantial damage > The plt noticed the throttle sticking on takeoff and tried to abort the takeoff but the throttle was binding. The acft tookoff at a below normal speed and had to be landed. Subsequently, the acft impacted the ground & several trees. An engineer said the… - [NTSB CHI84LA131](https://openairdocs.org/ntsb/CHI84LA131.md): Cessna 152 · Lone Rock, WI · Accident · No injuries · Limited investigation · Final report · Jan 31, 1984 · N25216 · Substantial damage > During the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over. - [NTSB DEN84LA078](https://openairdocs.org/ntsb/DEN84LA078.md): Piper J3C-65 · Billings, MT · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 1984 · N6741H · Substantial damage > The plt stated that during takeoff a gust of wind blew the acft to the right and he decided to abort the takeoff. Duringthe abort the acft departed the rwy, went down a bank and came to rest upside down. - [NTSB DCA84AA015](https://openairdocs.org/ntsb/DCA84AA015.md): Swearingen SA226TC · Terre Haute, IN · Accident · 3 fatal · Final report · Jan 30, 1984 · N63Z · Destroyed > After taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a… - [NTSB LAX84LA172](https://openairdocs.org/ntsb/LAX84LA172.md): Bell 206L-1 · Camarillo, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1984 · N2045U · Destroyed > According to witnesses, the plt had been drinking & decided to prove to his friends that he could fly a helicopter. Reportedly, he 'threw on a bunch of switches, and got the engine started.' When he attempted the takeoff, the helicopter rolled over on its… - [NTSB NYC84LA076](https://openairdocs.org/ntsb/NYC84LA076.md): Robinson R-22 · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Jan 27, 1984 · N8431Y · Substantial damage > The helicopter left skid hooked on the guard rail as takeoff began from a trailer. As the plt continued to increase power to lift, the acft rolled over and the main rotor hit the hood of the tractor. - [NTSB CHI84LA096](https://openairdocs.org/ntsb/CHI84LA096.md): Cessna 150M · West Bend, WI · Accident · No injuries · Limited investigation · Final report · Jan 26, 1984 · N63178 · Substantial damage > The acft went out of control during the takeoff roll after a touch and go landing. The plt stated that, as he applied power and went to raise the flaps the acft began to drift to the left. When he applied right rudder the acft began to skid to the right. He… - [NTSB CHI84IA093](https://openairdocs.org/ntsb/CHI84IA093.md): Mcdonnell Douglas DC-8-61 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jan 24, 1984 · N8081U · Minor damage > As the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.… - [NTSB SEA84LA041](https://openairdocs.org/ntsb/SEA84LA041.md): Piper PA-18-135 · Klamath Falls, OR · Accident · No injuries · Limited investigation · Final report · Jan 22, 1984 · N99620 · Substantial damage > The plt attempted a takeoff on a slushy soft rwy. The takeoff was aborted at the rwy midpoint due to lack of acceleration. During the abort the acft collided with a fence and nosed over. The plt thought the rwy conditions and carburetor ice. - [NTSB NYC84IA071](https://openairdocs.org/ntsb/NYC84IA071.md): Boeing 747-230 · Jamaica, NY · Incident · Serious injuries · Incident investigation · Final report · Jan 18, 1984 · DABYO · No damage > At the time of the incident, rwy 31L was the only active rwy. Aprx 9 snow removal vehicles were being used to remove snow from rwy 4L/22R. The vehicle drivers were instructed to hold short of rwy 31L, then Boeing 747, d-abyo, was cleared for takeoff. The plt… - [NTSB ATL84LA085](https://openairdocs.org/ntsb/ATL84LA085.md): Piper PA-34-220T · Beckley, WV · Accident · No injuries · Limited investigation · Final report · Jan 18, 1984 · N8461H · Substantial damage > During the takeoff roll the acft traveled about 2400 ft before starting a drift to the left. It covered another 425 ft prior to colliding with a snow bank shearing off the nose gear & collapsing both main landing gear. The rwy was covered with about 4 inches… - [NTSB CHI84LA085](https://openairdocs.org/ntsb/CHI84LA085.md): Cessna 140 · Huntley, IL · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N76310 · Substantial damage > The student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision… - [NTSB MIA84LA061](https://openairdocs.org/ntsb/MIA84LA061.md): Piper J3C-65 · Pensacola, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1984 · N42774 · Substantial damage > During takeoff, the eng began losing power at about 200 ft AGL. The plt applied carb heat & began a descent. Power was restored for about 5 sec, then all power was lost. The acft was landed straight ahead in a wooden swampy area & was substantially damaged.… - [NTSB LAX84LA137](https://openairdocs.org/ntsb/LAX84LA137.md): Rockwell 114 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jan 11, 1984 · N50BG · Substantial damage > The acft veered off the rwy in a strong gusty crosswind. As the acft left the rwy the landing gear collapsed. The plt stated that she over-corrected having never attempted a takeoff in wind that strong. - [NTSB CHI84LA084](https://openairdocs.org/ntsb/CHI84LA084.md): Cessna 150 · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · Jan 11, 1984 · N63546 · Substantial damage > The student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This… - [NTSB DEN84LA101](https://openairdocs.org/ntsb/DEN84LA101.md): Maule M-5-210C · Fortuna, ND · Accident · No injuries · Limited investigation · Final report · Jan 4, 1984 · N314X · Substantial damage > The plt made an off arpt landing on upward sloping terrain which was covered with aprx 4 inches of snow. About 1/2 hr later, he initiated a takeoff on a different section of the field on downward sloping terrain. The snow in that area was initially 4 inches… - [NTSB LAX84LA128](https://openairdocs.org/ntsb/LAX84LA128.md): Beech C-45H · Coolidge, AZ · Accident · No injuries · Limited investigation · Final report · Jan 2, 1984 · N3736G · Substantial damage > The plt stated that during the initial application of power, the left eng backfired due to a possible too sudden application of power. He said that due to 'inattention' he let the acft 'drift to the left side of the runway.' Just after the acft became… - [NTSB DEN84LA061](https://openairdocs.org/ntsb/DEN84LA061.md): Cessna 150L · Limon, CO · Accident · No injuries · Limited investigation · Final report · Jan 2, 1984 · N1667Q · Substantial damage > The student plt on his 2nd supervised solo flt. After returning from te local practice area, he entered the traffic pattern for a touch-&-go landing. When he added power for the takeoff portion. The acft veered to the left. The left main wheel entered deeper… - [NTSB MKC84LA055](https://openairdocs.org/ntsb/MKC84LA055.md): Mooney M20C · Pittsburg, MO · Accident · No injuries · Limited investigation · Final report · Jan 1, 1984 · N2998L · Substantial damage > The acft ran off of the snow covered rwy into trees after an attempted downwind takeoff. The plt had packed the 8 inch snow by driving his car on the rwy. During the aborted takeoff the plt was unable to stop the acft before tree contact. - [NTSB MKC84LA054](https://openairdocs.org/ntsb/MKC84LA054.md): Cessna 182 · Marion, IA · Accident · No injuries · Limited investigation · Final report · Jan 1, 1984 · N3641C · Substantial damage > The acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted. - [NTSB NYC84LA062](https://openairdocs.org/ntsb/NYC84LA062.md): Piper PA-23-250 · West Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N14360 · Substantial damage > During the cockpit preflight the plt noticed an unsafe nose gear indication. The plt checked the nose gear & could see nothing unusual, & concluded that there was a faulty indicating system. During rotation the nose gear collapsed & this acft slid down the… - [NTSB CHI84LA068](https://openairdocs.org/ntsb/CHI84LA068.md): Piper PA-23-250 · Michigan City, IN · Accident · No injuries · Limited investigation · Final report · Dec 28, 1983 · N54828 · Substantial damage > The acft ran off the snow covered rwy into soft ground and collapsed the nose gear. The plt said that during acceleration for takeoff he felt the left main landing gear go off the left side of the rwy. He reduced power but by this time the gear was in soft… - [NTSB NYC84FA061](https://openairdocs.org/ntsb/NYC84FA061.md): Aerospatiale SA-360C · Newark, NJ · Accident · Serious injuries · Field investigation · Final report · Dec 27, 1983 · N360CP · Substantial damage > The helicopter arrived at the Newark intl arpt at 1531 after an uneventful flt from new york, NY with 2 en route stops. At 1540, the plt taxied from the passenger gate for departure. According to him, he had no control problems, while taxiing. He checked the… - [NTSB MIA84LA050](https://openairdocs.org/ntsb/MIA84LA050.md): Cessna 210 · Ft. Myers, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1983 · N9510T · Destroyed > During tkof roll abt halfway down the rwy the plt noticed the acft was not accelerating normally. Aft liftoff he atmptd to return to the arpt however was forced to ditch the acft in the caloosahatche river due to a loss of pwr. Exam of the eng revealed that… - [NTSB DCA84AA013](https://openairdocs.org/ntsb/DCA84AA013.md): McDonnell Douglas DC-10-30CF · Anchorage, AK · Accident · Serious injuries · Final report · Dec 23, 1983 · H7339 · 2 aircraft · Destroyed > A Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited… - [NTSB LAX84LA110](https://openairdocs.org/ntsb/LAX84LA110.md): Cessna 180K · Santa Rosa Island, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1983 · N2697K · Substantial damage > According to the plt, the nose of the acft felt heavy just before lift-off & when he became airborne. He felt something was wrong with the tail of the acft & that he was unable to obtain full elevator response, so he aborted the takeoff. The acft rolled 300… - [NTSB MKC84LA043](https://openairdocs.org/ntsb/MKC84LA043.md): Gates Learjet 25 · Kansas City, KS · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N242AG · Substantial damage > During takeoff on a snow covered rwy at night the aircraft ran off the left side of the runway & was damaged. At that time, the rwy was covered with a thin layer of dry snow over the top of hard packed snow. A 50 ft strip had previously been plowed along the… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=152 ## 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=151 --- 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.