# 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 42 of 281 · 14,038 cases

## Cases, newest first

- [NTSB GAA16CA228](https://openairdocs.org/ntsb/GAA16CA228.md): Beech C23 · Yucca Valley, CA · Accident · No injuries · Data collection · Final report · May 7, 2016 · N6566R · Substantial damage
  > The pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.
- [NTSB GAA16CA220](https://openairdocs.org/ntsb/GAA16CA220.md): Cessna 172 · Richmond, KY · Accident · No injuries · Data collection · Final report · May 6, 2016 · N89847 · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).
- [NTSB DCA16WA160](https://openairdocs.org/ntsb/DCA16WA160.md): Boeing 737 · Guangzhou, China · Incident · No injuries · Foreign investigation · Apr 27, 2016 · B-2117 · Minor damage
  > The Civil Aviation Administration of China (CAAC) has notified the NTSB of an accident involving a Boeing 737 that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC's investigation under the provisions of…
- [NTSB ERA16LA171](https://openairdocs.org/ntsb/ERA16LA171.md): Cessna 421 · Foley, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 2016 · N3372Q · Destroyed
  > The pilot's failure to obtain proper takeoff speed before breaking ground, which resulted in the airplane’s failure to gain altitude and a collision with trees and terrain.
- [NTSB CEN16LA168](https://openairdocs.org/ntsb/CEN16LA168.md): Bell Helicopter Textron Canada 206 L4 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Apr 25, 2016 · N435AE · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in varying wind conditions, which resulted in a hard landing.
- [NTSB GAA16CA198](https://openairdocs.org/ntsb/GAA16CA198.md): Cessna 150 · Sterling City, TX · Accident · No injuries · Data collection · Final report · Apr 24, 2016 · N8052S · Substantial damage
  > The pilot's failure to establish a climb and maintain directional control during takeoff in quartering tailwind conditions, which resulted in a loss of directional control, aborted takeoff, collision with a wire fence, and nose over.
- [NTSB GAA16LA199](https://openairdocs.org/ntsb/GAA16LA199.md): Buckeye Industries Dream Machine · Culver, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 2016 · N2564A · Substantial damage
  > The noncertificated pilot’s failure to attain a climb in the powered-parachute and its subsequent impact with a tree.
- [NTSB GAA16CA197](https://openairdocs.org/ntsb/GAA16CA197.md): Bellanca 7ECA · Ramona, CA · Accident · Minor injuries · Data collection · Final report · Apr 23, 2016 · N8654V · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in variable wind conditions.
- [NTSB ANC16LA021](https://openairdocs.org/ntsb/ANC16LA021.md): Jim Riggs AK Ridge Runner · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Apr 23, 2016 · N1549M · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR16FA095](https://openairdocs.org/ntsb/WPR16FA095.md): Mooney M20K · Woodland, WA · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2016 · N97119 · Substantial damage
  > The pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…
- [NTSB ERA16FA161](https://openairdocs.org/ntsb/ERA16FA161.md): Cessna 172 · Westmoreland, NY · Accident · 2 fatal · Field investigation · Final report · Apr 18, 2016 · N1863Y · Destroyed
  > The pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…
- [NTSB GAA16CA183](https://openairdocs.org/ntsb/GAA16CA183.md): Piper PA22 · Pantego, NC · Accident · Minor injuries · Data collection · Final report · Apr 9, 2016 · N5069Z · Substantial damage
  > A loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.
- [NTSB GAA16LA182](https://openairdocs.org/ntsb/GAA16LA182.md): Hughes 369 · Weatherford, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 2016 · N298SD · Substantial damage
  > The pilot/mechanic's inadequate postmaintenance and preflight inspections, which resulted in his failure to remove the antitorque pedal lock and a subsequent loss of control during hover operations.
- [NTSB CEN16FA145](https://openairdocs.org/ntsb/CEN16FA145.md): Bellanca 7GCBC · Midlothian, TX · Accident · 1 fatal · Field investigation · Final report · Apr 8, 2016 · N5046N · Substantial damage
  > The flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…
- [NTSB CEN16WA147](https://openairdocs.org/ntsb/CEN16WA147.md): Mcdonnell Douglas Helicopter 369E · Suwalki, Poland · Accident · Serious injuries · Foreign investigation · Apr 7, 2016 · N60EA · Substantial damage
  > On April 7, 2016, at 1613 Central European Daylight Time, a McDonnell Douglas Helicopter 369E, N60EA, registered to EPC Industries, Inc., and operated by a private entity was substantially damaged when it impacted terrain under unknown circumstances near…
- [NTSB GAA16CA185](https://openairdocs.org/ntsb/GAA16CA185.md): Piper PA 22-160 · Palmer, AK · Accident · No injuries · Data collection · Final report · Apr 6, 2016 · N8842D · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, resulting in a runway over-run and collision with trees.
- [NTSB DCA16WA126](https://openairdocs.org/ntsb/DCA16WA126.md): Boeing 737 · Jakarta, Indonesia · Accident · Minor injuries · Foreign investigation · Apr 4, 2016 · PK-LBS · Substantial damage
  > The government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…
- [NTSB GAA16CA181](https://openairdocs.org/ntsb/GAA16CA181.md): Cessna 172 · Orangeburg, SC · Accident · No injuries · Data collection · Final report · Apr 3, 2016 · N2124E · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.
- [NTSB GAA16CA191](https://openairdocs.org/ntsb/GAA16CA191.md): Beech C23 · Frenchville, ME · Accident · No injuries · Data collection · Final report · Mar 30, 2016 · N2397E · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll on a runway contaminated with ice and snow, which resulted in a runway excursion and an impact with a snowbank.
- [NTSB GAA16CA167](https://openairdocs.org/ntsb/GAA16CA167.md): Sewell William K Zodiac 601 · Clarksville, VA · Accident · No injuries · Data collection · Final report · Mar 29, 2016 · N601BZ · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in the airplane drifting to the left of the runway and impacting trees.
- [NTSB ENG16WA013](https://openairdocs.org/ntsb/ENG16WA013.md): Airbus A320 · Rome, Italy · Incident · No injuries · Foreign investigation · Mar 27, 2016 · F-HBSA · No damage
  > The Italian Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving an Airbus 320-216, which occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under…
- [NTSB ERA16FA141](https://openairdocs.org/ntsb/ERA16FA141.md): Cessna 172N · Charleston, WV · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2016 · N6238D · Substantial damage
  > The flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.
- [NTSB ERA16FA140](https://openairdocs.org/ntsb/ERA16FA140.md): Eurocopter AS 350 B2 · Enterprise, AL · Accident · 4 fatal · Field investigation · Final report · Mar 26, 2016 · N911GF · Substantial damage
  > The pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…
- [NTSB CEN16LA131](https://openairdocs.org/ntsb/CEN16LA131.md): Cessna 180A · Del Rio, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 2016 · N9659B · Substantial damage
  > The pilot’s loss of directional control while departing with a gusting tailwind.
- [NTSB WPR16FA086](https://openairdocs.org/ntsb/WPR16FA086.md): Airborne XT 912 · Hawthorne, CA · Accident · 1 fatal · Field investigation · Final report · Mar 21, 2016 · N670EM · Destroyed
  > The weight shift control aircraft encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the accident pilot's failure to recognize the potential for a wake…
- [NTSB GAA16CA153](https://openairdocs.org/ntsb/GAA16CA153.md): Barnes Thomas A Vans · Bolingbrook, IL · Accident · Serious injuries · Data collection · Final report · Mar 18, 2016 · N442TB · Substantial damage
  > The pilot's failure to maintain direction control during the takeoff roll, which resulted in runway excursion, collision with terrain, and nose over.
- [NTSB DCA16WA112](https://openairdocs.org/ntsb/DCA16WA112.md): Beech 1900 · Karachi, Pakistan · Incident · No injuries · Foreign investigation · Mar 18, 2016 · AP-BII · Minor damage
  > The Pakistan Safety Investigation Board (PSIB) has notified the NTSB of an incident involving an Hawker Beechcraft 1900D that occurred on March 18, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the PSIB investigation under the…
- [NTSB ERA16CA134](https://openairdocs.org/ntsb/ERA16CA134.md): Eichhorn Gary L Skyraider I · Erwin, NC · Accident · Minor injuries · Data collection · Final report · Mar 16, 2016 · N8109E · Substantial damage
  > The pilot's inadequate compensation for the wind which resulted in a loss of directional control.
- [NTSB WPR16LA083](https://openairdocs.org/ntsb/WPR16LA083.md): Cessna 180 · Boulder, UT · Accident · No injuries · Limited investigation · Final report · Mar 13, 2016 · N4696B · Substantial damage
  > The pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.
- [NTSB ERA16CA128](https://openairdocs.org/ntsb/ERA16CA128.md): Cessna 180 · South Burlington, VT · Accident · Serious injuries · Data collection · Final report · Mar 13, 2016 · N9925N · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff roll, which resulted in a nose over.
- [NTSB GAA16CA149](https://openairdocs.org/ntsb/GAA16CA149.md): American AA 1 · Brigham City, UT · Accident · Minor injuries · Data collection · Final report · Mar 12, 2016 · N5703L · Substantial damage
  > Loss of directional control during landing, due to nose landing gear damage sustained in the prior takeoff, resulting in a runway excursion and nose over.
- [NTSB GAA16CA146](https://openairdocs.org/ntsb/GAA16CA146.md): Beech D17 · Brighton, CO · Accident · Minor injuries · Data collection · Final report · Mar 11, 2016 · N9290H · Substantial damage
  > The pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.
- [NTSB ENG16WA009](https://openairdocs.org/ntsb/ENG16WA009.md): Zurich, Switzerland · Incident · No injuries · Foreign investigation · Mar 10, 2016
  > On March 10, 2016, about 1611 UTC, a Swiss Global Air Lines AVRO 146-RJ100 airplane, Swiss registration HB-IYT, rejected its takeoff at Zurich, Switzerland at 45 knots because of sparks coming from the No. 2 engine. The investigation of this incident is under…
- [NTSB DCA16WA111](https://openairdocs.org/ntsb/DCA16WA111.md): Boeing 737 · Billund, Denmark · Incident · No injuries · Foreign investigation · Mar 5, 2016 · TC-TJP · Minor damage
  > The Turkish Directorate General of Civil Aviation (DGCA) has notified the NTSB of an accident involving a Boeing 737 that occurred on March 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA of Turkey's investigation under…
- [NTSB WPR16LA078](https://openairdocs.org/ntsb/WPR16LA078.md): Boeing A75N1(PT17) · Palm Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 2016 · N63555 · Substantial damage
  > Improper assembly of a fuel hose, which restricted the fuel supply to the carburetor and resulted in a loss of engine power during the initial climb after takeoff.
- [NTSB CEN16FA114](https://openairdocs.org/ntsb/CEN16FA114.md): Ohlgren RV 6A · Abilene, TX · Accident · 2 fatal · Field investigation · Final report · Mar 1, 2016 · N419B · Destroyed
  > The pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…
- [NTSB ERA16LA120](https://openairdocs.org/ntsb/ERA16LA120.md): Czech Aircraft Works Spol Sro Sportcruiser · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Feb 28, 2016 · N187SF · Substantial damage
  > A total loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.
- [NTSB ANC16WA015](https://openairdocs.org/ntsb/ANC16WA015.md): Cessna 172 · Seoul, South Korea · Accident · 2 fatal · Foreign investigation · Feb 28, 2016 · HL 1153 · Destroyed
  > On February 28, 2016, about 1831 Local Time, a Cessna 172S airplane, Republic of Korea registration number HL1153, operated by the pilot, was destroyed following a loss of control shortly after takeoff from Gimbo International Airport, Republic of Korea.…
- [NTSB DCA16WA101](https://openairdocs.org/ntsb/DCA16WA101.md): Boeing 737 · a Mitad de la Pista del Aeropuerto, Mexico · Incident · No injuries · Foreign investigation · Feb 24, 2016 · C-FIWJ · No damage
  > The government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on February 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB GAA16CA139](https://openairdocs.org/ntsb/GAA16CA139.md): Cessna 172 · Willoughby, OH · Accident · No injuries · Data collection · Final report · Feb 21, 2016 · N516TG · Substantial damage
  > The student pilot's failure to reduce pitch attitude during a simulated engine failure during takeoff initial climb, resulting in a high descent rate and hard landing. Contributing to the accident was the flight instructor's delayed remedial action during the…
- [NTSB ERA16LA113](https://openairdocs.org/ntsb/ERA16LA113.md): Liberty Aerospace Liberty XL · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Feb 21, 2016 · N568XL · Substantial damage
  > A failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…
- [NTSB WPR16LA071](https://openairdocs.org/ntsb/WPR16LA071.md): Evolution Revo · Buckeye, AZ · Accident · 1 fatal · Limited investigation · Final report · Feb 16, 2016 · N107SB · Substantial damage
  > The pilot's improper decision to operate the high-performance aircraft despite warnings from a flight instructor that he did not have the experience to operate the aircraft that had different and more sensitive handling characteristics than the…
- [NTSB GAA16CA131](https://openairdocs.org/ntsb/GAA16CA131.md): Foxworthy Roy Christen Eagle · Bell City, LA · Accident · No injuries · Data collection · Final report · Feb 14, 2016 · N960RF · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.
- [NTSB GAA16CA141](https://openairdocs.org/ntsb/GAA16CA141.md): Maule M 4 · Anchorage, AK · Accident · No injuries · Data collection · Final report · Feb 13, 2016 · N2032U · Substantial damage
  > The inadvertent rudder input by the passenger, resulting in a runway excursion during takeoff and collision with a taxiway sign.
- [NTSB GAA16CA125](https://openairdocs.org/ntsb/GAA16CA125.md): Socata Tampico TB 9 · Fort Smith, AR · Accident · No injuries · Data collection · Final report · Feb 13, 2016 · N505PC · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in runway excursion, impact with terrain and an airport sign, and a postimpact fire.
- [NTSB CEN16IA103](https://openairdocs.org/ntsb/CEN16IA103.md): Cessna 560 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Feb 9, 2016 · N774SB · No damage
  > The loss of aileron trim due to the lack of separation between the cannon head on the back of autopilot cannon plug and the aileron trim tab control gear. Contributing to the incident was the lack of guidance in the airplane maintenance manual to verify…
- [NTSB ERA16LA104](https://openairdocs.org/ntsb/ERA16LA104.md): Bell 206 · Linden, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2016 · N206R · Substantial damage
  > The pilot receiving instruction's failure to maintain helicopter control during the initial takeoff, which resulted in a dynamic rollover. Contributing to the accident was the flight instructor's inadequate remedial action due to his distraction by looking…
- [NTSB CEN16FA094](https://openairdocs.org/ntsb/CEN16FA094.md): Costruzioni Aeronautiche Tecna P92 Echo Super · Arcola, TX · Accident · 1 fatal · Field investigation · Final report · Feb 1, 2016 · N323BR · Destroyed
  > The student pilot's loss of control after exceeding the airplane's critical angle-of-attack, which lead to a power-on, aerodynamic departure stall. Contributing to the accident was the flight instructor's inadequate oversight of the student pilot.
- [NTSB GAA16CA150](https://openairdocs.org/ntsb/GAA16CA150.md): Cessna 172 · La Junta, CO · Accident · No injuries · Data collection · Final report · Jan 31, 2016 · N2567U · Substantial damage
  > The pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.
- [NTSB OPS16IA004](https://openairdocs.org/ntsb/OPS16IA004.md): Airbus A321 231 · Fort Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Jan 29, 2016 · N587NK · No damage
  > The air traffic controller's failure to ensure the runway surface area was clear of vehicles before clearing an aircraft for takeoff. Also causal was the flight crew's decision to initiate a takeoff while the Runway Status Lights (RWSL) Takeoff Hold Lights…

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

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

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