NTSB investigations
1,541 cases where the defining event was Unknown or undetermined.
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000') 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 WPR16WA161Accident · 1 fatalForeign investigationPiper PA31 · Nong Prue, Thailand, ThailandOn August 1, 2016, at 1605 local time, a Piper PA31-350, HS-FGB, was destroyed after it collided with a wooden bridge during an emergency landing near Nong Prue, Thailand. The aircraft was operated under the pertinent regulations of the Government of…NTSB WPR16RA151Accident · 5 fatalForeign investigationCessna 208 · Shanghai, ChinaOn July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…NTSB ANC16WA045Accident · 1 fatalForeign investigationDehavilland DHC-2 MK. I · Telegraph Creek, CanadaOn July 15, 2016, about 0520 Coordinated Universal Time, a Canadian registered De Havilland DHC-2 Mk I airplane on floats, C-GWDW, owned and operated by Tsayta Aviation Ltd, impacted terrain approximately 15 nm east south east of Telegraph Creek, British…NTSB CEN16WA268Accident · 4 fatalForeign investigationPiper PA-32R-301 · Ajdovscina, SloveniaThe accident investigation is under the jurisdiction and control of the Republic of Slovenia. This report is for information purposes only and contains only information released by or obtained from the Republic of Slovenia. Further information pertaining to…NTSB ANC16WA042Accident · 1 fatalForeign investigationAero Commander B1A · Hoey, CanadaOn July 14, 2016, about 0230 Coordinated Universal Time, an Aero Commander B1A airplane, C-GSQY, lost engine power and impacted terrain after takeoff near Hoey, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…NTSB ANC16WA043Accident · 1 fatalForeign investigationAir Tractor AT301 · Rocanville, CanadaOn July 8, 2016, about 2359 Coordinated Universal Time, an Air Tractor AT-301 airplane, C-GCYV, impacted terrain while low-level maneuvering near Rocanville, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…NTSB ANC16WA039Accident · 2 fatalForeign investigationPiper PA28 · Winnipeg, CanadaOn July 1, 2016, at approximately 1445 Coordinated Universal Time, a Canadian registered Piper PA-28-140 airplane, C-GNUC, owned and operated by a private pilot, was destroyed when it collided with terrain shortly after takeoff from Winnipeg Lyncrest Airport…NTSB ERA16WA240Accident · 5 fatalForeign investigationBell Helicopter 407 · Jundiaí, BrazilOn June 26, 2016, about 1110 coordinated universal time, a Bell 407, Brazilian registration PR-CBB, was destroyed during a collision with terrain and post-crash fire in Jundiaí, Brazil. The pilot and four passengers were fatally injured.The flight had…NTSB ERA16WA219Accident · 2 fatalForeign investigationPiper PA 23-250 · South Bimini, BahamasOn June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…NTSB ANC16WA033Accident · 1 fatalForeign investigationPiper PA28R · Green Lake, CanadaOn June 16, 2016, about 1900 Coordinated Universal Time, a Piper PA28R-180 airplane, C-FYGG, struck trees and impacted terrain while attempting a go-around near Green Lake, British Columbia, Canada. The pilot sustained serious injuries and the passenger…NTSB WPR16WA162Accident · No injuriesForeign investigationHawker Beech 900 · Chennai, India, IndiaOn June 7, 2016, at 2006 local time, a Hawker 900 XP, VT-LTA, was substantially damaged after a nose gear sheared off during the landing near Chennai, India. The aircraft was operated under the pertinent regulations of the Government of India. The 2…NTSB DCA16RA175Accident · Minor injuriesForeign investigationMcdonnell Douglas MD11 · Incheon, South KoreaimportNTSB WPR16WA123Accident · 1 fatalForeign investigationBell 206 · Siriwo, IndonesiaOn June 4, 2016, about 0815 local time, a Bell 206 helicopter, registration PK-UAF, sustained substantial damage following collision with terrain near Siriwo, Indonesia. Reports indicate that there were 4 soles onboard the helicopter; 1 fatal, 3 serious. The…NTSB ANC16WA030Accident · 1 fatalForeign investigationWag-Aero Super Tri-Pacer · Williston Lake, CanadaOn June 04, 2016, about 1500 Coordinated Universal Time, a Wag-Aero Super Tri-Pacer airplane, CGSMJ, impacted terrain near Williston Lake, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The…NTSB CEN16WA205Accident · 1 fatalForeign investigationVans RV4 · Coex, FranceOn June 1, 2016, at 2100 local time, a Vans RV4, Netherlands registration PH-EIL, was destroyed when it collided with the terrain in Coex, France. The pilot was fatally injured and the passenger received serious injuries. At the time of this report, it is…NTSB ERA16LA201Accident · 1 fatalLimited investigationFinal reportCriquet Aviation Bogota Columb Storch FI-156 · Fordsville, KYThe steep descent to ground impact for reasons that could not be determined based on the available evidence.NTSB CEN16WA198Accident · 2 fatalForeign investigationAmateur Construction Rans S6-ESD (Modifie · Shropshire, United KingdomThe United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of a fatal accident involving a Rans S-6ESD, registration G-MYES, which occurred on May 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB WPR16FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Avalon, CAUndetermined because the airplane was not located.NTSB DCA16RA156Accident · 66 fatalForeign investigationAirbus A320 · Cairo, EgyptThe Egyptian Ministry of Civil Aviation (EMCA) has notified the NTSB of an accident involving an AIRBUS A320, equipped with IAE V2500 engines, that occurred on May 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the EMCA's…NTSB ERA16FA189Accident · 1 fatalField investigationFinal reportCessna 210 · Wantage, NJA collision with terrain for reasons that could not be determined as the investigation did not reveal any postaccident anomalies with the airplane or pilot.NTSB CEN16WA199Accident · 1 fatalForeign investigationPiper PA-28R-200 · Halden, NorwayOn May 17, 2016, about 1615 coordinated universal time (UTC), a Piper Aircraft, Inc. PA-28R-200 airplane, Norwegian registration LN-AAM, impacted trees and terrain, near Halden, Norway. The airplane was destroyed during impact and the pilot, the sole…NTSB ANC16WA028Accident · 1 fatalForeign investigationVans RV4 · Eckville, CanadaOn May 07, 2016, about 2000 Coordinated Universal Time, an amateur-built Van's Thiessen RV-4 airplane, C-GGYT, impacted terrain near Eckville, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB ERA16WA175Accident · 3 fatalForeign investigationRobinson R44 · Avacha`, RussiaOn May 3, 2016, about 0347 UTC, a Robinson Helicopter R44, Russian registered RA-2118G was destroyed when it impacted mountainous terrain near Kamchatka, Russia, while on a flight from Khalaktyrka, Russia to Karymshina, Russia. The pilot and two passengers…NTSB DCA16WA142Incident · No injuriesForeign investigationBoeing 767 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 767 that occurred on April 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the…NTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.NTSB CEN16WA160Accident · 1 fatalForeign investigationExtra Flugzeugbau EA 300/L · Cozumel, MexicoOn April 17, 2016, at 1940 UTC, an Extra EA300, N13DK, impacted terrain at Cozumel International Airport (MMCZ) in Cozumel, Mexico. The aircraft was destroyed and the pilot, the sole occupant, was fatally injured. This investigation is under the jurisdiction…NTSB ANC16WA018Accident · 2 fatalForeign investigationRockwell 112 · Revelstoke, CanadaOn April 11, 2016, about 2000 Coordinated Universal Time, a Rockwell Commander 112B airplane, CGQJN, impacted terrain near Revelstoke, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation…NTSB CEN16WA147Accident · Serious injuriesForeign investigationMcdonnell Douglas Helicopter 369E · Suwalki, PolandOn April 7, 2016, at 1613 Central European Daylight Time, a McDonnell Douglas Helicopter 369E, N60EA, registered to EPC Industries, Inc., and operated by a private entity was substantially damaged when it impacted terrain under unknown circumstances near…NTSB CEN16WA149Accident · Serious injuriesForeign investigationRobinson Helicopter R44 II · Atemajac de Brizuela, MexicoOn April 2, 2015, about 2120 universal coordinated time, a Robinson Helicopter Company R44 II helicopter, N565AC, impacted terrain near Atemajac de Brizuela, Mexico. The pilot and two passengers were uninjured and one passenger sustained a serious injury. The…NTSB WPR16WA089Accident · 1 fatalForeign investigationBell 206 · Carmila West, AustraliaOn March 25, 2016, at 1028 local time, a Bell 206B, VH-WHU, collided with power lines during an aerial agriculture flight near Carmila West, Australia. The helicopter was destroyed by the post impact fire and the pilot was fatally injured. The flight was…NTSB ERA16WA147Accident · 3 fatalForeign investigationBell 206 · Riosucio, Choco, ColombiaNTSB CEN16WA142Accident · 1 fatalForeign investigationYork Laser Z-200 · Abbeyshrule, IrelandOn March 20, 2016, at 1745 coordinated universal time (UTC), an experimental amateur built York Laser Z-200 airplane, Dutch registered PH-LSR, was destroyed when it impacted terrain under unknown circumstances near Abbeyshrule, County Longford, Ireland. The…NTSB DCA16RA108Accident · 62 fatalForeign investigationBoeing 737 · Rostov-on-Don, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a BOEING 737 that occurred on March 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO…NTSB CEN16WA120Accident · No injuriesForeign investigationCessna 152 · Agostyan, HungaryOn February 28, 2016, at 1003 UTC, a Cessna FA152 (S/N 0346), HA-VOK, impacted wooded terrain near Agostyán, Tata, Hungary. The aircraft was destroyed and the two occupants on board were fatally injured. The aircraft was enroute to Godollo Airport (LHGD),…NTSB WPR16WA085Accident · 1 fatalForeign investigationZlin Z242L · Hong Kong, Hong Kong SAR ChinaOn February 27, 2016, approximately 0610 coordinated universal time (UTC), a Zlin Z242L, Hong Kong registration B-LUR, was substantially damaged when it impacted the water under unknown circumstances near the Tolo Harbour, Tai Po, Hong Kong. The pilot, the…NTSB DCA16WA101Incident · No injuriesForeign investigationBoeing 737 · a Mitad de la Pista del Aeropuerto, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on February 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB CEN16WA104Accident · 1 fatalForeign investigationCessna 172 · Jaen, SpainNTSB DCA16WA085Incident · No injuriesForeign investigationSikorsky S76 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a Sikorsky S76C helicopter that occurred on February 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…NTSB WPR16WA062Accident · 4 fatalForeign investigationPiper PA28 · Barwon Heads, Australia, AustraliaOn January 29, 2016, at 1155 local time, a Piper PA 28-235, VH-PXD, was ditched in the waters near Barwon Heads, Australia. The airplane was operated by a private individual under the pertinent regulations of the Government of Australia. The airplane was…NTSB ERA16WA096Accident · 5 fatalForeign investigationMcdonnell Douglas MD-600 · Taldykorgan, KazakhstanOn January 27, 2016, about 1747 local time, a McDonnell-Douglas MD-600N helicopter, Kazakhstan registration UP-MD004, registered to LLP Svinestroy and operated by JSC Aspan, impacted terrain under unknown circumstances after requesting to air traffic control…NTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…NTSB DCA16RA045Accident · 2 fatalForeign investigationBombardier CL600 2B19 · Kiruna, SwedenimportNTSB ERA16WA088Accident · 2 fatalForeign investigationCessna T188 · Bom Jesus de Goiás, BrazilOn January 7, 2016, about 1900 coordinated universal time, a Cessna T188C, Brazilian registration PR-INS, operated by Blitz Comercio e Representacoes Ltda, was destroyed when it impacted terrain while spraying insecticides on a sugar cane plantation in Bom…NTSB CEN16WA071Accident · 2 fatalForeign investigationSocata TB9 · Malaga, SpainThe Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…NTSB DCA16WA048Incident · No injuriesForeign investigationBoeing 737 · Gwangju-Si, South KoreaThe government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…NTSB WPR16WA051Accident · 10 fatalForeign investigationBeech 200 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ANC16WA007Accident · 2 fatalForeign investigationBell 206 · New Taipei City, TaiwanOn November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…NTSB CEN16WA044Accident · 3 fatalForeign investigationBell 206 · San Carlos, NicaraguaOn November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…NTSB CEN16WA045Accident · 4 fatalForeign investigationPiper PA 46 350P · Taunton, United KingdomNTSB ERA16WA038Accident · 1 fatalForeign investigationAir Tractor AT-502B · Balsas, BrazilOn November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…