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 WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.NTSB CEN09LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28C-235 · Falcon, COA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.NTSB WPR09IA123Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Salt Lake City, UTThe flight crew's failure to maintain clearance from the stationary vehicle while taxiing.NTSB WPR09CA136Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Ogden, UTThe loss of directional control during the landing roll due to the separation of the tailwheel spring retaining clip for unknown reasons.NTSB ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.NTSB CEN09LA170Accident · No injuriesLimited investigationFinal reportBeech B35 · La Luz, NMA loss of engine power due to fuel starvation as a result of a blockage in the right fuel tank vent.NTSB WPR09LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Big Bear Lake, CAThe pilot's failure to maintain clearance from terrain while maneuvering in a ravine. Contributing to the accident was the pilot's decision to continue flight in an area that exceeded the climb rate capabilities of the airplane.NTSB WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.NTSB WPR09CA120Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Lincoln, CAThe pilot's failure to extend the landing gear for landing. Contributing to the accident was the pilot's diverted attention due to an open door and the airport's pilot activated runway lights turning off.NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanNTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.NTSB ANC09LA022Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 / U-6A · Kenai, AKThe flight instructor’s decision to attempt a touch-and-go landing toward rising terrain and with a tailwind, resulting in an in-flight collision with terrain during takeoff.NTSB WPR09CA126Accident · No injuriesData collectionFinal reportErcoupe 415-E · Camas, WAThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB OPS09IA002Incident · No injuriesIncident investigationFinal reportTampa, FLThe controller's issuance of an improper climb clearance to the pilot of Berry Aviation flight 510. Contributing to the incident was the controller's distraction while he searched for a misplaced flight progress strip.NTSB DCA09FA028Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe student pilot's improper flare while landing with a tailwind and the instructor pilot's delayed response.NTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…NTSB ANC09LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKThe pilot's continued flight into adverse weather and his failure to maintain clearance from terrain while on approach in flat light conditions.NTSB WPR09WA138Accident · No injuriesForeign investigationEurocopter EC225 · North Sea, United Kingdom.NTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.NTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.NTSB ERA09FA169Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Deltona, FLThe pilot receiving instruction's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the flight instructor's inadequate supervision and both pilots'…NTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.NTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.NTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.NTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.NTSB ANC09CA020Accident · No injuriesData collectionFinal reportBeech 65-A90-1 · Soldotna, AKThe pilot's misidentification of the runway surface during landing. Contributing to the accident were the snow-covered terrain, and low-light conditions.NTSB ERA09WA167Accident · 13 fatalForeign investigationBell UH-1H · Chanco, ChileNone.NTSB WPR09LA115Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Rialto, CAA partial loss of engine power to one engine during initial climb for undetermined reasons.NTSB ERA09WA174Accident · Minor injuriesForeign investigationCessna 172 · Ica, PeruNone.NTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.NTSB CEN09LA165Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Steamboat Springs, COThe pilot's failure to apply brakes in a timely manner while landing on a snow-packed, ice-covered runway, and his delay in executing a go-around.NTSB ANC09LA019Accident · No injuriesLimited investigationFinal reportConstrucciones Aeronauticas C-212-CC · Kotzebue, AKThe flight crew's decision to continue flight into adverse weather. Contributing to the accident was blowing snow which limited their visibility during final approach to land.NTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…NTSB WPR09CA114Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAA loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.NTSB CEN09WA177Accident · 2 fatalForeign investigationDassault Falcon · Samedan, SwitzerlandThis is under the jurisdiction and control of the Swiss government.NTSB CEN09LA189Accident · No injuriesLimited investigationFinal reportRemos G-3/600 · Hilda, TXThe flight instructor’s failure to maintain clearance from obstacles while maneuvering at low altitude.NTSB CEN09FA164Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Porter, TXThe pilot’s failure to maintain control of the airplane during an aborted landing for undetermined reasons.NTSB ERA09LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJA loss of engine power due to the improper tightening of a fuel hose B-nut by maintenance personnel during engine installation.NTSB CEN09WA163Accident · 3 fatalForeign investigationRobinson R44 · Budaors, HungaryN/aNTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB ERA09CA165Accident · No injuriesData collectionFinal reportHelio H-295 · Clemson, SCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.NTSB ERA09LA158Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lakeville, NYThe pilot's failure to maintain aircraft control following a loss of engine power on the left engine for undetermined reasons.NTSB CEN09CA162Accident · Minor injuriesData collectionFinal reportCameron Balloons V-77 · Terre Haute, INThe loss of the burner pilot light during approach to the landing area and the pilot's failure to relight the burner using alternate sources.NTSB ERA09WA166Accident · 24 fatalForeign investigationEmbraer EMB110 · Coari, BrazilOn February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…