# NTSB investigations, 2015: 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 1 of 4 · 184 cases

## Latest cases

- [NTSB WPR16WA051](https://openairdocs.org/ntsb/WPR16WA051.md): Beech 200 · New Delhi, India · Accident · 10 fatal · Foreign investigation · Dec 22, 2015 · VT-BSA · Substantial damage
  > The Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB GAA16CA088](https://openairdocs.org/ntsb/GAA16CA088.md): Day William L Minicoupe · Middle River, MD · Accident · No injuries · Data collection · Final report · Dec 20, 2015 · N853WD · Substantial damage
  > The pilot's incorrect installation of the rudder horn and failure to properly inspect the installation, which led to a loss of directional control during takeoff.
- [NTSB WPR16FA035](https://openairdocs.org/ntsb/WPR16FA035.md): Aero Vodochody L 39C · Apple Valley, CA · Accident · 2 fatal · Field investigation · Final report · Dec 6, 2015 · N39AY · Destroyed
  > A total loss of engine power on takeoff, which resulted from a sudden over-temperature condition due to an improperly adjusted fuel control unit and the deteriorated condition of the fuel nozzles.
- [NTSB GAA16CA069](https://openairdocs.org/ntsb/GAA16CA069.md): Piper PA 46-350P · Mammoth, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2015 · N546C · Substantial damage
  > The pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…
- [NTSB DCA16WA049](https://openairdocs.org/ntsb/DCA16WA049.md): Bombardier BD100 1A10 · Le Bourget, France · Incident · No injuries · Foreign investigation · Dec 2, 2015 · OE-HRS · Minor damage
  > The BEA of France has notified the NTSB of an incident involving a Bombardier BD100 1A10 that occurred on December 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB ANC16CA009](https://openairdocs.org/ntsb/ANC16CA009.md): Cessna 172 · Manley Hot Springs, AK · Accident · No injuries · Data collection · Final report · Nov 27, 2015 · N7176A · Substantial damage
  > The pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.
- [NTSB CEN16WA049](https://openairdocs.org/ntsb/CEN16WA049.md): Piper PA31 · Guatemala City, Guatemala · Accident · No injuries · Foreign investigation · Nov 21, 2015 · C6-TAK · Destroyed
  > On November 21, 2015, at 1800 universal coordinated time, a Piper PA-31, C6-TAK, was destroyed on impact with a house following a loss of control during takeoff from La Aurora International Airport, Guatemala City, Guatemala. The airplane was destroyed. The…
- [NTSB GAA16CA054](https://openairdocs.org/ntsb/GAA16CA054.md): Aeronca 7AC · Fowlerville, MI · Accident · No injuries · Data collection · Final report · Nov 17, 2015 · N84157 · Substantial damage
  > The pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.
- [NTSB GAA16CA062](https://openairdocs.org/ntsb/GAA16CA062.md): Consolidated Aeronautics Lake LA-4 · Morganton, NC · Accident · No injuries · Data collection · Final report · Nov 14, 2015 · N1204L · Substantial damage
  > The pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.
- [NTSB GAA16CA050](https://openairdocs.org/ntsb/GAA16CA050.md): Cessna 182Q · Bowstring, MN · Accident · No injuries · Data collection · Final report · Nov 13, 2015 · N717AT · Substantial damage
  > The pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.
- [NTSB CEN16FA034](https://openairdocs.org/ntsb/CEN16FA034.md): Cirrus Design SR22 · Colorado Springs, CO · Accident · 2 fatal · Field investigation · Final report · Nov 9, 2015 · N752C · Destroyed
  > The pilot's loss of airplane control during the turn back to the airport after takeoff in high density altitude conditions, which resulted in an inadvertent aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's impaired…
- [NTSB ERA16CA060](https://openairdocs.org/ntsb/ERA16CA060.md): Eurocopter Deutschland EC 135 · Monongahela, PA · Accident · No injuries · Data collection · Final report · Nov 6, 2015 · N639ME · Substantial damage
  > The inadequate securing of the wheeled fire extinguisher's cover which resulted in it being blown off of the fire extinguisher and ingested into the helicopter's fenestron during takeoff, resulting in a loss of directional control.
- [NTSB GAA16CA045](https://openairdocs.org/ntsb/GAA16CA045.md): Schweizer 269C 1 · Mount Pocono, PA · Accident · No injuries · Data collection · Final report · Nov 4, 2015 · N21496 · Substantial damage
  > The student pilot's failure to remove the tension applied to the cyclic before takeoff, which resulted in a loss of directional control and the tail rotor striking the ground.
- [NTSB GAA16CA043](https://openairdocs.org/ntsb/GAA16CA043.md): Cessna 182 · Douglas Bisbee, AZ · Accident · No injuries · Data collection · Final report · Nov 2, 2015 · N1706R · Substantial damage
  > The student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.
- [NTSB DCA16WA017](https://openairdocs.org/ntsb/DCA16WA017.md): Mcdonnell Douglas DC 9 82(MD-82) · San Luis Potosi, Mexico · Incident · No injuries · Foreign investigation · Nov 2, 2015 · N73444 · Minor damage
  > The Dirección General de Aeronáutica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a McDonnell Douglas DC-9-82, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…
- [NTSB GAA16LA032](https://openairdocs.org/ntsb/GAA16LA032.md): Philip D Anderson 601 · Hemet, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 2015 · N467SD · Substantial damage
  > The pilot's failure to maintain the airplane's descent rate during a precautionary landing, which resulted in hard landing. Contributing to the accident was the pilot's failure to secure the canopy before takeoff, which precipitated the precautionary landing.
- [NTSB ERA16WA049](https://openairdocs.org/ntsb/ERA16WA049.md): Robinson R44 · Guarani Municipality, Brazil · Accident · 1 fatal · Foreign investigation · Oct 25, 2015 · PP-BAO · Substantial damage
  > On October 25, 2015, at 1730 local time (1930 coordinated universal time), a Robinson R44, Brazilian registration PP-BAO, was substantially damaged when it impacted trees and a lake after takeoff in the Guarani Municipality, State of Minas Gerais, Brazil. The…
- [NTSB CEN16LA022](https://openairdocs.org/ntsb/CEN16LA022.md): Delwyn Schmidt No model · Bennington, KS · Accident · 1 fatal · Limited investigation · Final report · Oct 25, 2015 · UNREG · Substantial damage
  > The unregistered airplane’s loss of engine power due to piston seizure. Contributing to the accident was the pilot’s loss of airplane control while maneuvering back to the runway.
- [NTSB WPR16LA018](https://openairdocs.org/ntsb/WPR16LA018.md): Cessna 120 · Lone Pine, CA · Accident · No injuries · Limited investigation · Final report · Oct 24, 2015 · N3124N · Substantial damage
  > The fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.
- [NTSB GAA16CA035](https://openairdocs.org/ntsb/GAA16CA035.md): Brandon Evans Gyroplane · Buckeye, AZ · Accident · No injuries · Data collection · Final report · Oct 24, 2015 · N166BE · Substantial damage
  > The student pilot's incorrect control input during takeoff which resulted in a runaway excursion and impact with terrain.
- [NTSB GAA16CA071](https://openairdocs.org/ntsb/GAA16CA071.md): Bell 206 · Christmas Island, Kiribati · Accident · No injuries · Data collection · Final report · Oct 20, 2015 · N1060C · Substantial damage
  > The pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.
- [NTSB ERA16WA020](https://openairdocs.org/ntsb/ERA16WA020.md): Learjet 35A · Buenos Aires, Argentina · Accident · No injuries · Foreign investigation · Oct 19, 2015 · LV-ZSZ · Destroyed
- [NTSB ERA16LA019](https://openairdocs.org/ntsb/ERA16LA019.md): Beech 23 · Humboldt, TN · Accident · No injuries · Limited investigation · Final report · Oct 18, 2015 · N2339J · Substantial damage
  > A partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.
- [NTSB ERA16LA058](https://openairdocs.org/ntsb/ERA16LA058.md): Cessna R182 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Oct 17, 2015 · N381MB · Substantial damage
  > A collapse of the nose landing gear due to a separation of the drag attachment fitting from the airframe. The separation was likely due to preexisting damage from an undetermined event.
- [NTSB GAA16CA021](https://openairdocs.org/ntsb/GAA16CA021.md): Piper PA 18-150 · Old Harbor, AK · Accident · No injuries · Data collection · Final report · Oct 16, 2015 · N4336Z · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, resulting in a collision with terrain.
- [NTSB ANC16WA004](https://openairdocs.org/ntsb/ANC16WA004.md): Cessna 207 · Taylor, Canada · Accident · 2 fatal · Foreign investigation · Oct 16, 2015 · C-GNVZ
  > On October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…
- [NTSB WPR16LA011](https://openairdocs.org/ntsb/WPR16LA011.md): Christopher Tom Kitfox 5 · Battle Ground, WA · Accident · No injuries · Limited investigation · Final report · Oct 14, 2015 · N533RC · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN16LA019](https://openairdocs.org/ntsb/CEN16LA019.md): Quest Kodiak 100 · Sheridan, WY · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2015 · N153RW · Substantial damage
  > The loss of airplane control during takeoff for reasons that could not be determined based on the available information.
- [NTSB WPR16LA005](https://openairdocs.org/ntsb/WPR16LA005.md): Piper PA28 · Compton, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 2015 · N7506W · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA16WA017](https://openairdocs.org/ntsb/ERA16WA017.md): Embraer EMB721C · Corumba, Brazil · Accident · 1 fatal · Foreign investigation · Oct 6, 2015 · PT-RAM · Substantial damage
  > On October 6, 2015, about 1200 universal coordinated time, an Embraer EMB721C, Brazilian registration PT-RAM, was substantially damaged when it encountered a wind gust and struck a tree, during takeoff from Guanabara Farm, Corumba, Brazil. The pilot and one…
- [NTSB GAA16CA006](https://openairdocs.org/ntsb/GAA16CA006.md): Robinson Helicopter R44 II · Devine, TX · Accident · No injuries · Data collection · Final report · Oct 5, 2015 · N174CD · Substantial damage
  > The pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.
- [NTSB CEN16LA006](https://openairdocs.org/ntsb/CEN16LA006.md): Robinson Helicopter R44 · Parkston, SD · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2015 · N442RP · Substantial damage
  > The pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.
- [NTSB ERA16WA002](https://openairdocs.org/ntsb/ERA16WA002.md): Piper PA-31-325 · Chia, Colombia · Accident · 2 fatal · Foreign investigation · Oct 3, 2015 · HK3909G · Destroyed
  > On October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…
- [NTSB GAA15CA295](https://openairdocs.org/ntsb/GAA15CA295.md): Beech V35B · Houston, TX · Accident · No injuries · Data collection · Final report · Sep 30, 2015 · N800JT · Substantial damage
  > The pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.
- [NTSB DCA15WA204](https://openairdocs.org/ntsb/DCA15WA204.md): De Havilland DHC8 · Saarbrucken, Germany · Accident · No injuries · Foreign investigation · Sep 30, 2015 · LX-LGH · Substantial damage
  > The government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…
- [NTSB GAA15CA293](https://openairdocs.org/ntsb/GAA15CA293.md): Cubcrafters CC11-160 · Lake City, CO · Accident · No injuries · Data collection · Final report · Sep 29, 2015 · N319PT · Substantial damage
  > The pilot's loss of directional control during the takeoff, which resulted in a collision with a parked airplane and impact with terrain.
- [NTSB GAA15CA292](https://openairdocs.org/ntsb/GAA15CA292.md): Cubcrafters CC11-160 · Lake City, CO · Accident · No injuries · Data collection · Final report · Sep 29, 2015 · N4HW · Substantial damage
  > The pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.
- [NTSB CEN15WA449](https://openairdocs.org/ntsb/CEN15WA449.md): Trendak Tercel · Odorheiul Secuiesc City, Romania · Accident · 1 fatal · Foreign investigation · Sep 26, 2015 · A11-DUN · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. On September 26, 2015, at an unknown time, a Trendak Tercel gyroplane, A11-DUN, impacted terrain after takeoff from an airfield near Odorheiul Secuiesc city, Harghita County, Romania.…
- [NTSB GAA15CA278](https://openairdocs.org/ntsb/GAA15CA278.md): Cessna 182A · Ama, LA · Accident · No injuries · Data collection · Final report · Sep 25, 2015 · N6361B · Substantial damage
  > The pilot's decision to takeoff on a partially obstructed runway, which resulted in a collision with trees.
- [NTSB GAA15CA282](https://openairdocs.org/ntsb/GAA15CA282.md): Cessna 170B · Arctic Village, AK · Accident · Minor injuries · Data collection · Final report · Sep 24, 2015 · N2528C · Substantial damage
  > The pilot exceeded the critical angle of attack during takeoff, which resulted in an aerodynamic stall and a collision with terrain.
- [NTSB GAA15LA284](https://openairdocs.org/ntsb/GAA15LA284.md): Champion 7ECA · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 2015 · N9132L · Substantial damage
  > The pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight and his decision to continue the flight despite signs of an engine problem, which resulted in a total loss of engine power due to fuel…
- [NTSB CEN15LA418](https://openairdocs.org/ntsb/CEN15LA418.md): Cessna 421B · Platteville, WI · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2015 · N813CA · Substantial damage
  > The partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.
- [NTSB GAA15CA277](https://openairdocs.org/ntsb/GAA15CA277.md): Mooney M20M · Manville, NJ · Accident · No injuries · Data collection · Final report · Sep 19, 2015 · N763RC · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a fence.
- [NTSB GAA15CA272](https://openairdocs.org/ntsb/GAA15CA272.md): Diamond Aircraft Ind DA 20 C1 · Sanford, NC · Accident · No injuries · Data collection · Final report · Sep 19, 2015 · N635DC · Substantial damage
  > The student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.
- [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.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?year=2015&page=2

## 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 year(c."eventDate") = 2015
  AND 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?year=2015

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