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 ERA14CA169Accident · No injuriesData collectionFinal reportCessna 172M · Knoxville, TNThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.NTSB ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.NTSB ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.NTSB CEN14LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 - II · Menard, TXThe pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.NTSB WPR14WA154Accident · 5 fatalForeign investigationCessna U206 - G · Caboolture, AustraliaOn March 22, 2014 about 1123 local time, a Cessna 206 airplane, Australian registration VH-FRT, crashed shortly after takeoff near Caboolture, Australia. The airplane was substantially damaged and the pilot and four passengers were fatally injured. The…NTSB ERA14FA162Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Safety Harbor, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.NTSB CEN14WA176Accident · No injuriesForeign investigationCessna 205 - Undesignat · Albacete, SpainThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 22, 2014, about 1630 UTC, a Cessna 205 airplane, EC-GQB, (s/n 205-0277) was involved in a forced landing following…NTSB CEN14WA169Accident · 2 fatalForeign investigationFritz Neumeyer Glasair II FT / 1865 · Turnau, AustriaOn 22 March 2014, approximately 1126 coordinated universal time, a Glasair II FT, airplane, registration D-EJFN crashed shortly after takeoff from the Lanzen-Turnau Airport, Turnau, Austria. The pilot and passage were fatally injured. The incident is being…NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.NTSB WPR14LA142Accident · No injuriesLimited investigationFinal reportBellanca 17 31 · Salt Lake City, UTThe failure of the right main landing gear extension spring to maintain adequate pressure, which allowed the landing gear to collapse during the landing roll.NTSB ERA14LA173Accident · No injuriesLimited investigationFinal reportCessna 206H · Philadelphia, PAThe pilot's failure to maintain control of the airplane while landing in gusty wind conditions.NTSB ERA14LA164Accident · Serious injuriesLimited investigationFinal reportFarace Thomas Scott Kitfox II · Vicksburg, MSThe airplane’s low-level encounter with a downdraft that maximum engine power could not overcome.NTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…NTSB CEN14LA168Accident · No injuriesLimited investigationFinal reportOlson Perry D Titan 51 Mustang · Evans, COThe builder's improper wiring of both fuel pumps to the battery-powered bus, which resulted in a total loss of engine power when the batteries failed because all power to the fuel pumps was lost.NTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.NTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.NTSB WPR14WA148Accident · 1 fatalForeign investigationMD Helicopter 500N · Gisborne, New Zealand, New ZealandOn March 19, 2014, at 2030 universal coordinated time, a MD Helicopters 500N, ZK-HQP, was preparing for a fire lighting operation when it crashed in Hawkes Bay near Gisborne, New Zealand. The helicopter was operated by Gisborne Helicopters Limited under the…NTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.NTSB DCA14WA104Incident · No injuriesForeign investigationBoeing 767-300 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 767-300 that occurred on March 19, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…NTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.NTSB CEN14CA440Accident · Serious injuriesData collectionFinal reportMooney M20J · Lamar, COThe pilot allowed the airplane to liftoff without sufficient airspeed which resulted in a stall and subsequent impact with the terrain.NTSB CEN14CA166Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Hudson, COThe pilot's inadequate monitoring of his glide path resulting in a collision with a berm prior to landing.NTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.NTSB WPR14FA137Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Seattle, WAThe loss of helicopter control due to a loss of hydraulic boost to the tail rotor pedal controls at takeoff, followed by a loss of hydraulic boost to the main rotor controls after takeoff. The reason for the loss of hydraulic boost to the main and tail rotor…NTSB ERA14LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Elizabethton, TNThe pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…NTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.NTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…NTSB WPR14CA143Accident · No injuriesData collectionFinal reportGrumman TMB-3E · Glendale, AZThe pilot inadvertently raised the landing gear lever rather than the adjacent flap level while exiting the runway which resulted in the retraction of the left main landing gear.NTSB ERA14CA157Accident · No injuriesData collectionFinal reportCessna 210N · Marathon, FLThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown. Contributing to the accident was the possibility of intermittent landing gear operation due to a faulty hydraulic power pack contactor.NTSB DCA14CA083Accident · Serious injuriesData collectionFinal reportAirbus A330 323 · Seattle (Pacific Ocean)the flight attendant inadvertently tripping over a passenger's foot that was protruding into the aisle, which resulted in the flight attendant fracturing her foot.NTSB ERA14LA159Accident · No injuriesLimited investigationFinal reportCessna 500 · Zephyrhills, FLThe pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.NTSB WPR14CA138Accident · Minor injuriesData collectionFinal reportDG Flugzeugbau DG 1000S · Wrightwood, CAThe pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing.NTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.NTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.NTSB CEN14CA183Accident · No injuriesData collectionFinal reportStinson 108 · Broomfield, COThe pilot's failure to maintain directional control during the landing, which resulted in the airplane departing the runway and nosing over.NTSB CEN14CA160Accident · Minor injuriesData collectionFinal reportPiper PA 28-235 · De Beque, COThe pilot's failure to maintain control of the airplane while maneuvering at low altitude.NTSB WPR14CA136Accident · No injuriesData collectionFinal reportNorman Quad City Challenger · Monroe, WAThe pilot's inadequate construction of the propeller bracket, which resulted in its failure during the initial climb and the propeller subsequently departing the airplane.NTSB ERA14WA245Accident · Minor injuriesForeign investigationCessna T188C · Canton Naranjal, EcuadorOn March 13, 2014, a Cessna T188C, Ecuadorian registration HC-BTA, was substantially damaged when it lost engine power and impacted terrain near Canton Naranjal, Ecuador. A postaccident fire ensued. The foreign certificated pilot received minor injuries. The…NTSB ENG14IA011Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Rochester, NYThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a herring gull birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural frequency (resonance)…NTSB DCA14MA081Accident · No injuriesClass 2 · MajorFinal reportAirbus A320 - 214 · Philadelphia, PAthe captain's decision to reject the takeoff after the airplane had rotated. Contributing to the accident was the flight crew's failure to follow standard operating procedures by not verifying that the airplane's flight management computer was properly…NTSB CEN14WA171Accident · 4 fatalForeign investigationAgustawestland Agusta AW139 · Gillingham, Norfolk, United KingdomOn March 13, 2014, about 1927 coordinated universal time, an Agusta/Westland model AW139 helicopter, United Kingdom registration G-LBAL, impacted terrain shortly after takeoff near Gillingham, Norfolk, United Kingdom. The four occupants were fatally injured.…NTSB CEN14CA162Accident · No injuriesData collectionFinal reportBeech 35 C33A · West Union, OHA loss of aircraft control during landing, due to the pilot's excessive braking. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA14WA154Accident · 5 fatalForeign investigationBeech BE9L-C90 · Villavicenco, ColombiaOn March 12, 2014, about 1133 universal coordinated time, a Hawker Beechcraft BE9L- C90, Colombian registration HK4921, was destroyed by impact and a postcrash fire, in the vicinity of Villavicencia, Meta, Colombia. The Colombian commercial pilot and four…NTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.NTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.