NTSB investigations, 2009, 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\") = 2009
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") = 2009 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 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 DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB DCA10WA002Incident · No injuriesForeign investigationBoeing 737 · Bologna, ItalyOn September 24, 2009, a Bluebird Cargo Boeing 737-300, registration TF-BBD, conducted an emergency descent after experiencing a rapid decompression and diverted into Bologna Airport (LIPE), Bologna, Italy. There were no injuries to the 2 crew members and the…NTSB DCA09WA079Accident · 1 fatalForeign investigationBAE Jetstream 41 · Durban, South AfricaOn September 24, 2009 about 0557 UTC, a BAE Jetstream 4100, ZS-NRM, operated by South African Air Link on a positioning flight, crashed shortly after takeoff from runway 06 at Durban Airport, South Africa. The pilot reported a loss of power in one engine…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 ENG09WA022Incident · No injuriesForeign investigationAirbus A319 · Copenhagen, Denmark, DenmarkOn September 17, 2009, a British Airways Airbus A319-131, powered by two International Aero Engines V2522-A5 engines, experienced a bird strike and subsequent engine stall in the No. 1 engine (left-hand) during climb after takeoff at approximately 5,000 feet.…NTSB CEN09RA590Accident · 3 fatalClass 5 · ForeignPiper PA34 · Castro Verde, PortugalOn September 15, 2009, at 2055 Western European Summer Time, a Piper PA-34-220T, OO-TML, registered to Ben-Air Flight Academy was destroyed upon impact with terrain during a night navigation training flight. The airplane had disappeared from radar and no…NTSB ERA09WA519Accident · 2 fatalForeign investigationRobinson R44 · Perm, RussiaOn September 14, 2009, at 0700 Universal Time Coordinated, a Robinson R44-II, Russian registration RA-04289, operated by Geliks Airline, crashed 6.2 miles from the Perm Airport, Perm, Russia. The pilot and passenger were killed, and the helicopter sustained…NTSB ENG09IA016Incident · No injuriesIncident investigationFinal reportBoeing 767 432ER · St. Johns, CanadaIncorrect installation of a wire bundle, which contained wires for oxygen system, passenger address system and lavatory power, led to chafing of the wires on structure. The chafing eventually exposed the wire conductors and resulted in electrical arcing,…NTSB CEN09WA582Accident · 2 fatalForeign investigationReims F172 · Commune de Brethencourt, FranceUnder the jurisdiction and control of the French government.NTSB ENG09IA017Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ 190-100 IGW · Nassau, Bahamasfailure of the engine high pressure turbine active clearance control valve fuel rod supply tube coupling seal due to a cross-threaded B-nut as installed during original manufacture.NTSB DCA09WA076Accident · 5 fatalForeign investigationBell 430 · Kurnoon, IndiaOn September 2, 2009, at approximately 0343 UTC, a Government of Andhra Pradesh Gad (Poll "c") Bell 430 helicopter crashed enroute to Chitoor, India from Hyderabad, India. There were 2 crew members and 3 passengers, including the Secretariat of Hyderabad on…NTSB CEN10WA072Accident · 1 fatalForeign investigationCessna 414 · Simeprodeso, MexicoNTSB CEN09WA607Accident · No injuriesForeign investigationEurocopter AS350 B2 · Némisko, CanadaOn August 28, 2009, at 1200 eastern daylight time, a Eurocopter model AS350 B2 (AStar), s/n 3292, Canadian registration C-FHAP, experienced a loss of engine power during cruise flight near Némisko, Québec, Canada. The helicopter was substantially damaged…NTSB ERA09WA486Accident · Minor injuriesForeign investigationCessna 208 · La Tortuga, VenezuelaOn August 26, 2009, about 1152 UTC, a Cessna 208B, Venezuelan registration YV1182, registered to and operated by Linea Turista Aerotuy (LTA), as a scheduled domestic passenger flight, had a total loss of engine power. The airline transport (ATP) rated pilot…NTSB ERA09WA478Accident · No injuriesForeign investigationAgusta A109E · Ras Tanajib, Saudi ArabiaOn August 22, 2009, at 0506 universal coordinated time, an Agusta 109E helicopter, N906AH, operated by Saudi Aramco Aviation, sustained substantial damage during landing and a post crash fire at barge Arabyia 4, in the Persian Gulf, near Ras Tanajib, Saudi…NTSB CEN10WA486Accident · 2 fatalForeign investigationCessna T206 · Hamburg Harbour, GermanyOn August 22, 2009, at 1252 coordinated universal time, a Cessna T206H, was substantially damaged when it nosed over during a water landing at Hamburg Harbour, Hamburg, Germany. Visual meteorological conditions prevailed at the time of the accident. The pilot…NTSB ENG09WA012Incident · No injuriesForeign investigationBoeing 737 · Launceton, Tasmania, AustraliaThe Australian Transport Safety Bureau (ATSB) reported that on August 21, 2009, a Virgin Blue Boeing 737-800 airplane registered in Australia as VH-VOC, experienced two compressor surges in the left engine, a CFMI CFM56-7, shortly after takeoff from Launceton…NTSB ENG10WA006Incident · No injuriesForeign investigationBoeing 737-236 · Coca, Ecuador, EcuadorOn August 19, 2009, a Boeing 737-236, registration number HC-CFD, experienced a thrust reverser separation from the No. 1 (left) engine, a Pratt & Whitney JT8D-17A turbofan, after touchdown runway 15 and thrust reverser deployment at the Coca - Aeropuerto…NTSB CEN09WA524Accident · 2 fatalForeign investigationBeech 99 · Évora, PortugalUnder the jurisdiction and control of the Portuguese government.NTSB DCA09WA072Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanOn August 10, 2009, a Boeing 737-800, registered JA56AN, operated by Air Nippon Co., Ltd. as flight ANA298, took off from Tottori Airport at 19:12 Japan standard time (10:12 UTC) and landed at runway B of Tokyo International Airport at 20:23 Japan standard…NTSB ENG13WA019Accident · No injuriesForeign investigationCessna 172P · Khaoyai National Park, Thailand, ThailandOn August 9, 2009, a Cessna 172P aircraft, registered HS-BAE, operating a route training flight from Nakhon Ratchasrima Airport Thailand to Donmuang International Airport (Bankok Thailand) with 2 student pilots, collided into mountainous terrain in Khaoyai…NTSB ERA09WA552Accident · No injuriesForeign investigationMooney M20F · Warwickshire, United KingdomOn August 8, 2009, at 1218 UTC, a Mooney M20F, G-CEJN, was substantially damaged when the landing gear collapsed during landing at Wellesbourne Mountford Airfield, Warwickshire, United Kingdom. The pilot was not injured. Visual meteorological conditions…NTSB CEN09WA529Accident · 2 fatalForeign investigationBell 412 · Manzanillo, MexicoOn August 7, 2009 a Bell Helicopter model 212 was destroyed when it impacted the ground in low visibility mountainous terrain. The pilot and on board mechanic were killed. The helicopter is located near a mountain top and is not accessible. When to helicopter…NTSB ENG09WA020Incident · No injuriesForeign investigationAustriaOn August 6, 2009, at approximately 15:28 coordinated universal time (UTC), a Fokker F28 Mk0100, registered in Austria and operated by an Austrian Commercial Aircraft Operator, experienced an electrical fire/smoke during engine startup for departure at…NTSB ENG09WA015Incident · No injuriesForeign investigationAirbus A320 · Paris ORLY, FranceOn August 5, 2009, a Vueling Airlines Airbus A320-211, registration number EC-ICQ, flight number VY9127, experienced a No. 2 engine, a CFM CFM56-5A turbofan engine, undercowl fire after push back from the gate and engine start. Ground crew informed the flight…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 DCA09IA071Incident · Minor injuriesIncident investigationFinal reportBoeing 767-224 · Bavaro, Dominican RepublicThe flight crew's inadvertent flight through the top of a convective updraft that resulted in an encounter with convective induced turbulence. Contributing to the severity of the incident was the unrestrained status of several passengers, contrary to the…NTSB CEN09WA499Accident · 2 fatalForeign investigationTorrance, CanadaOn August 3, 2009, 1545 eastern daylight time, a Cessna TU-206, C-GGMG impacted trees during takeoff from Lake Muskoka, near Torrance, Ontario, Canada. The airplane was destroyed. The pilot and passenger sustained fatal injuries. The flight was originating at…NTSB DCA09WA074Incident · No injuriesForeign investigationBoeing 757 · Barcelona, SpainOn August 2, 2009, at about 0750 UTC, a British Airways Boeing 757-236, registration number G-CPEM, declared an emergency during descent into Barcelona International Airport, Barcelona, Spain. The flight had originated at the London Heathrow International…NTSB DCA09WA070Accident · 1 fatalForeign investigationCessna U206 · Nairobi, KenyaOn August 1, 2009, about 1130 UTC, 5Y-LMB, Cessna U206, owned and operated by the African Inland Mission, collided with the ground at Nairobi, Kenya. The airplane was conducting low flight while the passengers were filming the underlying area. During the…NTSB ENG09WA010Incident · No injuriesForeign investigationBoeing · Melbourne, AustraliaOn July 24, 2009, about 2230 UTC, a Virgin Blue, Boeing 737-700 airplane, registration VH-VBA, sufferend a failue of the nose landing gear axle. During taxi for takeoff, the right nosewheel separated from the nose landing gear leg. The aircraft was able to be…NTSB DCA09WA066Incident · No injuriesForeign investigationBoeing 767 · Keflavik, IcelandOn July 20, 2009, UAL flight 949, a B767 enroute from London Heathrow to Chicago O'Hare experienced smoke in the cockpit and the crew elected to divert to Keflavik, Iceland. The flight landed without further incident and no injuries among the 11 crew and 178…NTSB ANC09WA079Accident · 2 fatalForeign investigationRobinson R44 · Tajima, JapanOn July 20, 2009, about 0925 Japan standard time, a Robinson R44 helicopter, Japanese registration JA32CT, collided with mountainous terrain about 9 miles southeast of the Tajima Airport, Tajima, Japan. The helicopter sustained substantial damage due to…NTSB ANC09WA071Accident · 2 fatalForeign investigationPiper PA-46-31P · Kamsack, CanadaOn July 19, 2009, about 2100 central standard time, a Piper PA-46-31P airplane, Canadian registration C-GUZZ, crashed on takeoff from Kamsack, Saskatchewan, Canada. Two people aboard received fatal injuries, and the remaining two people aboard received…NTSB CEN09WA454Accident · 1 fatalForeign investigationCirrus SR22 · Perrigny, FranceUnder the jurisdiction and control of the French government.NTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.NTSB DCA10WA009Incident · Serious injuriesForeign investigationBoeing 737 · Stansted, United KingdomOn July 17, 2009, while boarding the airplane, a child passenger fell off the airstair to a Ryanair Boeing 737, registration EI-DLJ, at London Stansted airport. The passenger was seriously injured. The UK AAIB is investigating.NTSB ANC09WA063Accident · 1 fatalForeign investigationMaule M-5-235C · Whitehorse, CanadaOn July 13, 2009, about 2145 pacific daylight time, a float-equipped Maule M-5-235C airplane, N9138E, nosed over and partially sank while landing on Kluane Lake, about 127 miles northwest of Whitehorse, Yukon, Canada. The airplane was being operated as a…NTSB CEN09RA443Incident · No injuriesForeign investigationGulfstream GIV · Kerry, IrelandOn July 13, 2009, at 0815 Coordinated Universal Time, a Gulfstream Aerospace G IV SP, VT-MST, registered to Asia Aviation Ltd, descended below the minimum safe altitude and flew near mountainous terrain in instrument meteorological conditions after departing…NTSB ERA09WA408Accident · 2 fatalForeign investigationBeech A36 · Masizo del Roraima, Venezuela, VenezuelaOn July 16, 2009, about 1640 Atlantic standard time, the wreckage of a Beechcraft A36 A, N354RA, was located on the “Ilu – Tepuy” mountain, within the sector of Masizo del Roraima, Bolivar, Venezuela. The pilot had filed a flight plan from the Maurice Bishop…NTSB CEN09WA476Accident · Serious injuriesForeign investigationCessna U206G · Stadtlohn-Wenningfeld, GermanyNTSB ANC09WA084Accident · 2 fatalForeign investigationKawasaki BK117 · Kinmen, TaiwanOn July 10, 2009, about 0420 Taiwan standard time, a Kawasaki BK-117-B1 helicopter, Taiwanese registration B-77088, collided with ocean water about 1 mile south of the Kinmen Island Airport, Kinmen, Taiwan. The helicopter sustained substantial damage due to…NTSB ERA09WA406Accident · Serious injuriesForeign investigationPiper PA-34-200T · Imperatrize, Maranhao, BrazilOn July 3, 2009, at 2146 UTC, a Piper PA-34-200T, PT-RFU, registered to and operated by Heringer Taxi Aereo LTD, as a cargo flight,lost engine power on one engine after takeoff from Imperatriz, Maranhao Airport, Brazil. The pilot attempted to return to the…NTSB DCA09WA063Accident · 152 fatalForeign investigationAirbus A310 · Moroni, ComorosOn June 29, 2009, about 2251 UTC, an Airbus A310-300, 7O-ADJ, operated as Yemenia flight 626, collided with the waters of the Indian Ocean, during an approach to land at Moroni, Comoros. Of the 153 aboard, one passenger was the sole survivor and the aircraft…NTSB WPR09WA296Accident · 1 fatalForeign investigationRobinson R22 · Paraburdoo, AustraliaOn June 25, 2009 at 2230 local time, a Robinson R22 helicopter, Australia registry VH-HXO, collided with the ground near Paraburdoo, Western Australia. The helicopter was owned and operated by a private individual and was on a non-commercial cross country…NTSB ERA09WA551Accident · No injuriesForeign investigationCessna 172 · Palazzolo dello Stella, ItalyNTSB DCA09IA064Incident · No injuriesIncident investigationFinal reportAirbus A330-323 · Kagoshima, JapanBrief and temporary blockage of the pitot probes in cruise flight, most likely due to ice crystals aloft, leading to erroneous airspeed indications and airplane automation degradation as designed. Contributing to the incidents were design features of the…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 DCA09WA062Incident · No injuriesForeign investigationBoeing 767 · North Bay, CanadaOn June 19, 2009, a Boeing 767-300, registration SP-LPA, operated by LOT Polish Airlines (flight number LOT 2) departed O'Hare International Airport, Chicago, Illinois (ORD) destined for Warsaw, Poland. In the vicinity of North Bay, Ontario, Canada, while…