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 WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…NTSB ERA16FA012Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Lake Worth, FLA loss of control for reasons that could not be determined based on the available information.NTSB ERA16CA011Accident · No injuriesData collectionFinal reportPiper PA-32RT-300T · Salisbury, NCThe pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN16FA011Accident · 2 fatalField investigationFinal reportBeech G35 · Eaton, COThe pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…NTSB GAA16CA034Accident · No injuriesData collectionFinal reportCessna 182R · Abilene, TXThe pilot's diverted attention while taxiing, which resulted in a collision with a fence post.NTSB GAA16CA018Accident · No injuriesData collectionFinal reportFurgason James E Vans RV 4 · San Marcos, TXThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB GAA16CA013Accident · No injuriesData collectionFinal reportBeech F33 · Marana, AZThe student pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an inadvertent aerodynamic stall and impact with terrain during recovery by the flight instructor.NTSB ERA16LA010Accident · 1 fatalLimited investigationFinal reportMurray Blair L Free Bird Classic · Kylertown, PAThe pilot's failure to maintain sufficient airspeed during approach for landing, which resulted in an inadvertent aerodynamic stall/spin. Contributing to the accident was the pilot’s lack of flight experience in the accident airplane make and model.NTSB CEN16LA018Accident · No injuriesLimited investigationFinal reportDiamond DA20-C1 · Waskom, TXThe pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion.NTSB CEN16LA008Accident · No injuriesLimited investigationFinal reportBeechcraft A36 · Dallas, TXThe pilot’s improper navigation onto a vehicle service road while taxiing and his subsequent distraction while looking at an airport diagram, which led to the airplane impacting a fence post.NTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…NTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.NTSB GAA16CA012Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Kanab, UTThe pilot's failure to monitor the airplane's movement on the ground while programming the GPS, which resulted in a collision with a pole.NTSB ERA16LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami Beach, FLA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean after the ditching.NTSB CEN16LA007Accident · 1 fatalLimited investigationFinal reportRich Harry A Woodstock I · Decatur, TXThe pilot's failure to maintain adequate airspeed while turning from the downwind to the base leg of the pattern in gusting wind conditions, which resulted in the glider exceeding its critical angle-of-attack and entering an aerodynamic stall/spin at a low…NTSB WPR16LA015Accident · No injuriesLimited investigationFinal reportCessna 310J · Tucson, AZThe insufficient right main landing gear (MLG) down-lock tension due to maintenance personnel's failure to perform a rigging procedure during the airplane's most recent inspection, which resulted in the right MLG collapsing during landing.NTSB ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.NTSB ERA16LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Savannah, GAThe pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…NTSB CEN16LA030Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Albuquerque, NMThe pilot's delay in deflating the balloon envelope completely after landing, which resulted in a loss of control due to a wind gust.NTSB ERA16FA006Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Erwin, TNThe pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.NTSB DCA16CA008Accident · Serious injuriesData collectionFinal reportBoeing 737 3H4 · Pound Ridge, NYhot water spilled from a cup onto the flight attendant's arm resulting in a 2nd degree burn.NTSB CEN16LA019Accident · Serious injuriesLimited investigationFinal reportQuest Kodiak 100 · Sheridan, WYThe loss of airplane control during takeoff for reasons that could not be determined based on the available information.NTSB WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.NTSB GAA16CA014Accident · Serious injuriesData collectionFinal reportKubicek BB · Albuquerque, NMA hard landing which resulted in serious injury to a passenger.NTSB ERA16FA005Accident · 1 fatalField investigationFinal reportPiper PA 38-112 · Jasper, GAThe student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.NTSB WPR16LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Compton, CAA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA004Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Georgetown, CAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA16CA008Accident · No injuriesData collectionFinal reportPiper PA · Glennallen, AKThe pilot's failure to maintain clearance from trees during the approach to land, resulting in a collision with trees.NTSB ERA16LA003Accident · Serious injuriesClass 2 · LimitedFinal reportBeech S35 · Knoxville, TNThe pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.NTSB GAA16CA020Accident · No injuriesData collectionFinal reportBeech A36 · Jasper, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.NTSB GAA16CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Ketchikan, AKThe pilot's failure to maintain directional control during the engine start sequence, which resulted in the helicopter sliding on a steel deck and impacting a crane. Contributing to the accident was the absence of traction material on the helicopter…NTSB GAA16CA005Accident · No injuriesData collectionFinal reportRaytheon A36 · Monterey, CAThe pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB ERA16WA017Accident · 1 fatalForeign investigationEmbraer EMB721C · Corumba, BrazilOn October 6, 2015, about 1200 universal coordinated time, an Embraer EMB721C, Brazilian registration PT-RAM, was substantially damaged when it encountered a wind gust and struck a tree, during takeoff from Guanabara Farm, Corumba, Brazil. The pilot and one…NTSB ERA16LA004Accident · No injuriesLimited investigationFinal reportBeech 58 · Albany, GAThe mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.NTSB CEN16WA009Accident · 2 fatalForeign investigationBell 430 · Xalapa, MexicoOn October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…NTSB CEN16LA012Accident · No injuriesLimited investigationFinal reportRefling RV8 · Bottineau, NDThe pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.NTSB WPR16FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Cedar City, UTThe failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.NTSB GAA16CA007Accident · Minor injuriesData collectionFinal reportBogle Absey C Breezy RLU-1 · Bryan, TXThe pilot's excessive descent rate, which resulted in a hard landing and substantial damage.NTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.NTSB CEN16LA006Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Parkston, SDThe pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.NTSB CEN16LA004Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dexter, MOThe pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.NTSB CEN16LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G · Huntsville, TXThe pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.NTSB GAA16CA010Accident · No injuriesData collectionFinal reportGrosch Starduster TOO SA 30 · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop, left main landing gear collapse, and the left wing striking the runway.NTSB GAA16CA003Accident · Minor injuriesData collectionFinal reportBushmaster Super Bushmaster · Marble Canyon, AZThe pilot's failure to maintain descent rate durring the landing resulting in collision with terrain.NTSB WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.NTSB GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.