# NTSB investigations, 2015: Approach

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 · 158 cases

## Latest cases

- [NTSB GAA16CA095](https://openairdocs.org/ntsb/GAA16CA095.md): Piper PA 28-161 · Fort Worth, TX · Accident · No injuries · Data collection · Final report · Dec 30, 2015 · N2135B · Substantial damage
  > An inadvertent collision with a bird while on downwind in the airport pattern.
- [NTSB DCA16CA052](https://openairdocs.org/ntsb/DCA16CA052.md): Boeing 737 76N · San Diego, CA · Accident · Serious injuries · Data collection · Final report · Dec 26, 2015 · N7733B · No damage
  > An inadvertent encounter with clear air turbulence.
- [NTSB DCA16CA053](https://openairdocs.org/ntsb/DCA16CA053.md): Boeing 737 7H4 · Charlotte, NC · Accident · Serious injuries · Data collection · Final report · Dec 23, 2015 · N475WN · No damage
  > An inadvertent encounter with clear air turbulence.
- [NTSB WPR16FA042](https://openairdocs.org/ntsb/WPR16FA042.md): Piper PA32R · Castro Valley, CA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2015 · N323PA · Destroyed
  > The pilot's loss of control due to spatial disorientation while maneuvering during an instrument approach in instrument meteorological conditions.
- [NTSB ERA16LA067](https://openairdocs.org/ntsb/ERA16LA067.md): Golden Circle Air T Bird II · Lenoir, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2015 · N92744 · Destroyed
  > The pilot’s failure to maintain airspeed and a coordinated turn in the traffic pattern, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to…
- [NTSB GAA16CA077](https://openairdocs.org/ntsb/GAA16CA077.md): Piper PA 28 · California, MD · Accident · No injuries · Data collection · Final report · Dec 11, 2015 · N432FL · Substantial damage
  > The student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.
- [NTSB ERA16FA064](https://openairdocs.org/ntsb/ERA16FA064.md): Beech A36 · Farmington, PA · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2015 · N72054 · Destroyed
  > The pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…
- [NTSB CEN16FA062](https://openairdocs.org/ntsb/CEN16FA062.md): Piper PA46 500TP · Council Bluffs, IA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2015 · N145JR · Substantial damage
  > The pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.
- [NTSB ERA16FA063](https://openairdocs.org/ntsb/ERA16FA063.md): Timothy C Williams CCK-1865 · Linesville, PA · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2015 · N541TC · Substantial damage
  > The noninstrument-rated pilot's improper decision to attempt a flight under visual flight rules at night in instrument meteorological conditions to an unlit airstrip, which resulted in controlled flight into terrain.
- [NTSB CEN16LA055](https://openairdocs.org/ntsb/CEN16LA055.md): Piper PA 28-181 · Pontiac, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 2015 · N47480 · Substantial damage
  > The pilot’s operation of the airplane below the glideslope and off course during a night, instrument approach, which resulted in a collision with trees and terrain.
- [NTSB DCA16WA034](https://openairdocs.org/ntsb/DCA16WA034.md): Boeing · Perth, Australia · Incident · No injuries · Foreign investigation · Dec 4, 2015 · 9V-OJC · No damage
  > The Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 787 that occurred on December 04, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions…
- [NTSB CEN16WA056](https://openairdocs.org/ntsb/CEN16WA056.md): Piper PA28R · Ljubljana, Slovenia, Slovenia · Accident · 1 fatal · Foreign investigation · Dec 3, 2015 · OE-DYM · Destroyed
  > On December 3, 2015, a Piper PA-28R-201 airplane, OE-DYM, was destroyed after impact with terrain while on approach to the Ljubljana Airport, Slovenia. The pilot was fatally injured. This investigation is under the jurisdiction and control of the Republic of…
- [NTSB GAA16CA066](https://openairdocs.org/ntsb/GAA16CA066.md): Grumman American Avn. AA 5 · West Point, VA · Accident · No injuries · Data collection · Final report · Dec 2, 2015 · N28295 · Substantial damage
  > The pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.
- [NTSB CEN16LA053](https://openairdocs.org/ntsb/CEN16LA053.md): Pipistrel Virus · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 2, 2015 · N145VS · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of contamination in the right fuel tank and fuel lines, which prevented fuel from flowing to the engine.
- [NTSB CEN16WA057](https://openairdocs.org/ntsb/CEN16WA057.md): Cessna 560 · Farnborough, United Kingdom · Accident · No injuries · Foreign investigation · Nov 29, 2015 · SE-RHJ · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On November 29, 2015, at 1350 UTC, a Cessna Citation 560XL, SE-RHJ, experienced an in-flight cowling departure during descent…
- [NTSB WPR16LA033](https://openairdocs.org/ntsb/WPR16LA033.md): Piper PA 28-140 · Wickenburg, AZ · Accident · No injuries · Class 3 · Limited · Final report · Nov 25, 2015 · N7PM · Substantial damage
  > A partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.
- [NTSB ERA16CA056](https://openairdocs.org/ntsb/ERA16CA056.md): Cirrus Design SR22 · Danbury, CT · Accident · No injuries · Data collection · Final report · Nov 24, 2015 · N771BT · Substantial damage
  > The pilot's failure to maintain adequate clearance from obstructions while on approach to landing.
- [NTSB CEN16LA064](https://openairdocs.org/ntsb/CEN16LA064.md): Cessna 305A · Sulphur, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 2015 · N5312G · Substantial damage
  > The loss of engine power due to water and contaminants in the carburetor, which resulted in a forced landing to a wet field.
- [NTSB ERA16LA045](https://openairdocs.org/ntsb/ERA16LA045.md): Phantom Aeronautics Phantom X 1 · Monroe, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2015 · N28365 · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any preimpact anomalies that would have precluded normal operation.
- [NTSB WPR16LA030](https://openairdocs.org/ntsb/WPR16LA030.md): Cessna T210N · La Verne, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2015 · N91HC · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA16FA044](https://openairdocs.org/ntsb/ERA16FA044.md): Beech F33A · North Salem, NY · Accident · 2 fatal · Field investigation · Final report · Nov 19, 2015 · N9318Q · Destroyed
  > A loss of airplane control for reasons that could not be determined because examination of the wreckage revealed no mechanical deficiencies.
- [NTSB WPR16LA028](https://openairdocs.org/ntsb/WPR16LA028.md): Beech A36 · Lancaster, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2015 · N78CR · Substantial damage
  > The flight instructor's failure to comply with published instrument approach procedures during an instrument approach in dark night, visual meteorological conditions, which resulted in impact with terrain. Contributing to the accident was the controller's…
- [NTSB CEN16MA036](https://openairdocs.org/ntsb/CEN16MA036.md): British Aerospace HS 125 700A · Akron, OH · Accident · 9 fatal · Class 1 · Major · Final report · Nov 10, 2015 · N237WR · Destroyed
  > The flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…
- [NTSB ERA16FA035](https://openairdocs.org/ntsb/ERA16FA035.md): Cessna 441 · Climax, GA · Accident · 2 fatal · Field investigation · Final report · Nov 9, 2015 · N164GP · Destroyed
  > The pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.
- [NTSB WPR16WA026](https://openairdocs.org/ntsb/WPR16WA026.md): Cessna 310 · Mildura, Australia, Australia · Accident · 1 fatal · Foreign investigation · Nov 6, 2015 · VH-BWZ · Destroyed
  > On November 6, 2015, at 1840 local time, a Cessna 310R, VH-BWZ, operating under the pertinent civil regulation of the Government of Australia, collided with terrain near Mildura, Australia, while on approach. The airplane was destroyed in the post-impact fire…
- [NTSB CEN16LA035](https://openairdocs.org/ntsb/CEN16LA035.md): Glimn Kitfox 2-3 · Escanaba, MI · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2015 · N93TG · Substantial damage
  > The airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…
- [NTSB GAA16LA031](https://openairdocs.org/ntsb/GAA16LA031.md): Airbus AS350 · Deadhorse, AK · Accident · No injuries · Limited investigation · Final report · Oct 27, 2015 · C-GSLY · Substantial damage
  > The noninstrument-rated pilot's continued visual flight into adverse weather conditions, which resulted in spatial disorientation, and his subsequent failure to maintain terrain clearance while attempting to land in flat light and whiteout conditions.
- [NTSB ERA16LA026](https://openairdocs.org/ntsb/ERA16LA026.md): Piper PA31 · Weston, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 2015 · N55GK · Substantial damage
  > The pilot's feathering of the incorrect propeller following a total loss of right engine power due to fuel starvation, which resulted from maintenance personnel’s failure to reinstall the flapper valve in the right main fuel tank. Contributing to the accident…
- [NTSB GAA16CA033](https://openairdocs.org/ntsb/GAA16CA033.md): Cessna 150 · Millbrook, NY · Accident · No injuries · Data collection · Final report · Oct 23, 2015 · N6709S · Substantial damage
  > The pilot's loss of heading control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.
- [NTSB CEN16LA016](https://openairdocs.org/ntsb/CEN16LA016.md): Cirrus Design SR22 · Lancaster, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2015 · N849CD · Destroyed
  > The pilot’s failure to maintain a proper glidepath during a night visual approach, which resulted in impact with a power line. Contributing to the accident was an inoperative precision approach path indicator.
- [NTSB CEN16LA017](https://openairdocs.org/ntsb/CEN16LA017.md): Comp Air CA8 · Ray, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2015 · N224MS · Substantial damage
  > The pilot's improper use of the trim, which created a cross-controlled situation and resulted in an aerodynamic stall during the attempted go-around.
- [NTSB ERA16FA012](https://openairdocs.org/ntsb/ERA16FA012.md): Piper PA 28-180 · Lake Worth, FL · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2015 · N57312 · Destroyed
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB ERA16CA011](https://openairdocs.org/ntsb/ERA16CA011.md): Piper PA-32RT-300T · Salisbury, NC · Accident · No injuries · Data collection · Final report · Oct 13, 2015 · N300KG · Substantial damage
  > The pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN16FA011](https://openairdocs.org/ntsb/CEN16FA011.md): Beech G35 · Eaton, CO · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2015 · N394CW · Substantial damage
  > The pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…
- [NTSB GAA16CA013](https://openairdocs.org/ntsb/GAA16CA013.md): Beech F33 · Marana, AZ · Accident · No injuries · Data collection · Final report · Oct 12, 2015 · N5581T · Substantial damage
  > The student pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an inadvertent aerodynamic stall and impact with terrain during recovery by the flight instructor.
- [NTSB ERA16LA010](https://openairdocs.org/ntsb/ERA16LA010.md): Murray Blair L Free Bird Classic · Kylertown, PA · Accident · 1 fatal · Limited investigation · Final report · Oct 12, 2015 · N176FB · Destroyed
  > The pilot's failure to maintain sufficient airspeed during approach for landing, which resulted in an inadvertent aerodynamic stall/spin. Contributing to the accident was the pilot’s lack of flight experience in the accident airplane make and model.
- [NTSB CEN16LA007](https://openairdocs.org/ntsb/CEN16LA007.md): Rich Harry A Woodstock I · Decatur, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 11, 2015 · N21468 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning from the downwind to the base leg of the pattern in gusting wind conditions, which resulted in the glider exceeding its critical angle-of-attack and entering an aerodynamic stall/spin at a low…
- [NTSB ERA16LA007](https://openairdocs.org/ntsb/ERA16LA007.md): Piper PA28R · Savannah, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 2015 · N9312N · Substantial damage
  > The pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…
- [NTSB GAA16CA003](https://openairdocs.org/ntsb/GAA16CA003.md): Bushmaster Super Bushmaster · Marble Canyon, AZ · Accident · Minor injuries · Data collection · Final report · Oct 4, 2015 · C-FIIB · Substantial damage
  > The pilot's failure to maintain descent rate durring the landing resulting in collision with terrain.
- [NTSB WPR16FA001](https://openairdocs.org/ntsb/WPR16FA001.md): Johnson Coot · Deer Park, WA · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2015 · N69BD · Destroyed
  > The pilot's failure to maintain sufficient airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's diverted attention due to the rough…
- [NTSB GAA16CA002](https://openairdocs.org/ntsb/GAA16CA002.md): Cessna 172 · Avalon, CA · Accident · No injuries · Data collection · Final report · Oct 1, 2015 · N4286Q · Substantial damage
  > The pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.
- [NTSB CEN15LA431](https://openairdocs.org/ntsb/CEN15LA431.md): Edward M Van Morlan Rans S-12 · Gardner, KS · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2015 · N98ES · Substantial damage
  > The pilot's inadequate airspeed control and the airplane’s exceedance of its critical angle-of-attack during the forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to fuel starvation caused by…
- [NTSB GAA15CA288](https://openairdocs.org/ntsb/GAA15CA288.md): Cessna 305F · Bentonville, AR · Accident · No injuries · Data collection · Final report · Sep 27, 2015 · N119BD · Substantial damage
  > The pilot's failure to maintain yaw control during a go-around, which resulted in a right main landing gear collapse and the right wing impacting terrain during a runway excursion.
- [NTSB CEN15FA427](https://openairdocs.org/ntsb/CEN15FA427.md): Cessna 182 · Lexington, TX · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2015 · N3921D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.
- [NTSB CEN15LA436](https://openairdocs.org/ntsb/CEN15LA436.md): Beech C35 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Sep 26, 2015 · N1990D · Substantial damage
  > The total loss of engine power due to contamination in the fuel system.
- [NTSB GAA15CA294](https://openairdocs.org/ntsb/GAA15CA294.md): Howard DGA 15P · Englewood, CO · Accident · No injuries · Data collection · Final report · Sep 25, 2015 · N1785H · Substantial damage
  > The separation of the elevator control system linkage at a push/pull tube and cable joint, for an unknown reason, because the bolt and associated hardware securing the joint was not found for examination.
- [NTSB ERA15LA376](https://openairdocs.org/ntsb/ERA15LA376.md): Hughes 269 · Eustis, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 2015 · N9567F · Substantial damage
  > The pilot's failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.
- [NTSB GAA15LA265](https://openairdocs.org/ntsb/GAA15LA265.md): Stinson 108 · Palmer, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2015 · N6066M · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during final approach to landing, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA15FA361](https://openairdocs.org/ntsb/ERA15FA361.md): Cessna U206 · Spring Hill, FL · Accident · 1 fatal · Field investigation · Final report · Sep 18, 2015 · N8615Z · Substantial damage
  > The pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.
- [NTSB GAA15CA267](https://openairdocs.org/ntsb/GAA15CA267.md): Cessna 180H · Delta Junction, AK · Accident · No injuries · Data collection · Final report · Sep 13, 2015 · N4763U · Substantial damage
  > The pilot's failure to attain and maintain yaw control during the approach and attempted go around, which resulted in impact with trees and terrain.

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

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