# 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 152 of 281 · 14,038 cases ## Cases, newest first - [NTSB MKC84IA040](https://openairdocs.org/ntsb/MKC84IA040.md): Douglas DC-9-15 · Wichita, KS · Incident · No injuries · Incident investigation · Final report · Dec 18, 1983 · N968E · No damage > A catastrophic (uncontainted) failure of the left engine occurred at the beginning of the takeoff roll. The takeoff was aborted & fire erupted on the taxi back to the gate. Investigation revealed a broken turbine long shaft. - [NTSB CHI84LA064](https://openairdocs.org/ntsb/CHI84LA064.md): Cessna 421 · Harbor Springs, MI · Accident · No injuries · Limited investigation · Final report · Dec 17, 1983 · N7557Q · Substantial damage > The plt stated that an overboost occurred on the right eng during the takeoff roll. He pulled off power on both engs but the acft slid off the rwy into a snowbank. - [NTSB ATL84IA065](https://openairdocs.org/ntsb/ATL84IA065.md): Sabreliner NA-265-80 · Cherry Point, NC · Incident · No injuries · Incident investigation · Final report · Dec 15, 1983 · N60 · Minor damage > The pilot's inadequate preflight planning/preparation. Factors contributing to the accident were fog, rain, and lightning. - [NTSB LAX84LA105](https://openairdocs.org/ntsb/LAX84LA105.md): Bell 206B · Supai, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1983 · N10MP · Substantial damage > The plt was transporting an external load of drywall panels when the acft's eng chip light illuminated. He set the load down & inspected the acft & eng. Finding nothing wrong, he reconnected the cable which was connected to the net containing the panels.… - [NTSB DEN84IA041](https://openairdocs.org/ntsb/DEN84IA041.md): Boeing 767 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Dec 9, 1983 · N613UA · No damage > On takeoff roll the no 3 wheel on the right main landing gear fell off the acft. The acft returned and landed without further incident. The wheel bearing was found faileddue to cosmoline contamination. - [NTSB CHI84FA053](https://openairdocs.org/ntsb/CHI84FA053.md): Cessna T210M · White Lk Twnshp, MI · Accident · 3 fatal · Field investigation · Final report · Dec 6, 1983 · N761RN · Destroyed > At about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the… - [NTSB ANC84LA021](https://openairdocs.org/ntsb/ANC84LA021.md): Piper PA-18 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Dec 1, 1983 · N5087Y · Substantial damage > The acft was taking off from an unimproved area covered by 2 inches of snow. At about 80 ft into the takeoff roll the acft bounced left into muskeg, collapsing the landing gear. - [NTSB ATL84FU002](https://openairdocs.org/ntsb/ATL84FU002.md): American Aerolights Double Eagle · Cape Carteret, NC · Accident · 1 fatal · Final report · Nov 30, 1983 · UNREG · Destroyed > Reportedly, the plt had previously flown in a 2 place ultralight vehicle, but had not flown in one that was equipped with a canard. He indicated to the owner that he would like to taxi the ultralight. The owner obliged after explaining the operation of the… - [NTSB FTW84LA079](https://openairdocs.org/ntsb/FTW84LA079.md): Cessna 140 · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1983 · N76119 · Substantial damage > This was to be the student's first flt & the CFI had him follow through on the controls. As the tail came off the rwy the student began overpowering the CFI at the controls. The CFI was unable to maintain directional control & the acft went off the rwy into a… - [NTSB LAX84LA080](https://openairdocs.org/ntsb/LAX84LA080.md): Cessna 180A · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1983 · N5016E · Substantial damage > While departing, the acft began veering left as the tailwheel came off the ground during the takeoff roll. It rolled onto a hard dirt shoulder to the left of the asphalt rwy. The plt reported that he corrected the drift by applying right rudder & the acft… - [NTSB CHI84LA066](https://openairdocs.org/ntsb/CHI84LA066.md): Stinson 108-3 · La Porte, IN · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1983 · N6881M · Substantial damage > The acft veered off the rwy, hit a ditch and nosed over during takeoff. The plt reported that he lost control of the acft during the takeoff roll and it ran off the side of the rwy into an open field and nosed over. - [NTSB MKC84LA030](https://openairdocs.org/ntsb/MKC84LA030.md): Cessna 172 · Hampton, IA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N7737U · Substantial damage > On his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA… - [NTSB DEN84LA029](https://openairdocs.org/ntsb/DEN84LA029.md): Piper PA-18-180 · Colorado Spgs, CO · Accident · No injuries · Limited investigation · Final report · Nov 19, 1983 · N3594P · 2 aircraft · Substantial damage > The Piper PA-18, N3594P, was being used to tow a burkhart grob flugzeugbau G103 twin astir, N4246L. At 0950 MST, the wind was reported from 310 deg at 9 KTS. Since the terrain sloped downhill to the south, rwy 17R (covered with hard packed snow) was being… - [NTSB MKC84LA026](https://openairdocs.org/ntsb/MKC84LA026.md): Cessna 180A · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Nov 17, 1983 · N7814A · Substantial damage > The acft veered off the rwy into the grass and collapsed the main landing gear during takeoff. The pilots seat slid aft as the acft accelerated and the pilot lost control of the acft. The acft veered off the left side of the runway into the grass. The pilot… - [NTSB DEN84LA024](https://openairdocs.org/ntsb/DEN84LA024.md): Bellanca 17-31ATC · Crested Butte, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 1983 · N14780 · Substantial damage > According to the plt, the ground was covered with about 6 inches of light snow & the wind was from the southwest at 5 to 10 KTS. A snow plow preceeded him to the rwy & had cleared a strip about 10 to 12 ft wide on the 1st 1/3 of the rwy. When the plt was… - [NTSB FTW84LA054](https://openairdocs.org/ntsb/FTW84LA054.md): Cessna 182A · Sunsett, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1983 · N4829D · Substantial damage > During takeoff toward the sun on rwy 21 of the private strip, the plt allowed the acft to drift off the left side of the rwy. It then encountered an area of soft, sandy soil & nosed over. The plt stated that due sun glare off the windshield, he had difficulty… - [NTSB FTW84LA053](https://openairdocs.org/ntsb/FTW84LA053.md): Cessna 310Q · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Nov 8, 1983 · N218JW · Substantial damage > The plt was starting a flt to reposition the acft from the tradewind arpt to the Amarillo intl arpt. He reported that he had started to takeoff on rwy 17, then aborted to avoid a Cessna 182. He reported the Cessna 182 plt was crossing rwy 17, on his way to… - [NTSB MIA84IA025](https://openairdocs.org/ntsb/MIA84IA025.md): Airbus Industrie A-300B4-2C · Miami, FL · Incident · No injuries · Incident investigation · Final report · Nov 7, 1983 · N203EA · Minor damage > During takeoff ground roll the NO-4 tire failed followed by failures of the other surrounding tires. The takeoff was aborted and there was no fire. The fuse plug in the NO-4 tire was found partially melted. - [NTSB ANC84LA014](https://openairdocs.org/ntsb/ANC84LA014.md): Cessna 180 · Montague Island, AK · Accident · No injuries · Limited investigation · Final report · Nov 6, 1983 · N3311D · Substantial damage > The acft ground looped during takeoff from a beach on montaque Island. The acft had been parked on the beach and the water had been over the landing gear due to the tide. The plt did not consider that the wet brakes would not be effective if needed. There was… - [NTSB LAX84FU019](https://openairdocs.org/ntsb/LAX84FU019.md): Delts Wing Kites Lazor 170 · El Mirage, CA · Accident · 1 fatal · Final report · Nov 5, 1983 · UNREG · Destroyed > The weight shift controlled, ultralight vehicle had just recently been built. The owner & the plt had agreed that they would not attempt to fly the vehicle on the initial test. The plt was observed taxiing excessively fast, and reportedly, he made 1 or 2… - [NTSB FTW84LA042](https://openairdocs.org/ntsb/FTW84LA042.md): Cessna A185F · Freemason Is., LA · Accident · 1 fatal · Limited investigation · Final report · Nov 5, 1983 · N61394 · Destroyed > The acft was on the return leg of a fishing trip at night. According to the plt, the float plane lifted off after a fairly long run on smooth water. He stated that at 200 ft AGL & 90 KTS, he initiated a 10 to 15 deg right turn & rolled out on a heading of 350… - [NTSB FTW84LA063](https://openairdocs.org/ntsb/FTW84LA063.md): Cessna 180 · Slidell, LA · Accident · No injuries · Limited investigation · Final report · Nov 4, 1983 · N7812K · Substantial damage > The acft collided with submerged objects during takeoff. The takeoff was aborted and the acft ran up on the bayou bank where it collided with trees. - [NTSB ATL84LA032](https://openairdocs.org/ntsb/ATL84LA032.md): Piper PA-61P · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Oct 29, 1983 · N9531Q · Substantial damage > The plt stated that during the takeoff roll the airspeed had accelerated through 128 KTS, but as the takeoff continued the airspeed dropped to 115 KTS & remained between 100-115 KTS. After rotation the acft would not climb or accelerate above 100-115 KTS. The… - [NTSB LAX84LA031](https://openairdocs.org/ntsb/LAX84LA031.md): Piper PA-25-235 · New River, AZ · Accident · No injuries · Limited investigation · Final report · Oct 24, 1983 · N4361Y · Substantial damage > The tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.… - [NTSB NYC84FHD01](https://openairdocs.org/ntsb/NYC84FHD01.md): Beech 58P · Cheswold, DE · Accident · Serious injuries · Final report · Oct 22, 1983 · N2029Z · Destroyed > The plt reported that the western 1/3 of rwy 9 consisted of rough chat rock & packed soil. The remaining rwy surface consisted of asphalt. The plt elected to make a no-flap takeoff, using all of the rwy. He stated that due to the rough rwy surface, up… - [NTSB FTW84LA024](https://openairdocs.org/ntsb/FTW84LA024.md): Cessna 150M · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Oct 17, 1983 · N7041W · Substantial damage > The acft nosed over after leaving the rwy and colliding with a dirt bank during an attempted go-around. The CFI had just checked the student out for his first solo flight. He heard the acft power decrease and saw the acft heading off the rwy. The student then… - [NTSB CHI84FA022](https://openairdocs.org/ntsb/CHI84FA022.md): Piper PA-28-181 · Dodgeville, WI · Accident · Minor injuries · Field investigation · Final report · Oct 16, 1983 · N8419G · Destroyed > Momentarily after lifting off, the plt heard a pronounced decrease in eng noise & noted that the tachometer indication had dropped to 1950 RPM. He elected to abort, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit an object &… - [NTSB LAX84IA014](https://openairdocs.org/ntsb/LAX84IA014.md): Cessna 152II · Woodland, CA · Incident · No injuries · Incident investigation · Final report · Oct 15, 1983 · N68604 · 2 aircraft · Minor damage > The Cessna 152 was performing a touch and go landng and had just taken off when the Boeing stearman landed on the left wing and propeller of the Cessna 152. Both acft landed sucessfully and taxied clear of the runway. Both acft were broadcasting their… - [NTSB ATL84LA020](https://openairdocs.org/ntsb/ATL84LA020.md): Cessna 172 · Cullman, AL · Accident · No injuries · Limited investigation · Final report · Oct 15, 1983 · N5082G · Substantial damage > The student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying… - [NTSB CHI84LA025](https://openairdocs.org/ntsb/CHI84LA025.md): Cessna 152 · Harrisburg, IL · Accident · No injuries · Limited investigation · Final report · Oct 14, 1983 · N66937 · Substantial damage > The acft nosed over during takeoff roll while on a solo training flt. The pilot applied too much right rudder then over compensated with left rudder and brake. The acft went off the left side of the rwy into soft mud and nosed over. - [NTSB NYC84FHM02](https://openairdocs.org/ntsb/NYC84FHM02.md): Beech A24R · Spring Valley, NY · Accident · Minor injuries · Final report · Oct 12, 1983 · N200AA · Substantial damage > The acft went off the end of the rwy during an aborted takeoff after the engine backfired and ran rough. The plt closed the throttle as he discontinued the takeoff. Before the acft could be stopped it went off the rwys end and down an embankment. Post… - [NTSB MKC84LA007](https://openairdocs.org/ntsb/MKC84LA007.md): Cessna 172M · Blairstown, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1983 · N755RB · Destroyed > The plt reported that after he started to takeoff, the acft had rolled aprx 1500 ft when he felt the airspeed was not sufficient, so he aborted. He was unable to stop on the remaining rwy. Before stopping, the acft went thru a shallow ravine. Subsequently,… - [NTSB LAX84LA017](https://openairdocs.org/ntsb/LAX84LA017.md): Rockwell S-2R · Holtville, CA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1983 · N8507V · Substantial damage > The plt attempted to take off with 300 gal of fungicide on board. He said that the recently resurfaced dirt rwy had not yet been compacted & this increased the rolling friction which did not allow the acft to accelerate properly. The plt was unable to get the… - [NTSB FTW84LA015](https://openairdocs.org/ntsb/FTW84LA015.md): Piper PA-28R-201T · Eagle Pass, TX · Accident · No injuries · Limited investigation · Final report · Oct 10, 1983 · N6902C · Substantial damage > On a previous flt from Mexico city, the plt was unable to land at monterry, Mexico due to wx & continued the flt to the united states. Before reaching his alternate arpt, the acft ran low on fuel, so the plt made a landing in a field near Eagle Pass, TX. He… - [NTSB ANC84LA005](https://openairdocs.org/ntsb/ANC84LA005.md): Cessna C-185E · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1983 · N64399 · Substantial damage > The passenger stated that the plt was attempting to wipe condensation from the windshield when the acft ran into dry land. - [NTSB DEN84FA004](https://openairdocs.org/ntsb/DEN84FA004.md): Cessna 421C · Center, CO · Accident · No injuries · Field investigation · Final report · Oct 9, 1983 · N770JW · Substantial damage > The acft collided with a dirt bank after a left engine overspeed and loss of directional control during takeoff. The plthad already aborted one takeoff due to overboost and a sticking wastegate. The problem seemed corrected after work and lubrication by a… - [NTSB SEA84LA006](https://openairdocs.org/ntsb/SEA84LA006.md): Cessna U206G · Meyers Chuck, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1983 · N8744Q · Substantial damage > The plt reported that the tide was out, so he was unable to takeoff in the protected bay at Meyers Chuck, AK. With the tide out, there was insufficient room in the bay, so he elected to takeoff on the ocean side of the area. During takeoff, a large wave was… - [NTSB CHI84LA009](https://openairdocs.org/ntsb/CHI84LA009.md): Mooney M20F · Evansville, IN · Accident · No injuries · Limited investigation · Final report · Oct 5, 1983 · N3475X · Substantial damage > During takeoff, the acft began to swerve to the left despite the plt's attempts to maintain directional control with rudder & opposite brake. The acft went off the left side of the rwy 7 struck the VASI lights with both wings. An exam of the brakes revealed… - [NTSB ATL84LA009](https://openairdocs.org/ntsb/ATL84LA009.md): Beech E18S · Denver, NC · Accident · No injuries · Limited investigation · Final report · Oct 3, 1983 · N700M · Substantial damage > After taxiing onto the rwy the plt ran the engs up to takeoff power of 36' mp & began the takeoff roll. Shortly thereafter she reduced power to about 25'-30' mp because the acft appeared to accelerate slowly. After a quick scan of the instruments which… - [NTSB ATL84LA002](https://openairdocs.org/ntsb/ATL84LA002.md): Cessna 172P · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N53445 · Substantial damage > The student plt reported he was practicing touch-and-go takeoffs & landings on rwy 11. While rolling after the 4th landing, power was applied for takeoff. At about that time, the acft veered to the left & ran off the rwy. Subsequently, it struck a drainage… - [NTSB ANC83LA183](https://openairdocs.org/ntsb/ANC83LA183.md): Cessna 185 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N185JS · Substantial damage > The pilot stated that during takeoff rotation, which occurred at 44 KTS the aircraft began a slow turn to the left apparently a torque stall, causing a wing stall and the left wing struck the ice. The pilot aborted the takeoff and the right float struck a mud… - [NTSB CHI83FA437](https://openairdocs.org/ntsb/CHI83FA437.md): Jilek-Smith Miniplane DSA-M3 · Rush City, MN · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1983 · N2441Q · Substantial damage > The plt was performing a high speed taxi test on rwy 33 when the acft became airborne. After lift-off, it climbed to an alt of aprx 50 ft & went into a left turn. It continued in a nose high attitude until it turned about 180 deg then crashed. One witness… - [NTSB ATL83FAG12](https://openairdocs.org/ntsb/ATL83FAG12.md): Beech E18S · Jonesboro, GA · Accident · No injuries · Final report · Sep 20, 1983 · N452CC · Substantial damage > The acft ran off the departure end of the rwy and nosed over during takeoff after an engine lost power. The acft had notbeen flown in several weeks and there had been days of rain and humidity. The magnetoes on the right engine were rough but seemed to clear… - [NTSB LAX83LA449](https://openairdocs.org/ntsb/LAX83LA449.md): Cessna 120 · Lone Pine, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1983 · N76744 · Destroyed > The acft collided with a sand bank during takeoff roll, a fuel leak developed and the acft was consumed by fire. The pilot was attempting a takeoff on a dry lake bed when the acft hit a few sand bumps. The nose went up in the air andthe acft came back down… - [NTSB ATL83FU007](https://openairdocs.org/ntsb/ATL83FU007.md): Teratorn Tierra II · Dallas, NC · Accident · Minor injuries · Final report · Sep 18, 1983 · UNREG · Substantial damage > The plt-in-command (PIC) stated he was taking off on a training flt with a student, using a 2 place, ultralight vehicle. During the takeoff roll, the rubber tread separated from the tailwheel & it began to dig into the airstrip. The PIC reported that after… - [NTSB ANC83LA179](https://openairdocs.org/ntsb/ANC83LA179.md): Cessna 180 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 18, 1983 · N9125T · Substantial damage > The acft collided with a sandbar and collapsed the left main landing gear during an aborted takeoff. The pilot stated that he was attempting a takeoff from a short airstrip at an elevation of 3000 ft MSL when he encountered a tailwind at rotation & the acft… - [NTSB ANC83LA176](https://openairdocs.org/ntsb/ANC83LA176.md): Piper PA-18A · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1983 · N7286D · Substantial damage > The acft collided with bushes at the departure end of the rwy. The pilot told the investigator that he attempted to takeoff from the grass strip but aborted at the last moment. He said he was unable to stop the acft before striking bushes at the departure end. - [NTSB ATL83LA370](https://openairdocs.org/ntsb/ATL83LA370.md): Grumman G-164B · Berry, AL · Accident · No injuries · Limited investigation · Final report · Sep 14, 1983 · N48475 · Substantial damage > The acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He… - [NTSB MKC83LA217](https://openairdocs.org/ntsb/MKC83LA217.md): Piper PA-38-112 · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N2327G · Substantial damage > The pilot stated that he was taking off for his fourth touch and go landing when the acft weathervaned and he lost control of the acft. The nose wheel struck a concrete drainage ditch. - [NTSB CHI83LA424](https://openairdocs.org/ntsb/CHI83LA424.md): Piper PA-31-350 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N62971 · Substantial damage > The acft went off the rwy and collapsed the landing gear after power loss during takeoff. Three of the passengers furnished statements and 2 seemed to think that the left engine quit. The acft turned to the right but the pilot did notknow which engine quit.… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=153 ## 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=152 --- 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.