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

## Latest cases

- [NTSB WPR16LA043](https://openairdocs.org/ntsb/WPR16LA043.md): Aerostar Acft Corp Of Texas M20F · Nogales, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 26, 2015 · N6811V · Substantial damage
  > The airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.
- [NTSB ERA16LA078](https://openairdocs.org/ntsb/ERA16LA078.md): Piper PA-46 · Corinth, MS · Accident · Serious injuries · Limited investigation · Final report · Dec 24, 2015 · N891CR · Substantial damage
  > The pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA16LA077](https://openairdocs.org/ntsb/ERA16LA077.md): Beech A36 · Myerstown, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2015 · N4314S · Substantial damage
  > The pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.
- [NTSB ANC16LA010](https://openairdocs.org/ntsb/ANC16LA010.md): Robinson Helicopter R44 II · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Dec 16, 2015 · N255VS · Substantial damage
  > The overhaul facility’s improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.
- [NTSB WPR16LA039](https://openairdocs.org/ntsb/WPR16LA039.md): Mooney M20E · Corona, CA · Accident · No injuries · Limited investigation · Final report · Dec 14, 2015 · N5863Q · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s decision to conduct the takeoff with observed engine deficiencies.
- [NTSB ERA16LA068](https://openairdocs.org/ntsb/ERA16LA068.md): Mccorkle Robert B Rans S-12 Airaile · Benton, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 12, 2015 · N6202N · Substantial damage
  > The pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.
- [NTSB ERA16LA065](https://openairdocs.org/ntsb/ERA16LA065.md): Dehavilland Tiger Moth DH 82A · Modena, NY · Accident · No injuries · Class 3 · Limited · Final report · Dec 12, 2015 · N9410 · Substantial damage
  > A partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.
- [NTSB CEN16LA061](https://openairdocs.org/ntsb/CEN16LA061.md): Globe GC 1B · Lake Elmo, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 2015 · N78067 · Substantial damage
  > A loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.
- [NTSB ERA16LA062](https://openairdocs.org/ntsb/ERA16LA062.md): Beech D35 · Vine Grove, KY · Accident · No injuries · Limited investigation · Final report · Dec 4, 2015 · N2991B · Substantial damage
  > The pilot’s failure to ensure that the fuel selector was properly positioned before takeoff, which resulted in the subsequent total loss of engine power due to fuel starvation.
- [NTSB ERA16LA061](https://openairdocs.org/ntsb/ERA16LA061.md): Piper PA-24 · Millville, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2015 · N88F · Substantial damage
  > The total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA16LA053](https://openairdocs.org/ntsb/ERA16LA053.md): Piper PA-32 · Opa Locka, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2015 · N5568J · Substantial damage
  > Maintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.
- [NTSB ERA16LA051](https://openairdocs.org/ntsb/ERA16LA051.md): Piper PA28 · Lawrenceville, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2015 · N3971R · Substantial damage
  > The flight instructor's inadequate fuel management, which resulted in a total loss of engine power during initial climb due to fuel starvation and a subsequent forced landing.
- [NTSB ERA16LA046](https://openairdocs.org/ntsb/ERA16LA046.md): Mooney M20 · Fort Meade, MD · Accident · No injuries · Limited investigation · Final report · Nov 22, 2015 · N5512Q · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16FA043](https://openairdocs.org/ntsb/ERA16FA043.md): Beech A36TC · Orlando, FL · Accident · 2 fatal · Field investigation · Final report · Nov 20, 2015 · N7FG · Destroyed
  > The pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…
- [NTSB WPR16LA031](https://openairdocs.org/ntsb/WPR16LA031.md): Cessna 210 · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 2015 · N9824G · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16WA047](https://openairdocs.org/ntsb/ERA16WA047.md): Cessna 402B · Choco, Colombia · Accident · 2 fatal · Foreign investigation · Nov 17, 2015 · HK4981G · Destroyed
  > On November 17, 2015, about 1550 coordinated universal time, a Cessna 402B, Colombian registration HK4981G, was destroyed when it descended and impacted the ground in a residential area, during takeoff from Acandi Airport (SKAD), Choco, Colombia. The pilot…
- [NTSB ERA16LA041](https://openairdocs.org/ntsb/ERA16LA041.md): Woodrow Larry W Sonex · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Nov 15, 2015 · N7035Z · Substantial damage
  > The pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.
- [NTSB WPR16LA023](https://openairdocs.org/ntsb/WPR16LA023.md): Thorp T 18 · Independence, OR · Accident · No injuries · Limited investigation · Final report · Nov 6, 2015 · N1488 · Substantial damage
  > A separation of the canopy mechanism during flight, which resulted in the pilot’s precautionary landing and the airplane’s subsequent collision with a fence post.
- [NTSB CEN16LA033](https://openairdocs.org/ntsb/CEN16LA033.md): Cessna 120 · Gonzales, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2015 · N2942N · Substantial damage
  > Maintenance personnel’s improper installation of the carburetor during recent maintenance, including the omission of a required cotter pin, which resulted in a total loss of engine power.
- [NTSB GAA16CA067](https://openairdocs.org/ntsb/GAA16CA067.md): Taylorcraft BC12 65 · New Lisbon, WI · Accident · Minor injuries · Data collection · Final report · Nov 2, 2015 · N33939 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.
- [NTSB DCA16WA081](https://openairdocs.org/ntsb/DCA16WA081.md): Gulfstream G1159 · Kinshasa, Congo - Kinshasa · Accident · No injuries · Foreign investigation · Nov 1, 2015 · 9Q-CND · Substantial damage
  > The government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a Gulfstream G1159 airplane that occurred on November 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's…
- [NTSB CEN16LA025](https://openairdocs.org/ntsb/CEN16LA025.md): Champion 7ECA · Sheridan, AR · Accident · No injuries · Limited investigation · Final report · Oct 30, 2015 · N9105L · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB CEN16FA024](https://openairdocs.org/ntsb/CEN16FA024.md): Raytheon A36 · Pottsville, AR · Accident · 4 fatal · Field investigation · Final report · Oct 29, 2015 · N3BE · Destroyed
  > The pilot's failure to maintain a sufficient climb rate during departure in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA16FA023](https://openairdocs.org/ntsb/ERA16FA023.md): Mooney M20M · Worcester, MA · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2015 · N243CW · Substantial damage
  > A total loss of engine power during the initial climb due to a fatigue failure of the engine's crankshaft. Contributing to the accident was the pilot's failure to maintain control of the airplane, which resulted in an aerodynamic stall.
- [NTSB ERA16RA021](https://openairdocs.org/ntsb/ERA16RA021.md): Beech 60 · Bogota, Colombia · Accident · 10 fatal · Foreign investigation · Oct 18, 2015 · HK3917G · Substantial damage
  > On October 18, 2015 at 2119 UTC, a Beechcraft B60, Colombian registration HK3917G, registered to and operated by Sky Hub Aviation, was destroyed during a collision with a building in Barrio El Lujan, Bogota, Colombia. The pilot, three passengers, and six…
- [NTSB WPR16FA012](https://openairdocs.org/ntsb/WPR16FA012.md): Bucker Jungmeister BU 133 · Missoula, MT · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2015 · N1940J · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while executing a return to the runway after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot’s…
- [NTSB ERA16LA014](https://openairdocs.org/ntsb/ERA16LA014.md): Gross Michael E Stol CH 701 · Eufala, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 2015 · N4931M · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no evidence of any preimpact mechanical malfunctions or failures. Also causal was the pilot's decision to continue the takeoff…
- [NTSB CEN16FA013](https://openairdocs.org/ntsb/CEN16FA013.md): Cessna 421B · Hammond, LA · Accident · 2 fatal · Field investigation · Final report · Oct 14, 2015 · N33FA · Destroyed
  > The loss of right engine power on takeoff due to maintenance personnel's failure to properly tighten the crankcase through-studs during cylinder replacement, which resulted in crankshaft fracture. Also causal were the pilot's failure to feather the propeller…
- [NTSB ERA16FA005](https://openairdocs.org/ntsb/ERA16FA005.md): Piper PA 38-112 · Jasper, GA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2015 · N4313E · Substantial damage
  > The student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…
- [NTSB ERA16LA003](https://openairdocs.org/ntsb/ERA16LA003.md): Beech S35 · Knoxville, TN · Accident · Serious injuries · Class 2 · Limited · Final report · Oct 7, 2015 · N449CT · Substantial damage
  > The pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.
- [NTSB ERA15FA378](https://openairdocs.org/ntsb/ERA15FA378.md): Piper PA 30 · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2015 · N21ND · Substantial damage
  > The pilot's failure to maintain single-engine minimum controllable airspeed following a loss of right engine power during initial climb. Also causal was the loss of right engine power for reasons that could not be determined because examination of the…
- [NTSB WPR15FA268](https://openairdocs.org/ntsb/WPR15FA268.md): Cessna 150F · Port Townsend, WA · Accident · Serious injuries · Field investigation · Final report · Sep 28, 2015 · N8529G · Substantial damage
  > The loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…
- [NTSB CEN15FA426](https://openairdocs.org/ntsb/CEN15FA426.md): Jones Ralph D Zodiac CH 601 HD · Ama, LA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 2015 · N401 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…
- [NTSB CEN15FA425](https://openairdocs.org/ntsb/CEN15FA425.md): Cessna T310Q · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2015 · N301JA · Destroyed
  > The separation of the attachment hardware connecting the elevator trim tab pushrod to the elevator trim actuator, which resulted in the elevator trim tab jamming in a position outside the limits of normal travel and a subsequent loss of airplane control.
- [NTSB CEN15FA422](https://openairdocs.org/ntsb/CEN15FA422.md): Pierce, Henry Bushby Mustang II · Granbury, TX · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2015 · N929DS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.
- [NTSB ERA15LA373](https://openairdocs.org/ntsb/ERA15LA373.md): Vanek Jim Sport Copter Vortex · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 2015 · N179V · Substantial damage
  > A loss of engine power due to a lean fuel/air mixture as a result of a disconnected fuel primer line.
- [NTSB WPR15LA266](https://openairdocs.org/ntsb/WPR15LA266.md): Piper PA 28 · Elko, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2015 · N56897 · Substantial damage
  > The pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.
- [NTSB WPR15IA263](https://openairdocs.org/ntsb/WPR15IA263.md): Cessna T206H · Idaho Falls, ID · Incident · Minor injuries · Incident investigation · Final report · Sep 21, 2015 · N7269T · Minor damage
  > An in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.
- [NTSB GAA15CA268](https://openairdocs.org/ntsb/GAA15CA268.md): Helio H 395 · Bethel, AK · Accident · No injuries · Data collection · Final report · Sep 18, 2015 · N910SP · Substantial damage
  > The pilot's failure to maintain a positive climb rate during takeoff initial climb, resulting in an uncontrolled descent and collision with trees and terrain.
- [NTSB DCA15WA198](https://openairdocs.org/ntsb/DCA15WA198.md): Boeing 777 · Miami, FL · Incident · No injuries · Foreign investigation · Sep 16, 2015 · A7-BAC · Minor damage
  > The National Transportation Safety Board (NTSB) has delegated the investigation of an incident involving a Qatar Airways Boeing 777-300, that occurred on September 15, 2015, to the Civil Aviation Authority (CAA) of Qatar. The NTSB has appointed a U.S.…
- [NTSB ANC15FA071](https://openairdocs.org/ntsb/ANC15FA071.md): Dehavilland DHC 3T · Iliamna, AK · Accident · 3 fatal · Field investigation · Final report · Sep 15, 2015 · N928RK · Substantial damage
  > The pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…
- [NTSB ERA15LA358](https://openairdocs.org/ntsb/ERA15LA358.md): Bellanca 7KCAB · Manteo, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 2015 · N86705 · Substantial damage
  > The inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.
- [NTSB ERA15FA353](https://openairdocs.org/ntsb/ERA15FA353.md): Aero Vodochody L39 · Oneida, TN · Accident · 1 fatal · Field investigation · Final report · Sep 12, 2015 · N139RT · Destroyed
  > The pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.
- [NTSB ERA15FA348](https://openairdocs.org/ntsb/ERA15FA348.md): Aerofab Lake LA-4-250 · Somerset, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2015 · N1401P · Destroyed
  > The pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…
- [NTSB CEN15LA402](https://openairdocs.org/ntsb/CEN15LA402.md): Viking Dragonfly · Freeport, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 2015 · N24TL · Substantial damage
  > The airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.
- [NTSB CEN15LA404](https://openairdocs.org/ntsb/CEN15LA404.md): Cessna TR182 · Midland, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 5, 2015 · N4707S · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR15FA256](https://openairdocs.org/ntsb/WPR15FA256.md): Piper PA28 · Santee, CA · Accident · 2 fatal · Field investigation · Final report · Sep 3, 2015 · N8441B · Substantial damage
  > The pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.
- [NTSB CEN15RA452](https://openairdocs.org/ntsb/CEN15RA452.md): Piper PA28 · Bergen, Norway · Incident · No injuries · Foreign investigation · Aug 31, 2015 · LN-BGQ · No damage
  > import
- [NTSB CEN15LA392](https://openairdocs.org/ntsb/CEN15LA392.md): Cessna T240 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Aug 31, 2015 · N452CS · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from the pilot’s inadequate fuel management and the flight instructor’s failure to verify the fuel level and fuel selector position in flight.
- [NTSB ERA15LA332](https://openairdocs.org/ntsb/ERA15LA332.md): Lancair IV · Fort Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2015 · N864KM · Destroyed
  > The mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.

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

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