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

## Cases, newest first

- [NTSB CEN17LA122](https://openairdocs.org/ntsb/CEN17LA122.md): Piper PA 28R-200 · Centennial, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2017 · N2702R · Substantial damage
  > The loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB DCA17WA221](https://openairdocs.org/ntsb/DCA17WA221.md): Boeing 737 · Riga, Latvia · Incident · No injuries · Foreign investigation · Feb 17, 2017 · VP-BVS · No damage
  > The Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on February 17, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…
- [NTSB DCA17CA064](https://openairdocs.org/ntsb/DCA17CA064.md): Bombardier CL 600 2C10 · Charlotte, NC · Accident · No injuries · Data collection · Final report · Feb 15, 2017 · N709PS · Substantial damage
  > collision with a deer during takeoff.
- [NTSB GAA17CA148](https://openairdocs.org/ntsb/GAA17CA148.md): Beech A23 · Beckwourth, CA · Accident · Serious injuries · Data collection · Final report · Feb 14, 2017 · N425RS · Substantial damage
  > The student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.
- [NTSB CEN17LA104](https://openairdocs.org/ntsb/CEN17LA104.md): Beech D55 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Feb 14, 2017 · N88EB · Substantial damage
  > The partial loss of left engine power during takeoff and initial climb, which led to a hard landing in gusting crosswind conditions. The reason for the loss of engine power could not be determined because postaccident examination of the left engine revealed…
- [NTSB CEN17WA109](https://openairdocs.org/ntsb/CEN17WA109.md): Cessna TU206G · Tamazula, Mexico · Accident · 3 fatal · Foreign investigation · Feb 10, 2017 · XA-UIL · Substantial damage
  > On February 10, 2017, about 1850 hours universal coordinated time, a Cessna model TU206G single-engine airplane, serial number U20605373, Mexican registration XA-UIL, crashed shortly after takeoff from Alizal Airport (MX-0092), located near Tamazula, Durango,…
- [NTSB GAA17CA130](https://openairdocs.org/ntsb/GAA17CA130.md): Robinson Helicopter R22 · Armstrong, TX · Accident · No injuries · Data collection · Final report · Jan 31, 2017 · N883KC · Substantial damage
  > The pilot’s failure to remove the left helicopter skid tie-down before takeoff, which resulted in dynamic roll-over.
- [NTSB CEN17FA085](https://openairdocs.org/ntsb/CEN17FA085.md): Cessna 172 · Jay, OK · Accident · 1 fatal · Field investigation · Final report · Jan 25, 2017 · N5639A · Substantial damage
  > The pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…
- [NTSB CEN17LA123](https://openairdocs.org/ntsb/CEN17LA123.md): Beech C 99 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jan 24, 2017 · N216CS · Substantial damage
  > The pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.
- [NTSB WPR17LA054](https://openairdocs.org/ntsb/WPR17LA054.md): Johnson Harmon Rocket · Corona, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 17, 2017 · N275JS · Substantial damage
  > A total loss of engine power during takeoff due to fuel starvation as a result of a failure of internal components of the fuel servo.
- [NTSB ERA17LA091](https://openairdocs.org/ntsb/ERA17LA091.md): American Legend AL3 · Pierson, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2017 · N841ML · Substantial damage
  > The pilot's improper braking during takeoff, which resulted in a nose-over.
- [NTSB GAA17CA114](https://openairdocs.org/ntsb/GAA17CA114.md): Beech B200 · Coalinga, CA · Accident · No injuries · Data collection · Final report · Jan 14, 2017 · N795DE · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB GAA17CA110](https://openairdocs.org/ntsb/GAA17CA110.md): Christen Industries A 1 · Milton-Freewater, OR · Accident · No injuries · Data collection · Final report · Jan 10, 2017 · N9598Z · Substantial damage
  > The pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.
- [NTSB DCA17WA053](https://openairdocs.org/ntsb/DCA17WA053.md): Boeing Boeing 737-8K5 · Bournemouth, United Kingdom · Incident · No injuries · Foreign investigation · Jan 10, 2017 · G-FDZY · Minor damage
  > The government of United Kingdom has notified the NTSB of an accident involving a BOEING COMPANY BOEING 737-8K5 airplane that occurred on January 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's…
- [NTSB CEN17FA067](https://openairdocs.org/ntsb/CEN17FA067.md): Demmer BD-4 · Brookfield, WI · Accident · 1 fatal · Field investigation · Final report · Jan 4, 2017 · N311SD · Substantial damage
  > The pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.
- [NTSB ERA17WA076](https://openairdocs.org/ntsb/ERA17WA076.md): Air Tractor AT802 · Santa Juana, Chile · Accident · 1 fatal · Foreign investigation · Dec 28, 2016 · CC-CCJ · Destroyed
- [NTSB DCA17WA047](https://openairdocs.org/ntsb/DCA17WA047.md): Boeing 737 · Dabolim, Goa, India · Accident · Minor injuries · Foreign investigation · Dec 27, 2016 · VT-JBG · Substantial damage
  > The India Air Accident Investigation Bureau (AAIB) has notified the NTSB of an accident involving a Boeing 737-800 airplane that occurred on December 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…
- [NTSB CEN17LA061](https://openairdocs.org/ntsb/CEN17LA061.md): Mead RV 8A · Farmington, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 2016 · N918KS · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff in crosswind conditions.
- [NTSB DCA17WA044](https://openairdocs.org/ntsb/DCA17WA044.md): Boeing 727 · Puerto Carreno, Colombia · Accident · 3 fatal · Foreign investigation · Dec 20, 2016 · HK4544 · Destroyed
  > The Accident Investigation Group (AIG) of Colombia has notified the NTSB of an accident involving a Boeing 727 airplane that occurred on December 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Colombia's investigation…
- [NTSB CEN17LA057](https://openairdocs.org/ntsb/CEN17LA057.md): Stinson 108-3 · Ionia, MI · Accident · No injuries · Limited investigation · Final report · Dec 16, 2016 · N812C · Substantial damage
  > A failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.
- [NTSB GAA17CA101](https://openairdocs.org/ntsb/GAA17CA101.md): Maule MX 7 · Willow, AK · Accident · No injuries · Data collection · Final report · Dec 15, 2016 · N56681 · Substantial damage
  > The pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.
- [NTSB ERA17WA080](https://openairdocs.org/ntsb/ERA17WA080.md): Neiva EMB-721D · Manaus, Brazil · Accident · 6 fatal · Foreign investigation · Dec 7, 2016 · PT-REI · Destroyed
  > On December 7, 2016, about 1150 UTC, an Industria Aeronautica Neiva S/A EMB 721D, Brazilian registration PT-REI, registered to and operated by a foreign individual, collided with trees then terrain shortly after takeoff. Visual meteorological conditions…
- [NTSB ERA17LA063](https://openairdocs.org/ntsb/ERA17LA063.md): Cirrus Design SR22 · Bluefield, WV · Accident · No injuries · Limited investigation · Final report · Nov 22, 2016 · N217CE · Substantial damage
  > The pilot's failure to maintain directional control during the aborted takeoff.
- [NTSB CEN17LA042](https://openairdocs.org/ntsb/CEN17LA042.md): Northwing Navajo · Daingerfield, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2016 · N360XL · Substantial damage
  > The noncertificated pilot’s unfamiliarity with the aircraft, which resulted in a loss of control during an unintentional takeoff.
- [NTSB GAA17CA081](https://openairdocs.org/ntsb/GAA17CA081.md): Cessna 172 · Destin, FL · Accident · No injuries · Data collection · Final report · Nov 17, 2016 · N9358L · Substantial damage
  > The student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.
- [NTSB GAA17CA070](https://openairdocs.org/ntsb/GAA17CA070.md): Robinson Helicopter R44 · Stone Lake, WI · Accident · Minor injuries · Data collection · Final report · Nov 12, 2016 · N744JS · Substantial damage
  > The pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.
- [NTSB WPR17LA019](https://openairdocs.org/ntsb/WPR17LA019.md): Bell 206B · Yuma, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 2016 · N914HH · Substantial damage
  > The pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.
- [NTSB GAA17CA073](https://openairdocs.org/ntsb/GAA17CA073.md): Carter Richard L Buddy Baby Lakes · Hurricane, UT · Accident · No injuries · Data collection · Final report · Nov 10, 2016 · N1028Q · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB GAA17CA076](https://openairdocs.org/ntsb/GAA17CA076.md): Cessna 172 · Salmon, ID · Accident · No injuries · Data collection · Final report · Nov 8, 2016 · N737MY · Substantial damage
  > The airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.
- [NTSB GAA17CA057](https://openairdocs.org/ntsb/GAA17CA057.md): Piper PA18 · Mouth of The Big Susitna River, AK · Accident · No injuries · Data collection · Final report · Nov 7, 2016 · N62744 · Substantial damage
  > The pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.
- [NTSB GAA17CA056](https://openairdocs.org/ntsb/GAA17CA056.md): Beech 76 · Davis, CA · Accident · No injuries · Data collection · Final report · Nov 5, 2016 · N6703L · Substantial damage
  > The pilot's failure to maintain directional control during a simulated left engine failure during takeoff. Also causal to the accident was the flight instructor's delayed remedial action to maintain directional control and reduce the right engine mixture…
- [NTSB CEN17FA035](https://openairdocs.org/ntsb/CEN17FA035.md): Stamper RV-10 · Dubois, WY · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2016 · N924WY · Destroyed
  > The pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…
- [NTSB CEN17LA029](https://openairdocs.org/ntsb/CEN17LA029.md): Beech 100 · Jeffersonville, IN · Accident · No injuries · Limited investigation · Final report · Oct 30, 2016 · N411HA · Substantial damage
  > The pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…
- [NTSB DCA17FA021](https://openairdocs.org/ntsb/DCA17FA021.md): Boeing 767 · Chicago, IL · Accident · Serious injuries · Class 1 · Field · Final report · Oct 28, 2016 · N345AN · Substantial damage
  > The failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…
- [NTSB CEN17LA031](https://openairdocs.org/ntsb/CEN17LA031.md): Piper PA 28-236 · Lexington, MO · Accident · No injuries · Limited investigation · Final report · Oct 27, 2016 · N4376V · Substantial damage
  > A total loss of engine power during takeoff for reasons that could not be determined based on available information.
- [NTSB CEN17FA026](https://openairdocs.org/ntsb/CEN17FA026.md): Roe Cleo Wittman Tailwind W10 · Pearland, TX · Accident · 1 fatal · Field investigation · Final report · Oct 26, 2016 · N557CL · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…
- [NTSB CEN17LA032](https://openairdocs.org/ntsb/CEN17LA032.md): Boeing A75N1 (PT17) · Ingleside, TX · Accident · No injuries · Limited investigation · Final report · Oct 25, 2016 · N48182 · Substantial damage
  > The pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.
- [NTSB CEN17LA025](https://openairdocs.org/ntsb/CEN17LA025.md): Cessna 182Q · Buffalo, WY · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 2016 · N97878 · Substantial damage
  > The pilot’s failure to set the proper flap position before the short field takeoff, which resulted in a runway excursion and impact with terrain.
- [NTSB WPR17LA009](https://openairdocs.org/ntsb/WPR17LA009.md): Gray Jim Robert Exec 90 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Oct 19, 2016 · N716JB · Substantial damage
  > The pilot's failure to properly tighten the tension bolts during the installation of the alternator belt, which resulted in inadequate voltage to sustain ignition and the subsequent partial loss of engine power.
- [NTSB GAA17CA033](https://openairdocs.org/ntsb/GAA17CA033.md): Stinson 108 3 · Boulder City, NV · Accident · Minor injuries · Data collection · Final report · Oct 19, 2016 · N818C · Substantial damage
  > The pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.
- [NTSB GAA17CA042](https://openairdocs.org/ntsb/GAA17CA042.md): Cessna 152 · Miami, FL · Accident · No injuries · Data collection · Final report · Oct 17, 2016 · N46953 · Substantial damage
  > The student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.
- [NTSB ERA17LA020](https://openairdocs.org/ntsb/ERA17LA020.md): Taylorcraft BC12 D · Vaughn, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2016 · N94919 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17WA017](https://openairdocs.org/ntsb/CEN17WA017.md): Cessna F150 · Cambridge, United Kingdom · Accident · 1 fatal · Foreign investigation · Oct 17, 2016 · G-BDZC · Substantial damage
  > On October 17, 2016, at 1021 coordinated universal time, a Reims Cessna F150M airplane, G-BDZC, crashed after takeoff at the Bourn Airfield (EGSN), Cambridge, United Kingdom. The pilot was fatally injured.The accident investigation is under the jurisdiction…
- [NTSB GAA17CA051](https://openairdocs.org/ntsb/GAA17CA051.md): Cessna 152 · Chickaloon, AK · Accident · No injuries · Data collection · Final report · Oct 14, 2016 · N488E · Substantial damage
  > The flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.
- [NTSB GAA17CA020](https://openairdocs.org/ntsb/GAA17CA020.md): Remos Remos GX · Lowell, AR · Accident · No injuries · Data collection · Final report · Oct 11, 2016 · N27GX · Substantial damage
  > The pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.
- [NTSB DCA17WA006](https://openairdocs.org/ntsb/DCA17WA006.md): Boeing 777 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Oct 9, 2016 · 9V-SYG · Minor damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB GAA17CA014](https://openairdocs.org/ntsb/GAA17CA014.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Oct 6, 2016 · N602ND · Substantial damage
  > The flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.
- [NTSB GAA17CA011](https://openairdocs.org/ntsb/GAA17CA011.md): Fuller Neil H Glasair SH 2 · Bellingham, WA · Accident · No injuries · Data collection · Final report · Oct 5, 2016 · N724NF · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.
- [NTSB WPR17CA001](https://openairdocs.org/ntsb/WPR17CA001.md): Cessna R172K · Rosamond, CA · Accident · No injuries · Data collection · Final report · Oct 2, 2016 · N736LZ · Substantial damage
  > The pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.
- [NTSB CEN17LA001](https://openairdocs.org/ntsb/CEN17LA001.md): Drake Kitfox Speedster · Jennings, LA · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2016 · N157D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.

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

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

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