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

## Cases, newest first

- [NTSB LAX82DA186](https://openairdocs.org/ntsb/LAX82DA186.md): Bell 47G2 · Santa Maria, CA · Accident · No injuries · Final report · May 21, 1982 · N130V · Substantial damage
  > The helicopter contacted the platform with a landing skid and rolled over during an attempted takeoff. As the helicopterlifted off of a truck mounted platform a skid became fouled by the truck and a dynamic roll-over occurred.
- [NTSB CHI82DA178](https://openairdocs.org/ntsb/CHI82DA178.md): Balloon Works FIREFLY-7 · Wyoming, MI · Accident · No injuries · Final report · May 20, 1982 · N1533N · Substantial damage
  > The pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.
- [NTSB FTW82DA183](https://openairdocs.org/ntsb/FTW82DA183.md): Champion 7EC · Southlake, TX · Accident · No injuries · Final report · May 19, 1982 · N7477B · Substantial damage
  > During takeoff, the private pilot sitting in the front seat, thought the cowling was loose. The pilot informed the owner and commercial pilot in the rear seat who took control and decided to return to the airport. The pilot landed short of the runway and the…
- [NTSB MIA82FA120](https://openairdocs.org/ntsb/MIA82FA120.md): Piper P-60-601P · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · May 18, 1982 · N90702 · Destroyed
  > Shortly after takeoff witnesses observed the acft in a steep left bank descending until it crashed approximately 1200 ftnw of the departure end of the rwy. According to the pax the initial climb distracting the attention of the plt who lostcontrol of the acft…
- [NTSB LAX82DA181](https://openairdocs.org/ntsb/LAX82DA181.md): Grumman G-164 · 10 West Of Bigg, CA · Accident · Minor injuries · Final report · May 17, 1982 · N10280 · Substantial damage
  > During takeoff, the engine began to vibrate and lose power. While landing in the only available area, one of the main gear dug into a soft spot and the aircraft flipped over. An investigation revealed that the no. 4 cylinder had become cracked from the front…
- [NTSB NYC82FHD19](https://openairdocs.org/ntsb/NYC82FHD19.md): Luscombe 8A · Bargaintown, NJ · Accident · No injuries · Final report · May 16, 1982 · N28432 · Destroyed
  > At about 50 ft AGL after takeoff the eng lost power & the acft settled into trees. The plt stated the eng quit due to carburetor ice. The eng was tested & operated normally.
- [NTSB NYC82FFA05](https://openairdocs.org/ntsb/NYC82FFA05.md): Navion A · Hancock, NY · Accident · Serious injuries · Final report · May 16, 1982 · N91662 · Substantial damage
  > The pilot reported that during takeoff, he climbed to about 20 to 30 ft and raised the gear. At about that time, the aircraft began to sink. He stated that he pulled the power off just before the aircraft hit the ground a few miles from the airport. An…
- [NTSB CHI82DA172](https://openairdocs.org/ntsb/CHI82DA172.md): Oldfield Baby Lakes · Middlefield, OH · Accident · No injuries · Final report · May 16, 1982 · N120R · Substantial damage
  > The aircraft quit during takeoff climb. The pilot reversed course and the engine started again for a short period then stopped. The pilot attempted to land on a taxiway but hit the raised lip of the taxiway. The right main landing gear failed. No preimpact…
- [NTSB CHI82DA167](https://openairdocs.org/ntsb/CHI82DA167.md): Piper PA-22-150 · Harrison, MI · Accident · No injuries · Final report · May 16, 1982 · N6939B · Substantial damage
  > During takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.
- [NTSB MKC82DA080](https://openairdocs.org/ntsb/MKC82DA080.md): Bell 47G-2 · Osage Beech, MO · Accident · No injuries · Final report · May 15, 1982 · N208B · Destroyed
  > Shortly after the helicopter cleared the helipad the pilot noticed that although he had the cyclic positioned in the full forward position against the stop the airspeed was gradually decaying. The pilot then removed his seatbeat and moved forward. Along with…
- [NTSB LAX82FA174](https://openairdocs.org/ntsb/LAX82FA174.md): Martin 404 · Madera, CA · Accident · No injuries · Field investigation · Final report · May 15, 1982 · N40445 · Destroyed
  > After takeoff the aircraft was observed to trail a brown substance. About 3 miles from the airport the right engine oil pressure dropped. The pilot decided to return to the airport. When he thought the runway was attainable he lowered the flaps; however, a…
- [NTSB FTW82DA186](https://openairdocs.org/ntsb/FTW82DA186.md): Cessna 150 · Knowles, OK · Accident · No injuries · Final report · May 15, 1982 · N50994 · Substantial damage
  > During a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…
- [NTSB FTW82DA179](https://openairdocs.org/ntsb/FTW82DA179.md): Grumman G-164A · Farmington, NM · Accident · Minor injuries · Final report · May 15, 1982 · N6602Q · Destroyed
  > On takeoff for an aerial application flight at maximum gross weight the aircraft began to settle. The aircraft impacted the ground in a slightly nose-down attitude. Investigation revealed the accident site elevation was 5300 feet MSL and the takeoff was made…
- [NTSB FTW82DRG32](https://openairdocs.org/ntsb/FTW82DRG32.md): Air Tractor 301 · Mcallen, TX · Accident · Serious injuries · Final report · May 14, 1982 · N8523S · Substantial damage
  > The pilot reported that the engine failed shortly after takeoff. The aircraft was substantially damaged when it hit a canal bank at the end of the airstrip. According to the operator, the blower section failed which resulted in the loss of power.
- [NTSB ATL82DKJ13](https://openairdocs.org/ntsb/ATL82DKJ13.md): Cessna 150 · Wheeler, AL · Accident · Minor injuries · Final report · May 14, 1982 · N6301K · Destroyed
  > The pilot reported that during takeoff, the aircraft made a sharp, uncontrollable turn to the right when he was about 50 ft AGL. He stated that he could not hold the aircraft straight and it went down on the grass runway. Automotive fuel was found in the…
- [NTSB FTW82FA173](https://openairdocs.org/ntsb/FTW82FA173.md): Gulfstream American 980(695) · Carlsbad, NM · Accident · 2 fatal · Field investigation · Final report · May 13, 1982 · N9789S · Destroyed
  > The acft crashed about 1/2 mi sw of the departure end of rwy 32L. The rwy had been illuminated at the time of takeoff with the acft making a left turn into an area that was not illuminated toward the mountains. It was a very dark night with an…
- [NTSB CHI82DA164](https://openairdocs.org/ntsb/CHI82DA164.md): Grumman AA5 · Brookville, OH · Accident · Minor injuries · Final report · May 13, 1982 · N4522E · Substantial damage
  > On takeoff with 3 passengers and full fuel the pilot pulled the nose up and pushed the nose back down to build airpseed. The aircraft became uncontrollable, veered to the left, nosed over impacting the ground left wing first. The field elevation is 1040 feet…
- [NTSB ATL82FIJ02](https://openairdocs.org/ntsb/ATL82FIJ02.md): Piper PA-12 · Dunbar, WV · Accident · 2 fatal · Final report · May 10, 1982 · N7583H · Substantial damage
  > The pilot took off eastbound toward multiple power lines that crossed the river. The aircraft climbed to about 100 feet and was turning left away from the wires when it nosed over and crashed into the river. The pilot did not have a seaplane rating but had…
- [NTSB ATL82DA129](https://openairdocs.org/ntsb/ATL82DA129.md): Beech A23-24 · Kingston, TN · Accident · No injuries · Final report · May 10, 1982 · N5750V · Substantial damage
  > During takeoff, the engine lost power at about 300 ft AGL and the pilot ditched the plane in a lake. After the ditching, the pilot egressed from the plane and enter a fishing boat that pulled up alongside. Shortly after that, the plank sank. After the…
- [NTSB DEN82DA082](https://openairdocs.org/ntsb/DEN82DA082.md): Bellanca 17-31ATC · Walsh, CO · Accident · No injuries · Final report · May 9, 1982 · N4050B · Substantial damage
  > The pilot reported that during takeoff, the engine lost power at about 75 ft AGL. While making a forced landing, the aircraft struck large pipes that were laying on the ground. An investigation revealed the engine would run satisfactorly as long as the…
- [NTSB MKC82DA073](https://openairdocs.org/ntsb/MKC82DA073.md): Taylor Monoplane · Walden, MO · Accident · No injuries · Final report · May 8, 1982 · N32RA · Substantial damage
  > This was the aircraft's first flight as well as the pilot's first flight in this make and model. It was a home built plane that the pilot had recently completed. The pilot tookoff on runway 15 with wind from 190 degrees at 16 gusting 24 knots. During the…
- [NTSB LAX82FA163](https://openairdocs.org/ntsb/LAX82FA163.md): Thunder Balloons LTD. · Fountain Valley, CA · Accident · Serious injuries · Field investigation · Final report · May 8, 1982 · GBJZC · Minor damage
  > The pilot stated the balloon was inflated and established weigh-off procedures were conducted. At the end of the weight-off procedure, as the balloon was being walked by the ground handlers, an increase in wind velocity caused the basket to be pulled free…
- [NTSB FTW82DA169](https://openairdocs.org/ntsb/FTW82DA169.md): Grumman G164A · Welsh, LA · Accident · No injuries · Final report · May 8, 1982 · N9937 · Substantial damage
  > During the initial takeoff with a load of fertilizer the engine lost power and the load was dumped. A forced landing wasmade in a plowed, wet field and the aircraft nosed over. Investigation revealed the cylinder head failed.
- [NTSB DEN82DA081](https://openairdocs.org/ntsb/DEN82DA081.md): Piper PA-28R-200 · Medicine Bow, WY · Accident · No injuries · Final report · May 8, 1982 · N6994C · Substantial damage
  > During takeoff from a muddy field with a density altitude of 7253 feet the aircraft failed to clear a boundary fence. The passengers stated the stall warning sounded steadily from takeoff until impact with the ground. After the collision with the fence the…
- [NTSB CHI82DA156](https://openairdocs.org/ntsb/CHI82DA156.md): Piper PA-28-180 · Yale, MI · Accident · No injuries · Final report · May 8, 1982 · N15585 · Substantial damage
  > The pilot elected to make a go-around due to a wind shift. During the attempted go-around the aircraft collided with trees about 700 feet off the end of the runway and crashed in a corn field.
- [NTSB MKC82DA072](https://openairdocs.org/ntsb/MKC82DA072.md): Piper PA-18 · North Loup, NE · Accident · No injuries · Final report · May 7, 1982 · N4339Z · Substantial damage
  > The pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…
- [NTSB ATL82DA125](https://openairdocs.org/ntsb/ATL82DA125.md): Piper PA-38-112 · Jonesboro, TN · Accident · No injuries · Final report · May 5, 1982 · N900AA · Substantial damage
  > After utilizing the southwest runway for takeoff and landing the pilot noted that the limp windsock had shifted to indicate use of the northeast runway. The next takeoff was therefore made to the northeast, with an uphill gradient to the runway. After a…
- [NTSB SEA82FA064](https://openairdocs.org/ntsb/SEA82FA064.md): Cessna 150H · Oregon City, OR · Accident · 2 fatal · Field investigation · Final report · May 4, 1982 · N6752S · Destroyed
  > The aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…
- [NTSB FTW82DA164](https://openairdocs.org/ntsb/FTW82DA164.md): Grumman G-164B · Houston, TX · Accident · No injuries · Final report · May 4, 1982 · N6746K · Substantial damage
  > After takeoff the engine lost power and the aircraft was landed in a plowed field. During the landing roll the aircraft nosed over. An engine teardown revealed water and contamination of the fuel system.
- [NTSB ANC82DA039](https://openairdocs.org/ntsb/ANC82DA039.md): Hughes 369HS · Tok, AK · Accident · No injuries · Final report · May 4, 1982 · N9239F · Substantial damage
  > The pilot was conducting a non-revenue, sling-load operation on mt neuberer, while donating his services to Tok community tv, inc. he stated that he was lifting three empty propane bottles from a snow field when he noticed the auto relight lamp flash. He…
- [NTSB NYC82DA085](https://openairdocs.org/ntsb/NYC82DA085.md): Rayan NAV-4 · Bloomsburg, PA · Accident · No injuries · Final report · May 2, 1982 · N4540K · Destroyed
  > After takeoff the pilot smelled smoke and observed the oil pressure drop to 20 PSI. When the oil pressure continued to drop the pilot decided to land at Bloomsburg airport, approximately 3 miles away. After landing the pilot taxied off the runway and the…
- [NTSB FTW82DA158](https://openairdocs.org/ntsb/FTW82DA158.md): Piper PA-31-350 · Midland, TX · Accident · No injuries · Final report · May 2, 1982 · N70TT · Substantial damage
  > During a business flight the aircraft's engines quit. The pilot attempted a gear-up emergency landing in a residential area. The aircraft impacted one pickup and two cars during the landing. Investigation revealed the aircraft had been mistakenly fueled with…
- [NTSB CHI82FA145](https://openairdocs.org/ntsb/CHI82FA145.md): Cessna 172M · Pardeeville, WI · Accident · 1 fatal · Field investigation · Final report · May 2, 1982 · N12696 · Destroyed
  > According to witnesses the aircraft made a routine takeoff followed by an immediate left climbing turn. The aircraft was observed to lose airspeed and descend into the ground. Witnesses stated that the engine was running until ground impact.
- [NTSB DEN82DA080](https://openairdocs.org/ntsb/DEN82DA080.md): Piper PA-23 · Erie, CO · Accident · No injuries · Final report · May 1, 1982 · N13845 · Substantial damage
  > The aircraft lost power during takeoff climb and was landed straight ahead resulting in substantial damage. The fuel selector valve was hard to move and during tests moving it caused the engines to quit. Piper AD 80-18-10 warns that scott manufactured…
- [NTSB CHI82FA144](https://openairdocs.org/ntsb/CHI82FA144.md): Piper PA-28-140 · Bowling Green, OH · Accident · 4 fatal · Field investigation · Final report · May 1, 1982 · N40999 · Destroyed
  > The pilot started his takeoff with the aircraft about 198 lbs over its maximum gross weight limit. The plane was observed to lift off near the departure end of the runway, then continue in a nose high attitude. Some witnesses observed the wings rocking or…
- [NTSB ATL82DA119](https://openairdocs.org/ntsb/ATL82DA119.md): Cessna A188 · Columbus, MS · Accident · No injuries · Final report · May 1, 1982 · N9557G · Substantial damage
  > The pilot had landed in a farmer's field to reload his sprayer tank. Before takeoff, he noticed some cows had strayed onto the strip. He directed his loadcrew assistant to take his truck and clear the cows from the strip. After the cows were cleared, the…
- [NTSB ATL82IA121](https://openairdocs.org/ntsb/ATL82IA121.md): Piper PA-31-350 · Enterprise, AL · Incident · No injuries · Incident investigation · Final report · Apr 30, 1982 · N53RT · Minor damage
  > Shortly after liftoff, the pilot felt the aircraft yaw left and noticed that the left engine manifold pressure had dropped from 42" hg to 29" hg. He analysed a turbocharger failure and elected to keep the engine running in the normallyaspirated mode. At…
- [NTSB ANC82DA038](https://openairdocs.org/ntsb/ANC82DA038.md): Cessna 207 · New Stuyahok, AK · Accident · Minor injuries · Final report · Apr 29, 1982 · N6274H · Substantial damage
  > The pilot utilized a soft field technique and commenced his takeoff from the runway threshold. During takeoff run he observed the runway end markers and elected to put down full flaps. The aircraft became airborne just before colliding with the end marker and…
- [NTSB NYC82DA081](https://openairdocs.org/ntsb/NYC82DA081.md): Mooney M20J · Madison, CT · Accident · No injuries · Final report · Apr 28, 1982 · N1147W · Substantial damage
  > The pilot reported that during takeoff, the engine lost power at about 30 ft AGL. He switched tanks and checked that the boost pump was on, but the engine did not restart. The plane was landed in a marsh where it flipped over during touchdown. An inspection…
- [NTSB LAX82DA149](https://openairdocs.org/ntsb/LAX82DA149.md): Cessna 172 · Litchfield Park, AZ · Accident · No injuries · Final report · Apr 28, 1982 · N5434D · Substantial damage
  > The student was a private pilot who was practicing for a commercial certificate. During the flight, he elected to make a simulated emergency landing on a dirt strip. He stated that during the takeoff phase of a touch and go, he encountered a dust devil.…
- [NTSB FTW82FA155](https://openairdocs.org/ntsb/FTW82FA155.md): Cessna 411A · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1982 · N411HN · Destroyed
  > The acft was the second acft of a flight of two. The lead acft had received radio clearance for takeoff. The lead acft was to proceed to a visual checkpoint northwest of the arpt & wait for this acft to join up. Witnesses observed the acft depart rwy 17 &…
- [NTSB MIA82DLA05](https://openairdocs.org/ntsb/MIA82DLA05.md): Raz-Mut 440A · Deland, FL · Accident · 1 fatal · Final report · Apr 27, 1982 · N29826 · Substantial damage
  > The pilot of this amateur/experimental aircraft was on an initial test flight. During the takeoff roll, the aircraft was observed to swerve left and right just before lift-off. After lift-off, it was observed to climb to about 70 to 100 ft AGL and drift left.…
- [NTSB FTW82FA152](https://openairdocs.org/ntsb/FTW82FA152.md): Beech B23 · Roanoke, TX · Accident · 2 fatal · Field investigation · Final report · Apr 27, 1982 · N6502T · Destroyed
  > Witnesses reported that the aircraft appeared to takeoff and climb normally until it reached an altitude of about 100 ft AGL. It then pitched up abruptly to about a 70 deg nose high attitude. After the pitch-up, the aircraft climbed to about 175 to 200 ft…
- [NTSB FTW82FRA18](https://openairdocs.org/ntsb/FTW82FRA18.md): Beech A36TC · League City, TX · Accident · Serious injuries · Final report · Apr 26, 1982 · N1838F · Substantial damage
  > At about 200 ft the eng abruptly quit. The plt was unable to restart the eng by switching tanks & turning the boost pump on. The acft was landed gear up in an open field adjacent to the rwy. Just prior to the eng failure the plt noticed that the fuel pressure…
- [NTSB DEN82DA072](https://openairdocs.org/ntsb/DEN82DA072.md): Enstrom 280-C · Granger, WY · Accident · No injuries · Final report · Apr 26, 1982 · N629H · Substantial damage
  > The aircraft's engine backfired and quit during takeoff. The pilot cleared a fence and during the forced landing the gear collapsed. No engine malfunction or failure could be found.
- [NTSB MIA82DA112](https://openairdocs.org/ntsb/MIA82DA112.md): Beech 95-B55 · Gainesville, FL · Accident · No injuries · Final report · Apr 25, 1982 · N38198 · Substantial damage
  > The purpose of the flight was to give dual instruction to the owner/student whose multi-engine rating was limited to centerline thrust models. The student was flying the aircraft on the takeoff roll when the cockpit door became ajar. The aircraft was near…
- [NTSB FTW82DA148](https://openairdocs.org/ntsb/FTW82DA148.md): Rand KR-1 Catfish · Slaton, TX · Accident · No injuries · Final report · Apr 25, 1982 · N8036A · Destroyed
  > The home built aircraft was on its initial test flight. After completing two takeoff runs successfully, the pilot elected to fly the aircraft around the local pattern. While climbing about 1/4 mile from the runway, the engine began missing. The pilot turned…
- [NTSB NYC82FHJ05](https://openairdocs.org/ntsb/NYC82FHJ05.md): Cessna 150 · Bayport, NY · Accident · Minor injuries · Final report · Apr 24, 1982 · N22550 · Destroyed
  > During takeoff, the engine began to lose power at about 50 ft AGL and then began to vibrate. The pilot checked that the fuel selector switch was on. He turned and attempted to return to the airport; however, he was unable to maintain altitude. Subsequently,…
- [NTSB SEA82FYM13](https://openairdocs.org/ntsb/SEA82FYM13.md): Weatherly 201B · Kent, OR · Accident · Serious injuries · Final report · Apr 22, 1982 · N1262W · Destroyed
  > The pilot reported that he was working off of a 1700 ft dirt strip with a rough surface and with a slight cross- wind. The elevation was about 2650 ft MSL and the temperature was approximately 70 degrees fahrenheit. The pilot initiated a takeoff with about…
- [NTSB MKC82IA047](https://openairdocs.org/ntsb/MKC82IA047.md): Cessna 152 · Cottonwood Fall, KS · Incident · No injuries · Incident investigation · Final report · Apr 20, 1982 · N89585 · Minor damage
  > After executing two landings on runway 36, the pilot noticed a wind shift from 360 degrees to 260 degrees and he taxied back up the runway and started a takeoff on runway 18. The pilot stated that about 1300 from the departure end of the runway, he…

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

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

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