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 ERA11FA391Accident · 7 fatalField investigationFinal reportCessna 421C · Demopolis, ALThe pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…NTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN11LA472Accident · No injuriesLimited investigationFinal reportCessna 150J · Lacassine, LAA total loss of engine power due to fuel exhaustion, as a result of the pilot's improper fuel planning.NTSB CEN11LA466Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-1 · Benton, KSThe pilot did not maintain sufficient airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and spin.NTSB CEN11FA469Accident · 1 fatalField investigationFinal reportBowie Richard Sonerai II · Dudley, MOFuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.NTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.NTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.NTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…NTSB WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…NTSB ENG11WA039Incident · No injuriesForeign investigationBoeing 767 · Tokyo, JapanOn July 8, 2011, at 0920 Japan standard time, an All Nippon Airways Co., Ltd. Boeing 767-300 airplane, registered in Japan as JA8674, experienced turbine damage in the No. 1 (left) engine, a General Electric CF6-80C2. The airplane was climbing through 9,200…NTSB DCA11RA080Accident · 77 fatalForeign investigationBoeing 727 · Kisangani, Congo - KinshasaOn July 8, 2011 about 1311 UTC (1511 local time), a Hewa Bora Airways Boeing 727-100, 9Q-COP, a domestic scheduled commercial flight, operating as Hewa Bora flight 952, collided with the ground during visual approach to runway 31 at Bangoka International…NTSB CEN11WA493Accident · 2 fatalForeign investigationBell 206 - L4 · Tecpan, GuatemalaOn July 8, 2011, about 2145 coordinated universal time (UTC), a Bell 206L-4 helicopter, TG-MUK, was destroyed after impacting wires and terrain near Tecpan, Guatemala. The pilot was seriously injured and two passengers were fatally injured. The accident…NTSB CEN11WA471Accident · 1 fatalForeign investigationPiper PA18 · Undrom, SwedenOn July 8, 2011, approximately 1920 universal coordinated time, a Piper PA-18-A150 collided with trees and impacted terrain near Undrom, Sweden. The pilot was fatally injured. The airplane was destroyed. The local flight departed River Aangermanaelven at an…NTSB CEN11FA465Accident · 1 fatalField investigationFinal reportPipistrel Taurus · Durango, COThe pilot’s loss of control during the off-airport landing in strong winds, which resulted in a hard landing.NTSB WPR11WA488Accident · No injuriesForeign investigationEurocopter BO105 · Tari, Papua New GuineaOn July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…NTSB WPR11LA315Accident · No injuriesLimited investigationFinal reportBeech V35B · Oljato, UTThe pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.NTSB WPR11CA323Accident · No injuriesData collectionFinal reportTL Ultralight Sro Stingsport · Soda Springs, IDThe pilot's improper landing flare and failure to maintain directional control during the landing.NTSB CEN11LA464Accident · Serious injuriesLimited investigationFinal reportBurtner Charles W Derjager D IX · East Liverpool, OHThe pilot's improper landing flare, which resulted in a porpoised landing and propeller contact with the runway, which caused an in-flight disintegration of the propeller during the go-around, and subsequent collision with trees.NTSB ANC11LA060Accident · Serious injuriesLimited investigationFinal reportSonex / John D. McCarter Waiex · Sterling, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall following a loss of engine power for undetermined reasons.NTSB WPR11LA311Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Hesperia, CAThe separation of the end baffle cone inside the muffler, which blocked airflow through the engine after takeoff and resulted in a loss of engine power and an off-airport landing into obstacles.NTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.NTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.NTSB ERA11CA384Accident · No injuriesData collectionFinal reportAeronca 7DC · Greenland, NHThe pilot's improper flare, which resulted in a bounced landing, and subsequent loss of control during an attempted go-around maneuver.NTSB CEN11LA460Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Pine Bluff, ARThe use of an incorrect mounting bolt by maintenance persons to attach the engine torque sensor, which resulted in an internal failure of the torque sensor and subsequent loss of engine power due to fuel starvation.NTSB CEN11CA454Accident · No injuriesData collectionFinal reportVan Kalker John E RAF 2000 GTX SE · Decker, INThe improper landing flare, which resulted in the gyroplane's main rotor contacting the runway surface.NTSB ANC11CA058Accident · Serious injuriesData collectionFinal reportAviat A-1B · Palmer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB WPR11LA306Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Yacoit, WAThe pilot’s failure to maintain clearance from terrain.NTSB WPR11LA305Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Nogales, AZThe pilot did not maintain airplane control during the initial climb.NTSB WPR11CA310Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Whitefish, MTThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of recent experience in a tailwheel equipped airplane.NTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.NTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.NTSB ERA11CA381Accident · Minor injuriesData collectionFinal reportSchleicher ASW-28 · Hugguenot, NYThe pilot's failure to attain the proper touchdown point during a tailwind landing.NTSB ERA11CA377Accident · Serious injuriesData collectionFinal reportCessna 150M · Ridgeway, VAThe pilot's decision to takeoff using a flap setting higher than the manufacturer's recommended setting for takeoff.NTSB CEN11LA451Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · New Carlisle, OHThe pilot's failure to conduct a go-around once he recognized he was going to land long on the runway.NTSB ANC11IA059Incident · No injuriesIncident investigationFinal reportHughes 500D · McGrath, AKA fatigue fracture of the governor-to-fuel control Pc line, which resulted in a partial loss of engine power.NTSB WPR11LA324Accident · Serious injuriesLimited investigationFinal reportM Squared Sprint 1000 · Heise, IDThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB WPR11FA304Accident · 2 fatalField investigationFinal reportCessna 180D · Santa Paula, CAThe pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.NTSB WPR11CA314Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Spanish Fork, UTThe pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control.NTSB ERA11LA400Accident · No injuriesLimited investigationFinal reportFessenden Alfred Expermental RV-4 · Fort Drum, FLA total loss of engine power for undetermined reasons.NTSB ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.NTSB ERA11LA380Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Lakewood, NJThe pilot’s inadequate yaw control of the helicopter while hovering.NTSB ERA11CA378Accident · Minor injuriesData collectionFinal reportBeech 77 · Jonesville, VAThe pilot's delayed decision to abort the takeoff.NTSB CEN11WA458Accident · 1 fatalForeign investigationVans RV6 · Shoreham, United KingdomOn July 4, 2011, at 1528 Universal Coordinated Time (UTC), a Vans RV-6A single-engine airplane, G-RVCG, and a Diamond DA-40 single-engine airplane, G-CEZR, collided in midair while maneuvering near Shoreham, West Sussex, United Kingdom. G-RVGC was destroyed…NTSB CEN11CA461Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Amarillo, TXThe pilot's failure to lower the landing gear prior to landing.