NTSB investigations, Outside the U.S.
66 cases where the sequence of events included Part(s) separation from AC.
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\" = '338' 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" = '338' 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 DCA15WA163Incident · No injuriesForeign investigationBoeing 737 - 4Q8 · St Georges sur Meuse, BelgiumThe Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB CEN15WA193Accident · 2 fatalForeign investigationRans S6 - ES · Tan Rouge, RéunionOn March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…NTSB DCA15WA075Accident · No injuriesForeign investigationBoeing 747 - 468 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…NTSB ERA14WA246Accident · Serious injuriesForeign investigationCessna T206H · Macas, EcuadorOn May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…NTSB DCA14WA042Incident · No injuriesForeign investigationBoeing 767 332 · Buenos Aires, ArgentinaThe Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…NTSB ANC13RA061Accident · No injuriesForeign investigationDe Havilland DHC-2 MK 1 · Half Moon Bay, CanadaOn June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…NTSB ERA12WA200Incident · No injuriesForeign investigationBombardier 60 · Europe, A1On February 12, 2012, at an unknown time and location, the cargo compartment door of a Bombardier Aerospace Learjet 60, Estonia registration ES-PVP, separated from the airframe in flight. The airplane incurred minor damage, while the two crewmembers and four…NTSB CEN12WA144Accident · No injuriesForeign investigationRobinson R22 · Lincolnshire, United KingdomOn January 6, 2012, about 1127 universal time (UTC), a United Kingdom registered Robinson R22 Beta, G-CHZN, sustained substantial damage when it impacted terrain near Witchford, Cambridgeshire, United Kingdom. The pilot was fatally injured. The investigation…NTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…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 DCA11WA042Incident · No injuriesForeign investigationBoeing B737 · Hamburg, GermanyOn April 7, 2011, a Boeing 737-800, German registration D-ABEH, operated by Deutsche Lufthansa, experienced a failure of the nosewheel upon landing at Hamburg Airport, Germany. The flight was a regularly scheduled domestic passenger flight from Koln-Bonn,…NTSB ERA11WA159Accident · 1 fatalForeign investigationRobinson R44 · Canne della Battaglia, ItalyOn February 18, 2011, about 0706 universal coordinated time, a Robinson R44, French registration F-GUJB, crashed after an in-flight separation of the tail rotor from the fuselage. The pilot was killed. The flight departed Bari, Italy, for Foggia Airport…NTSB ERA10WA149Incident · No injuriesForeign investigationPiper PA32 · Santiago, EcuadorOn February 6, 2010, about 1020 central standard time, a Piper PA-32-300, of Ecuadorian registration, HC-BOD, registered to and operated by Fundacion Amazonia Verde, separated the left main wheel during the landing roll at the Mashuim Airstrip, Santiago,…NTSB CEN09WA612Accident · 2 fatalForeign investigationEurocopter AS350 · Barcelona, SpainOn June 22, 2009 a Eurocopter AS350B3, Spanish registration EC-IOJ was destroyed while filling the fire attack system with water during a fire extinguishing operation. The pilot and passenger both were killed. According to several witness statements, the…NTSB ENG08IA030IncidentIncident investigationFinal reportBoeing B747 · Jeddah, Saudi ArabiaFailure of the low pressure turbine stage 3 disk due to a design that is vulnerable to high pressure turbine unbalance-induced synchronous vibration that cannot be detected in flight, and the subsequent uncontained engine failure.