# 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 137 of 281 · 14,038 cases ## Cases, newest first - [NTSB CHI87LA202](https://openairdocs.org/ntsb/CHI87LA202.md): Piper PA-28-151 · Delft, MN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1987 · N4935F · Substantial damage > The acft was loaded close to its gross wt limit & the plt atmtd to takeoff on a 2160 ft strip, using short field takeoff techniques. The acft became airborne for a short time, however, it began to settle. The plt elected to abort the takeoff, but was unable… - [NTSB ANC87FA118](https://openairdocs.org/ntsb/ANC87FA118.md): De Havilland DHC-2 MK-1 · Elmendorf Afb, AK · Accident · No injuries · Field investigation · Final report · Aug 9, 1987 · N5342G · Substantial damage > The instructor (CFI) elected to demonstrate a no-flap takeoff with calm/glassy water conds. After the float plane had accelerated to about 55 to 60 KTS without becoming airborne, he elected to abort the takeoff. He stated that he attempted a left turn & the… - [NTSB FTW87LA192](https://openairdocs.org/ntsb/FTW87LA192.md): Cessna 170A · San Marcos, TX · Accident · No injuries · Limited investigation · Final report · Aug 8, 1987 · N401P · Substantial damage > The student pilot lost directional control when the tail wheel came off the runway. The instructor pilot stated that he was late with corrective action and the aircraft ground looped off the runway. - [NTSB SEA87LA159](https://openairdocs.org/ntsb/SEA87LA159.md): Eagle DW-1 · Hamer, ID · Accident · No injuries · Limited investigation · Final report · Aug 7, 1987 · N8803R · Substantial damage > The plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled… - [NTSB DEN87IA207](https://openairdocs.org/ntsb/DEN87IA207.md): Airbus Industrie A-300-B4-203 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Aug 3, 1987 · N966C · Minor damage > As coplt accelerated acft through 128 KTS for takeoff, electrical malfunction occurred resulting in unreliable instrument indications. Capt rejected takeoff. Acft went off end of 12000-FT rwy. Post-incident examination disclosed no. 1 constant speed drive… - [NTSB CHI87IA183](https://openairdocs.org/ntsb/CHI87IA183.md): Mcdonnell Douglas DC-10-10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 3, 1987 · N113AA · 2 aircraft · No damage > After ldg the co B727 was directed to make two right turns and follow an acft that had landed in front of him. The pilot made one right turn and taxied down an empty runway. This taxi route crossed an active runway. An aa#DC-10 on takeoff roll, at 110 knots,… - [NTSB NYC87LA218](https://openairdocs.org/ntsb/NYC87LA218.md): Piper PA-28-181 · Newport, NH · Accident · No injuries · Limited investigation · Final report · Aug 2, 1987 · N25HG · Substantial damage > On takeoff the aircraft failed to gain sufficient airspeed to maintain flight. The takeoff was aborted after reaching 200 feet altitude and the aircraft was landed on the runway. The aircraft continued off the end of the runway and collided with a sandbank.… - [NTSB MIA87LA221](https://openairdocs.org/ntsb/MIA87LA221.md): Lake LA-4-200 · St.Augustine, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1987 · N2878P · Substantial damage > During the water takeoff run the plt's forward visibility was momentarily lost as he rotated the acft onto the step. When visibility was regained he realized that the acft was headed towards the shoreline & turned to avoid it during which the rt wing tip was… - [NTSB NYC87LA212](https://openairdocs.org/ntsb/NYC87LA212.md): Lake LA-4-250 · Westport, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1987 · N14037 · Substantial damage > Drg the takeoff run on a Lake, the amphibian enctrd rough water & became airborne prematurely. The acft then settled onto the water in a slightly nose high attitude & touched down in front of a large wave. The acft's nose crashed head-on into the wave which… - [NTSB MKC87LA149](https://openairdocs.org/ntsb/MKC87LA149.md): Piper PA-38-112 · Benton, KS · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N2355N · Substantial damage > While practicing soft field take offs, student plt with CFI over rotated acft causing premature flt before attaining vxse airspeed. CFI attempted to correct the situation, but acft settled in uncontrolled descent beyond the airport boundary. Acft struck the… - [NTSB MKC87LA147](https://openairdocs.org/ntsb/MKC87LA147.md): Cessna 188B · Fairfield, NE · Accident · No injuries · Limited investigation · Final report · Jul 29, 1987 · N2833J · Substantial damage > Shortly after takeoff for an aerial application flight, the aircraft began to settle. The left wing struck the ground and the aircraft turned 180 degrees. Temperature was 95 degrees f and density altitude 4000 feet. The pilot stated he 'could have dumped some… - [NTSB CHI87FA177](https://openairdocs.org/ntsb/CHI87FA177.md): Taylorcraft BC12-D · Morris, MN · Accident · 2 fatal · Field investigation · Final report · Jul 29, 1987 · N99AW · Destroyed > The plt was ferrying the acft from Ohio to Alaska. While en route, he stopped & refueled at Morris, MN. After he took off, the plane crashed in an open field about 1/2 mi from the arpt. No known witnesses saw the acdnt, but a passerby found the acft on its… - [NTSB ANC87LA111](https://openairdocs.org/ntsb/ANC87LA111.md): Beech H35 · Nikolai Creek, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1987 · N5429D · Substantial damage > This pilot stated he did not fully understand crosswind operating procedures. When he encountered a crosswind during takeoff he allowed the aircraft to drift to the left off the runway and groundlooped. - [NTSB FTW87LA178](https://openairdocs.org/ntsb/FTW87LA178.md): Piper PA-18A · Aransas Pass, TX · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N321AK · Substantial damage > The plt rprtd that drg a takeoff roll, the acft encountered a gust of wind from the left which caused it to veer off the right side of the rwy. Subsequently, it contacted a ditch & was damaged. - [NTSB FTW87LA176](https://openairdocs.org/ntsb/FTW87LA176.md): Piper PA28R-201 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N6083H · Substantial damage > According to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an… - [NTSB DEN87LA195](https://openairdocs.org/ntsb/DEN87LA195.md): Cessna 182L · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N3371R · Destroyed > The plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed… - [NTSB LAX87LA283](https://openairdocs.org/ntsb/LAX87LA283.md): Ercoupe 415-C · Galt, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1987 · N2716H · Destroyed > During the takeoff ground roll on a 2000 ft private runway, at the point to rotate, the plt applied back pressure, however, the aircraft did not respond. Aprx three quarters of the way down the rwy the plt realized that the acft was not lifting off and he… - [NTSB ANC87LA104](https://openairdocs.org/ntsb/ANC87LA104.md): Aeronca 15AC · Charley River, AK · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N1023H · Substantial damage > The pilot stated that during the takeoff roll he struck a hidden tree stump; he lost directional control of the aircraft causing the plane to nose over. - [NTSB CHI87LA175](https://openairdocs.org/ntsb/CHI87LA175.md): Piper PA-30 · Bad Axe, MI · Accident · No injuries · Limited investigation · Final report · Jul 20, 1987 · N8049Y · Substantial damage > During a demonstration of an aborted takeoff, the 'power was cut' after the aircraft accelerated to about 75 mph. At about that time, the aircraft encountered a gust of wind and became airborne. A power recovery was initiated, but the aircraft touched down in… - [NTSB MKC87DCA02](https://openairdocs.org/ntsb/MKC87DCA02.md): Rotorway Exec · Highridge, MO · Accident · Serious injuries · Final report · Jul 19, 1987 · N275FS · Substantial damage > The plt said the helicopter enctrd hi density altitude problems as it was moving out of ground effect drg takeoff. Subsequently, the helicopter settled into trees, then crashed to the ground in an inverted attitude. The temp & dew point were 90 & 77 deg,… - [NTSB ATL87LA215](https://openairdocs.org/ntsb/ATL87LA215.md): Cessna 150K · New Carlisle, OH · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N5669G · Substantial damage > During a takeoff attempt, the student retarded the throttle shortly after liftoff. This flt was the student plts second flight and the first flight with this instructor. The student was instructed to follow along on the flight controls. This was the first… - [NTSB ANC87LA099](https://openairdocs.org/ntsb/ANC87LA099.md): Cessna 185 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N1977U · Substantial damage > The pilot stated that during takeoff on the river he lost directional control of the aircraft causing the aircraft to collide with a boat dock. - [NTSB CHI87LA172](https://openairdocs.org/ntsb/CHI87LA172.md): Cessna 170 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N4649V · Substantial damage > The plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.… - [NTSB MIA87LA207](https://openairdocs.org/ntsb/MIA87LA207.md): Israel Aircraft Industries 1121 · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N133ME · Substantial damage > During the ground run at 80 KTS the cabin door unsafe light illuminated. The takeoff was aborted with heavy braking & deployment of the thrust reversers. The door was then opened & reclosed which extinguished the light, & a second takeoff was attempted. Aprx… - [NTSB ANC87LA098](https://openairdocs.org/ntsb/ANC87LA098.md): Lake LA-4 · Cool Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N1135L · Substantial damage > The pilot stated that during the takeoff on the Lake the aircraft would not lift off the water and he lost directional control of the aircraft causing it to collide with the Lake shore. - [NTSB MKC87LA139](https://openairdocs.org/ntsb/MKC87LA139.md): Cessna 188B · Satanta, KS · Accident · No injuries · Limited investigation · Final report · Jul 15, 1987 · N4954R · Substantial damage > During the takeoff ground run on an aerial application operation, the right main gear leg separated approximately 10 inches above the axle. Acft became uncontrollable and struck the terrain. Post acc examination disclosed no defects which may have assisted… - [NTSB ATL87LA213](https://openairdocs.org/ntsb/ATL87LA213.md): Cessna 152 · Middlefield, OH · Accident · No injuries · Limited investigation · Final report · Jul 15, 1987 · N4649M · Substantial damage > The student plt's seat slid back during the takeoff roll, following a touch-and-go ldg. The student lost directional control and the airplane ran off the left side of the rwy. The airplane impacted a ditch and nosed over. Post-crash exam of the seat assy by a… - [NTSB FTW87DRA09](https://openairdocs.org/ntsb/FTW87DRA09.md): Weatherly 201C · Louise, TX · Accident · No injuries · Final report · Jul 13, 1987 · N1296W · Substantial damage > The acft was loaded with aprx 1100 lbs of fertilizer & the plt attempted to takeoff from a pvt strip on a 'still & muggy' day with a temp of about 95 deg. He rprtd that during the takeoff roll, he opened the dump gate when the acft was midway down the rwy to… - [NTSB SEA87LA138](https://openairdocs.org/ntsb/SEA87LA138.md): Cessna 185 · Lake Chelan, WA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N8593Q · Substantial damage > During takeoff from the water the plt noticed a log protruding out of the water. The acft struck the log and the plt rotated prematurely, became airborne, and then descended striking the water hard. - [NTSB ATL87DEI09](https://openairdocs.org/ntsb/ATL87DEI09.md): Cessna 170B · Upper Sandusky, OH · Accident · No injuries · Final report · Jul 11, 1987 · N3142A · Substantial damage > During takeoff attempt from runway 36 the aircraft veered to the left about 250 feet from the runway threshold and contacted the ground. The pilot reported that a crosswind caught him off guard. Weather information obtained from findlay flight service… - [NTSB ANC87LA093](https://openairdocs.org/ntsb/ANC87LA093.md): Aeronca 15AC · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N1304H · Substantial damage > The student pilot stated that the aircraft lost partial power during the take off run due to water being ingested into the engine air filter as he made his water takeoff. He elected to continue with the takeoff attempt and struck the shoreline prior to… - [NTSB MKC87LA133](https://openairdocs.org/ntsb/MKC87LA133.md): Grumman G-164B · Mcdougal, AR · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N6609Q · Destroyed > The ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total… - [NTSB FTW87LA166](https://openairdocs.org/ntsb/FTW87LA166.md): Piper PA-28R-201T · Midland, TX · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N5919V · Substantial damage > During takeoff roll from mid-field on the wrong runway, the pilot realized he was running out of runway. He rotated the aircraft early and climbed to approximately 10 feet AGL. The aircraft would not climb. The pilot aborted the takeoff andapplied brakes… - [NTSB ATL87LA205](https://openairdocs.org/ntsb/ATL87LA205.md): Piper PA-28-181 · Gulf Shores, AL · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N8389Y · Substantial damage > The plt aborted the takeoff about half way down the 3600 ft rwy after observing that the airspeed indicator was inop. Before he could stop the acft, it ran off the end of the rwy & went into a ditch. An exam by an A&P mechanic revealed that the pitot head was… - [NTSB FTW87DRD08](https://openairdocs.org/ntsb/FTW87DRD08.md): Grumman G-164A · Lacassine, LA · Accident · No injuries · Final report · Jul 7, 1987 · N9778 · Substantial damage > The pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional… - [NTSB NYC87LA198](https://openairdocs.org/ntsb/NYC87LA198.md): Lake LA-250 · Alton Bay, NH · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N1403W · Substantial damage > The Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had… - [NTSB DEN87LA173](https://openairdocs.org/ntsb/DEN87LA173.md): Beech B-60 · Kanab, UT · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N18444 · Substantial damage > The commercial corporate plt had deplaned his passengers and was beginning the second leg of a corp/exec flight. During ground run the plt detected a manifold pressure loss on the left engine. The plt aborted the takeoff and applied heavy braking. The… - [NTSB DEN87LA171](https://openairdocs.org/ntsb/DEN87LA171.md): Socata TB-10 · Cripple Creek, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1987 · N112U · Substantial damage > This acdt occurred when the plt attempted to takeoff on a 2600 ft long rwy when the density altitude was about 13,500 ft. the acft overran the rwy and collided with a highway. The plt said that the field was too high and too short and it was too hot. - [NTSB FTW87LA158](https://openairdocs.org/ntsb/FTW87LA158.md): Piper PA-28RT-201T · Galveston, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1987 · N8274U · Substantial damage > The plt had lndd on an abandoned airstrip & was attempting to takeoff again. He stated that due to birds on the rwy, he deviated to the left to avoid a bird strike. Subsequently, the landing gear collided with a chunk of raised concrete which was hidden by… - [NTSB MKC87FA130](https://openairdocs.org/ntsb/MKC87FA130.md): Mitsubishi MU-2B-60 · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Jul 3, 1987 · N271MA · Substantial damage > During a takeoff, PIC lost directional control of acft, causing it to swerve off the active runway, spin around, shearing the nose gear assembly and left main wheel. The nose wheel strut assembly careened into the right powerplant propeller causing the torque… - [NTSB ATL87LA202](https://openairdocs.org/ntsb/ATL87LA202.md): Piper PA-32RT-300 · Liberty, NC · Accident · No injuries · Limited investigation · Final report · Jul 3, 1987 · N9385C · Substantial damage > Bfr departing on a ngt flt, the acft was loaded until it was at or near its max gross wt limit. The plt stated that as he was taking off on a 3000' rwy, the eng 'coughed' after the acft had accelerated to about the rotation speed & was aprx 3/4 of the way… - [NTSB ANC87LA090](https://openairdocs.org/ntsb/ANC87LA090.md): Piper PA-32-301T · Becharof Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 2, 1987 · N8185W · Substantial damage > The pilot stated he was rolling out for takeoff when the nose wheel struck a soft area causing the aircraft to go up on its nose. - [NTSB CHI87LA159](https://openairdocs.org/ntsb/CHI87LA159.md): Cessna 152 · Jenison, MI · Accident · No injuries · Limited investigation · Final report · Jul 1, 1987 · N757UT · Substantial damage > On takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side… - [NTSB ANC87LA085](https://openairdocs.org/ntsb/ANC87LA085.md): Piper PA-22 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N7801D · Substantial damage > The pilot stated that he lost directional control of the aircraft during the takeoff causing the plane to groundloop. - [NTSB NYC87LA190](https://openairdocs.org/ntsb/NYC87LA190.md): American AA-1A · Kralltown, PA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1987 · N9399L · Substantial damage > The plt attempted to takeoff from a 2130 ft grass strip on a relatively hot & humid day with an air temp of 85 deg. About 2/3 of the way down the rwy, he rotated the acft to takeoff, but it would not climb sufficiently to clear a hill beyond the arpt boundry.… - [NTSB ATL87IA179](https://openairdocs.org/ntsb/ATL87IA179.md): Boeing 727-232 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Jun 19, 1987 · N482DA · 2 aircraft · No damage > At aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming… - [NTSB ANC87LA083](https://openairdocs.org/ntsb/ANC87LA083.md): de Havilland DHC-2 · Alexander River, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N5349G · Substantial damage > The pilot stated that during the takeoff run the left float contacted a hidden sand bar. The aircraft then nosed over on its back. - [NTSB CHI87IA163](https://openairdocs.org/ntsb/CHI87IA163.md): Boeing 757-251 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Jun 18, 1987 · N515US · Minor damage > A northwest airlines Boeing 757, operating as flight 336, scraped the tail cone area of the fuselage on the runway when the pilot failed to maintain sufficient ground clearance during rotation and takeoff from Detroit, Michigan. The Boeing 757 flight… - [NTSB ANC87LA081](https://openairdocs.org/ntsb/ANC87LA081.md): Cessna 182 · Theodore River, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 1987 · N71724 · Substantial damage > The plt stated that during the takeoff roll the acft's left main gear struck a culvert in the road. The acft became airborne prior to reaching rotation speed. The plt reduced power to abort the takeoff. The nose wheel struck a stump on the road and the acft… - [NTSB LAX87LA229](https://openairdocs.org/ntsb/LAX87LA229.md): Cessna 180 · Kernville, CA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1987 · N2477C · Destroyed > The plt rprtd that he made a precautionary landing on a remote airstrip after detecting smoke & an odor of burnt oil coming from the eng compartment. After landing, he determined the source of the odor was spilled oil on the exhaust & he elected to takeoff… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=138 ## 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=137 --- 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.