# NTSB investigations, 2014: Maneuvering

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

## Latest cases

- [NTSB WPR15WA075](https://openairdocs.org/ntsb/WPR15WA075.md): Cessna 172 - S · Port Arthur, Australia, Australia · Accident · 2 fatal · Foreign investigation · Dec 29, 2014 · VH-PFT · Substantial damage
  > On December 29, 2014, at 1747 local, a Cessna 172S, VH-PFT, collided with water near Port Arthur, Australia during an aerial photography flight. The airplane was operating under the pertinent civil regulations of the government of Australia. The airplane was…
- [NTSB WPR15FA070](https://openairdocs.org/ntsb/WPR15FA070.md): Cessna 172 · Sutter Creek, CA · Accident · 2 fatal · Field investigation · Final report · Dec 24, 2014 · N8518B · Substantial damage
  > The noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…
- [NTSB CEN15FA083](https://openairdocs.org/ntsb/CEN15FA083.md): Cessna 172M · Odessa, TX · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2014 · N9922V · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.
- [NTSB WPR15FA062](https://openairdocs.org/ntsb/WPR15FA062.md): Piper PA 18-150 · Ronan, MT · Accident · 1 fatal · Field investigation · Final report · Dec 16, 2014 · N5989Z · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while performing an intentional, abrupt low-level maneuver.
- [NTSB WPR15CA063](https://openairdocs.org/ntsb/WPR15CA063.md): Eurocopter AS 350 B2 Ecureuil · Bicknell, UT · Accident · No injuries · Data collection · Final report · Dec 16, 2014 · N352SL · Substantial damage
  > The pilot's failure to prevent the helicopter from settling with power while maneuvering at a low altitude, which resulted in a loss of control and subsequent hard landing.
- [NTSB ERA15FA076](https://openairdocs.org/ntsb/ERA15FA076.md): Titan Tornado II · Catlett, VA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2014 · N50402 · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN15LA077](https://openairdocs.org/ntsb/CEN15LA077.md): New Piper PA 32R-301T · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2014 · N3127R · Substantial damage
  > The pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…
- [NTSB WPR15LA058](https://openairdocs.org/ntsb/WPR15LA058.md): Mcholland Glastar · Sheridan, WY · Accident · No injuries · Limited investigation · Final report · Dec 10, 2014 · N16XP · Substantial damage
  > A loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.
- [NTSB CEN15IA076](https://openairdocs.org/ntsb/CEN15IA076.md): Cessna 182S · Springfield, IL · Incident · No injuries · Incident investigation · Final report · Dec 10, 2014 · N661SP · Minor damage
  > The improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.
- [NTSB CEN15CA095](https://openairdocs.org/ntsb/CEN15CA095.md): Cessna 152 · Mount Pleasant, TX · Accident · No injuries · Data collection · Final report · Dec 8, 2014 · N787PB · Destroyed
  > The pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.
- [NTSB WPR15FA051](https://openairdocs.org/ntsb/WPR15FA051.md): Robinson Helicopter R44 · Bountiful, UT · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2014 · N3234U · Substantial damage
  > The pilot/mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and a subsequent loss of control.
- [NTSB WPR15LA048](https://openairdocs.org/ntsb/WPR15LA048.md): Air Tractor AT 502B · Somerton, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 30, 2014 · N946TR · Destroyed
  > A loss of airplane control for reasons that could not be determined based on available evidence.
- [NTSB WPR15FA049](https://openairdocs.org/ntsb/WPR15FA049.md): Cessna 170B · Alzada, MT · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2014 · N3292A · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.
- [NTSB ERA15CA059](https://openairdocs.org/ntsb/ERA15CA059.md): Hiller OH 23B · Leesburg, VA · Accident · No injuries · Data collection · Final report · Nov 24, 2014 · N6057 · Substantial damage
  > A loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.
- [NTSB ERA15CA055](https://openairdocs.org/ntsb/ERA15CA055.md): Mcdonnell Douglas Helicopter MD500 · Decatur, AL · Accident · No injuries · Data collection · Final report · Nov 18, 2014 · N8371F · Substantial damage
  > An undetermined pilot's failure to maintain clearance from an electrical transmission tower resulting in substantial damage to a main rotor blade. Postaccident investigation could not determine which of two pilots was flying the helicopter at the time the…
- [NTSB ERA15WA061](https://openairdocs.org/ntsb/ERA15WA061.md): Piper PA-25-235 · Cidade Gaúcha, State of Paraná, Brazil · Accident · 1 fatal · Foreign investigation · Nov 17, 2014 · PR-WIZ · Destroyed
  > On November 17, 2014, about 1758 universal coordinated time, a Piper PA-25-235, Brazilian registration PR-WIZ, was destroyed when it impacted the ground in a sugar cane field in Cidade Gaúcha, Paraná, Brazil. The pilot was fatally injured. The flight was…
- [NTSB ERA15LA052](https://openairdocs.org/ntsb/ERA15LA052.md): Dehavilland Tiger Moth DH 82A · Williamson, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2014 · N28681 · Destroyed
  > The pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.
- [NTSB WPR15FA039](https://openairdocs.org/ntsb/WPR15FA039.md): Cessna 140A · Gilroy, CA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2014 · N5612C · Substantial damage
  > The pilot’s failure to maintain clearance from power lines while flying at a low altitude. Contributing to the accident was the obscuration of the pilot’s visibility due to sun glare.
- [NTSB CEN15FA032](https://openairdocs.org/ntsb/CEN15FA032.md): Langston, Frederick L RV 4 · Boerne, TX · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2014 · N70PM · Destroyed
  > A total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB WPR15TA027](https://openairdocs.org/ntsb/WPR15TA027.md): Eurocopter AS 350 · Bisbee, AZ · Accident · Serious injuries · Final report · Oct 27, 2014 · N5204X · Substantial damage
  > Failure of maintenance personnel to ensure adequate torque of a pneumatic control pipe (P2) fitting, which resulted in a loss of engine power during low altitude flight maneuvers.
- [NTSB WPR15LA023](https://openairdocs.org/ntsb/WPR15LA023.md): Air Tractor AT 301 · Basin City, WA · Accident · No injuries · Limited investigation · Final report · Oct 27, 2014 · N8878S · Substantial damage
  > Maintenance personnel’s and the airplane owner’s failure to inspect the engine for cracks in the cylinders as required by an airworthiness directive, which resulted in the loss of engine power during low-altitude maneuvering flight.
- [NTSB WPR15LA024](https://openairdocs.org/ntsb/WPR15LA024.md): Extra Flugzeugproduktions-Und EA 300/L · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Oct 26, 2014 · N763DT · Substantial damage
  > The failure of the rudder cable due to tension overstress as a result of the cable’s strength being compromised by wear damage, which resulted in the flight instructor’s inability to maintain directional control during the landing roll.
- [NTSB WPR15FA021](https://openairdocs.org/ntsb/WPR15FA021.md): Slingsby T67M 260 · Ridgecrest, CA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 2014 · N456FR · Substantial damage
  > The pilots' failure to recover from a spin for reasons that could not be determined based on available information. Contributing to the student's fatal injury was his delayed egress from the airplane below the specified egression altitude.
- [NTSB CEN15LA026](https://openairdocs.org/ntsb/CEN15LA026.md): Stephenson Stol CH 701 · Mount Vernon, IN · Accident · 1 fatal · Limited investigation · Final report · Oct 24, 2014 · N34WS · Substantial damage
  > The pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…
- [NTSB CEN15CA025](https://openairdocs.org/ntsb/CEN15CA025.md): Robinson Helicopter R44 · Harper, TX · Accident · No injuries · Data collection · Final report · Oct 24, 2014 · N7192K · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering.
- [NTSB WPR15IA035](https://openairdocs.org/ntsb/WPR15IA035.md): North American P51 - D · Mesa, AZ · Incident · No injuries · Incident investigation · Final report · Oct 23, 2014 · N351BD · Minor damage
  > The failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…
- [NTSB WPR15FA016](https://openairdocs.org/ntsb/WPR15FA016.md): Sonex Sonex Trigear · Fawnskin, CA · Accident · 1 fatal · Field investigation · Final report · Oct 20, 2014 · N91922 · Substantial damage
  > The pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…
- [NTSB ERA15CA018](https://openairdocs.org/ntsb/ERA15CA018.md): Bell 206B · Prattville, AL · Accident · No injuries · Data collection · Final report · Oct 16, 2014 · N59541 · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR15GA005](https://openairdocs.org/ntsb/WPR15GA005.md): Marsh S 2F3AT · El Portal, CA · Accident · 1 fatal · Final report · Oct 7, 2014 · N449DF · Destroyed
  > The pilot's failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB ERA15WA050](https://openairdocs.org/ntsb/ERA15WA050.md): Cessna A188B · Rozo, Colombia · Accident · No injuries · Foreign investigation · Oct 6, 2014 · HK-1746 · Substantial damage
- [NTSB ERA15CA010](https://openairdocs.org/ntsb/ERA15CA010.md): Toerner Bob SEA REY · Tampa, FL · Accident · No injuries · Data collection · Final report · Oct 6, 2014 · N345BT · Substantial damage
  > The pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.
- [NTSB CEN15LA004](https://openairdocs.org/ntsb/CEN15LA004.md): Celier Xenon R · Loma, CO · Accident · 2 fatal · Limited investigation · Final report · Oct 5, 2014 · N719MB · Substantial damage
  > The pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.
- [NTSB ERA15CA005](https://openairdocs.org/ntsb/ERA15CA005.md): HPH 304CZ · Pikeville, TN · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N304AK · Substantial damage
  > A loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.
- [NTSB CEN15CA005](https://openairdocs.org/ntsb/CEN15CA005.md): Cessna 152 · Arlington, TX · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N124RP · Substantial damage
  > The pilot's inadequate flight preparation and navigation during a training flight resulting in collision with low wires.
- [NTSB CEN15LA002](https://openairdocs.org/ntsb/CEN15LA002.md): Bell 206B · Woodsboro, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2014 · N49746 · Substantial damage
  > The pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.
- [NTSB CEN15CA001](https://openairdocs.org/ntsb/CEN15CA001.md): Piper PA 25-235 · Yankton, SD · Accident · No injuries · Data collection · Final report · Oct 1, 2014 · N6659Z · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA14FA461](https://openairdocs.org/ntsb/ERA14FA461.md): Eagle R&D Helicycle · Gallatin, TN · Accident · 1 fatal · Field investigation · Final report · Sep 28, 2014 · N7062U · Substantial damage
  > The pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…
- [NTSB ERA14FA459](https://openairdocs.org/ntsb/ERA14FA459.md): Cessna 172M · Lancaster, NY · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2014 · N9679H · 2 aircraft · Destroyed
  > The other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.
- [NTSB WPR14CA390](https://openairdocs.org/ntsb/WPR14CA390.md): William M Oprendek Pitts S1S · Sedona, AZ · Accident · No injuries · Data collection · Final report · Sep 25, 2014 · N93DB · Substantial damage
  > Failure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.
- [NTSB WPR14CA389](https://openairdocs.org/ntsb/WPR14CA389.md): Piper PA25 - 260 · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Sep 24, 2014 · N8555L · Substantial damage
  > The pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA507](https://openairdocs.org/ntsb/CEN14LA507.md): Manweiller Acro Sport II · Middletown, OH · Accident · 2 fatal · Limited investigation · Final report · Sep 20, 2014 · N94SM · Substantial damage
  > The failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…
- [NTSB WPR14FA381](https://openairdocs.org/ntsb/WPR14FA381.md): Cessna 162 · Borrego Springs, CA · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2014 · N3037H · Substantial damage
  > The pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.
- [NTSB ERA14LA446](https://openairdocs.org/ntsb/ERA14LA446.md): Cessna 180B · Piscataquis County, ME · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 2014 · N180GK · Substantial damage
  > The fatigue fracture of the No. 3 exhaust valve, which initiated at the outer surface of the valve stem and resulted in the subsequent total loss of engine power over terrain unsuitable for landing.
- [NTSB ERA14FA445](https://openairdocs.org/ntsb/ERA14FA445.md): North American T 28C · Alton, VA · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2014 · N531KG · Destroyed
  > The pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.
- [NTSB CEN14FA506](https://openairdocs.org/ntsb/CEN14FA506.md): Cessna 172R · Okmulgee, OK · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2014 · N2435R · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.
- [NTSB WPR14CA375](https://openairdocs.org/ntsb/WPR14CA375.md): Eurocopter AS 350 B2 · Kahului, Maui, HI · Accident · No injuries · Data collection · Final report · Sep 14, 2014 · N197BH · Substantial damage
  > The pilot's failure to maintain clearance from the cart while hovering. Contributing to the accident was the failure of ground personnel to remove the cart from the helipad.
- [NTSB CEN15WA102](https://openairdocs.org/ntsb/CEN15WA102.md): Boeing PT-17 · San Jose, Guatemala · Accident · No injuries · Foreign investigation · Sep 14, 2014 · TG-JEN · Destroyed
  > On September 14, 2014, at 2314 coordinated universal time, a Boeing PT-17, Guatemalian registration TG-JEN, operated by KEHA S.A., was destroyed when it impacted water while performing aerobatic maneuvers near San Jose, Guatemala. The pilot was not injured.…
- [NTSB WPR14LA394](https://openairdocs.org/ntsb/WPR14LA394.md): Lorentzen Lancair Legacy · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 13, 2014 · N368W · Substantial damage
  > The shearing of mounting bolts that attached the right turbocharger to its mounting bracket during an air race, which resulted in hot exhaust gases leaking into the engine compartment and starting a fire.
- [NTSB WPR14FA369](https://openairdocs.org/ntsb/WPR14FA369.md): Backovich George C G P 5 · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2014 · N501GP · Destroyed
  > The failure of the right wing under normal race loads due to an improper repair of the right wing spar that reduced its structural strength following a previous landing accident.
- [NTSB CEN14CA490](https://openairdocs.org/ntsb/CEN14CA490.md): Buckeye Dream · Monee, IL · Accident · Serious injuries · Data collection · Final report · Sep 8, 2014 · UNREG · Substantial damage
  > The pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.

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

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