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 DCA16WA231Accident · No injuriesForeign investigationBoeing 727 · Kamina, Congo - KinshasaThe government of Dem. Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 727 airplane that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's investigation…NTSB WPR16WA186Accident · 4 fatalForeign investigationLittle Eagle LE500 · Shijiazhuang City, ChinaOn September 15, 2016, about 0308 Universal Time, a Little Eagle LE500 single-engine airplane, Chinese registration B-9246, impacted flat terrain about 1,640 feet from the approach end of runway 18, at the Luan Cheng General Aviation Airport, Shijiazhuang…NTSB ERA16WA317Accident · 2 fatalForeign investigationPiper PA28 · Flanders, ColombiaOn September 15, 2016, about 1523 universal coordinated time, a Piper PA-28-140; Colombian registration, HK1328G, operated by Aeroandes Flight Training School, and a Cessna 152; Columbian registration, HK2092G, operated by Acahel Flight Training School…NTSB DCA16WA239Incident · No injuriesForeign investigationCessna 152 · Malindi, KenyaThe Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an incident involving a Cessna 152 airplane that occurred on September 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under the…NTSB DCA16WA225Accident · No injuriesForeign investigationBoeing 737 · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB CEN16WA376Accident · No injuriesForeign investigationSchweizer 269C · Lausanne - La Blecherette, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Schweizer Aircraft Corporation 269 helicopter, HB-ZLB, that occurred on September 13, 2016. The NTSB has…NTSB CEN16RA399Accident · No injuriesForeign investigationCessna P210N · Guatemala City, GuatemalaOn September 13, 2016, about 1600 UTC, a Cessna turbo P210N, N210BC, owned and operated by a private individual lost engine power in cruise flight and impacted on a road near Guatemala City, Guatemala. The pilot on board was not injured. The airplane…NTSB DCA16WA241Accident · No injuriesForeign investigationCessna 152 · Nairobi, KenyaThe Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on September 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID investigation under the…NTSB WPR16WA180Accident · 1 fatalForeign investigationCessna 172RG · Parafield Aerodrome, Australia, AustraliaOn September 11, 2016, at 1606 local time, Cessna 172RG, VH-MKG, while hand-starting the engine at Parafield Aerodrome, Australia, the pilot was fatally injured and the damage to the airplane is unknown. The flight was under the pertinent civil regulations of…NTSB OPS16WA017Incident · No injuriesForeign investigationAirbus A330 · Gold Coast, AustraliaThe Australian Transport Safety Bureau (ATSB) of Australia has notified the NTSB of an incident involving an Airbus A330-343, which occurred on September 11, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under…NTSB CEN16WA400Accident · No injuriesForeign investigationPiper PA-28-161 · Sevilla, SpainOn September 9, 2017, at 1918 local time, a Piper PA-28-161, Spanish registration EC-JCI, had a brake failure while taxiing at Sevilla Airport, Sevilla, Spain. There were no injuries to the private pilot and one passenger, The airplane was substantially…NTSB DCA16WA237Accident · No injuriesForeign investigationCessna 210 · Naivasha, Nakuru County, KenyaThe Kenya Air Accident Investigation Department (AAID) has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on September 08, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under…NTSB CEN16WA365Accident · 1 fatalForeign investigationRobinson R66 · Carinthia, AustriaOn September 8, 2016, at 1920 coordinated universal time (UTC), a Robinson R66, Austrian registration OE-XHA, was destroyed when it impacted terrain under unknown circumstances near Carinthia, Austria. Visual meteorological conditions prevailed at the time of…NTSB ERA16WA342Accident · No injuriesForeign investigationCessna 172RG · Amalfi, ItalyThe government of Italy has notified the NTSB of an accident involving a Cessna Aircraft Company 172RG airplane that occurred on September 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation…NTSB ENG16WA036Incident · No injuriesForeign investigationBoeing 777 · Tarcoola, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 777-31HER which occurred on September 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions…NTSB CEN16WA368Accident · 6 fatalForeign investigationPiper PA34 · Skopje, Macedonia, North MacedoniaOn September 6, 2016, about 1540 local time, a Piper PA-34-200T multi-engine airplane, serial number 34-8070170, German registry D-GLLW, was destroyed after impacting terrain while on an ILS approach to Runway 34 at Alexander the Great Airport (LWSK), Skopje,…NTSB CEN16WA367Accident · No injuriesForeign investigationUNknown Hummingbird 300LS · Rzeszow, PolandOn September 6, 2016, at 1125 UTC, an amateur built Hummingbird 300LS helicopter, Polish registration SP-YLN, caught fire during the on-ground cool down period following the first hovering flight of the helicopter after being built. The accident occurred at…NTSB CEN16WA357Accident · 2 fatalForeign investigationRobin DR400 · Villanueva del Condado, SpainOn September 6, 2016, about 1420 hours coordinated universal time (UTC), a French manufactured Robin DR400-180 airplane, Spanish registration EC-KFG, impacted terrain neat Villanueva del Condado, Leon, Spain. The pilot and passenger were fatally injured. The…NTSB ANC16WA064Accident · 1 fatalForeign investigationBell 206B · Fox Creek, CanadaOn September 5, 2016, about 1520 mountain daylight time, a Bell 206B helicopter, Canadian registration C-GHHU, impacted terrain during an aerial survey flight subsequent to a power loss about 12 miles southwest of Fox Creek, Alberta, Canada. The helicopter…NTSB CEN16WA358Accident · 2 fatalForeign investigationBell 206B · Flatlands, CanadaOn September 4, 2016, about 1600 Atlantic Daylight Time, a Bell model 206B helicopter, Canadian registration C-GVJT, serial number 3492, collided with power lines during cruise flight before crashing into the Restigouche River near Flatlands, New Brunswick,…NTSB ANC16WA063Accident · Serious injuriesForeign investigationBell 206B · Williams Lake, CanadaOn September 3, 2016, about 1530 Pacific daylight time, a Bell 206B helicopter, Canadian registration C-FWHF, impacted terrain following a loss of engine power during a visual approach to landing about 58 miles east of Williams Lake, British Colombia, Canada.…NTSB ERA16WA315Accident · 2 fatalForeign investigationAir Tractor AT502 · Sorriso, BrazilOn September 1, 2016, about 1905 coordinated universal time, a privately owned and operated Air Tractor AT-502B, Brazilian registration PR-SLV, experienced an in-flight loss of control and impacted terrain near Sorriso Municipality, State of Mato Grosso,…NTSB CEN16WA371Accident · 3 fatalForeign investigationPiper PA28 · Bovec, SloveniaOn September 1, 2016, about 1545 coordinated universal time, a Piper PA-28-161, Slovenia-registration S5-DES, was destroyed when it crashed into mountainous terrain near Bovec, Slovenia. The pilot and two passengers were fatally injured. The flight originated…NTSB DCA16CA220Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · International Waters, A1an inadvertent encounter with severe convective turbulence.NTSB DCA16WA228Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Boeing 777 that occurred on August 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB WPR16WA192Accident · 3 fatalForeign investigationCessna 182 · Mpumalanga Province, South AfricaOn August 27, 2016, about 1025 coordinated universal time, a Cessna 182Q, South African registration ZS-PHB, was destroyed when it impacted terrain shortly after takeoff from Komati Gorge Lodge private airstrip, Mpumalanga Province, South Africa. The pilot…NTSB WPR16WA190Accident · 1 fatalForeign investigationXtremeair XA42 · Zhangye Ganzhou, ChinaOn August 27, 2016, at 1047 local time, an XtremeAir XA-42, N344XA, operated by Southern Aircraft Consultancy Inc. collided with the ground during an aerobatic maneuver at an airshow near the Zhangye Ganzhou Airport, China. The airplane was operating under…NTSB ERA16WA307Accident · 1 fatalForeign investigationPiper PA25 · Finca, ColombiaOn August 26, 2016, about 1250 coordinated universal time, a Piper PA-25-260, Colombian registration HK588, operated by Fumigaciones Aereas Del Norte S.A.S., was destroyed when it collided with an electrical wire and terrain near Finca, Colombia. The…NTSB CEN16WA403Accident · No injuriesForeign investigationRobin DR400/180R · Schaffhausen, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a ROBIN DR400/180R airplane that occurred on August 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under…NTSB ERA16WA310Accident · No injuriesForeign investigationLearjet 55 · Eleuthera, BahamasOn August 25, 2016, about 1903 universal coordinated time, a Learjet 55, N666TK, operated by RCR7 LLC, was substantially damaged during a runway excursion following an aborted takeoff at North Eleuthera Airport, Eleuthera, Bahamas. The two pilots and seven…NTSB CEN16WA337Accident · 1 fatalForeign investigationYakovlev/Chinnery YAK 11 · Speyer, GermanyOn August 25, 2016, at 0651 universal coordinated time, a Yakolev YAK-11, US registration N111YK, crashed under unknown circumstances in Speyer, Germany. The pilot was fatally injured and the airplane was destroyed. The accident investigation is under the…NTSB ERA16WA298Accident · 2 fatalClass 3 · ForeignCessna 550 · Charallave, VenezuelaNTSB DCA16WA240Accident · No injuriesForeign investigationCessna 401 · Antalaha, MadagascarNTSB CEN16WA345Accident · No injuriesForeign investigationRobinson R44 · Plasy, CzechiaNTSB ERA16WA292Accident · Serious injuriesForeign investigationEurocopter AS355 · Santo Domingo, Dominican RepublicOn August 14, 2016, about 2040 coordinated universal time, a Eurocopter AS355 F2, Dominican registration HI-861, was substantially damaged during a hard landing at the La Isabela International Airport (MDJB), Santo Domingo, Dominican Republic. The pilot was…NTSB CEN16WA395Accident · Serious injuriesForeign investigationBell 206 · Sayaxché, GuatemalaOn August 12, 2016, about 1500 universal coordinated time (UTC), a Guatemalan-registered Bell 206-L3 helicopter, TG-CHB, crashed near Sayaxche, Guatemala. The pilot was seriously injured, one passenger received minor injuries, and two passengers were…NTSB CEN16WA325Accident · 1 fatalForeign investigationPiper PA38 · Peterborough, CanadaOn August 11, 2016, at 0520 coordinated universal time, a Piper PA-38-112, Canadian-registered C-FSYH, was damaged when it struck several metal poles during a forced landing near Peterborough, Ontario, Canada. Visual meteorological conditions prevailed at the…NTSB ERA16WA287Accident · 2 fatalForeign investigationCessna 172 · Fredonia, ColombiaOn August 9, 2016, about 2156 universal coordinated time, a Cessna 172N, Colombian registration HK4822G, was substantially damaged when it impacted terrain near Fredonia, Antioquia, Colombia. The flight instructor and student pilot were fatally injured and…NTSB CEN16WA340Accident · 1 fatalForeign investigationQuad City Challenger II · Amos, CanadaOn August 9, 2016, at 1530 UTC, a Quad City Challenger II (S/N CH2-0903-2368), C-IIJW, impacted terrain near the runway end at Amos/Magny Airport (CYEY), Amos, Quebec, Canada. The aircraft was destroyed and sole occupant on board was fatally injured. The…NTSB ERA16WA283Accident · Serious injuriesForeign investigationRobinson R66 · Voronezhskaya oblast, RussiaOn August 7, 2016, about 1030 coordinated universal time, a Robinson Helicopter R66, Russian registration RA-06347, was substantially damaged when it impacted electrical transmission lines near Borki village, Ramogn region, Voronezhskaya oblast, Russia. The…NTSB ENG16WA032Incident · No injuriesForeign investigationBoeing 787 · Over the Pacific, A1On August 7, 2016, a Jetstar Boeing 787, powered by 2 General Electric (GE) GEnx-1B64/P2 engines experienced a right engine (No. 2) low oil quantity indication while cruising over the Pacific. The engine was shutdown and the airplane was diverted to Guam…NTSB CEN16WA318Accident · 1 fatalForeign investigationPiper PA28 · Winchelsea, East Sussex, United KingdomOn August 6, 2016, a Piper PA-28-161 airplane, G-CDER, sank after ditching near Winchelsea, East Sussex. The pilot was fatally injured. This investigation is under the jurisdiction and control of the government of the United Kingdom. Any further information…NTSB DCA16WA219Accident · No injuriesForeign investigationRobinson R66 · Drakensburg Mountain, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB DCA16WA210Accident · No injuriesForeign investigationBoeing 737 · Bergamo, ItalyThe Agenzia Nazionale per la sicurezza del volo (ANSV) of Italy has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the…NTSB DCA16WA218Accident · 4 fatalForeign investigationRobinson R44 · Lusikisuki, near Port John, Eastern Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB DCA16RA206Accident · 1 fatalForeign investigationBoeing 777 · Dubai, United Arab EmiratesThe United Arab Emirates General Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a BOEING 777 that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the…NTSB DCA16CA209Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Grand Cayman Island (GCM), Cayman Islandsan inadvertent encounter with clear air turbulence.NTSB DCA16WA216Incident · No injuriesForeign investigationBoeing 737 · Mbuji Mayi, Congo - KinshasaThe government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on August 02, 2016. The NTSB has appointed a U.S. Accredited Representative to DRC under the provisions of ICAO Annex 13 as…NTSB WPR16WA161Accident · 1 fatalForeign investigationPiper PA31 · Nong Prue, Thailand, ThailandOn August 1, 2016, at 1605 local time, a Piper PA31-350, HS-FGB, was destroyed after it collided with a wooden bridge during an emergency landing near Nong Prue, Thailand. The aircraft was operated under the pertinent regulations of the Government of…NTSB ERA16WA306Accident · 8 fatalForeign investigationEmbraer EMB820 · Londrina City, BrazilOn July 31, 2016, at 2357 universal coordinated time, an Embraer EMB820C (Piper PA-31-350), Brazilian registration PT-EFQ, was destroyed when it impacted a power line and terrain following a loss of power in the left engine, while on approach to Londrina…