# 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 40 of 281 · 14,035 cases

## Cases, newest first

- [NTSB DCA16WA227](https://openairdocs.org/ntsb/DCA16WA227.md): Boeing 777 · Abu Dhabi, United Arab Emirates · Incident · No injuries · Foreign investigation · Sep 27, 2016 · A6-ETL · Minor damage
  > The General Civil Aviation Authority (GCAA) of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on September 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation…
- [NTSB ANC16LA071](https://openairdocs.org/ntsb/ANC16LA071.md): Helio H-295 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Sep 26, 2016 · N68857 · Substantial damage
  > The pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.
- [NTSB GAA16CA526](https://openairdocs.org/ntsb/GAA16CA526.md): Six Chuter Legend XL · Arcadia, FL · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N149SC · Substantial damage
  > The pilot’s decision to take off in high-density altitude conditions, which resulted in the powered parachute being unable to maintain a sufficient climb rate and its subsequent impact with power lines.
- [NTSB GAA16CA503](https://openairdocs.org/ntsb/GAA16CA503.md): Cessna 185 · Fairbanks, AK · Accident · Minor injuries · Data collection · Final report · Sep 22, 2016 · N5892T · Substantial damage
  > The pilot’s failure to recognize he was taking off with a tailwind and his inadequate compensation for taking off with a tailwind, which led to the airplane’s failure to attain a climb and a subsequent forced landing.
- [NTSB CEN16FA378](https://openairdocs.org/ntsb/CEN16FA378.md): Piper PA 28-235 · Lee's Summit, MO · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2016 · N8983W · Substantial damage
  > The pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.
- [NTSB ENG16IA037](https://openairdocs.org/ntsb/ENG16IA037.md): Airbus A320 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Sep 19, 2016 · P4-AAA · Minor damage
  > the incorrect latching of the #2 Engine Fan Cowl following a routine maintenance check that resulted in separation of the cowl during takeoff.
- [NTSB CEN16LA375](https://openairdocs.org/ntsb/CEN16LA375.md): Piper PA 32R-300 · Grants, NM · Accident · No injuries · Limited investigation · Final report · Sep 19, 2016 · N4477F · Destroyed
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR16LA185](https://openairdocs.org/ntsb/WPR16LA185.md): Hoover David Arnold AR 6 · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2016 · N616DH · 2 aircraft · Substantial damage
  > The pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…
- [NTSB GAA16CA499](https://openairdocs.org/ntsb/GAA16CA499.md): Alex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJ · Accident · No injuries · Data collection · Final report · Sep 17, 2016 · N528WM · Substantial damage
  > The student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.
- [NTSB GAA16CA498](https://openairdocs.org/ntsb/GAA16CA498.md): Airtime Cygnet · Venice, FL · Accident · No injuries · Data collection · Final report · Sep 16, 2016 · N145AT · Substantial damage
  > The student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.
- [NTSB ANC16LA067](https://openairdocs.org/ntsb/ANC16LA067.md): Helio H 295 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 2016 · N6464V · Substantial damage
  > Excessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.
- [NTSB WPR16FA176](https://openairdocs.org/ntsb/WPR16FA176.md): Cessna 310N · Wickenburg, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 9, 2016 · N126P · Substantial damage
  > Total loss of power to the right engine during takeoff due to a fuel contaminant, which blocked the fuel flow transducer and resulted in fuel starvation to the engine.
- [NTSB GAA16CA477](https://openairdocs.org/ntsb/GAA16CA477.md): Pacific Aerospace 750XL · Warrenton, VA · Accident · No injuries · Data collection · Final report · Sep 9, 2016 · N750SS · Substantial damage
  > The pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.
- [NTSB GAA16CA478](https://openairdocs.org/ntsb/GAA16CA478.md): Cessna 180 · Clemson, SC · Accident · No injuries · Data collection · Final report · Sep 5, 2016 · N451SW · Substantial damage
  > The pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.
- [NTSB GAA16CA486](https://openairdocs.org/ntsb/GAA16CA486.md): Champion 7GC · Palmer, AK · Accident · No injuries · Data collection · Final report · Sep 4, 2016 · N4831E · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.
- [NTSB GAA16CA485](https://openairdocs.org/ntsb/GAA16CA485.md): Dormaier Monte R Baby Great Lakes · Mazama, WA · Accident · Minor injuries · Data collection · Final report · Sep 3, 2016 · N110MD · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.
- [NTSB CEN16FA341](https://openairdocs.org/ntsb/CEN16FA341.md): Beech A36 · Bentonville, AR · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2016 · N8283D · Destroyed
  > The pilot's failure to monitor and/or transmit his position over the uncontrolled airport's common traffic advisory frequency, and his decision to continue the takeoff when he observed conflicting traffic on the runway.
- [NTSB DCA16WA228](https://openairdocs.org/ntsb/DCA16WA228.md): Boeing 777 · London, United Kingdom · Incident · No injuries · Foreign investigation · Aug 30, 2016 · VT-JEK · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Boeing 777 that occurred on August 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…
- [NTSB CEN16CA359](https://openairdocs.org/ntsb/CEN16CA359.md): Beech 58 · Wichita Falls, TX · Accident · No injuries · Data collection · Final report · Aug 26, 2016 · N15MD · Substantial damage
  > The incorrect maintenance of the airplane's ventilation system which resulted in an obstruction of the elevator control system.
- [NTSB WPR16LA167](https://openairdocs.org/ntsb/WPR16LA167.md): Siai-Marchetti SF260 · Fullerton, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 25, 2016 · N16FD · Substantial damage
  > The failure of the pilot to set the flaps to the proper takeoff setting before takeoff, resulting in an aerodynamic stall during takeoff and loss of control.
- [NTSB ERA16WA310](https://openairdocs.org/ntsb/ERA16WA310.md): Learjet 55 · Eleuthera, Bahamas · Accident · No injuries · Foreign investigation · Aug 25, 2016 · N666TK · Substantial damage
  > On August 25, 2016, about 1903 universal coordinated time, a Learjet 55, N666TK, operated by RCR7 LLC, was substantially damaged during a runway excursion following an aborted takeoff at North Eleuthera Airport, Eleuthera, Bahamas. The two pilots and seven…
- [NTSB ERA16LA299](https://openairdocs.org/ntsb/ERA16LA299.md): Progressive Aerodyne Searey · Sebring, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2016 · N801SR · Substantial damage
  > A disconnected ground wire during initial climb, which degraded the fuel boost pumps’ performance and resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA16CA497](https://openairdocs.org/ntsb/GAA16CA497.md): Cirrus Design SR20 · Brunswick, GA · Accident · No injuries · Data collection · Final report · Aug 22, 2016 · N204AK · Substantial damage
  > The total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.
- [NTSB ERA16LA305](https://openairdocs.org/ntsb/ERA16LA305.md): Dayton A Babcock Storm · Eustis, FL · Accident · No injuries · Limited investigation · Final report · Aug 20, 2016 · N516VB · Substantial damage
  > The pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the loss of engine power due to a malfunctioning alternator, which precipitated the off-field landing, and the pilot’s decision to attempt to take…
- [NTSB CEN16LA329](https://openairdocs.org/ntsb/CEN16LA329.md): Collins RV6A · Pekin, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2016 · N576RV · Substantial damage
  > The pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.
- [NTSB GAA16CA437](https://openairdocs.org/ntsb/GAA16CA437.md): Cessna 152 · Belle Plaine, MN · Accident · No injuries · Data collection · Final report · Aug 17, 2016 · N631TK · Substantial damage
  > The student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.
- [NTSB GAA16CA430](https://openairdocs.org/ntsb/GAA16CA430.md): Pzl-Swidnik PW 6U · Llano, CA · Accident · No injuries · Data collection · Final report · Aug 14, 2016 · N212EC · Substantial damage
  > The pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.
- [NTSB CEN16LA324](https://openairdocs.org/ntsb/CEN16LA324.md): Bellanca 7ECA · Lino Lakes, MN · Accident · No injuries · Limited investigation · Final report · Aug 14, 2016 · N50437 · Substantial damage
  > A partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.
- [NTSB CEN16WA340](https://openairdocs.org/ntsb/CEN16WA340.md): Quad City Challenger II · Amos, Canada · Accident · 1 fatal · Foreign investigation · Aug 9, 2016 · C-IIJW · Destroyed
  > On August 9, 2016, at 1530 UTC, a Quad City Challenger II (S/N CH2-0903-2368), C-IIJW, impacted terrain near the runway end at Amos/Magny Airport (CYEY), Amos, Quebec, Canada. The aircraft was destroyed and sole occupant on board was fatally injured. The…
- [NTSB CEN16FA307](https://openairdocs.org/ntsb/CEN16FA307.md): Wilson BUGATTI-DEMONGE 100P · Burns Flat, OK · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2016 · N110PX · Destroyed
  > The pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…
- [NTSB CEN16LA302](https://openairdocs.org/ntsb/CEN16LA302.md): Sonex Waiex · Fond du Lac, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2016 · N12YX · Substantial damage
  > A partial loss of engine for reasons that could not be determined during an examination of the engine.
- [NTSB GAA16CA419](https://openairdocs.org/ntsb/GAA16CA419.md): Cessna 172 · Lewiston, MT · Accident · No injuries · Data collection · Final report · Aug 2, 2016 · N734GM · Substantial damage
  > The pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.
- [NTSB ERA16CA278](https://openairdocs.org/ntsb/ERA16CA278.md): Trick Trikes Storm · Valkaria, FL · Accident · Minor injuries · Data collection · Final report · Jul 31, 2016 · N4367X · Substantial damage
  > The pilot’s premature rotation during takeoff, which resulted in an aerodynamic stall and a hard landing.
- [NTSB ANC16CA053](https://openairdocs.org/ntsb/ANC16CA053.md): Cessna U206G · Sleetmute, AK · Accident · No injuries · Data collection · Final report · Jul 31, 2016 · N206JC · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the initial climb after taking off from a wet runway and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB GAA16CA415](https://openairdocs.org/ntsb/GAA16CA415.md): Cessna 172 · Kissimmee, FL · Accident · No injuries · Data collection · Final report · Jul 30, 2016 · N1688C · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff.
- [NTSB CEN16LA293](https://openairdocs.org/ntsb/CEN16LA293.md): Boam Larry Rans S 7 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 2016 · N6271X · Substantial damage
  > The pilot's failure to maintain airplane control on takeoff, which resulted in his remedial action to induce an aerodynamic stall and the subsequent impact with terrain.
- [NTSB GAA16CA403](https://openairdocs.org/ntsb/GAA16CA403.md): Cessna 172 · Rexburg, ID · Accident · No injuries · Data collection · Final report · Jul 28, 2016 · N3677S · Substantial damage
  > The student pilot's failure to retract the flaps during a go-around in high density altitude conditions, resulting in the airplane's inability to climb and a subsequent collision with terrain and nose over.
- [NTSB GAA16CA394](https://openairdocs.org/ntsb/GAA16CA394.md): Alon A2 · Alamosa, CO · Accident · No injuries · Data collection · Final report · Jul 27, 2016 · N5690F · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.
- [NTSB GAA16CA395](https://openairdocs.org/ntsb/GAA16CA395.md): Engineering & Research 415 · Collinsville, OK · Accident · No injuries · Data collection · Final report · Jul 23, 2016 · N2377H · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.
- [NTSB GAA16CA390](https://openairdocs.org/ntsb/GAA16CA390.md): Piper PA46 · Claremore, OK · Accident · No injuries · Data collection · Final report · Jul 22, 2016 · N9111P · Substantial damage
  > The pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.
- [NTSB WPR16RA151](https://openairdocs.org/ntsb/WPR16RA151.md): Cessna 208 · Shanghai, China · Accident · 5 fatal · Foreign investigation · Jul 20, 2016 · B-10FW · Substantial damage
  > On July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…
- [NTSB ERA16LA263](https://openairdocs.org/ntsb/ERA16LA263.md): Tecnam P2008 · Warrenton, VA · Accident · No injuries · Limited investigation · Final report · Jul 19, 2016 · N615BS · Substantial damage
  > The pilot’s decision to begin the takeoff roll with helicopter traffic on the runway, which led to a rejected takeoff. Contributing to the accident was the pilot’s improper use of the toe brakes, which he had limited experience using and resulted in a runway…
- [NTSB ANC16LA047](https://openairdocs.org/ntsb/ANC16LA047.md): Aeropro CZ A220 · McCarthy, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 2016 · N151J · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll, which resulted in a loss of control and impact with terrain. Contributing to the accident were engine power surges due to the bent carburetor throttle valve lever.
- [NTSB WPR16CA145](https://openairdocs.org/ntsb/WPR16CA145.md): Beech 19A · Helena, MT · Accident · Minor injuries · Data collection · Final report · Jul 18, 2016 · N7645R · Substantial damage
  > The pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.
- [NTSB WPR16LA141](https://openairdocs.org/ntsb/WPR16LA141.md): Luscombe 8A · Minden, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2016 · N2759K · Substantial damage
  > The failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.
- [NTSB ERA16CA259](https://openairdocs.org/ntsb/ERA16CA259.md): Hirn Associates Zodiac CH601XL · Hedgesville, WV · Accident · Minor injuries · Data collection · Final report · Jul 17, 2016 · N650WP · Substantial damage
  > The pilot’s inadvertent activation of the elevator trim, which resulted in a premature takeoff and subsequent loss of airplane control and collision with trees.
- [NTSB ERA16WA340](https://openairdocs.org/ntsb/ERA16WA340.md): Cessna 172 · Valday-avia, Russia · Accident · Minor injuries · Foreign investigation · Jul 16, 2016 · RA-67480 · Substantial damage
  > On July 16, 2016, about 1024 universal coordinated time, a Cessna 172K, Russian registration RA-67480, was substantially damaged when it experienced a runway excursion during takeoff from Valday-Avia Airfield, Valday, Novgorod, Russia. The pilot and two…
- [NTSB CEN16LA267](https://openairdocs.org/ntsb/CEN16LA267.md): Aeronca 7BCM · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2016 · N2576E · Substantial damage
  > The pilot's decision to continue the takeoff after observing a partial loss of engine power, the reason for which could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures.
- [NTSB GAA16CA376](https://openairdocs.org/ntsb/GAA16CA376.md): Cessna 182 · Stevensville, MT · Accident · No injuries · Data collection · Final report · Jul 15, 2016 · N9928B · Substantial damage
  > The pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.
- [NTSB ANC16WA042](https://openairdocs.org/ntsb/ANC16WA042.md): Aero Commander B1A · Hoey, Canada · Accident · 1 fatal · Foreign investigation · Jul 14, 2016 · C-GSQY · Destroyed
  > On July 14, 2016, about 0230 Coordinated Universal Time, an Aero Commander B1A airplane, C-GSQY, lost engine power and impacted terrain after takeoff near Hoey, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…

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

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

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