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 ERA17WA343Accident · Serious injuriesForeign investigationCessna 182 · Ivano-Frankivsk, UkraineOn July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…NTSB CEN17WA296Accident · No injuriesForeign investigationCessna 182 · Aeródromo de la Isla de Utila, HondurasNTSB CEN17WA269Accident · 1 fatalForeign investigationCessna TU206 · Surutato, MexicoOn June 30, 2017, about 1907 hours universal coordinated time, a Cessna TU206G single-engine airplane, serial number U20606684, Mexican registration XB-NWL, collided with terrain near Surutato, Mexico. The pilot was fatally injured. The flight's origin and…NTSB CEN17WA262Incident · No injuriesForeign investigationEmbraer ERJ190 · Mérida, Yucatán, MexicoOn June 30, 2017, at 2133 universal coordinated time, an Embraer ERJ190 airplane, XA-GAH, experienced an engine problem and returned to the Manuel Crescencio Rejón International Airport (MMMD), Mérida, Yucatán. The aircrew performed a precautionary landing…NTSB WPR17WA135Accident · 3 fatalForeign investigationSocata TB10 · Suttontown, AustraliaNTSB ERA17WA224Accident · 2 fatalForeign investigationMD Helicopter 500 · Schinias Marathonas, GreeceOn June 23, 2017, about 0645 universal coordinated time, a MD Helicopter 500E, Greek registration SX-HBB, was substantially damaged when it struck a power line and impacted terrain near Schinias Marathonas, Greece. The Greek certificated pilot and one…NTSB WPR17WA129Accident · 1 fatalForeign investigationAirparts NZ FU 24 Stallion · Bathurst, AustraliaNTSB WPR17WA127Accident · 1 fatalForeign investigationCessna 172 · Ballina, AustraliaNTSB WPR17WA130Incident · No injuriesForeign investigationTurbo Thrush S2R · Megiddo, IsraelOn June 14, 2017, about 1600 universal coordinated time (UTC), a Turbo Thrush AG S2R, 4X-AQS made an off-airport landing following an engine shutdown during flight at Megiddo Airport, Megiddo, Israel. The pilot was operating the airplane under the provisions…NTSB ANC17WA031Accident · Serious injuriesForeign investigationBell 214 · Dongducheon, South KoreaOn June 13, 2017, about 1810 local time, a Republic of Korea registered Bell 214B helicopter, HL9157, operated by UB Air, impacted remote mountainous terrain about 3 miles northeast of Dongducheon, Republic of Korea, during the approach to a drop zone while…NTSB ANC17WA029Accident · 3 fatalForeign investigationBell 206 · Fengbin, TaiwanOn June 10, 2017, about 1255 Taipei local time (0455 UTC), a Taiwanese registered Bell 206B3 helicopter, B-31118, operated by Emerald Pacific Airlines, impacted remote mountainous terrain about 8 miles south of Fengbin, Hualien County, under unknown…NTSB CEN17WA349Accident · 1 fatalForeign investigationPiper PA31 · Caernarfon, Gwynedd, United KingdomOn June 9, 2017, at 1705 coordinated universal time, a Piper PA31, N250AC, impacted terrain during landing at Caernarfon Airport (EGCK), Caernarfon, Gwynedd, Wales. The airplane was destroyed by impact forces and fire. The pilot, who was the sole occupant,…NTSB DCA17WA228Accident · No injuriesForeign investigationFokker F27 Mk 600 · Garbaharey, SomaliaThe Ministry of Transport for the Republic of Kenya has notified the NTSB of an accident involving a Fokker F27, which occurred on July 14, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All…NTSB ANC17WA027Accident · 4 fatalForeign investigationCessna 172 · Tateyama, JapanOn June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…NTSB WPR17WA115Accident · 3 fatalForeign investigationCessna 441 · Renmark, AustraliaOn May 30, 2017, about 1630 Australian central standard time, a Cessna 441, equipped with Garret TPE331 series turboprop engines, registration VH-XMJ, collided with terrain shortly after takeoff from Renmark Aerodrome, Renmark, SA, Australia. The three crew…NTSB ERA17WA199Accident · 2 fatalForeign investigationPiper PA34 · Coxim Municipality, BrazilOn May 28, 2017, about 1540 coordinated universal time, a Piper PA-34-220T, Brazilian registration PT-WPD, was destroyed when it impacted terrain in Coxim Municipality, State of Mato Grosso so Sul, Brazil. The Brazilian pilot and passenger were fatally…NTSB CEN17WA203Accident · 1 fatalForeign investigationCessna 182 · Palmar Norte de Osa, Puntarenas, Costa RicaOn May 28, 2017, a Panamanian-flagged Cessna 182, serial number FT34567, and reported false registration HP-1760FT, was located crashed in an African palm seeding field on a farm near Palmar Norte of Osa, Puntarenas, Costa Rica. The pilot, the sole person on…NTSB CEN17WA199Accident · 2 fatalForeign investigationPiper PA28R · Skipness/Kintyre, Scotland, United KingdomOn May 25, 2017, about 1300 hours universal coordinated time, a Piper PA-28R-201, United Kingdom registration G-CEOF, impacted the sea near Skipness/Kintyre, Scotland, United Kingdom. The two occupants on-board were fatally injured. The flight departed Oban…NTSB ERA17WA198Accident · 2 fatalForeign investigationCessna 206 · Cerro Azul, EcuadorOn May 18, 2017, at an unknown time, a Cessna 206H, Ecuadorian registration HC-CEG, was destroyed when it impacted terrain in Cerro Azul, Ecuador. The foreign certificated pilot and one passenger were fatally injured. The flight departed Jose Joaquin de…NTSB CEN17WA187Accident · 2 fatalForeign investigationLearjet 25 · Toluca, MexicoOn May 17, 2017, at 2025 hours universal coordinated time, a Lear 25B airplane, Mexican registration XA-VMC, impacted terrain near Toluca, Mexico. The pilot-in-command and co-pilot were fatally injured. The airplane was destroyed by impact forces and a…NTSB CEN17WA189Accident · 1 fatalForeign investigationMonocoupe 90AF · Plattsville, CanadaOn May 13, 2017, a Monocoupe 90F-100 airplane, C-FJGA, impacted short of the threshold at Lubitz Flying Field (CLB2), Plattsville, Ontario. The pilot was fatally injured.This investigation is under the jurisdiction and control of the government of Canada. Any…NTSB ERA17WA183Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Fundres, ItalyOn May 10, 2017, about 1143 universal coordinated time,an Enstrom 480B, N480W, was destroyed during an infight break-up near Fundres, Italy. The flight departed from Bolzano, Italy, and was destined for Linz, Italy. The pilot was fatally injured. This…NTSB CEN17RA191Accident · 2 fatalForeign investigationBell 429 · Presov, SlovakiaOn May 10, 2017, about 1430 local time, a Bell 429 helicopter, Slovakia registration OM-BYM, impacted terrain shortly after takeoff near Presov, Slovakia. There were four people on board; two people received fatal injuries and two people received serious…NTSB ERA17WA173Accident · 3 fatalForeign investigationRobinson R44 · Beloretsk, RussiaOn May 4, 2017, about 1020 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04156, was substantially damaged when it impacted mountainous terrain during a fire monitoring mission after departing from Beloretsk, Bashkortostan,…NTSB CEN17WA172Accident · 2 fatalForeign investigationPiper PA31 · Schefferville, CanadaOn April 30, 2017, a Piper PA-31 airplane, C-FQQB, impacted terrain near Schefferville, Quebec. The two pilots were fatality injured. The accident investigation is under the jurisdiction and control of the Canadian government. This report is for information…NTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.NTSB ERA17WA159Accident · 2 fatalForeign investigationCessna 172 · Cassilandia, BrazilOn April 14, 2017, about 2045 coordinated universal time, a privately owned and operated Cessna 172N, Brazilian registration PR-LPW, was substantially damaged after it struck a tree about 400 meters from the threshold of runway 13 at the Aeroporto de…NTSB WPR17WA123Accident · 1 fatalForeign investigationCessna 208 · Anem Mountain, Oksibil, IndonesiaOn April 12, 2017, about 0340 universal coordinated time, a Cessna 208C, PK-FSO, operated by PT. Spirit Avia Sentosa as an unscheduled cargo flight under the pertinent civil regulations of the government of Indonesia, collided with mountainous terrain 7…NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB ERA17WA147Accident · 2 fatalForeign investigationPiper PA-42 · Sorocaba, BrazilOn March 31, 2017, about 1745 coordinated universal time (1445 local time), a Piper PA-42, Brazilian registration PP-EPB, operated by a private individual, was destroyed after it impacted the ground while on approach to Barra Do Garcas Airport (SBBW),…NTSB DCA17RA082Accident · No injuriesForeign investigationBoeing 737 · Jauja, PeruThe government of Peru has notified the NTSB of an accident involving a BOEING 737 that occurred on March 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO Annex 13…NTSB WPR17WA083Accident · 1 fatalForeign investigationRobinson R22 · Reefton, New ZealandOn March 27, 2017, about 0345 Universal Time, a Robinson R22, New Zealand registration ZK-IHA, impacted forested terrain about 5.5 miles north of Reefton, West Coast. The pilot, the sole occupant was fatally injured, and the helicopter was substantially…NTSB CEN17WA133Accident · No injuriesForeign investigationCessna 172P · Manitouwadge, CanadaOn March 15, 2017, at an unknown time, a Cessna 172P airplane, N230TX, owned and operated by the University of Michigan Flyers Inc. was substantially damaged when it collided with wooded terrain near Manitouwadge, Ontario, Canada. No pilot or occupant was…NTSB CEN17RA131Accident · 4 fatalForeign investigationSikorsky S92 · Blacksod Bay, IrelandOn March 14, 2017, about 1719 universal coordinated time (UTC), a Sikorsky S-92 helicopter, Irish registration EI-ICR, crashed offshore near Blackrock Island West of Blacksod Bay, Ireland. There were 4 occupants. The pilot was fatally injured and 3…NTSB CEN17WA128Accident · 1 fatalForeign investigationPiper PA25 · Etchoropo, Sonora, MexicoOn March 12, 2017, at 2050 hours universal coordinated time, a Piper PA25-235 airplane, Mexican registration XB-FHP, impacted terrain near Etchoropo, Sonora, Mexico. The pilot was fatally injured. The airplane was destroyed by impact forces.The accident…NTSB ANC17RA019Accident · 9 fatalForeign investigationBell 412 · Matsumoto, JapanimportNTSB ERA17WA124Accident · 1 fatalForeign investigationPiper PA25 · Villa Tapia, Dominican RepublicOn March 4, 2017, about 1330 coordinated universal time, a Piper PA-25-235, N8969L, was destroyed following a collision with antenna wires and terrain during an aerial application flight near Villa Tapia, Dominican Republic. The pilot was fatally injured. The…NTSB CEN17WA115Accident · 4 fatalForeign investigationCessna 172 · Magdalena, Sonora, MexicoOn February 26, 2017, about 0140 universal coordinated time, a Cessna model 172N single-engine airplane, Mexican registration XB-MRG, crashed near Magdalena, Sonora, Mexico. The pilot and 3 passengers were fatally injured. The airplane was on a local flight.…NTSB WPR17WA081Accident · 2 fatalForeign investigationCessna 162 LSA · Faisalabad, PakistanThe foreign authority was the source of this information. On February 24, 2017, at 0738 universal coordinated time, a Cessna 162, AP-ZBQ, collided with terrain shortly after takeoff from Faisalabad, Pakistan. The airplane was operated by M/S. Shaheen Air…NTSB CEN17CA140Accident · No injuriesData collectionFinal reportCessna 172R · Cahokia, ILA hard landing for reasons that could not be determined based on the available evidence.NTSB WPR17WA069Accident · Serious injuriesForeign investigationHughes 369E · Raetihi, New ZealandOn February 19, 2017, at 0930 local time, a McDonnell Douglas Hughes 369E, ZK-HRK, operated by Precision Helicopters Ltd. collided with a ridgeline in the Waimarino Forest near Raetihi, New Zealand during an external load operation. The helicopter was being…NTSB ERA17WA104Accident · 5 fatalForeign investigationRobinson R66 · Lake Teletskoye, RussiaOn February 12, 2017, at 1319 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-06375, was substantially damaged when it crashed into Lake Teletskoye, Republic of Altai, Russia. The pilot and four passengers were fatally injured.…NTSB ANC17LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA18 · Sterling, AKThe pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.NTSB ERA17WA350Accident · 6 fatalForeign investigationBeech 58 · Puerto la Cruz, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on January 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB CEN17WA083Accident · 2 fatalForeign investigationRobinson R44 · Salinas Victoria, MexicoOn January 21, 2017, about 1800 universal coordinated time, a Robinson R44 helicopter, XA-CSJ, impacted terrain near Salinas Victoria, Mexico. The pilot and one passenger were fatally injured and the helicopter was destroyed by impact and fire damage. The…NTSB ERA17WA094Accident · 2 fatalForeign investigationCessna 172 · Araucania, ChileOn January 20, 2017, about 2120 coordinated universal time, a Cessna 172S, Chilean registration CC-AGK, was substantially damaged when it impacted terrain near Araucania, Chile. The pilot and one passenger were fatally injured, while two other passengers were…NTSB ERA17WA093Accident · 5 fatalForeign investigationHawker Beechcraft C90GT · Parati, BrazilOn January 19, 2017, about 1530 UTC, A Beechcraft C90GT, Brazilian registration PR-SOM, was destroyed when it impacted the sea after departing from Campo de Marte Airport (SBMT), Sao Paulo, Brazil. The five occupants were fatally injured.This accident…NTSB DCA17RA058Accident · 39 fatalForeign investigationBoeing 747 · Bishkek, KyrgyzstanThe Government of Kyrgyzstan has notified the NTSB of an accident involving a BOEING 747 that occurred on January 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Kyrgyzstan's investigation under the provisions of…NTSB CEN17WA077Accident · 1 fatalForeign investigationPiper Piper PA-30 · Oxfordshire, United KingdomOn January 15, 2017, a Piper PA-30 airplane, (G-ATMT, s/n 30-439), crashed into woodland near Oxfordshire, United Kingdom. There was one person on board, who was fatally injured, and the aircraft was destroyed.This investigation is under the jurisdiction and…NTSB ERA17WA082Accident · 1 fatalForeign investigationCessna A188 · Michiragua, ColombiaOn January 7, 2017, about 1315 UTC, a Cessna A188A; HK714 was lost at sea after takeoff from La Guajira, Columbia. The wreckage was not recovered and the pilot was presumed fatally injured.The investigation is under the jurisdiction of the Government of…