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 ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.NTSB WPR10WA484Accident · 1 fatalForeign investigationChampion 8KCAB · Bandung, Indonesia, IndonesiaOn September 24, 2010, at 0312 universal coordinated time, an American Champion Super Decathlon 8KCAB, PK-NZP, collided with terrain while performing an inverted aerobatic maneuver at low altitude during an air show at Husein Sastranegara Airport, Bandung,…NTSB ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB ERA10WA456Accident · 1 fatalForeign investigationCessna A188 · Pista El Limon, EcuadorOn August 29, 2010, about 1300 universal coordinated time (UTC), a Cessna A188B, Ecuadorian registration HC-BCF, operated by a private owner on an agricultural spraying flight, collided with power lines and subsequently the ground near Pista El Limon,…NTSB ERA10WA428Accident · 4 fatalForeign investigationRobinson R44 · Milazzo, ItalyOn August 12, 2010, about 0600 Universal Coordinated Time (UTC), a Robinson R44, Italian registration I-KOST, operated by Intesa Leasing, Rent and Fly, as a personal flight, collided with a building and the ground during takeoff from a private field at…NTSB ERA10WA386Accident · 2 fatalForeign investigationEmbraer EMB711 · Mato Grosso, BrazilOn July 18, 2010, about 1500 Universal Coordinated Time (UTC), an Embraer EMB-711C, Brazilian registration PT-NBE, operated by a private owner on a personal flight, collided with a hill while in cruise flight in the vicinity of Santo Antonio Do Leverger, Mato…NTSB WPR10WA309Accident · 1 fatalClass 5 · ForeignCessna 172N · Broken Hill, AustraliaOn June 21, 2010, about 0145 coordinated universal time, a Cessna 172N, VH-UFN, registered to a private owner, collided with water during an unknown flight phase near Broken Hill, New South Wales (NSW), Australia. The airplane was reported missing and was…NTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…NTSB WPR10WA185Accident · 2 fatalForeign investigationPiper PA30 · Northam, Australia, AustraliaOn March 28, 2010, at 0900 coordinated universal time, a Piper PA-30, VH-KDS, registered to a private owner, collided with terrain near Northam, Australia. The airplane was substantially damaged and the pilot and passenger were killed. The flight departed…NTSB DCA10WA025Accident · No injuriesForeign investigationBoeing 747 · Luxembourg, LuxembourgOn January 21, 2010, a Cargolux Airlines, Boeing 747-400F, registration LX-OCV, struck the top of a maintenance van that was on the runway during CAT IIIB conditions at Luxembourg-Findel International Airport, Luxembourg. The airplane landed safely with minor…NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…NTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…NTSB CEN10WA073Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Oberbarnim, GermanyOn December 10, 2009, at 1625 coordinated universal time, a Cirrus SR20, German registered D-EYAT, was destroyed when it impacted forested terrain near Oberbarnim, Germany. Instrument meteorological conditions prevailed at the time of the accident. The pilot…NTSB WPR10WA080Accident · 1 fatalForeign investigationBell 206 · Dorrigo, Australia, AustraliaOn December 9, 2009, at 1225 universal coordinated time a Bell 206 L-1, VH-MJO, operated by Commercial Helicopters Pty Ltd. collided with the terrain during takeoff near Dorrigo, Australia. The flight was for the purpose of performing an aerial survey. The…NTSB ERA10WA416Accident · No injuriesForeign investigationEmbraer EMB-720 · Fazenida Liberdade, Brazil, BrazilOn November 23 18, 2009, about 1440 Universal Coordinated Time (UTC), an Embraer EMB-720D, Brazilian registration PT-VIF, operated by W.P.Comercio De Cereais LTDA, collided with a fence as a result of a force landing from a loss of engine power during cruise…NTSB WPR10WA108Accident · 1 fatalForeign investigationCessna A188 · Kojonup, Australia, AustraliaOn November 17, 2009, at 1200 coordinated universal time, a Cessna A188B, Australian registry VH-ZRR, registered to and operated by South West Aerial Services, collided with the terrain while maneuvering during an aerial application flight near Kojonup,…NTSB WPR10WA036Accident · 1 fatalForeign investigationAir Tractor AT-502 · Narrogin, Australia, AustraliaOn October 3, 2009, at 1130 Western Standard Time, an Air Tractor AT-502, VH-ODP, operated by Agricair Pty Limited, as an agricultural flight collided with the ground while maneuvering 47 Km east northeast of Narrogin, Australia. Visual meteorological…NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB CEN09WA598Accident · 2 fatalForeign investigationSchweizer 269C · Blackpool, United KingdomOn September 22, 2009, at 1104 universal coordinated time, a Schweizer 269C helicopter, United Kingdom registered G-LINX, registered to Heli-Lynx Limited, was destroyed when it impacted terrain near Blackpool, Lancashire, England. Visual meteorological…NTSB CEN09WA506Accident · 2 fatalForeign investigationEnstrom F28 · Mont Laurier, CanadaOn August 5, 2009, at 1000 eastern daylight time, an Enstrom F28C helicopter, Canadian registered C-GVQQ, registered to a private individual and piloted by the accident pilot, was destroyed when it impacted wires and terrain near Mont-Laurier Airport (CSD4),…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 ERA09WA354Accident · 2 fatalForeign investigationRobinson R-44 · Vitoria da Conquista, BrazilOn May 22, 2009, at 2139 Coordinated Universal Time (UTC), a Brazilian registered Robinson R-44, PR-NDF, was destroyed when it impacted the ground during approach to land at the Vitoria da Conquista Airport (SBQV), Vitoria da Conquista, Brazil. The pilot and…NTSB WPR09WA292Accident · No injuriesForeign investigationCessna 208 · Vientiane, Laos, LaosOn April 11, 2009, about 1035 coordinated universal time (UTC), a Cessna 208B, Laos registration RDPL-34144, owned by Helicopters of New Zealand, operated by Lao Air, was substantially damaged during a forced landing following a loss of engine power near…NTSB CEN09WA188Accident · Minor injuriesForeign investigationBell 212 · Aguascalientes, MexicoNot Required. Investigation is being conducted by the DGAC, Mexico.NTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…NTSB WPR09LA069Accident · 1 fatalLimited investigationFinal reportHughes 369 · Honiara, Solomon IslandsThe pilot's failure to remove the tail rotor pedal lock before attempting flight, resulting in a loss of control.NTSB ERA09WA085Accident · 1 fatalForeign investigationMaule M7 · Cobra River, Manaus, BrazilOn December 7, 2008, about 1115 universal coordinated time, a Maule M-7-235, Brazilian registration PT-ONN, was substantially damaged when it impacted trees while departing from the Taruma River, Manaus, Brazil. The floatplane subsequently came to rest in the…NTSB CEN09WA073Accident · Minor injuriesForeign investigationBeech A100 · God's Lake Narrows, CanadaNone.NTSB WPR09WA250Accident · 1 fatalForeign investigationMcdonnell Douglas 369 · Murray Bridge, AustraliaOn November 19, 2008, about 1115 Australian central daylight-saving time, a pilot and two linesmen were operating a McDonnell Douglas 369D helicopter, Australian registry VH-PLJ, to test a high-voltage power line between Mannum and Mobilong, SA. While…NTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…NTSB CEN09WA016Accident · 2 fatalForeign investigationCessna 421 · Oaxaca, MexicoOn October 6, 008 at approximately 1332 central daylight time (CDT) a Cessna 421C, Mexican Registration XB-KWB was destroyed while attempting to return to Xoxocotlan International Airport (OAX,) Oaxaca, Mexico to land . Both aircraft occupants sustained fatal…