# 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 204 of 412 · 20,559 cases

## Cases, newest first

- [NTSB LAX83FA274](https://openairdocs.org/ntsb/LAX83FA274.md): Mooney M20J · Death Valley, CA · Accident · Serious injuries · Field investigation · Final report · Jun 9, 1983 · N3894H · Destroyed
  > The plt initiated his takeoff from the Death Valley arpt at about 1530 hrs on a hot day. Subsequently, the acft collidedwith trees on the left side of the rwy & crashed. An investigation revealed that the acft had angled to the left prior to reaching the 1000…
- [NTSB FTW83LA273](https://openairdocs.org/ntsb/FTW83LA273.md): Cessna 152 · Addison, TX · Accident · No injuries · Limited investigation · Final report · Jun 9, 1983 · N65419 · Substantial damage
  > The plt reported that during takeoff, the acft 'immediately slid sideways' as the nosewheel lifted off. According to a witness, the acft weathervaned/veered into the wind. Subsequently, the plt reduced power & the acft dropped from about 15 ft AGL to the…
- [NTSB MKC83FU003](https://openairdocs.org/ntsb/MKC83FU003.md): Airmass Sunburst · Pittsburg, KS · Accident · 1 fatal · Final report · Jun 8, 1983 · UNREG · Substantial damage
  > The plt had completed a private plt ground school course & had flown aprx 4.6 hrs in a Cessna 172 before flying his home built ultralight vehicle. During a test flt, he was making a go-around from a touch-and-go landing when the vehicle crashed. A witness…
- [NTSB LAX83LA268](https://openairdocs.org/ntsb/LAX83LA268.md): Piper PA-28RT-201 · Meadview, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1983 · N8348Z · Substantial damage
  > The pilot stated that shortly after takeoff at aprx 100 feet, the engine lost power. He then switched the boost pumps from low to high and the engine momentarily surged before losing power. During the forced landing the landing gear collapsed and the wings…
- [NTSB SEA83LA119](https://openairdocs.org/ntsb/SEA83LA119.md): Bell 205A-1 · Near Randle, WA · Accident · No injuries · Limited investigation · Final report · Jun 6, 1983 · N98HJ · Substantial damage
  > The acft was engaged in log slinging operations and had just released a load and initiated a climb away from the site when according to the pilot the engine started to spool down, although the pilot was able return to the log-landingarea there was…
- [NTSB LAX83LA270](https://openairdocs.org/ntsb/LAX83LA270.md): Piper PA-28-140 · Concord, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1983 · N6714J · Substantial damage
  > The acft made a forced landing on the arpt after the engine lost power at 150-200 ft AGL on takeoff. The pilot said all preflt checks were normal. Post accident examination revealed no reason for a loss of power.
- [NTSB LAX83LA265](https://openairdocs.org/ntsb/LAX83LA265.md): Cessna 150 · Show Low, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 1983 · N51255 · Substantial damage
  > The acft stalled during a night takeoff and collided with the ground. The weather was VMC and no flight plan was filed. No one witnessed the takeoff as the airport was closed. It was a dark night and the student pilot had no night flying experience. The pilot…
- [NTSB FTW83LA268](https://openairdocs.org/ntsb/FTW83LA268.md): Cessna 185 · Mcallen, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1983 · N4016Y · Substantial damage
  > The eng quit during climbout. Inspection revealed that the fuel system contained about 50% clear liquid other than gasoline. The acft had sat with its tanks empty for the past 7-10 days.
- [NTSB ATL83LA219](https://openairdocs.org/ntsb/ATL83LA219.md): Cessna 172M · Kingston, TN · Accident · No injuries · Limited investigation · Final report · Jun 6, 1983 · N13881 · Substantial damage
  > The plt checked the wx conditions before operating on the 1020 ft grass strip. He landed on the strip at 0935 EDT, took off again about 10 min later, then returned & landed again. Aprx 1 hr & 5 min after his 1st takeoff, he started another departure with 20…
- [NTSB DEN83LA134](https://openairdocs.org/ntsb/DEN83LA134.md): Piper PA-28-235 · Hamilton, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1983 · N8787W · Substantial damage
  > Ground roll during takeoff was normal but at liftoff the acft began a roll to the left. The pilot said he began the takeoff with less than full power but added full power as the turn began. He tried to correct with aileron to no avail. The acft was now…
- [NTSB CHI83LU002](https://openairdocs.org/ntsb/CHI83LU002.md): Barnstormer 1 · Newton, IL · Accident · Serious injuries · Final report · Jun 5, 1983 · UNREG · Destroyed
  > During takeoff, the right wing collapsed when the ultralight vehicle was climbing thru aprx 100 ft AGL. An investigation disclosed that the right wing spar failed allowing the section, outboard of the strut attach point, to fold upward.
- [NTSB FTW83LA267](https://openairdocs.org/ntsb/FTW83LA267.md): Grumman G-164B · Kinder, LA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N6642K · Substantial damage
  > The acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…
- [NTSB NYC83FNC05](https://openairdocs.org/ntsb/NYC83FNC05.md): Enstrom 280C · New Market, NH · Accident · Minor injuries · Final report · Jun 2, 1983 · N587H · Substantial damage
  > After completing a normal run-up & mag check, the plt hovered in ground effect. A normal takeoff was then made in groundeffect. At about 200 ft AGL the plt noticed the RPM dropping from 2900 to about 2700. He tried to restore by dropping collective &…
- [NTSB CHI83LA236](https://openairdocs.org/ntsb/CHI83LA236.md): Cessna 177B · Jackson, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 1983 · N20082 · Substantial damage
  > The plt stated the eng quit at about 100-200 ft AGL after takeoff. He executed a descending right turn to remain within the arpt boundary & the acft struck the ground. The upper portion of the magneto mount flange was broken & the magneto was hanging by the…
- [NTSB FTW83FA259](https://openairdocs.org/ntsb/FTW83FA259.md): Cessna 180J · Harvey, LA · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1983 · N52072 · Destroyed
  > A navigable waterway, Harvey canal, was being used as a seaplane base. In that area, a set of power lines were suspended over the canal by 2 tall towers. The lowest line over the canal was 160 ft above the canal surface, but the lines dropped to heights of…
- [NTSB ATL83LA205](https://openairdocs.org/ntsb/ATL83LA205.md): Grumman G-164B · Blakely, GA · Accident · No injuries · Limited investigation · Final report · Jun 1, 1983 · N8476K · Destroyed
  > Shortly after takeoff, the eng sputtered, lost power & belched black & gray smoke. The plt was unable to get the acft to maintain altidude. Also, he was unable to reach an open field, so he landed on the tops of trees. An investigation revealed that the front…
- [NTSB MIA83FA149](https://openairdocs.org/ntsb/MIA83FA149.md): Piper PA-23C-250 · Ft. Lauderdale, FL · Accident · 5 fatal · Field investigation · Final report · May 31, 1983 · N6103Y · Destroyed
  > The acft crashed shortly after takeoff. According to witnesses, the acft veered to the left losing altitude and suddenlyflipped to the left crashing about 1/2 mile from the arpt in a steep left bank. The landing gear was reported in a down position. An…
- [NTSB DEN83LA124](https://openairdocs.org/ntsb/DEN83LA124.md): Aerospatiale SA-315B · Kemmerer, WY · Accident · Minor injuries · Limited investigation · Final report · May 31, 1983 · N16297 · Substantial damage
  > The helicopter crashed during takeoff. The weather was VMC and a company VFR flight plan was on file. According to the pilot, he tookoff and brought the acft to a hover, made a right pedal turn and accelerated for a normal takeoff. The acft suddenly jerked,…
- [NTSB LAX83LA250](https://openairdocs.org/ntsb/LAX83LA250.md): Cessna 337B · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N2368S · Substantial damage
  > The acft made a forced landing and collided with a pine tree after a takeoff with a tow bar attached to the nose gear. The pilot reported that he attached a tow bar to get the acft level to measure the oil quantity in the engine. After thepreflt inspection he…
- [NTSB FTW83LA333](https://openairdocs.org/ntsb/FTW83LA333.md): Cessna 152 · Bon Wier, TX · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N714UX · Substantial damage
  > The acft collided with a fence during takeoff from an unimproved field. The plt and his wife had departed houston TX theday before for a 'local' flt. Due to mechanical difficulties a landing was made at Bon Wier. According to the plt, although relatives live…
- [NTSB FTW83LA260](https://openairdocs.org/ntsb/FTW83LA260.md): Balloon Works Firefly 7 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N2375H · Substantial damage
  > According to the plt, a unauthorized ground crew relieved the plt's crew & would not follow his instructions. After the ground crew moved the Balloon into a position that was upwind from a light pole, they released it & it ascending. The plt stated that he…
- [NTSB ATL83FIA01](https://openairdocs.org/ntsb/ATL83FIA01.md): Champion 402 · Friendly, MD · Accident · Minor injuries · Final report · May 30, 1983 · N9966Y · Substantial damage
  > The left engine quit at 400 feet after takeoff. After the accident fuel was found draining from the right tank filler opening. The acft was leveled and the engine started with boost pump and pumping throttle. The engine was started twice but would not…
- [NTSB MKC83LA117](https://openairdocs.org/ntsb/MKC83LA117.md): Mooney M20C · Wheatland, MO · Accident · No injuries · Limited investigation · Final report · May 29, 1983 · N6288U · Destroyed
  > The pilot said the engine lost power after takeoff and settled into trees off the end of the rwy. The engine, damaged by fire, was examined and there was no evidence of pre-impact failures or deficiencies.
- [NTSB SEA83FYK03](https://openairdocs.org/ntsb/SEA83FYK03.md): Ryan-Navion NAV 4 · Cottage Grove, OR · Accident · Serious injuries · Final report · May 28, 1983 · N4468K · Substantial damage
  > The acft made a forced landing in a hay field and collaped the landing gear after the engine quit at 500 ft AGL during takeoff climb. During an on scene investigation there was no fuel visible in the rt wing tank. The left wing tank has nofiller access but is…
- [NTSB ATL83LA209](https://openairdocs.org/ntsb/ATL83LA209.md): Barnes AX-6B · Decatur, AL · Accident · Serious injuries · Limited investigation · Final report · May 28, 1983 · N2023H · Destroyed
  > The balloon was launched from a field with power lines along the east side after another balloon was launched. The first balloon was aprx 50 ft from the power line when it was launched. When it tookoff, it traveled to the north northwest & remained well clear…
- [NTSB ATL83LA203](https://openairdocs.org/ntsb/ATL83LA203.md): Aeronca C3 · Ocean City, MD · Accident · Serious injuries · Limited investigation · Final report · May 28, 1983 · N16270 · Substantial damage
  > At about 150 ft AGL after takeoff the acft stalled. The plt previously had an accident with the acft on 6/13/82. Since that date he had recorded 17 hrs of flt time with less than 1 hr in a J-3 cub. The J-3 is similar to the Aeronca C3 in size but with twice…
- [NTSB ATL83FKJ04](https://openairdocs.org/ntsb/ATL83FKJ04.md): Cessna 310 · Decatur, AL · Accident · Serious injuries · Final report · May 28, 1983 · N8KD · Destroyed
  > The pilot stated that just after retracting the landing gear, the left engine appeared to quit. Unable to maintain flying speed, he elected to land in an open field but was unable to clear a row of trees. The acft impacted the ground after striking the trees.…
- [NTSB SEA83FU004](https://openairdocs.org/ntsb/SEA83FU004.md): Waspair Tomcat · Ketchikan, AK · Accident · Serious injuries · Final report · May 27, 1983 · UNREG · Substantial damage
  > The plt stated that virtually calm wind conditions existed prior to takeoff to the south, the direction of the prevailing winds. At about 25 ft AGL, the ultralight encountered a strong northerly (tailwind) gust. The ultralight tumbled & struck the ground.…
- [NTSB DEN83FA122](https://openairdocs.org/ntsb/DEN83FA122.md): Bell 206B · Billings, MT · Accident · No injuries · Field investigation · Final report · May 27, 1983 · N16937 · Substantial damage
  > The helicopter made a hard autorotative landing after takeoff from an off arpt landing stie. The plt was on a personal flt with family and friends when a engine fire/explosion forced him to land. The fire was extinguished by the plt after landing. Post…
- [NTSB CHI83LA232](https://openairdocs.org/ntsb/CHI83LA232.md): Boeing A75N1 · Lebanon, IN · Accident · 1 fatal · Limited investigation · Final report · May 27, 1983 · N52470 · Substantial damage
  > The plt had flown the acft to boone county arpt to get the acft's carburetor adjusted. After the adjustment, he took off to the south on a grass rwy beside the concrete rwy. While climbing thru about 300 to 400 ft AGL, the eng began running rough. The plt…
- [NTSB NYC83FNC03](https://openairdocs.org/ntsb/NYC83FNC03.md): Lake LA-4-200 · Vinalhaven, ME · Accident · Serious injuries · Final report · May 25, 1983 · N5015L · Destroyed
  > The acft crashed following a water takeoff from a small Lake. The pilot and witnesses stated that for approximately two hours before departure an attempt was made to remove water from the tail section of the acft. The water had accumulated due to a missing…
- [NTSB LAX83LA251](https://openairdocs.org/ntsb/LAX83LA251.md): Piper PA-28-180 · Aguanga, CA · Accident · No injuries · Limited investigation · Final report · May 25, 1983 · N4964L · Substantial damage
  > The acft collided with an abandoned auto during an aborted takeoff. The pilot said he applied full power during takeoff and accelerated to about 85 mph and rotated. At about 15 ft AGL the engine seemed to lose power. The pilot said the engine did not sputter…
- [NTSB FTW83LA247](https://openairdocs.org/ntsb/FTW83LA247.md): Fairchild Hiller FH-1100 · Beaumont, TX · Accident · No injuries · Limited investigation · Final report · May 25, 1983 · N543FH · Substantial damage
  > The helicopter was damaged in an emergency landing in a street. The acft had just taken off from an adjoining parking lot in a shopping center. According the plt the acft lost rotor RPM at 150-175 ft during climb after takeoff and went into a 'settling with…
- [NTSB FTW83LA246](https://openairdocs.org/ntsb/FTW83LA246.md): Cessna 172 · Timpson, TX · Accident · Minor injuries · Limited investigation · Final report · May 24, 1983 · N62969 · Substantial damage
  > Acft stalled on takeoff.
- [NTSB DEN83LA117](https://openairdocs.org/ntsb/DEN83LA117.md): Aircoupe 415-C · Big Piney, WY · Accident · Minor injuries · Limited investigation · Final report · May 22, 1983 · N3726H · Substantial damage
  > The pilot was practicing a short field takeoff. However, he held the elevator full back during the takeoff roll until the acft was 50 ft AGL, and then only released it slightly. According to the pilot, airspeed was 47 mph at 50 ft and about 57 mph at 70 ft.…
- [NTSB ATL83LA195](https://openairdocs.org/ntsb/ATL83LA195.md): Cessna 182P · Nashville, TN · Accident · No injuries · Limited investigation · Final report · May 22, 1983 · N52848 · Substantial damage
  > The acft nosed over during a forced landing after the engine quit during takeoff at about 150 ft AGL. After the engine stoppage the pilot said he applied carburetor heat with no effect. A landing was made in a grain field straight ahead. During the landing…
- [NTSB CHI83LA223](https://openairdocs.org/ntsb/CHI83LA223.md): Schreder HP12A · Stanton, MN · Accident · Serious injuries · Limited investigation · Final report · May 21, 1983 · N544J · Substantial damage
  > The pilot performed his preflight checks including a flight control check. After lift off the pilot could not control the pitch of the glider. As the pitch increased to about 30 degrees he elected to release the tow cable from the tow aircraft. The glider…
- [NTSB ANC83LA077](https://openairdocs.org/ntsb/ANC83LA077.md): Piper PA-12 · Aniak, AK · Accident · Serious injuries · Limited investigation · Final report · May 21, 1983 · N2725M · Substantial damage
  > According to the plt, he was taking off downslope & downwind on bumpy muskeg/tundra with full flaps. At aprx 40 to 45 mph, the acft lifted off before reaching the edge of a deep ravine. He began a shallow left turn, then the left wing struck a tree which spun…
- [NTSB SEA83LA102](https://openairdocs.org/ntsb/SEA83LA102.md): Cessna TRI82 · Idaho Falls, ID · Accident · Serious injuries · Limited investigation · Final report · May 20, 1983 · N757SP · Destroyed
  > During takeoff, the engine lost power after the plt started to make a turn at aprx 500 ft AGL. An emergency landing was made in a plowed field with the gear & flaps retracted. After touchdown, the acft slid aprx 100 yards, then stopped in a canal. An…
- [NTSB NYC83LA120](https://openairdocs.org/ntsb/NYC83LA120.md): Globe GC-1B · Bedford, MA · Accident · No injuries · Limited investigation · Final report · May 19, 1983 · N3201K · Substantial damage
  > The engine quit at 250 feet during the takeoff climb. No cause for the engine failure was found.
- [NTSB LAX83LU005](https://openairdocs.org/ntsb/LAX83LU005.md): Wizard W-1 · Shafter, CA · Accident · Serious injuries · Final report · May 19, 1983 · UNREG · Minor damage
  > The vehicle involved in this mishap was a Wizard W-1 ultralight which was assembled from a kit supplied by the manufacturer, us, inc. it was designed to be controller by 'weight shifts' of the plt, and featured a ground adjustable fixed horizontal stabilizer…
- [NTSB LAX83LA243](https://openairdocs.org/ntsb/LAX83LA243.md): Grumman G-164A · Willows, CA · Accident · No injuries · Limited investigation · Final report · May 19, 1983 · N48381 · Substantial damage
  > The acft collided with the terrain shortly after takeoff. The pilot stated he noticed signs of a 'power loss'. Trying toland on a highway he abandoned his approach because of traffic and headed for a plowed field. Without time to jettison his load he did not…
- [NTSB NYC83LA116](https://openairdocs.org/ntsb/NYC83LA116.md): Cessna 150G · So. Bethlehem, NY · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N3138X · Substantial damage
  > The pilot lost directional control during takeoff. The instructor pilot and student were not injured. The student tried to abort a takeoff when the acft started to swerve left. The instructor tried to correct but had difficulty because of the students input…
- [NTSB NYC83LA114](https://openairdocs.org/ntsb/NYC83LA114.md): Cessna 150L · Waterford, CT · Accident · No injuries · Limited investigation · Final report · May 17, 1983 · N11234 · Substantial damage
  > The acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…
- [NTSB CHI83LA219](https://openairdocs.org/ntsb/CHI83LA219.md): Piper PA25 · Tomah, WI · Accident · No injuries · Limited investigation · Final report · May 17, 1983 · N4521Y · Substantial damage
  > The acft lost power and made a forced landing immediately after takeoff on an aerial application mission. The landing gear collapsed during the landing. The pilot stated that the accident occurred on the 5th flt of the day after taking off on runway 27 and…
- [NTSB MKC83LA110](https://openairdocs.org/ntsb/MKC83LA110.md): Cessna 182P · Gardner, KS · Accident · Minor injuries · Limited investigation · Final report · May 16, 1983 · N780H · Destroyed
  > The acft was throughly preflighted to check for water in fuel. The acft had been outdoors in rain for several weeks. Run-up and taxi were normal. During right turn out of traffic the engine quit. The pilot made a landing in a field and nosed over. The acft…
- [NTSB NYC83LNC02](https://openairdocs.org/ntsb/NYC83LNC02.md): Aeronca 7AC · Johnson Pond, ME · Accident · Serious injuries · Final report · May 15, 1983 · N1241E · Destroyed
  > The acft lifted off from the surface of Johnson Pond and was climbing over trees when the plt made a sharp turn and the acft struck a tree. The acft then impacted the ground and was destroyed by impact and fire.
- [NTSB CHI83LA214](https://openairdocs.org/ntsb/CHI83LA214.md): Piper PA-22 · Spring Arbor, MI · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N3242Z · Substantial damage
  > The acft made a forced landing off the arpt when the engine quit during takeoff climb. The acft had about 1/2 a tank of fuel in both right and left tank before takeoff. The plt was using the right tank for takeoff. The plt had done a 180 degree left turn on…
- [NTSB NYC83LA112](https://openairdocs.org/ntsb/NYC83LA112.md): Forney F-1 · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · May 14, 1983 · N7528C · Substantial damage
  > The acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…
- [NTSB ATL83LA186](https://openairdocs.org/ntsb/ATL83LA186.md): Cummings Quickie Q2 · Asheboro, NC · Accident · Serious injuries · Limited investigation · Final report · May 13, 1983 · N3154Z · Destroyed
  > This particular home built acft was equipped with an 'aileron reflexer.' This modification allowed the plt to change the faired setting of the ailerons, above or below the normal neutral position. Reportedly, this adjustment would affect the lift of the main…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=205

## 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=204

---
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.