Skip to content

NTSB investigations, 2010, Outside the U.S.

20 cases where the sequence of events included Unknown or undetermined.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Latest cases

Query with SQL

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 year(c."eventDate") = 2010 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' 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

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 year(c.\"eventDate\") = 2010
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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 year(c."eventDate") = 2010
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' 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 ERA11WA090Accident · 2 fatalForeign investigationHawker Beechcraft TC-45J · Nassau, BahamasOn December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…Dec 14, 2010 · N38L · Destroyed NTSB CEN11WA094Accident · 1 fatalForeign investigationCessna F150 · Linköping, SwedenOn December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…Dec 1, 2010 · SE-IGU · Substantial damage NTSB DCA11WA114Accident · 1 fatalForeign investigationPiper PA32 - 301 · Vipingo Ridge, KenyaOn October 23, 2010, about 0653 UTC, 5Y-NAM, a Piper PA-32R-301, a personal flight, had an inflight breakup during cruise flight and crashed in an open field at Vipingo Ridge, Kenya. The pilot, the sole occupant, was fatally injured. The aircraft was…Oct 23, 2010 · 5Y-NAM · Substantial damage NTSB ERA11WA031Accident · 5 fatalForeign investigationCessna TU206G · Medellin, ColombiaOn October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…Oct 20, 2010 · HK2933 · Destroyed NTSB DCA11WA003Accident · 8 fatalForeign investigationLockheed L-100 · Kabul, AfghanistanOn October 12, 2010, about 1505 UTC, a Trans Afrique Airlines (under contract to National Air Cargo) Lockheed L-100, registration 5X-TUC, impacted terrain while maneuvering to land at Kabul International Airport (OAKB), Kabul Afghanistan. The two flight crew…Oct 12, 2010 · 5X-TUC · Destroyed NTSB ERA11WA041Accident · 2 fatalForeign investigationPiper PA38 · Buenos Aires, ArgentinaOn October 3, 2010, about 1920 Universal Coordinated Time (UTC), a Piper PA-A-38-112, Argentinean registration LV-MNO, crashed into terrain during an instructional flight near Marcos Paz, Argentina. The local training flight originated from San Fernando…Oct 3, 2010 · LV-MNO · Substantial damage NTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoSep 25, 2010 · N91HV · Substantial damage NTSB ERA10WA507Accident · 2 fatalForeign investigationRobinson R44 · Itanhaem, BrazilOn September 10, 2010, about 1445 Universal Coordinated Time (UTC), a Robinson Helicopters R44, Brazilian registration PT-YON, operated by AM Transportes Ltda ME, crashed into mountainous terrain near Itanhaem, State of Sao Paulo, Brazil. The flight was en…Sep 10, 2010 · PT-YON · Substantial damage NTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportAug 17, 2010 · N540WC · Destroyed NTSB CEN10WA585Accident · 2 fatalForeign investigationSchweizer 269C · Saint Gondon, FranceOn July 25, 2010, at 0800 coordinated universal time, a Schweizer 269C, French registered F-GJGQ, was destroyed when it impacted trees in a wooded area under unknown circumstances near Saint-Gondon, France. Visual meteorological conditions prevailed at the…Jul 25, 2010 · F-GJGQ · Destroyed NTSB ANC10WA073Accident · 1 fatalForeign investigationBeech B36TC · Peace River, CanadaJul 24, 2010 · N64631 · Substantial damage NTSB WPR10WA321Accident · 1 fatalForeign investigationErickson S64E · Borneo Island, IndonesiaJun 25, 2010 · N229AC · Substantial damage NTSB ERA10WA327Accident · Serious injuriesForeign investigationCessna · Pavacachi, EcuadorOn June 22, 2010, about 1345 universal time, a Cessna TU-206F, HC-BYA, registered to and operated by Servicio Aero Quichua De Pasta, as a cargo flight, initiated a descent in the vicinity of Pavacachi, Ecuador. Visual meteorological conditions prevailed and a…Jun 22, 2010 · HC-BYA · Substantial damage NTSB ERA10WA171Accident · 2 fatalForeign investigationRobinson R44 · Karelia, RussiaOn March 10, 2010, about 0900 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Russian registration RA-04163, operated by a private individual, was involved in an accident under unknown circumstances near Karelia, Russia. The helicopter departed…Mar 10, 2010 · RA-04163 · Substantial damage NTSB DCA12WA015Incident · No injuriesForeign investigationBoeing 737 · Brussels, BelgiumThe Irish Air Accident Investigation Unit (AAIU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on March 1, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of…Mar 1, 2010 · EIDYI · Minor damage NTSB ERA10WA153Accident · 7 fatalForeign investigationCessna U206F · Nazca, PeruOn February 25, 2010, about 1630 universal coordinated time (1130 local time), a Cessna U206F, Peruvian registration OB-1117, operated by Nazca Airlines, was destroyed when it impacted terrain near Nazca, Ica Province, Peru. The Peruvian commercial pilot and…Feb 25, 2010 · OB-1117 · Destroyed NTSB DCA10WA043Incident · No injuriesForeign investigationBoeing 757 - 236 · Bacelona, SpainThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-236 that occurred on February 21, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…Feb 21, 2010 · G-CPET · No damage NTSB ERA10WA157Accident · 4 fatalForeign investigationBell 206 · Carayaca, VenezuelaOn February 19, 2010, about 1950 Universal Coordinated Time, a Bell 206B helicopter, Venezuelan registration YV2191, operated by Aeromedic 2005, was lost from contact with Maiquetia approach control. The helicopter departed from Generalisimo Francisco de…Feb 19, 2010 · YV2191 · Substantial damage NTSB DCA10WA035Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaOn February 12, 2010, a Metro Batavia Boeing 737-200, registration PK-YTR, aborted the takeoff from runway 10 at Juanda Airport, Surabaya, Indonesia. There were no injuries to the 5 crew members and 120 passengers onboard and the airplane received minor…Feb 13, 2010 · PK-YTR · Minor damage NTSB ERA10WA130Accident · 2 fatalForeign investigationPiper PA-34 · Ipero, BrazilOn January 27, 2010, at 0918 EST, a Piper PA-34, PR-UGO, of Brazilian registration, registered to and operated by an individual, crashed 10 minutes after takeoff. The pilot and passenger were killed and the airplane was substantially damaged. The weather at…Jan 27, 2010 · PR-UGO · Substantial damage