NTSB investigations, 2011
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.NTSB WPR11CA208Accident · No injuriesData collectionFinal reportDoktor Fiberglas H101 Salto · Peoria, AZThe glider's encounter with turbulence and loss of lift, which resulted in a ditching in a lake.NTSB ERA11CA267Accident · Minor injuriesData collectionFinal reportCessna 182A · Galax, VAThe pilot's inadequate compensation for the wind while on approach for landing.NTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.NTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.NTSB WPR11LA209Accident · No injuriesLimited investigationFinal reportCessna 182B · Colville, WAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA207Accident · No injuriesLimited investigationFinal reportDavison RV-7A · Marsing, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA206Accident · No injuriesData collectionFinal reportTew William P Team Rocket F1 · Heber, UTThe pilot's failure to maintain directional control during landing.NTSB ERA11LA263Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass Aquilla · Starke, FLThe pilot's loss of airplane control while taxiing, which resulted in the weight-shift-controlled airplane becoming inadvertently airborne and subsequently impacting the ground. Contributing to the accident was the pilot's lack of experience in the make and…NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB ERA11CA260Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Belhaven, NCThe pilot's failure to maintain adequate clearance above crops while performing an aerial application flight.NTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN11LA305Accident · Minor injuriesLimited investigationFinal reportD & D Rotorway Exec · Massillon, OHThe excessive wear on the secondary shaft, from the inner bearing race, which resulted in the transmission clutch disengagement and a loss of power to the rotor system.NTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.NTSB CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.NTSB WPR11CA204Accident · No injuriesData collectionFinal reportCessna 172P · Palm Springs, CAThe pilot's failure to maintain aircraft control after landing with a crosswind.NTSB ERA11WA265Accident · 7 fatalForeign investigationEmbraer EMB-810C · Manaus, BrazilOn April 21, 2011, about 1850 coordinated universal time, an Embraer EMB-810C, Brazilian registration PT-EFS, was destroyed when it impacted terrain shortly after takeoff from Eduardo Gomes Airport (SBEG), Manaus, Brazil. The two flight crewmembers and five…NTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.NTSB ERA11CA256Accident · No injuriesData collectionFinal reportVans RV8 · Locust Grove, GAThe pilot's failure to maintain aircraft control during the takeoff roll.NTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.NTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.NTSB ERA11WA268Accident · Minor injuriesForeign investigationGrumman G164 · Volgodonsk, RussiaOn April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…NTSB CEN11LA296Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · New Madrid, MOThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.NTSB CEN11CA298Accident · Minor injuriesData collectionFinal reportAviat A-1C-180 · Greensburg, INThe pilot's decision to land on the grass which contained standing water. Contributing to the accident was the partial loss of power due to carburetor ice.NTSB OPS11IA499Incident · No injuriesIncident investigationFinal reportBoeing 737 · Camp Springs, MDThe misapplication of wake turbulence and instrument flight rules (IFR) separation criteria by air traffic controllers.NTSB CEN11WA297Accident · 2 fatalForeign investigationReims FR172J · Rheindelden, GermanyOn April 18, 2011, approximately 1245 coordinated universal time, a Reims Cessna FR172J, D-EENT, departed the runway and nosed over while landing at Herten-Rheinfelden Aiport (EDTR), Rheinfelden, Germany. The two occupants on-board were both fatally injured.…NTSB ERA11CA247Accident · Serious injuriesData collectionFinal reportBoeing 757-2B7 · Cheltenham, MDThe in-flight encounter with turbulence, resulting in an injury to a cabin attendant.NTSB DCA11WA046Accident · No injuriesForeign investigationBoeing 777 · Copenhagen, DenmarkOn April 17, 2011, about 1300 UTC, a Boeing 777, registered in China as B2078, experienced a tailstrike during a go-around. None of the four flightcrew or one passenger were injured. The airplane sustained substantial damage. The flight was registered to and…NTSB CEN11FA299Accident · 2 fatalField investigationFinal reportClaus Rodney L Christen Eagle II · San Angelo, TXThe pilot did not maintain sufficient altitude to recover from a low-level aerobatic maneuver.NTSB CEN11CA376Accident · No injuriesData collectionFinal reportPiper PA-28-161 · San Angelo, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT-802A · Horseshoe Lake, ARThe pilot's failure to maintain clearance from the tower due to his inadequate visual lookout.NTSB WPR11LA202Accident · No injuriesLimited investigationFinal reportRans S-12 · Marana, AZThe pilot's failure to conduct an adequate preflight inspection, which resulted in a loss of engine coolant during climb due to an unsecured tank cap. Contributing to the accident was the pilot's failure to use available engine power to ensure a landing on an…NTSB WPR11LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Payson, AZThe pilot's decision to conduct a touch-and-go arrival during his first flight to a high elevation airport, which resulted in an improper mixture adjustment and a partial loss of engine power for the takeoff and attempted climbout.NTSB CEN11FA292Accident · Minor injuriesField investigationFinal reportPiper PA-22/20 · New Orleans, LAThe pilot’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.NTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.NTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.NTSB ANC11LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Cold Bay, AKAn in-flight encounter with unforecast turbulence, which resulted in structural damage to the stabilator.NTSB WPR11LA199Accident · Minor injuriesLimited investigationFinal reportZenith CH-750 · Winchester, CAA total loss of engine power during descent for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA249Accident · No injuriesLimited investigationFinal reportBeech D-45 (T-34B) · Linden, NCThe pilot's inadequate takeoff performance planning and procedures, which resulted in an attempted takeoff on a grass runway that was not long enough for the given conditions and airplane configuration.NTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA250Accident · No injuriesData collectionFinal reportAviat A-1B · Burgaw, NCThe pilot's inadvertent application of brakes during the landing rollout.NTSB ERA11CA243Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Latrobe, PAMaintenance personnel’s failure to properly secure the throttle cable to the fuel servo.NTSB DCA11WA048Incident · No injuriesForeign investigationBoeing 767 323 · Barcelona, SpainOn 14 April 2011, at about 08:30 local, a Ryanair Boeing 737-800 and an American Airlines Boeing 767-300 collided while taxiing to runway 25L for takeoff at Barcelona Airport, Barcelona, Spain. The collision was not noticed by either flight crew until after…NTSB CEN11CA290Accident · No injuriesData collectionFinal reportCessna 182H · Park Falls, WIThe student pilot's failure to maintain aircraft control during an aborted landing.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB OPS11IA476Incident · No injuriesIncident investigationFinal reportBeech 400 · Midland, TXInadequate planning and control instructions issued to the pilots involved by the trainee controller operating the local control position and inadequate supervision by the instructor responsible for the position.