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 DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…NTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…NTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.NTSB CEN18WA388Accident · 3 fatalForeign investigationCessna 210 · Pico de Orizaba, MexicoOn September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…NTSB WPR18WA258Accident · 1 fatalForeign investigationYakovlev YAK-9UM · Victoria, AustraliaOn September 7, 2018, about 1933 coordinated universal time a Yakovlev Aircraft YAK-9UM airplane, VH-YIX, impacted terrain during a local flight that departed from the Latrobe Valley Airport, Victoria, Australia. The pilot in command was fatally injured, and…NTSB ERA18WA245Accident · 1 fatalForeign investigationBell 430 · Bostanci, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…NTSB WPR18WA254Accident · Serious injuriesForeign investigationCessna 182M · Leshiba Wilderness, South AfricaOn September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…NTSB CEN18WA367Accident · 1 fatalForeign investigationCessna 310 · Villa Zaragoza, MexicoThe government of Mexico has notified the NTSB of an accident involving a Cessna 310, XB-KQF that occurred on August 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN18WA353Accident · 1 fatalForeign investigationPiper PA34 · Loma Linda, Costa RicaNTSB ERA18WA223Accident · 2 fatalForeign investigationStemme S12 · Santo Domingo Norte, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a STEMME S12 glider that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's investigation…NTSB WPR18FA228Accident · 2 fatalClass 3 · FieldFinal reportPietenpol Aircamper · Camp Verde, AZLoss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.NTSB WPR18WA230Accident · 1 fatalForeign investigationKawasaki Heavy Industries BK117 B-2 · Ulladulla, AustraliaOn August 17, 2018, about 1400 local time, a Kawasaki Heavy Industries Ltd. BK117 B-2 helicopter, VH-JWB, was destroyed when it impacted terrain during aerial firefighting operations near Ulladulla, New South Wales, Australia. The helicopter was operated by…NTSB CEN18LA335Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Springs, COThe airplane’s failure to maintain a climb after takeoff, which resulted in a forced landing on unsuitable terrain; the reason for the airplane’s failure to climb could not be determined based on the available evidence.NTSB ANC18WA074Accident · 1 fatalForeign investigationCessna 172 · Edson, CanadaOn August 12, 2018, about 1645 Coordinated Universal Time, a Cessna 172 airplane, C-FJCP, impacted terrain near Edson, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries.The Transportation Safety Board (TSB) of Canada is…NTSB ANC18WA065Accident · 9 fatalForeign investigationBell 412EP · Nakanojo, JapanThe government of Japan has notified the NTSB of an accident involving a BELL 412EP helicopter that occurred on August 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB CEN18WA325Accident · 2 fatalForeign investigationBeech 58 · Munster, GermanyOn August 9, 2018, about 1000 UTC, a Beechcraft Baron 58 airplane, Hungarian registration PH-CJX, impacted terrain under unknown circumstances near Münster, Germany. The two occupants inside the airplane sustained fatal injuries. The airplane sustained…NTSB CEN18WA318Accident · 3 fatalForeign investigationCessna 172 · Puy-de-Dome Mazoires, FranceOn August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…NTSB ANC18FA063Accident · 5 fatalField investigationFinal reportDe Havilland DHC-2 · Talkeetna, AKImpact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB ANC18WA062Accident · 2 fatalForeign investigationCessna 180 · Gold Bridge, CanadaOn August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…NTSB ANC18WA061Accident · 2 fatalForeign investigationPiper PA-31 · Calgary, CanadaOn August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…NTSB ERA18WA218Accident · 3 fatalForeign investigationPiper PA34 · Irineopolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-34-220T that occurred on July 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB ERA18WA196Accident · 2 fatalForeign investigationPiper PA28R · Santiago, ChileThe government of Chile has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on July 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN18WA320Accident · 1 fatalForeign investigationChampion 8KCAB · Toronto, CanadaOn July 12, 2018, at 2359 universal coordinated time, a Bellanca 8KCAB, Canadian registration C-GDLP, declared an emergency and impacted terrain shortly after takeoff from the Toronto/Buttonville Airport (CYKZ), Ontario, Canada. The pilot was fatally injured.…NTSB CEN18WA268Accident · 2 fatalForeign investigationRobinson R44 · Domecko, PolandOn July 11, 2018, at 0736 coordinated universal time (UTC), a Robinson Helicopter R-44 II helicopter, SP-MAP, impacted terrain near Opole, Poland. 2 occupants were fatally injured, and 1 occupant was seriously injured.The investigation is under the…NTSB WPR18FA188Accident · 2 fatalField investigationFinal reportHughes 369 · MajuroThe pilot's failure to maintain clearance above the surface of the ocean.NTSB WPR18WA185Accident · 5 fatalForeign investigationBeech C90 · Mumbai, IndiaOn June 28, 2018, at 0740 Universal Coordinated Time, a King Air C90 airplane, VT-UPZ, was destroyed when it impacted the ground near Mumbai, India. The airplane was operated under the pertinent regulations of the Government of India. The two pilots, two…NTSB ERA18WA272Accident · 1 fatalForeign investigationCessna 172 · Adiyaman, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…NTSB WPR18WA202Accident · Serious injuriesForeign investigationZlin Z242L · Hong Kong, ChinaOn June 24, 2018, at 1638 local time, a Zlin Z 242 L airplane, B-LUK, was substantially damaged when it collided with the ground near Ma Shi Chau, Hong Kong, China. The private pilot was seriously injured. The airplane was operated in accordance with the…NTSB ANC18FA050Accident · 2 fatalField investigationFinal reportPiper PA 18-150 · Delta Junction, AKUndetermined based on the available evidence.NTSB WPR18WA180Accident · 5 fatalForeign investigationPiper PA31 · Antananarivo, MadagascarOn June 18, 2018, about 0615 local time, a Piper PA-31 airplane, 5R-MKF, impacted terrain about 5 nautical miles from the Ivato International Airport, Antananarivo, Madagascar. The pilot in command, two pilot observers, pilot monitor, and one passenger were…NTSB WPR18WA169Accident · Serious injuriesForeign investigationMD Helicopter 600 · Waiouru, New ZealandOn June 13, 2018, at 2048 Universal Coordinated time, an MD 600N helicopter, ZK-ILD crashed in a remote area for unknown reasons near Waiouru, New Zealand. The pilot and four passengers were seriously injured. The helicopter was substantially damaged. The…NTSB CEN18WA231Accident · 1 fatalForeign investigationAir Tractor AT802 · Mallorca, SpainOn June 12, 2018, about 1600 hours universal coordinated time, an Air Tractor AT-802 airplane, Spanish registration EC-GVN, was substantially damaged during an agricultural application flight near Mallorca, Spain. The pilot sustained fatal injuries. The local…NTSB WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…NTSB CEN18WA355Accident · Minor injuriesForeign investigationCessna R172 · Aude Fraisse-Cabardes, FranceThe government of France has notified the NTSB of an accident involving a Cessna R172 airplane that occurred on June 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB WPR18WA187Accident · 1 fatalForeign investigationCessna 172 · Moorabbin, AustraliaNTSB CEN18WA203Accident · 1 fatalForeign investigationPiper PA25 · Bosschenhoofd, NetherlandsOn May 31, 2018, a Piper PA-25-135 airplane (SE-KHF), crashed while attempting to pick up a banner near Bosschenhoofd, Netherlands. The pilot, who was the sole occupant, was fatally injured. This investigation is under the jurisdiction and control of the…NTSB CEN18WA202Accident · 1 fatalForeign investigationBell Helicopter Textron Bell 206B · North Aldborough, United KingdomOn May 30, 2018, about 1225 coordinated universal time (UTC), a Bell 206B helicopter, registration G-OPEN, s/n 4300, impacted terrain and was destroyed near North Aldborough, North Yorkshire in the United Kingdom. The pilot was the sole occupant and was…NTSB WPR18LA152Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Heli 369FF · Wikieup, AZA vibration of the helicopter for reasons that could not be determined based on the available information, which resulted in a forced landing and the main rotor contacting the tailboom.NTSB CEN18WA190Accident · 2 fatalForeign investigationReims F172N · Stolwijk, NetherlandsOn May 22, 2018, about 0930 UTC, a Reims Aviation, F172N airplane, PH-SBM, was destroyed when it impacted trees and terrain near Stolwijk, The Netherlands. The two pilots on board the airplane were fatally injured. The foreign, local personal flight departed…NTSB DCA18RA186Accident · 112 fatalForeign investigationBoeing 737 · Havana, CubaThe government of Cuba has notified the NTSB of an accident involving a Boeing 737-200 that occurred on May 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Cuba's investigation under the provisions of ICAO Annex…NTSB ENG18WA034Accident · No injuriesForeign investigationSikorsky S76 · Valle Nuevo, Dominican RepublicNTSB ERA18WA147Accident · 4 fatalForeign investigationMaule M7 · Abayt, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a Maule, M-7-235C, airplane that occurred on May 15, 2018 near Abayt, Saudi Arabia. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi…NTSB CEN18WA289Accident · 3 fatalForeign investigationMooney M20K · Flix, SpainOn May 12, 2018, at 1340 universal coordinated time, a Mooney M20K airplane, D-ETFT, impacted terrain near Flix, Tarragona, Spain. The pilot and 2 passengers were fatally injured and the airplane was destroyed.The accident investigation is under the…NTSB CEN18WA191Accident · 3 fatalForeign investigationMooney M20K · Tarragona, PortugalOn May 12, 2018, about 1340 coordinated universal time, a Mooney M20K airplane, D-EFTF, impacted terrain near Tarragone, Portugal, after reporting an engine issue to air traffic control. The pilot and two passengers were fatally injured. The airplane was…NTSB ERA18WA143Accident · 3 fatalForeign investigationCessna U206F · Trelawny, JamaicaThe government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…NTSB ERA18WA139Accident · 2 fatalForeign investigationAgusta Bell AB206B · Cacao, French GuianaThe government of France has notified the NTSB of an accident involving a Agusta Bell AB206B helicopter that occurred on May 2, 2018 near Cacao, French Guiana. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB WPR18WA160Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Mabula, South AfricaOn May 1, 2018, at 0940 Universal Coordinated Time, a Robinson R44 Raven II helicopter, ZS-MZS, impacted an open field for unknown reasons near Mabula, South Africa. The pilot and one passenger were fatally injured. The helicopter was destroyed. The…NTSB CEN18WA154Accident · 2 fatalForeign investigationAmateur Construction Vari EZE · Innsbruck, AustriaOn April 29, 2018, about 0819 hours universal coordinated time, an amateur-built Vari-Eze airplane, Swiss registration HB-YCM, impacted terrain shortly after takeoff from the Innsbruck Airport (LOWI), Innsbruck, Austria. The pilot and passenger were fatally…NTSB CEN18WA153Accident · 2 fatalForeign investigationCessna 172 · Corozalito, Nandayure, Costa RicaOn April 28, 2018, about 1800 UTC, a Cessna 172S airplane, TI-BIL, impacted terrain during an instructional flight near Corozalito, Nandayure. Both crewmembers on board were fatally injured.This investigation is under the jurisdiction and control of the Costa…NTSB WPR18WA126Accident · 1 fatalForeign investigationWells Elgin M Starjammer · HeNan Province, ChinaOn April 25, 2018, at 1814 local time, an experimental Wells StarJammar airplane, N49EW, crashed during the rehearsal flight for an aerobatic performance at ShangJie general aviation Airport, HeNan Province, P.R. China. The owner/pilot, the sole occupant, was…