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

## Cases, newest first

- [NTSB DEN82DA202](https://openairdocs.org/ntsb/DEN82DA202.md): Piper PA-34 · Langdon, ND · Accident · No injuries · Final report · Sep 21, 1982 · N8107X · Substantial damage
  > Cabin door came open in flight and pilot made a precautionary landing. During roll-out nose gear collapsed as aircraft weight settled on it since it had not fully extended.
- [NTSB CHI82DA363](https://openairdocs.org/ntsb/CHI82DA363.md): Aeronca 7EC · Detroit, MI · Accident · No injuries · Final report · Sep 21, 1982 · N29246 · Destroyed
  > Aircraft made left turn after takeoff at 15 feet AGL behind tree line which interferred with available wind. Aircraft stalled and dragged left wing, followed by cartwheel and sinking.
- [NTSB NYC82FGM16](https://openairdocs.org/ntsb/NYC82FGM16.md): Foster Airspeed · Butler, PA · Accident · 1 fatal · Final report · Sep 19, 1982 · N827Z · Destroyed
  > The owner intended to put his aircraft on static display at the airport fly-in which was on the same airport. A friend informed the owner that he would like to fly the plane and the owner disclosed that it did not have a current inspection. The plane was…
- [NTSB MIA82DA185](https://openairdocs.org/ntsb/MIA82DA185.md): Hughes 500 · Kissimmee, FL · Accident · No injuries · Final report · Sep 19, 1982 · N50723 · Substantial damage
  > During takeoff at about 75-100 ft the eng quit. The m/r blades flexed down & severed the tail boom during the autorotative landing in a pasture. After the accident the eng ran satisfactorily.
- [NTSB CHI82DA359](https://openairdocs.org/ntsb/CHI82DA359.md): Scorpion Too · Sheboygan Falls, WI · Accident · Serious injuries · Final report · Sep 19, 1982 · N49JF · Destroyed
  > The pilot made a turn after takeoff and the aircraft vibrated and crashed. No malfunction was found.
- [NTSB SEA82DA167](https://openairdocs.org/ntsb/SEA82DA167.md): Cessna U206A · 42nm Ese Of Yak, AK · Accident · No injuries · Final report · Sep 18, 1982 · N80632 · Substantial damage
  > Shortly after the aircraft became airborne, the pilot was not capable of maintaining flight due to insufficient airspeed. The aircraft stalled and the left wing tip dragged in the east river. The pilot reduced power and the aircraft settled into shallow water.
- [NTSB NYC82DA227](https://openairdocs.org/ntsb/NYC82DA227.md): Piper PA-22-160 · Marlboro, NJ · Accident · Minor injuries · Final report · Sep 18, 1982 · N8905D · Destroyed
  > The aircraft lost power after takeoff. While the pilot was attempted to land, the left wing of the aircraft collided with trees and the plane crashed. The fuel was found to have been exhausted.
- [NTSB MIA82DA183](https://openairdocs.org/ntsb/MIA82DA183.md): Piper PA-36-375 · Astatula, FL · Accident · No injuries · Final report · Sep 18, 1982 · N3808E · Substantial damage
  > The plt stated the acft failed to become airborne at the usual takeoff point & did not climb when forced into the air. The acft then settled into soft sand.
- [NTSB LAX82FA337](https://openairdocs.org/ntsb/LAX82FA337.md): Cessna 182P · 11 Mi. S. Of Du, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 18, 1982 · N1777M · Substantial damage
  > At about 60 ft above the rwy the eng quit. The acft stalled just before touchdown as the plt was maneuvering to avoid some gullies. On 7/9/82 the plt had purchased 1,200 gals of regular unleaded automobile fuel for use in his acft. Prior to this time he had…
- [NTSB FTW82DA383](https://openairdocs.org/ntsb/FTW82DA383.md): Beechcraft K35 · Houston, TX · Accident · No injuries · Final report · Sep 18, 1982 · N601Q · Destroyed
  > Pilot stated that he lifted the nose off the runway too soon and the aircraft became airborne but would not climb or accelerate. The aircraft drifted to the left and collided with a canal dirt bank.
- [NTSB CHI82DA358](https://openairdocs.org/ntsb/CHI82DA358.md): Taylorcraft BC12-D · Springfield, IL · Accident · Minor injuries · Final report · Sep 18, 1982 · N94979 · Substantial damage
  > The pilot stalled after takeoff and the plane crashed in a bean field. The pilot was making a 180 degree turn to return to the private strip. No reason was reported for returning.
- [NTSB CHI82DA355](https://openairdocs.org/ntsb/CHI82DA355.md): Beech G18S · Indianapolis, IN · Accident · No injuries · Final report · Sep 18, 1982 · N730M · Substantial damage
  > The pilot stated that the aircraft veered to the left just after rotation. He pushed the propeller, power and mixture controls forward. The left wing and left main gear struck the ground. The aircraft then began to spin while in ground contact. The left…
- [NTSB ANC82FA091](https://openairdocs.org/ntsb/ANC82FA091.md): Robertson C-U206F · Near Nondalton, AK · Accident · 4 fatal · Field investigation · Final report · Sep 17, 1982 · N33249 · Destroyed
  > Shortly after takeoff from hudson lake the left wingtip contacted the water causing the acft to cartwheel. The acft came to rest inverted & floated for a short time before sinking. A witness reported the waves on the lake were at least 4 ft high & breaking…
- [NTSB ANC82DAG55](https://openairdocs.org/ntsb/ANC82DAG55.md): Piper PA-12 · Anchorage, AK · Accident · Serious injuries · Final report · Sep 17, 1982 · N3829M · Destroyed
  > The acft was observed to lift off at the end of the lake, turn downwind & stall, the acft was over max takeoff gross weight & the rear CG was beyond the aft limit.
- [NTSB ATL82DA276](https://openairdocs.org/ntsb/ATL82DA276.md): Grumman G-164B · Society Hill, AL · Accident · No injuries · Final report · Sep 16, 1982 · N48636 · Substantial damage
  > Aircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.
- [NTSB DEN82DA196](https://openairdocs.org/ntsb/DEN82DA196.md): Cessna U206F · Kemmerer, WY · Accident · No injuries · Final report · Sep 15, 1982 · N8317Q · Substantial damage
  > The aircraft lost power after takeoff in a large field. During the landing roll, the aircraft crossed a dirt road that crossed the field, the nose gear failed and the aircraft nosed over. A section of aluminum from the air induction box was missing. Aluminum…
- [NTSB DEN82DA194](https://openairdocs.org/ntsb/DEN82DA194.md): Cessna 182P · 3/4 N.E. Of Nuc, CO · Accident · No injuries · Final report · Sep 14, 1982 · N7446N · Substantial damage
  > Minor eng maintenance was performed before takeoff. After takeoff the eng ran rough, backfired & could not produce sufficient power to sustain flight. During the landing in an open field the horizontal stablizer hit a fence. The plt reported that evidently a…
- [NTSB ATL82FLT06](https://openairdocs.org/ntsb/ATL82FLT06.md): Benson B8M · Walls, MS · Accident · Minor injuries · Final report · Sep 14, 1982 · N2311E · Substantial damage
  > The pilot reported that after he took off and climbed to about 100 ft AGL, he tried to turn, but found he had no control of the aircraft. He then reduced the power and crash landed into a soybean field. An examination of the wreckage revealed that the lower…
- [NTSB ANC82DAA19](https://openairdocs.org/ntsb/ANC82DAA19.md): Cessna A185F · Kotzebue, AK · Accident · No injuries · Final report · Sep 13, 1982 · N60844 · Substantial damage
  > The pilot reported that the wind was from 010 deg at 13, gusting 16 to 17 KTS. He stated that if runway 35 had been used for departure, there would have been a delay due to other aircraft. Therefore, he decided to expedite his departure by using runway 08.…
- [NTSB CHI82DA351](https://openairdocs.org/ntsb/CHI82DA351.md): Piper PA-28-161 · Angle Inlet, MN · Accident · Serious injuries · Final report · Sep 12, 1982 · N8067V · Substantial damage
  > Just after takeoff, the aircraft lost altitude and crashed beyond the departure end of the runway. The pilot stated that just after takeoff, the stall warning was heard. Also, he reported that when the aircraft reached an altitude of about 60 ft AGL, there…
- [NTSB ATL82DA270](https://openairdocs.org/ntsb/ATL82DA270.md): Cessna 150 · Goldsboro, NC · Accident · No injuries · Final report · Sep 12, 1982 · N3641J · Substantial damage
  > The aircraft was flown by an unauthorized person after it had been secured for the night and the flight operation had been closed. On the next morning, the plane was found about 200 yards from the departure end of runway 04, where it had crashed. An…
- [NTSB NYC82DA225](https://openairdocs.org/ntsb/NYC82DA225.md): Cessna 172K · Vinalhaven, ME · Accident · No injuries · Final report · Sep 11, 1982 · N84220 · Destroyed
  > The engine lost power at 100 feet of altitude after takeoff. The pilot found by pumping the throttle, he could regain some power. The aircraft collided with trees and came to rest on the ground. The mixture control cable had separated about one inch from it…
- [NTSB NYC82DA223](https://openairdocs.org/ntsb/NYC82DA223.md): Beech B23 · West Yarmouth, MA · Accident · No injuries · Final report · Sep 11, 1982 · N7674R · Substantial damage
  > About 30 min after takeoff, the engine lost power at about 1000 ft AGL when the pilot added power to climb. He was unable to restart the engine and elected to land along the shoreline. During the approach, the aircraft collided with power lines. Reportedly,…
- [NTSB NYC82DA222](https://openairdocs.org/ntsb/NYC82DA222.md): Champion 7GCBC · Enfield, NH · Accident · No injuries · Final report · Sep 11, 1982 · N5185X · Substantial damage
  > The pilot experienced a partial power loss after takeoff and in trying for better landing terrain collided with power lines, a camp and a car.
- [NTSB MKC82FA171](https://openairdocs.org/ntsb/MKC82FA171.md): Starduster TOO · Plattsburg, MO · Accident · Serious injuries · Field investigation · Final report · Sep 11, 1982 · N60WW · Substantial damage
  > At about 100 ft AGL during takeoff, the engine quit. The acft crashed in a wooded area southeast of the arpt boundary. No fuel was found onboard.
- [NTSB CHI82DA361](https://openairdocs.org/ntsb/CHI82DA361.md): Cassutt Mark II · Blaine, MN · Accident · 1 fatal · Final report · Sep 11, 1982 · N8937 · Destroyed
  > Witnesses at the accident site stated that after takeoff, the engine on N8937 began to sputter and the aircraft stalled at an altitude of approximately 50 to 100 feet AGL.
- [NTSB ANC82DAG57](https://openairdocs.org/ntsb/ANC82DAG57.md): Piper PA-18-150 · Wasilla, AK · Accident · No injuries · Final report · Sep 11, 1982 · N63837 · Substantial damage
  > The pilot landed on anderson lake to obtain fuel. After refueling, he aborted his first attempt to takeoff when the aircraft was slow to accelerate. About 20 gal of fuel was then drained from the aircraft. Another takeoff was started by making a step turn to…
- [NTSB DEN82DA189](https://openairdocs.org/ntsb/DEN82DA189.md): Mooney M20E · Falcon, CO · Accident · Minor injuries · Final report · Sep 10, 1982 · N5666Q · Substantial damage
  > Acft was observed taking off downwind on an uphill gradient rwy. The acft rotated several times before lifting off into a 40-45 deg angle of climb & stalling. The takeoff roll was started abeam the runup pad which provided 3,500 ft for takeoff. An additional…
- [NTSB NYC82DA224](https://openairdocs.org/ntsb/NYC82DA224.md): Beech C23 · Hammonton, NJ · Accident · Minor injuries · Final report · Sep 9, 1982 · N23965 · Substantial damage
  > The aircraft lost power at 300 feet after takeoff. The pilot stated he changed the fuel selector and tried a restart. The aircraft began to stall, but the pilot lowered the nose, then rotated to settle into trees. The aircraft flipped inverted. No malfunction…
- [NTSB MKC82DA170](https://openairdocs.org/ntsb/MKC82DA170.md): Robinson R-22 HP · Gardner, KS · Accident · No injuries · Final report · Sep 9, 1982 · N9078N · Substantial damage
  > A non-cfi rated plt was giving instruction to an airplane plt that had logged a total of 6 hrs in helicopters. The student plt was lifting to a hover when a gust of wind struck the aircraft from the right side. The student pilot moved the cyclic pitch control…
- [NTSB ANC82FA089](https://openairdocs.org/ntsb/ANC82FA089.md): Piper PA-18 · Near Clear, AK · Accident · No injuries · Field investigation · Final report · Sep 9, 1982 · N9104D · Substantial damage
  > The plt reported that immediately after lift-off the acft began a right turn. He applied full left rudder & left aileron but the acft did not respond. It continued to turn right until it struck trees on the right side of the strip. The plt thought there was a…
- [NTSB LAX82FUG16](https://openairdocs.org/ntsb/LAX82FUG16.md): Cessna 210A · Lake Havasu, CA · Accident · 2 fatal · Final report · Sep 7, 1982 · N6652X · Destroyed
  > The pilot and passenger departed Lake Havasu airport. Following takeoff, the aircraft turned west and crossed the lake and shortly thereafter impacted the ground. There were no witnesses to the accident. The weather at the time of the accident was clear sky,…
- [NTSB ANC82DA084](https://openairdocs.org/ntsb/ANC82DA084.md): de Havilland Beaver U-64 · Port Moller, AK · Accident · Minor injuries · Final report · Sep 7, 1982 · N4022B · Substantial damage
  > During takeoff climb gusts caused aircraft to roll. Wing contacted the ground and aircraft cartwheeled. Wind was 20 KTS gusting to 45 KTS.
- [NTSB FTW82DA366](https://openairdocs.org/ntsb/FTW82DA366.md): Piper PA32-301 · Raton, NM · Accident · No injuries · Final report · Sep 6, 1982 · N8200M · Substantial damage
  > The pilot stated that the airport regulations were such that he had to make a downwind takeoff on runway 17. The wind was from 350 degrees at 10 knots. He stated that just after liftoff, the aircraft stalled. Forward elevator was applied to break the stall…
- [NTSB FTW82DA365](https://openairdocs.org/ntsb/FTW82DA365.md): Beech 23 · Fort Worth, TX · Accident · Serious injuries · Final report · Sep 6, 1982 · N45BW · Destroyed
  > The plt stated the stall warning sounded every time he tried to climb & the acft settled into trees. The acft was 7 lbs over max gross weight requiring 2,369 ft to clear a 50 ft obstacle.
- [NTSB NYC82FFJ18](https://openairdocs.org/ntsb/NYC82FFJ18.md): I.C.A. Brasov IS-28B2 · Dansville, NY · Accident · Serious injuries · Final report · Sep 5, 1982 · N52RS · Destroyed
  > The accident occurred during a tow takeoff. The tow plane plt stated he broke ground about 70 mph at the same spot as previous tows. Upon reaching the departure end of the rwy he felt his acft decelerating & losing altitude. With declining airspeed, no climb…
- [NTSB FTW82DPD18](https://openairdocs.org/ntsb/FTW82DPD18.md): Bennet VP-1 · Fort Worth, TX · Accident · Serious injuries · Final report · Sep 5, 1982 · N45RB · Destroyed
  > Engine quit after takeoff and aircraft stalled during forced landing in tall weeds. Bendix zenith carburetor acceleration pump rubber cover was deteriorated, sucking in air.
- [NTSB FTW82DA370](https://openairdocs.org/ntsb/FTW82DA370.md): Robinson R22 · Eden, TX · Accident · Minor injuries · Final report · Sep 5, 1982 · N90744 · Substantial damage
  > The pilot reportd that he lifted off to a three foot hover, checked his instrument readings, then took off. He reported climbing to 15 feet to clear some bushes and two fences that were in his flight path. As he approached the first fence, the helicopter was…
- [NTSB CHI82DA337](https://openairdocs.org/ntsb/CHI82DA337.md): Cessna 172H · Hackensack, MN · Accident · Serious injuries · Final report · Sep 4, 1982 · N2678L · Substantial damage
  > The pilot tookoff from a 2000 foot grass strip with 3 passengers and the aircraft near gross weight. The grass was 4-6 inches high. He made the takeoff and attained a height of 50-60 feet when gusts from a tree line raised the right wing. With the aircraft…
- [NTSB ANC82DA090](https://openairdocs.org/ntsb/ANC82DA090.md): Maule M-5 · Nr. Mcgrath, AK · Accident · No injuries · Final report · Sep 4, 1982 · N51470 · Substantial damage
  > The pilot began a takeoff from an unimproved strip with two passengers on board. The winds were blowing from the northeast at 20 gusting 35 knots. The pilot reported that after the plane had rolled about 300 ft, the airspeed indicated over 40 KTS. After…
- [NTSB NYC82DA216](https://openairdocs.org/ntsb/NYC82DA216.md): Consolidated Aero LA-4-200 · Moriches Bay, NY · Accident · No injuries · Final report · Sep 3, 1982 · N80020 · Substantial damage
  > After taking off, the pilot climbed to 1000 ft MSL and leveled off. As the throttle was retarded, the engine lost power for an unknown reason. While making a forced landing on a bay, the aircraft struck a submerged object about 100 ft after touching down and…
- [NTSB MKC82FCG20](https://openairdocs.org/ntsb/MKC82FCG20.md): Villine'S Breezy RLV-1 · Independence, MO · Accident · Serious injuries · Final report · Sep 2, 1982 · N21CV · Substantial damage
  > Pilot made a precautionary landing when aircraft developed a vibration. What pilot thought was a bean field was 5 feet high milo, and aircraft flipped inverted. Vibration was caused by piece of separated exhaust system hitting and breaking off part of the…
- [NTSB CHI82IA331](https://openairdocs.org/ntsb/CHI82IA331.md): Swearingen SA-226TC · Appleton, WI · Incident · No injuries · Incident investigation · Final report · Sep 2, 1982 · N261S · Minor damage
  > The right main gear "in transit" light remained on after gear retraction on a training flight. Various methods of remedial action did not cure the problem. A landing on runway 21 was executed with the nose and left main gear in the down position. The right…
- [NTSB CHI82DA333](https://openairdocs.org/ntsb/CHI82DA333.md): Piper J-3C65 · Bloomfield Hill, MI · Accident · No injuries · Final report · Sep 2, 1982 · N6544H · Substantial damage
  > Takeoff was from se end of a lake about 4,000 ft long (se to nw) with a small island in the center. The plt stated that after lift-off he obtained climb speed but the acft would not climb from about 20-30 ft above the water. Severe turbulence was encountered…
- [NTSB ANC82DA082](https://openairdocs.org/ntsb/ANC82DA082.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Final report · Sep 2, 1982 · N6195D · Substantial damage
  > The pilot departed in an easterly direction from an unimproved strip 700 feet in length. He stated that the aircraft waslifted off the ground at an airspeed of 35 to 40 knots and would not climb. He also stated that a 5 to 7 knot wind down the runway caused a…
- [NTSB LAX82DUJ45](https://openairdocs.org/ntsb/LAX82DUJ45.md): Ayres S2R · Goodyear, AZ · Accident · No injuries · Final report · Sep 1, 1982 · N5611X · Substantial damage
  > The aircraft had just been loaded with spray material. The pilot stated that after taking off, he leveled off over cotton at the end of the strip and made a power reduction. At about that time, the aircraft settled into the cotton and hit an embankment. The…
- [NTSB MKC82DA162](https://openairdocs.org/ntsb/MKC82DA162.md): Cessna T188C · Mechanicsville, IA · Accident · No injuries · Final report · Aug 31, 1982 · N4927J · Destroyed
  > The pilot began his takeoff from a 2200 ft strip with a load of about 40 gallons of fuel and 1500 to 1600 lbs of seed. He reported that the wind was from the southeast at 2 mph, the temperature was 74 deg, and the elevation was 800 ft. the aircraft became…
- [NTSB LAX83FUJ46](https://openairdocs.org/ntsb/LAX83FUJ46.md): Piper PA-28-235 · Kayenta, AZ · Accident · 1 fatal · Final report · Aug 31, 1982 · N8850W · Destroyed
  > A witness reported that at about 200-250 ft the eng sputtered, the acft leveled off & the eng started again. The acft then made a right turn & the eng sputtered again & quit. The right wing dropped drastically. No malfunctions were noted during the eng tear…
- [NTSB FTW82DA360](https://openairdocs.org/ntsb/FTW82DA360.md): American AA-1A · Georgetown, TX · Accident · No injuries · Final report · Aug 31, 1982 · N6306L · Destroyed
  > At 50 feet AGL the instructor pilot closed the throttle to simulate engine failure during takeoff. He expected a low speed, low altitude, steep 120 degree turn to land on runway 29 by the private pilot receiving familiarization on the AA-1A aircraft. The…
- [NTSB FTW82DA358](https://openairdocs.org/ntsb/FTW82DA358.md): Cessna 150 · Farmerville, LA · Accident · Minor injuries · Final report · Aug 30, 1982 · N66222 · Destroyed
  > The pilot made a downwind takeoff from an intersection of the runway. The aircraft failed to clear trees at the departure end of the runway.

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

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

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