NTSB investigations, Outside the U.S.
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.\"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 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 DCA17WA030Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe Mexican Direccion General de Aeronautica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737, which occurred on November 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB DCA17WA023Incident · No injuriesForeign investigationBoeing 737-476 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CCAA) has notified the NTSB of an incident involving a BOEING 737-476 airplane that occurred on November 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…NTSB ERA17WA178Accident · Minor injuriesForeign investigationCessna 210 · Metropolitana, ChileOn August 11, 2016, at 1312 coordinated universal time, a Cessna 210N, Chilean registration CC-LLH, was substantially damaged when it impacted terrain during a forced landing near Metropolitana, Chile. The pilot and one passenger sustained minor injuries.…NTSB WPR17WA028Accident · 1 fatalForeign investigationAir Tractor AT502 · Walgett, AustraliaNTSB GAA17WA584Accident · No injuriesClass 5 · ForeignDHC 4 · Perkumpulan, IndonesiaNTSB WPR17WA016Accident · 2 fatalForeign investigationRobinson R44 · Kamo, New Zealand, New ZealandOn October 30, 2016, a Robinson R44, ZK-HTH, was destroyed by fire after it collided with terrain near Kamo, New Zealand, The helicopter was operated by Helisika Agricultural Limited under the pertinent regulations of the government of New Zealand. The pilot…NTSB WPR17WA095Incident · No injuriesForeign investigationCessna 500 · Banswara, IndiaOn October 27, 2016, at 0745 universal coordinated time (1315 local time), a Cessna 500 SII Citation, VT-KMB, sustained minor damage following a runway excursion in Banswara, India. The airplane was operated under the pertinent regulations of the Government…NTSB CEN17WA086Accident · 1 fatalForeign investigationMooney M20K · Saarbrucken, GermanyOn October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was…NTSB ERA17WA051Accident · 2 fatalForeign investigationEmbraer EMB711 · Espumoso, BrazilOn October 25, 2016, about 1250 coordinated universal time (1050 local time), an Embraer 711C, Brazilian registration PT-NQS, operated by a private individual, was destroyed after it impacted the ground shortly after takeoff from Espumoso Airport (SSEZ),…NTSB DCA17WA015Accident · No injuriesForeign investigationLockheed Stalker · Avoca, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's…NTSB DCA17WA014Accident · No injuriesForeign investigationLockheed Stalker · Mount Disappointment, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's…NTSB ERA17WA028Accident · 3 fatalForeign investigationRobinson R44 · Baleisky, RussiaOn October 23, 2016, about 1030 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04347, was destroyed when it impacted terrain in the Baleisky district, in eastern Siberia, Russia, while en route from Zolotorechensk Airport to…NTSB DCA17WA224Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board has notified the NTSB of a serious incident involving a BOEING 757 airplane that occurred on October 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iceland's…NTSB ERA17WA090Accident · 3 fatalForeign investigationAerofab Lake LA 250 · Puerto Plata, Dominican RepublicOn October 17, 2016, about 2200 coordinated universal time, an AeroFab, Inc. Lake-250, N724ST, was substantially damaged when it impacted the ocean while on approach to Gregorio Luperón International Airport (POP), Puerto Plata, Dominican Republic. The pilot…NTSB CEN17WA017Accident · 1 fatalForeign investigationCessna F150 · Cambridge, United KingdomOn October 17, 2016, at 1021 coordinated universal time, a Reims Cessna F150M airplane, G-BDZC, crashed after takeoff at the Bourn Airfield (EGSN), Cambridge, United Kingdom. The pilot was fatally injured.The accident investigation is under the jurisdiction…NTSB ERA17WA025Incident · No injuriesForeign investigationPiper PA23 · Chimbote, PeruOn October 16, 2016, at 1937 universal time coordinated, a Piper PA-23-250 twin-engine airplane, Peruvian registration OB-2039, was not damaged during a precautionary landing to the Jaime Montreuil M. Airport (CHM), Chimbote, Peru. According to Peruvian…NTSB ERA17WA021Accident · 2 fatalForeign investigationCessna 172 · Peloponnese, GreeceOn October 16, 2016, about 1415 universal coordinated time, a Cessna 172P, Greek registration 5B-CLB, was destroyed when it impacted mountainous terrain while performing a cross-country training flight near Peloponnese, Greece. The Greek certificated…NTSB CEN17WA141Accident · No injuriesForeign investigationReims 406 · Oulu, FinlandOn October 3, 2016, a Reims F406 Caravan II aircraft, registered OH-OTL, experienced a landing gear failure while landing at Oulu Airport, Finland. The airplane was substantially damaged. The two pilots onboard were uninjured. The accident is being…NTSB CEN17WA020Accident · Serious injuriesForeign investigationSocata TBM700 · Surrey, United KingdomOn October 15, 2016, a Socata TBM700 airplane, M-VNTR, undershot the runway at Fairoaks Airport (EGTF), near Surrey, England. There were two persons on board, one of whom was seriously injured.This investigation is under the jurisdiction and control of the…NTSB ANC17WA030Accident · 4 fatalForeign investigationCessna 500 · Kelowna, CanadaOn October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft…NTSB DCA17WA010Accident · No injuriesForeign investigationPiper PA28 · Jozini, South AfricaThe government of South Africa has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on October 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB ERA17WA009Accident · 3 fatalForeign investigationCessna 207 · Santa Cruz, Cajamarca, PeruOn October 10, 2016, about 1427 universal coordinated time, a Cessna 207A, Peruvian registration OB-1936-P, was destroyed during a collision with mountainous terrain near Santa Cruz, Cajamarca, Peru. The pilot and two passengers were fatally injured. The…NTSB DCA17WA012Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia (KNKT/NTSC) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on October 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's…NTSB DCA17WA006Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB DCA17WA032Accident · No injuriesForeign investigationCessna 172 · Brits, North West Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving ZS-MPF, a Cessna 172M airplane that occurred on October 07, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB ENG17WA002Incident · No injuriesForeign investigationMD Helicopter 500 · Wanaka, New ZealandThe Civil Aviation Authority of New Zealand has notified the NTSB of an incident involving a MD Helicopters MD520N, which occurred on October 6, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…NTSB ANC17WA002Accident · 1 fatalForeign investigationSteen Skybolt · Blackfalds, CanadaOn October 06, 2016, about 2050 Coordinated Universal Time, an amateur-built Steen Skybolt airplane, C-GWBD, impacted terrain near Blackfalds, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB ENG17WA001Accident · No injuriesForeign investigationBoeing 737 · Aldergrove, United KingdomOn October 4, 2016, a Boeing 737-400 experienced a partial right main gear failure during the landing roll at Belfast International Airport (EGAA), Aldergrove, Northern Ireland, United Kingdom. The flight originated from East Midlands Airport (EGNX),…NTSB ERA17WA004Accident · No injuriesForeign investigationCessna 208 · Contamana, PeruOn October 3, 2016, about 1530 universal coordinated time, a Cessna 208B, Peruvian registration OB-1998-P, was substantially damaged when the left main landing gear separated from the airplane while taxiing at Contamana Airport (SPCM), Contamana, Peru. The…NTSB CEN17WA008Accident · 1 fatalForeign investigationNorth American P-51D · East Anglia, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted…NTSB ERA16WA332Accident · 4 fatalForeign investigationCessna 208 · San Antonio De Prado, ColombiaOn September 30, 2016, about 1705 coordinated universal time, a Cessna 208B, Colombian registration HK3804, was substantially damaged when it impacted high terrain near San Antonio De Prado, Colombia. One of the Colombian certificated pilots and three of the…NTSB DCA16WA242Incident · No injuriesForeign investigationBeech 1900C · Long Key, BahamasThe Bahamas Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a Beech 1900 on September 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of ICAO Annex…NTSB ENG16RA041Incident · No injuriesForeign investigationBAE AVRO146RJ · Malmo, SwedenThe Swedish Accident Investigation Authority has notified the NTSB of an incident involving a BAE Systems (Operations) Limited Avro 146-RJ100 which occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Swedish…NTSB DCA16WA233Accident · No injuriesForeign investigationBeech 1900 · Mavivi, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BEECH 1900 airplane that occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB DCA16WA229Incident · No injuriesForeign investigationPulse Vapor 55 · Ballina, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Pulse Vapor 55 unmanned helicopter that occurred on September 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation…NTSB DCA16WA227Incident · No injuriesForeign investigationBoeing 777 · Abu Dhabi, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on September 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation…NTSB CEN16WA392Incident · No injuriesForeign investigationGulfstream G200 · Barcelona, SpainOn September 26, 2016, about 1959 hours universal coordinated time, a Gulfstream model G200 airplane, serial number 145, Spanish registration EC-KBC, was involved in a runway excursion while landing on runway 25R at Barcelona/El Prat Airport (LEBL), near…NTSB CEN16WA384Accident · 2 fatalForeign investigationCessna 206 · Lake Kuashkuapishiu, CanadaOn September 25, 2016, a Cessna U206F airplane, C-FWBQ, collided with terrain after departing from Lake Kuashkuapishiu, Quebec. The pilot was seriously injured and two passengers were fatally injured. This investigation is under the jurisdiction and control…NTSB ERA16WA327Accident · 2 fatalForeign investigationAgusta Bell AB206-B3 · Yartsevo, RussiaOn September 24, 2016, at an unknown time, an Agusta-Bell AB206-B3 helicopter, Russian registration RA-01630, was substantially damaged when it crashed under unknown circumstances near Yartsevo, Russia. The pilot and passenger were fatally injured.The…NTSB ENG16RA042Accident · No injuriesForeign investigationBAE JETSTREAM4100 · Siddharthanagar, NepalThe Government of Nepal Ministry of Culture, Tourism and Civil Aviation has notified the NTSB of an accident involving a BAE Systems (Operations) Limited Jetstream 41 which occurred on September 24, 2016. The NTSB has appointed a U.S. Accredited…NTSB ANC16RA074Accident · 1 fatalForeign investigationPitts S2 · Seoul, South KoreaOn September 24, 2016 , about 1132 local time, an Aviat Pitts S-2B airplane, Republic of Korea registration number HL1161, operated by the pilot, was destroyed following an impact with terrain during an airshow at Taean Airfield, Republic of Korea. The pilot…NTSB DCA16WA230Accident · Serious injuriesForeign investigationBoeing 737 · Lores, NetherlandsThe Dutch Safety Board (DSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on September 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DSB's investigation under the provisions of ICAO Annex 13 as…NTSB ERA16WA334Accident · 4 fatalForeign investigationBeech E55 · Campinapolis, BrazilOn September 22, 2016, about 2210 universal time coordinated, a Beech E55, Brazilian registration PR-DTA, was destroyed when it impacted terrain near Campinapolis, Brazil. The airplane departed the Santa Genoveva Airport (SBGO), Goiana, Brazil, and was…NTSB ENG16WA043Incident · No injuriesForeign investigationAirbus A320 · Brisbane, AustraliaAn Australian-registered A320-232 airplane in cruise flight between Sydney and Cairns, Australia had a failure of the right engine, an International Aero Engine V2527-A5. The airplane diverted to Brisbane for landing. The Australian Transport Safety Bureau…NTSB ERA16WA341Accident · No injuriesForeign investigationAir Tractor AT602 · Sao Jose do Rio Preto, BrazilOn September 21, 2016, about 1415 coordinated universal time, an Air Tractor AT-602, N1001R, was substantially damaged during a forced landing to a sugar plantation, following a total loss of engine power during descent near Sao Jose do Rio Preto, Brazil. The…NTSB ENG16WA040Incident · No injuriesForeign investigationAirbus A319 · Chiclayo, PeruThe Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB CEN16WA396Incident · No injuriesForeign investigationSwearingen SA227 · Cologne, GermanyOn September 20, 2016, at 1725 UTC, a Fairchild Swearingen Corporation SA-227-AC Metroliner, German registration D-CPSW, owned and operated by BINAIR Aero, sustained minor damage when the airplane veered off the runway while landing at the Cologne/Bonn…NTSB ERA16WA337Accident · 1 fatalForeign investigationEmbraer EMB810 · Miranda, BrazilOn September 19, 2016, at 2000 coordinated universal time (1600 local), a Piper designed Embraer EMB810-D, Brazilian registration PT-VKY, was destroyed when it impacted terrain in the Miranda Municipality, State of Mato Grosso Do Sul, Brazil. The pilot was…NTSB CEN16WA377Accident · 4 fatalForeign investigationPiper PA28 · Gödöllo, Pest, Hungary, HungaryNTSB DCA16WA232Accident · No injuriesForeign investigationBell 430 · Cabinda, AngolaThe Angola Ministry of Transport (MoT) has notified the NTSB of an accident involving a BELL 430 helicopter that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MoT's investigation under the provisions of…