NTSB investigations, 2011
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB DCA11FA052Accident · No injuriesField investigationFinal reportBoeing 737 · Greenville, MSThe failure of a utility pipe beneath the ramp surface, which caused a localized void in the soil and resulting reduction in the load bearing capability of the ramp.NTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.NTSB ANC11CA029Accident · Serious injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's loss of aircraft control during final approach in gusty wind conditions, resulting in a hard landing.NTSB ENG11WA031Incident · No injuriesForeign investigationBoeing 747 · Lahore, PakistanOn May 5, 2011, at 16:20 UTC, a Saudi Arabian Airlines Boeing 747-300 airplane, registration HZ-AIR, that was equipped with Rolls-Royce RB211-524 engines, had the No. 4 engine make an uncommanded increase to full power as the crew started to advance the…NTSB CEN11LA323Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Arriba, COThe pilot’s controlled flight into terrain for undetermined reasons.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB WPR11CA198Accident · No injuriesData collectionFinal reportGrumman G-164 · Princeton, CAThe pilot’s failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB ERA11LA282Accident · No injuriesLimited investigationFinal reportPfouts Alfred L Senior Aero SPT D260 · Palm Coast, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA286Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing.NTSB CEN11LA320Accident · No injuriesLimited investigationFinal reportCommander 114-B · Sandusky, OHThe pilot's inadequate directional control while landing in a variable crosswind.NTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.NTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB ERA11LA278Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B2 · Camden, SCThe instructor pilot did not maintain adequate helicopter control while maneuvering, which resulted in a hard landing.NTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.NTSB ERA11CA277Accident · No injuriesData collectionFinal reportCessna A185F · Ocean City, NJThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB WPR11IA213Incident · No injuriesIncident investigationFinal reportCessna 421B · Truckee, CAFatigue failure of the right flap extend cable during the landing approach.NTSB ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.NTSB CEN11CA314Accident · No injuriesData collectionFinal reportPrichard Kevin Legacy 2K · Kansas City, MOThe pilot's misjudgment of the landing area, which resulted in the airplane touching down on a grass area adjacent to the runway and between parallel taxiways.NTSB WPR11LA216Accident · No injuriesLimited investigationFinal reportDralle RV-8 · Livermore, CAThe pilot's decision to exit the runway while still traveling at an excessive speed and his subsequent loss of directional control.NTSB ERA11FA272Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Indiana, PAThe pilot's operation of the helicopter at a low-forward airspeed out of ground effect, which resulted in the helicopter’s loss of translational lift and tail rotor authority and the pilot’s subsequent loss of helicopter control.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB ERA11CA275Accident · No injuriesData collectionFinal reportBeech A23 · Hammonton, NJThe pilot's failure to maintain directional control during the aborted takeoff.NTSB CEN11FA312Accident · 1 fatalField investigationFinal reportCombs Earl W Kitfox Speedster · Elephant Butte, NMThe pilot's loss of control of the airplane for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA215Accident · No injuriesData collectionFinal reportCessna 185A · Bend, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA11CA279Accident · No injuriesData collectionFinal reportFranke Harry C Avid Flyer B · Somerset, PAThe pilot’s failure to hold full power for takeoff.NTSB ERA11CA273Accident · No injuriesData collectionFinal reportCessna 172M · Suchez, GAThe failure of the pilot to initiate a go-around and his excessive airspeed on the final landing approach.NTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.NTSB ERA11CA270Accident · No injuriesData collectionFinal reportCessna 182T · East Hampton, NYThe pilot's failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion.NTSB ERA11LA290Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Albion, NYA bearing failure in the engine’s supercharger section, which resulted in a total loss of engine power during flight. Contributing to the accident was the soft soil of the forced landing site.NTSB CEN11LA315Accident · No injuriesLimited investigationFinal reportHughes 269B · Edgerton, INA loss of clearance between the tail rotor drive shaft and the tailboom bulkhead for undetermined reasons, which resulted in the overstress failure of the drive shaft.NTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB CEN11CA331Accident · Minor injuriesData collectionFinal reportCessna 172R · Fort Worth, TXThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.NTSB CEN11CA291Accident · No injuriesData collectionFinal reportCessna A185F · Hot Springs, ARThe pilot’s improper recovery from a bounced landing.NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.NTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN11CA321Accident · No injuriesData collectionFinal reportChang RV-10 · Minford, OHA loose fuel line fitting, which caused a fuel leak and subsequent in-flight fire.NTSB CEN11CA309Accident · No injuriesData collectionFinal reportCessna 208B · El Paso, TXThe pilot's loss of control as result of the gusting wind.NTSB ERA11WA276Accident · 2 fatalForeign investigationRobinson R22 · Sulmona, ItalyOn April 26, 2011, at 1743 coordinated universal time (1843 local time), a Robinson R22, Italian registration I-ETEC, was destroyed when it impacted power lines near Sulmona, L'Aquila, Italy. The pilot and the observer were fatally injured. The flight, which…NTSB DCA11IA047Incident · No injuriesIncident investigationFinal reportBoeing 737-7Q8 · Chicago, ILThe flight crew's delayed deployment of the speedbrakes and thrust reversers, resulting in insufficient runway remaining to bring the airplane to a stop. Contributing to the delay in deployment of these stopping devices was the flight crew's inadequate…NTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.NTSB DCA11WA051Incident · No injuriesForeign investigationBoeing 737 · Stockholm, SwedenOn April 25, 2011, at 0532 UTC, a Boeing 737-800, registration EI-DAD, experienced multiple electrical problems while airborne. No injuries occurred and the airplane was not damaged. The flight was registered to and operated by Ryanair, Ltd. and was being…NTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.