NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 CEN10CA305Accident · No injuriesData collectionFinal reportCessna 337 · Custer, SDA partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.NTSB WPR10LA302Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Richfield, UTThe pilot’s decision to operate the unairworthy airplane with suspected performance deficiencies in a high density altitude and the subsequent partial loss of engine power due to low compression.NTSB ERA10LA296Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Rainelle, WVThe pilot's failure to adequately assess the runway conditions prior to attempting a takeoff and his failure to abort the takeoff in a timely manner resulting in an on-ground collision with trees.NTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.NTSB CEN10LA340Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Salina, KSA partial loss of engine power after takeoff due to thermal damage to three cylinders for undetermined reasons. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB CEN10LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pollard, ARA loss of engine power for undetermined reasons.NTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.NTSB CEN10CA296Accident · Minor injuriesData collectionFinal reportMooney M20M · Port Clinton, OHThe pilot’s delayed decision to abort the landing and his failure to properly reconfigure the airplane during the aborted landing attempt.NTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.NTSB CEN10CA297Accident · Minor injuriesData collectionFinal reportCessna 180 · Humble, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB WPR10LA276Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · San Diego, CAThe inadvertent opening of the aircraft canopy during the takeoff climb, which distracted the pilot and resulted in his failure to maintain aircraft control. Contributing to the accident was a lack of guidance in the manufacturer's pilot operating handbook…NTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.NTSB CEN10FA291Accident · 2 fatalField investigationFinal reportBell 222 · Midlothian, TXThe fracture of a swashplate drive pin as a result of hydrogen embrittlement due to an unknown source, which resulted in an in-flight breakup of the main rotor system during cruise flight.NTSB CEN10CA361Accident · Serious injuriesData collectionFinal reportPiper PA-20 · Dover, ARThe pilot's failure to maintain clearance from the trees during takeoff.NTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.NTSB ANC10FA048Accident · 1 fatalField investigationFinal reportCessna U206F · Anchorage, AKThe pilot’s decision to load the airplane well beyond its allowable weight and center of gravity limits, resulting in a loss of control during the initial climb. Contributing to the severity of the injuries was the pilot’s decision to allow two child…NTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.NTSB WPR10LA271Accident · No injuriesLimited investigationFinal reportShaffer William C Quicksilver MX II SP · Visalia, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain runway alignment while landing.NTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.NTSB ERA10LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Dania Beach, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN10RA345Accident · No injuriesForeign investigationBell 412 · Campeche, MexicoOn June 1, 2010, approximately 1123 central daylight time, a Bell Helicopter model 412EP, Mexican registration XA-HSI, made a successful water landing after a loss of tail rotor control in the Gulf of Mexico near Campeche, Mexico. The helicopter was en route…NTSB CEN10LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Wellington, KSA fire of undetermined cause that originated in the airplane's cabin.NTSB CEN10CA311Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Okmulgee, OKThe student pilot’s inadvertent retraction of the nose landing gear and the flight instructor's delayed response.NTSB CEN10CA289Accident · No injuriesData collectionFinal reportCessna 172S · Greenfield, INThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN10CA280Accident · No injuriesData collectionFinal reportHughes 269A · Cannon Falls, MNThe pilot's failure to maintain rotor speed during the autorotation, which resulted in an excessive sink rate and a hard landing.NTSB ANC10CA047Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Port Alsworth, AKThe pilot's selection of unsuitable terrain for takeoff and inability to abort the takeoff, resulting in an overrun into the water.NTSB WPR10LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Nelson, CAThe pilot's loss of aircraft control during an undetermined phase of flight, which resulted in an aerodynamic stall/spin and subsequent collision with terrain.NTSB WPR10CA282Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Chandler, AZThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB ERA10CA289Accident · No injuriesData collectionFinal reportCessna 172N · Sterling, MAThe pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.NTSB ERA10CA288Accident · Minor injuriesData collectionFinal reportCessna 182H · Oliver Springs, TNThe pilot's failure to execute a go-around, which resulted in a long landing, runway overrun, and the airplane's subsequent descent into a stream.NTSB DCA10WA065Incident · No injuriesForeign investigationBoeing 747 · Heathrow Intl Apt, United KingdomOn May 31, 2010, a Cathay Pacific Boeing 747-400F, B-HKH, experienced a flap retraction anomaly after landing at London Heathrow International Airport (LHR), London, United Kingdom. The incident is being investigated by the British Air Accidents Investigation…NTSB CEN10WA293Accident · 4 fatalClass 5 · ForeignCirrus SR22 · Bielefeld, GermanyOn May 31, 2010, at 0852 coordinated universal time, a Cirrus SR-22, SP-AVC, was substantially damaged upon impact with terrain following a loss of control while on approach to the Bielefeld-Windelsbleiche airport (EDLI), Nordrhein-Westfalen, Germany. The…NTSB CEN10CA300Accident · No injuriesData collectionFinal reportCessna 172K · Wellington, KSThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller.NTSB CEN10CA286Accident · Minor injuriesData collectionFinal reportCessna 150M · Glasco, KSThe pilot’s delay in applying full power to arrest a sink rate at low altitude.NTSB WPR10LA274Accident · Serious injuriesLimited investigationFinal reportSmithwick/Treidel Tukan · Prairie, IDThe pilot's loss of control of the weight-shift-controlled airplane during takeoff for undetermined reasons.NTSB WPR10FA273Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Lincoln, MTThe pilot’s decision to continue flight into an area of low ceilings and low visibility and his failure to maintain sufficient clearance from mountainous terrain.NTSB ERA10TA292Accident · No injuriesFinal reportBell 206B · Memphis, TNThe pilot’s failure to maintain adequate rotor rpm and the certificated flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA10CA295Accident · No injuriesData collectionFinal reportCessna 182D · Chateaugay, NYThe pilot's misjudgedment of his speed and distance during landing, which resulted in an overrun.NTSB CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.NTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…NTSB CEN10CA284Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mount Pleasant, TXThe pilot's failure to maintain adequate airspeed while turning resulting in a stall.NTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.NTSB WPR10CA269Accident · No injuriesData collectionFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Koosharem, UTThe pilot's failure to maintain clearance from a sign on the side of his landing area (a dirt road). Contributing to the accident was the pilot's failure to perform a fly-by of the road to check for hazards.NTSB WPR10CA267Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Palo Alto, CAA total loss of engine power on final approach due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ERA10CA287Accident · Minor injuriesData collectionFinal reportLepow David A Prgsv Aerdyn SEA REY · Chester, PAThe airplane’s collision with a submerged object during landing, which resulted in a nose-over.NTSB CEN10WA379Accident · 2 fatalForeign investigationBeech E-55 · Ciutadella de Menorca, SpainNTSB CEN10LA295Accident · Minor injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Amarillo, TXThe fracture of the fuel pump housing for undetermined reasons.