Fatal NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE c.\"highestInjuryLevel\" = 'Fatal' 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 WHERE c."highestInjuryLevel" = 'Fatal' 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 CEN19FA009Accident · 1 fatalClass 2 · FieldFinal reportRobinson R22 · Fulton, MOA total loss of engine power due to carburetor icing, the pilot's delayed application of carburetor heat, and the pilot's delay in entering an autorotation following the loss of engine power, which resulted in a main rotor stall due to low rotor rpm and an…NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB CEN19FA008Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Canoncito, NMThe partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.NTSB WPR19FA007Accident · 2 fatalClass 2 · FieldFinal reportCessna T240 · Payson, AZThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.NTSB CEN19WA010Accident · 3 fatalForeign investigationCessna F172 · Wasserkuppe, GermanyOn October 14, 2018, about 1345 coordinated universal time, a Cessna F172N, D-EFJX, experienced a runway excursion during landing which resulted in 3 ground fatalities.This investigation is under the jurisdiction and control of the German Federal Bureau of…NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB CEN19FA005Accident · 1 fatalField investigationFinal reportPiper PA28 · Cartersville, GAThe pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA19FA010Accident · 1 fatalClass 2 · FieldFinal reportVans RV8 · Culpeper, VAThe pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.NTSB CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.NTSB CEN19FA003Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Placedo, TXThe pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.NTSB CEN19WA011Accident · 2 fatalForeign investigationCessna F172 · East Yorkshire, United KingdomOn November 10, 2018, about 1930 hours universal coordinated time, a Reims Cessna F172N, United Kingdom registration G-BGSV, impacted a field near East Yorkshire, United Kingdom. The two occupants on-board were fatally injured. The flight origin and…NTSB WPR19LA006Accident · 1 fatalClass 2 · LimitedFinal reportVans RV6 · Cape Girardeau, MOThe pilot's improper landing flare in gusting crosswind conditions, his failure to conduct a go-around, and his failure to maintain directional control, which resulted in a runway departure and nose-over.NTSB WPR19WA004Accident · 2 fatalForeign investigationCessna 172 · Midrand, South AfricaOn October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…NTSB ERA19WA038Accident · 2 fatalForeign investigationSiai Marchetti SF260 · Caorle, ItalyThe government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB WPR19FA001Accident · 1 fatalClass 2 · FieldFinal reportBeech V35 · La Verne, CAThe pilot's failure to maintain clearance from trees during a visual approach for landing. Contributing to the accident was the pilot's distraction during the approach.NTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…NTSB ANC19WA001Accident · 2 fatalForeign investigationRobinson R44 · Bodaybo, RussiaOn October 1, 2018, at an undetermined time, a Robinson R-44-II helicopter, RA-05758, impacted water and sank prior to colliding with a power transmission line near Bodaybo, Russia. The pilot and passenger sustained fatal injuries. The Interstate Aviation…NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…NTSB CEN18FA391Accident · 3 fatalField investigationFinal reportAirbus Helicopters AS350 · Gustavus, AKThe pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.NTSB ERA18FA264Accident · 2 fatalField investigationFinal reportDassault Falcon 50 · Greenville, SCThe operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…NTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…NTSB CEN18FA389Accident · 1 fatalClass 2 · FieldFinal reportVans RV 4 · Austin, ARThe pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.NTSB CEN18WA390Accident · 1 fatalForeign investigationRobinson R44 · Buttonville, CanadaOn September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB CEN18FA386Accident · 1 fatalField investigationFinal reportCessna U206 · Rainy Pass, AKThe pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.NTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.NTSB CEN18WA388Accident · 3 fatalForeign investigationCessna 210 · Pico de Orizaba, MexicoOn September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…NTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…NTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA18WA252Accident · 1 fatalForeign investigationBeech C90 · Ipumirim County, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on September 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.NTSB WPR18FA261Accident · 2 fatalClass 3 · FieldFinal reportGruber Beelzabub · Rochester, WAThe pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.NTSB WPR18FA260Accident · 1 fatalField investigationFinal reportRobert L Coons RotorWay RW 1 · Billings, MTThe pilot's failure to maintain clearance with a hangar while maneuvering to his hangar. Contributing to the accident was the pilot's limited experience in helicopters.NTSB ERA18LA249Accident · 1 fatalLimited investigationFinal reportEdward R. Sugg Sonex · Marion, SCImpact with terrain for reasons that could not be determined based on the available information.NTSB ERA18FA244Accident · 2 fatalField investigationFinal reportCessna 335 · Lake Worth, FLThe pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.NTSB WPR18WA258Accident · 1 fatalForeign investigationYakovlev YAK-9UM · Victoria, AustraliaOn September 7, 2018, about 1933 coordinated universal time a Yakovlev Aircraft YAK-9UM airplane, VH-YIX, impacted terrain during a local flight that departed from the Latrobe Valley Airport, Victoria, Australia. The pilot in command was fatally injured, and…NTSB WPR18FA253Accident · 1 fatalClass 2 · FieldFinal reportCommander 114 · Jean, NVThe pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.NTSB ERA18WA245Accident · 1 fatalForeign investigationBell 430 · Bostanci, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…NTSB CEN18FA371Accident · 1 fatalField investigationFinal reportCessna 340A · Port Huron, MIThe pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…NTSB CEN18WA376Accident · 4 fatalForeign investigationRobinson R44 · Domažlická 1059, Plzen - Skvrnany, CzechiaOn September 5, 2018, at 1533 Coordinated Universal Time, a Robinson R44, I-CCNI, impacted terrain while maneuvering at low altitude, Plzen-Skvmany, Czech Republic. The pilot and three passengers sustained fatal injuries.The investigation is under the…NTSB WPR18FA251Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Palo Alto, CAThe pilot’s failure to maintain aircraft control during a go-around due to his premature flap retraction, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…NTSB WPR18FA247Accident · 2 fatalClass 3 · FieldFinal reportSchempp-Hirth Duo Discus T · New Washoe City, NVThe pilot’s delayed recovery from an inadvertent spin and/or spiral dive and an exceedance of the glider’s design limit load during recovery, which resulted in an overload failure of both wings.NTSB ERA18WA247Accident · 1 fatalForeign investigationBeech 33 · Taquaraçu de Minas, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA18FA240Accident · 1 fatalField investigationFinal reportLance M Hooley Jetez · Covington, TNThe improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.NTSB CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.NTSB CEN18FA359Accident · 2 fatalField investigationFinal reportPiper PA28R · Kaplan, LAThe pilot's failure to maintain clearance from a charted and illuminated television/radio tower.