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 WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.NTSB WPR13CA126Accident · No injuriesData collectionFinal reportBellanca 7ECA · Santa Paula, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA146Accident · No injuriesData collectionFinal reportCessna 172P · Valparaiso, FLThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.NTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.NTSB ANC13FA024Accident · Serious injuriesField investigationFinal reportCessna 170B · Skwentna, AKThe pilot’s failure to maintain airspeed during a departure turn, resulting in an aerodynamic stall and collision with terrain.NTSB WPR13LA132Accident · No injuriesLimited investigationFinal reportCessna T310R · Casper, WYThe separation of the right main gear bracket assembly from its wing attachment fitting due to lack of lubrication of the torque tube bearing.NTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.NTSB ERA13CA140Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TNThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.NTSB CEN13LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Akron, COThe pilot’s physical impairment due to alcohol intoxication, which resulted in an aerodynamic stall during landing.NTSB CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.NTSB WPR13LA125Accident · Minor injuriesLimited investigationFinal reportTemco D-16A · Heber, CAA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight and fuel planning.NTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.NTSB ERA13LA138Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Fort Gaines, GAThe total loss of engine power due to fuel starvation as a result of debris in the fuel control unit.NTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.NTSB CEN13CA169Accident · No injuriesData collectionFinal reportCessna 152 · Murphysboro, ILAn inadvertent encounter with birds while on the downwind leg in the traffic pattern.NTSB WPR13FA123Accident · 1 fatalField investigationFinal reportAvions Fairey Tipsy Nipper T-66 · Winters, CAThe airplane's impact with a turkey vulture in cruise flight, which resulted in the structural failure of the right wing and the subsequent loss of control.NTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…NTSB ERA13LA134Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Danville, PAThe pilot’s decision to conduct a straight-in approach to the helipad, which resulted in the main rotor blade impacting a construction crane flag marker. Contributing to the accident was the erroneous information about the construction crane’s operation time…NTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…NTSB CEN13TA165Accident · Minor injuriesFinal reportBell OH-58A · Pine Springs, TXThe pilot's failure to maintain directional control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR13CA124Accident · No injuriesData collectionFinal reportBeech B19 · Ephrata, WAThe student pilot's failure to maintain directional control during the takeoff ground roll in crosswind conditions, and the flight instructor's delayed remedial action.NTSB ERA13FA131Accident · 1 fatalField investigationFinal reportCessna T337C · New Smyrna Beach, FLMaintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…NTSB CEN13LA171Accident · No injuriesLimited investigationFinal reportPiper PA46 · Grand Island, NEThe pilot's failure to maintain airplane control after engine start.NTSB CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.NTSB WPR13WA175Accident · Minor injuriesForeign investigationMD Helicopter 600N · Dhaka, Bangladesh, BangladeshOn February 12, 2013, at 0930 universal coordinated time, a MD Helicopter 600N, S2-AFZ, experienced a loss of engine power during cruise flight. The pilot initiated an autorotation to a muddy rice paddy near Dhaka, Bangladesh. The helicopter was operated by…NTSB WPR13LA122Accident · Serious injuriesLimited investigationFinal reportST Clair Lancair 360 · Williams, CAAn in-flight fire due to an electrical short circuit.NTSB ERA13WA157Accident · 1 fatalForeign investigationCessna 172S · Mersin, TürkiyeOn February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…NTSB CEN13WA181Accident · 2 fatalForeign investigationAmerican Champion 8KCAB · Cozumel, MexicoOn February 15, at 1615 central standard time, an American Champion 8KCAB decathalon, El Salvador registered YS-175P, owned by a private individual, was destroyed when it impacted terrain under unknown circumstances near Cozumel, Mexico. The pilot and one…NTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.NTSB DCA13WA053Accident · No injuriesForeign investigationBoeing 737 · Muscat, OmanA PIA Pakistan International Airlines Boeing 737-300, registration AP-BEH performing flight PK-259 from Sialkot (Pakistan) to Muscat (Oman) with 107 people on board, landed on Muscat's runway 26L at 13:25L (09:25Z) but suffered the collapse of the left main…NTSB CEN13LA158Accident · No injuriesLimited investigationFinal reportBell 206B III · Ponderosa, NMA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…NTSB WPR13CA120Accident · No injuriesData collectionFinal reportBell 206B · Shandon, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ANC13WA022Accident · 4 fatalForeign investigationCessna 210 · Waskada, CanadaOn February 10, 2013, about 1317 central standard time, a Cessna 210C airplane, (Canadian Registration C-FWUX) was on a flight from a private airport located 9 nautical miles east of Weskada, MB, to Brandon, MB, Canada. The airplane crashed 12 nautical miles…NTSB WPR13CA121Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sunnyside, WAThe pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.NTSB ERA13CA132Accident · No injuriesData collectionFinal reportTriad International Technology RV6A · Lewisburg, TNThe pilot’s improper landing flare and failure to maintain directional control during the landing.NTSB ERA13CA130Accident · Minor injuriesData collectionFinal reportDratbe Shmiel Amir Classic Edge X · Miami, FLThe student pilot's decision to fly at low altitude surrounded by tree, wire, and water hazards, and his failure to maintain clearance from those obstacles.NTSB CEN13WA156Accident · 5 fatalForeign investigationCessna P210N · Charloeri, BelgiumOn February 9, 2013, about 0840 hours universal coordinated time, a Cessna P210N, United States registration N240PW, impacted terrain after takeoff from the Brussels South -- Charleroi Airport (EBCI), Charleroi, Belgium. The intended destination was Lyon,…NTSB WPR13FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Tucson, AZThe pilot's incapacitation due to his preexisting cardiac disease, which resulted in his degraded or complete loss of ability to control the airplane.NTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…NTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.NTSB CEN13CA153Accident · No injuriesData collectionFinal reportCessna 177RG · Herington, KSThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall.NTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.NTSB ERA13LA129Accident · No injuriesLimited investigationFinal reportBeech 58 · Winston-Salem, NCThe failure of the left main landing gear to fully extend due to improper rigging by maintenance personnel during a maintenance check.NTSB DCA13IA058Incident · Minor injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Bowman, GAthe captain's inappropriate climb speed, his failure to monitor airspeed during the level off, and his inappropriate response to multiple stall warnings.NTSB CEN13LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Forrest City, ARThe in-flight separation of the left aileron's push-pull rod and hardware. Contributing to the accident was the failure of maintenance personnel to apply proper torque to the self-locking nuts.NTSB CEN13LA167Accident · No injuriesLimited investigationFinal reportCessna 172L · Idabel, OKThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion.