# NTSB investigations, 2014: Initial climb

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 3 · 130 cases

## Latest cases

- [NTSB CEN15FA090](https://openairdocs.org/ntsb/CEN15FA090.md): Cessna 404 · Englewood, CO · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2014 · N404MG · Substantial damage
  > The loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.
- [NTSB ERA15WA098](https://openairdocs.org/ntsb/ERA15WA098.md): Aerospatiale AS350B · Bertioga, Brazil · Accident · 5 fatal · Foreign investigation · Dec 27, 2014 · PT-HNC · Destroyed
  > On December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…
- [NTSB WPR15CA059](https://openairdocs.org/ntsb/WPR15CA059.md): Cessna 182T · Wendover, UT · Accident · Serious injuries · Data collection · Final report · Dec 12, 2014 · N961GW · Substantial damage
  > The pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.
- [NTSB CEN15IA079](https://openairdocs.org/ntsb/CEN15IA079.md): Cessna T182T · Cahokia, IL · Incident · No injuries · Incident investigation · Final report · Dec 12, 2014 · N93CL · No damage
  > The mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.
- [NTSB ERA15LA071](https://openairdocs.org/ntsb/ERA15LA071.md): Cessna 210 5(205) · Sussex, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2014 · N8296Z · Substantial damage
  > Maintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.
- [NTSB WPR15IA046](https://openairdocs.org/ntsb/WPR15IA046.md): Embraer EMB-505 · Palm Springs, CA · Incident · No injuries · Incident investigation · Final report · Nov 23, 2014 · C-GJOL · Minor damage
  > The failure of the gust lock actuator solenoid for reasons that could not be determined because postaccident examination of the rudder gust lock system revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ANC15LA004](https://openairdocs.org/ntsb/ANC15LA004.md): Helio H 295 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Nov 15, 2014 · N6465V · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical anomalies.
- [NTSB CEN15FAMS1](https://openairdocs.org/ntsb/CEN15FAMS1.md): Cessna 172K · Lake Pontchartrain, LA · Accident · 2 fatal · Missing aircraft · Final report · Nov 13, 2014 · N46707 · Destroyed
  > The airplane's collision with water for reasons that could not be determined because the wreckage was not located.
- [NTSB ERA15CA056](https://openairdocs.org/ntsb/ERA15CA056.md): Cessna 172S · Sarasota, FL · Accident · No injuries · Data collection · Final report · Nov 12, 2014 · N60155 · Substantial damage
  > The student pilot's failure to maintain airplane control during the initial climb, resulting in a runway excursion and substantial damage to the engine firewall. The student pilot's lack of overall flying experience was a factor.
- [NTSB ERA15FA049](https://openairdocs.org/ntsb/ERA15FA049.md): Mooney M20C · Lewisburg, WV · Accident · Serious injuries · Field investigation · Final report · Nov 10, 2014 · N6581U · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were abnormal engine operation due to improper…
- [NTSB WPR15LA038](https://openairdocs.org/ntsb/WPR15LA038.md): Cessna 210B · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Nov 8, 2014 · N9578X · Substantial damage
  > The failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.
- [NTSB CEN15FA034](https://openairdocs.org/ntsb/CEN15FA034.md): Raytheon B200 · Wichita, KS · Accident · 4 fatal · Field investigation · Final report · Oct 30, 2014 · N52SZ · Destroyed
  > The pilot's failure to maintain lateral control of the airplane after a reduction in left engine power and his application of inappropriate rudder input. Contributing to the accident was the pilot's failure to follow the emergency procedures for an engine…
- [NTSB DCA15RA018](https://openairdocs.org/ntsb/DCA15RA018.md): Short Bros Shorts SD3 60 · Sint Maartin -Juliana, NT · Accident · 2 fatal · Foreign investigation · Oct 29, 2014 · N380MQ · Destroyed
  > import
- [NTSB ERA15LA028](https://openairdocs.org/ntsb/ERA15LA028.md): Piper PA-28-140 · Valley Point, WV · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2014 · N5601U · Substantial damage
  > Undetermined based on a lack of available information.
- [NTSB ERA15LA029](https://openairdocs.org/ntsb/ERA15LA029.md): Piper PA 22-150 · Tompkins, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 2014 · N8064Y · Substantial damage
  > A total loss of engine power for reasons that could not be determined during postaccident examinations and testing.
- [NTSB ERA15LA030](https://openairdocs.org/ntsb/ERA15LA030.md): North American T 6G · Naples, FL · Accident · No injuries · Limited investigation · Final report · Oct 23, 2014 · N22NA · Substantial damage
  > The total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…
- [NTSB WPR15LA015](https://openairdocs.org/ntsb/WPR15LA015.md): Piper PA28 151 · Bullhead City, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2014 · N56873 · Substantial damage
  > A partial loss of engine power during the initial climb 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 ERA15CA020](https://openairdocs.org/ntsb/ERA15CA020.md): Airborne Windsports PTY Edge XT 912 L · Sebring, FL · Accident · No injuries · Data collection · Final report · Oct 18, 2014 · N29ME · Substantial damage
  > The student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.
- [NTSB ERA15FA017](https://openairdocs.org/ntsb/ERA15FA017.md): Aeronca 7EC · Cordele, GA · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2014 · N946DR · Substantial damage
  > An in-flight loss of control for reasons that could not be determined based on the available evidence.
- [NTSB ERA15FA016](https://openairdocs.org/ntsb/ERA15FA016.md): Rockwell International 112 · Gainesville, GA · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2014 · N1148J · Destroyed
  > The partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.
- [NTSB ENG15IA037](https://openairdocs.org/ntsb/ENG15IA037.md): Boeing 787-8 · London, United Kingdom · Incident · No injuries · Incident investigation · Final report · Oct 10, 2014 · N26906 · Minor damage
  > A shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…
- [NTSB ERA14LA462](https://openairdocs.org/ntsb/ERA14LA462.md): Quicksilver Eipper Acft GT 400 · Lebanon, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2014 · N3740A · Substantial damage
  > The pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.
- [NTSB WPR14FA393](https://openairdocs.org/ntsb/WPR14FA393.md): Tifft Kitfox III · Lake Stevens, WA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2014 · N307KF · Substantial damage
  > The pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…
- [NTSB WPR14FA382](https://openairdocs.org/ntsb/WPR14FA382.md): Piper PA 28R-180 · Saratoga, WY · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2014 · N4618J · Substantial damage
  > The pilot’s failure to maintain a positive climb rate after takeoff in dark, night conditions, which resulted in his controlled flight into terrain due to the lack of ground references or natural horizon.
- [NTSB ENG14IA027](https://openairdocs.org/ntsb/ENG14IA027.md): Boeing 747 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Sep 21, 2014 · N669US · No damage
  > Turbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…
- [NTSB CEN14LA508](https://openairdocs.org/ntsb/CEN14LA508.md): Brupbacher Chris CB2000 · Reserve, LA · Accident · 2 fatal · Limited investigation · Final report · Sep 21, 2014 · N5002E · Destroyed
  > The failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.
- [NTSB ERA14LA450](https://openairdocs.org/ntsb/ERA14LA450.md): Barger Jerry L Challenger II · Clarion, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2014 · N4017C · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…
- [NTSB ENG14IA028](https://openairdocs.org/ntsb/ENG14IA028.md): Airbus A320 232 · Long Beach, CA · Incident · No injuries · Incident investigation · Final report · Sep 18, 2014 · N656JB · Minor damage
  > The probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…
- [NTSB ANC14CA079](https://openairdocs.org/ntsb/ANC14CA079.md): Piper PA 18-135 · Susitna, AK · Accident · No injuries · Data collection · Final report · Sep 13, 2014 · N959E · Substantial damage
  > The pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.
- [NTSB ERA14CA430](https://openairdocs.org/ntsb/ERA14CA430.md): Cessna 172M · Watertown, CT · Accident · Minor injuries · Data collection · Final report · Sep 9, 2014 · N20469 · Substantial damage
  > The pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…
- [NTSB ERA14FA428](https://openairdocs.org/ntsb/ERA14FA428.md): Cessna 172 · Selkirk, NY · Accident · 2 fatal · Field investigation · Final report · Sep 8, 2014 · N79438 · Substantial damage
  > A 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 ERA14LA418](https://openairdocs.org/ntsb/ERA14LA418.md): Lorenz Stephen Kitfox Series 5 · Greene, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2014 · N94SL · Destroyed
  > The pilot’s failure to attain adequate airspeed during the initial climb, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the…
- [NTSB ERA14FA417](https://openairdocs.org/ntsb/ERA14FA417.md): Cessna 180 · North Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Sep 1, 2014 · N6510A · Substantial damage
  > The pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…
- [NTSB ANC14LA071](https://openairdocs.org/ntsb/ANC14LA071.md): Dehavilland DHC 2 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2014 · N93E · Substantial damage
  > The loss of engine power during takeoff due to a malfunction of the engine-driven fuel pump.
- [NTSB ERA14FA416](https://openairdocs.org/ntsb/ERA14FA416.md): Piper PA-25-260 · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2014 · N254AB · Substantial damage
  > The pilot's improper deployment of the banner-tow hook, which resulted in it becoming entangled between the left elevator and horizontal stabilizer, restricted the movement of the elevator, and led to a loss of airplane control.
- [NTSB WPR14LA361](https://openairdocs.org/ntsb/WPR14LA361.md): Travel Air C 4000 · Williams, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2014 · N9952 · Substantial damage
  > The failure of the elevator control tube due to corrosion, which resulted in a loss of elevator control and collision with terrain.
- [NTSB WPR14FA355](https://openairdocs.org/ntsb/WPR14FA355.md): Thomas C Sikes Loehle 5151 Mustang · Chehalis, WA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2014 · N73144 · Destroyed
  > The pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…
- [NTSB CEN14LA456](https://openairdocs.org/ntsb/CEN14LA456.md): Maule MT 7-235 · Edon, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2014 · N627RK · Substantial damage
  > The pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.
- [NTSB ERA14LA404](https://openairdocs.org/ntsb/ERA14LA404.md): Piper PA-28-180 · Gaithersburg, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2014 · N9095J · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.
- [NTSB WPR14CA350](https://openairdocs.org/ntsb/WPR14CA350.md): Schweizer SGS 1 34 · Marana, AZ · Accident · Minor injuries · Data collection · Final report · Aug 19, 2014 · N7628 · Substantial damage
  > The pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.
- [NTSB CEN14LA439](https://openairdocs.org/ntsb/CEN14LA439.md): Air Tractor AT-401 · Wray, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 2014 · N4542W · Substantial damage
  > A loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…
- [NTSB CEN14FA437](https://openairdocs.org/ntsb/CEN14FA437.md): Lancair LC 40 550FG · Ranger, TX · Accident · 3 fatal · Field investigation · Final report · Aug 17, 2014 · N6500Z · Destroyed
  > The pilot's loss of airplane control shortly after takeoff as a result of spatial disorientation due to dark night conditions, the pilot's low overall night and instrument flight time, and his lack of recent night flights.
- [NTSB CEN14FA435](https://openairdocs.org/ntsb/CEN14FA435.md): Cessna 172N · Natchitoches, LA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2014 · N734YW · Substantial damage
  > The partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…
- [NTSB ERA14LA388](https://openairdocs.org/ntsb/ERA14LA388.md): Piper PA-28-161 · Buffalo, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2014 · N706GS · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA14FA387](https://openairdocs.org/ntsb/ERA14FA387.md): Cessna 150 · Mount Pleasant, SC · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2014 · N66241 · Substantial damage
  > The commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…
- [NTSB CEN14LA432](https://openairdocs.org/ntsb/CEN14LA432.md): Cessna 188 - Undesignat · Columbus, NM · Accident · No injuries · Limited investigation · Final report · Aug 13, 2014 · N9849V · Substantial damage
  > The pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…
- [NTSB WPR14LA338](https://openairdocs.org/ntsb/WPR14LA338.md): Nelson RV 3M · North Plains, OR · Accident · No injuries · Class 3 · Limited · Final report · Aug 10, 2014 · N43AZ · Substantial damage
  > A partial loss of engine power for undetermined reasons which resulted in a landing gear collapse during the precautionary landing to a field.
- [NTSB WPR14LA336](https://openairdocs.org/ntsb/WPR14LA336.md): Piper PA 32R-300 · West Jordan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2014 · N4646F · Destroyed
  > A partial loss of engine power during initial climb for reasons that could not be determined due to the severity of the damage to the engine.
- [NTSB WPR14LA335](https://openairdocs.org/ntsb/WPR14LA335.md): Cessna 180A · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Aug 10, 2014 · N7784A · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14CA333](https://openairdocs.org/ntsb/WPR14CA333.md): Kitfox Series 5 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Aug 9, 2014 · N910MK · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.

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

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