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 ERA11LA342Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Linden, NCA partial loss of engine power during initial climb for undetermined reasons.NTSB ERA11CA343Accident · No injuriesData collectionFinal reportCessna 172S · Covington, GAThe pilot's failure to maintain directional control during takeoff.NTSB CEN11CA395Accident · No injuriesData collectionFinal reportNelson Dan H LONG-EZ · Moriarity, NMThe pilot's failure to maintain directional control during the landing.NTSB CEN11CA392Accident · No injuriesData collectionFinal reportCessna 172S · Cortez, COThe pilot's failure to maintain aircraft control while landing in gusty crosswind conditions.NTSB ANC11CA047Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's loss of directional control while landing in a crosswind.NTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.NTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.NTSB WPR11CA257Accident · No injuriesData collectionFinal reportMooney M20K · Page, AZThe pilot's selection of the wrong taxi route and failure to follow prescribed taxi procedures.NTSB ERA11CA341Accident · Minor injuriesData collectionFinal reportCessna 182K · Bentonia, MSThe pilot’s loss of control on the ground during engine start, which resulted in a collision with nearby equipment. Contributing to the accident was the pilot’s improper engine start procedure and improper securing of the seat.NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.NTSB ERA11CA339Accident · No injuriesData collectionFinal reportKendall W R/Mclaughlin J Rans S-10 Sakota · Bennettsville, SCThe pilot's inadequate preflight familiarization of the airstrip.NTSB DCA11CA073Accident · No injuriesData collectionFinal reportBoeing 757-222 · San Fransico, CAThe ramp personnel's failure to visually verify the position of the jetway before beginning the airplane pushback.NTSB CEN11WA394Accident · 1 fatalForeign investigationAmerican Blimp A60PLUS · Reichelheim, GermanyUnder the jurisdiction and control of the German government.NTSB CEN11LA384Accident · Serious injuriesLimited investigationFinal reportFisher Lancair · Azle, TXThe pilot’s inadequate in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ANC11CA044Accident · No injuriesData collectionFinal reportDouglas DC-6B · Cold Bay, AKThe flight crew's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. Contributing to the accident was the flight crew's diverted attention.NTSB ANC11CA043Accident · No injuriesData collectionFinal reportCessna 180H · Skwentna, AKThe pilot's loss of directional control during landing.NTSB WPR11FA256Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Ukiah, ORThe non-instrument-rated pilot's decision to conduct a visual flight rules flight over mountainous terrain into a region covered by clouds, which likely resulted in spatial disorientation and subsequent loss of airplane control.NTSB ERA11CA337Accident · No injuriesData collectionFinal reportFlightstar Flightstar II-SL · Kingston, GAThe pilot's failure to maintain clearance from trees during low-altitude maneuvering flight.NTSB DCA11WA086Incident · No injuriesForeign investigationMcdonnell Douglas MD11 - F · Mumbai, IndiaThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Cargo MD-11F that occurred on June 11, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the…NTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaNTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.NTSB WPR11LA275Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze LX · Montague, CAThe unintended capture of the parachute bridle on a portion of the airframe during the takeoff roll, which resulted in a misinflated or misaligned parachute and an in-flight loss of control.NTSB WPR11CA262Accident · No injuriesData collectionFinal reportCessna 152 · Idaho Falls, IDThe pilot's inadequate landing flare and improper bounced landing recovery.NTSB ERA11LA336Accident · Serious injuriesLimited investigationFinal reportMarks Ca III Kitfox II · Scarborough, METhe pilot’s failure to maintain control of the airplane while taking off with a gusting wind.NTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.NTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.NTSB CEN11CA391Accident · No injuriesData collectionFinal reportBeech F33A · Houston, TXAn in-flight collision with a bird during initial climb.NTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.NTSB CEN11CA387Accident · No injuriesData collectionFinal reportBeech B200 · Waukegan, ILThe lightning strike during an en route descent.NTSB WPR11LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Clarita, CAThe pilot's inadequate preflight verification of the fuel quantity and his inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB ERA11FA332Accident · 2 fatalField investigationFinal reportCessna 152 · Vero Beach, FLThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent spin.NTSB WPR11CA259Accident · No injuriesData collectionFinal reportCessna 172P · Palo Alto, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.NTSB CEN11LA381Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canton, TXThe loss of fuel pressure for undetermined reasons, which resulted in a loss of engine power.NTSB ANC11CA042Accident · No injuriesData collectionFinal reportCessna 182P · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions and his failure to maintain control of the airplane during a water landing.NTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.NTSB CEN11IA379Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIThe failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…NTSB ERA11CA327Accident · Serious injuriesData collectionFinal reportBombardier CL600-2D24 · Florence, SCThe inadvertent in-flight encounter with turbulence, resulting in an injury to a cabin attendant.NTSB CEN11WA380Accident · 4 fatalForeign investigationCessna 182 · Asturias, SpainNTSB CEN11CA410Accident · No injuriesData collectionFinal reportTaft, Malcolm J SR Glastar · Canon City, COA loss of engine power due to an overheated engine as a result of a malfunction of the modified engine cooling system, necessitating a forced landing on unsuitable terrain.NTSB CEN11CA378Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Wagoner, OKThe airplane's collision with a deer during the landing flare and touchdown.NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.NTSB ERA11CA329Accident · No injuriesData collectionFinal reportRemos Remos G-3/600 · Apoka, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a hangar.NTSB CEN11LA372Accident · Minor injuriesLimited investigationFinal reportMooney M20J · North Canton, OHThe pilot’s improper landing flare and recovery from a bounced landing, which resulted in a loss of control.NTSB CEN11CA377Accident · Minor injuriesData collectionFinal reportKamtz Russell H RV-6A · Dexter, NMThe pilot's failure to maintain clearance from a fence while landing at night.NTSB WPR11CA250Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's failure to maintain adequate clearance from terrain while attempting a transition from hovering flight to forward flight over a mesa in windy, downdraft conditions.NTSB WPR11CA247Accident · No injuriesData collectionFinal reportSieber Paul P Nieuport 11 · Bellingham, WAThe pilot's failure to maintain directional control during landing rollout.NTSB ERA11LA326Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Russellville, TNThe pilot’s failure to switch fuel tanks when the fuel was exhausted, which resulted in fuel starvation and a total loss of engine power.