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 DCA11WA090Incident · No injuriesForeign investigationBoeing 777 · Cairo, EgyptOn July 29, 2011, a Boeing B777-200, registration SU-GBP, operated by EgyptAir, experienced a fire in the right hand lower portion of the cockpit area, adjacent to the electronic flight bag and an electrical power panel. The aircraft was in the process of…NTSB DCA11FA091Accident · Serious injuriesField investigationFinal reportBoeing 747-422 · Tangshan, Chinaan inadvertent encounter with convectively induced turbulence likely due to radar limitations and convective weather developing upwards into the flight path.NTSB CEN11WA602Accident · No injuriesForeign investigationMD Helicopters MD 900 · Leeds, United KingdomOn July 29, 2011, at 0901 universal coordinated time (UTC), an MD Helicopters, Inc. MD 900, United Kingdom registration G-CEMS, sustained substantial damage during a landing near Leeds, United Kingdom. The investigation is under the jurisdiction of the United…NTSB CEN11WA538Accident · 1 fatalForeign investigationPiper PA38 · Greater Manchester, United KingdomOn July 29, 2011, about 1123 coordinated universal time (UTC), a Piper PA-38-112 airplane, United Kingdom registration G-RVRF, was substantially damaged during an in-flight collision with terrain in Greater Manchester, United Kingdom. One occupant of the…NTSB CEN11LA539Accident · Serious injuriesLimited investigationFinal reportHurley Richard A Cavalier SA102.5 · Salem, IAThe partial loss of engine power due to the formation of carburetor ice.NTSB ERA11LA429Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pahokee, FLThe flight instructor's misjudgment of the airplane's position and airspeed relative to the runway while returning to the airport after a partial loss of engine power. Contributing to the accident was the separation of the engine's No. 3 cylinder exhaust…NTSB ERA11FA426Accident · 1 fatalField investigationFinal reportTaylorcraft BL-65 · Winterville, NCA loss of airplane control for undetermined reasons as the autopsy was unable to reveal any definitive conditions that would have led to the loss of control.NTSB CEN11LA530Accident · Serious injuriesLimited investigationFinal reportChristiansen Don E Do RV-4 · Fort Worth, TXA total loss of engine power due to carburetor icing.NTSB CEN11CA545Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Forest City, IAThe pilot's inadequate visual lookout during an aerial application run, which resulted in an in-flight collision with a windmill.NTSB CEN11CA524Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Creston, ILThe pilot's failure to maintain adequate skid clearance from the helicopter cart during landing, resulting in a dynamic rollover.NTSB CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.NTSB WPR11WA351Accident · 1 fatalForeign investigationRobinson R22 · Fitzroy Crossing, Australia, AustraliaOn July 27, 2011, at 0930 universal coordinated time, a Robinson R-22 Beta, VH-YOL, registered to and operated by a private owner, collided with terrain near Fitzoy Crossing, Australia. The helicopter was substantially damaged and the pilot, the sole…NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.NTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.NTSB DCA11RA087Accident · 2 fatalClass 5 · ForeignBoeing 747 · Jeju Island, South KoreaNTSB CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.NTSB CEN11CA517Accident · Serious injuriesData collectionFinal reportKubicek BB85 · Hartsel, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.NTSB ANC11WA070Accident · 3 fatalForeign investigationBeech · Hokkaido, JapanOn July 27, 2011, about 1728 Alaska daylight time, a Beechcraft A36 airplane, Japanese registration JA4215, crashed under unknown circumstances on Mt. Tsurugi, near Memuro Town, Kasai District, Hokkaido, Japan. Three people aboard received fatal injuries, and…NTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.NTSB ERA11CA423Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Quinton, VAThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ENG11WA044Incident · No injuriesForeign investigationBoeing 747-230F · Liege, Belium, BelgiumOn July 26, 2011, a C.A.L. Cargo Airlines Boeing B747-230F took off from Liège Airport (LGG)Belium and during the initial climb, about 1000 feet above the ground, the crew heard a loud noise (bang) in the No. 2 (inboard left) engine, a GE CF6-5E2 turbofan…NTSB DCA11WA088Incident · No injuriesForeign investigationBoeing 737 · Pemir, LatviaOn July 26, 2011, a Boeing 737-300, Latvian registration YL-BBR, operated by Air Baltic, experienced a depressurization while enroute from Antalya, Turkey, to Riga, Latvia. There were no injuries to the 6 crew and 138 passengers. The incident is being…NTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.NTSB CEN11CA519Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · Colorado Springs, COThe pilot's failure to maintain proper approach speed and his inadequate recovery from a bounced landing.NTSB CEN11CA516Accident · Serious injuriesData collectionFinal reportCessna 150F · Harbor Beach, MIThe pilot's delay in using carburetor heat while operating in carburetor icing conditions, resulting in carburetor ice and subsequent partial loss of engine power.NTSB WPR11LA356Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Brewster, WAThe pilot did not maintain main rotor rpm while hovering in gusting wind conditions.NTSB WPR11LA346Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Torrington, WYThe carburetor’s failure to meet its operating limits at the low range, which resulted in a loss of engine power when the pilot reduced power for landing.NTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…NTSB CEN11LA514Accident · No injuriesLimited investigationFinal reportEvens RV4 · Monroe City, MOA total loss of engine power for undetermined reasons.NTSB CEN11LA512Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Anderson, INThe fatigue failure of the propeller governor speeder spring, which resulted in the pilot’s inability to control engine output power.NTSB CEN11LA506Accident · No injuriesLimited investigationFinal reportGottschalk John R John 1 · Oshkosh, WIThe pilot's inadequate preflight planning, which led to the power required exceeding the power available and resulted in a loss of lift and subsequent hard landing.NTSB CEN11FA507Accident · 1 fatalField investigationFinal reportSikorsky UH-34D · Wilton, IAThe inadequate performance planning by the pilot that resulted in reduced climb capability while transitioning to an out-of-ground effect hover with a left pedal turn.NTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.NTSB ANC11LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe loss of engine power for an undetermined reason, resulting in the ditching and sinking of the airplane in ocean waters.NTSB WPR11LA370Accident · No injuriesLimited investigationFinal reportPiper J5A · Biddle, MTFailure of the left main landing gear strut during the landing roll due to a preexisting crack.NTSB WPR11CA368Accident · No injuriesData collectionFinal reportCessna R172K · Sandy, ORThe pilot's improper flare which resulted in a hard landing.NTSB WPR11CA347Accident · No injuriesData collectionFinal reportCessna 182B · Sandy, ORThe pilot's failure to maintain adequate clearance between the airplane and ground obstacles.NTSB ERA11LA418Accident · No injuriesLimited investigationFinal reportFloyd Joseph B RV6 · Hartford, KYA loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.NTSB ERA11LA417Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Sagaponack, NYThe loss of engine power for undetermined reasons.NTSB ERA11CA419Accident · No injuriesData collectionFinal reportCessna 177 · Americus, GAThe CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11WA510Accident · 1 fatalForeign investigationRobinson R44 II · Cornwall, United KingdomOn July 24, 2011, about 1528 coordinated universal time (UTC), a Robinson R44 II helicopter, United Kingdom registration G-ROTG, was substantially damaged during an in-flight collision with terrain in Cornwall, United Kingdom. The pilot sustained fatal…NTSB CEN11FA500Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Rantoul, ILThe pilot did not maintain airplane control during takeoff with approaching thunderstorms. Contributing to the accident was the pilot's decision to depart into adverse weather conditions.NTSB CEN11CA518Accident · No injuriesData collectionFinal reportCessna 180D · Oscoda, MIThe pilot's failure to retract the landing gear before a water landing. Contributing to the accident was the pilot's failure to use a checklist.NTSB ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.NTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.NTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.NTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.NTSB WPR11CA357Accident · No injuriesData collectionFinal reportCessna 175 · Greer, AZThe pilot’s improper flare and inadequate recovery from a bounced landing which resulted in a nose gear collapse.