NTSB investigations, 2017, Outside the U.S.
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 per year
| 1962 | 9 |
|---|---|
| 1963 | 3 |
| 1964 | 108 |
| 1965 | 99 |
| 1966 | 106 |
| 1967 | 101 |
| 1968 | 64 |
| 1969 | 63 |
| 1970 | 70 |
| 1971 | 56 |
| 1972 | 79 |
| 1973 | 66 |
| 1974 | 65 |
| 1975 | 58 |
| 1976 | 16 |
| 1977 | 24 |
| 1978 | 36 |
| 1979 | 14 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 8 |
| 1987 | 22 |
| 1988 | 41 |
| 1989 | 25 |
| 1990 | 30 |
| 1991 | 29 |
| 1992 | 36 |
| 1993 | 41 |
| 1994 | 42 |
| 1995 | 66 |
| 1996 | 61 |
| 1997 | 93 |
| 1998 | 134 |
| 1999 | 110 |
| 2000 | 159 |
| 2001 | 152 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 154 |
| 2005 | 174 |
| 2006 | 181 |
| 2007 | 174 |
| 2008 | 174 |
| 2009 | 181 |
| 2010 | 227 |
| 2011 | 238 |
| 2012 | 259 |
| 2013 | 248 |
| 2014 | 219 |
| 2015 | 268 |
| 2016 | 319 |
| 2017 | 304 |
| 2018 | 337 |
| 2019 | 323 |
| 2020 | 257 |
| 2021 | 428 |
| 2022 | 429 |
| 2023 | 460 |
| 2024 | 492 |
| 2025 | 475 |
| 2026 | 390 |
Latest cases
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 year(c.\"eventDate\") = 2017
AND c.\"eventCountry\" <> 'USA'
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 year(c."eventDate") = 2017 AND c."eventCountry" <> 'USA' 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 WPR18WA060Accident · 6 fatalForeign investigationDe Havilland DHC2 · Cottage Point, AustraliaOn December 31, 2017, at 1515 local time, a De Havilland DHC-2, VH-NOO, collided with water during takeoff initial climb near Cottage Point, Australia. The airplane was destroyed and the pilot and five passengers were fatally injured. The flight was operated…NTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…NTSB ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18WA067Accident · 1 fatalForeign investigationConstrucciones Aeronauticas C.A.S.A. 1.131 · Alicante, SpainOn December 30, 2017, at 1642 universal time coordinated, a Construcciones Aeronauticas SA C.A.S.A. 1.131 (Bucker BU-131), N1950M (NX-1950M), and a Bell 412SP, EC-MMC, experienced a mid-air collision during final approach for landing to runway 20 at Muchamiel…NTSB ERA18WA057Accident · 2 fatalForeign investigationCessna 172 · Providenciales, Turks & Caicos IslandsThe government of the United Kingdom has notified the NTSB of an accident involving a Cessna 172S airplane that occurred on December 24, 2017, in Turks and Caicos Islands. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accidents…NTSB ERA18WA069Incident · No injuriesForeign investigationCessna A188 · Montecristi, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB WPR18WA054Accident · Serious injuriesForeign investigationBell UH1H · Bredasdorp, South AfricaOn December 21, 2017, about 1105 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLI, was substantially damaged when it impacted terrain shortly after liftoff from Bredasdorp fire station, Western Cape Province, South Africa. The helicopter was…NTSB ENG18WA024Accident · No injuriesForeign investigationAntonov TVS-2MS · Naryan-Mar, RussiaA TVS-2MS airplane powered by a Honeywell TPE331-12UHR-702H and equipped with skids impacted unpaved runway after an aborted takeoff. The airplane was completed destroyed. The Russian Interstate Aviation Committee (MAK) is investigating.NTSB ERA18WA051Accident · 1 fatalForeign investigationBeech A36 · Itapua, ParaguayNTSB ANC18WA015Accident · 1 fatalForeign investigationPiper PA23 · Baldur, CanadaOn December 16, 2017, about 0037 Coordinated Universal Time, a Piper PA-23 airplane, CFIPK, impacted terrain near Baldur, Manitoba, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries.The Transportation Safety Board (TSB) of…NTSB WPR18WA078Accident · 3 fatalForeign investigationBeech 58 · Qaroun Lake, EgyptOn December 15, 2017, about 0930 Coordinated Universal time, a Textron/Beech Model 58 Baron twin engine airplane, SU-BLD, was substantially damaged when it impacted desert terrain about 18 kilometers north of Qaroun Lake, Egypt. The training pilot and the two…NTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasNTSB ENG18WA016Accident · No injuriesForeign investigationAerospatiale ATR 42-320 · Fond-du-Lac, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale ATR 42-320, which occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB CEN18WA055Accident · 3 fatalForeign investigationCessna 510 · Waldburg, GermanyOn December 14, 2017, about 1620 coordinated universal time, a Cessna 510 airplane, OE-FWD, impacted terrain near Waldburg, Germany. The pilots and passenger were all fatally injured and the airplane was destroyed.The accident investigation is under the…NTSB ERA18WA060Accident · 1 fatalForeign investigationAir Tractor AT502 · Rivadavia, ArgentinaThe government of Argentina has notified the NTSB of an accident involving an Air Tractor AT-502B airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under…NTSB DCA18WA054Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB DCA18WA077Incident · No injuriesForeign investigationBoeing 767 · Almaty, KazakhstanKazakhstan's Aviation Accident Investigation Department has notified the NTSB of an incident involving a Boeing 767, which occurred on December 9, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as…NTSB ERA18WA042Accident · 2 fatalForeign investigationRobinson R44 · Dubovaya Balka, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB DCA18WA029Accident · No injuriesForeign investigationCanadair CL 600 2A12 · Caracas, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CANADAIR LTD CL 600 2A12 airplane that occurred on December 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation…NTSB WPR18WA061Accident · Minor injuriesForeign investigationEnstrom 480 · Bacoor, PhilippinesOn December 2, 2017, at 0900 universal time coordinated, a Enstrom Helicopter Corporation 480B, RP-C8955, was substantially damaged during a precautionary landing near Bacoor, Cavite, Philippines. The pilot was not injured, and the passenger sustained minor…NTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNTSB DCA18WA048Incident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) of Singapore has notified the NTSB of an incident involving a Boeing 777, which occurred on November 29, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB DCA18WA027Accident · Serious injuriesForeign investigationBoeing 757 224 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State…NTSB DCA18WA028Incident · No injuriesForeign investigationBoeing 737 · Latvia, LatviaThe Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 23, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB WPR18WA086Incident · No injuriesForeign investigationHawker Beechcraft 390 · Germiston, South AfricaOn November 22, 2017, at 1423 coordinated universal time, a Hawker Premier Jet airplane, registration ZS-CBI, sustained minor damage during a runway excursion at Rand Airport (FAGM), Germiston, South Africa. The pilot and passenger were not injured. The…NTSB DCA18WA038Incident · No injuriesForeign investigationBoeing 737 · Foz do Iguacu County, BrazilThe government of Brazil has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18WA046Accident · 2 fatalForeign investigationMD Helicopter 369HS · La Morita, MexicoOn November 22, 2017, about 1437 pacific standard time, a MD Helicopters 369HS single-engine helicopter, serial number 920414S, Mexican registration XC-TIJ, crashed while providing aerial support for police activity near La Morita, Mexico. The pilot and his…NTSB DCA18WA047Incident · No injuriesForeign investigationBoeing 737 · Jauja, PeruThe Peruvian Board of Aviation Accidents Investigation (CIAA) has notified the NTSB of an incident involving a Boeing 737, which occurred on November 20, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB DCA18WA023Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB WPR18WA038Accident · No injuriesForeign investigationBell Helicopter 206B · Emerald Aerodrome, AustraliaOn November 18, 2017, about 1430 local time, a Bell 206B helicopter, registration VH-SDZ, rolled over following a precautionary landing near Emerald Aerodrome, Middlemount, Queensland, Australia. The helicopter, which was equipped with a Rolls-Royce 250…NTSB DCA18WA025Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…NTSB ERA18WA028Accident · 11 fatalForeign investigationCessna 208 · Ngorongoro, TanzaniaOn November 15, 2017, about 0805 coordinated universal time, Cessna 208B, Tanzanian registration 5H-EGG, operated by Coastal Aviation LTD., was substantially damaged when it impacted terrain near Ngorongoro, Tanzania. The pilot and 10 passengers were fatally…NTSB ERA18WA160Accident · 1 fatalForeign investigationPiper PA-25-235 · Itapolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB DCA18WA020Incident · No injuriesForeign investigationBoeing 777 · Oceanic, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on November 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the provisions of ICAO…NTSB DCA18WA030Incident · No injuriesForeign investigationBoeing 747 · Maastricht, NetherlandsThe Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…NTSB ERA18WA025Accident · Serious injuriesForeign investigationQuest Kodiac 100 · Goias, BrazilThe government of Brazil has notified the NTSB of an accident involving a QUEST AIRCRAFT COMPANY LLC KODIAC 100 airplane that occurred on November 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's…NTSB ENG18RA004Incident · No injuriesForeign investigationBritish Aerospace Avro 146 · Johannesburg, South AfricaOn November 8, 2017, at about 1750 UTC, South African Airlink flight 8103, a British Aerospace BAE-146 RJ85A, registered in South Africa as ZS-ASW, experienced an uncontained release of turbine material from the No. 2 engine, a Honeywell LF507-1F turbofan,…NTSB ENG18WA007Accident · No injuriesForeign investigationBell 407 · Krasny Pakhar village, RussiaThe Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a Bell 407, which occurred on November 6, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex…NTSB ENG18RA002Accident · Minor injuriesForeign investigationSwearingen SA227 · Thompson, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Fairchild SA227-AC airplane which occurred on November 3, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB ENG18WA005Incident · No injuriesForeign investigationBoeing 767 · Karachi, PakistanThe Safety Investigation Board of Pakistan has notified the NTSB of an incident involving a Boeing 767-200 airplane which occurred on November 1, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the SIB investigation under the…NTSB CEN18WA028Incident · No injuriesForeign investigationCessna 152 · Namur, BelgiumOn October 31, 2017, at 1305 coordinated universal time, a Cessna 152, Belgium registration OO-TMC, registered to Aero Motion, was involved in an off airport landing following a loss of engine power while preparing to land at the Namur-Suarlee Airport (EBNM),…NTSB CEN18WA022Accident · No injuriesForeign investigationCessna 550 · Bremen, GermanyOn October 29, 2017, about 1740 UTC, a Cessna 550/551 SP airplane, Russian Federation / RA-67560, was involved in a runway excursion at the Bremen Airport (EDDW), Bremen, Germany. Damage to the airplane was not yet known. The three crewmembers and two…NTSB WPR18WA019Accident · 2 fatalForeign investigationCessna T310 · Kew, New South Wales, AustraliaOn October 28, 2017, at 1600 local time, a Cessna T310R, VH-JMW, was destroyed when it collided with terrain near Kew, New South Wales, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The pilot and…NTSB ANC18WA076Accident · 2 fatalForeign investigationPiper PA34 · Calgary Springbank, CanadaOn October 26, 2017, about 0952 mountain daylight time, a Piper PA-34-200T airplane, C-GCCM, departed controlled flight and impacted terrain shortly after takeoff from Calgary Springbank Airport (CYBW), Alberta, Canada. The flight instructor and pilot…NTSB WPR18WA017Accident · 1 fatalForeign investigationCessna 210 · Albany, AustraliaOn October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian…NTSB ERA18WA029Accident · 1 fatalForeign investigationCessna A188 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on October 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR18WA024Accident · 2 fatalForeign investigationCessna 210L · Darwin Aerodrome, AustraliaOn October 23, 2017, at 1332 local time, a Cessna 210L, VH-HWY, collided with terrain near Darwin Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The two occupants were fatally injured. The…NTSB ERA18WA017Accident · 5 fatalForeign investigationCessna 210 · Itaituba, BrazilOn October 22, 2017, about 2105 universal coordinated time, a Cessna 210N, Brazilian registration PT-ORU, operated by a private individual, was destroyed when it collided with terrain following a low altitude maneuver near Itaituba, Brazil. The two foreign…NTSB DCA18WA017Accident · Serious injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on October 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions of ICAO Annex 13 as the…NTSB ERA18WA052Accident · Serious injuriesForeign investigationBeech B200 · Pucallpa, PeruThe government of Peru has notified the NTSB of an accident involving a Beech B200C airplane that occurred on October 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…