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 CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.NTSB WPR19WA234Accident · 3 fatalForeign investigationRobinson R44 · Korotasere, Cakaudrove, FijiOn August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…NTSB CEN19WA301Accident · 2 fatalForeign investigationCessna TU206 · Guachochi, MexicoOn August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…NTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB WPR19LA202Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Port Townsend, WAThe loss of engine power for reasons that could not be determined based on available information.NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.NTSB ANC19WA041Accident · 2 fatalForeign investigationRobinson R22 · Moscow, RussiaOn July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…NTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB WPR19WA211Accident · 1 fatalForeign investigationCessna 172 · Anji, ChinaOn July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane…NTSB CEN19WA337Accident · 2 fatalForeign investigationRobinson R44 · Mt Tremblank, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R-44 helicopter, Canadian registration C-FJLH, that occurred on July 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's…NTSB ERA19LA221Accident · 1 fatalClass 3 · LimitedFinal reportTeam Mini-Max Hi-Max · Monroe, GAA collision with terrain for undetermined reasons.NTSB CEN19WA338Incident · No injuriesForeign investigationGulfstream Gulfstream GVI · Waterford, IrelandOn July 7, 2019, about 1645 coordinated universal time, a Gulfstream GVI airplane, EI-JSK, had an uncommanded engine shutdown in flight near Waterford, Ireland. The flight departed from and returned to Shannon Airport. The flight was destined for Farnborough…NTSB CEN19WA208Accident · 1 fatalForeign investigationPiper PA-24-250 · Quetzaltenango, GuatemalaThe government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the…NTSB CEN19WA197Accident · 2 fatalForeign investigationRans S6 · Rougemont, CanadaNTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…NTSB WPR19FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172 · Pescadero, CAImpact with the ocean for reasons that could not be determined because the airplane was not located.NTSB CEN19WA200Accident · 1 fatalForeign investigationPiper PA28 · Mandal, NorwayOn June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident…NTSB ANC19WA025Accident · No injuriesForeign investigationCirrus SR20 · Yeosu, South KoreaThe government of Korea has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea's investigation under the provisions of…NTSB CEN19WA273Accident · No injuriesForeign investigationAgustaWestland AW139 · Albarracín, SpainOn June 12, 2019, about 1330 local time, an AgustaWestland AW139 helicopter, EC-NEH, executed an emergency landing to an open field near Albarracín, Spain, for unknown reasons. The pilot and sole occupant sustained no injury, and the helicopter sustained…NTSB ANC19WA022Accident · 3 fatalForeign investigationGrumman AA-5B · Medicine Hat, CanadaOn June 2, 2019, at 0440 (UTC) time, a Canadian registered Grumman American Aviation, AA-5B airplane, C-GQIJ, operated by a private individual, was found after it had collided with terrain under unknown circumstances while conducting a VFR flight. A search…NTSB WPR19LA168Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky UH19 · Brewster, WAA reported mechanical malfunction and a hard landing for reasons that could not be determined based on available evidence.NTSB WPR19LA155Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Garberville, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.NTSB ERA19LA180Accident · 1 fatalLimited investigationFinal reportCessna 560 · Atlantic Ocean (Atlantic Ocean)Impact with water for reasons that could not be determined based on the available information.NTSB ERA19WA176Accident · 2 fatalForeign investigationBell 206 · La Vega, Dominican RepublicNTSB GAA19WA273Accident · No injuriesForeign investigationCirrus SR20 · Wilhelmshaven, Germany, GermanyThe government of Germany has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on May 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB CEN19RA145Accident · 5 fatalForeign investigationPiper PA32 · Roatán, HondurasimportNTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…NTSB WPR19WA158Accident · 2 fatalForeign investigationJM Kemp RT13B · Mookgopong, South AfricaOn May 10, 2019, about 1105 Coordinated Universal time, a JM Kemp RT13B, South African registry ZU-FUO, was destroyed when it impacted a ridge north of the Mountain View Lodge Airport, near the town of Mookgopong, Limpopo Province, South Africa. The pilot and…NTSB ANC19WA023Accident · 3 fatalForeign investigationCessna 182 · Smithers, CanadaThe government of Canada has notified the NTSB of an accident involving a Cessna 182E airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.NTSB CEN19LA127Accident · No injuriesClass 3 · LimitedFinal reportBeech 50 · Sheldon, MOA partial loss of engine power on both engines due to detonation for undetermined reasons.NTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB ENG19RA019Incident · No injuriesForeign investigationAvro 146 · Tambo International Airport, South AfricaThe South Africa Accident and Incident Investigation Division (AIID) has notified the United States, as the State of Design and Manufacture for the Engines, of an engine in-flight shut down incident involving a BAE Aero 146 RJ85A, ZS-SSJ, that occurred near…NTSB WPR19WA107Accident · 1 fatalForeign investigationCessna 182 · Wongabel, AustraliaOn April 8, 2019, about 0740 coordinated universal time a Cessna 182G airplane, VH-DJN, impacted terrain in the Wongabel State Forest, Wongabel, Queensland, Australia. The pilot in command was fatally injured, and the airplane was destroyed. The personal…NTSB DCA19RA101Accident · 157 fatalForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe government of Ethiopia has notified the NTSB of an accident involving a BOEING 737 that occurred on March 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ethiopia's investigation under the provisions of ICAO…NTSB WPR19WA164Accident · 5 fatalForeign investigationBell 505X · Londiani, Kericho, KenyaOn March 3, 2019, about 0834 local time, a Bell 505X, 5Y-KDL, collided with terrain near Londiani, Kericho, Kenya. The 1 pilot and 4 passengers were fatally injured; the helicopter was destroyed. The helicopter was owned and operated by KWAE Island…NTSB ERA19WA108Accident · 1 fatalForeign investigationCessna U206 · Eteringbang, GuyanaThe government of Guyana has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.NTSB CEN19WA083Accident · 2 fatalForeign investigationRobinson R44 · Roeldal, NorwayThe government of Norway has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the…NTSB CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19WA271Accident · 5 fatalForeign investigationCessna U206G · Londiani, KenyaOn February 13, 2019, at 0729 universal coordinated time a Cessna U206G, 5Y-BSE, crashed into terrain, following a distress signal from the airplane near Londiani, Kericho County, Kenya. The pilot and four passengers were fatally injured. The airplane was…NTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…NTSB ERA19WA090Accident · 1 fatalForeign investigationPiper PA25 · Jaguaré County, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA19WA054Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Dubai, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of The United Arab Emirates has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD11 that occurred on January 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's…NTSB CEN19LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Port Lavaca, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN19LA051Accident · 1 fatalLimited investigationFinal reportPiper PA 23 · Beaver Island, MIThe pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…