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 ANC12WA011Accident · No injuriesForeign investigationEurocopter AS350-B3 · Higashikagawa, JapanOn September 22, 2011, about 1012 Japan standard time, a Eurocopter AS350-B3 helicopter, Japanese registration JA6522, sustained substantial damage as the result of an in-flight fire in the baggage compartment during cruise flight near Higashikagawa City,…NTSB WPR11LA460Accident · Serious injuriesLimited investigationFinal reportPiper PA23 · Truckee, CAThe pilot's failure to maintain an airspeed at or above the airplane's minimum controllable airspeed, which resulted in a loss of airplane control. Contributing to the accident was the partial loss of power from the left engine as a result of a clogged fuel…NTSB ERA11CA497Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot's failure to maintain the proper glidepath during a power-off landing and the flight instructor's delayed remedial action.NTSB ERA11WA499Accident · 3 fatalForeign investigationBeech 99 · Cap Haitien, HaitiOn September 20, 2011, at 2130 universal coordinated time, a Hawker Beechcraft BE-99A, registered in Haiti as HH-APA, was substantially damaged when it impacted terrain while on approach to the Cap Haitien International Airport (MTCH), Cap Haitien, Haiti. The…NTSB ANC11CA096Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB WPR11LA459Accident · No injuriesLimited investigationFinal reportMcarthur Steen Skybolt · Greenleaf, IDStructural failure of the upper left wing during aerobatic flight.NTSB WPR11LA458Accident · Serious injuriesLimited investigationFinal reportAviat Pitts S-2B · Redlands, CAThe pilot’s failure to maintain airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s impairment from alcohol.NTSB ERA11LA519Accident · No injuriesLimited investigationFinal reportHeinlein George GH125 · Okeechobee, FLThe non-certificated pilot's improper flare on an earlier flight, which resulted in a hard landing, fracture of the right main landing gear bolt, and subsequent collapse of the right main landing gear.NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…NTSB CEN11LA657Accident · No injuriesLimited investigationFinal reportCessna P210N · Longview, TXThe flight's inadvertent encounter with a rare and unforecasted mesoscale gravity wave while on base leg, which resulted in a sudden loss of altitude and subsequent collision with trees.NTSB CEN11FA652Accident · 2 fatalField investigationFinal reportConcannon Milton Radial ROC · Socorro, NMThe pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…NTSB ERA11WA515Accident · 1 fatalForeign investigationPiper PA-34-220T · Jatai Municipality, BrazilOn September 18, 2011, about 2330 universal coordinated time, a Piper PA-34-220T, Brazilian registration PT-GCC, was substantially damaged when it impacted terrain near Jatai Municipality, Goias, Brazil. The certificated pilot was fatally injured. The local…NTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.NTSB CEN11LA658Accident · No injuriesLimited investigationFinal reportMark Divita RV-8 · Lancaster, TXThe failure of the tailwheel to remain locked during a crosswind landing, which resulted in a loss of directional control.NTSB CEN11CA668Accident · No injuriesData collectionFinal reportCessna R172K · Jonesboro, ARThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB WPR11LA457Accident · No injuriesLimited investigationFinal reportCessna 170 · Pahrump, NVA loss of engine power during the landing approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA456Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · San Jose, CAThe pilot's failure to maintain directional control while taxiing due to his distraction by a cockpit warning light.NTSB ERA11WA518Accident · No injuriesForeign investigationGates Lear Jet 35 · Valencia, Carabobo, VenezuelaOn September 17, 2011, about 2135 universal coordinated time, a Gates Lear Jet 35, N535LC, was substantially damaged while landing at the Arturo Michelena Airport (SVVA), Valencia, Carabobo, Venezuela. The two pilots and five passengers were not injured. The…NTSB ERA11FA495Accident · 1 fatalField investigationFinal reportNorth American T-28C · Martinsburg, WVThe pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB DCA11RA100Accident · Serious injuriesForeign investigationEmbraer E190 · Quito, EcuadorOn September 16, 2011, an Ecuadoran Embraer EMB-190, registration HC-CEZ, overran runway 35 while landing at Quito, Ecuador. The airplane was substantially damaged and there were 5 serious injuries among the 97 passengers and 5 crew. The investigation is…NTSB CEN11LA651Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6 · Nunica, MIThe loss of engine power due to fuel starvation during climbout for undetermined reasons, because postaccident examination of the fuel system did not reveal any discrepancies that would have precluded normal engine operation. Contributing to the accident was…NTSB CEN11IA649Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe infiltration of moisture into the windshield heating layer that induced arcing in the heating system that subsequently cracked the windshield.NTSB CEN11CA655Accident · No injuriesData collectionFinal reportBeech B90 · Hillsboro, TXThe pilot's failure to obtain a proper touchdown point, which resulted in a runway undershoot.NTSB CEN11CA654Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 8 · Mingo, IAThe pilot’s failure to maintain control of the balloon’s descent during the landing, which resulted in the balloon having a hard landing in a ditch and causing a passenger to be seriously injured.NTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.NTSB ANC11CA104Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience/training in tailwheel-equipped airplanes.NTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…NTSB WPR11LA452Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Paragonah, UTThe pilot's failure to secure the left tank's fuel cap after refueling the airplane, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR11CA455Accident · No injuriesData collectionFinal reportCessna 180H · Reno, NVThe pilot’s inadequate compensation for the crosswind condition, which resulted in a loss of directional control.NTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…NTSB WPR11FA453Accident · Serious injuriesField investigationFinal reportDacey Venture · Reno, NVA total loss of engine power during the initial climb due to the pilot’s premature activation of the engine's anti-detonant injection system.NTSB WPR11FA450Accident · 1 fatalField investigationFinal reportCone James A RV-6A · West Jordan, UTThe pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.NTSB ERA11CA494Accident · No injuriesData collectionFinal reportMooney M20K · Anderson, SCThe pilot's failure to maintain directional control during an attempted go-around.NTSB ERA11CA492Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Cleveland, GAThe pilot's poor decision to land with a tailwind, which resulted in a runway excursion.NTSB CEN11LA648Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ocate, NMThe pilot’s failure to apply carburetor heat, which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB CEN11LA646Accident · No injuriesLimited investigationFinal reportBell 206B · Spicewood, TXThe pilot did not maintain adequate rotor rpm during a low-altitude maneuvering flight.NTSB CEN11FA645Accident · 2 fatalField investigationFinal reportRemos Aircraft Gmbh Flugzeugba GX · Noblesville, INThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.NTSB ANC11LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Beluga, AKThe total loss of engine power for an undetermined reason.NTSB WPR11CA449Accident · No injuriesData collectionFinal reportCessna 172M · Wendover, UTThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB CEN11CA647Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Pinckneyville, ILThe pilot's failure to conduct a go-around due to his excessive airspeed while on approach to land, which resulted in a runway excursion.NTSB ANC11CA098Accident · No injuriesData collectionFinal reportCessna 180A · McGrath, AKThe pilot's loss of control when encountering a downdraft during the initial climb after takeoff, resulting in a collision with terrain.NTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…NTSB ERA11WA498Accident · 3 fatalForeign investigationBeech G-58 · Parana, BrazilOn September 13, 2011, about 1135, Universal Coordinated Time (UTC), a Hawker Beechcraft G-58, Brazilian registration PR-KST, operated by a private owner, lost control during a climb while enroute to Fortaleza do Guapore` Farm, State of Mato Grosso (SSDP),…NTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.NTSB WPR11LA451Accident · No injuriesLimited investigationFinal reportPeter A Land White Lightning · Lancaster, CAA total loss of engine power during the landing approach due to fuel starvation. Contributing to the accident was the airplane’s inaccurate fuel indicator.NTSB DCA11WA110Accident · Serious injuriesForeign investigationBoeing 777 · Montauk (Atlantic Ocean)The Unfalluntersuchungsstelle - Luftfahrt Accident Investigation Branch of Austria has notified the NTSB of an accident involving a Boeing 777-200 that occurred on September 12, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, Mexico