NTSB investigations
5,011 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 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.
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 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
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 CEN17WA125Accident · Serious injuriesForeign investigationRobinson Helicopter Robinson R44 II · Carlingford, IrelandOn March 12, 2017, about 1715 coordinated universal time (UTC), a Robinson Helicopter Company Inc. R44 II helicopter, G-DORM, was destroyed when it impacted terrain during an approach to landing near Carlingford, County Louth, Ireland. The pilot and one…NTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.NTSB ERA17FA123Accident · 1 fatalField investigationFinal reportJordan Bruce C Pitts S2E · Apex, NCThe pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…NTSB GAA17CA192Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot’s decision to land with a crosswind that exceeded the airplane’s demonstrated capability, which resulted in the airplane banking left and the wing striking the ground.NTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…NTSB ERA17FA118Accident · 1 fatalField investigationFinal reportCessna 421 · Canton, GAThe pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB GAA17CA170Accident · No injuriesData collectionFinal reportMaule M5 · Roxbury, KSThe pilot’s failure to maintain directional control during a go-around.NTSB ERA17FA117Accident · 1 fatalField investigationFinal reportLavender Alan P Sonex · Methuen, MAThe pilot's failure to properly secure oil and fuel line fittings during maintenance, which resulted in an inflight engine fire, and his subsequent loss of control while maneuvering for landing. Contributing to the accident was the pilot's diverted attention…NTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.NTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.NTSB CEN17CA114Accident · No injuriesData collectionFinal reportCessna 340A · Waukesha, WIThe pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.NTSB ERA17LA113Accident · Serious injuriesLimited investigationFinal reportCirrus SR20 · Daytona Beach, FLThe pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.NTSB CEN17RA106Accident · 5 fatalForeign investigationRaytheon B200 · Melbourne, AustraliaOn February 20, 2017, at 2159 hours universal coordinated time (0859 hours Australian eastern daylight time on February 21, 2017), a Raytheon model B200 (King Air) airplane, Australian registration VH-ZCR, impacted a building and roadway shortly after takeoff…NTSB CEN17LA118Accident · No injuriesLimited investigationFinal reportThunder & Colt Airborne Amer AX10 180 · Albuquerque, NMThe pilot’s delayed reaction to the balloon’s increased rate of descent during an attempted landing, which resulted in impact with a power line.NTSB GAA17CA165Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Spofford, TXThe pilot's decision to hover-taxi out of the hangar and his subsequent failure to maintain clearance from the hangar.NTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.NTSB WPR17LA068Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Holbrook, AZThe pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.NTSB ERA17CA114Accident · No injuriesData collectionFinal reportCessna 172N · Statesville, NCA loss of airplane control during takeoff for reasons that could not be determined based on the available information.NTSB CEN17LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Centennial, COThe loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA17CA140Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, NCThe pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.NTSB ERA17FA106Accident · 2 fatalField investigationFinal reportBeech C23 · Winder, GAThe flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.NTSB ANC17LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA18 · Sterling, AKThe pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.NTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.NTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA17CA099Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.NTSB WPR17LA059Accident · Minor injuriesLimited investigationFinal reportBeech E 55 · Bakersfield, CAThe pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.NTSB GAA17CA128Accident · No injuriesData collectionFinal reportCessna 210 · Charleston, WVThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard landing and runway excursion.NTSB WPR17WA060Accident · 2 fatalForeign investigationGrumman American G-73 · Perth, AustraliaOn January 26, 2017, at 1708 local time, a Grumman American Aviation Corp. G-73, VH-CQA, collided with water while maneuvering near Perth, Australia. The airplane and the pilot and passenger were fatally injured. The flight was operated under the pertinent…NTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.NTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.NTSB ERA17LA092Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Beechcraft G36 · West Caldwell, NJThe pilot’s failure to maintain airplane control after takeoff, which resulted in an aerodynamic stall.NTSB CEN17FA080Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Wellington, TXThe pilot's improper decision to perform a steep turn at low altitude, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.NTSB ERA17CA089Accident · Minor injuriesData collectionFinal reportCessna 182 · Mobile, ALThe pilot’s failure to maintain airplane control during the initial climb.NTSB WPR17FA052Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Port Orford, ORThe pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.NTSB CEN17FA075Accident · 1 fatalField investigationFinal reportFields Steen Skybolt · Era, TXThe pilot’s loss of airplane control while conducting aerobatic flight maneuvers with insufficient altitude to recover.NTSB ERA17LA083Accident · Serious injuriesLimited investigationFinal reportMaule MX7 · Carthage, TNThe pilot's inadequate compensation for gusting tailwind conditions, which resulted in a loss of airplane control during the landing flare.NTSB WPR17FA047Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · San Pedro, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing. Also causal was the pilot's failure to maintain rotor rpm following the loss of engine…NTSB ERA17WA086Accident · 2 fatalForeign investigationCessna 172 · Tangara da Serra, BrazilOn January 5, 2017, at 1420 universal time coordinated, a Cessna 172S airplane, Brazilian registration PR-GRS, sustained substantial damage when it struck high-tension power-lines while attempting to land at the Tangara da Serra Airport (TGQ), State of Mato…NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…NTSB CEN17FA072Accident · 6 fatalField investigationFinal reportCessna 525 · Cleveland, OHControlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…NTSB WPR17LA043Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mt. Baldy, CAThe pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…NTSB ERA17WA076Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileNTSB CEN17LA062Accident · No injuriesLimited investigationFinal reportPiper PA22 · Piedmont, MOThe pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.