NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.NTSB DCA10FA012Accident · Serious injuriesField investigationFinal reportBoeing 777-200 · New Market, VAThe flight crew’s inadvertent encounter with a small area of cumulous clouds at night that resulted in moderate to severe convectively induced turbulence.NTSB CEN10LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Mineola, TXA loss of engine power due to fuel exhaustion and the pilot's inadequate preflight planning.NTSB WPR10CA057Accident · No injuriesData collectionFinal reportBell 206B · Lyons, ORThe pilot's inadvertent encounter with a vortex ring state (settling with power) condition while he was descending, and his improper initial remedial action.NTSB CEN10LA056Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Montrose, COA loss of engine power due to the pilot’s inadequate preflight planning.NTSB WPR10WA108Accident · 1 fatalForeign investigationCessna A188 · Kojonup, Australia, AustraliaOn November 17, 2009, at 1200 coordinated universal time, a Cessna A188B, Australian registry VH-ZRR, registered to and operated by South West Aerial Services, collided with the terrain while maneuvering during an aerial application flight near Kojonup,…NTSB ERA10CA069Accident · No injuriesData collectionFinal reportParadise USA Paradise P-1 Slsa LW · Plant City, FLThe pilot's improper flare while landing, which resulted in a hard landing.NTSB CEN10LA052Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saginaw, TXThe pilot's inability to maintain control of the airplane due to a pinched trim system wire that resulted in a runaway nose-down pitch trim.NTSB ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.NTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.NTSB WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.NTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.NTSB ERA10CA072Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Coyote · Indian Trail, NCA loss of engine power due to carburetor icing.NTSB CEN10WA051Accident · 1 fatalForeign investigationRobinson R22 · Cheshire, United KingdomOn November 15, 2009, at 1530 coordinated universal time, a Robinson R-22 Beta, G-RIDL, sustained substantial damage on impact with terrain near Cheshire, United Kingdom. The pilot was fatally injuried. The accident flight origination and time are unknown.…NTSB CEN10IA053Incident · No injuriesIncident investigationFinal reportAirbus A319-111 · Kansas City, MOThe in-flight engine ingestion of one or more Lesser Snow Geese (Chen caerulescens caerulescens).NTSB WPR10FA055Accident · 3 fatalField investigationFinal reportAerospatiale AS350BA · Doyle, CAThe pilot became spatially disoriented while maneuvering on a dark night, which resulted in a loss of helicopter control.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…NTSB ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.NTSB ERA10CA065Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Georgetown, KYThe pilot's failure to maintain adequate clearance from the surface during lateral hover, which resulted in dynamic rollover.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB DCA10WA048Accident · 1 fatalForeign investigationEnglish Electric Lightning MK T5 · Bredasdorp, South AfricaOn November 14, 2009 about 1025 UTC, ZU-BEX, English Electric Lightning MK T5, crashed after the pilot reported he had experienced hydraulic failure while conducting aerobatic manuevers during an airshow near Bredasdorp, South Africa. Visual meteorological…NTSB CEN10LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Naytahwaush, MNThe non-instrument rated pilot's decision to continue the flight into known instrument meteorological conditions resulting in spatial disorientation and impact with terrain.NTSB CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…NTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.NTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.NTSB ERA10CA061Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Clarksville, TNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.NTSB DCA10RA011Accident · No injuriesForeign investigationBombardier CL600 2B19 · Kigali, RwandaOn November 12, 2009, at approximately 1115 UTC, a Rwandair Canadian Regional Jet 600 impacted a building after returning to Kigali International Airport after the pilots reported a technical problem. Rwandair flight WB 205 had departed Kigali, Rwanda,…NTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.NTSB WPR10CA058Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-250 · Napa, CAThe pilot's encounter with variable winds which resulted in a hard landing and passenger injury.NTSB CEN10LA046Accident · Serious injuriesLimited investigationFinal reportYounkin J R Mullicoupe · Siloam Springs, ARA loss of engine power due to fuel starvation for undetermined reasons.NTSB ERA10LA056Accident · Serious injuriesLimited investigationFinal reportHawker Beechcraft B200 · Greer, SCA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to visually verify that sufficient fuel was onboard prior to flight.NTSB ERA10CA058Accident · Serious injuriesData collectionFinal reportCessna 150 · York, PAThe pilot's inadvertent encounter with a rotating propeller.NTSB DCA10RA031Accident · No injuriesForeign investigationBeech 1900 - D · Nairobi, KenyaOn November 9, 2009 about 0517 UTC, Kenyan registry 5Y-VVQ, a Beech 1900D, a chartered cargo flight, had a loss of control and collided with the ground during a visual approach for landing at Wilson Airport, Nairobi, Kenya. The airplane had turned back to…NTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.NTSB WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.NTSB ERA10LA059Accident · No injuriesLimited investigationFinal reportCessna A188B · Ripley, MSThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to water in the fuel.NTSB ERA10LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Luray, VAThe pilot's premature rotation and liftoff and her subsequent failure to recognize and correct for the influence of ground effect on the airplane's takeoff performance.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.NTSB CEN10FA044Accident · 3 fatalField investigationFinal reportBeech A36 · Spring Branch, TXThe pilot's failure to maintain control of the airplane during cruise flight in instrument meteorological conditions. Contributing to this accident was the pilot’s lack of recent experience in flying in instrument meteorological conditions.NTSB CEN10CA048Accident · No injuriesData collectionFinal reportCessna 150L · Galion, OHThe student pilot's failure to maintain directional control.NTSB WPR10LA048Accident · 3 fatalLimited investigationFinal reportPiasecki/Pike PV-18 · Adelanto, CAThe pilot’s failure to maintain clearance from powerlines during en route flight.NTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.NTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.NTSB CEN10CA045Accident · No injuriesData collectionFinal reportCessna 150H · Paoli, INThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR10CA054Accident · No injuriesData collectionFinal reportCirrus SR20 · Santa Barbara, CAThe pilot's improper flare, which resulted in a hard landing and porpoise pilot induced oscillation.NTSB OPS10IA002Incident · No injuriesIncident investigationFinal reportAirbus A320 · Cortez, COThe failure of the ACA795 flight crew to monitor and/or switch to the appropriate air traffic control frequency.