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

## Cases, newest first

- [NTSB CEN14LA445](https://openairdocs.org/ntsb/CEN14LA445.md): Franke Roland SKY Raider · Bethel, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 2014 · N65692 · Substantial damage
  > The pilot's inadvertent aerodynamic stall while maneuvering after a loss of engine power during initial climb. Contributing to the accident was the total loss of engine power for reasons that could not be determined because the investigation could not…
- [NTSB CEN14LA441](https://openairdocs.org/ntsb/CEN14LA441.md): Becker Elmer L Stol CH 750 · Grain Valley, MO · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 2014 · N484XB · Substantial damage
  > The pilot’s failure to maintain airplane control during a low-speed, high-pitch climb after the airplane experienced a loss of electrical power and subsequent total loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was…
- [NTSB ANC14LA065](https://openairdocs.org/ntsb/ANC14LA065.md): Terry W. Thayer Zenith Stol CH701 · Nikiski, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 2014 · N957TT · Substantial damage
  > The pilot’s improper positioning of the fuel selector valves, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow preflight checklists.
- [NTSB ERA14CA408](https://openairdocs.org/ntsb/ERA14CA408.md): Day William L Minicoupe · Baltimore, MD · Accident · No injuries · Data collection · Final report · Aug 16, 2014 · N853WD · Substantial damage
  > The pilot/owner/builder's improper weight and balance calculations, which rendered the airplane uncontrollable in the pitch axis.
- [NTSB CEN14FA434](https://openairdocs.org/ntsb/CEN14FA434.md): Piper PA 32-300 · Ardmore, OK · Accident · 1 fatal · Field investigation · Final report · Aug 16, 2014 · N4125W · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because thermal damage to the engine prevented a complete examination.
- [NTSB WPR14LA341](https://openairdocs.org/ntsb/WPR14LA341.md): Mcdonnell Douglas Helicopter 500N · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Aug 12, 2014 · N18GH · Substantial damage
  > The pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB DCA14CA147](https://openairdocs.org/ntsb/DCA14CA147.md): Dehavilland DHC 8 102 · Harrisburg, PA · Accident · No injuries · Data collection · Final report · Aug 10, 2014 · N815EX · Substantial damage
  > the airplanes collision with geese during the takeoff roll.
- [NTSB WPR14CA339](https://openairdocs.org/ntsb/WPR14CA339.md): Piper PA 18 · Lysite, WY · Accident · Minor injuries · Data collection · Final report · Aug 8, 2014 · N1765P · Substantial damage
  > The pilot's failure to ensure the airplane was configured for takeoff.
- [NTSB CEN14WA420](https://openairdocs.org/ntsb/CEN14WA420.md): Quicksilver MXL Sport II · Cuenca, Spain · Accident · 1 fatal · Foreign investigation · Aug 8, 2014 · EC-FL8 · Substantial damage
  > On August 8, 2014, about 1920 coordinated universal time, a Quicksilver MXL Sport II, motorized ultralight (ULM) aircraft, registry EC-FL8, was substantially damaged after impacting terrain during takeoff. The pilot was fatally injured. At the time of the…
- [NTSB CEN14LA406](https://openairdocs.org/ntsb/CEN14LA406.md): Cessna 177RG · Manistee, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2014 · N468LE · Substantial damage
  > The pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…
- [NTSB CEN14LA411](https://openairdocs.org/ntsb/CEN14LA411.md): Hanson Lonn Avid Amphibian · Waterville, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2014 · N4118X · Substantial damage
  > The noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.
- [NTSB ANC14CA059](https://openairdocs.org/ntsb/ANC14CA059.md): Steven R Mcneese Airborne Edge X · Palmer, AK · Accident · No injuries · Data collection · Final report · Aug 2, 2014 · N821AK · Substantial damage
  > The non-certificated pilot's failure to maintain directional control while performing a high speed taxi test and inadvertent lift-off, which resulted in an inflight collision with trees and terrain.
- [NTSB WPR14LA323](https://openairdocs.org/ntsb/WPR14LA323.md): Rans S-16 · Fort Bridger, WY · Accident · No injuries · Limited investigation · Final report · Aug 1, 2014 · N116GS · Substantial damage
  > The fuel flow divider inlet line’s B-nut coming loose during takeoff, resulting in a total loss of engine power. Contributing to the accident was the pilot's failure to adequately tighten the B-nut during recent maintenance.
- [NTSB WPR14FA324](https://openairdocs.org/ntsb/WPR14FA324.md): S.N.I.A.S. AS350B · Tahoma, CA · Accident · Serious injuries · Field investigation · Final report · Aug 1, 2014 · N3597T · Substantial damage
  > The pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.
- [NTSB CEN14CA460](https://openairdocs.org/ntsb/CEN14CA460.md): Aviat Husky · Steamboat Springs, CO · Accident · No injuries · Data collection · Final report · Aug 1, 2014 · N776BC · Substantial damage
  > The student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.
- [NTSB ANC14LA058](https://openairdocs.org/ntsb/ANC14LA058.md): Dehavilland DHC 2 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jul 31, 2014 · N62197 · Substantial damage
  > The pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…
- [NTSB CEN14LA433](https://openairdocs.org/ntsb/CEN14LA433.md): Sutton William J Stits Playmate SA11A · Bridgeport, TX · Accident · No injuries · Limited investigation · Final report · Jul 29, 2014 · N76WS · Substantial damage
  > The pilot’s loss of airplane control during takeoff after encountering rapidly changing wind conditions.
- [NTSB WPR14CA317](https://openairdocs.org/ntsb/WPR14CA317.md): Air Tractor AT 802A · Hazelton, ID · Accident · No injuries · Data collection · Final report · Jul 28, 2014 · N802TY · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff roll in variable wind conditions.
- [NTSB ERA14CA365](https://openairdocs.org/ntsb/ERA14CA365.md): Cessna 182B · Clayton, GA · Accident · No injuries · Data collection · Final report · Jul 27, 2014 · N2275G · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.
- [NTSB ANC14CA061](https://openairdocs.org/ntsb/ANC14CA061.md): Aviat A 1 · Ketchikan, AK · Accident · No injuries · Data collection · Final report · Jul 26, 2014 · N400HU · Substantial damage
  > The pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.
- [NTSB CEN14CA395](https://openairdocs.org/ntsb/CEN14CA395.md): Cessna A188B · Milford, NE · Accident · No injuries · Data collection · Final report · Jul 23, 2014 · N730GU · Substantial damage
  > The pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.
- [NTSB ERA14CA352](https://openairdocs.org/ntsb/ERA14CA352.md): Cessna 172M · Chatham, MA · Accident · No injuries · Data collection · Final report · Jul 22, 2014 · N1066R · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.
- [NTSB CEN14LA387](https://openairdocs.org/ntsb/CEN14LA387.md): Aeronca 11AC · Flushing, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2014 · N4453P · Substantial damage
  > The pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…
- [NTSB WPR14LA305](https://openairdocs.org/ntsb/WPR14LA305.md): Cessna 150M · Russian Flat, MT · Accident · 1 fatal · Limited investigation · Final report · Jul 21, 2014 · N66255 · Substantial damage
  > The pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…
- [NTSB WPR14CA319](https://openairdocs.org/ntsb/WPR14CA319.md): Bell 206B · Salinas, CA · Accident · No injuries · Data collection · Final report · Jul 19, 2014 · N291SH · Substantial damage
  > The pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.
- [NTSB WPR14CA294](https://openairdocs.org/ntsb/WPR14CA294.md): Thrush S2RHG T65 · Parma, ID · Accident · Minor injuries · Data collection · Final report · Jul 16, 2014 · N4036G · Substantial damage
  > The pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.
- [NTSB WPR14CA293](https://openairdocs.org/ntsb/WPR14CA293.md): Grumman Acft ENG Cor-Schweizer G 164B · Marysville, CA · Accident · No injuries · Data collection · Final report · Jul 14, 2014 · N48475 · Substantial damage
  > The pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…
- [NTSB CEN14CA380](https://openairdocs.org/ntsb/CEN14CA380.md): Dantonio 404 · Wichita Falls, TX · Accident · No injuries · Data collection · Final report · Jul 14, 2014 · N482FD · Substantial damage
  > The separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.
- [NTSB CEN14CA368](https://openairdocs.org/ntsb/CEN14CA368.md): Mckenzie Douglas E Stol CH750 · Dodgeville, MI · Accident · Minor injuries · Data collection · Final report · Jul 13, 2014 · N792MC · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.
- [NTSB CEN14FA356](https://openairdocs.org/ntsb/CEN14FA356.md): Mooney M20M · Greenwood, IN · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2014 · N72FG · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. Also causal to the accident was the pilots' decision…
- [NTSB CEN14CA366](https://openairdocs.org/ntsb/CEN14CA366.md): Air Tractor AT 502B · Cavalier, ND · Accident · No injuries · Data collection · Final report · Jul 11, 2014 · N636LA · Substantial damage
  > The pilot's loss of control during the takeoff roll.
- [NTSB CEN14CA353](https://openairdocs.org/ntsb/CEN14CA353.md): Cessna 172N · Edgewood, NM · Accident · No injuries · Data collection · Final report · Jul 10, 2014 · N4842G · Substantial damage
  > The pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.
- [NTSB WPR14CA291](https://openairdocs.org/ntsb/WPR14CA291.md): Delconte Emidio J Kitfox Series V · Cove, OR · Accident · Minor injuries · Data collection · Final report · Jul 8, 2014 · N68KF · Substantial damage
  > The pilot's failure to maintain directional control during takeoff when the airplane encountered standing water on the airstrip.
- [NTSB CEN14LA346](https://openairdocs.org/ntsb/CEN14LA346.md): Buckeye Dream Machine · Ansley, NE · Accident · 1 fatal · Limited investigation · Final report · Jul 8, 2014 · N4394V · No damage
  > The powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…
- [NTSB CEN14LA349](https://openairdocs.org/ntsb/CEN14LA349.md): Air Tractor AT-502 · Carthage, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2014 · N9185G · Substantial damage
  > The airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.
- [NTSB CEN14LA334](https://openairdocs.org/ntsb/CEN14LA334.md): Piper PA-28-140 · Granbury, TX · Accident · No injuries · Limited investigation · Final report · Jul 2, 2014 · N9898W · Substantial damage
  > The partial loss of engine power due to the failure of the exhaust valve.
- [NTSB ANC14FA050](https://openairdocs.org/ntsb/ANC14FA050.md): Piper PA 12 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2014 · N3512M · Substantial damage
  > The incorrect (reverse) rigging of the elevator control cables, and the pilot’s inadequate preflight inspection, which failed to detect the misrigging.
- [NTSB CEN14IA329](https://openairdocs.org/ntsb/CEN14IA329.md): Eurocopter AS 350 B3 · Temple, TX · Incident · No injuries · Incident investigation · Final report · Jun 26, 2014 · N808LF · Minor damage
  > The pilot’s failure to reposition the yaw servo hydraulic switch to the “on” position during the pretakeoff hydraulic system check, which resulted in a complete lack of hydraulic boost to the tail rotor system and increased the load required to move the…
- [NTSB WPR14LA269](https://openairdocs.org/ntsb/WPR14LA269.md): Piper PA 30 · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 2014 · N7350Y · Substantial damage
  > The pilot’s inadequate preflight planning and checks, during which he failed to determine the quantity and distribution of the fuel, which resulted in the loss of right engine power during takeoff due to fuel starvation.
- [NTSB ANC14CA047](https://openairdocs.org/ntsb/ANC14CA047.md): Piper PA 18 · Cantwell, AK · Accident · No injuries · Data collection · Final report · Jun 25, 2014 · N72842 · Substantial damage
  > The pilot's encounter with a wind gust during takeoff from a short gravel bar, which resulted in the airplane settling after rotation and striking obstacles.
- [NTSB ERA14LA305](https://openairdocs.org/ntsb/ERA14LA305.md): Christen Industries A 1 · Tampa, FL · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 2014 · N436C · Substantial damage
  > The pilot’s failure to maintain airplane control during initial climb after takeoff, which resulted in an uncontrolled descent into the ground.
- [NTSB CEN14WA332](https://openairdocs.org/ntsb/CEN14WA332.md): Cessna U206 · Abbeyshrule, Ireland · Accident · No injuries · Foreign investigation · Jun 21, 2014 · G-SKYE · Substantial damage
  > On June 21, 2014, about 1115 hours universal coordinated time, a Cessna model U206 Turbo Stationair, United Kingdom registration G-SKYE, was substantially damaged during a forced landing following a loss of engine power after takeoff from the Abbeyshrule…
- [NTSB CEN14LA320](https://openairdocs.org/ntsb/CEN14LA320.md): Cessna 172XP · St. Cloud, MN · Accident · No injuries · Limited investigation · Final report · Jun 20, 2014 · N758HP · Substantial damage
  > The pilot's failure to maintain the proper airspeed and angle-of-attack after a partial loss of engine power on takeoff, which resulted in a stall and the subsequent impact with water. Contributing to the accident was the partial loss of engine power due to…
- [NTSB ANC14CA044](https://openairdocs.org/ntsb/ANC14CA044.md): Cessna 208B · Egegik, AK · Accident · No injuries · Data collection · Final report · Jun 20, 2014 · N208SM · Substantial damage
  > The pilot's loss of situational awareness during the takeoff roll resulting in a collision with a refrigeration trailer.
- [NTSB WPR14LA250](https://openairdocs.org/ntsb/WPR14LA250.md): Cessna 172RG · Alturas, CA · Accident · No injuries · Limited investigation · Final report · Jun 19, 2014 · N6091R · Substantial damage
  > The airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…
- [NTSB CEN14LA308](https://openairdocs.org/ntsb/CEN14LA308.md): Gulfstream Schweizer A/C Gulfstream AM G 164C · Beech Grove, AR · Accident · No injuries · Limited investigation · Final report · Jun 19, 2014 · N7501Z · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in his attempt to take off with insufficient climb performance to climb out of ground effect in the high-density altitude conditions.
- [NTSB ANC14CA043](https://openairdocs.org/ntsb/ANC14CA043.md): Piper PA 18-135 · Beluga, AK · Accident · No injuries · Data collection · Final report · Jun 19, 2014 · N27293 · Substantial damage
  > The pilot's loss of control when encountering a downdraft during the initial climb after takeoff, resulting in a collision with brush and terrain.
- [NTSB ERA14FA300](https://openairdocs.org/ntsb/ERA14FA300.md): Israel Aircraft Industries 1124A · Huntsville, AL · Accident · 3 fatal · Field investigation · Final report · Jun 18, 2014 · N793BG · Destroyed
  > The flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…
- [NTSB CEN14LA301](https://openairdocs.org/ntsb/CEN14LA301.md): Grumman Acft ENG Cor-Schweizer G-164B · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 2014 · N993QC · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN14LA299](https://openairdocs.org/ntsb/CEN14LA299.md): Air Tractor AT 502 · Dell, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2014 · N9184T · Substantial damage
  > The pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.

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

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

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