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 ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…Jun 8, 2014 · N863SB · DestroyedNTSB CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.Jun 8, 2014 · N567CM · Substantial damageNTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.Jun 7, 2014 · N2804P · DestroyedNTSB WPR14FA234Accident · 2 fatalField investigationFinal reportPiper J3C · Paso Robles, CAThe pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 7, 2014 · N24918 · Substantial damageNTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…Jun 7, 2014 · N86NW · Substantial damageNTSB CEN14CA283Accident · No injuriesData collectionFinal reportAyres S2R T34 · Wilmont, ARPilot's failure to verify the amount of chemical load on the airplane prior to takeoff which resulted in the airplane being heavier than expected. Contributing to the accident was loading crew not following the pilot's instructions.Jun 7, 2014 · N23034 · Substantial damageNTSB CEN14LA281Accident · Serious injuriesLimited investigationFinal reportOffchiss Edward R Avid Flyer · Lamoni, IAThe student pilot’s failure to maintain control of the airplane while landing.Jun 6, 2014 · N111ED · Substantial damageNTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.Jun 6, 2014 · N30537 · Substantial damageNTSB WPR14LA222Accident · 1 fatalLimited investigationFinal reportPhillips BD 4 · Dayton, NVThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the turn onto the final base leg in gusting wind conditions, which resulted in a stall/spin at too low an altitude to allow recovery.Jun 3, 2014 · N11DV · DestroyedNTSB ERA14CA274Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Middletown, NYThe pilot's failure to maintain directional control during a bounced landing.Jun 1, 2014 · N7638 · Substantial damageNTSB CEN14LA277Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Durango, COThe student pilot’s decision to fly solo into an unfamiliar, mountain airport during high-wind conditions. Contributing to the accident was a partial loss of engine power during the attempted go-around, which was caused by an over-rich mixture setting.Jun 1, 2014 · N583KM · Substantial damageNTSB CEN14FA266Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Stevens Point, WIThe pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.Jun 1, 2014 · N176FD · Substantial damageNTSB WPR14CA219Accident · Minor injuriesData collectionFinal reportPzl-Swidnik PW 5 · Enumclaw, WAThe pilot's failure to maintain control of the glider during the landing flare which resulted in a stall and hard landing.May 31, 2014 · N77FZ · Substantial damageNTSB CEN14CA533Accident · No injuriesData collectionFinal reportAviat Pitts S 2B · Grants, NMThe pilot's failure to maintain control of the airplane during landing in gusty wind conditions.May 31, 2014 · N9YH · Substantial damageNTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.May 30, 2014 · N5495K · Substantial damageNTSB CEN14CA271Accident · No injuriesData collectionFinal reportBRM Aero Sro Bristell S-LSA · Boerne, TXThe instructor pilot's failure to regain control of the airplane following the student pilot's initial loss of control of the airplane.May 30, 2014 · N348BL · Substantial damageNTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.May 29, 2014 · UNREG · Substantial damageNTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.May 28, 2014 · N51853 · Substantial damageNTSB ERA14WA275Accident · 5 fatalForeign investigationBeech B200 · Colonia, UruguayOn May 27, 2014, about 1050 coordinated universal time (UTC), a Beechcraft B200, Argentina registration LV-CNT, was substantially damaged when it impacted the water near Rio de la Plata, Uruguay. The Argentinian pilot and four of the passengers were fatally…May 27, 2014 · LV-CNT · Substantial damageNTSB CEN14LA255Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Gueydan, LAThe pilot's failure to maintain airplane control, which resulted in a stall and subsequent collision with power lines.May 27, 2014 · N602RR · Substantial damageNTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.May 26, 2014 · N4493 · Substantial damageNTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.May 26, 2014 · N640C · Substantial damageNTSB ERA14CA259Accident · No injuriesData collectionFinal reportBrantly B 2B · Essex, MDThe pilot's failure to maintain helicopter control during landing resulting in a hard landing and a roll over.May 25, 2014 · N9023Z · Substantial damageNTSB WPR14FA209Accident · 1 fatalField investigationFinal reportKenneth A Berger Searey LSX · Electric City, WAThe pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.May 24, 2014 · N249PW · Substantial damageNTSB CEN14LA259Accident · Serious injuriesLimited investigationFinal reportSibley Glasair · Midlothian, TXThe pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.May 24, 2014 · N4VX · DestroyedNTSB WPR14LA206Accident · Minor injuriesLimited investigationFinal reportWilliams Helicopter UH 1H · Waitsburg, WAAn extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…May 23, 2014 · N260TA · Substantial damageNTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, BoliviaMay 23, 2014 · CP-2544 · DestroyedNTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.May 22, 2014 · N2068Z · Substantial damageNTSB ERA14CA320Accident · No injuriesData collectionFinal reportFairchild M 62C(PT-23A) · Petersburg, VAThe flight instructor's failure to maintain control of the airplane during the landing attempt. Contributing to the accident was the changing wind conditions.May 22, 2014 · N60418 · Substantial damageNTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.May 21, 2014 · N702CB · Substantial damageNTSB ERA14LA254Accident · Serious injuriesLimited investigationFinal reportJohn V Rawson JR Sprint II · Princeton, NJThe pilot’s failure to maintain airplane control during the approach to land. Contributing to the accident was the pilot’s unfamiliarity with and lack of training in the accident airplane make and model.May 21, 2014 · N505CR · Substantial damageNTSB CEN14CA246Accident · No injuriesData collectionFinal reportNorth American SNJ 6 · Santa Fe, NMThe pilot's loss of directional control during landing and subsequent go around attempt.May 18, 2014 · N5485V · Substantial damageNTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.May 11, 2014 · N209SP · Substantial damageNTSB ERA14WA247Accident · 2 fatalForeign investigationCessna 140A · Cachoeira do Sul, BrazilOn May 10, 2014, at 2025 coordinated universal time, a Cessna 140A, Brazilian registration PT-AGS, experienced a loss of control and subsequently impacted terrain near Cachoeira do Su, Brazil. The two pilots onboard were fatally injured. The instructional…May 10, 2014 · PT-AGS · Substantial damageNTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…May 10, 2014 · N824SH · Substantial damageNTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…May 5, 2014 · N4519Y · DestroyedNTSB WPR14FA181Accident · 1 fatalField investigationFinal reportAero Tek Zuni · Aguila, AZThe pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.May 3, 2014 · N22DA · Substantial damageNTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…May 2, 2014 · N702JS · Substantial damageNTSB ERA14WA241Accident · 2 fatalForeign investigationCessna T210N · Para, BrazilOn April 30, 2014, about 2215 UTC, a Cessna T210N, Brazilian Registration PR-WCO, registered to and operated by Mineradora Bom Jesus Ltda, collided with trees during a go-around from landing at an airstrip located in Para, Brazil. Visual meteorological…Apr 30, 2014 · PR-WCO · DestroyedNTSB WPR14LA173Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Adelanto, CAThe commercial pilot’s improper control inputs, which resulted in a loss of helicopter control during takeoff.Apr 27, 2014 · N606BP · Substantial damageNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB CEN14CA223Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Liberty, MOThe pilot's failure to maintain directional control while operating in gusty wind conditions at a low altitude.Apr 25, 2014 · N32VB · Substantial damageNTSB CEN14WA214Accident · 4 fatalForeign investigationCessna 172 - M · Gracias, HondurasOn April 23, 2014, at 1900 universal coordinated time, a Cessna 172M airplane, bearing Honduran registration HR-AVH, was destroyed upon impact with trees and terrain under unknown circumstances, near Gracias, Department of Lempira, in the Republic of…Apr 23, 2014 · HR-AVN · DestroyedNTSB ERA14CA205Accident · Minor injuriesData collectionFinal reportCirrus Design SR20 · Sanford, FLThe student pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was his failure to compensate for torque, P-factor, and the reported crosswind conditions.Apr 21, 2014 · N497DA · Substantial damageNTSB ERA14CA203Accident · Minor injuriesData collectionFinal reportEvolution Revo · Concord, NHThe student pilot's failure to maintain control during a go around, which resulted in a collision with terrain.Apr 20, 2014 · N2264X · Substantial damageNTSB CEN14WA206Accident · 7 fatalForeign investigationSui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, FinlandOn April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10…Apr 20, 2014 · OH-XDZ · DestroyedNTSB CEN14CA203Accident · Minor injuriesData collectionFinal reportPiper PA-28 · Kalamazoo, MIAn inadvertent stall during gusting crosswind conditions.Apr 19, 2014 · N38240 · Substantial damageNTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.Apr 18, 2014 · N827D · DestroyedNTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.Apr 18, 2014 · UNREG · Substantial damageNTSB WPR14FA167Accident · 1 fatalField investigationFinal reportSands Helicycle · Reno, NVThe pilot’s failure to maintain control of the helicopter while in the traffic pattern.Apr 13, 2014 · N78CS · Substantial damage