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 ERA16FA140Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Enterprise, ALThe pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…NTSB CEN16LA137Accident · Serious injuriesLimited investigationFinal reportMatthews H Thomas Jodel F11 A · Marathon, TXThe pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.NTSB CEN16LA134Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Stephenville, TXThe loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB ANC16WA016Accident · 4 fatalForeign investigationMooney M20C · Yao, JapanOn March 26, 2016 , about 1618 Local Time, a Mooney M20C airplane, Japan registration number JA3788, operated by the pilot, was destroyed by post crash fire following a loss of control while attempting a go-around at the Yao Airport, Osaka Prefecture. The…NTSB WPR16WA089Accident · 1 fatalForeign investigationBell 206 · Carmila West, AustraliaOn March 25, 2016, at 1028 local time, a Bell 206B, VH-WHU, collided with power lines during an aerial agriculture flight near Carmila West, Australia. The helicopter was destroyed by the post impact fire and the pilot was fatally injured. The flight was…NTSB GAA16CA166Accident · Minor injuriesData collectionFinal reportPiper J5A · Lake Harbor, FLThe pilot's exceedance of the critical angle of attack while maneuvering at low altitude, which resulted in an accelerated aerodynamic stall, spin, and impact with terrain.NTSB DCA16WA235Accident · No injuriesForeign investigationCessna T210H · Hoedspruit, Limpopo Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T210H airplane that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…NTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN16WA397Incident · No injuriesForeign investigationBombardier BD 700 1A10 · George Town, Cayman IslandsOn March 25, 2016, about 0345 coordinated universal time, an unoccupied Saab 340B airplane, VP-CKI, encountered jet blast from a taxiing Bombardier Global Express BD-700-1A10 airplane, N683GA, at the Owen Roberts International Airport, George Town, Cayman…NTSB CEN16LA135Accident · Serious injuriesLimited investigationFinal reportBrantly B 2B · Galena, MOThe pilot’s loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA169Accident · Minor injuriesData collectionFinal reportAmerican Legend AL3 · Monticello, GAThe pilot's decision to land with a quartering tail wind, and failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with a tree.NTSB ERA16LA139Accident · 1 fatalLimited investigationFinal reportHall, Wendall W Harmon Rocket II · Cheraw, SCThe pilot's decision to fly at low altitude, which resulted in a collision with power lines.NTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.NTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.NTSB GAA16CA159Accident · No injuriesData collectionFinal reportCessna 152 · Valparaiso, INThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA158Accident · No injuriesData collectionFinal reportCessna 172 · Frederick, MDThe student pilot's improper pitch control during the landing flare, which resulted in a hard bounced landing.NTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB ERA16WA147Accident · 3 fatalForeign investigationBell 206 · Riosucio, Choco, ColombiaNTSB ERA16WA138Accident · 3 fatalForeign investigationBell 206B III · Angostura, ColombiaOn March 23, 2016, about 1211 universal coordinated time, a Bell 206B III, Colombian registration HK4764, was destroyed when it impacted mountainous terrain and was consumed by a postcrash fire. Three of the four occupants were fatally injured, and one…NTSB ENG16WA014Incident · No injuriesForeign investigationFairchild SA-227-AT · Brisbane, AustraliaDuring a post-flight inspection of a Fairchild SA227-AT, Registration Number VH-UZI, powered by two TPE331-11U-611G Honeywell Turbine engines, evidence of a fuel leak was detected on the left-hand engine. Further investigation revealed a fire on the left-hand…NTSB DCA16WA140Accident · No injuriesForeign investigationFairchild SA227 · Tierra del Fuego, ArgentinaThe Argentina Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) has notified the NTSB of an accident involving a Fairchild SA-226 that occurred on March 22, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…NTSB WPR16FA086Accident · 1 fatalField investigationFinal reportAirborne XT 912 · Hawthorne, CAThe weight shift control aircraft encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the accident pilot's failure to recognize the potential for a wake…NTSB GAA16CA156Accident · No injuriesData collectionFinal reportRolladen-Schneider LS8 · Pine Grove, PAThe pilot's inability to maintain the glider's descent rate and glide path after encountering a downdraft, resulting in a collision with trees during an off airport landing.NTSB ANC16WA026Incident · No injuriesForeign investigationCirrus SR22 · Kagoshima, JapanOn March 21, 2016 , about 1320 Local Time, a Cirrus SR22 airplane, Japan registration number JA01YK, operated by the pilot, sustained minor damage following a fracture of the nose landing gear strut during landing at the Kagoshima Airport, Japan. The pilot…NTSB GAA16CA157Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB ERA16WA206Accident · No injuriesForeign investigationCessna 150 · Daule, EcuadorOn March 20, 2016, at 1730 Universal Coordinated Time (UTC), a Cessna 150L, Ecuadorian registration HC-CJS, operated by Sky Ecuador, received substantial damage following a loss of engine power and forced landing in a rice field near Daule, Ecuador. The…NTSB DCA16WA115Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB CEN16WA142Accident · 1 fatalForeign investigationYork Laser Z-200 · Abbeyshrule, IrelandOn March 20, 2016, at 1745 coordinated universal time (UTC), an experimental amateur built York Laser Z-200 airplane, Dutch registered PH-LSR, was destroyed when it impacted terrain under unknown circumstances near Abbeyshrule, County Longford, Ireland. The…NTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…NTSB ERA16WA136Accident · 7 fatalForeign investigationComp Air CA9 · Sao Paulo, BrazilOn March 19, 2016, about 1853 coordinated universal time, an experimental amateur-built Comp Air CA9, Brazilian registration PR-ZRA, was destroyed by impact and fire after collision with a building shortly after takeoff in Sao Paulo, Brazil. There was a…NTSB ERA16LA135Accident · No injuriesLimited investigationFinal reportCessna 210L · Myrtle Beach, SCA complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…NTSB DCA16RA108Accident · 62 fatalForeign investigationBoeing 737 · Rostov-on-Don, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a BOEING 737 that occurred on March 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO…NTSB GAA16CA161Accident · No injuriesData collectionFinal reportBeech 58 · Huntsville, ALThe pilot's failure to extend the landing gear prior to touchdown resulting in a landing with the landing gear retracted and consequent substantial damage.NTSB GAA16CA153Accident · Serious injuriesData collectionFinal reportBarnes Thomas A Vans · Bolingbrook, ILThe pilot's failure to maintain direction control during the takeoff roll, which resulted in runway excursion, collision with terrain, and nose over.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB DCA16WA112Incident · No injuriesForeign investigationBeech 1900 · Karachi, PakistanThe Pakistan Safety Investigation Board (PSIB) has notified the NTSB of an incident involving an Hawker Beechcraft 1900D that occurred on March 18, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the PSIB investigation under the…NTSB CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.NTSB ERA16CA134Accident · Minor injuriesData collectionFinal reportEichhorn Gary L Skyraider I · Erwin, NCThe pilot's inadequate compensation for the wind which resulted in a loss of directional control.NTSB DCA16CA181Accident · Serious injuriesData collectionFinal reportBoeing 737 724 · Port Arthur, TXan inadvertent encounter with clear air turbulence.NTSB CEN16CA126Accident · No injuriesData collectionFinal reportNakajima A6M2 Model 21 · Midland, TXThe Goodyear pilot did not see and avoid the Nakajima ahead on the taxiway.NTSB ERA16LA131Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Rome, GAThe pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.NTSB ERA16LA130Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Myakka, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB CEN16WA124Incident · No injuriesForeign investigationCessna 525 · Lugano, SwitzerlandNTSB WPR16LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, UTThe pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.