NTSB investigations, Outside the U.S.
197 cases where the sequence of events included Miscellaneous/other.
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA21WA077Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Vereda La Pedrera, ColombiaNTSB DCA21WA231Accident · No injuriesClass 5 · ForeignBoeing 737 · Ikeja, NigeriaNTSB DCA21WA078Incident · No injuriesClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanNTSB DCA20WA144Incident · No injuriesForeign investigationBoeing 737 · West Midland, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB DCA20WA078Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA20WA068Incident · No injuriesForeign investigationBoeing 737 · Madrid, SpainThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737-300, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist…NTSB DCA20WA063Incident · No injuriesForeign investigationAirbus A300 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an incident involving a AIRBUS A300 airplane that occurred on January 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB WPR20WA129Accident · Minor injuriesClass 5 · ForeignCessna U206G · Happy Valley, AustraliaNTSB WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…NTSB WPR20WA137Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe government of South African Civil Aviation Authority has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on October 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South…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 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 CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…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 CEN19WA288Accident · 2 fatalForeign investigationZenair CH601 · Pont-A-Celles, BelgiumThe government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR19WA151Accident · 1 fatalClass 5 · ForeignRobinson R44 II · Tai Po, ChinaNTSB ENG19WA023Incident · No injuriesForeign investigationBoeing 767 · Johannesburg, South AfricaThe Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…NTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaNTSB 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 WPR18WA225Accident · 1 fatalForeign investigationRobinson R22 · Queenstown, South AfricaOn August 15, 2018, at 0830 Universal Coordinated Time, a Robinson R22 Beta helicopter, ZS-HBP, impacted power lines while conducting a game capturing flight near Queenstown, South Africa. The pilot sustained serious injuries and the passenger was fatally…NTSB WPR18WA235Accident · 1 fatalForeign investigationAyres S2R · Diatar, MauritaniaOn August 8, 2018, at an unknown time, an Ayres S2R T34 airplane, F-GOKZ, impacted terrain during an agricultural operation near Diatar, Mauritania. The pilot was fatally injured. The airplane was being operated under the pertinent civil regulations of the…NTSB DCA18WA297Incident · No injuriesForeign investigationAirbus A330 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on July 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA207Incident · No injuriesForeign investigationBoeing 737 · Otopeni, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB DCA21WA027IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsNTSB WPR18WA138Accident · 2 fatalForeign investigationTaylorcraft BC12 · Vryheid, South AfricaOn April 29, 2018, at 1110 coordinated universal time, a Taylorcraft BC 12-D airplane, registration ZS-BLD, sustained substantial damage under unknown circumstances following a departure from Vryheid Aerodrome (FAVY), Kwa-Zulu Natal, South Africa. Both…NTSB DCA18WA153Incident · No injuriesForeign investigationAirbus A319 115 · MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A319 115 airplane that occurred on April 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB WPR18WA240Accident · No injuriesForeign investigationCessna 206 · Southport, AustraliaOn March 4, 2018, about 1040 local time, a Cessna U206G airplane, VH-LHQ, was substantially damaged when it impacted water during takeoff near Southport, Queensland, Australia. The pilot and two passengers were not injured. The investigation is under the…NTSB ENG18RA015Incident · No injuriesForeign investigationBoeing 757 · Auckland, New ZealandThe Australian Transport Safety Bureau has notified the NTSB of an incident involving a Boeing 757-236, which occurred on February 5,2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau investigation…NTSB ERA18WA066Accident · 2 fatalForeign investigationRobinson R44 · Recife, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on January 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ENG18WA038Incident · No injuriesForeign investigationEmbraer ERJ190 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving an Embraer 190-200 LR, which occurred on October 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB ERA17WA342Accident · 1 fatalForeign investigationRobinson R44 · Cape Town, South AfricaOn September 28, 2017, about 1000 coordinated universal time, a Robinson R44 II helicopter, South African registration ZS-OSL, was destroyed when it impacted terrain during an emergency autorotation near Cape Town, South Africa. The pilot was fatally injured.…NTSB DCA17WA216Incident · No injuriesForeign investigationBoeing 737 · Luga, MaltaThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB ERA17WA323Accident · 1 fatalForeign investigationBritten Norman BN2A · San Salvador de Paul, VenezuelaOn September 11, 2017 about 1400 coordinated universal time, a Britten Norman BN2-A, Venezuelan registration YV1441, was landing at San Salvador de Paul, Ciudad Bolivar, Venezuela, when it struck and fatally injured a child who was on the runway. The pilot…NTSB ERA17WA259Accident · 2 fatalForeign investigationCirrus Design SR20 · Santo Antonio do Leverger, BrazilOn July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…NTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB DCA17WA121Incident · No injuriesForeign investigationBoeing 737 · Sint Maarten, NTThe government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…NTSB ENG17WA025Incident · No injuriesForeign investigationBombardier BD700 1A11 · Hong Kong, Hong Kong SAR ChinaThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Bombardier Global Express BD700, which occurred on November 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…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 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 WPR16WA143Accident · 1 fatalForeign investigationCessna 150 · New Crown Station, AustraliaOn July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…NTSB ENG16WA035Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DIRECCIÓN GENERAL DE AERONAUTICA CIVIL (DGCA) of Mexico has notified the NTSB of an incident involving a Magnicharter Boeing 737, which occurred on July 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA investigation…NTSB DCA16WA189Incident · No injuriesForeign investigationBoeing 737 · Launceston, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB CEN16WA140Accident · 2 fatalForeign investigationCessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, GuatemalaOn March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…NTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN16WA124Incident · No injuriesForeign investigationCessna 525 · Lugano, SwitzerlandNTSB ERA16WA101Accident · Serious injuriesForeign investigationRobinson R66 · Aviatornyi, RussiaOn February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…NTSB CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…NTSB CEN16WA060Incident · No injuriesForeign investigationSikorsky S92 · Wexford, IrelandOn December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…