NTSB investigations
1,712 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 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 ANC18FA044Accident · 2 fatalClass 2 · FieldFinal reportPiper PA18 · Sitka, AKThe pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.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…NTSB CEN18WA145Accident · 2 fatalForeign investigationCessna Cessna 152 · Crumlin, IrelandOn April 19, 2018, at 1230 UTC, a Cessna 152 airplane, G-UFCO, collided with the terrain in Crumlin, Northern Ireland. The pilot and passenger were fatally injured, and the airplane was substantially damage by impact and postimpact fire. The wreckage was…NTSB WPR18WA134Accident · Serious injuriesForeign investigationGarlick UH1H · Talbingo NSW, AustraliaOn April 17, 2018, about 1510 local time, a Garlick, Australian registration VH-HUE, operated as a freight charter and equipped with a Textron Lycoming T-53 engine, impacted terrain near Talbingo, Australia. The pilot, sole occupant onboard, was seriously…NTSB CEN18FA140Accident · 2 fatalField investigationFinal reportBordiuk Challenger II · Friona, TXAn in-flight impact with terrain for reasons that could not be determined due to a lack of evidence.NTSB ERA18WA131Accident · No injuriesForeign investigationPiper PA34-200T · La Pampa, ArgentinaNTSB CEN18WA136Accident · 2 fatalForeign investigationBell 47G · Libourne, FranceThe government of France has notified the NTSB of an accident involving a BELL 47G helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ERA18WA123Accident · 4 fatalForeign investigationRobinson R44 · Rosario, BrazilNTSB WPR18WA110Accident · 2 fatalForeign investigationEurocopter EC120 · Hardy Reef, Queensland, AustraliaOn March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef…NTSB WPR18WA115Accident · No injuriesForeign investigationRobinson R22 · Bloemfontein, South AfricaNTSB DCA18WA106Accident · 11 fatalForeign investigationCanadair CL600 2B16 · Shahr-e Kurd, IranThe Transportation Safety Board of Canada has informed the NTSB of an accident involving a Challenger 604, which occurred on March 11, 2018, in the Islamic Republic of Iran. All investigative information will be released by the government of Iran.NTSB ANC18WA035Accident · Serious injuriesForeign investigationBeech B100 · Abbotsford, CanadaOn February 23, 2018, about 1204 Pacific standard time, a twin engine, turbine-powered Beech King Air B100 airplane, Canadian registration C-GIAE, crashed shortly after takeoff from the Abbotsford International Airport, Abbotsford, British Columbia, Canada.…NTSB WPR18CA100Accident · Minor injuriesData collectionFinal reportHughes 369D · Pacific Ocean, Marshall IslandsAn in-flight mechanical malfunction with the helicopter, which necessitated a ditching in the ocean. The reason for the malfunction could be determined because the helicopter sank and was not recovered.NTSB CEN18WA103Accident · 3 fatalForeign investigationBeech 95B55 · Saint Laurent La Roche, FranceNTSB CEN18WA110Accident · 2 fatalForeign investigationCessna 182 · El Pozo, MexicoOn February 12, 2018, about 1815 coordinated universal time, a Cessna 182B airplane, Mexican registration XB-HRG, crashed in a field under unknown circumstances near El Pozo, Mexico. The pilot and passenger were fatally injured. The local flight originated…NTSB CEN18WA104Accident · 2 fatalForeign investigationBeech F33 · Bolderberg, BelgiumNTSB DCA18WA107Accident · 71 fatalForeign investigationAntonov AN148 · Argunovo, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a ANTONOV AN-148 airplane that occurred on February 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the…NTSB ERA18WA108Accident · 1 fatalForeign investigationPiper PA25 · Ribeirao Cascalheira, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-25-260 airplane that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA18WA085Accident · 3 fatalForeign investigationBeech F35 · Itaituba, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH F35 airplane that occurred on February 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ANC18WA023Accident · 6 fatalForeign investigationSikorsky UH-60M (S-70) · Lanyu, TaiwanThe foreign authority was the source of this information. On February 05, 2018, about 2352 local time, a Sikorsky UH-60M helicopter, NA-706, operated by National Airborne Service Corps. of the Ministry of Interior, Taiwan R.O.C., went missing and is presumed…NTSB WPR18FA075Accident · 1 fatalField investigationFinal reportCessna 152 · Concord, CAA loss of control for reasons that could not be determined based on the available information.NTSB CEN18FA083Accident · 1 fatalField investigationFinal reportSkwira Matthew J W-10 Tailwind · Sauk Centre, MNImpact with terrain for reasons that could not be determined based on the available information.NTSB WPR18WA067Accident · 1 fatalForeign investigationCessna 182 · Bridport, AustraliaOn January 20, 2018, at 1800 local time, a Cessna 182P, VH-TSA, collided with terrain near Bridport, Australia. The airplane sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight was operated…NTSB ERA18WA093Accident · 1 fatalForeign investigationAyres S2R · Jaramillo, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on January 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB CEN18LA069Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Albany, TXA loss of helicopter control for reasons that could not be determined because postaccident examination did not reveal any evidence of mechanical malfunctions or failures of the main rotor and tail rotor systems that would have precluded normal operation.NTSB CEN18WA066Accident · 1 fatalForeign investigationGulfstream Aerospace LP Gulfstream G150 · Kittilä, FinlandOn January 5, 2018, about 1200 coordinated universal time, a Gulfstream G150 airplane, OE-GKA, was involved in a ground accident that fatally injured the pilot when he was struck by the door. The accident investigation is under the jurisdiction and control of…NTSB CEN18FA400Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Gulf of Mexico (Gulf of Mexico)The pilot's incapacitation resulted in impact with the Gulf of Mexico. The reason the hypoxia recognition system did not descend the airplane as designed could not be determined as the airplane was not located.NTSB ERA18WA051Accident · 1 fatalForeign investigationBeech A36 · Itapua, ParaguayNTSB ANC18WA015Accident · 1 fatalForeign investigationPiper PA23 · Baldur, CanadaOn December 16, 2017, about 0037 Coordinated Universal Time, a Piper PA-23 airplane, CFIPK, impacted terrain near Baldur, Manitoba, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries.The Transportation Safety Board (TSB) of…NTSB WPR18WA078Accident · 3 fatalForeign investigationBeech 58 · Qaroun Lake, EgyptOn December 15, 2017, about 0930 Coordinated Universal time, a Textron/Beech Model 58 Baron twin engine airplane, SU-BLD, was substantially damaged when it impacted desert terrain about 18 kilometers north of Qaroun Lake, Egypt. The training pilot and the two…