NTSB investigations, 2015, Outside the U.S.
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 2015
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") = 2015 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 ANC16WA002Accident · 1 fatalForeign investigationBell 206B · Asquinth, CanadaOn October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…NTSB DCA16WA012Accident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on October 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB ERA16WA049Accident · 1 fatalForeign investigationRobinson R44 · Guarani Municipality, BrazilOn October 25, 2015, at 1730 local time (1930 coordinated universal time), a Robinson R44, Brazilian registration PP-BAO, was substantially damaged when it impacted trees and a lake after takeoff in the Guarani Municipality, State of Minas Gerais, Brazil. The…NTSB ENG16WA016Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación – CIAA of Peru has notified the NTSB of an incident involving a Peruvian Airlines Boeing 737, which occurred on October 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA16WA050Accident · 2 fatalForeign investigationCessna 150H · Rondonopolis Municipality, BrazilOn October 22, 2015, about 1130 coordinated universal time , a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…NTSB CEN16WA020Accident · 4 fatalForeign investigationLearjet 31 · La Tinaja, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaNTSB ERA16RA021Accident · 10 fatalForeign investigationBeech 60 · Bogota, ColombiaOn October 18, 2015 at 2119 UTC, a Beechcraft B60, Colombian registration HK3917G, registered to and operated by Sky Hub Aviation, was destroyed during a collision with a building in Barrio El Lujan, Bogota, Colombia. The pilot, three passengers, and six…NTSB ANC16WA004Accident · 2 fatalForeign investigationCessna 207 · Taylor, CanadaOn October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…NTSB ERA16WA013Accident · 3 fatalForeign investigationCessna 208B · Yumbillo, ColombiaOn October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB ERA16WA017Accident · 1 fatalForeign investigationEmbraer EMB721C · Corumba, BrazilOn October 6, 2015, about 1200 universal coordinated time, an Embraer EMB721C, Brazilian registration PT-RAM, was substantially damaged when it encountered a wind gust and struck a tree, during takeoff from Guanabara Farm, Corumba, Brazil. The pilot and one…NTSB CEN16WA009Accident · 2 fatalForeign investigationBell 430 · Xalapa, MexicoOn October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…NTSB ERA16WA002Accident · 2 fatalForeign investigationPiper PA-31-325 · Chia, ColombiaOn October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…NTSB CEN16WA002Accident · 2 fatalForeign investigationBeech 200 · Chigwell, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an incident involving a Beech B200 that occurred on October 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB ENG16IA001Incident · No injuriesIncident investigationFinal reportBoeing 747 · Russian airspace, JapanThe PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…NTSB CEN16WA010Accident · 1 fatalForeign investigationPiper PA31 · Veracruz, NicaraguaNTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.NTSB DCA15WA204Accident · No injuriesForeign investigationDe Havilland DHC8 · Saarbrucken, GermanyThe government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB CEN15WA449Accident · 1 fatalForeign investigationTrendak Tercel · Odorheiul Secuiesc City, RomaniaThis is preliminary information, subject to change, and may contain errors. On September 26, 2015, at an unknown time, a Trendak Tercel gyroplane, A11-DUN, impacted terrain after takeoff from an airfield near Odorheiul Secuiesc city, Harghita County, Romania.…NTSB CEN15WA429Accident · 4 fatalForeign investigationPiper PA28 · Sandstedt, GermanyOn September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…NTSB CEN15WA447Accident · No injuriesForeign investigationBell 407 · San Agustine Guatemala, GuatemalaThe Direccion General de Aeronutica Civil (DGAC) of Guatemala has notified the NTSB of a non-fatal accident involving a Bell 407GX Helicopter, registration TG-PDF, that occurred on September 24, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB CEN15WA456Accident · 1 fatalForeign investigationAmateur Construction Glasair RG · Muhen, SwitzerlandOn September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…NTSB DCA15WA197Incident · No injuriesForeign investigationBoeing 737 · Frankfort, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB WPR15WA271Accident · 4 fatalForeign investigationBell 407 · Chong Qing, China, ChinaOn September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…NTSB DCA15WA203Incident · No injuriesForeign investigationAirbus A320 · Perth, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaNTSB CEN15WA406Accident · 1 fatalForeign investigationBeech Beech C 24R · Könnern, GermanyOn September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…NTSB CEN15WA454Accident · 2 fatalForeign investigationRobinson R44 · Foleyet, CanadaOn September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…NTSB WPR15WA259Accident · 1 fatalForeign investigationCessna 172 · Ballarat, Australia, AustraliaOn September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB CEN15WA401Accident · 1 fatalForeign investigationCessna 150F · Brackley, United KingdomOn September 4, 2015, about 1110 coordinated universal time, a Cessna 150F airplane, G-ATKF, impacted terrain during takeoff at the Hinton in the Hedges Airfield, near Brackley, United Kingdom. The pilot was fatally injured and the airplane sustained…NTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.NTSB CEN15WA435Accident · No injuriesForeign investigationBell 206B · Sept-Iles, CanadaOn September 2, 2015, about 1345 Universal Coordinated Time (UTC), a Bell 206B, Canada Registry C-GYBK, impacted terrain about 19 miles north of Sept-iles, Quebec. Of the five occupants that were on board, the pilot sustained minor injuries, two passengers…NTSB ERA15WA346Accident · Minor injuriesForeign investigationBell 206L-3 · Boyaca, ColombiaOn September 1, 2015, about 1925 UTC, a Bell 206L-3, HK 3311, registered to and operated by Sociedad Aerea De Ibague, was landed hard in a field during a forced landing near Municipality of Chita, Boyaca, Colombia. Visual meteorological conditions prevailed…NTSB DCA15WA181Accident · No injuriesForeign investigationSwearingen SA227 · Thangool, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA227 airplane, which occurred on September 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB CEN15WA408Accident · Minor injuriesForeign investigationPiper PA-46-350P · Cannes, FranceOn August 31, 2015, about 0655 coordinated universal time, a Piper PA-46-350P airplane, D-ESPE, landed in the bay near Cannes, France, following a loss of engine power after takeoff from the Cannes-Mandelieu Airport (LFMD), Cannes, France. The pilot and…NTSB CEN15RA452Incident · No injuriesForeign investigationPiper PA28 · Bergen, NorwayimportNTSB ERA15WA371Accident · 2 fatalForeign investigationEmbraer EMB721 · Sao Felix do Xingu, BrazilOn August 30, 2015, about 1830 universal coordinated time, an Embraer EMB721, Brazilian registration PT-EPD, was substantially damaged during a forced landing after a loss of engine power near São Félix do Xingu Municipality, State of Pará, Brazil. The…NTSB CEN15WA448Accident · 1 fatalForeign investigationPitts S2 · Friesach, AustriaOn August 30, 2015, about 1242 UTC, a Pitts S2B airplane, D-EZZT, (s/n 5327), impacted terrain while performing aerobatic maneuvers near Friesach, Austria. The airplane was destroyed and the pilot was fatally injured. This investigation is under the…NTSB CEN15WA457Accident · No injuriesForeign investigationCessna 340A · Vicovu de Sus, RomaniaThe accident is under the jurisdiction and control of the Romanian government. This report is for information purposes only and contains only information released by or obtained from the Romanian government. Further information pertaining to this accident may…NTSB ERA15WA347Accident · 3 fatalForeign investigationCessna TU206B · Lib Mandy, PeruNTSB CEN15WA393Accident · No injuriesForeign investigationBeech C90 · Helsinki, FinlandOn August 26, 2015, at 0535 universal coordinated time, a Beechcraft C90 airplane, Finnish registration OH-BEX, owned and operated by Scanwings Oy, sustained substantial damage when the nose landing gear collapsed during landing at the Helsinki-Vantaa…NTSB CEN15WA380Accident · 6 fatalForeign investigationDehavilland DHC-2 MK. I · Lac Long, CanadaOn August 23, 2015, about 1530 coordinated universal time, a De Havilland DHC-2 MK. I airplane, collided with wooded mountainous terrain near Lac Long, Quebec, Canada. The pilot and 5 passengers were fatally injured. The accident investigation is under the…NTSB DCA15WA213Accident · Serious injuriesForeign investigationAirbus A330 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving an AIRBUS A330 that occurred on August 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…NTSB CEN15WA397Accident · Minor injuriesForeign investigationRobinson R44 · Natolin village, PolandOn August 22, 2015 about 1515 UTC, a Robinson R44 helicopter, Poland registration SP-TVN, made a hard landing, during a precautionary landing, following an engine issue near Natolin village, Radom-Sadkow airport, Poland. The pilot was not injured and the…NTSB DCA15WA202Incident · No injuriesForeign investigationBoeing 737 · Trivandrum, IndiaThe NTSB was notified of an incident involving a Boeing B737-800 aircraft, registration VT-JFA, that occurred on August 18, 2015, during landing at Trivandrum International Airport (TRV). The incident is being investigated by the Aircraft Accident…