NTSB investigations, 2011
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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\") = 2011 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 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 WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.NTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.NTSB DCA13WA052Incident · No injuriesForeign investigationBeech 1900 · Goose Bay, CanadaOn 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…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 ERA12WA113Accident · 1 fatalForeign investigationRobinson R44 · Sao Bento do Sul, BrazilOn December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…NTSB ERA12LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLA loss of engine power during takeoff for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB DCA12CA021Accident · No injuriesData collectionFinal reportBoeing 757-351 · Atlanta, GAthe failure of the captain of N303DQ to maintain a safe clearance from N583NW that was stopped on the taxiway.NTSB CEN12LA103Accident · No injuriesLimited investigationFinal reportBeech C23 · Watertown, SDA total loss of engine power during initial climb for undetermined reasons.NTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…NTSB CEN12CA104Accident · No injuriesData collectionFinal reportCessna 421B · Pampa, TXThe pilot's inadequate aircraft control during landing, which resulted in a hard landing.NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…NTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.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 ANC12CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Kaltag, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's self-reported fatigue.NTSB WPR12WA063Accident · 1 fatalForeign investigationCessna 210 · Roma, Australia, AustraliaOn December 7, 2011, at 0530 universal coordinated time, a Cessna 210M, VH-WBZ, collided with terrain near Roma, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was fatally injured. The flight was operated under the…NTSB WPR12LA055Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Davis, CAThe pilot's inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR12CA056Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Waipahu, HIThe certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.NTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…NTSB ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12IA158Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLThe failure of a crankshaft gear tooth due to fatigue, which resulted in the loss of several additional gear teeth and a subsequent total loss of engine power.NTSB ERA12CA096Accident · Serious injuriesData collectionFinal reportThompson Tommy W Loehle P5151 · Courtland, ALThe airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…NTSB DCA12WA018Incident · No injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…NTSB CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.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 ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN12FA098Accident · 4 fatalField investigationFinal reportSocata TB21 · Silverton, COThe non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…NTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.NTSB WPR12LA053Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Oakland, CAThe flight crew’s flight into known severe turbulence associated with mountain wave activity.NTSB WPR12LA052Accident · No injuriesLimited investigationFinal reportBeech 76 · San Carlos, CAThe collapse of the right main landing gear during the turn off the runway due to the failure of the A-frame assembly.NTSB ERA12IA097Incident · No injuriesIncident investigationFinal reportCessna 560XL · Ocoee, FLWater contamination in the pitch trim actuators.NTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.NTSB DCA12WA030Incident · No injuriesForeign investigationBoeing 777 · Maldives, MaldivesThe UAE General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Boeing 777 that occurred on December 2, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of…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 WPR12LA057Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Modesto, CAThe flight's encounter with known severe turbulence associated with mountain wave activity, which resulted in a flight attendant sustaining a broken ankle.NTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.NTSB OPS12IA167Incident · No injuriesIncident investigationFinal reportLearjet 45 · Chicago, ILThe tower local controller did not ensure that the runway was clear of conflict before directing the B737 to cross the runway, and other air traffic control personnel did not effectively intervene when the separation between the two airplanes became…NTSB ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…NTSB ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.NTSB ERA12CA098Accident · No injuriesData collectionFinal reportCessna 172P · Schenectady, NYThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.NTSB ERA12CA095Accident · No injuriesData collectionFinal reportBell 206L-3 · Wingate, NCThe certified flight instructor did not select an adequate landing site for the practice autorotation.NTSB CEN12IA096Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 407 · Gulf Of MexicoThe failure of the compressor section No. 2 bearing due to false brinnelling and fatigue.NTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.NTSB CEN12LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Fredericksburg, TXThe pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB ERA12IA090Incident · No injuriesIncident investigationFinal reportCessna 402B · Nantucket, MAThe failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…NTSB CEN12FA086Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Riverwoods, ILThe pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.NTSB ANC12FA009Accident · 1 fatalField investigationFinal reportCessna 207 · Chuathbaluk, AKThe pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.