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

## Cases, newest first

- [NTSB ERA15LA365](https://openairdocs.org/ntsb/ERA15LA365.md): Clark 1000 · Warehouse Point, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 2015 · N9018R · Substantial damage
  > The pilot’s failure to maintain adequate airspeed 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 the pilot's decision to…
- [NTSB ERA15CA364](https://openairdocs.org/ntsb/ERA15CA364.md): Hughes 269B · Hartford, AL · Accident · Minor injuries · Data collection · Final report · Sep 19, 2015 · N141LL · Substantial damage
  > The pilot's inadequate preflight planning, and his subsequent failure to attain adequate altitude during takeoff, which resulted in a collision with a wire fence.
- [NTSB GAA15LA281](https://openairdocs.org/ntsb/GAA15LA281.md): Dehavilland DHC 2 MK.I · Nikolai, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 2015 · N676SP · Substantial damage
  > A loss of directional control during a water takeoff for reasons that could not be determined because the airplane was not examined due to the remote accident location.
- [NTSB ANC15LA070](https://openairdocs.org/ntsb/ANC15LA070.md): Helio H 295 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 2015 · N6464V · Substantial damage
  > A partial loss of engine power during takeoff 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.
- [NTSB GAA15CA260](https://openairdocs.org/ntsb/GAA15CA260.md): Rocci Martignoni JA30 Superstol · Santa Rosa, NM · Accident · No injuries · Data collection · Final report · Sep 11, 2015 · N508RM · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.
- [NTSB CEN15LA405](https://openairdocs.org/ntsb/CEN15LA405.md): Piper PA-36-375 · Elmwood, NE · Accident · No injuries · Limited investigation · Final report · Sep 9, 2015 · N1057E · Substantial damage
  > The pilot’s decision to take off with the airplane near its maximum gross weight from a runway that did not have sufficient length for the airplane to achieve a normal takeoff and positive climb rate after liftoff.
- [NTSB DCA15FA185](https://openairdocs.org/ntsb/DCA15FA185.md): Boeing Boeing 777-236 · Las Vegas, NV · Accident · Serious injuries · Field investigation · Final report · Sep 8, 2015 · G-VIIO · Substantial damage
  > The failure of the left engine high-pressure compressor (HPC) stage 8-10 spool, which caused the main fuel supply line to become detached from the engine main fuel pump and release fuel, resulting in a fire on the left side of the airplane. The HPC stage 8-10…
- [NTSB ERA15LA357](https://openairdocs.org/ntsb/ERA15LA357.md): Beech V35B · Wilmington, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2015 · N789WF · Substantial damage
  > The pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.
- [NTSB CEN15WA401](https://openairdocs.org/ntsb/CEN15WA401.md): Cessna 150F · Brackley, United Kingdom · Accident · 1 fatal · Foreign investigation · Sep 4, 2015 · G-ATKF · Substantial damage
  > On September 4, 2015, about 1110 coordinated universal time, a Cessna 150F airplane, G-ATKF, impacted terrain during takeoff at the Hinton in the Hedges Airfield, near Brackley, United Kingdom. The pilot was fatally injured and the airplane sustained…
- [NTSB ANC15CA075](https://openairdocs.org/ntsb/ANC15CA075.md): Dehavilland Beaver DHC 2 MK.1 · Arctic Village, AK · Accident · No injuries · Data collection · Final report · Sep 3, 2015 · N55WE · Substantial damage
  > The pilot's selection of an unsuitable, off-airport site, which resulted in a nose over.
- [NTSB GAA15CA244](https://openairdocs.org/ntsb/GAA15CA244.md): Joe Salomone Super CUB SQ2 · Truckee, CA · Accident · No injuries · Data collection · Final report · Sep 1, 2015 · N786AB · Substantial damage
  > The pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion, ground loop, and impact with terrain. Contributing to the accident was the pilot's lack of experience from the back seat.
- [NTSB ERA15WA346](https://openairdocs.org/ntsb/ERA15WA346.md): Bell 206L-3 · Boyaca, Colombia · Accident · Minor injuries · Foreign investigation · Sep 1, 2015 · HK 3311 · Substantial damage
  > On September 1, 2015, about 1925 UTC, a Bell 206L-3, HK 3311, registered to and operated by Sociedad Aerea De Ibague, was landed hard in a field during a forced landing near Municipality of Chita, Boyaca, Colombia. Visual meteorological conditions prevailed…
- [NTSB DCA15WA181](https://openairdocs.org/ntsb/DCA15WA181.md): Swearingen SA227 · Thangool, Australia · Accident · No injuries · Foreign investigation · Sep 1, 2015 · VH-HPE · Substantial damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA227 airplane, which occurred on September 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…
- [NTSB CEN15WA408](https://openairdocs.org/ntsb/CEN15WA408.md): Piper PA-46-350P · Cannes, France · Accident · Minor injuries · Foreign investigation · Aug 31, 2015 · D-ESPE · Destroyed
  > On August 31, 2015, about 0655 coordinated universal time, a Piper PA-46-350P airplane, D-ESPE, landed in the bay near Cannes, France, following a loss of engine power after takeoff from the Cannes-Mandelieu Airport (LFMD), Cannes, France. The pilot and…
- [NTSB CEN15LA391](https://openairdocs.org/ntsb/CEN15LA391.md): Ference John W Thatcher CX4A · Hebron, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2015 · N443JF · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB GAA15CA243](https://openairdocs.org/ntsb/GAA15CA243.md): Cessna 172 · New Enterprise, PA · Accident · No injuries · Data collection · Final report · Aug 30, 2015 · N8404X · Substantial damage
  > The pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB GAA15CA253](https://openairdocs.org/ntsb/GAA15CA253.md): Air Creation USA Skypper · Stow, MA · Accident · Minor injuries · Data collection · Final report · Aug 29, 2015 · N534AC · Substantial damage
  > The student pilot's improper directional control inputs during the takeoff roll, resulting in a roll over and collision with terrain.
- [NTSB CEN15FA386](https://openairdocs.org/ntsb/CEN15FA386.md): Barrow Ted A ONE Easy · Battle Creek, MI · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N227TB · Destroyed
  > The pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.
- [NTSB CEN15WA393](https://openairdocs.org/ntsb/CEN15WA393.md): Beech C90 · Helsinki, Finland · Accident · No injuries · Foreign investigation · Aug 26, 2015 · OH-BEX · Substantial damage
  > On August 26, 2015, at 0535 universal coordinated time, a Beechcraft C90 airplane, Finnish registration OH-BEX, owned and operated by Scanwings Oy, sustained substantial damage when the nose landing gear collapsed during landing at the Helsinki-Vantaa…
- [NTSB CEN15LA382](https://openairdocs.org/ntsb/CEN15LA382.md): Piper PA 22-160 · Tyler, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 2015 · N2805Z · Substantial damage
  > The student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.
- [NTSB GAA15CA262](https://openairdocs.org/ntsb/GAA15CA262.md): Aero Commander 500 B · The Dalles, OR · Accident · No injuries · Data collection · Final report · Aug 19, 2015 · N1010F · Substantial damage
  > A motor vehicle's runway incursion causing the premature rotation of the departing airplane, which resulted in a tail strike.
- [NTSB WPR15IA244](https://openairdocs.org/ntsb/WPR15IA244.md): Quest Kodiac 100 · Page, AZ · Incident · No injuries · Incident investigation · Final report · Aug 17, 2015 · N771RT · Minor damage
  > The pilot's inadvertent failure to engage the seat in the locked position before takeoff, which resulted in the seat sliding back during the takeoff roll and a subsequent loss of directional control. Contributing to the incident was the seat locking…
- [NTSB ERA15CA320](https://openairdocs.org/ntsb/ERA15CA320.md): Sanderson Herbert H SHA Glasair · Bladenboro, NC · Accident · Minor injuries · Data collection · Final report · Aug 15, 2015 · N629HS · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.
- [NTSB ERA15FA308](https://openairdocs.org/ntsb/ERA15FA308.md): Beech N35 · Weirsdale, FL · Accident · 2 fatal · Field investigation · Final report · Aug 12, 2015 · N390Z · Destroyed
  > A partial loss of engine power during takeoff. The reason for the partial loss of power could not be determined due to the extensive fire and impact damage to the engine.
- [NTSB ERA15LA306](https://openairdocs.org/ntsb/ERA15LA306.md): Wright Daniel J Volksplane VP-1 · Brooksville, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2015 · N9288 · Destroyed
  > The pilot's failure to abort the takeoff after determining that the engine was not producing adequate power. Contributing to the accident was the engine's inability to produce adequate power for reasons that could not be determined due to extensive postimpact…
- [NTSB GAA15CA216](https://openairdocs.org/ntsb/GAA15CA216.md): Cessna 150M · Ellijay, GA · Accident · No injuries · Data collection · Final report · Aug 5, 2015 · N3568V · Substantial damage
  > The pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.
- [NTSB CEN15LA345](https://openairdocs.org/ntsb/CEN15LA345.md): Air Tractor AT 401 · Nekoosa, WI · Accident · No injuries · Limited investigation · Final report · Aug 5, 2015 · N1539U · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in his attempt to take off for the agricultural application flight with the airplane over its maximum gross weight in high-density altitude conditions and led to the airplane’s degraded climb…
- [NTSB WPR15LA226](https://openairdocs.org/ntsb/WPR15LA226.md): Taylorcraft 12-m · Selma, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 2015 · N49153 · Substantial damage
  > The pilot receiving instruction's use of an excessive pitch attitude during takeoff with the airplane near its maximum gross weight in hot and humid conditions, which degraded the airplane’s climb performance and resulted in a collision with obstacles during…
- [NTSB ERA16WA039](https://openairdocs.org/ntsb/ERA16WA039.md): Cessna 650 · Corlu, Türkiye · Incident · No injuries · Foreign investigation · Aug 1, 2015 · N692BE · Minor damage
  > On August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…
- [NTSB CEN15LA335](https://openairdocs.org/ntsb/CEN15LA335.md): Air Tractor AT 502B · Virden, IL · Accident · No injuries · Limited investigation · Final report · Aug 1, 2015 · N502LH · Substantial damage
  > The pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.
- [NTSB GAA15CA199](https://openairdocs.org/ntsb/GAA15CA199.md): Norton Claude C Tailwind W8 · Portales, NM · Accident · Minor injuries · Data collection · Final report · Jul 26, 2015 · N299CB · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.
- [NTSB GAA15CA198](https://openairdocs.org/ntsb/GAA15CA198.md): Evektor-Aerotechnik Sportstar · Eufaula, AL · Accident · No injuries · Data collection · Final report · Jul 26, 2015 · N804EV · Substantial damage
  > The pilot's failure to maintain direction control during takeoff, and the pilot's failure to ensure that the canopy of the airplane was secured and locked prior to departure.
- [NTSB ANC15WA060](https://openairdocs.org/ntsb/ANC15WA060.md): Piper PA46 - 350P · Tokyo, Japan · Accident · 3 fatal · Foreign investigation · Jul 26, 2015 · JA4060 · Destroyed
  > On July 26, 2015, at 0200 coordinated universal time, a Japanese registered Piper PA46-350P airplane, JA4060, operated by a private individual, impacted a residential area shortly after takeoff from Chofu Airfield, Tokyo, Japan. The pilot, one passenger, and…
- [NTSB GAA15CA202](https://openairdocs.org/ntsb/GAA15CA202.md): Bell 47G · De Queen, AR · Accident · Minor injuries · Data collection · Final report · Jul 25, 2015 · N1420W · Substantial damage
  > The pilot's failure to conduct helicopter performance planning, which resulted in an uncontrolled descent and impact with a truck and terrain during takeoff from an elevated platform.
- [NTSB ERA15LA286](https://openairdocs.org/ntsb/ERA15LA286.md): Beech A36 · Poughkeepsie, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 2015 · N6677D · Substantial damage
  > A leaking fuel discharge fitting, which resulted in a partial loss of engine power and an off-airport, gear-up landing.
- [NTSB ERA15CA307](https://openairdocs.org/ntsb/ERA15CA307.md): Johnny F Anderson Buckeye Dream Machin · Trenton, SC · Accident · Minor injuries · Data collection · Final report · Jul 25, 2015 · N371P · Substantial damage
  > The non-certificated pilot's inadequate preflight inspection, which resulted in a loss of directional control during takeoff, and collision with trees during the subsequent rejected takeoff.
- [NTSB ANC15LA057](https://openairdocs.org/ntsb/ANC15LA057.md): Found Acft Canada FBA 2C1 · Cold Bay, AK · Accident · No injuries · Limited investigation · Final report · Jul 24, 2015 · N798 · Substantial damage
  > The pilot's failure to maintain adequate distance from surrounding terrain during the takeoff sequence, which resulted in the airplane contacting the terrain, prematurely becoming airborne, and subsequently entering an aerodynamic stall.
- [NTSB GAA15CA220](https://openairdocs.org/ntsb/GAA15CA220.md): Cessna 150M · Apopka, FL · Accident · No injuries · Data collection · Final report · Jul 23, 2015 · N704SB · Substantial damage
  > Following a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.
- [NTSB DCA15WA209](https://openairdocs.org/ntsb/DCA15WA209.md): Boeing 737 · Monterrey, Mexico · Incident · No injuries · Foreign investigation · Jul 23, 2015 · XA-UTE
  > The government of Mexico has notified the NTSB of an incident involving a Boeing 737 that occurred on July 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO Annex…
- [NTSB CEN15LA313](https://openairdocs.org/ntsb/CEN15LA313.md): Luscombe 8E · Perry, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2015 · N2789K · Substantial damage
  > The pilot's incapacitation and subsequent loss of airplane control due to heat exhaustion.
- [NTSB ANC15CA053](https://openairdocs.org/ntsb/ANC15CA053.md): Cessna U206F · Kasilof, AK · Accident · No injuries · Data collection · Final report · Jul 22, 2015 · N206CL · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in a jammed elevator and subsequent loss of control and collision with terrain.
- [NTSB GAA15CA193](https://openairdocs.org/ntsb/GAA15CA193.md): Luscombe 8A · Oxford, IA · Accident · Minor injuries · Data collection · Final report · Jul 19, 2015 · N45508 · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.
- [NTSB ERA15LA274](https://openairdocs.org/ntsb/ERA15LA274.md): Cessna 172S · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Jul 19, 2015 · N962SP · Substantial damage
  > The pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.
- [NTSB GAA15CA192](https://openairdocs.org/ntsb/GAA15CA192.md): Cessna R172K · Fairfield, NC · Accident · No injuries · Data collection · Final report · Jul 18, 2015 · N5453V · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.
- [NTSB GAA15CA189](https://openairdocs.org/ntsb/GAA15CA189.md): Cessna 182Q · Hanksville, UT · Accident · No injuries · Data collection · Final report · Jul 18, 2015 · N735JB · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.
- [NTSB GAA15LA191](https://openairdocs.org/ntsb/GAA15LA191.md): Celier Xenon RST · Livingston, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2015 · N402ED · Substantial damage
  > The pilot’s loss of directional control after aborting the takeoff due to a grinding noise coming from the main rotor area, which resulted in a runway excursion.
- [NTSB GAA15CA143](https://openairdocs.org/ntsb/GAA15CA143.md): Aventura II · Fenton, MI · Accident · No injuries · Data collection · Final report · Jul 17, 2015 · N1204A · Substantial damage
  > The failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.
- [NTSB CEN15LA309](https://openairdocs.org/ntsb/CEN15LA309.md): Cessna 172RG · Anoka, MN · Accident · No injuries · Limited investigation · Final report · Jul 17, 2015 · N6511V · Substantial damage
  > Failure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.
- [NTSB GAA15CA207](https://openairdocs.org/ntsb/GAA15CA207.md): Cessna 170B · Rosamond, CA · Accident · No injuries · Data collection · Final report · Jul 16, 2015 · N8028A · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.
- [NTSB CEN15WA368](https://openairdocs.org/ntsb/CEN15WA368.md): Piper PA-32R-300 · Varberg, Sweden · Accident · Minor injuries · Foreign investigation · Jul 15, 2015 · SE-MCB · Destroyed
  > On July 15, 2015, at 1402 coordinated universal time, a Piper PA-32R-300 airplane, Swedish registration SE-MCB, operated by a private individual, collided with the terrain following a loss of lift on takeoff from the Varberg Airport (ESGV), Varberg, Sweden.…

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

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

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