NTSB investigations
1,709 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 ANC20WA031Accident · 1 fatalForeign investigationRobinson R44 · Astrakhan, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB CEN20FA098Accident · 1 fatalClass 3 · FieldFinal reportInnovator Mosquitto · North Manchester, INThe pilot’s loss of control for reasons that could not be determined based on the available information.NTSB ANC20WA033Accident · No injuriesForeign investigationBombardier CL600 2B16 · Calgary, CanadaThe government of Canada has notified the NTSB of an accident involving a BOMBARDIER CL600 2B16 airplane that occurred on February 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB CEN20WA121Accident · 1 fatalForeign investigationLavia Argentina PA-25-235 · Etchoja, MexicoThe government of Mexico has notified the NTSB of an accident involving a LAVIA ARGENTINA PA-25-235 airplane that occurred on February 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under…NTSB ANC20WA026Accident · No injuriesForeign investigationAgustawestland AW139 · Ishikari-City, Hokkaido, JapanThe government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB ANC20WA019Accident · 1 fatalForeign investigationBell 407 · Laishevo, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on February 07, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions…NTSB ANC20WA025Accident · No injuriesForeign investigationAgustawestland AW139 · Fukushima, JapanThe government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB WPR20WA082Accident · 3 fatalForeign investigationCessna S550 · George, South AfricaOn January 23, 2020, about 0853 coordinated universal time, a Cessna S550, ZS-CAR, impacted mountainous terrain under unknown circumstances while conducting aerial surveying operations near George, South Africa. The two crew members and one passenger were…NTSB CEN20WA081Accident · Serious injuriesForeign investigationBell 206 · Lac Saint-Jean, CanadaThe government of Canada has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA20RA048Accident · 176 fatalForeign investigationBoeing 737 · Tehran, IranThe government of Iran has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iran's investigation under the provisions of…NTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR20WA061Accident · No injuriesForeign investigationCessna 172 · Dhana, IndiaThe government of India has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on January 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of…NTSB CEN20WA054Accident · 4 fatalForeign investigationMooney M20 · Lifou Wanaham, New CaledoniaOn January 3, 2020, about 1430 universal coordinated time, a Mooney M20J, French registration F-OIAT, impacted terrain shortly after departing the Lifou Wanaham Airport (New Caledonia). The aircraft was destroyed, and the pilot and three passengers were…NTSB ANC20MA010Accident · 7 fatalClass 1 · MajorFinal reportAirbus AS350B2 · Kekaha, HIThe pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…NTSB CEN20WA045Accident · No injuriesForeign investigationCessna 208 · San Rafael, MexicoOn December 24, 2019, about 1529 coordinated universal time, a Cessna 208B airplane, XA-TWN, impacted desert terrain near San Rafael, Sonoroa, Mexico, while enroute to the Guerrero Negro Airport (MMGR), Baja California, Mexico. The two occupants sustained…NTSB WPR20WA044Accident · 2 fatalForeign investigationAngel 44 · Mareeba, AustraliaOn December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…NTSB ANC20WA009Accident · 3 fatalForeign investigationPiper PA60 · Nanaimo, CanadaThe government of Canada has notified the NTSB of an accident involving a Piper PA60 airplane that occurred on December 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB CEN20WA210Accident · 2 fatalForeign investigationPiper PA30 · Kaunas, LithuaniaThe government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…NTSB ANC20WA008Accident · 1 fatalForeign investigationRobinson R66 · Krasnodarsky Krai, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on November 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB DCA20WA019Accident · 29 fatalForeign investigationDornier 228 · Gomo, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a DORNIER 228 airplane that occurred on November 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.NTSB WPR20LA028Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Metaline, WAImpact with a lake for reasons that could not be determined.NTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.NTSB ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.NTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.NTSB WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.NTSB WPR20FA013Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Las Vegas, NVAn undetermined inflight event that resulted in the pilot performing an autorotation to uneven terrain for reasons that could not be determined due to the extent of impact damage.NTSB GAA20WA047Accident · 1 fatalForeign investigationRobinson R44 · Tarasenkove, UkraineThe government of Ukraine has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…NTSB CEN20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV-8 · White Plains, ALImpact with terrain for reasons that could not be determined based on the available information.NTSB CEN20LA021Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA23 · (Gulf of Mexico)The airplane’s descent into the ocean for reasons that could not be determined.NTSB WPR20WA006Accident · 1 fatalForeign investigationPiper PA-28-140 · Huhudi, South AfricaOn October 6, 2019, about 1547 coordinated universal time, a Piper PA28-140, ZS-EEZ, crashed near, Vryburg Airport, Huhudi, South Africa. The pilot was fatally injured, and the passenger sustained serious injuries. The extent of the airplane's damage is…NTSB CEN20LA004Accident · No injuriesClass 3 · LimitedFinal reportBeech B36 · Ranger, TXA lack of climb performance after takeoff for reasons that could not be determined based on the available information.NTSB CEN20LA005Accident · No injuriesLimited investigationFinal reportZenair Zenith CH 701 · Garden Ridge, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR19LA267Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Modesto, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ANC19WA056Accident · 1 fatalForeign investigationBell 206 · Campbell River, CanadaThe government of Canada has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on September 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB CEN19LA297Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Independence Charter Township, MIThe reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.NTSB WPR19WA272Accident · 9 fatalForeign investigationBeech B300 · Calamba, PhilippinesOn September 1, 2019 about 0541 universal coordinated time, a Beech B-300, RP-C2296, collided with terrain near Brgy. Pansol, Calamba, Laguna, Philippines. The two flight crew and seven passengers were fatally injured. Two persons on the ground received minor…NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19WA296Accident · Serious injuriesForeign investigationRobinson R44 · Veracruz, MexicoOn August 26, 2019, about 1700 hours universal coordinated time, a Robinson R-44 II helicopter, Mexican registration XB-GIL, was substantially damaged during an emergency landing in a field near Veracruz, Mexico. Two occupants were seriously injured; one…NTSB CEN19WA286Accident · 2 fatalForeign investigationPitts S2 · Stonor Oxforshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN19WA284Accident · 1 fatalForeign investigationReims F172 · Schneizlreuth, GermanyThe government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA282Accident · 1 fatalForeign investigationCessna 150 · Diepholz, GermanyOn August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…NTSB WPR19WA274Accident · 2 fatalForeign investigationCessna 172 · Pretoria, South AfricaOn August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…NTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…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…