NTSB investigations, 2010, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 year(c.\"eventDate\") = 2010
AND c.\"eventCountry\" <> 'USA'
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' 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 ERA11WA008Accident · 9 fatalForeign investigationCessna 402 · Nassau, BahamasOn October 5, 2010, about 1236 Atlantic standard time, a Cessna 402C, Bahamian registration C6-NLH, registered to and operated by Lebocruise Air Limited, crashed into Lake Killarney shortly after takeoff from the Lynden Pindling International Airport (MYNN),…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…NTSB DCA11WA002Accident · No injuriesForeign investigationBoeing 767 · Bristol, United KingdomOn October 3, 2010, at 0541 UTC, a Thompson Airways Boeing 767 experienced a hard landing at Bristol International Airport (BRS), Bristol, England. The aircraft was completing a flight from Cancun International Airport (CUN), Cancun, Mexico. Upon parking,…NTSB ERA11WA004Accident · 6 fatalForeign investigationCessna 185 · Nazca, PeruOn October 2, 2010, about 2102 Universal Coordinated Time (UTC), a Cessna 185, Peruvian registration OB-1808, operated by Air Nasca S.A.C., on a commercial air tour flight, was substantially damaged, when it impacted terrain after a loss of power during…NTSB DCA11WA001Incident · No injuriesForeign investigationBoeing 737 · Amsterdam, NetherlandsOn October 2, 2010, Turkish Airlines flight CAI603, a Boeing 737-400, registered in Turkey as TC-TJF, overran runway 22 at Schiphol Airport (EHAM), Amstedam, the Netherlands. Only the nose landing gear exited the paved surface and the airplane was undamaged.…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 CEN10WA583Incident · No injuriesClass 5 · ForeignCessna 680 · Bedfordshire, United KingdomOn September 30, 2010, at 0825 universal coordinated time (UTC), a Cessna 680, G-CJCC, operated by Bookajet, experienced a left main bus electrical system fault, approximately 20 minutes after taking off from Luton Airport (EGGW), en route to the Milas-Bodrum…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 CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoNTSB 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 ENG12RA005Accident · Minor injuriesForeign investigationAirbus A319 - 132 · Palermo (Sicily), ItalyNTSB ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB ENG10RA054Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn September 25, 2010, a Southern Air Transport Boeing 747-281F, Reg. No. N758SA, experienced an uncontained LPT failure of the GE CF6-50 engine in the No. 3 position during taxi for takeoff from Frankfurt International Airport, Frankfurt, Germany. The No. 3…NTSB DCA10WA098Incident · No injuriesForeign investigationMcdonnell Douglas MD-11F · Kabul, AfghanistanOn Sept 22, 2010, a World Airways MD-11 scraped the right wingtip during a go-around at Kabul Afghanistan. The aircraft had minor damage and there were no injuries. The investigation is being conducted by the Civil Aviation Authority of Afghanistan. All…NTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…NTSB DCA10WA099Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryOn September 20, 2010 about 1:00 PM local time, a Hungarian Airlines Boeing 737-600, registration HA-LOE, experienced a yaw event at about 95 knots and aborted the takeoff from Budapest Ferihegy International Airport (LHBP), Budapest, Hungary. There were no…NTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB DCA10WA096Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Paris, FranceOn September 18, 2010 about 7:30 PM local time, a FedEx Express McDonnell Douglas MD-11F (registration N574FE), landed on runway 27R and crossed runway 27L Paris-Charles De Gaulle Airport (LFPG), Paris, France. As a result, a Boeing 777 aborted its initial…NTSB CEN10WA546Accident · 1 fatalForeign investigationBell 206 · San Pedro Sula, HondurasOn September 18, 2010, at 1757 coordinated universal time, a Bell 206B, HR-AVL, was substantially damaged upon impact with terrain near the La Mesa Airport, San Pedro Sula, Honduras. The pilot, the sole occupant on board, was fatally injured. The number of…NTSB ERA10WA509Accident · 4 fatalForeign investigationRobinson R44 · Lagoa do Triunfo, Para, BrazilOn September 15, 2010, about 2150 universal coordinated time, a Robinson R-44 II helicopter, Brazilian registration PR-DAN, was substantially damaged when it impacted the terrain in Lagoa do Triunfo, Para, Brazil. The pilot and three passengers were fatally…NTSB WPR10WA460Accident · 1 fatalForeign investigationCessna 188 · Geraldton Aerodrome, Australia, AustraliaOn September 14, 2010, at 0745 universal coordinated time, a Cessna 188 Agwagon, VH-KZF, collided with terrain during takeoff for an aerial application flight near Geraldton Aerodrome, Australia. The airplane was operated by Prestige Helicopters PTY LTD. The…NTSB DCA10WA101Accident · No injuriesForeign investigationATR ATR42 · Cuidad Guayana, VenezuelaOn September 13, 2010, a Venezuelan ATR-42 operated by Conviasa Airlines crashed near Cuidad Guayana, Venezuela. The accident is being investigated by the government of Venezuela and the Safety Board is assisting with flight recorder readouts. All inquiries…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…NTSB ENG10WA057Accident · No injuriesForeign investigationTupolev TU154 · Izhma, RussiaOn September 7, 2010, an Alrosa Mirny Air Enterprise Tupolev Tu-154M, registration RA-85684, overran the runway at an abandoned air strip near the town of Izhma, Russia. This accident is being investigated by the Russian Interstate Aviation Committee (MAK).…NTSB CEN10WA534Accident · Minor injuriesForeign investigationCessna 208 · Pointe a Pitre, GuadeloupeOn September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…NTSB CEN10WA538Accident · 2 fatalForeign investigationMooney M20J · Ryde, United KingdomOn September 4, 2010, approximately 1600 Universal Coordinated Time (UTC), a Mooney M20J single-engine airplane, G-JAST, and a Vans RV-4 single-engine airplane, G-MARX, collided in midair while maneuvering near Ryde, Isle of Wight, United Kingdom. G-JAST was…NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesNTSB CEN10WA574Accident · 2 fatalForeign investigationBell OH-58 · Tuxtlas, MexicoOn September 3, 2010, at an unknown time, a Bell OH-58, Mexican registration XY-KYY, was substantially damaged when it impacted terrain while conducting crop dusting operations near Tuxtlas, Mexico. Visual meteorological conditions prevailed at the time of…NTSB DCA10WA093Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanOn September 2, 2010, at 1337 UTC, an Eva Airways Boeing 747-400 ran off the edge of runway 24 upon landing at Tao Yuan International Airport, Taipei, Taiwan. The aircraft was registered in Taiwan a B-16410 and was on a scheduled passenger flight from Poo…NTSB WPR10WA443Accident · 4 fatalForeign investigationCessna 550 · Bugoiya, Papua New GuineaOn August 31, 2010, about 0630 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 550, PA-TAA, was substantially damaged following an overrun and post-crash fire after landing at the Misima Airport (MIS), Bugoiya, Papua, New Guinea.…NTSB DCA10WA094Incident · No injuriesForeign investigationBoeing 757 · Shanghai, ChinaOn August 30, 2010, a Shanghai Airlines Boeing 757 experienced a lightning strike after takeoff from PuDong International Airport, Shanghai, China. The flight returned to PuDong International Airport and landed uneventfully. No passengers or crewmembers were…NTSB 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 ERA10WA492Accident · Serious injuriesForeign investigationCessna 182Q · Taisha, EcuadorOn August 28, 2010, about 1350 eastern standard time, a Cessna 182Q, Ecuadorian registration HC-BGA, registered to and operated by Aerosangay, sustained substantial damage during a forced landing near Taisha, Ecuador. Visual meteorological conditions…NTSB CEN10WA508Accident · 3 fatalForeign investigationPiper PA32R · Oey, Gemeinde Saanen, SwitzerlandOn August 26, 2010, at 1109 coordinated universal time, a Piper PA-32R-300, Swiss registered HB-PRE, owned by Swiss Aviation Services AG, and operated by Bodanair AG, was destroyed when it impacted terrain under unknown circumstances near Oey, Gemeinde…NTSB ERA10WA455Accident · 6 fatalForeign investigationPiper PA34 · Casanare, ColombiaOn August 25, 2010, about 1330 universal coordinated time, a Piper PA-34-200T, Colombian registration, HK4429, operated by Agropecuaria–Aliar S.A., last reported their position crossing the Yopal (EYP) VOR (VHF omnidirectional radio range) at 11,500 mean sea…NTSB ERA10WA444Accident · 1 fatalForeign investigationCessna 172 · Cerro Azul, EcuadorOn August 25, 2010, about 1229 universal coordinated time, a Cessna 172, Ecuadorian registration HC-AQK, registered to and operated by AIFA as a personal flight, crashed following a loss of engine power. The airplane was substantially damaged. The pilot and…NTSB ERA10WA443Accident · No injuriesForeign investigationEmbraer EMB145 LU · Bahia, BrazilOn August 25, 2010, about 1741 Universal Coordinated Time (UTC), an Embraer EMB-145 LU, Brazilian registration PR-PSJ, operated by Passaredo Transportes Aereos LTDA, on a commercial flight, was substantially damaged, when it landed short of the runway during…NTSB DCA10WA089Accident · 14 fatalForeign investigationDornier 228 · Kathmandu, NepalOn August 24, 2010 about 7:30 AM local time, an Agni Air (registration 9N-AHE) Dornier 228 equipped with Garrett TPE331 engines, impacted terrain about 20 miles south of Kathmandu-Tribhuvan Airport (KTM), Kathmandu, Nepal. The 14 passengers and crew on board…NTSB DCA10WA087Accident · 42 fatalForeign investigationEmbraer ERJ190 · Yichun, ChinaOn August 24, 2010 at 9:40 PM local time, Henan Airlines flight VD8387 (registration B-3130), an Embraer 190 equipped with General Electric (GE) CF-34 engines, impacted terrain about 1.5 km (0.9 miles) short of runway 30 during approach to Yichun Airport,…NTSB DCA10WA091Accident · Serious injuriesForeign investigationBoeing 737 · London, United KingdomOn August 23, 2010 about 2:15 PM local time, a Scandinavian Airlines Boeing 737-600 (registration LN-RPH), experienced turbulence while on approach to London-Heathrow Airport (EGLL), United Kingdom. One flight attendant sustained serious injuries. There were…NTSB DCA10WA097Incident · No injuriesForeign investigationBoeing 737 · Venice, ItalyOn August 20, 2010, a Jet4You Boeing 737-400, registration CN-RPA, conducted an emergency descent after experiencing a rapid decompression. The flight continued on to its destination at 10,000 feet. There were no injuries to the 6 crew members onboard and the…NTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportNTSB DCA10RA085Accident · 1 fatalForeign investigationBoeing 737 · San Andres Island, ColombiaOn August 16, 2010, at 0150 UTC, an Aires B737-700, registration HK4682, crashed on approach to the San Andres Island Airport in San Andres Island, Colombia. Of the 121 passengers and 6 crew on board, preliminary reports indicate that there was one fatality…NTSB ENG10RA047Incident · No injuriesForeign investigationMcdonnell Douglas MD90 · Sendai, JapanOn August 15, 2010, at 16:10 Japan standard time (07:10 UTC), a Japan Air Lines Boeing MD90-30, registered in Japan as JA002D, experienced an engine fire in the right engine, an International Aero Engine (IAE) V2525-D5, shortly after takeoff from Sendai,…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 CEN10WA471Accident · No injuriesForeign investigationCirrus Design SR20 · Oxfordshire, United KingdomNTSB ERA10WA415Accident · 1 fatalForeign investigationHughes 369 · Minsk, BelarusOn August 8, 2010, at 1249 coordinated universal time (1549 local time), a Hughes 369, German registration D-HDWM, was destroyed when it impacted terrain at Borovaya Airfield (UMMB), near Minsk, Belarus. The German pilot was fatally injured. The helicopter…NTSB CEN10RA511Accident · No injuriesForeign investigationPiper PA-28 · San Jose, Costa RicaOn August 8, 2010, a Piper PA-28-180, TI-AGR, was substantially damaged following an in-flight fire during a departure from the Tobias Bolaños Palma International Airport (MRPV), Favorita Norte, Pavas, Costa Rica. The pilot, the sole occupant was not injured.…NTSB ERA10WA482Accident · 1 fatalForeign investigationCessna 402 · Arnos Vale, St. Vincent & GrenadinesOn August 5, 2010, at 2217 UTC, a Cessna 402-C, J8-SXY, operated by St. Vincent Grenadines Air Limited, was destroyed following an in-flight breakup about 7 minutes after departure from E.T. Joshua Airport (TVSV), Kingstown, St. Vincent. The airplane was on a…NTSB ERA10WA394Accident · 1 fatalForeign investigationBell Helicopter Textron Canada 206B · Libertad, Uruguay