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 DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB ERA15WA346Accident · Minor injuriesForeign investigationBell 206L-3 · Boyaca, ColombiaOn September 1, 2015, about 1925 UTC, a Bell 206L-3, HK 3311, registered to and operated by Sociedad Aerea De Ibague, was landed hard in a field during a forced landing near Municipality of Chita, Boyaca, Colombia. Visual meteorological conditions prevailed…NTSB ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…NTSB CEN15WA302Incident · No injuriesForeign investigationRobinson R-22 Beta II · Hradec Kralove, Czech Republic, CzechiaOn June 29, 2015, about 0806 coordinated universal time (UTC), a Robinson R-22 Beta II, OK-ZYZ, experienced an in-flight anomaly and the pilot conducted an emergency autorotation to a field about 10 miles west of Hradec Kralove, Czech Republic. The two pilots…NTSB WPR15WA188Accident · 1 fatalForeign investigationRobinson R44 - Undesignat · Timber Creek, Australia, AustraliaOn June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…NTSB DCA15WA210Incident · No injuriesForeign investigationBoeing 737 · Nauru, NauruThe Australian Transport Safety Board (ATSB) has notified the NTSB of an accident involving a BOEING 737 that occurred on June 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB DCA15WA130Incident · No injuriesForeign investigationBoeing 737 - 4D7 · Turin, ItalyThe Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving a Boeing 737-400, which occurred on June 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the…NTSB DCA15WA178Incident · No injuriesForeign investigationBoeing Boeing 777-228 IGW · Douala, CameroonThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) has notified the NTSB of an incident involving a Boeing 777-200, which occurred on May 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA…NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB ERA15WA082Accident · 7 fatalForeign investigationCessna T207 - A · Piedecuesta, ColombiaOn December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…NTSB DCA15WA013Incident · No injuriesForeign investigationBoeing 777 · Dubai, United Arab EmiratesThe GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA15WA014Incident · No injuriesForeign investigationBoeing 737 · Hat Yai, ThailandThe Department of Civil Aviation of Thailand has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DCA's investigation under the provisions of ICAO…NTSB ERA14WA296Incident · No injuriesForeign investigationBeech 300 · Pucallpa, PeruOn June 10, 2014, at 1212 universal coordinated time, a Beech 300, Peruvian registration OB-1881P, operated by Aero Transporte S.A., sustained minor damage when its No. 1 engine experienced vibrations and was subsequently shutdown, while on approach to the…NTSB ERA14WA241Accident · 2 fatalForeign investigationCessna T210N · Para, BrazilOn April 30, 2014, about 2215 UTC, a Cessna T210N, Brazilian Registration PR-WCO, registered to and operated by Mineradora Bom Jesus Ltda, collided with trees during a go-around from landing at an airstrip located in Para, Brazil. Visual meteorological…NTSB WPR14WA085Accident · 1 fatalForeign investigationBell 206 · Berastagi, IndonesiaOn December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…NTSB DCA14WA024Incident · No injuriesForeign investigationBoeing 767 · Arusha, TanzaniaNTSB DCA14WA019Accident · No injuriesForeign investigationBoeing 767 - 300ER · Madrid, SpainNTSB DCA14WA015Incident · No injuriesForeign investigationBoeing 737-400 · Zurich, SwitzerlandThe Swiss Accident Investigation Board (SAIB) has notified the NTSB of an incident involving a Boeing 737-400 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the SAIB investigation under the provisions of…NTSB ENG13WA043Incident · No injuriesClass 5 · ForeignBoeing 737 - 53C · Cusco, PeruOn September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…NTSB DCA13WA159Incident · No injuriesForeign investigationBoeing 787 - 8QQ · Warsaw, PolandOn September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…NTSB DCA13WA144Incident · No injuriesForeign investigationAirbus Industrie A300B4-622R · Luton, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A300 operated by Federal Express Corp, which occurred on August 25, 2013. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…NTSB ERA13WA306Accident · 1 fatalForeign investigationPiper PA34 · Envira, BrazilOn June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB DCA13WA089Accident · 1 fatalForeign investigationBeech 1900 · Unkown, São Tomé & PríncipeThe Sao Tome and Principe Civil Aviation Authority (STPCAA) has notified the NTSB of an accident involving a Beech 1900 that occurred on April 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist STPCAA investigation under the…NTSB ERA13WA282Accident · 2 fatalForeign investigationRobinson R66 · Caraguatatuba, BrazilOn January 3, 2013, about 1600 coordinated universal time (UTC), a Robinson R-66 Helicopter, Brazilian registration PR-DUB, was destroyed when it impacted a dense forest and the side of a hill in the Caraguatatuba Municipality, in the State of São Paulo,…NTSB DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB DCA12WA105Incident · No injuriesForeign investigationAirbus A319 · Okinawa, JapanOn July 5, 2012, about 1324 Japan Standard Time (0424 UTC), an Airbus A319-112, (B2332), operated by China Eastern Airlines Co., Ltd., was instruction to hold short of the runway at the Naha Airport (OKA), Okinawa, Japan; however, the flight crew taxied onto…NTSB DCA12WA102Incident · No injuriesForeign investigationBoeing 767-323 · Sao Paulo, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 767 that occurred on July 3, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB DCA12WA089Accident · 14 fatalForeign investigationSikorsky S58 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación of Peru (CIAA) has notified the NTSB of an accident involving a Sikorsky S58 helicopter that occurred on June 06, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…NTSB DCA12WA070Accident · No injuriesForeign investigationBoeing 737 · Gothenburg, SwedenThe Swedish Accident Investigation Authority (SHK) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the SHK investigation under the provisions of ICAO…NTSB ERA12WA183Incident · No injuriesForeign investigationEmbraer EMB-500 · Campo Grande, BrazilOn February 3, 2012, about 2333 universal coordinated time, an Embraer EMB-500 airplane, Brazilian registration PR-PHE, experienced an anti-skid brake failure during landing roll at the Campo Grande International Airport (SBCG), Campo Grande, Brazil, which…NTSB DCA12WA028Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving an MD-80 that occurred on January 24, 2012. The ACAA delegated the investigation to the Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación…NTSB DCA12WA027Incident · No injuriesForeign investigationBoeing 777 · Rio de Janeiro, BrazilThe Brazilian Centro de Investigação e Prevenção deAcidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 777 that occurred on January, 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB CEN12WA105Accident · 2 fatalForeign investigationCessna 177A · Ottawa, CanadaOn December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…NTSB ERA11RA398Accident · 2 fatalForeign investigationRobinson R66 · Girardot, ColombiaOn July 12, 2011, about 2041 UTC, or 1541 local, a Robinson Helicopter Company R66, N810AG, registered to Aircraft Guaranty Corporation Trustee, operated by a private individual, collided with terrain near Girardot, Colombia. Visual meteorological conditions…NTSB ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…NTSB DCA10WA078Incident · No injuriesForeign investigationBoeing 757 - 212 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-200 that occurred on July 16, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…NTSB ERA11WA157Incident · No injuriesForeign investigationBeech 300 · Jundiai, BrazilOn June 29, 2010, about 1910 UTC, a Beech 300, Brazilian registration PP-EPD, operated by The Government of the State of Amazonas, Brazil had a blown tire during the landing roll following a forced landing shortly after takeoff from Jundiai Airport (SBJD),…NTSB CEN10WA331Accident · No injuriesForeign investigationCirrus Design SR20 · Sirdal, NorwayOn May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…NTSB WPR10RA197Accident · Serious injuriesForeign investigationEagle 150B · Kota Bahru, MalaysiaOn March 9, 2010, about 1630 local time, an Eagle 150B, Malaysia registration 9M-BEV, crashed near Kota Bahru, Kelantan, Malaysia, subsequent to an in-flight propeller separation. The two occupants, a flight instructor and student pilot, sustained serious…NTSB DCA10WA040Incident · No injuriesForeign investigationBoeing 727 · Torino, ItalyOn February 21, 2010, a Thomas Cook Boeing 757-200, registration G-TCBA, experienced an uncommanded fuel dump during initial climb after takeoff from Turin International Airport (LIMF), Torino, Italy. There were no injuries to the 8 crew members and 231…NTSB DCA09WA058Incident · No injuriesForeign investigationBoeing 767 · Taipei, Taiwan, TaiwanOn June 6, 2009, Japan Airlines flight 653, a Boeing 767-300, registration JA-613J, experienced a cabin fire during approach to Taoyuan International Airport (TPE/RCTP), Taipei, Taiwan. The remains of a charred lighter were found in the nook between a seat…NTSB MIA08WA200Accident · Serious injuriesClass 5 · ForeignFokker F28-4000 · Quito, EcuadorOn September 22, 2008, about 1600 universal time, a Fokker F28-4000, HC-CDT, flight ICD-504, registered to and operated by Icaro Air, as a scheduled domestic passenger flight, aborted take off on runway 35 at Mariscal Surce Airport (SEQU), Quito, Ecuador. The…