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

## Latest cases

- [NTSB WPR15IA080](https://openairdocs.org/ntsb/WPR15IA080.md): Robinson Helicopter R22 Beta II · Phoenix, AZ · Incident · No injuries · Incident investigation · Final report · Dec 30, 2014 · N7041X · No damage
  > The failure of the fanshaft due to fatigue.
- [NTSB ERA15LA087](https://openairdocs.org/ntsb/ERA15LA087.md): MDS Fying Zenith Zodiac CH 650 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Dec 30, 2014 · N419PE · Substantial damage
  > The inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.
- [NTSB DCA15WA212](https://openairdocs.org/ntsb/DCA15WA212.md): Boeing 737 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · Dec 30, 2014 · AP-BJN · Minor damage
  > The Pakistan Civil Aviation Authority (PCAA) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on December 30, 2014. The NTSB has appointed a U.S. Accredited Representative to assist PCAA's investigation under the provisions…
- [NTSB CEN15LA091](https://openairdocs.org/ntsb/CEN15LA091.md): Cessna 208B · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Dec 30, 2014 · N950FE · Substantial damage
  > The pilot's failure to maintain adequate airspeed to compensate for icing on the airplane's wings and control surfaces during a circling approach, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA15FA085](https://openairdocs.org/ntsb/ERA15FA085.md): Robinson Helicopter R22 Beta · Lake Worth, FL · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2014 · N771MM · Substantial damage
  > A main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.
- [NTSB ERA15LA084](https://openairdocs.org/ntsb/ERA15LA084.md): Aerotek Pitts Special S-1S · Westminster, MD · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2014 · N49294 · 2 aircraft · Substantial damage
  > The pilot’s failure to see and avoid the other airplane, which resulted in a midair collision while both airplanes were on final approach to land.
- [NTSB CEN15FA087](https://openairdocs.org/ntsb/CEN15FA087.md): Piper PA-34-200T · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2014 · N38884 · Destroyed
  > The pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.
- [NTSB CEN15FA081](https://openairdocs.org/ntsb/CEN15FA081.md): Beech V35A · Seagoville, TX · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2014 · N555SF · Destroyed
  > The pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.
- [NTSB CEN15WA113](https://openairdocs.org/ntsb/CEN15WA113.md): Saab-Scania Saab 2000 · Sumburgh, United Kingdom · Incident · No injuries · Foreign investigation · Dec 15, 2014 · G-LGNO
  > On December 15, 2014, about 1955 coordinated universal time, a SAAB-Scania SAAB 2000 airplane, G-LGNO, lost elevator control following a lightning strike on approach to Sumburgh Airport, Sumburgh, United Kingdom. The damage to the airplane is unknown. The…
- [NTSB DCA15CA037](https://openairdocs.org/ntsb/DCA15CA037.md): Boeing 737 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Dec 13, 2014 · N7710A · Substantial damage
  > an inadvertent encounter with birds during approach to land that resulted in substantial damage.
- [NTSB CEN15IA085](https://openairdocs.org/ntsb/CEN15IA085.md): Dassault/Sud FAN JET Falcon · Shreveport, LA · Incident · No injuries · Incident investigation · Final report · Dec 12, 2014 · N827AA · No damage
  > A short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.
- [NTSB DCA15WA031](https://openairdocs.org/ntsb/DCA15WA031.md): Beech F33 - A · Krugersdorp, South Africa · Accident · No injuries · Foreign investigation · Dec 8, 2014 · ZS-KHE · Destroyed
- [NTSB DCA15MA029](https://openairdocs.org/ntsb/DCA15MA029.md): Embraer EMB-500 · Gaithersburg, MD · Accident · 6 fatal · Class 1 · Major · Final report · Dec 8, 2014 · N100EQ · Destroyed
  > the pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…
- [NTSB WPR15LA055](https://openairdocs.org/ntsb/WPR15LA055.md): Fouga CM 170R Magister · Lake Havasu City, AZ · Accident · No injuries · Limited investigation · Final report · Dec 6, 2014 · N300FM · Substantial damage
  > A total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.
- [NTSB CEN15LA069](https://openairdocs.org/ntsb/CEN15LA069.md): Cirrus Design SR20 · Fort Collins, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 2014 · N407ND · Substantial damage
  > The student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…
- [NTSB ERA15WA070](https://openairdocs.org/ntsb/ERA15WA070.md): Piper PA-31-350 · Mariquita, Colombia · Accident · 10 fatal · Foreign investigation · Dec 3, 2014 · HK4464 · Destroyed
- [NTSB ERA15CA064](https://openairdocs.org/ntsb/ERA15CA064.md): Piper PA 28-180 · Athens, AL · Accident · Serious injuries · Data collection · Final report · Nov 30, 2014 · N7422W · Substantial damage
  > The pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.
- [NTSB ENG15RA003](https://openairdocs.org/ntsb/ENG15RA003.md): ATR ATR72 - 212A · Visby, Sweden · Incident · No injuries · Foreign investigation · Nov 30, 2014 · SE-MDB · No damage
  > On November 30, 2014, an ATR72-212A airplane, SE-MDB, experienced excessive vibration during approach to Visby Airport(ESSV), Gotland, Sweden. The right engine was shut down and a single-engine landing was performed. Post-incident inspection found damage to…
- [NTSB CEN15FA060](https://openairdocs.org/ntsb/CEN15FA060.md): Bellanca 17-30A · Boonville, MO · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2014 · N6629V · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…
- [NTSB DCA15WA030](https://openairdocs.org/ntsb/DCA15WA030.md): Robinson R44 - II · Dar es Salaam, Tanzania · Accident · 4 fatal · Foreign investigation · Nov 29, 2014 · 5H-TWA · Destroyed
- [NTSB CEN15LA068](https://openairdocs.org/ntsb/CEN15LA068.md): Rans S-14 · Kewanee, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 2014 · UNREG · Substantial damage
  > The pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.
- [NTSB CEN15LA064](https://openairdocs.org/ntsb/CEN15LA064.md): Piper PA 24-250 · Berrien Springs, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2014 · N5897P · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15LA066](https://openairdocs.org/ntsb/CEN15LA066.md): MD Helicopter MD 900 · Highlandville, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2014 · N902LC · Substantial damage
  > The pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.
- [NTSB ANC15LA005](https://openairdocs.org/ntsb/ANC15LA005.md): Piper PA 18-150 · Nikiski, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2014 · N9720P · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat while operating at low-power settings in an area conducive to carburetor icing.
- [NTSB ERA15CA065](https://openairdocs.org/ntsb/ERA15CA065.md): Socata TB 20 Trinidad · Hilton Head Island, SC · Accident · No injuries · Data collection · Final report · Nov 26, 2014 · N85AV · Substantial damage
  > The pilot's inadvertent selection of an incorrect frequency, which resulted in his inability to activate the airport lighting, and his subsequent decision to continue the approach in dark night conditions despite having not positively identified the runway…
- [NTSB WPR15FA045](https://openairdocs.org/ntsb/WPR15FA045.md): Piper PA 24-250 · Garberville, CA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2014 · N7428P · Substantial damage
  > A loss of engine power for reasons that could not be determined due to extensive damage sustained during the collision and postaccident water immersion.
- [NTSB CEN15FA048](https://openairdocs.org/ntsb/CEN15FA048.md): Aero Commander 500 B · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2014 · N30MB · Substantial damage
  > The pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.
- [NTSB CEN15FA051](https://openairdocs.org/ntsb/CEN15FA051.md): Mooney M20C · Pagosa Springs, CO · Accident · 2 fatal · Field investigation · Final report · Nov 15, 2014 · N6466U · Destroyed
  > The noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.
- [NTSB WPR15CA040](https://openairdocs.org/ntsb/WPR15CA040.md): Aerospatiale AS350BA · Panguitch, UT · Accident · Minor injuries · Data collection · Final report · Nov 13, 2014 · N425U · Substantial damage
  > The flight instructor's delayed reaction in taking control of the helicopter during a student pilot's loss of control while landing.
- [NTSB ERA15RA047](https://openairdocs.org/ntsb/ERA15RA047.md): Gates Learjet 35A · Freeport, Bahamas · Accident · 9 fatal · Foreign investigation · Nov 9, 2014 · N17UF · Destroyed
- [NTSB WPR15LA036](https://openairdocs.org/ntsb/WPR15LA036.md): Champion 7AC · Darby, MT · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 2014 · N84462 · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering in gusting wind conditions, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB WPR15LA034](https://openairdocs.org/ntsb/WPR15LA034.md): Extra Flugzeugproduktions-Und EA 300 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Nov 5, 2014 · N369XT · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15GA030](https://openairdocs.org/ntsb/WPR15GA030.md): Hawker Hawker Hunter MK.58 · Oxnard, CA · Accident · 1 fatal · Final report · Oct 30, 2014 · N332AX · Destroyed
  > The pilot's failure to maintain adequate airspeed during the approach for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at an altitude too low for recovery.
- [NTSB ERA15CA031](https://openairdocs.org/ntsb/ERA15CA031.md): Solo Wings Aquilla · Eustis, FL · Accident · Minor injuries · Data collection · Final report · Oct 26, 2014 · N55446 · Substantial damage
  > The pilot's failure to maintain aircraft control during the final approach in turbulent conditions, which resulted in a collision with water.
- [NTSB CEN15LA031](https://openairdocs.org/ntsb/CEN15LA031.md): Cessna T210M · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Oct 26, 2014 · XBNCZ · Substantial damage
  > A loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight fuel planning.
- [NTSB ERA15WA026](https://openairdocs.org/ntsb/ERA15WA026.md): Cessna 310R · Governors Harbor, Bahamas · Accident · 1 fatal · Foreign investigation · Oct 24, 2014 · N310WL · Substantial damage
- [NTSB ERA15FA025](https://openairdocs.org/ntsb/ERA15FA025.md): Cirrus Design SR22 · Frederick, MD · Accident · 3 fatal · Field investigation · Final report · Oct 23, 2014 · N122ES · 2 aircraft · Substantial damage
  > The failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…
- [NTSB CEN15FA022](https://openairdocs.org/ntsb/CEN15FA022.md): CGS Hawk Arrow II Slsa · Lonoke, AR · Accident · 1 fatal · Field investigation · Final report · Oct 20, 2014 · N916H · Substantial damage
  > The pilot's loss of airplane control while turning onto the base leg of the traffic pattern due to his failure to maintain sufficient speed and/or overbanking, which resulted in the airplane impacting trees. Contributing to the pilot's fatal injuries was his…
- [NTSB CEN15LA012](https://openairdocs.org/ntsb/CEN15LA012.md): Cessna 182B · Orange, TX · Accident · No injuries · Limited investigation · Final report · Oct 15, 2014 · N2437G · Substantial damage
  > The pilot’s failure to maintain airplane control during a go-around to avoid another airplane that was making a nonstandard approach to the opposing runway. Contributing to the accident was the other pilot’s use of a nonstandard approach while landing on the…
- [NTSB ERA15CA036](https://openairdocs.org/ntsb/ERA15CA036.md): Six Chuter SR7 XL · Fairview, NC · Accident · Serious injuries · Data collection · Final report · Oct 14, 2014 · UNREG · Substantial damage
  > The non-certificated pilot's delayed go-around procedure, which resulted in collision with trees. Contributing to the accident was the pilot's lack of total flying experience.
- [NTSB CEN15FA008](https://openairdocs.org/ntsb/CEN15FA008.md): Piper PA46 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2014 · N9126V · Destroyed
  > The pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.
- [NTSB CEN15LA020](https://openairdocs.org/ntsb/CEN15LA020.md): Kovars Gary D Zenith Zodiak 601XL · Richland Center, WI · Accident · No injuries · Limited investigation · Final report · Oct 9, 2014 · N601GK · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB ERA15CA012](https://openairdocs.org/ntsb/ERA15CA012.md): Schweizer SGS 2 33A · Waynesboro, VA · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N3619T · Substantial damage
  > The glider's inadvertent encounter with low altitude wind shear.
- [NTSB ERA15CA007](https://openairdocs.org/ntsb/ERA15CA007.md): Aeronca 7AC · Maryville, TN · Accident · Minor injuries · Data collection · Final report · Oct 4, 2014 · N85707 · Substantial damage
  > The pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.
- [NTSB CEN15FA003](https://openairdocs.org/ntsb/CEN15FA003.md): Bell Helicopter Textron 206L 1 · Wichita Falls, TX · Accident · 3 fatal · Field investigation · Final report · Oct 4, 2014 · N335AE · Destroyed
  > The pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.
- [NTSB WPR15LA001](https://openairdocs.org/ntsb/WPR15LA001.md): Gaston Thomas D Thunder Mustang · Council, ID · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 2014 · N51TG · Destroyed
  > The pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.
- [NTSB ERA15CA002](https://openairdocs.org/ntsb/ERA15CA002.md): Piper PA-28-140 · Toccoa, GA · Accident · Minor injuries · Data collection · Final report · Oct 2, 2014 · N6044W · Substantial damage
  > The private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.
- [NTSB CEN14LA527](https://openairdocs.org/ntsb/CEN14LA527.md): Butcher Russell A RV9A · Shepherd, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 27, 2014 · N809RD · Substantial damage
  > The pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…
- [NTSB CEN14LA520](https://openairdocs.org/ntsb/CEN14LA520.md): Robinson Helicopter R22 Beta · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 2014 · N7026J · Substantial damage
  > The pilot's failure to maintain main rotor rpm during a pinnacle approach, which resulted in a loss of helicopter control and collision with terrain. Contributing to the accident was the pilot's decision to attempt the approach given the helicopter's weight…
- [NTSB WPR14CA385](https://openairdocs.org/ntsb/WPR14CA385.md): Robinson Helicopter R44 · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Sep 22, 2014 · N8375E · Substantial damage
  > The pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.

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

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