NTSB investigations, 2011
247 cases where the defining event was Loss of control in flight.
Cases per year
| 2008 | 253 |
|---|---|
| 2009 | 231 |
| 2010 | 202 |
| 2011 | 247 |
| 2012 | 241 |
| 2013 | 213 |
| 2014 | 246 |
| 2015 | 216 |
| 2016 | 217 |
| 2017 | 215 |
| 2018 | 194 |
| 2019 | 232 |
| 2020 | 198 |
| 2021 | 191 |
| 2022 | 195 |
| 2023 | 171 |
| 2024 | 141 |
| 2025 | 155 |
| 2026 | 83 |
Where
Open the mapLatest cases
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\") = 2011
AND 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 year(c."eventDate") = 2011 AND 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 ERA12FA123Accident · 1 fatalField investigationFinal reportAero Commander 560-F · Venice, FLThe pilot’s failure to maintain adequate airspeed during a single-engine approach, which resulted in an aerodynamic stall. Contributing to the accident was the total loss of power in the left engine due to a failed No. 2 connecting rod bearing.NTSB ERA12CA124Accident · No injuriesData collectionFinal reportChapel Robert B Aerial · Simsbury, CTThe pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.NTSB CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.NTSB ERA12FA115Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Morristown, NJThe airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…NTSB WPR12LA065Accident · Minor injuriesLimited investigationFinal reportBell 407 · Rock Springs, WYThe unauthorized operation of the helicopter by a non-certificated and unqualified individual who failed to maintain helicopter control.NTSB ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.NTSB CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…NTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.NTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.NTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…NTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.NTSB ERA12WA105Accident · 2 fatalForeign investigationCirrus SR20 · Minas Gerias, BrazilOn November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…NTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.NTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.NTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.NTSB CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.NTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.NTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.NTSB ERA12WA099Accident · 4 fatalForeign investigationCessna 210 · Cuiaba, BrazilOn November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…NTSB CEN12LA061Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Gladewater, TXThe pilot’s failure to maintain control of the airplane during the landing and attempted go-around in a gusty crosswind.NTSB CEN12WA092Accident · 1 fatalForeign investigationSocata TBM 700 · Lyon, FranceNTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.NTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB ERA12CA054Accident · Serious injuriesData collectionFinal reportAeros Trike · Amherst, VAThe student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.NTSB ANC12FA006Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Iliamna, AKThe pilot's loss of control due to sudden medical impairment or incapacitation.NTSB ERA12FA052Accident · 2 fatalField investigationFinal reportInterplane S R O Skyboy · Miami, FLThe pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…NTSB CEN12CA041Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Pueblo, COThe certified flight instructor’s delayed remedial action. Contributing to the accident was the student pilot's failure to maintain control prior to the landing.NTSB ERA12WA041Accident · Serious injuriesForeign investigationBell 412 · Santa Rosa, VenezuelaOn October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB CEN12CA064Accident · No injuriesData collectionFinal reportCessna 210F · Phillipsburg, KSThe pilot’s improper recovery from a bounced landing.NTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.NTSB ERA12FA006Accident · 1 fatalField investigationFinal reportHarry L. Weber Arion LI · Hedgesville, WVAn aerodynamic stall at low altitude due to the pilot’s acute cardiac event.NTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…NTSB CEN12CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hibbing, MNThe private pilot's failure to maintain control of the helicopter during the landing flare.NTSB ERA12CA013Accident · Minor injuriesData collectionFinal reportLoehle Loehle P-40 · Tullahoma, TNThe pilot's delayed decision to abort the takeoff.NTSB WPR11LA469Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ahwahnee, CAThe pilot’s failure to maintain adequate main rotor rpm during the landing approach, which resulted in a loss of control.NTSB WPR11CA467Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Douglas, WYThe pilot's failure to maintain yaw control of the helicopter while hover taxiing in gusty wind conditions.NTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.NTSB CEN11CA682Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Texarkana, ARThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR11LA460Accident · Serious injuriesLimited investigationFinal reportPiper PA23 · Truckee, CAThe pilot's failure to maintain an airspeed at or above the airplane's minimum controllable airspeed, which resulted in a loss of airplane control. Contributing to the accident was the partial loss of power from the left engine as a result of a clogged fuel…NTSB WPR11LA458Accident · Serious injuriesLimited investigationFinal reportAviat Pitts S-2B · Redlands, CAThe pilot’s failure to maintain airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s impairment from alcohol.NTSB CEN11FA652Accident · 2 fatalField investigationFinal reportConcannon Milton Radial ROC · Socorro, NMThe pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…NTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.NTSB CEN11LA648Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ocate, NMThe pilot’s failure to apply carburetor heat, which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB ANC11CA098Accident · No injuriesData collectionFinal reportCessna 180A · McGrath, AKThe pilot's loss of control when encountering a downdraft during the initial climb after takeoff, resulting in a collision with terrain.NTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…NTSB ERA11WA498Accident · 3 fatalForeign investigationBeech G-58 · Parana, BrazilOn September 13, 2011, about 1135, Universal Coordinated Time (UTC), a Hawker Beechcraft G-58, Brazilian registration PR-KST, operated by a private owner, lost control during a climb while enroute to Fortaleza do Guapore` Farm, State of Mato Grosso (SSDP),…