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 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 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 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…NTSB ENG18WA016Accident · No injuriesForeign investigationAerospatiale ATR 42-320 · Fond-du-Lac, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale ATR 42-320, which occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB CEN18WA055Accident · 3 fatalForeign investigationCessna 510 · Waldburg, GermanyOn December 14, 2017, about 1620 coordinated universal time, a Cessna 510 airplane, OE-FWD, impacted terrain near Waldburg, Germany. The pilots and passenger were all fatally injured and the airplane was destroyed.The accident investigation is under the…NTSB ERA18WA042Accident · 2 fatalForeign investigationRobinson R44 · Dubovaya Balka, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNTSB ENG18WA007Accident · No injuriesForeign investigationBell 407 · Krasny Pakhar village, RussiaThe Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a Bell 407, which occurred on November 6, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex…NTSB WPR18WA019Accident · 2 fatalForeign investigationCessna T310 · Kew, New South Wales, AustraliaOn October 28, 2017, at 1600 local time, a Cessna T310R, VH-JMW, was destroyed when it collided with terrain near Kew, New South Wales, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The pilot and…NTSB WPR18WA024Accident · 2 fatalForeign investigationCessna 210L · Darwin Aerodrome, AustraliaOn October 23, 2017, at 1332 local time, a Cessna 210L, VH-HWY, collided with terrain near Darwin Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The two occupants were fatally injured. The…NTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…NTSB CEN18WA016Accident · 1 fatalForeign investigationAvid Mark IV · Jüterborg, GermanyOn October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…NTSB CEN18WA005Accident · 1 fatalForeign investigationPiper PA25 · Cerro de Ortega, MexicoNTSB ANC18RA001Accident · 1 fatalForeign investigationRobinson R44 · Campbell River, CanadaNTSB ERA17WA344Accident · 2 fatalForeign investigationCessna 150 · BahamasOn September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…NTSB CEN17WA369Accident · 1 fatalForeign investigationMD Helicopter 369 · Norrbotten, Sweden, SwedenOn September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…NTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.NTSB ERA17WA320Accident · 2 fatalForeign investigationCessna 182 · Pontinia, ItalyOn September 3, 2017 about 1030 universal coordinated time, a Cessna 182P, I-SCAP, impacted terrain during initial climb after takeoff, from Pegaso Club 2000 Airfield, Pontinia, Italy. The airplane was destroyed by impact forces and a post crash fire. Five…NTSB CEN17WA378Accident · 1 fatalForeign investigationPiper PA25 · Sueco, Chihuahua, Mexico, MexicoOn September 2, 2017, about 1700 hours universal coordinated time, a Piper PA25-235, Mexican registration XB-EXZ, was substantially damaged when it impacted powerlines near Sueco, Chihuahua, Mexico. The pilot was seriously injured. The local flight departed…NTSB ERA17WA308Accident · 1 fatalForeign investigationMaule M7 · Zhideli, KazakhstanOn August 25, 2017, about 0450 coordinated universal time, a Maule M7-260C airplane, Kazakhstan registration UP-ML003, impacted terrain during a forced landing near Zhideli, Kazakhstan. The pilot was fatally injured and the passenger sustained serious…NTSB DCA17WA185Incident · No injuriesForeign investigationBoeing 737 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737-200, which occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of ICAO…NTSB ANC17FA047Accident · 1 fatalField investigationFinal reportRockwell International S 2R · Calipatria, CAA loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.NTSB ERA17WA283Accident · 1 fatalForeign investigationRobinson R66 · Maly Utrish, RussiaOn July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…NTSB WPR17WA203Accident · No injuriesForeign investigationRobinson Helicopter R44 II · Darwin Aerodrome, AustraliaOn August 18, 2017, at 1400 local time, a Robinson R44 II, VH-LGN, was substantially damaged during a forced landing near Darwin Aerodrome, Australia. The helicopter was operated under the pertinent civil regulations of the government of Australia. The pilot…NTSB ANC17WA048Accident · 2 fatalForeign investigationSocata TBM 700 · Zemyo, JapanOn Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…NTSB ANC17WA045Accident · 1 fatalForeign investigationAir Tractor AT502 · La Crete, CanadaOn August 10, 2017, about 0320 Coordinated Universal Time, an Air Tractor AT-502B airplane, C-FWAS, impacted terrain while conducting an aerial application repositioning turn near La Crete, Alberta, Canada. The pilot sustained fatal injuries. The…