NTSB investigations, 2018, Outside the U.S.
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 393 |
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\") = 2018
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") = 2018 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 ANC19WA013Accident · 4 fatalForeign investigationAgusta A119 · Ulan-Ude, RussiaOn December 30, 2018, about 0230 universal time, an Agusta A119 helicopter, RA-01908, impacted terrain under unknown circumstances about 12 miles from Ulan-Ude, Buryatia, Russia. The pilot and three passenger sustained fatal injuries. The Interstate Aviation…NTSB ENG19IA008IncidentClass 3 · IncidentFinal reportAirbus A220 · Busan, South KoreaThe manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…NTSB ERA19RA077Accident · 5 fatalForeign investigationAgusta A109 · Santa Maria Coronango, State of Puebla, MexicoThe government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB DCA19WA057Incident · No injuriesForeign investigationBoeing 747-428 · Delhi Airspace, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA19WA049Incident · No injuriesForeign investigationBoeing 777 · Belo Horizonte, BrazilThe CENIPA of Brazil has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on December 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's investigation under the provisions of ICAO Annex 13 as…NTSB ERA19WA082Accident · No injuriesForeign investigationRockwell S2R · Orihueca, Magdalena, ColombiaThe government of Colombia has notified the NTSB of an accident involving a ROCKWELL S2R airplane that occurred on December 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN19WA080Accident · No injuriesForeign investigationCirrus SR22 · Toussus-Le-Noble, FranceThe government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA19WA047Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanThe ASC of Taiwan has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on December 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ASC of Taiwan's investigation under the provisions of ICAO Annex…NTSB DCA19WA044Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB ENG19RA007Incident · No injuriesForeign investigationAirbus A330 · Brussels, BelgiumThe Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…NTSB DCA19WA043Accident · No injuriesForeign investigationBoeing 777 · Hong Kong, Hong Kong SAR ChinaThe Air Accident Investigation Authority (AAIA) of Hong Kong has notified the NTSB of an accident involving a Boeing 777-300ER, which occurred on December 11, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB ENG19WA011Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…NTSB CEN19WA102Accident · 3 fatalForeign investigationCirrus SR22 · Beauberry, FranceThe government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB WPR19WA040Accident · 1 fatalForeign investigationPilatus BN2A-20 · Hobart, AustraliaOn December 7, 2018, at 0929 Universal Time Coordinated, a Pilatus Britten-Norman Ltd, BN2A-20, VH-OBL was destroyed when it collided with terrain near the Hobart Aerodrome, Hobart, Australia. The pilot, who was the sole occupant was fatally injured. The…NTSB CEN19WA043Accident · 2 fatalForeign investigationCessna 177 · Spain, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 177 airplane that occurred on December 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB ERA19WA089Accident · No injuriesForeign investigationEmbraer EMB720 · Almeirim, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB720 airplane that occurred on December 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA19WA087Accident · 2 fatalForeign investigationCessna 210 · São Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on November 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR19WA033Accident · Serious injuriesForeign investigationCessna U206 · Machadodorp, South AfricaOn November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…NTSB GAA22WA262Accident · 1 fatalClass 5 · ForeignThrush S2R · Bataan, Costa RicaNTSB WPR19WA038Accident · No injuriesForeign investigationBell 407 GX · West Bangkala, IndonesiaOn November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…NTSB DCA19WA028Incident · No injuriesForeign investigationBoeing 737 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA058Accident · 4 fatalForeign investigationCessna 525 · Jequitaí County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ENG19WA005Incident · No injuriesForeign investigationBoeing 767 · Addis Ababa, EthiopiaOn November 26, 2018, a Boeing 767-300 airplane, operated by Ethiopian Airlines, experienced a right engine (No. 2) fan blade failure during takeoff from the Addis Ababa Bole International Airport (ADD), Ethiopia. The airplane returned to ADD where an…NTSB DCA19WA068Incident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB WPR19WA032Accident · 1 fatalForeign investigationRobinson R22 · Alice Springs, AustraliaOn November 24, 2018, at 1200 local time, a Robinson R22 BETA, VH-KZV, collided with terrain near Alice Springs, NT, Australia. The helicopter sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight…NTSB ERA19WA104Accident · 6 fatalForeign investigationAgusta AW109 · Campos do Jordao, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB WPR19WA081Accident · 5 fatalForeign investigationCessna U206 · Chemajenjera Hill, ZimbabweOn November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…NTSB ERA19WA054Accident · 5 fatalForeign investigationEurocopter EC120 · La Romana, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB DCA19WA026Incident · No injuriesForeign investigationBoeing 737 · La Paz, BoliviaThe AIG of Bolivia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Bolivia's investigation under the provisions of ICAO Annex…NTSB ERA19WA053Accident · 2 fatalClass 5 · ForeignCessna TU206 · Puente Alto, ChileNTSB ERA19WA075Accident · 2 fatalForeign investigationCessna 172 · Denizli, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB ERA19WA045Accident · No injuriesForeign investigationPiper PA25 · Ezperanza, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…NTSB DCA19WA224Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Hong Kong, ChinaNTSB CEN19WA041Accident · 2 fatalForeign investigationCessna T206H · Tampico, MexicoOn November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…NTSB DCA19WA023Incident · No injuriesForeign investigationEmbraer 190 · Bara, PortugalThe GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…NTSB DCA19RA025Accident · No injuriesForeign investigationBoeing 757 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19WA038Accident · 1 fatalForeign investigationPiper PA25 · Pachuca, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA19WA021Accident · No injuriesForeign investigationBoeing 747 · Halifax, CanadaNTSB CEN19WA027Accident · 2 fatalForeign investigationVans (EX) RV-6 · Meraaker, NorwayOn November 7, 2018, about 1410 hours central European standard time, a Vans RV-6 airplane, Norwegian registration LN-AAL, impacted terrain under unknown circumstances near Meråker, Norway. The pilot and passenger were fatally injured. The flight departed…NTSB WPR19RA044Accident · No injuriesForeign investigationAerospatiale AS350 · Dusky Forest, New ZealandThe government of New Zealand has notified the NTSB of an accident involving a AEROSPATIALE AS350 helicopter that occurred on November 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of New Zealand's investigation…NTSB DCA19WA022Accident · No injuriesForeign investigationBoeing 737 · Callao, PeruThe CIAA of Peru has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA of Peru's investigation under the provisions of ICAO Annex 13…NTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNTSB CEN19WA042Accident · No injuriesForeign investigationPiper PA34 · Uk, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceNTSB ERA19WA288Accident · No injuriesForeign investigationEmbraer EMB-202 · Miranda, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB-202 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…