NTSB investigations, Outside the U.S.
331 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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" = '470' 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 CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandNTSB CEN17WA049Accident · 4 fatalForeign investigationBeech E 90 · Toledo, SpainNTSB ERA16WA298Accident · 2 fatalClass 3 · ForeignCessna 550 · Charallave, VenezuelaNTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaNTSB CEN16WA045Accident · 4 fatalForeign investigationPiper PA 46 350P · Taunton, United KingdomNTSB CEN16WA010Accident · 1 fatalForeign investigationPiper PA31 · Veracruz, NicaraguaNTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenNTSB CEN15WA143Accident · 1 fatalForeign investigationJudr Zdenek Prazdny Rotorway · Bohušovice nad Ohrí, CzechiaNTSB CEN15WA133Accident · 1 fatalForeign investigationPiper PA 46 350P · Meyrin, SwitzerlandNTSB ERA15WA026Accident · 1 fatalForeign investigationCessna 310R · Governors Harbor, BahamasNTSB ERA15WA050Accident · No injuriesForeign investigationCessna A188B · Rozo, ColombiaNTSB ERA14LA424Accident · 2 fatalLimited investigationFinal reportSocata TBM 700 · Caribbean Sea, A1The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…NTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB CEN14WA531Accident · 2 fatalForeign investigationPiper PA-31 · Manan, CanadaNTSB ERA14WA381Accident · Serious injuriesForeign investigationPiper PA-25-260 · Tolima, ColombiaOn August 8, 2014, about 2215 coordinated universal time, a Piper PA-25-260, Colombian registration HK1680, was substantially damaged when it impacted terrain near Tolimo, Colombia. The pilot was seriously injured. The local aerial application flight was…NTSB CEN14WA420Accident · 1 fatalForeign investigationQuicksilver MXL Sport II · Cuenca, SpainOn August 8, 2014, about 1920 coordinated universal time, a Quicksilver MXL Sport II, motorized ultralight (ULM) aircraft, registry EC-FL8, was substantially damaged after impacting terrain during takeoff. The pilot was fatally injured. At the time of the…NTSB WPR14WA304Accident · 1 fatalForeign investigationCessna 182 - L · Albury Aerodrome, AustraliaOn July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…NTSB CEN14WA297Accident · No injuriesForeign investigationCessna F182 - Q · Monhoudou, FranceOn June 8, 2014, at 0800 UTC, a Cessna F182Q, French Registration F-GAQR, was destroyed during a runway excursion while landing at the Chateau de Monhoudou private airstrip (LK7255) near Monhoudou, France. The pilot and three passengers were not injured. The…NTSB CEN14WA254Accident · 1 fatalForeign investigationAir Tractor AT802 · Seron, SpainOn May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal…NTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, BoliviaNTSB ANC14RA051Accident · Minor injuriesForeign investigationExtra 300 - L · Fukushima City, JapanOn May 12, 2014, at 0115 coordinated universal time, a Japanese registered Extra 300L airplane, JA111L, operated by a private individual, experienced a loss of engine power followed by a forced landing near Fukushima City, Japan. The pilot and one passenger…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 CEN14RA212Accident · 8 fatalForeign investigationBritish Aerospace HS 125 700A · Saltillo, MexicoOn April 19, 2014, about 1945 hours central daylight time, a British Aerospace HS 125 700A, XA-UKR, impacted an industrial complex and terrain while on final approach to Plan de Guadalupe International Airport (SLW), near Saltillo, Mexico. A postimpact ground…NTSB WPR14WA164Accident · 2 fatalForeign investigationQuest Kodiak · Jayapura, Papua, Indonesia, IndonesiaOn April 9, 2014, at 0025 universal coordinated time, a Quest Aircraft Company, Kodiak-100, PK-SDF, during takeoff from Doyo Baru Airstrip, Jayapura, Papua, Indonesia, the airplane lost altitude and struck the airport fence and subsequently came to rest on a…NTSB ERA14WA186Accident · 1 fatalForeign investigationBoeing B75 · Lujan, ArgentinaOn March 29, 2014, about 1900 coordinated universal time, a Boeing B75 Stearman, Argentine registration LV-HAF, was substantially damaged when it impacted the ground during the initial climb after takeoff from the Lujan Airport, Lujan, Argentina. The pilot…NTSB ERA14WA196Accident · 2 fatalForeign investigationRobinson R22 - Beta · Ribeirão Preto, BrazilOn March 23, 2014, about 1355 universal coordinated time, a Robinson R22 Beta, Brazilian registration PP-SSP, was substantially damaged when it impacted the ground on a corn plantation in Ribeirao Preto, Brazil. The pilot and a passenger were fatally injured.…NTSB WPR14WA154Accident · 5 fatalForeign investigationCessna U206 - G · Caboolture, AustraliaOn March 22, 2014 about 1123 local time, a Cessna 206 airplane, Australian registration VH-FRT, crashed shortly after takeoff near Caboolture, Australia. The airplane was substantially damaged and the pilot and four passengers were fatally injured. The…NTSB ERA14WA154Accident · 5 fatalForeign investigationBeech BE9L-C90 · Villavicenco, ColombiaOn March 12, 2014, about 1133 universal coordinated time, a Hawker Beechcraft BE9L- C90, Colombian registration HK4921, was destroyed by impact and a postcrash fire, in the vicinity of Villavicencia, Meta, Colombia. The Colombian commercial pilot and four…NTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…NTSB ERA14WA131Accident · 2 fatalForeign investigationRobinson R44 · Braganca, BrazilOn February 15, 2014, about 2200 coordinated universal time (UTC), a Robinson, R 44 helicopter, Brazilian registration PT-YMF, was destroyed when it impacted the ground in a dense forest in the Bragança Municipality, in the State of Pará, Brazil. The…NTSB ERA14WA114Accident · 2 fatalForeign investigationCessna 140 · Cachoeira do Sul, BrazilOn January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…NTSB CEN14WA117Accident · 7 fatalForeign investigationBritten Norman BN-2A-27 · Horea, RomaniaOn January 20, 2014, about 1400 coordinated universal time, a Britten-Norman BN-2A-27 airplane, YR-BNP, impacted mountainous terrain near Horea, Cluj, Romania. The two pilots, and five passengers were all fatally injured. The airplane was destroyed. The…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 ERA14WA079Accident · 4 fatalForeign investigationCessna 172A · Teresina Municipality, BrazilOn December 26, 2013, about 2148 universal coordinated time (UTC), a Cessna 172, Brazilian registration PT-CNL, was destroyed while conducting touch and go landings in the Teresina Municipality, State of Piauí, Brazil. The pilot, copilot, and 2 passengers…NTSB ERA15WA034Accident · No injuriesForeign investigationBombardier CL 600 2B16 · Charallave, VenezuelaNTSB ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNTSB ERA14WA036Accident · 2 fatalForeign investigationPiper PA-34-200 · Marica, BrazilOn October 21, 2013, about 1840 universal coordinated time (UTC), a Piper PA-34-200, Brazilian registration PT-KGK, while on a local training flight, impacted in a lagoon, after a loss of control, in Marica Municipality – State of Rio de Janeiro, Brazil. The…NTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceNTSB CEN13WA548Accident · 3 fatalForeign investigationRobinson R44 · Wygonin, PolandOn September 13, 2013, about 0750 coordinated universal time, a Robinson R44 II helicopter, SP-WNP, impacted terrain near Wygonin, Poland. A postimpact fire ensued. The pilot and two passengers were fatally injured and the helicopter was destroyed. The flight…NTSB ERA13LA380Accident · Minor injuriesLimited investigationFinal reportPiper PA46R-350T · Cat Cay, BahamasThe pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…NTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…NTSB ERA13WA296Accident · 1 fatalForeign investigationExtra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, RussiaNTSB CEN13WA311Accident · 1 fatalForeign investigationSaab 91C · Söderhamn, SwedenOn June 1, 2013, at 1215 universal coordinated time, a SAAB model 91C (Safir) airplane, Swedish registration SE-KVC, collided with terrain shortly after takeoff from the Söderhamn Airport (ESNY), near Söderhamn, Sweden. A postimpact fire destroyed the…NTSB ERA13WA304Accident · Minor injuriesForeign investigationEurocopter BO-105 · Granville, Cedros, Trinidad & TobagoOn March 26, 2013, about 1300 universal coordinated time, a Eurocopter BO-105 helicopter, Trinidad and Tobago registry 9Y-TIC, was substantially damaged during a forced landing to a forested area in Granville, Cedros, Trinidad and Tobago. The pilot sustained…NTSB ERA13WA162Accident · 3 fatalForeign investigationBeech 35 · Los Amores, Santa Fe, ArgentinaOn March 9, 2013, about 2030 coordinated universal time (UTC), a Beech 35, Paraguayan registration ZP-BAM, was destroyed when it impacted terrain in Los Amores, Santa Fe Province, Argentina. The pilot and two passengers were fatally injured. The flight…NTSB ERA13WA158Accident · 9 fatalForeign investigationBeech B200 · La Libertad, PeruOn March 6, 2013, about 1245 UTC, a Beech B200, OB-1992, registered to Dearborn and Flint Aviation Co, Inc., operated by Aero Transporte Sociedad Anonima ATSA, collided with a wire then terrain during visual approach to Aerodrome Pias (SPIS), La Libertad,…NTSB WPR13LA137Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Latangai Island, Papua New GuineaThe failure of both the pilot and the fish master of the vessel to adequately monitor their environment, which resulted in a collision.NTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…NTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…