# NTSB investigations, 2015: Enroute

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 6 · 295 cases

## Latest cases

- [NTSB DCA16WA040](https://openairdocs.org/ntsb/DCA16WA040.md): Boeing 777-333ER · Calgary, Canada · Incident · No injuries · Foreign investigation · Dec 31, 2015 · C-FRAM · No damage
  > The NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…
- [NTSB CEN16LA079](https://openairdocs.org/ntsb/CEN16LA079.md): Piper 28-140 · Republic, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2015 · N4643R · Destroyed
  > The pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.
- [NTSB CEN16LA069](https://openairdocs.org/ntsb/CEN16LA069.md): Cirrus Design SR22 · Watertown, WI · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2015 · N5PF · Substantial damage
  > The pilot’s improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to switch fuel tanks after the engine lost power, and his delayed decision to activate…
- [NTSB DCA16WA048](https://openairdocs.org/ntsb/DCA16WA048.md): Boeing 737 · Gwangju-Si, South Korea · Incident · No injuries · Foreign investigation · Dec 23, 2015 · HL8049 · No damage
  > The government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…
- [NTSB CEN16LA082](https://openairdocs.org/ntsb/CEN16LA082.md): Beech V35B · Tahlequah, OK · Accident · No injuries · Limited investigation · Final report · Dec 23, 2015 · N4523A · Substantial damage
  > A partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.
- [NTSB GAA16CA099](https://openairdocs.org/ntsb/GAA16CA099.md): Davis Michael J MD Special · Wallace, NC · Accident · No injuries · Data collection · Final report · Dec 21, 2015 · N141MD · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion.
- [NTSB DCA16WA037](https://openairdocs.org/ntsb/DCA16WA037.md): Boeing 787 · Darwin, Australia · Incident · No injuries · Foreign investigation · Dec 21, 2015 · VH-VKE · No damage
  > The government of Australia has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on December 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…
- [NTSB ERA16FA075](https://openairdocs.org/ntsb/ERA16FA075.md): Beech C24R · Winder, GA · Accident · 1 fatal · Field investigation · Final report · Dec 20, 2015 · N2074P · Destroyed
  > A total loss of engine power for reasons that could not be determined because the examination of the wreckage did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB WPR16FA041](https://openairdocs.org/ntsb/WPR16FA041.md): Piper PA 32RT-300T · Bakersfield, CA · Accident · 5 fatal · Field investigation · Final report · Dec 19, 2015 · N36402 · Destroyed
  > The noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…
- [NTSB ERA16LA076](https://openairdocs.org/ntsb/ERA16LA076.md): Porrata Luis G Rans S 12XL · Guanica, PR · Accident · No injuries · Limited investigation · Final report · Dec 19, 2015 · N124LP · Substantial damage
  > The pilot/owner's failure to maintain the engine in accordance with manufacturer guidance, which resulted in the undetected corrosion of the power takeoff bearing, subsequent bearing failure, and a total loss of engine power.
- [NTSB ERA16FA074](https://openairdocs.org/ntsb/ERA16FA074.md): Hinton Paul M RV 4 · Greenville, FL · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2015 · N77BP · Destroyed
  > The pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…
- [NTSB DCA16WA236](https://openairdocs.org/ntsb/DCA16WA236.md): Cessna 182 · Plettenberg, Western Cape Province, South Africa · Accident · No injuries · Foreign investigation · Dec 16, 2015 · ZS-SLS · Destroyed
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…
- [NTSB ERA16LA071](https://openairdocs.org/ntsb/ERA16LA071.md): Piper PA-32 · Brunswick, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 2015 · N8675N · Substantial damage
  > Maintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder.
- [NTSB ERA16WA069](https://openairdocs.org/ntsb/ERA16WA069.md): Hawker Beech A36TC · Suvorovskaya, Russia · Accident · 4 fatal · Foreign investigation · Dec 13, 2015 · RA-2587G · Destroyed
  > On December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,…
- [NTSB ERA16LA066](https://openairdocs.org/ntsb/ERA16LA066.md): Raytheon A36 · Fayetteville, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2015 · N3241N · Substantial damage
  > Maintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…
- [NTSB DCA16CA050](https://openairdocs.org/ntsb/DCA16CA050.md): Boeing 777 223 · Buenos Aires, Argentina · Accident · Serious injuries · Data collection · Final report · Dec 12, 2015 · N784AN · No damage
  > an inadvertant encounter with convective turbulence.
- [NTSB WPR16FA037](https://openairdocs.org/ntsb/WPR16FA037.md): Bell 407 · McFarland, CA · Accident · 4 fatal · Field investigation · Final report · Dec 11, 2015 · N408FC · Destroyed
  > The pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…
- [NTSB ENG16WA006](https://openairdocs.org/ntsb/ENG16WA006.md): Airbus A319 · Bogota, Colombia · Incident · No injuries · Foreign investigation · Dec 11, 2015 · N593FL · No damage
  > On December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the…
- [NTSB DCA16CA030](https://openairdocs.org/ntsb/DCA16CA030.md): Airbus A319 115 · Great Falls, MT · Accident · Serious injuries · Data collection · Final report · Dec 10, 2015 · N3014R · No damage
  > an encounter with turbulence during initial descent.
- [NTSB CEN16WA065](https://openairdocs.org/ntsb/CEN16WA065.md): Enstrom 280 · Salinas Victoria, Mexico · Accident · No injuries · Foreign investigation · Dec 10, 2015 · XB-GRG · Substantial damage
  > On December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.…
- [NTSB WPR16IA044](https://openairdocs.org/ntsb/WPR16IA044.md): Cessna LC41-550FG · Seal Beach, CA · Incident · No injuries · Incident investigation · Final report · Dec 8, 2015 · N932AC · Minor damage
  > Improper maintenance performed on the left magneto which led to a loss of engine power. Contributing to the incident was the pilot's failure to check the magnetos in flight in compliance with manufacturers guidance regarding rough running engine. The pilot's…
- [NTSB DCA16WA031](https://openairdocs.org/ntsb/DCA16WA031.md): Eclipse 500 · Swellendam, South Africa · Accident · 1 fatal · Foreign investigation · Dec 7, 2015 · ZS-DKS · Destroyed
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…
- [NTSB DCA16CA026](https://openairdocs.org/ntsb/DCA16CA026.md): Boeing 737 7H4 · St Louis, MO · Accident · Serious injuries · Data collection · Final report · Nov 29, 2015 · N467WN · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB GAA16CA072](https://openairdocs.org/ntsb/GAA16CA072.md): Skaggs Ronnie Lynn Rans S6S · Oldtown, MD · Accident · No injuries · Data collection · Final report · Nov 27, 2015 · N531VS · Substantial damage
  > The pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain.
- [NTSB WPR16LA032](https://openairdocs.org/ntsb/WPR16LA032.md): Hughes 369D · Carlisle, WA · Accident · No injuries · Limited investigation · Final report · Nov 24, 2015 · N50713 · Substantial damage
  > A total loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge.
- [NTSB DCA16CA023](https://openairdocs.org/ntsb/DCA16CA023.md): Airbus Industrie A319 112 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · Nov 23, 2015 · N725UW · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB CEN16WA048](https://openairdocs.org/ntsb/CEN16WA048.md): Bell 407 · Justo Romero, Nicaragua · Accident · No injuries · Foreign investigation · Nov 21, 2015 · HR-AWI · Substantial damage
  > On November 21, 2015, at 1000 central standard time (cst), a Bell model 407 helicopter, Honduran registration HR-AWI, serial number 53978, sustained substantial damage during a forced landing following a total loss of engine power near Justo Romero,…
- [NTSB CEN16LA047](https://openairdocs.org/ntsb/CEN16LA047.md): Eurocopter EC120B · Goshen, IN · Accident · No injuries · Limited investigation · Final report · Nov 16, 2015 · N88HA · Substantial damage
  > The failure of the Thomas coupling at the interface with the main gear box tail rotor output shaft, which resulted in the helicopter's loss of tail rotor control.
- [NTSB CEN16FA042](https://openairdocs.org/ntsb/CEN16FA042.md): Cessna 182G · Sandia Park, NM · Accident · 3 fatal · Field investigation · Final report · Nov 16, 2015 · N2440R · Destroyed
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB CEN16WA046](https://openairdocs.org/ntsb/CEN16WA046.md): Cessna 172N · Gorliz, Spain · Accident · Serious injuries · Foreign investigation · Nov 14, 2015 · EC-HKH · Substantial damage
  > On November 14, 2015, at 1157 UTC, a Cessna 172, Spanish registration EC-HKH, collided with the water in the Astondo Bay off the coast of Gorliz, Spain, following a loss of engine power. The pilot and one passenger received minor injuries and a second…
- [NTSB ERA16LA040](https://openairdocs.org/ntsb/ERA16LA040.md): Cirrus Design SR22 · Jefferson, NC · Accident · No injuries · Limited investigation · Final report · Nov 13, 2015 · N334CM · Substantial damage
  > A total loss of engine power for reasons that could not be determined during a postaccident test run of the engine.
- [NTSB CEN16FA037](https://openairdocs.org/ntsb/CEN16FA037.md): Cessna 182Q · Richmond, MO · Accident · 1 fatal · Field investigation · Final report · Nov 11, 2015 · N96381 · Substantial damage
  > The airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…
- [NTSB ERA16WA037](https://openairdocs.org/ntsb/ERA16WA037.md): Cessna 650 · Guarda-Mor, Brazil · Accident · 4 fatal · Foreign investigation · Nov 10, 2015 · PT-WQH · Destroyed
  > On November 10, 2015, at 2030 Universal Coordinated Time (UTC), a Cessna 650 Citation VII, Brazilian registration PT-WQH, operated by a private owner, was destroyed following an in-flight loss of control and collision with terrain near Guarda-mor…
- [NTSB DCA16CA021](https://openairdocs.org/ntsb/DCA16CA021.md): Boeing 787 · Beaumont, TX · Accident · Serious injuries · Data collection · Final report · Nov 7, 2015 · N27958 · No damage
  > An inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.
- [NTSB GAA16CA078](https://openairdocs.org/ntsb/GAA16CA078.md): Cessna 525 · Monroeville, AL · Accident · No injuries · Data collection · Final report · Nov 6, 2015 · N525DY · Substantial damage
  > An inadvertent collision with a bird during takeoff enroute climb, which resulted in substantial damage to the right wing.
- [NTSB ERA16FA033](https://openairdocs.org/ntsb/ERA16FA033.md): Zenith CH701 · Okeechobee, FL · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2015 · N56553 · Destroyed
  > An in-flight structural failure due to a severely corroded wing strut, which resulted in a loss of airplane control.
- [NTSB ERA16FA032](https://openairdocs.org/ntsb/ERA16FA032.md): Piper PA 28-180 · Cornelia, GA · Accident · 3 fatal · Field investigation · Final report · Nov 5, 2015 · N57WV · Destroyed
  > The pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.
- [NTSB ANC16LA005](https://openairdocs.org/ntsb/ANC16LA005.md): Cessna 180 · Haines, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2015 · N4611U · Substantial damage
  > A loss of engine power due to fuel exhaustion for reasons that could not be determined based on available evidence and the pilot’s decision to continue the flight after realizing the remaining fuel quantity was near 0.
- [NTSB CEN16LA026](https://openairdocs.org/ntsb/CEN16LA026.md): Cirrus Design SR22T · Fayetteville, AR · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2015 · N857SW · Substantial damage
  > The fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power.
- [NTSB DCA16WA015](https://openairdocs.org/ntsb/DCA16WA015.md): Airbus A321 · Sinai Peninsula, Egypt · Accident · 224 fatal · Foreign investigation · Oct 31, 2015 · EI-ETJ · Destroyed
  > The Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…
- [NTSB ERA16LA030](https://openairdocs.org/ntsb/ERA16LA030.md): Hughes 369D · Marion, SC · Accident · No injuries · Limited investigation · Final report · Oct 30, 2015 · N920JP · Substantial damage
  > A momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control.
- [NTSB ANC16WA002](https://openairdocs.org/ntsb/ANC16WA002.md): Bell 206B · Asquinth, Canada · Accident · 1 fatal · Foreign investigation · Oct 28, 2015 · C-GIFY
  > On October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…
- [NTSB ERA16LA028](https://openairdocs.org/ntsb/ERA16LA028.md): Schumacher Lancair Super ES · Pascagoula, MS · Accident · 3 fatal · Limited investigation · Final report · Oct 26, 2015 · N817PR · Destroyed
  > The pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather.
- [NTSB ERA16LA027](https://openairdocs.org/ntsb/ERA16LA027.md): Cessna 150M · Key Biscayne, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 2015 · N171RD · Substantial damage
  > The fatigue failure of the No. 1 cylinder intake valve, which resulted in the partial loss of engine power.
- [NTSB DCA16CA010](https://openairdocs.org/ntsb/DCA16CA010.md): Boeing 737-924ER · Plevna, KS · Accident · Serious injuries · Data collection · Final report · Oct 24, 2015 · N69838 · No damage
  > An inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.
- [NTSB ERA16LA022](https://openairdocs.org/ntsb/ERA16LA022.md): Piper PA-32-260 · Bluemont, VA · Accident · No injuries · Limited investigation · Final report · Oct 23, 2015 · N43249 · Substantial damage
  > A total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.
- [NTSB CEN16WA020](https://openairdocs.org/ntsb/CEN16WA020.md): Learjet 31 · La Tinaja, Mexico · Accident · 4 fatal · Foreign investigation · Oct 22, 2015 · XB-GYB · Destroyed
  > The Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…
- [NTSB ERA16LA018](https://openairdocs.org/ntsb/ERA16LA018.md): Cessna 172 · Campobello, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2015 · N6636A · Substantial damage
  > The pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.
- [NTSB WPR16FA014](https://openairdocs.org/ntsb/WPR16FA014.md): Piper PA 28R-180 · Morongo Valley, CA · Accident · 2 fatal · Field investigation · Final report · Oct 17, 2015 · N4972J · Destroyed
  > The non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and…
- [NTSB WPR16FA013](https://openairdocs.org/ntsb/WPR16FA013.md): Aviat A-1C-200 · Swan Valley, ID · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2015 · N280TB · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering in high density altitude conditions over mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.