NTSB investigations
3,842 cases where the defining event was 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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.
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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA14LA302Accident · Minor injuriesLimited investigationFinal reportBailey Robert Moyes Dragonfly · Melfa, VAThe pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.NTSB CEN14CA295Accident · Minor injuriesData collectionFinal reportCessna 414 · Pleasanton, TXThe pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.NTSB WPR14FA243Accident · 2 fatalField investigationFinal reportDittenber Thomas J Auriga · Echo Bay, NVThe pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.NTSB ERA14FA289Accident · 1 fatalField investigationFinal reportMeyer Clair O 2/3 P 51B/C Mustang · Marion, SCThe airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB CEN14WA292Accident · 1 fatalForeign investigationSchweizer 269C · Cerfontaine, Belgium, BelgiumOn June 13, 2014, about 1500 UTC, a Schweizer 269C, OO-JCS (s/n S1749) impacted terrain at the airfield of Cerfontaine, Belgium (EBCF). The helicopter was destroyed. One pilot was fatally injured and one pilot was seriously injured. This investigation is…NTSB CEN14FA286Accident · 2 fatalField investigationFinal reportBell 206 L4 · South Timbalier PlatformThe pilot's loss of helicopter control for reasons that could not be determined based on the available information.NTSB ERA14FA282Accident · 2 fatalField investigationFinal reportLiberty Aerospace XL-2 · Merritt Island, FLThe failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB CEN14LA281Accident · Serious injuriesLimited investigationFinal reportOffchiss Edward R Avid Flyer · Lamoni, IAThe student pilot’s failure to maintain control of the airplane while landing.NTSB 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.NTSB 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.NTSB ERA14CA274Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Middletown, NYThe pilot's failure to maintain directional control during a bounced landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, BoliviaNTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.NTSB 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.NTSB 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.NTSB CEN14CA246Accident · No injuriesData collectionFinal reportNorth American SNJ 6 · Santa Fe, NMThe pilot's loss of directional control during landing and subsequent go around attempt.NTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.