NTSB investigations, 2014

311 cases where the sequence of events included Loss of control in flight.

Cases, newest first

Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR14CA352Accident · Minor injuriesData collectionFinal reportRans S 6S · Rigby, IDThe student pilot's loss of directional control during takeoff in gusting wind conditions. Contributing to the accident was the flight instructor's failure to intervene and apply corrective flight control inputs.Aug 22, 2014 · N171CT · Substantial damageNTSB CEN14LA447Accident · Serious injuriesLimited investigationFinal reportHerder Michael Zodiac 601 HD · Fredericksburg, TXThe pilot’s loss of airplane control during a gusting crosswind landing.Aug 21, 2014 · N318MH · Substantial damageNTSB ERA14FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Parsons, TNThe pilot’s failure to see and avoid trees during a low-level aerial application operation.Aug 20, 2014 · N802BB · Substantial damageNTSB CEN14LA445Accident · Serious injuriesLimited investigationFinal reportFranke Roland SKY Raider · Bethel, OHThe pilot's inadvertent aerodynamic stall while maneuvering after a loss of engine power during initial climb. Contributing to the accident was the total loss of engine power for reasons that could not be determined because the investigation could not…Aug 19, 2014 · N65692 · Substantial damageNTSB CEN14FA437Accident · 3 fatalField investigationFinal reportLancair LC 40 550FG · Ranger, TXThe pilot's loss of airplane control shortly after takeoff as a result of spatial disorientation due to dark night conditions, the pilot's low overall night and instrument flight time, and his lack of recent night flights.Aug 17, 2014 · N6500Z · DestroyedNTSB CEN14LA480Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Hearne, TXThe pilot’s failure to maintain clearance from a crop.Aug 16, 2014 · N878C · Substantial damageNTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.Aug 15, 2014 · N127BC · DestroyedNTSB ERA14FA387Accident · 2 fatalField investigationFinal reportCessna 150 · Mount Pleasant, SCThe commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…Aug 14, 2014 · N66241 · Substantial damageNTSB WPR14CA344Accident · No injuriesData collectionFinal reportCessna 177 · Pine Bluffs, WYThe pilot's inadequate flare and failure to maintain aircraft control while landing.Aug 13, 2014 · N2830X · Substantial damageNTSB CEN14LA432Accident · No injuriesLimited investigationFinal reportCessna 188 - Undesignat · Columbus, NMThe pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…Aug 13, 2014 · N9849V · Substantial damageNTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Aug 12, 2014 · N18GH · Substantial damageNTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.Aug 11, 2014 · N214EV · Substantial damageNTSB ERA14WA381Accident · Serious injuriesForeign investigationPiper PA-25-260 · Tolima, ColombiaOn August 8, 2014, about 2215 coordinated universal time, a Piper PA-25-260, Colombian registration HK1680, was substantially damaged when it impacted terrain near Tolimo, Colombia. The pilot was seriously injured. The local aerial application flight was…Aug 8, 2014 · HK1680 · Substantial damageNTSB CEN14WA420Accident · 1 fatalForeign investigationQuicksilver MXL Sport II · Cuenca, SpainOn August 8, 2014, about 1920 coordinated universal time, a Quicksilver MXL Sport II, motorized ultralight (ULM) aircraft, registry EC-FL8, was substantially damaged after impacting terrain during takeoff. The pilot was fatally injured. At the time of the…Aug 8, 2014 · EC-FL8 · Substantial damageNTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.Aug 6, 2014 · N212RW · Substantial damageNTSB CEN14CA413Accident · Minor injuriesData collectionFinal reportPhantom Phantom X 1 · Three Rivers, MIThe pilot did not maintain adequate airspeed while flying a visual pattern, which resulted in an aerodynamic stall and subsequent loss of control.Aug 6, 2014 · N2552S · Substantial damageNTSB ANC14CA060Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Anderson, AKThe pilot's inadequate compensation for wind conditions, which resulted in a hard landing.Aug 6, 2014 · N3502W · Substantial damageNTSB WPR14FA330Accident · 2 fatalField investigationFinal reportDavid Fitzgerald Zenith · Warren, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.Aug 5, 2014 · N32FZ · DestroyedNTSB CEN14LA406Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Manistee, MIThe pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…Aug 5, 2014 · N468LE · Substantial damageNTSB WPR14CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and failure to maintain aircraft control during taxi, which resulted in a loss of tail rotor effectiveness and subsequent impact with the taxiway and a parked fuel truck.Aug 2, 2014 · N110JC · Substantial damageNTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.Aug 2, 2014 · N4118X · Substantial damageNTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.Aug 2, 2014 · N6257W · Substantial damageNTSB ANC14CA059Accident · No injuriesData collectionFinal reportSteven R Mcneese Airborne Edge X · Palmer, AKThe non-certificated pilot's failure to maintain directional control while performing a high speed taxi test and inadvertent lift-off, which resulted in an inflight collision with trees and terrain.Aug 2, 2014 · N821AK · Substantial damageNTSB WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.Aug 1, 2014 · N3597T · Substantial damageNTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…Aug 1, 2014 · N116LK · DestroyedNTSB CEN14CA460Accident · No injuriesData collectionFinal reportAviat Husky · Steamboat Springs, COThe student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.Aug 1, 2014 · N776BC · Substantial damageNTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…Jul 31, 2014 · N147MP · Substantial damageNTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.Jul 31, 2014 · N7194H · Substantial damageNTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.Jul 30, 2014 · N6004U · Substantial damageNTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.Jul 30, 2014 · N82PR · Substantial damageNTSB CEN14LA433Accident · No injuriesLimited investigationFinal reportSutton William J Stits Playmate SA11A · Bridgeport, TXThe pilot’s loss of airplane control during takeoff after encountering rapidly changing wind conditions.Jul 29, 2014 · N76WS · Substantial damageNTSB CEN14LA398Accident · Serious injuriesLimited investigationFinal reportHughes 369D · West Liberty, OHA total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.Jul 29, 2014 · N89ZC · Substantial damageNTSB ERA14LA363Accident · 1 fatalLimited investigationFinal reportTemco GC 1B · Yulee, FLThe pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.Jul 28, 2014 · N1CY · Substantial damageNTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.Jul 24, 2014 · N8159Z · Substantial damageNTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…Jul 23, 2014 · N4425W · Substantial damageNTSB WPR14LA309Accident · 2 fatalLimited investigationFinal reportBeech A36 · Pago Pago, AntarcticaA loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.Jul 22, 2014 · N20TC · DestroyedNTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…Jul 22, 2014 · N5225C · Substantial damageNTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.Jul 21, 2014 · N84754 · DestroyedNTSB WPR14WA304Accident · 1 fatalForeign investigationCessna 182 - L · Albury Aerodrome, AustraliaOn July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…Jul 20, 2014 · VH-TRS · Substantial damageNTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.Jul 20, 2014 · N42474 · DestroyedNTSB CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.Jul 20, 2014 · N622P · Substantial damageNTSB WPR14CA301Accident · Minor injuriesData collectionFinal reportErcoupe 415 C · Hubbart, ORThe pilot's failure to maintain aircraft control and proper alignment during approach for landing in gusting wind conditions.Jul 19, 2014 · N99621 · Substantial damageNTSB CEN14LA376Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 401B · Ellis, KSThe noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…Jul 18, 2014 · N4223F · Substantial damageNTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.Jul 17, 2014 · N507CF · DestroyedNTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.Jul 14, 2014 · N501WG · Substantial damageNTSB CEN14CA364Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's failure to maintain control during landing.Jul 14, 2014 · N562BG · Substantial damageNTSB ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.Jul 13, 2014 · N849CA · DestroyedNTSB CEN14LA372Accident · 1 fatalLimited investigationFinal reportJonker Sailplanes JS1-C · Wallis, TXThe pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.Jul 13, 2014 · N60XJ · Substantial damageNTSB CEN14FA356Accident · 1 fatalField investigationFinal reportMooney M20M · Greenwood, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. Also causal to the accident was the pilots' decision…Jul 11, 2014 · N72FG · Substantial damageNTSB CEN14CA360Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Englewood, COThe pilot did not maintain control of the helicopter during the takeoff resulting in low rotor rpm and impact of the fuel trailer during the running landing.Jul 11, 2014 · N69MP · Substantial damage