# 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 141 of 281 · 14,038 cases ## Cases, newest first - [NTSB NYC86LA188](https://openairdocs.org/ntsb/NYC86LA188.md): Beech BE-20 · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N83BA · Substantial damage > After a short distance on the takeoff roll, the aircraft veered sharply to the left. Pilot attempted to correct, but was unsucessful and the aircraft collided with parked unoccupied aircraft. - [NTSB DEN86LA212](https://openairdocs.org/ntsb/DEN86LA212.md): Cessna 170B · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N3056A · Substantial damage > The plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the… - [NTSB DEN86LA205](https://openairdocs.org/ntsb/DEN86LA205.md): Schweizer G164A · Grandin, ND · Accident · No injuries · Limited investigation · Final report · Jul 24, 1986 · N8379 · Substantial damage > Plt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks… - [NTSB ATL86FA208](https://openairdocs.org/ntsb/ATL86FA208.md): Piper PA-60-600 · Raleigh, NC · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1986 · N3643Q · Destroyed > The plt was issued rwy 5, 7,500', for IFR departure with favoring 4 kt quartering headwind. Plt requested rwy 14, 4,498', for takeoff with a 4 kt quartering tailwind. Ground witness and control tower observed acft use nearly all of the rwy on takeoff roll.… - [NTSB DEN86LA204](https://openairdocs.org/ntsb/DEN86LA204.md): Piper PA-25-260 · Sisseton, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N8629L · Substantial damage > The plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken… - [NTSB SEA86LA173](https://openairdocs.org/ntsb/SEA86LA173.md): Cessna 180 · Thomas Creek, ID · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N7583K · Substantial damage > The plt reported not being lined up properly on the airstrip when power was applied for takeoff. A witness reported seeing the tail of the acft pulling to the left causing the acft to slide down the airstrip. The left landing gear dug into the terrain,… - [NTSB LAX86LA298](https://openairdocs.org/ntsb/LAX86LA298.md): Cessna 140 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N76553 · Substantial damage > A Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right… - [NTSB NYC86LA190](https://openairdocs.org/ntsb/NYC86LA190.md): Cessna 172P · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N65612 · Destroyed > When the plt checked the airspeed indicator on takeoff, he saw no indication of speed & aborted the takeoff, but was unable to stop on the remaining rwy. The acft contd off the departure end, when down an embankment & became inverted. An exam revealed the… - [NTSB MKC86LA153](https://openairdocs.org/ntsb/MKC86LA153.md): Stevenson Glasair · Oakley, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1986 · N2440H · Substantial damage > The PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the… - [NTSB LAX86LA294](https://openairdocs.org/ntsb/LAX86LA294.md): Cessna 310J · Stockton, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N3195L · Substantial damage > A C-31OJ went out of ctl on the rwy and collided with a dirt bank. The CFI indicated that they were practicing single eng procedures in the tfc pattern. After td on a single eng apch the CFI gave the left eng back to the student and annc go-around. Init climb… - [NTSB FTW86LA130](https://openairdocs.org/ntsb/FTW86LA130.md): Bell 206B · Conroe, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1986 · N352AT · Substantial damage > The pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail… - [NTSB FTW86LA129](https://openairdocs.org/ntsb/FTW86LA129.md): Cessna 182C · Decker'S Island, TX · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N8654T · Substantial damage > During a beach take-off run of approximately 200 feet, the aircraft nose wheel sunk into the soft sand. The pilot tried to add power and pull the column back, however the aircraft nosed over into an inverted position. - [NTSB MKC86LA149](https://openairdocs.org/ntsb/MKC86LA149.md): Piper PA-30 · Arkansas City, KS · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N7259Y · Substantial damage > The certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately… - [NTSB NYC86FA182](https://openairdocs.org/ntsb/NYC86FA182.md): Aeronca 7AC · Durhamville, NY · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1986 · N84854 · Destroyed > Aircraft departed rwy 35 at kamp airport, climbed to about 200 feet, turned right, stalled and crashed vertically into the ground. A witness said that the aircraft climbed, the engine sputtered, and then stopped. No preimpact malfunction/failure was… - [NTSB DEN86LA198](https://openairdocs.org/ntsb/DEN86LA198.md): Cessna A188B · Center, CO · Accident · No injuries · Limited investigation · Final report · Jul 11, 1986 · N53353 · Substantial damage > According to the plt involved in the accident the acft crashed during takeoff because the eng was not developing full power. The owner of the ag spraying business (to whom the acft belongs) and another plt for the operator, stated the mixture was improperly… - [NTSB MIA86LA203](https://openairdocs.org/ntsb/MIA86LA203.md): Aerotek Pitts S-2A · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1986 · N31496 · Substantial damage > The student plt lost control of the acft as power was applied to takeoff. The instructor plt then took control of the acft as it left the rwy, after which the left gear became stuck in sand. The acft nosed over and came to rest inverted. - [NTSB ANC86LA112](https://openairdocs.org/ntsb/ANC86LA112.md): Cessna 180B · Kvichak, AK · Accident · No injuries · Limited investigation · Final report · Jul 10, 1986 · N5159E · Substantial damage > The plt attempted to become airborne without sufficient airspeed after noticing that there was not enough rwy remaining to complete the takeoff. The acft mushed and one of the main gears contacted a dirt bank. A loss of directional control resulted and the… - [NTSB CHI86LA167](https://openairdocs.org/ntsb/CHI86LA167.md): Cessna A152 · Middleton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1986 · N761UA · Substantial damage > The student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the… - [NTSB LAX86FJA02](https://openairdocs.org/ntsb/LAX86FJA02.md): Bell 206B · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Final report · Jul 7, 1986 · N4835A · Destroyed > The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The… - [NTSB LAX86FA282](https://openairdocs.org/ntsb/LAX86FA282.md): Cessna 150H · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · Jul 7, 1986 · N23222 · Destroyed > The plt performed 1 normal touch & go operation, & touched down normally on the second planed touch & go which was to terminate with a right dep out of the pattern. After touchdown, witnesses observed the acft roll straight along the rwy centerline for about… - [NTSB SEA86LA162](https://openairdocs.org/ntsb/SEA86LA162.md): Lazarini LONG-EZ · Jackpot, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1986 · N8183K · Substantial damage > During takeoff at about rotation speed, the pilot diverted her attention to the right wing. The acft drifted to the edge of the runway and caught a wingtip, then nosed over. - [NTSB LAX86FA278](https://openairdocs.org/ntsb/LAX86FA278.md): Beech C24R · Meyers, CA · Accident · 4 fatal · Field investigation · Final report · Jul 5, 1986 · N66287 · Destroyed > With a density altitude of about 8400 ft, and an aircraft near its max certificated gross weight, the plt & 3 pax departed on rwy 18. During takeoff either the pilot's door was not closed or it came open. The open door degraded the acft's climb performance.… - [NTSB MKC86LA137](https://openairdocs.org/ntsb/MKC86LA137.md): WSK PZL Mielec PZL-M-18 · Wynne, AR · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N4685B · Substantial damage > The plt stated that he had been fertilizing rice crops the morning prior to the accident flt and that there was nothing wrong with the acft. He further stated that on the accident flt he had already initiated the takeoff roll, when he realized that the flt… - [NTSB LAX86LA274](https://openairdocs.org/ntsb/LAX86LA274.md): Piper PA-18-150 · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1986 · N2406J · Substantial damage > The Piper PA-18-150 encountered turbulent wind conditions and dragged the left wing during a takeoff ground run from rwy 33. The plt reported that during the takeoff ground run, the right wing lifted causing the left wing to drag on the rwy. The aircraft then… - [NTSB NYC86LA159](https://openairdocs.org/ntsb/NYC86LA159.md): Cessna 152 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N6150Q · Substantial damage > The student pilot was cleared for closed traffic touch and go landings; however, during his acceleration for takeoff, he lost directional control and the aircraft veered left off the runway. Not being able to regain control, the takeoff was aborted. The… - [NTSB DEN86FA175](https://openairdocs.org/ntsb/DEN86FA175.md): Martin 404 · Buffalo, WY · Accident · 3 fatal · Field investigation · Final report · Jun 27, 1986 · N40443 · Destroyed > N40443 was contracted by the Wyoming dept of ag to spray grasshoppers. Investigation revealed the plt held a pvt certificate with asmel ratings. His medical certificate was denied because he failed to provide information concerning high blood pressure and… - [NTSB MIA86LA190](https://openairdocs.org/ntsb/MIA86LA190.md): Aero Commander S2R · Valley Park, MS · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N8946Q · Substantial damage > The plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph. - [NTSB FTW86LRD15](https://openairdocs.org/ntsb/FTW86LRD15.md): Grumman G-164B · Church Point, LA · Accident · No injuries · Final report · Jun 24, 1986 · N48585 · Substantial damage > The acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee. - [NTSB DEN86LA172](https://openairdocs.org/ntsb/DEN86LA172.md): Cessna 180K · Ronan, MT · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N61999 · Substantial damage > According to the plt, during the takeoff ground run, his seat slid to the full aft position. The plt stated he lost control & the acft ground looped. - [NTSB LAX86LA259](https://openairdocs.org/ntsb/LAX86LA259.md): Beech A-36TC · San Rafael, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 1986 · N3823A · Substantial damage > The acft stalled and collided with the ground initial during a takeoff initial climb. He indicated that he misjudged the stall buffet as turbulent airflow from a crosswind. The right wing dropped and the acft stalled. The plt also indicated the stall warning… - [NTSB FTW86LA113](https://openairdocs.org/ntsb/FTW86LA113.md): Grumman G-164 · Palacios, TX · Accident · No injuries · Limited investigation · Final report · Jun 19, 1986 · N48398 · Substantial damage > During the ground run portion of the takeoff, the acft contacted a mud hole which resulted in it veering off the grass and into bushes alongside the strip. The plt did not select suitable terrain for the takeoff. - [NTSB DEN86LA166](https://openairdocs.org/ntsb/DEN86LA166.md): Piper PA-36 · Onida, SD · Accident · No injuries · Limited investigation · Final report · Jun 19, 1986 · N3856E · Destroyed > The plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be… - [NTSB ANC86LA083](https://openairdocs.org/ntsb/ANC86LA083.md): Cessna 172M · Theodore River, AK · Accident · No injuries · Limited investigation · Final report · Jun 18, 1986 · N73419 · Substantial damage > The pilot stated that upon attempting a soft field takeoff the aircraft drifted to the left. The left main landing gear struck a sand berm which caused the aircraft to exit the road into an open ditch. - [NTSB LAX86LA255](https://openairdocs.org/ntsb/LAX86LA255.md): Stinson 108-1 · Quincy, CA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1986 · N97201 · Substantial damage > The commercial plt/cfi, attempted to takeoff when a left 40 deg, 15 to 25 knot crosswind existed. The plt lost directional control of the acft, & when attempting to abort the takeoff the acft's gear collapsed & the acft collided with a drainage ditch. The plt… - [NTSB LAX86LA252](https://openairdocs.org/ntsb/LAX86LA252.md): Piper PA-28-181 · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N8156E · Substantial damage > The pilot said that during the takeoff roll on the 2,400 foot long runway he noticed the aircraft aceleration was slow and the airspeed was still below 55 KTS at 3/5 of the way down the runway and he elected to abort the takeoff. The aircraft overran the end… - [NTSB CHI86LA155](https://openairdocs.org/ntsb/CHI86LA155.md): Piper PA-16 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N5370H · Substantial damage > The plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch. - [NTSB BFO86FIG02](https://openairdocs.org/ntsb/BFO86FIG02.md): Aero Commander 560A · Easton, MD · Accident · Minor injuries · Final report · Jun 14, 1986 · N2756B · Substantial damage > The acft overran the end of the rwy and struck an embankment during an aborted takeoff. The plt reported that shortly after takeoff, the acft settled back on the rwy. He reduced the engine power to idle, raised the flaps and attempted to stop the acft to no… - [NTSB ANC86LA073](https://openairdocs.org/ntsb/ANC86LA073.md): Piper PA-22-150 · Theodore River, AK · Accident · No injuries · Limited investigation · Final report · Jun 12, 1986 · N5837D · Substantial damage > The pilot stated that during the takeoff roll he lost directional control of the aircraft causing the aircraft to strike a row of trees. - [NTSB MIA86LA178](https://openairdocs.org/ntsb/MIA86LA178.md): Piper PA-38-112 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 11, 1986 · N2378D · Substantial damage > The student plt stated that he was attempting a practice soft-field takeoff from rwy 18. Just prior to rotation the main gear contacted a bump in the airstrip and the acft drifted to the left. The acft continued left where it struck trees alongside the rwy.… - [NTSB ATL86IA167](https://openairdocs.org/ntsb/ATL86IA167.md): Beech H35 · Birmingham, AL · Incident · No injuries · Incident investigation · Final report · Jun 11, 1986 · N7989D · Minor damage > During takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway. - [NTSB FTW86LA104](https://openairdocs.org/ntsb/FTW86LA104.md): Cessna 170B · Witchita Falls, TX · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N37RA · Substantial damage > During the ground run portion of the takeoff, the pilot lost directional control of his taildragger aircraft. As the aircraft was spinning around the right gear struck a small ditch and broke the landing gear off, causing the aircraft to come to rest on its… - [NTSB DEN86LA158](https://openairdocs.org/ntsb/DEN86LA158.md): Beaver Evans VP-1 · Glade Park, CO · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N23RB · Substantial damage > The plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft. - [NTSB MKC86LA126](https://openairdocs.org/ntsb/MKC86LA126.md): Rockwell S-2R · Hickory Ridge, AR · Accident · No injuries · Limited investigation · Final report · Jun 7, 1986 · N4921X · Substantial damage > The plt stated that the takeoff was normal up to the initial climb when, at this point oil began streaking from the engine and it lost power. According to the plt, he immediately tried to dump the fertilizer and look for a place to land but, due to the… - [NTSB NYC86LA145](https://openairdocs.org/ntsb/NYC86LA145.md): Cessna 172 · Perkasie, PA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1986 · N1009F · Substantial damage > During takeoff roll and as the aircraft was brought to full power, the flight started to veer left. Attempts to correct with right rudder but the aircraft continued to roll left. The aircraft could not be brought under control before contact with two parked… - [NTSB FTW86LA101](https://openairdocs.org/ntsb/FTW86LA101.md): Cessna 180K · Timbalier, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1986 · N20379 · Substantial damage > During the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the… - [NTSB MKC86LA124](https://openairdocs.org/ntsb/MKC86LA124.md): Cessna A188 · Blaine, KS · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N8140V · Substantial damage > The plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's… - [NTSB FTW86LA102](https://openairdocs.org/ntsb/FTW86LA102.md): WSK PZL Mielec PZL-M-18 · Winnie, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1986 · N4226N · Destroyed > The pilot experienced partial loss of power during takeoff when the #3 cylinder quit firing. The aircraft then settled back down onto the grass strip and collided with a levy. At this point the pilot lost control of the aircraft, which went through some… - [NTSB LAX86LA237](https://openairdocs.org/ntsb/LAX86LA237.md): Cessna 172N · Goodyear, AZ · Accident · Serious injuries · Limited investigation · Final report · May 31, 1986 · N2002E · Substantial damage > The student pilot was on her first supervised solo on runway 03 at Goodyear airport, Goodyear, AZ. Her instructor advised her to make three touch & go takeoff's and landings. The instructor positioned herself near the landing area and advised the student… - [NTSB MKC86LA120](https://openairdocs.org/ntsb/MKC86LA120.md): Eagle DW-1 · Corning, AR · Accident · No injuries · Limited investigation · Final report · May 29, 1986 · N8814M · Substantial damage > The plt was making his second flt in this acft when the accident occurred. He failed to lock the cockpit canopy before start of takeoff roll. During the takeoff roll the canopy opened and separated from the acft. The plt diverted his attention from flying the… - [NTSB MKC86LA119](https://openairdocs.org/ntsb/MKC86LA119.md): Piper PA-34-200T · Olathe, KS · Accident · No injuries · Limited investigation · Final report · May 28, 1986 · N1581X · Substantial damage > During a takeoff roll fm johnson county executive airport, the PIC stated that the left landing gear collapsed and the aircraft impacted the rwy and veered off into soft terrain. Inspection revealed that when electrical power was initiated and the gear switch… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=142 ## 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=141 --- 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.