NTSB investigations, 2011
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CEN11CA644Accident · No injuriesData collectionFinal reportCessna 120 · Camden, ARThe flight instructor's inadvertent braking during taxi.NTSB CEN11LA642Accident · No injuriesLimited investigationFinal reportPiper PA16 · Muskegan, MIThe pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.NTSB CEN11LA636Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kokomo, INThe loss of engine power following takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA444Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Show Low, AZThe pilot’s failure to maintain directional control during the landing, which resulted in a ground loop.NTSB WPR11CA445Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · San Diego, CAThe pilot's improper recovery from a bounced landing and failure to maintain control during an attempted go-around.NTSB ERA11WA509Accident · 2 fatalForeign investigationRobinson R44 · Rio de Janeriro, BrazilOn September 10, 2011, about 2330 universal coordinated time, a Robinson R44 II, Brazilian registration PR-CEC, was substantially damaged when it impacted wooded terrain during an aerial photography flight, near Rio de Janeiro, Brazil. The foreign…NTSB ERA11CA488Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Leesburg, VAThe pilot did not follow the engine start checklist.NTSB ERA11CA487Accident · Serious injuriesData collectionFinal reportKaribian Hurant Thorp T-18 · Panama City, FLThe pilot's selection of an unsuitable landing site, which resulted in a collision with a culvert.NTSB DCA11WA109Incident · No injuriesForeign investigationBoeing 737 · Phuket, ThailandOn September 10, 2011, at about 1842 local time, a Shanghai Airlines B737-800, registration #B-5088, ran off the side of runway 27 at Phuket International Airport (HKT), Phuket, Thailand, and was able to turn back onto the runway. The aircraft sustained minor…NTSB CEN11LA656Accident · No injuriesLimited investigationFinal reportQuicksilver GT400 · Bolingbrook, ILThe loss of engine power for reasons that could not be determined during postaccident examination of the engine or airframe.NTSB CEN11LA635Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Waukegan, ILThe pilot’s inadequate preflight inspection of the airplane, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the accident were a malfunctioning fuel gauge and air traffic that prevented an on airport landing.NTSB CEN11CA661Accident · No injuriesData collectionFinal reportLuscombe 8A · Huntington, INThe failure of the right main landing gear strut due to internal corrosion.NTSB ANC11CA101Accident · Serious injuriesData collectionFinal reportDouglas DC-8-62F · Yakota, JapanThe passenger's decision to ignore the fasten seatbelt sign, resulting in serious injury to the passenger during a turbulence encounter.NTSB WPR11WA475Accident · 2 fatalForeign investigationCessna 208B · Wamean, West Papua, IndonesiaOn September 9, 2011, at 1223 local time (0323 UTC) a Cessna 208B, Indonesia registry PK-VVE, collided with mountainous terrain 8 nautical miles north east of Wamena Airport, Wamena, West Papau, Indonesia. The aircraft was operated by Susi Air under the…NTSB WPR11CA442Accident · Minor injuriesData collectionFinal reportAir Creation Tanarg · Corvallis, ORThe pilot's failure to maintain clearance from an obstacle while taking off with a gusting crosswind.NTSB WPR11WA484Accident · No injuriesForeign investigationAerospatiale AS350 · Rockhampton, Australia, AustraliaOn September 8, 2011, at 0203 universal coordinated time, an Aerospatiale Industries AS-350BA, VH-RDU, collided with the terrain near Rockhampton, Australia. The helicopter was substantially damaged. Of the three occupants on board, two were fatally injured…NTSB WPR11CA440Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11LA632Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18-150 · Long Lake, WIThe pilot's failure to complete the prelanding checklist, which resulted in the landing gear wheels not being retracted for the water landing.NTSB CEN11FA629Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · West Liberty, OHThe pilot’s improper decision to fly aerobatic maneuvers at low altitude, which resulted in a loss of control and impact with terrain. Contributing to the accident was the pilot’s impairment due to his recent use of multiple impairing drugs.NTSB ANC11LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Galena, AKThe total loss of engine power for undetermined reasons.NTSB CEN11FA634Accident · 1 fatalField investigationFinal reportRiffel Jerris L RV-7A · Winfield, KSThe pilot’s in-flight loss of control. Contributing to the pilot’s fatal injury was his failure to use the available restraint systems, which resulted in him falling through the open canopy when the airplane inverted.NTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.NTSB WPR11CA435Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · Park City, UTThe pilot’s failure to maintain control of the balloon during the landing on uneven ground.NTSB DCA11WA105Incident · Minor injuriesForeign investigationBoeing 737 · Hamamatsu City, JapanOn September 6, 2011, at 22:50 local time (13:50 UTC), a Boeing 737-700, registration JA16AN, operated by Air Nippon Co., Ltd., entered an unusual attitude and lost altitude about 43km south of Hamamatsu City, Shizuoka Prefecture, Japan, as the aircraft was…NTSB DCA11RA098Accident · 8 fatalForeign investigationM7Aero SW3 · Trinidad, BoliviaOn September 6, 2011, an Aerocon Swearingen SA-227 Metroliner, registration CP-2548 performing flight A4-238 from Santa Cruz to Trinidad (Bolivia) with 7 passengers and 2 crew, was on approach to Trinidad when radio contact was lost. The airplane was located…NTSB DCA11CA116Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Cape Coral, FLAn encounter with convective turbulence during the descent.NTSB CEN11CA685Accident · No injuriesData collectionFinal reportCessna A185F · Hays, KSThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB CEN11CA678Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Buena Vista, COThe airplane’s diminished climb performance due to the pilot not leaning the engine mixture enough prior to takeoff in high density altitude conditions and at nearly maximum gross takeoff weight.NTSB CEN11CA633Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Damon, TXThe pilot’s improper fuel management during cruise flight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11LA434Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Saratoga, WYA loss of engine power during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA439Accident · No injuriesData collectionFinal reportCessna 182D · Roundup, MTThe pilot's failure to maintain clearance from an obstacle during the landing flare.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN11FA625Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Mt. Pleasant, WIThe pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…NTSB CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.NTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.NTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.NTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…NTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.NTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.