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 WPR17WA016Accident · 2 fatalForeign investigationRobinson R44 · Kamo, New Zealand, New ZealandOn October 30, 2016, a Robinson R44, ZK-HTH, was destroyed by fire after it collided with terrain near Kamo, New Zealand, The helicopter was operated by Helisika Agricultural Limited under the pertinent regulations of the government of New Zealand. The pilot…NTSB WPR17FA013Accident · 2 fatalField investigationFinal reportBeech A36 · Pittsburg, CAA loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane.NTSB ERA17WA051Accident · 2 fatalForeign investigationEmbraer EMB711 · Espumoso, BrazilOn October 25, 2016, about 1250 coordinated universal time (1050 local time), an Embraer 711C, Brazilian registration PT-NQS, operated by a private individual, was destroyed after it impacted the ground shortly after takeoff from Espumoso Airport (SSEZ),…NTSB ERA17WA028Accident · 3 fatalForeign investigationRobinson R44 · Baleisky, RussiaOn October 23, 2016, about 1030 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04347, was destroyed when it impacted terrain in the Baleisky district, in eastern Siberia, Russia, while en route from Zolotorechensk Airport to…NTSB GAA17CA033Accident · Minor injuriesData collectionFinal reportStinson 108 3 · Boulder City, NVThe pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.NTSB DCA17WA224Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board has notified the NTSB of a serious incident involving a BOEING 757 airplane that occurred on October 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iceland's…NTSB CEN17WA017Accident · 1 fatalForeign investigationCessna F150 · Cambridge, United KingdomOn October 17, 2016, at 1021 coordinated universal time, a Reims Cessna F150M airplane, G-BDZC, crashed after takeoff at the Bourn Airfield (EGSN), Cambridge, United Kingdom. The pilot was fatally injured.The accident investigation is under the jurisdiction…NTSB CEN17WA020Accident · Serious injuriesForeign investigationSocata TBM700 · Surrey, United KingdomOn October 15, 2016, a Socata TBM700 airplane, M-VNTR, undershot the runway at Fairoaks Airport (EGTF), near Surrey, England. There were two persons on board, one of whom was seriously injured.This investigation is under the jurisdiction and control of the…NTSB ERA17WA009Accident · 3 fatalForeign investigationCessna 207 · Santa Cruz, Cajamarca, PeruOn October 10, 2016, about 1427 universal coordinated time, a Cessna 207A, Peruvian registration OB-1936-P, was destroyed during a collision with mountainous terrain near Santa Cruz, Cajamarca, Peru. The pilot and two passengers were fatally injured. The…NTSB ANC17WA002Accident · 1 fatalForeign investigationSteen Skybolt · Blackfalds, CanadaOn October 06, 2016, about 2050 Coordinated Universal Time, an amateur-built Steen Skybolt airplane, C-GWBD, impacted terrain near Blackfalds, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB WPR17LA005Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Waimea, HIImpact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.NTSB ERA16WA332Accident · 4 fatalForeign investigationCessna 208 · San Antonio De Prado, ColombiaOn September 30, 2016, about 1705 coordinated universal time, a Cessna 208B, Colombian registration HK3804, was substantially damaged when it impacted high terrain near San Antonio De Prado, Colombia. One of the Colombian certificated pilots and three of the…NTSB ENG16RA041Incident · No injuriesForeign investigationBAE AVRO146RJ · Malmo, SwedenThe Swedish Accident Investigation Authority has notified the NTSB of an incident involving a BAE Systems (Operations) Limited Avro 146-RJ100 which occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Swedish…NTSB CEN16LA386Accident · Serious injuriesLimited investigationFinal reportBell 407 · Lawton, OKThe pilot's loss of helicopter control during landing, which resulted in a hard landing and collision with a wall.NTSB ERA16WA327Accident · 2 fatalForeign investigationAgusta Bell AB206-B3 · Yartsevo, RussiaOn September 24, 2016, at an unknown time, an Agusta-Bell AB206-B3 helicopter, Russian registration RA-01630, was substantially damaged when it crashed under unknown circumstances near Yartsevo, Russia. The pilot and passenger were fatally injured.The…NTSB ANC16RA074Accident · 1 fatalForeign investigationPitts S2 · Seoul, South KoreaOn September 24, 2016 , about 1132 local time, an Aviat Pitts S-2B airplane, Republic of Korea registration number HL1161, operated by the pilot, was destroyed following an impact with terrain during an airshow at Taean Airfield, Republic of Korea. The pilot…NTSB ERA16WA337Accident · 1 fatalForeign investigationEmbraer EMB810 · Miranda, BrazilOn September 19, 2016, at 2000 coordinated universal time (1600 local), a Piper designed Embraer EMB810-D, Brazilian registration PT-VKY, was destroyed when it impacted terrain in the Miranda Municipality, State of Mato Grosso Do Sul, Brazil. The pilot was…NTSB WPR16FA182Accident · 3 fatalField investigationFinal reportBeech 95 B55 (T42A) · Broadus, MTThe airplane's departure from cruise flight for reasons that could not be determined based on the available information.NTSB DCA16WA232Accident · No injuriesForeign investigationBell 430 · Cabinda, AngolaThe Angola Ministry of Transport (MoT) has notified the NTSB of an accident involving a BELL 430 helicopter that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MoT's investigation under the provisions of…NTSB WPR16WA186Accident · 4 fatalForeign investigationLittle Eagle LE500 · Shijiazhuang City, ChinaOn September 15, 2016, about 0308 Universal Time, a Little Eagle LE500 single-engine airplane, Chinese registration B-9246, impacted flat terrain about 1,640 feet from the approach end of runway 18, at the Luan Cheng General Aviation Airport, Shijiazhuang…NTSB OPS16WA017Incident · No injuriesForeign investigationAirbus A330 · Gold Coast, AustraliaThe Australian Transport Safety Bureau (ATSB) of Australia has notified the NTSB of an incident involving an Airbus A330-343, which occurred on September 11, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under…NTSB CEN16WA365Accident · 1 fatalForeign investigationRobinson R66 · Carinthia, AustriaOn September 8, 2016, at 1920 coordinated universal time (UTC), a Robinson R66, Austrian registration OE-XHA, was destroyed when it impacted terrain under unknown circumstances near Carinthia, Austria. Visual meteorological conditions prevailed at the time of…NTSB CEN16WA368Accident · 6 fatalForeign investigationPiper PA34 · Skopje, Macedonia, North MacedoniaOn September 6, 2016, about 1540 local time, a Piper PA-34-200T multi-engine airplane, serial number 34-8070170, German registry D-GLLW, was destroyed after impacting terrain while on an ILS approach to Runway 34 at Alexander the Great Airport (LWSK), Skopje,…NTSB CEN16WA357Accident · 2 fatalForeign investigationRobin DR400 · Villanueva del Condado, SpainOn September 6, 2016, about 1420 hours coordinated universal time (UTC), a French manufactured Robin DR400-180 airplane, Spanish registration EC-KFG, impacted terrain neat Villanueva del Condado, Leon, Spain. The pilot and passenger were fatally injured. The…NTSB CEN16WA371Accident · 3 fatalForeign investigationPiper PA28 · Bovec, SloveniaOn September 1, 2016, about 1545 coordinated universal time, a Piper PA-28-161, Slovenia-registration S5-DES, was destroyed when it crashed into mountainous terrain near Bovec, Slovenia. The pilot and two passengers were fatally injured. The flight originated…NTSB CEN16WA337Accident · 1 fatalForeign investigationYakovlev/Chinnery YAK 11 · Speyer, GermanyOn August 25, 2016, at 0651 universal coordinated time, a Yakolev YAK-11, US registration N111YK, crashed under unknown circumstances in Speyer, Germany. The pilot was fatally injured and the airplane was destroyed. The accident investigation is under the…NTSB CEN16WA395Accident · Serious injuriesForeign investigationBell 206 · Sayaxché, GuatemalaOn August 12, 2016, about 1500 universal coordinated time (UTC), a Guatemalan-registered Bell 206-L3 helicopter, TG-CHB, crashed near Sayaxche, Guatemala. The pilot was seriously injured, one passenger received minor injuries, and two passengers were…NTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.NTSB WPR16FA160Accident · 1 fatalField investigationFinal reportAMS Flight Carat A · Minden, NVImpact with terrain for reasons that could not be determined based on the available information.NTSB ERA16WA283Accident · Serious injuriesForeign investigationRobinson R66 · Voronezhskaya oblast, RussiaOn August 7, 2016, about 1030 coordinated universal time, a Robinson Helicopter R66, Russian registration RA-06347, was substantially damaged when it impacted electrical transmission lines near Borki village, Ramogn region, Voronezhskaya oblast, Russia. The…NTSB CEN16WA318Accident · 1 fatalForeign investigationPiper PA28 · Winchelsea, East Sussex, United KingdomOn August 6, 2016, a Piper PA-28-161 airplane, G-CDER, sank after ditching near Winchelsea, East Sussex. The pilot was fatally injured. This investigation is under the jurisdiction and control of the government of the United Kingdom. Any further information…NTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.NTSB DCA16RA206Accident · 1 fatalForeign investigationBoeing 777 · Dubai, United Arab EmiratesThe United Arab Emirates General Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a BOEING 777 that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the…NTSB WPR16WA161Accident · 1 fatalForeign investigationPiper PA31 · Nong Prue, Thailand, ThailandOn August 1, 2016, at 1605 local time, a Piper PA31-350, HS-FGB, was destroyed after it collided with a wooden bridge during an emergency landing near Nong Prue, Thailand. The aircraft was operated under the pertinent regulations of the Government of…NTSB CEN16FA282Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Leshara, NEThe pilot's loss of airplane control during a practice stall maneuver, which resulted in a spin that continued to ground impact.NTSB WPR16RA151Accident · 5 fatalForeign investigationCessna 208 · Shanghai, ChinaOn July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…NTSB ANC16WA045Accident · 1 fatalForeign investigationDehavilland DHC-2 MK. I · Telegraph Creek, CanadaOn July 15, 2016, about 0520 Coordinated Universal Time, a Canadian registered De Havilland DHC-2 Mk I airplane on floats, C-GWDW, owned and operated by Tsayta Aviation Ltd, impacted terrain approximately 15 nm east south east of Telegraph Creek, British…NTSB CEN16WA268Accident · 4 fatalForeign investigationPiper PA-32R-301 · Ajdovscina, SloveniaThe accident investigation is under the jurisdiction and control of the Republic of Slovenia. This report is for information purposes only and contains only information released by or obtained from the Republic of Slovenia. Further information pertaining to…NTSB ANC16WA042Accident · 1 fatalForeign investigationAero Commander B1A · Hoey, CanadaOn July 14, 2016, about 0230 Coordinated Universal Time, an Aero Commander B1A airplane, C-GSQY, lost engine power and impacted terrain after takeoff near Hoey, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…NTSB ANC16WA043Accident · 1 fatalForeign investigationAir Tractor AT301 · Rocanville, CanadaOn July 8, 2016, about 2359 Coordinated Universal Time, an Air Tractor AT-301 airplane, C-GCYV, impacted terrain while low-level maneuvering near Rocanville, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB ANC16WA039Accident · 2 fatalForeign investigationPiper PA28 · Winnipeg, CanadaOn July 1, 2016, at approximately 1445 Coordinated Universal Time, a Canadian registered Piper PA-28-140 airplane, C-GNUC, owned and operated by a private pilot, was destroyed when it collided with terrain shortly after takeoff from Winnipeg Lyncrest Airport…NTSB ERA16WA240Accident · 5 fatalForeign investigationBell Helicopter 407 · Jundiaí, BrazilOn June 26, 2016, about 1110 coordinated universal time, a Bell 407, Brazilian registration PR-CBB, was destroyed during a collision with terrain and post-crash fire in Jundiaí, Brazil. The pilot and four passengers were fatally injured.The flight had…NTSB CEN16LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Humansville, MOA partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB ERA16WA219Accident · 2 fatalForeign investigationPiper PA 23-250 · South Bimini, BahamasOn June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…NTSB ANC16WA033Accident · 1 fatalForeign investigationPiper PA28R · Green Lake, CanadaOn June 16, 2016, about 1900 Coordinated Universal Time, a Piper PA28R-180 airplane, C-FYGG, struck trees and impacted terrain while attempting a go-around near Green Lake, British Columbia, Canada. The pilot sustained serious injuries and the passenger…NTSB WPR16WA162Accident · No injuriesForeign investigationHawker Beech 900 · Chennai, India, IndiaOn June 7, 2016, at 2006 local time, a Hawker 900 XP, VT-LTA, was substantially damaged after a nose gear sheared off during the landing near Chennai, India. The aircraft was operated under the pertinent regulations of the Government of India. The 2…NTSB DCA16RA175Accident · Minor injuriesForeign investigationMcdonnell Douglas MD11 · Incheon, South KoreaimportNTSB WPR16WA123Accident · 1 fatalForeign investigationBell 206 · Siriwo, IndonesiaOn June 4, 2016, about 0815 local time, a Bell 206 helicopter, registration PK-UAF, sustained substantial damage following collision with terrain near Siriwo, Indonesia. Reports indicate that there were 4 soles onboard the helicopter; 1 fatal, 3 serious. The…NTSB ANC16WA030Accident · 1 fatalForeign investigationWag-Aero Super Tri-Pacer · Williston Lake, CanadaOn June 04, 2016, about 1500 Coordinated Universal Time, a Wag-Aero Super Tri-Pacer airplane, CGSMJ, impacted terrain near Williston Lake, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The…