# NTSB investigations, 2014: 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 · 258 cases

## Latest cases

- [NTSB WPR15TA071](https://openairdocs.org/ntsb/WPR15TA071.md): MD Helicopter 369FF · Las Vegas, NV · Accident · Serious injuries · Final report · Dec 31, 2014 · N530KK · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN15FA092](https://openairdocs.org/ntsb/CEN15FA092.md): Piper PA 28-181 · Vaughn, NM · Accident · 2 fatal · Field investigation · Final report · Dec 30, 2014 · N2558M · Substantial damage
  > The noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.
- [NTSB DCA15WA046](https://openairdocs.org/ntsb/DCA15WA046.md): Airbus A320 - 216 · Pangkalan Bun, Indonesia · Accident · 162 fatal · Foreign investigation · Dec 28, 2014 · PK-AXC · Destroyed
  > The National Transportation Safety Committee (NTSC) of Indonesia, has notified the NTSB of an accident involving an Airbus A320-216 that occurred on December 28, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…
- [NTSB ENG15WA019](https://openairdocs.org/ntsb/ENG15WA019.md): Airbus A330 - 201 · Athens, Greece, Greece · Incident · No injuries · Foreign investigation · Dec 26, 2014 · F-GRSQ · No damage
  > On 12/26/2014 an Airbus A330 operated by XL Airways took off from La Réunion (Indian Ocean) to Marseille (France). The information provided by the three inertial reference systems became successively unavailable, leading autopilot + auto-thrust to disconnect,…
- [NTSB ERA15WA082](https://openairdocs.org/ntsb/ERA15WA082.md): Cessna T207 - A · Piedecuesta, Colombia · Accident · 7 fatal · Foreign investigation · Dec 24, 2014 · HK4892 · Destroyed
  > On December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…
- [NTSB CEN15WA096](https://openairdocs.org/ntsb/CEN15WA096.md): Piper PA-32-260 · Lorrha, Tipperary, Ireland, Ireland · Accident · No injuries · Foreign investigation · Dec 24, 2014 · G-OCTI · Substantial damage
  > On December 24, 2014, at 1410 universal coordinated time (UTC), a Piper PA-32-260, United Kingdom registration G-OCTI, sustained substantial damage during an forced landing near Lorrha, Tipperary, Ireland, after experiencing an engine failure. There were no…
- [NTSB ERA15LA091](https://openairdocs.org/ntsb/ERA15LA091.md): Cessna 172M · South Bimini, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2014 · N12182 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.
- [NTSB ENG15RA010](https://openairdocs.org/ntsb/ENG15RA010.md): Bombardier DHC-8-402 · Belfast, N Ireland, United Kingdom · Incident · No injuries · Foreign investigation · Dec 16, 2014 · G-FLBC
  > On December 16, 2014, about 1839 UTC, a DeHavilland DHC-8-400Q, powered by two Pratt & Whitney Canada (PWC) PW150A turboprop engines, experienced an engine casing burn-through and in-flight shutdown near Belfast International Airport. Belfast, N. Ireland.…
- [NTSB DCA15WA041](https://openairdocs.org/ntsb/DCA15WA041.md): Boeing 777 223 · Ishikawa, Japan · Accident · Serious injuries · Foreign investigation · Dec 16, 2014 · N751AN · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…
- [NTSB CEN15WA108](https://openairdocs.org/ntsb/CEN15WA108.md): Airbus Helicopter EC135T2+ · Lake Siutghiol, Romania · Accident · 4 fatal · Foreign investigation · Dec 15, 2014 · N348 · Substantial damage
  > On December 14, 2014, about 1615 local time, an Airbus Helicopter EC135T2+ helicopter, Romanian registration number 348, impacted Lake Siutghiol, Romania. The four occupants, flight and medical crew, were all fatally injured. The helicopter sustained…
- [NTSB ERA15LA077](https://openairdocs.org/ntsb/ERA15LA077.md): Thomas R Wade Revelation · Ellisville, MS · Accident · No injuries · Limited investigation · Final report · Dec 13, 2014 · N783QJ · Substantial damage
  > The failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…
- [NTSB DCA15CA050](https://openairdocs.org/ntsb/DCA15CA050.md): Boeing 737 7H4 · San Jose, CA · Accident · Serious injuries · Data collection · Final report · Dec 11, 2014 · N481WN · No damage
  > an inadvertent encounter with convective turbulence during descent.
- [NTSB ENG15WA005](https://openairdocs.org/ntsb/ENG15WA005.md): Boeing 757 - 236 · Magadan, Russia · Incident · No injuries · Foreign investigation · Dec 6, 2014 · VQ-BPY
  > On December 6, 2014, at approximately 10:30 UTC, a Yakutia Airlines Boeing 757-236PCF, registration VQ-BPY experienced a decompression and cargo door opening approximately 4 minutes after takeoff from Magadan, Russian Federation. The Department for Inspection…
- [NTSB ERA15LA072](https://openairdocs.org/ntsb/ERA15LA072.md): Cessna 150J · Brookline, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2014 · N50709 · Substantial damage
  > The student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.
- [NTSB CEN15CA067](https://openairdocs.org/ntsb/CEN15CA067.md): Cessna 210 · Edinburg, TX · Accident · No injuries · Data collection · Final report · Dec 2, 2014 · N9452T · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.
- [NTSB ERA15LA063](https://openairdocs.org/ntsb/ERA15LA063.md): Cessna 182 · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Nov 29, 2014 · N759VG · Substantial damage
  > The partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.
- [NTSB ERA15LA062](https://openairdocs.org/ntsb/ERA15LA062.md): Cirrus Design SR22T · Hampton, SC · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2014 · N227RR · Substantial damage
  > The pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…
- [NTSB DCA15CA035](https://openairdocs.org/ntsb/DCA15CA035.md): Boeing 737 824 · Valdosta, GA · Accident · Serious injuries · Data collection · Final report · Nov 24, 2014 · N16217 · No damage
  > an inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.
- [NTSB CEN15FA056](https://openairdocs.org/ntsb/CEN15FA056.md): Aero Commander 500A · McDade, TX · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2014 · N14AV · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…
- [NTSB CEN15CA055](https://openairdocs.org/ntsb/CEN15CA055.md): Piper PA 28-181 · Strasburg, CO · Accident · Minor injuries · Data collection · Final report · Nov 21, 2014 · N2204Q · Substantial damage
  > The exhaustion of the fuel supply resulting in a complete loss of engine power.
- [NTSB ERA15LA053](https://openairdocs.org/ntsb/ERA15LA053.md): Beech F33A · Clinton, CT · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 2014 · N4548S · Substantial damage
  > The pilot's inadequate fuel planning and improper 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 follow proper procedures in response to the loss of engine power.
- [NTSB CEN15FA044](https://openairdocs.org/ntsb/CEN15FA044.md): Mooney M20K · Clines Corners, NM · Accident · 1 fatal · Field investigation · Final report · Nov 13, 2014 · N231JF · Destroyed
  > The noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…
- [NTSB ERA15FA046](https://openairdocs.org/ntsb/ERA15FA046.md): Cessna 172 · Hinton, VA · Accident · 1 fatal · Field investigation · Final report · Nov 8, 2014 · N2152T · Substantial damage
  > The flight instructor’s decision to conduct a night training flight in mountainous terrain without conducting or allowing the student to conduct appropriate preflight planning and his lack of situational awareness of the surrounding terrain altitude, which…
- [NTSB ERA15CA048](https://openairdocs.org/ntsb/ERA15CA048.md): Cessna 177 · Landrum, SC · Accident · No injuries · Data collection · Final report · Nov 8, 2014 · N3339T · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN15FA040](https://openairdocs.org/ntsb/CEN15FA040.md): Cirrus Design SR22 · Grover Hill, OH · Accident · 3 fatal · Field investigation · Final report · Nov 6, 2014 · N811CD · Destroyed
  > The airplane's encounter with supercooled large droplet (SLD) icing, which resulted in a loss of lift and a subsequent uncontrolled descent into terrain. Also causal was the pilot's preflight and in-flight decision to fly in known icing conditions in an…
- [NTSB WPR15CA033](https://openairdocs.org/ntsb/WPR15CA033.md): Beech A35 · Havasu City, AZ · Accident · No injuries · Data collection · Final report · Nov 5, 2014 · N149DS · Substantial damage
  > Loss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.
- [NTSB WPR15LA032](https://openairdocs.org/ntsb/WPR15LA032.md): Cessna T210M · Jacksonville, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2014 · N1593M · Substantial damage
  > A loss of engine power during cruise flight due to the failure of the No. 6 connecting rod, which resulted from oil starvation.
- [NTSB CEN15CA039](https://openairdocs.org/ntsb/CEN15CA039.md): Robinson Helicopter R66 · Baton Rouge, LA · Accident · No injuries · Data collection · Final report · Oct 29, 2014 · N67GA · Substantial damage
  > An in-flight bird strike.
- [NTSB CEN15CA041](https://openairdocs.org/ntsb/CEN15CA041.md): Cessna 510 · Faribault, MN · Accident · No injuries · Data collection · Final report · Oct 27, 2014 · N510PT · Substantial damage
  > An inflight collision with a goose while descending to land at the destination airport.
- [NTSB CEN15LA028](https://openairdocs.org/ntsb/CEN15LA028.md): Huebbe Sonex HB · Plainview, IL · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 2014 · N244HB · Substantial damage
  > The loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.
- [NTSB CEN15CA033](https://openairdocs.org/ntsb/CEN15CA033.md): Piper PA-23-250 · Quincy, IL · Accident · No injuries · Data collection · Final report · Oct 26, 2014 · N62791 · Substantial damage
  > The pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…
- [NTSB CEN15LA038](https://openairdocs.org/ntsb/CEN15LA038.md): Stol UC 1 · Jacksonville, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 2014 · N950TB · Substantial damage
  > The loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.
- [NTSB WPR15LA020](https://openairdocs.org/ntsb/WPR15LA020.md): Winston W Walker Thunder Mustang · Globe, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2014 · N244SW · Substantial damage
  > The separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…
- [NTSB DCA15WA091](https://openairdocs.org/ntsb/DCA15WA091.md): North American NA 265-80 · Panama Pacifico, Panama · Incident · No injuries · Foreign investigation · Oct 24, 2014 · N100EJ · No damage
  > The Civil Aeronautical Authority of Panama (AAC) has notified the NTSB of an incident involving a North American NA 265-80 that occurred on October 24, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAC investigation under the…
- [NTSB CEN15FA027](https://openairdocs.org/ntsb/CEN15FA027.md): Cessna T210M · Bay City, WI · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2014 · N761SU · Destroyed
  > The non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.
- [NTSB CEN15TA035](https://openairdocs.org/ntsb/CEN15TA035.md): Bell UH1H · San Isidro, TX · Accident · No injuries · Final report · Oct 23, 2014 · N72595 · Substantial damage
  > The flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.
- [NTSB ERA15IA024](https://openairdocs.org/ntsb/ERA15IA024.md): Cirrus Design SR22 · Lexington, NC · Incident · No injuries · Incident investigation · Final report · Oct 22, 2014 · N242MB · Minor damage
  > Maintenance personnel's improper tightening of the crankcase through bolt nuts during reassembly of the engine at the last overhaul, which resulted in the failure of the crankshaft and the subsequent total loss of engine power.
- [NTSB DCA15WA013](https://openairdocs.org/ntsb/DCA15WA013.md): Boeing 777 · Dubai, United Arab Emirates · Incident · No injuries · Foreign investigation · Oct 22, 2014 · A6-EMJ · No damage
  > The GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA15LA044](https://openairdocs.org/ntsb/ERA15LA044.md): Itec Maverick · Dunnellon, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2014 · N356MV · Destroyed
  > A cell blowout in the fabric wing, which resulted in an asymmetrical loss of lift and a subsequent loss of aircraft control.
- [NTSB ERA15FA023](https://openairdocs.org/ntsb/ERA15FA023.md): Beech D95 · Bahama, NC · Accident · 1 fatal · Field investigation · Final report · Oct 21, 2014 · N64GM · Substantial damage
  > The pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…
- [NTSB ENG15WA002](https://openairdocs.org/ntsb/ENG15WA002.md): BAE JETSTREAM4100 - 4100 · Medellín, Colombia, Colombia · Incident · No injuries · Foreign investigation · Oct 21, 2014 · HK4503 · No damage
  > On October 21, 2014, at about 2005 universal coordinated time, a BAE Jetstream 41, registration HK-4503, operated by EasyFly S.A., experienced a No. 1 (left) engine stoppage during cruise after departing from Enrique Olaya Herrera Airport (EOH)- Medellin,…
- [NTSB CEN15LA018](https://openairdocs.org/ntsb/CEN15LA018.md): Viguie G/Viguie M Lancair Legacy · Livingston, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 2014 · N550AC · Destroyed
  > A catastrophic and uncontained engine failure due to oil starvation. Contributing to the accident was the missing No. 3 cylinder intake rocker cover for reasons that could not be determined based on the available evidence.
- [NTSB WPR15LA014](https://openairdocs.org/ntsb/WPR15LA014.md): Cessna 172S · Big Bear, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2014 · N612SP · 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.
- [NTSB CEN15LA015](https://openairdocs.org/ntsb/CEN15LA015.md): Cessna P210N · West Memphis, AR · Accident · No injuries · Limited investigation · Final report · Oct 15, 2014 · N731QV · Substantial damage
  > A catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.
- [NTSB CEN15FA009](https://openairdocs.org/ntsb/CEN15FA009.md): Raytheon 58 · Palos Hills, IL · Accident · 3 fatal · Field investigation · Final report · Oct 13, 2014 · N31EW · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.
- [NTSB WPR15FA010](https://openairdocs.org/ntsb/WPR15FA010.md): Cessna 170B · Yerington, NV · Accident · 2 fatal · Field investigation · Final report · Oct 12, 2014 · N3558C · 2 aircraft · Destroyed
  > The failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…
- [NTSB ERA15LA015](https://openairdocs.org/ntsb/ERA15LA015.md): Piper PA-28-151 · Granville, MA · Accident · No injuries · Class 3 · Limited · Final report · Oct 12, 2014 · N57SH · Substantial damage
  > Deformation of the No. 1 cylinder's intake valve, which resulted in a partial loss of engine power and a subsequent off-airport precautionary landing.
- [NTSB ERA15LA014](https://openairdocs.org/ntsb/ERA15LA014.md): Cessna 180K · Boca Raton, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 2014 · N2590K · Substantial damage
  > Maintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1 and 2 main bearings, loss of lubrication, failure of the crankshaft, and a subsequent total loss of engine power.
- [NTSB ANC15WA017](https://openairdocs.org/ntsb/ANC15WA017.md): Cirrus Design SR20 · Ibusuki City, Japan · Accident · Minor injuries · Foreign investigation · Oct 12, 2014 · N176CD · Substantial damage
  > On October 12, 2014, about 0530 coordinated universal time, a US registered Cirrus SR-20 airplane, N176CD, experienced a total loss of engine power near Ibusuki City, Kagoshima Prefecture, Japan. The pilot made a emergency landing, and received minor…
- [NTSB WPR15LA008](https://openairdocs.org/ntsb/WPR15LA008.md): Piper PA 28-180 · Bend, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 2014 · N32150 · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2014&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") = 2014
  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=2014

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