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 CEN13CA247Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Owatonna, MNThe pilot’s loss of directional control during an aborted landing.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.NTSB ERA13LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB ERA13CA218Accident · Serious injuriesData collectionFinal reportCessna 172P · Davis, WVThe pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.NTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13CA262Accident · Minor injuriesData collectionFinal reportEngineering & Research 415-C · Little Falls, MNThe failure of the airplane's throttle cable.NTSB WPR13TA205Accident · No injuriesFinal reportBell BHT407 · Big Fork, MTThe pilot’s failure to maintain helicopter control while maneuvering over mountainous terrain in strong up/downdrafts and possible mountain wave activity, which resulted in a loss of tail rotor effectiveness.NTSB ERA13LA214Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Knoxville, TNThe loss of engine power during takeoff for a reasons that could not be determined because postaccident examinations and testing revealed no anomalies that would have precluded normal operation.NTSB ERA13CA222Accident · No injuriesData collectionFinal reportCirrus Design SR22T · Milledgeville, GAThe student pilot’s failure to maintain a proper approach path for landing and the flight instructor’s delayed remedial action, which resulted in a runway undershoot and collision with a taxiway sign.NTSB CEN13WA255Accident · No injuriesForeign investigationMcdonnell Douglas 600N · Oaxaca, MexicoOn April 24, 2013, about 2335 universal time coordinated, a McDonnell Douglas MD 600N, XC-AAF, was destroyed when it impacted terrain near Oaxaca, Mexico. The pilot and three passengers on board were fatally injured. The medical flight originated from…NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB CEN13IA270Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Clearwater, FLThe failure of the nose landing gear steering manifold during landing, which resulted in an uncommanded and uncontrollable right turn, and the overhaul facility’s improper overhaul of the nose landing gear steering manifold.NTSB CEN13CA238Accident · No injuriesData collectionFinal reportEnstrom F-28C · Lanesboro, IAThe pilot’s failure to maintain control of the helicopter while making an off-airport landing with a gusty tailwind.NTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.NTSB WPR13CA206Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe failure of the flight instructor and the pilot receiving instruction to recognize before entering the flare that the wind had shifted to a tailwind and terminate the practice autorotation.NTSB ERA13LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Inlet, NYA loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA13CA230Accident · No injuriesData collectionFinal reportCessna 152 · Americus, GAThe pilot’s delayed decision to terminate the practice approach during a simulated loss of engine power maneuver, which resulted in an inadvertent collision with utility wires.NTSB DCA13WA080Incident · No injuriesForeign investigationBoeing 747-400 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB), has notified the NTSB of an accident involving a Boeing 747-400 that occurred on April 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB ERA13LA212Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-225 · Chester Springs, PAThe pilot's failure to extinguish the burner pilot lights prior to a hard landing in windy conditions.NTSB CEN13CA236Accident · No injuriesData collectionFinal reportCessna T182T · Colorado Springs, COThe pilot’s improper recovery from a bounced landing.NTSB WPR13LA212Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Santa Rosa, CAThe partial loss of engine power due to fuel contamination and partially blocked fuel screens.NTSB WPR13LA203Accident · 1 fatalLimited investigationFinal reportHoffman RV-4 · Bullhead City, AZThe pilot’s suicidal act.NTSB WPR13CA204Accident · No injuriesData collectionFinal reportBell 206B · Wells, NVThe pilot's failure to maintain clearance from an obstacle while maneuvering at a low altitude.NTSB ERA13CA210Accident · No injuriesData collectionFinal reportCessna 172N · Stow, MAThe pilot’s failure to maintain directional control while landing in gusty wind conditions.NTSB CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.NTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.NTSB WPR13CA202Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Mesa, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA13FA209Accident · 2 fatalField investigationFinal reportCessna 210E · Williamsburg, VAThe pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN13LA233Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Paris, TXThe improper installation of the connecting rod bolts, which resulted in an engine failure.NTSB WPR13CA258Accident · No injuriesData collectionFinal reportCessna P210N · Corvallis, ORThe pilot's inadvertent selection and activation of the landing gear handle rather than the flap handle during the landing roll. Contributing to the accident was the pilot's decision to alter the configuration of the airplane before exiting the runway.NTSB WPR13CA200Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the airplane’s subsequent collision with a fence during the go-around attempt.NTSB ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.NTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.NTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.NTSB DCA13WA092Accident · No injuriesForeign investigationBoeing 767 · Madrid, SpainOn April 16,2013, about 1235 UTC, an Aero Mexico B767-200, registration XA-TOJ, operated as flight 071 from Madrid-Barajas International Airport, Madrid, Spain, to Benito Juarez International Airport, Mexico City, Mexico, experienced a tail strike while…NTSB CEN13WA297Accident · No injuriesForeign investigationCessna 510 · Luxembourg, LuxembourgOn April 16, 2013, at 0706 coordinated universal time, a Cessna 510, Luxembourg registered LX-FGL, owned and operated by Flying Group LUX S.A., was substantially damaged in flight. The airplane landed without further incident at Luxembourg Findel…NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.NTSB WPR13FA201Accident · 2 fatalField investigationFinal reportCessna 182D · Wellington, NVThe pilot’s failure to maintain clearance from mountainous terrain during a night, visual descent to the destination airport, which resulted in controlled flight into terrain.NTSB WPR13CA193Accident · No injuriesData collectionFinal reportCessna 210B · Caldwell, IDThe pilot’s failure to lower the landing gear, which resulted in a gear-up hard landing.NTSB CEN13LA229Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Warren, ARThe fatigue failure of the engine crankshaft due to oversized crankcase saddle bores, which resulted from maintenance personnel improperly resizing the saddle bores during engine maintenance.NTSB CEN13CA302Accident · Serious injuriesData collectionFinal reportJans Robert Falcon XP · Diboll, TXThe pilot did not properly secure a sand bag in the airplane's rear seat causing its flight controls to become jammed and resulting in the airplane's inability to avoid a collision with power lines.NTSB ANC13CA038Accident · No injuriesData collectionFinal reportBeech A36 · Port Alsworth, AKThe failure of the left main landing gear retraction brace assembly, resulting in the collapse of the left main landing gear.NTSB WPR13LA191Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Mesquite, NVSeparation of the propeller from the engine during initial climb due to the incorrect torque applied to the propeller hub nut during maintenance.NTSB ERA13FA201Accident · 1 fatalField investigationFinal reportSchoonover John D KIT FOX IV 1200 · St. Lucie, FLThe pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…NTSB CEN13LA231Accident · No injuriesLimited investigationFinal reportNeedham Stoddard-Hamilton TD · Bloomington, INThe improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.NTSB CEN13LA227Accident · Serious injuriesLimited investigationFinal reportQuad City Ultralight Acft Challenger I · Winnie, TXThe noncertificated pilot’s failure to maintain airplane control during takeoff due to his fixation on the instrument panel.NTSB CEN13CA303Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TXThe pilot's delay to not perform a go-around when he lost sight of the runway while on final approach to land at night. Contributing to the accident was the obscuration (tall grass) of the runway edge lights.