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 SEA93LA217Accident · No injuriesLimited investigationFinal reportBeech G35 · Arlington, WAFracture of the left stabilizer spar.NTSB SEA93LA200Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waterville, WAThe pilot's inadequate visual lookout and failure to maintain clearance from the powerline.NTSB LAX93LA353Accident · No injuriesLimited investigationFinal reportHughes 369D · Georgetown, CAFailure of the pilot to maintain aircraft control after improperly planning his approach to a hover by avoiding conditions conducive to settling with power. Factors in the accident were high density altitude and failure of the pilot to jettison the external…NTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…NTSB BFO93LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Mattawamkeag, ME1) The pilot's initiation of an excessive maneuver (steep bank turn) at 400 feet above the ground, which resulted in an aerodynamic stall, and 2) the pilot's lack of recognition of the nature of the emergency, causing a delay in performing remedial action to…NTSB BFO93IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe operator maintenance personnel's failure to perform an adequate inspection of the airplane, which led to a worn aileron cable which separated in flight and caused a loss of control.NTSB SEA93LA211Accident · No injuriesLimited investigationFinal reportCessna 150L · Silverton, ORClearance was not maintained. A factor to the accident was: poor in-flight planning/decision.NTSB LAX93LA351Accident · Serious injuriesLimited investigationFinal reportR&K Special 01 · Reno, NVThe pilot's loss of control due to an undetermined encounter with an unfavorable wind/air condition in the form of a dust devil, windshear, or wake turbulence from a previous lap. A related factor in the accident was: the low altitude at the time of the…NTSB LAX93FA352Accident · 1 fatalField investigationFinal reportScaled Composites 158-8 · Lemmon Valley, NVOil starvation and connecting rod failure in the right engine, and a resultant fuel fed fire.NTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.NTSB SEA93LA198Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164A · Dayton, WAThe pilot in command's failure to maintain proper clearance from the power lines. The unmarked power lines were a factor.NTSB BFO93LA174Accident · No injuriesLimited investigationFinal reportCessna 182L · Oxford, MAThe failure of the CFI to maintain a proper descent rate, and his delay in performing remedial action. Factors related to the accident are the downdraft, the gusting winds, and the soft runway.NTSB BFO93IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200ER · Jamaica, NYThe failure of the left hydraulic pressure switch, which caused the left yaw damper module to become inoperative resulting in uncommanded rudder movements during flight.NTSB ANC93LA185Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Puget Bay, AKThe pilot's improper in-flight planning/decision, and his misjudging his altitude above the water. A factor was the glassy water.NTSB ANC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prudhoe Bay, AKFluid fuel contamination as a result of the pilot-in-commands improper preflight planning/preparation.NTSB ANC93FA175Accident · 1 fatalField investigationFinal reportCessna 152 · Fairbanks, AKThe student pilot's failure to maintain control of the airplane due to spatial disorientation. Factors were the dark night and the inadequate surveillance of the operation by the club management.NTSB MIA93WA195Accident · Serious injuriesForeign investigationCessna 402B · Sandy Point, BahamasNTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…NTSB LAX93LA350Accident · No injuriesLimited investigationFinal reportCessna 182E · Minden, NVthe pilot's inadequate preflight planning and failure to use all available runway. A factor in the accident was the high density altitude condition.NTSB CHI93LA359Accident · No injuriesLimited investigationFinal reportCessna 172F · Indianapolis, INThe failure of the left magneto, which resulted in a partial loss of engine power.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB BFO93LA172Accident · No injuriesLimited investigationFinal reportCessna 172L · Gr Barrington, MAThe pilot's inadequate compensation for the crosswind which resulted in his loss of directional control during the landing roll and subsequent collision with the parked airplanes. A related factor was the pilot's lack of experience.NTSB ATL93LA158Accident · Serious injuriesLimited investigationFinal reportBeech A-23-19 · Resaca, GANot determined.NTSB ANC93LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mosquito River, AKThe pilot's failure to maintain a proper altitude during the low pass. A factor was the rough/uneven terrain.NTSB ANC93LA174Accident · 1 fatalLimited investigationFinal reportCessna 206 · Swikshak Bay, AKThe pilot-in-command's failure to attain a proper climb rate.NTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.NTSB NYC93IA184Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New York, NYThe improper installation of the fairing by company maintenance personnel, resulting in the infligh separation of the fairing in flight.NTSB LAX93LA355Accident · No injuriesLimited investigationFinal reportAlfred F. Dibernardino RV-6A · Mesa, AZthe pilot's failure to maintain the landing airspeed. The inadvertent stall was a factor related to this accident.NTSB LAX93LA349Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Sonoma, CAthe airport management's failure to provide notice of the banner operation and to close the runway. An additional cause was the banner operator's failure to ensure that the runway on which he placed his banner equipment was closed.NTSB CHI93LA360Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Marshfield, MOfuel exhaustion due to the failure of the fuel tank selector valve handle which prohibited the pilot from switching to a tank containing fuel.NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.NTSB BFO93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tangier Island, VAFailure of the pilot to maintain control of the aircraft during a go-around. A factor related to the accident was: the crosswind condition.NTSB ATL93LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Deatsville, ALWas a crack in no.3 cylinder head which resulted in the loss of engine power.NTSB ATL93LA156Accident · Serious injuriesLimited investigationFinal reportBrown VAN'S RV-3 · Statesville, NCWas the pilot's failure to see and avoid utility lines. A factor was the sunglare.NTSB ANC93FA173Accident · Serious injuriesField investigationFinal reportCessna 180 · Cooper Landing, AKThe separation of the throttle arm from the thorttle shaft, the failure of the maintenance personnel to comply with the airworthiness directive, and the company management's failure to adequately ensure compliance with the airworthiness directives.NTSB SEA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Merrill, ORFuel exhaustion and inadequate inflight planning/decision.NTSB SEA93LA196Accident · 1 fatalLimited investigationFinal reportAerospatiale SA-365-N2 · Ogden, UTThe pilot's failure to maintain proper altitude. A factor to the accident was glassy water.NTSB LAX93LA348Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Floriston, CAthe flight instructor's failure to maintain main rotor RPM after initiating a go-around from a pinnacle approach. A factor in the accident was the high density altitude condition.NTSB CHI93LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Davison, MIImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.NTSB BFO93FA169Accident · 2 fatalField investigationFinal reportCessna A150 · Greenbelt, MD1) The pilot's poor judgement in buzzing a residential area, 2) his failure to maintain an airspeed above the aerodynamic stalling speed, which led to a stall/spin, and 3) the inability of the pilot to take remedial action and recover from the stall/spin due…NTSB BFO93FA167Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Marshall, VAAn inadequate annual inspection of the airplane and non-compliance with airworthiness directives by company maintenance personnel.NTSB ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.NTSB ATL93LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Roxboro, NCThe pilot's inadequate compensation for the wind conditions at the time of the takeoff. Factors were the wind gusts and windshear existing at the airport.NTSB ATL93FA155Accident · 2 fatalField investigationFinal reportBeech F35 · Jackson, TNThe improper use of old auto fuel for the refueling of the aircraft. Factors in the accident were the deterioration of the octane in the auto fuel being used in the aircraft and the delayed decision by the pilot to choose a suitable area and execute a forced…NTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.NTSB MIA93LA193Accident · Serious injuriesLimited investigationFinal reportLegrand Avid Flyer · Titusville, FLThe pilot-in-command's failure to maintain airspeed (vso) in a go-around, resulting in an in-flight loss of control (stall).NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB ATL93LA152Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe failure of the engine exhaust valve which resulted in the loss of engine power. The soft terrain in the landing area was a factor.