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 WPR19FA212Accident · 2 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Camarillo, CAThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.NTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.NTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…NTSB GAA19WA533Accident · 1 fatalForeign investigationPiper PA25 · Totatlan, Jalisco, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR19FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Wolf Point, MTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB ANC19FA042Accident · 4 fatalField investigationFinal reportPiper PA22-150 · Girdwood, AKThe pilot's failure to maintain clearance from terrain due to his impairment from alcohol consumption.NTSB CEN19WA256Accident · 1 fatalForeign investigationCessna A185 · Upper Raft Lake, CanadaNTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.NTSB CEN19FA247Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Ontonagon, MIThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions with thunderstorm activity, which resulted in spatial disorientation and a loss of airplane control.NTSB WPR19WA234Accident · 3 fatalForeign investigationRobinson R44 · Korotasere, Cakaudrove, FijiOn August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…NTSB ERA19WA241Accident · 1 fatalForeign investigationCessna 510 · Los Angeles, ChileThe government of Chile has notified the NTSB of an accident involving a Cessna 510 airplane that occurred on August 2, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN19WA301Accident · 2 fatalForeign investigationCessna TU206 · Guachochi, MexicoOn August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…NTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…NTSB CEN19WA268Accident · 1 fatalForeign investigationBeech V35 · Senneterre, Quebec, CanadaNTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.NTSB CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.NTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.NTSB GAA19WA444Accident · 1 fatalForeign investigationCirrus SR22 · Leutasch, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions of…NTSB WPR19LA191Accident · 1 fatalClass 3 · LimitedFinal reportBolkow Phoebus · Alvord Desert, ORPilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.NTSB GAA19WA441Accident · 7 fatalForeign investigationDe Havilland DHC2 · Mistastin Lake, NL, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB GAA19WA420Accident · 9 fatalForeign investigationAIRvan GA8 · Umea, SwedenThe government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB ANC19WA041Accident · 2 fatalForeign investigationRobinson R22 · Moscow, RussiaOn July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…NTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…NTSB ERA19FA225Accident · 1 fatalClass 3 · FieldFinal reportQuicksilver Mxii · Oliver Springs, TNThe noncertificated pilot’s decision to continue to takeoff and climb after encountering an undetermined airplane control issue that he was unable to counteract, which resulted in collision with trees and subsequent impact with terrain.NTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB GAA19WA417Accident · 3 fatalForeign investigationDe Havilland DHC2 · Chibogamau, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ERA19WA237Accident · 2 fatalForeign investigationPiper PA28 · Atibaia, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-28-140 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA19WA459Accident · 2 fatalForeign investigationDe Havilland DHC2 · Hawk Junction ON-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB CEN19FA218Accident · 1 fatalField investigationFinal reportGIbb AR-1 · Hawley, MNAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB ANC19FA033Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 24-180 · Ketchikan, AKThe pilot’s decision to continue visual flight rules into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB WPR19WA211Accident · 1 fatalForeign investigationCessna 172 · Anji, ChinaOn July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane…NTSB CEN19WA337Accident · 2 fatalForeign investigationRobinson R44 · Mt Tremblank, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R-44 helicopter, Canadian registration C-FJLH, that occurred on July 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's…NTSB ERA19LA221Accident · 1 fatalClass 3 · LimitedFinal reportTeam Mini-Max Hi-Max · Monroe, GAA collision with terrain for undetermined reasons.NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.NTSB CEN19WA208Accident · 1 fatalForeign investigationPiper PA-24-250 · Quetzaltenango, GuatemalaThe government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the…NTSB CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB WPR19FA183Accident · 2 fatalClass 3 · FieldFinal reportSchempp Hirth Arcus · Ephraim, UTThe pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.NTSB CEN19WA197Accident · 2 fatalForeign investigationRans S6 · Rougemont, CanadaNTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.