# NTSB investigations: Takeoff

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 135 of 281 · 14,038 cases

## Cases, newest first

- [NTSB ATL88FA174](https://openairdocs.org/ntsb/ATL88FA174.md): Mooney M20F · Middlesboro, KY · Accident · 4 fatal · Field investigation · Final report · May 14, 1988 · N9654M · Substantial damage
  > Witnesses rprted the eng did not sound like it was providing full power drg takeoff & that abt 3/4 of the 3600' rwy was used for the takeoff roll. After lift-off, the acft climbed at a shallow angle to abt 250 to 300 ft AGL. It then entereda shallow left…
- [NTSB FTW88LA099](https://openairdocs.org/ntsb/FTW88LA099.md): Beech B55 · Ada, OK · Accident · No injuries · Limited investigation · Final report · May 12, 1988 · N7330R · Substantial damage
  > The plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…
- [NTSB ANC88LA055](https://openairdocs.org/ntsb/ANC88LA055.md): Piper PA-22-160 · Kodiak, AK · Accident · No injuries · Limited investigation · Final report · May 9, 1988 · N8842D · Substantial damage
  > The pilot stated that during the takeoff run he lost control of the aircraft causing the aircraft to nose over on its back at the departure end of the lake. The plt had been issued a special VFR clearance by Kodiak tower due to existing wx conditions. The plt…
- [NTSB LAX88DUG03](https://openairdocs.org/ntsb/LAX88DUG03.md): Stolp-Starduster Too SA-300-A · Chino, CA · Accident · No injuries · Final report · May 5, 1988 · N1300S · Substantial damage
  > During the ground run for take off, the left main gear strut broke. The main landing gear collapsed resulting in substantial damage. The reason for the strut failure was undetermined.
- [NTSB LAX88DVG04](https://openairdocs.org/ntsb/LAX88DVG04.md): Hiller UH-12E · Winters, CA · Accident · No injuries · Final report · May 4, 1988 · N62391 · Destroyed
  > The pilot was taking off from a loading truck for his 16th aerial application. He reduced the load from 90 to 70 gals because the winds had become variable. The helicopter descended into ground effect where it normally attains translational lift. The…
- [NTSB ATL88FA162](https://openairdocs.org/ntsb/ATL88FA162.md): Beech 55 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · May 2, 1988 · N2025W · Substantial damage
- [NTSB FTW88DRA10](https://openairdocs.org/ntsb/FTW88DRA10.md): New Rutan LONG-EZE · Friendswood, TX · Accident · Minor injuries · Final report · May 1, 1988 · N331LB · Substantial damage
  > The pilot overrotated the aircraft on takeoff to a nose high attitude, then overcontrolled in the opposite direction to get the nose down. The aircraft touched down nose gear first and all three landing gears collapsed, a wing sheared off, and the aircraft…
- [NTSB ANC88LA048](https://openairdocs.org/ntsb/ANC88LA048.md): Cessna 206 · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Apr 19, 1988 · N51205 · Substantial damage
  > The air-taxi pilot stated that he attempted to takeoff from a private, dirt runway that was dry in the middle and muddy towards the edges. During the takeoff roll, the airplane's left main gear tire encountered the soft, muddy area and turned abruptly towards…
- [NTSB ANC88LA044](https://openairdocs.org/ntsb/ANC88LA044.md): Aeronca 7DC · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N2532E · Substantial damage
  > The pilot stated that during the takeoff run on the frozen field the aircraft struck a snow berm causing the aircraft to ground loop.
- [NTSB LAX88LA166](https://openairdocs.org/ntsb/LAX88LA166.md): Champion 7EC · Mayer, AZ · Accident · No injuries · Limited investigation · Final report · Apr 13, 1988 · N7586E · Substantial damage
- [NTSB NYC88LA122](https://openairdocs.org/ntsb/NYC88LA122.md): Cessna 172 · Myerstown, PA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1988 · N2825U · Destroyed
  > The pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.
- [NTSB FTW88LA086](https://openairdocs.org/ntsb/FTW88LA086.md): Piper PA-38-112 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · Apr 2, 1988 · N9213T · Substantial damage
  > The student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…
- [NTSB ATL88LA130](https://openairdocs.org/ntsb/ATL88LA130.md): Beech A-36 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Apr 2, 1988 · N7243B · Substantial damage
  > The pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…
- [NTSB MIA88LA130](https://openairdocs.org/ntsb/MIA88LA130.md): Champion 7ECA · La Belle, FL · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N9097L · Substantial damage
  > During the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.
- [NTSB ANC88LA041](https://openairdocs.org/ntsb/ANC88LA041.md): Cessna 177 · Tok, AK · Accident · No injuries · Limited investigation · Final report · Mar 17, 1988 · N34603 · Substantial damage
  > The private pilot attempted to take-off at dusk with a left main gear wheel brake that was frozen in the 'on' position. He had unsuccessfully attempted to free the brake prior to TAKE0FF, but felt that he could get the airplane airborne by skidding the tire…
- [NTSB NYC88LA107](https://openairdocs.org/ntsb/NYC88LA107.md): Cessna T210M · Greene, NY · Accident · No injuries · Limited investigation · Final report · Mar 12, 1988 · N761BU · Substantial damage
  > During takeoff roll, the aircraft drifted to the right edge of the runway in a soft-field takeoff attitude. The right main gear contacted the top of a snowbank. The aircraft then yawed to the right and impacted a second snowbank where it came to rest.
- [NTSB CHI88DCA01](https://openairdocs.org/ntsb/CHI88DCA01.md): Bell 206B · Cahokia, IL · Accident · No injuries · Final report · Mar 10, 1988 · N13Q · Substantial damage
  > The instructor was giving a pilot an employment evaluation in the helicopter when during the startup the pilot prematurely added full power causing the helicopter to rotate rapidly to the right. The helicopter had been positioned on a trailer. During the…
- [NTSB ANC88LA042](https://openairdocs.org/ntsb/ANC88LA042.md): Cessna 185F · Ophir, AK · Accident · No injuries · Limited investigation · Final report · Mar 10, 1988 · N5045R · Substantial damage
  > During the takeoff roll from the frozen lake the pilot lost directional control of the aircraft causing the aircraft to nose over on its back. The pilot stated during the takeoff roll the aircraft crossed a snowmachine track causing him to lose control of the…
- [NTSB ANC88LA038](https://openairdocs.org/ntsb/ANC88LA038.md): Piper PA-18 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Mar 10, 1988 · N78AJ · Substantial damage
  > The private pilot-in-command of the Piper PA-18 lost control of the airplane while attempting to takeoff from a section of snow covered river ice.
- [NTSB NYC88LA095](https://openairdocs.org/ntsb/NYC88LA095.md): Stinson 108-1 · Burlington, VT · Accident · No injuries · Limited investigation · Final report · Feb 28, 1988 · N97979 · Substantial damage
  > The flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…
- [NTSB FTW88LA073](https://openairdocs.org/ntsb/FTW88LA073.md): Brantly Helicopter B-2B · Decatur, TX · Accident · No injuries · Limited investigation · Final report · Feb 27, 1988 · N2233U · Substantial damage
  > The non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…
- [NTSB FTW88DRA04](https://openairdocs.org/ntsb/FTW88DRA04.md): Barnett Drifter XP503 · Alvin, TX · Accident · Serious injuries · Final report · Feb 27, 1988 · N247JB · Substantial damage
  > The pilot reassembled the flight controls just prior to flight, and installed the aileron pins to connect the cables, but forget the safety locking devices. During flight, the pins fell out causing a total loss of aileron control.
- [NTSB CHI88LA070](https://openairdocs.org/ntsb/CHI88LA070.md): Cessna 172A · Crivitz, WI · Accident · No injuries · Limited investigation · Final report · Feb 26, 1988 · N9751T · Substantial damage
  > The aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…
- [NTSB ATL88DKG04](https://openairdocs.org/ntsb/ATL88DKG04.md): Weber Evans VF-1 · Fort Payne, AL · Accident · Serious injuries · Final report · Feb 26, 1988 · N18JW · Substantial damage
- [NTSB ATL88LA099](https://openairdocs.org/ntsb/ATL88LA099.md): Beech 18S · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Feb 24, 1988 · N1480K · Substantial damage
  > PIC aborted first takeoff attempt due to crosswind induced directional control difficulties. During second takeoff attempt, gusty crosswind lifted left wing & acft became airborne. PIC forced acft back onto rwy, lost directional control and veered off rwy…
- [NTSB NYC88LA092](https://openairdocs.org/ntsb/NYC88LA092.md): Cessna 182 · Westfield, PA · Accident · No injuries · Limited investigation · Final report · Feb 23, 1988 · N3374F · Substantial damage
  > The pilot was attempting a soft field takeoff with full power and right rudder applied. During ground run, the tail of the aircraft struck a snowbank, pulling the aircraft into the snow. When the left main gear hit the snow the aircraft flipped over onto its…
- [NTSB FTW88LA071](https://openairdocs.org/ntsb/FTW88LA071.md): Piper PA-38-112 · San Benito, TX · Accident · No injuries · Limited investigation · Final report · Feb 23, 1988 · N24447 · Substantial damage
  > The student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…
- [NTSB ATL88LA097](https://openairdocs.org/ntsb/ATL88LA097.md): Cessna 172 · Jackson, TN · Accident · No injuries · Limited investigation · Final report · Feb 22, 1988 · N6285E · Substantial damage
  > While returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…
- [NTSB MKC88FA054](https://openairdocs.org/ntsb/MKC88FA054.md): Bell 47D1 · Nixa, MO · Accident · 1 fatal · Field investigation · Final report · Feb 21, 1988 · N7735 · Destroyed
  > During the process of moving the helicopter from the hangar the right skid slipped off the concrete helipad and became stuck in the mud. The pilot attempted to dislodge the skid by bringing the aircraft to a hover. The left skid became airborne and contacted…
- [NTSB ATL88LA098](https://openairdocs.org/ntsb/ATL88LA098.md): Beech 77 · Concord, GA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1988 · N623CH · Substantial damage
  > PIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…
- [NTSB MIA88LA111](https://openairdocs.org/ntsb/MIA88LA111.md): Cessna A188B · Macon, MS · Accident · No injuries · Limited investigation · Final report · Feb 20, 1988 · N4489Q · Destroyed
  > The plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…
- [NTSB FTW88LA067](https://openairdocs.org/ntsb/FTW88LA067.md): Piper PA-38-112 · Washington, OK · Accident · No injuries · Limited investigation · Final report · Feb 19, 1988 · N9331T · Substantial damage
  > The student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…
- [NTSB DEN88LA074](https://openairdocs.org/ntsb/DEN88LA074.md): Cessna 152 · Hurricane, UT · Accident · No injuries · Limited investigation · Final report · Feb 18, 1988 · N67515 · Substantial damage
  > The student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…
- [NTSB FTW88DRA03](https://openairdocs.org/ntsb/FTW88DRA03.md): Hiller UH-12-D · Bon-Wier, TX · Accident · Serious injuries · Final report · Feb 17, 1988 · N48265 · Destroyed
  > Ground crewmember's failure to follow established procedures for secureing the aircraft to the transport trailer.
- [NTSB ATL88LA092](https://openairdocs.org/ntsb/ATL88LA092.md): Cessna 172P · Wakeman, OH · Accident · No injuries · Limited investigation · Final report · Feb 14, 1988 · N633BC · Substantial damage
  > The 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…
- [NTSB SEA88LA049](https://openairdocs.org/ntsb/SEA88LA049.md): Piper Aerostar 602P · Lovelock, NV · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · N68915 · Substantial damage
  > The non-multiengine rated pilot (left seat) executed a takeoff during which the aircraft developed a slight right drift. The pilot then attempted to utilize nose wheel steering to correct and a hard left swerve ensued resulting in a loss of directional…
- [NTSB CHI88DEP03](https://openairdocs.org/ntsb/CHI88DEP03.md): Piper PA-38-112 · Sheboygan, WI · Accident · Minor injuries · Final report · Jan 24, 1988 · N25760 · Substantial damage
  > The aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.
- [NTSB DEN88LA057](https://openairdocs.org/ntsb/DEN88LA057.md): Cessna 172N · Duchesne, UT · Accident · No injuries · Limited investigation · Final report · Jan 22, 1988 · N4897G · Substantial damage
  > The student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…
- [NTSB FTW88IA055](https://openairdocs.org/ntsb/FTW88IA055.md): Swearingen SA227-AC · College Station, TX · Incident · No injuries · Incident investigation · Final report · Jan 20, 1988 · N3107P · Minor damage
  > The aircraft's nose gear struck a deer during the takeoff roll and the takeoff was aborted. The aircraft taxied back to the terminal and was examined by the flight crew. No damage was found. It then departed on its scheduled flight. It flew 18 flights during…
- [NTSB DEN88LA055](https://openairdocs.org/ntsb/DEN88LA055.md): Cessna 402 · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1988 · N2614U · Substantial damage
  > The ATP rated plt and a commercial rated passenger were taking a scheduled cargo flight from Albuquerque to las cruces, new Mexico. The runway was covered with snow, ice and water from a snow storm the previous night. It was snowing lightly at the time of the…
- [NTSB SEA88LA035](https://openairdocs.org/ntsb/SEA88LA035.md): Cessna 172 · Everett, WA · Accident · No injuries · Limited investigation · Final report · Jan 17, 1988 · N2811Q · Substantial damage
  > The student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.
- [NTSB ATL88LA080](https://openairdocs.org/ntsb/ATL88LA080.md): Piper PA-44-180 · Florence, SC · Accident · No injuries · Limited investigation · Final report · Jan 16, 1988 · N268NA · Substantial damage
  > The left main ldg gear collapsed during takeoff roll, following a touch & go ldg. The airplane subsequently veered into a snowbank. Post-crash examination of the airplane revealed that the left MLG truss bracket assy had pulled loose from the acft structure…
- [NTSB ATL88LA075](https://openairdocs.org/ntsb/ATL88LA075.md): Cessna 150 · Carolina Beach, NC · Accident · No injuries · Limited investigation · Final report · Jan 12, 1988 · N50738 · Substantial damage
  > The aircraft sustained substantial airframe damage when the acft collided with the ground following an aborted t/o. the instructor reported that the student pulled the throttle back after the aircraft broke ground. The instructor attempted to recover, but the…
- [NTSB DEN88LA042](https://openairdocs.org/ntsb/DEN88LA042.md): Cessna 152 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Jan 8, 1988 · N280SV · Substantial damage
  > The plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…
- [NTSB MKC88LA035](https://openairdocs.org/ntsb/MKC88LA035.md): Cessna 182Q · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N96934 · Substantial damage
  > The PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…
- [NTSB DEN88LA040](https://openairdocs.org/ntsb/DEN88LA040.md): Beech A36 · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Dec 23, 1987 · N27LH · Substantial damage
  > The private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…
- [NTSB DEN88LA038](https://openairdocs.org/ntsb/DEN88LA038.md): Cessna T210R · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N7381U · Substantial damage
  > The plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.
- [NTSB ANC88FA022](https://openairdocs.org/ntsb/ANC88FA022.md): Cessna 208 · Bethel, AK · Accident · Minor injuries · Field investigation · Final report · Dec 19, 1987 · N9438F · Substantial damage
  > The plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…
- [NTSB NYC88LA023](https://openairdocs.org/ntsb/NYC88LA023.md): Gulfstream American AA-5B · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Nov 30, 1987 · N4533Q · Substantial damage
  > The Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…
- [NTSB CHI88LA029](https://openairdocs.org/ntsb/CHI88LA029.md): Piper PA-28 · Lake City, MI · Accident · No injuries · Limited investigation · Final report · Nov 22, 1987 · N9817W · Substantial damage
  > The student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=136

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=135

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