NTSB investigations
1,269 cases where NTSB found Performance/control parameters, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062000')) 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 CEN17FA167Accident · 1 fatalField investigationFinal reportCessna 421C · Huntsville, TXThe pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined…NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.NTSB CEN17LA144Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Wayne, INThe pilot receiving instruction’s failure to maintain airplane control during a crosswind landing in high gusting winds, and the flight instructor’s failure to maintain a proper airspeed and angle of attack during the go-around, which resulted in an…NTSB ERA17FA136Accident · 4 fatalField investigationFinal reportCessna T210 · Hayden, ALThe pilot's decision to continue the flight into known adverse weather conditions, which resulted in spatial disorientation and a subsequent loss of airplane control and in-flight breakup.NTSB CEN17FA138Accident · 1 fatalField investigationFinal reportBeech V35 · Union City, OKThe pilot's improper recovery from a spin.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 GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.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 WPR17FA066Accident · 4 fatalField investigationFinal reportCessna T310Q · Riverside, CAThe pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…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 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 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 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 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 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 CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB ERA17LA041Accident · Serious injuriesLimited investigationFinal reportBeech 36 · Ormond Beach, FLA loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.NTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.NTSB ERA17LA031Accident · Minor injuriesLimited investigationFinal reportHaddow William H Pitts Special S 1 · New Bern, NCA loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.NTSB ERA17CA030Accident · Minor injuriesData collectionFinal reportKolb Fire FLY · West Middlesex, PAThe noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.NTSB WPR17LA015Accident · No injuriesLimited investigationFinal reportRyan W Gross Arion Lighting · Mesa, AZThe pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.NTSB ERA17LA029Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Mount Ulla, NCThe passenger's failure to follow the pilot's instructions for properly securing herself during landing, which resulted in her serious injury when the balloon landed hard and the basket was dragged.NTSB CEN17FA024Accident · 2 fatalField investigationFinal reportBeech C23 · Osage Beach, MOThe pilot's loss of control while maneuvering shortly after takeoff. Contributing to the loss of control was the pilot's attempt to climb with the flaps fully extended.NTSB GAA17CA033Accident · Minor injuriesData collectionFinal reportStinson 108 3 · Boulder City, NVThe pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.NTSB ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…NTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…NTSB CEN17FA005Accident · 1 fatalField investigationFinal reportBeech D95A · Hitchcock, TXThe flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…NTSB ANC16CA069Accident · Minor injuriesData collectionFinal reportPiper PA18 · Willow, AKThe pilot's failure to maintain airplane control during the landing roll, which resulted in a nose-over.NTSB CEN16LA379Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Chesterfield, MOThe pilot's unstable approach and subsequent loss of airplane control during an attempted go-around.NTSB WPR16LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, WAThe pilot's failure to maintain helicopter control while on the ground, which resulted in mast bumping.NTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…NTSB CEN16LA347Accident · 1 fatalLimited investigationFinal reportHaggenmacher Bensen · Bryant, ARThe pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…NTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.NTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.NTSB CEN16FA304Accident · 1 fatalField investigationFinal reportSchweizer 269C 1 · Jeanerette, LAThe pilot's loss of helicopter control for reasons that could not be determined based on available evidence.NTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.NTSB CEN16FA290Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Fond du Lac, WICarburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.NTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.NTSB ERA16LA267Accident · Serious injuriesLimited investigationFinal reportTemple Benjamin Freedom Master FM-2 · East Haddam, CTThe pilot’s loss of airplane control during the initial climb.NTSB CEN16LA299Accident · No injuriesLimited investigationFinal reportEngineering & Research 415 C · Mt Morris, ILThe pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.NTSB ERA16LA247Accident · Minor injuriesLimited investigationFinal reportMormile Francis W Aventura II · West Pittsfield, METhe pilot's failure to maintain airplane control after a total loss of engine power due to carburetor icing, which accumulated because the carburetor heat was not functioning.NTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB ANC16CA036Accident · No injuriesData collectionFinal reportCessna A185F · King Salmon, AKThe pilot's failure to maintain airplane control while landing in gusty wind conditions, resulting in a noseover.NTSB CEN16FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Jonesboro, ARThe pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB ERA16CA197Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCBC · Warner, NHAn encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.