NTSB investigations
1,713 cases where the sequence of events included 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 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 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 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 CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…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 CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…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…NTSB DCA16WA016Incident · No injuriesForeign investigationBoeing 737 · Nicosia, CyprusThe Accident Investigation Board of Turkey (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA16WA015Accident · 224 fatalForeign investigationAirbus A321 · Sinai Peninsula, EgyptThe Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…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 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 ERA16LA058Accident · No injuriesLimited investigationFinal reportCessna R182 · Sanford, FLA collapse of the nose landing gear due to a separation of the drag attachment fitting from the airframe. The separation was likely due to preexisting damage from an undetermined event.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 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 WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.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…