# NTSB investigations: Initial climb 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 206 of 412 · 20,559 cases ## Cases, newest first - [NTSB LAX83LA178](https://openairdocs.org/ntsb/LAX83LA178.md): Piper PA 32-300 · San Luis Obispo, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1983 · N15278 · Substantial damage > The acft departed rwy 29, & at about 200 ft AGL the eng was heard to sputter & surge. The acft was then observed in a steep left bank toward rwy 7. The wings leveled just prior to impact about 100 ft short of rwy 7. Arpt police personnel inspected the acft… - [NTSB DEN83FA091](https://openairdocs.org/ntsb/DEN83FA091.md): Cessna 182H · Hayden, CO · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1983 · N2971Y · Substantial damage > The acft collided with a powerline and crashed after the engine lost power on takeoff. According to witnesses the acft made a normal takeoff but during climbout the engine backfired and dark smoke came out. The acft turned left then steeply right before… - [NTSB LAX83LA176](https://openairdocs.org/ntsb/LAX83LA176.md): Cessna 182H · Ruth, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N2353X · Substantial damage > After landing at Ruth, CA, the acft was refueled with aprx 38 gal of 80/87 octane aviation fuel. During takeoff, about 15 min after landing, the eng lost power as the acft was climbing thru aprx 200 to 300 ft AGL. The plt landed straight ahead in the best… - [NTSB ATL83LA148](https://openairdocs.org/ntsb/ATL83LA148.md): Cessna 175 · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1983 · N7588M · Substantial damage > The aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn… - [NTSB NYC83FU002](https://openairdocs.org/ntsb/NYC83FU002.md): CGS Hawk · East Hanover, NJ · Accident · Serious injuries · Final report · Apr 2, 1983 · UNREG · Destroyed > During takeoff, the plt heard a bang as the propeller (prop), attaching pulley & reduction drive belts separated, while the ultralight vehicle was climbing thru about 130 ft AGL. At that time. The eng began overspeeding, the nose pitched up & the ultralight… - [NTSB FTW83FA176](https://openairdocs.org/ntsb/FTW83FA176.md): Cessna 172N · Cuero, TX · Accident · 3 fatal · Field investigation · Final report · Apr 2, 1983 · N734ZR · Destroyed > The non-rated plt had been previously employed by the operator & knew where the keys of the acft had been kept. He had no known flight training, but had previously been a passenger in the acft on at least one ocasion. He took the acft without permission,… - [NTSB FTW83FA172](https://openairdocs.org/ntsb/FTW83FA172.md): Cessna 182A · Bethany, OK · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1983 · N2030G · Destroyed > The student pilot departed Oklahoma city, OK en route to chickasha, OK. The acft was observed to depart runway 17R and proceed wsw of the airport. The acft wreckage was located about 1 1/2 miles west of wiley post airport. The acft was intact and exam… - [NTSB DEN83LA095](https://openairdocs.org/ntsb/DEN83LA095.md): Aerospatiale SA 315B · Craig, CO · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 1983 · N5770F · No damage > The helicopter was being used in a long line demonstration when the cable contacted a man on the ground and injured him. According to the pilot, after the acft was landed at the staging area, the field was briefed on helicopter operations for aprx 45 min.… - [NTSB FTW83LA169](https://openairdocs.org/ntsb/FTW83LA169.md): Beech 35 · El Paso, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 29, 1983 · N3732N · Substantial damage > On a flt after an annual inspn, the plt could not retract the gear, using the normal electrical sys. It remained extended with the green safe light on & the gear pointer indicating down. He tried to assist the normal sys with the manual handcrank, although… - [NTSB FTW83LA168](https://openairdocs.org/ntsb/FTW83LA168.md): Piper PA-18A-150 · Mountain Park, OK · Accident · No injuries · Limited investigation · Final report · Mar 28, 1983 · N6983D · Substantial damage > The pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.… - [NTSB CHI83LA153](https://openairdocs.org/ntsb/CHI83LA153.md): Mooney M20J · Warren, MN · Accident · No injuries · Limited investigation · Final report · Mar 28, 1983 · N1170G · Substantial damage > The pilot was practicing a short field takeoff. The acft came off the ground nose high at low airspeed. At about 40 feetagl the pilot retracted the landing gear and while doing this he inadvertantly raised the flaps. The acft mushed back tothe surface. The… - [NTSB LAX83LA152](https://openairdocs.org/ntsb/LAX83LA152.md): Cessna 182A · Torrance, CA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1983 · N2112G · Destroyed > The plt stated that when he reached aprx 60 ft AGL during takeoff, he noticed the airspeed indicator drop below 40 mph. He said the eng sounded normal. He lowered the nose of the acft, but the airspeed indicator reading remained below 40 mph, so he elected to… - [NTSB FTW83LA166](https://openairdocs.org/ntsb/FTW83LA166.md): Air Tractor AT-301 · Newellton, LA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1983 · N3652A · Substantial damage > Aprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which… - [NTSB ATL83LA142](https://openairdocs.org/ntsb/ATL83LA142.md): Cessna 188B · Houston, MS · Accident · No injuries · Limited investigation · Final report · Mar 24, 1983 · N731PP · Substantial damage > The plt reported that during takeoff, he had reached an alt of aprx 100 ft AGL, had reduced power & was retracting the flaps from the takeoff setting when he felt the acft 'give.' He reextended the flaps, applied full throttle & dumped his load, but the acft… - [NTSB MIA83LA099](https://openairdocs.org/ntsb/MIA83LA099.md): Cessna 152 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Mar 23, 1983 · N5547P · Substantial damage > A student pilot on a supervised solo flight in a Cessna 152 collided with a remote controlled model airplane during climb out through 400 feet. The acft was damaged but the pilot was not injured. The model airplane was being operated from an adjacent park, by… - [NTSB ANC83FAA05](https://openairdocs.org/ntsb/ANC83FAA05.md): Cessna U206G · Rampart, AK · Accident · Serious injuries · Final report · Mar 23, 1983 · N9068G · Substantial damage > The runway was a 3000 foot gravel strip covered with hard packed snow and snow berms on both sides. The pilot stated he broke ground about half way down the runway at about 50 KTS airspeed. At about 40 feet AGL, he noticed he was drifting toward 60 foot trees… - [NTSB DEN83IA083](https://openairdocs.org/ntsb/DEN83IA083.md): Boeing 737-200 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Mar 21, 1983 · N7358F · Minor damage > During takeoff the inboard left main landing gear tire & wheel departed the acft. The flight returned and landed withoutfurther incident. Examination of the wheel rim revealed multiple fatigue cracks in the rim. - [NTSB MIA83FA093](https://openairdocs.org/ntsb/MIA83FA093.md): Mooney M20J · Tampa, FL · Accident · Serious injuries · Field investigation · Final report · Mar 20, 1983 · N1166U · Destroyed > The accident occurred during an instrument takeoff in IMC. The sky was obscured & visibility zero. After lift-off the acft began to settle. The plt stated he aggravated the situation by advancing down trim which was his routine to establish a 5 deg climb… - [NTSB ANC83LU001](https://openairdocs.org/ntsb/ANC83LU001.md): Waspair HM-81 Tomcat Tour · Chugiak, AK · Accident · Serious injuries · Final report · Mar 20, 1983 · UNREG · Substantial damage > A test plt & dealer for the manufacturer inspected the ultralight vehicle & made adjustments prior to making a test flight after it was assembled. He stated that before takeoff, he was having problems setting the carburetor mixture & that the throttle cable… - [NTSB MIA83LA102](https://openairdocs.org/ntsb/MIA83LA102.md): Gemini Int'l. Humingbird · Lakeland, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 19, 1983 · N3147G · Substantial damage > The acft landed hard and collapsed the nose gear after one engine failed during takeoff. The acft had made one takeoff and landing and was beginning a second. As the acft rotated the left engine failed due to the throttle linkage becoming disconnected. The… - [NTSB FTW83LA159](https://openairdocs.org/ntsb/FTW83LA159.md): Cessna 150J · El Dorado, AR · Accident · No injuries · Limited investigation · Final report · Mar 19, 1983 · N5512G · Substantial damage > The acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After… - [NTSB LAX83LA143](https://openairdocs.org/ntsb/LAX83LA143.md): Piper PA-36-285 · Tipton, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1983 · N400HP · Substantial damage > During takeoff, at aprx 80 ft AGL, the eng backfired then lost power. The plt chose an open field for an emergency landing while trying to dump the load. While landing, the acft bounced, rolled about 600 ft, then hit a dirt berm & subsequently came to rest in… - [NTSB LAX83LA142](https://openairdocs.org/ntsb/LAX83LA142.md): Cessna T188C · Clarksburg, CA · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N9957J · Substantial damage > According to the plt, he was taking off from a narrow gravel strip with a x-wind when he encounter a strong gust. Reportedly, he lost control when the acft was about 1 ft AGL & the right main wheel hit a ditch. Subsequently, the acft was spun around & was… - [NTSB SEA83FU001](https://openairdocs.org/ntsb/SEA83FU001.md): Weedhopper 1 · Woodinville, WA · Accident · Serious injuries · Final report · Mar 15, 1983 · UNREG · Substantial damage > The plt took off in an ultralight vehicle from a sod field. Witnesses observed that the right wing tip was dropped during the takeoff. At aprx 200 ft AGL, the vehicle entered a right spiral & impacted the ground. The lower, right wing, left/drag strut pin was… - [NTSB NYC83FNC01](https://openairdocs.org/ntsb/NYC83FNC01.md): Quickie Q-2 · Norridgewock, ME · Accident · Serious injuries · Final report · Mar 14, 1983 · N298P · Substantial damage > The new home-built acft had no previous flt time. After making preparations, the plt taxied to rwy 33 for high speed taxi runs with runway lift-offs. On the first high speed run, he lifted off to about 20 ft AGL, then landed back on the rwy. He reported that… - [NTSB MIA83LA100](https://openairdocs.org/ntsb/MIA83LA100.md): Quicksilver Quicksilver MX II · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Mar 14, 1983 · N3132S · Substantial damage > The acft collided with a sand hill at the departure end of the runway when the acft failed to accelerate sufficiently following a partial power loss during takeoff. According to the operator spark plug fouling in the engine was the cause of the partial power… - [NTSB FTW83FA149](https://openairdocs.org/ntsb/FTW83FA149.md): Piper PA-34-200 · Kingston, OK · Accident · 3 fatal · Field investigation · Final report · Mar 12, 1983 · N43480 · Destroyed > The acft rolled right after a premature liftoff due to a dip in the rwy. The acft continued to roll right until it impacted a 6 degree slope in a 100 degree nose down attitude. Investigation revealed that the right engine had suffered a power loss due to a… - [NTSB LAX83LA134](https://openairdocs.org/ntsb/LAX83LA134.md): Enstrom F280C · Concord, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1983 · N5691H · Substantial damage > The helicopter collided with a tree during a landing after a decay in rotor RPM during takeoff. According to the pilot the acft was facing southeast prior to departure and the pilot estimated that the wind was from the northwest at 8 KTS. Following a pedal… - [NTSB LAX83LA133](https://openairdocs.org/ntsb/LAX83LA133.md): Cessna 188B · Delhi, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1983 · N731JK · Destroyed > The plt reported that he had been spraying fertilizer in the area all day. While taking off from a strip surrounded by trees, the acft climbed above the treetops, then began to settle. Subsequently, it crashed into almond trees & burned. The plt stated that… - [NTSB FTW83LA148](https://openairdocs.org/ntsb/FTW83LA148.md): Piper PA-38-112 · Breckenridge, TX · Accident · No injuries · Limited investigation · Final report · Mar 11, 1983 · N24147 · Substantial damage > The student plt stated that she initiated rotation for takeoff at 58 to 60 mph. Very shortly after lift-off, the left wing dropped. The student stated that she seemed to have no control over the acft after the left wing dropped & that she never heard the… - [NTSB LAX83LA130](https://openairdocs.org/ntsb/LAX83LA130.md): Cessna 195 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Mar 8, 1983 · N1560D · Substantial damage > At about 50 ft AGL during the takeoff portion of a touch-and-go, the eng loss power & the acft crashed into a fence. Thecarburetor bowl was drained & about 2/3 of the fluid was determined to be water. The fuel strainer also contained water. - [NTSB LAX83LA127](https://openairdocs.org/ntsb/LAX83LA127.md): Cessna 310C · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 1983 · N1884H · Substantial damage > The plt reported that when he was taking off, he heard a noise, during gear retraction, that sounded to him like an explosion & the gear-up light did not illuminate. He then tried to extend the gear, but was unable to get a safe-down indication. He was able… - [NTSB CHI83LA129](https://openairdocs.org/ntsb/CHI83LA129.md): Rand KR1 KR-1 · Watervliet, MI · Accident · No injuries · Limited investigation · Final report · Mar 6, 1983 · N4306 · Destroyed > The pilot stated that he had flown the aircraft on the previous day and the operation had been satisfactory. Prior to that flight the aircraft had not been flown for two years. After takeoff he experienced power interruption, made a 180 degree turn back to… - [NTSB LAX83FA123](https://openairdocs.org/ntsb/LAX83FA123.md): Piper PA-38-112 · Blythe, CA · Accident · Minor injuries · Field investigation · Final report · Mar 5, 1983 · N9716T · Destroyed > Shortly after takeoff the acft experienced a power loss. During the subsequent forced landing the acft collided with trees. Wreckage examination disclosed no evidence of fuel and the engine operated normally during a functional test conducted 6 days after the… - [NTSB LAX83FA122](https://openairdocs.org/ntsb/LAX83FA122.md): Cessna 210M · La Verne, CA · Accident · No injuries · Field investigation · Final report · Mar 4, 1983 · N761RG · Substantial damage > The pilot had found water in the wing tanks during his preflt but did not drain the fuel accumulator tanks as he was not aware of their existence. The engine sputtered and quit at 100 ft AGL, but the pilot was able to negotiate a landing on the arpt.… - [NTSB ATL83LA125](https://openairdocs.org/ntsb/ATL83LA125.md): Rockwell 112A · Chestertown, MD · Accident · No injuries · Limited investigation · Final report · Mar 3, 1983 · N1461J · Substantial damage > The aircraft settled back to the right of the runway during takeoff and struck an old stanchion used for runway lights. The pilot was unsure of the extent of damage and elected to re-land the aircraft. The landing gear had already been raised, so the landing… - [NTSB FTW83FA134](https://openairdocs.org/ntsb/FTW83FA134.md): Piper PA-28-181 · La Grange, TX · Accident · Serious injuries · Field investigation · Final report · Mar 2, 1983 · N8384A · Destroyed > The plt elected to takeoff to the north on a downsloping paved road. He reported that the wind was variable from the southwest at 2 to 4 KTS, gusting 4 to 6 KTS. At austin, TX, the wind was from 190 deg at 13 gusting 20 KTS & at college station, TX, it was… - [NTSB FTW83FA133](https://openairdocs.org/ntsb/FTW83FA133.md): Cessna 177 · Borger, TX · Accident · 3 fatal · Field investigation · Final report · Mar 2, 1983 · N29302 · Destroyed > According to 2 plt witnesses, the acft stalled during takeoff after it had climbed to aprx 75 to 100 ft AGL. They reported that at that time, it did a wing-over, entered a dive & crashed. Reportedly, the acft was loaded to near its max gross wt limit. The… - [NTSB CHI83LA127](https://openairdocs.org/ntsb/CHI83LA127.md): Aeronca Champion 7AC · Newberry, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 1983 · N84583 · Destroyed > The aircraft collided with a telephone pole while attempting a takeoff on skis. The snow was wet, sparse and sticky and the takeoff was being performed on a taxiway because it had more snow. This was a dual instructional flight with the student at the… - [NTSB CHI83FA122](https://openairdocs.org/ntsb/CHI83FA122.md): Cessna 150 · Wheeling, IL · Accident · No injuries · Field investigation · Final report · Feb 26, 1983 · N63044 · Destroyed > The student pilot was making a touch-and-go landing and at about 100 ft AGL the engine stopped. A restart was to no avail. The plt stated that he kept the airspeed near stall speed until ground impact. There was fuel spillage at the accident site and no… - [NTSB SEA83LA059](https://openairdocs.org/ntsb/SEA83LA059.md): Hiller UH-12D · Near Oakridge, OR · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N62398 · Substantial damage > According to the pilot, a 250 lb load on a 30 ft external line had been set down at a site at an elevation of about 3500 ft MSL. After the load was released, the pilot attempted to transition from a hover to a climb, but the helicopter began to settle.… - [NTSB LAX83LA117](https://openairdocs.org/ntsb/LAX83LA117.md): Bell BH 206-L111 · Peach Springs, AZ · Accident · No injuries · Limited investigation · Final report · Feb 24, 1983 · N3898Y · Substantial damage > After the rotorcraft took off to a hover the pilot did a pedal turn for a down canyon departure. After the hover turn the pilot slid to the right to clear some obstacles and when the rotorcraft moved laterally about 25 feet the pilot heard a bang. The left… - [NTSB MIA83FA081](https://openairdocs.org/ntsb/MIA83FA081.md): Cessna 182H · Chuluota, FL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1983 · N2081X · Destroyed > The acft crashed from 200 ft AGL on takeoff. Witnesses said the engine quit and the acft made a steep left turn and then dove straight to the ground. The acft had almost made a 180 degree turn to line up with state road 419 when it crashed. This road… - [NTSB MIA83FLD03](https://openairdocs.org/ntsb/MIA83FLD03.md): Cessna 182 · Zephyrhills, FL · Accident · Serious injuries · Final report · Feb 21, 1983 · CGNHL · Destroyed > On initial climb at about 250 ft AGL the engine failed. Water was found in the gascolator and in the fuel tanks. A wrinkled ridge was found in the fuel tank bottom which trapped water. - [NTSB LAX83LA112](https://openairdocs.org/ntsb/LAX83LA112.md): Bell 47G3B-2 · Merced, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N88CP · Destroyed > The eng lost power at about 20 ft AGL for undetermined reasons. - [NTSB ANC83FU002](https://openairdocs.org/ntsb/ANC83FU002.md): Eagle B · Chugiak, AK · Accident · 1 fatal · Final report · Feb 21, 1983 · UNREG · Substantial damage > Reportedly, the plt took off from a yard, and when the ultralight vehicle had climbed to about 200 ft AGL, the eng lost RPM momentarily, then regained power. A witness reported that when the RPM decreased, the ultralight nosed over & went upside down. During… - [NTSB NYC83LA070](https://openairdocs.org/ntsb/NYC83LA070.md): Cessna 152 · Bally, PA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N25565 · Substantial damage > The pilot reported that he initiated his takeoff from the 1300 ft/blacktop portion of a 2500 ft runway. The remainder of the runway was sod. He stated that he rotated for takeoff about 50 ft from the end of the blacktop portion at 56 to 58 KTS. Also, he… - [NTSB LAX83LA108](https://openairdocs.org/ntsb/LAX83LA108.md): Cessna 172C · Rubidoux, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1983 · N8347X · Destroyed > The acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field… - [NTSB FTW83LA123](https://openairdocs.org/ntsb/FTW83LA123.md): Cessna 180H · Chandeleur Isl., LA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N9080M · Destroyed > The plt elected to takeoff on a sandy beach aprx 1800 to 2000 ft long. There was a gradual curve in the beach for most of the takeoff distance. The plt reported that there was debris on the beach that was too heavy to move, which he had to dodge with less… - [NTSB ATL83LA109](https://openairdocs.org/ntsb/ATL83LA109.md): Piper J-3C · Stockbridge, GA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N88037 · Substantial damage > The acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=207 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=206 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.