NTSB investigations, 2020

87 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 year(c.\"eventDate\") = 2020
    AND 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.

NTSB CEN20LA215Accident · 1 fatalClass 3 · LimitedFinal reportMitsubishi MU2B · Sioux Falls, SDThe pilot’s failure to maintain control of the airplane during takeoff for reasons that could not be determined.Jun 7, 2020 · N44MX · DestroyedNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB CEN20WA433Accident · No injuriesClass 5 · ForeignCirrus SR22 · Foreign, United KingdomMay 31, 2020 · G-CTAM · Substantial damageNTSB CEN20WA198Accident · 1 fatalForeign investigationCessna 150 · Blomberg, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on May 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…May 27, 2020 · D-ECVT · DestroyedNTSB ERA20WA196Accident · 1 fatalForeign investigationDiamond DA20 · Rome, ItalyThe government of Italy has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on May 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…May 25, 2020 · I-DADL · Substantial damageNTSB DCA20WA108Accident · 97 fatalForeign investigationAirbus A320 · Karachi, PakistanThe government of Pakistan has notified the NTSB of an accident involving an AIRBUS A320 with CFM56 engines that occurred on May 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…May 22, 2020 · AP-BLD · DestroyedNTSB CEN20LA187Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · West Branch, MIThe pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…May 20, 2020 · N153SA · Substantial damageNTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.May 15, 2020 · N1JA · Substantial damageNTSB WPR20WA143Accident · 1 fatalForeign investigationDaher Kodiak · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a Daher Kodiak airplane that occurred on May 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…May 12, 2020 · PK-MEC · Substantial damageNTSB CEN20WA209Accident · 2 fatalForeign investigationPiper PA38 · Kena, LithuaniaThe National Transportation Safety Board was notified of an accident involving a Piper PA-38-112 airplane, LY-ATM, near Kena, Lithuania. This investigation is under the jurisdiction of Ministry of Justice of the Republic of Lithuania, Transport Accident and…May 9, 2020 · LY-ATMNTSB ERA20WA170Accident · 1 fatalForeign investigationLearjet 35 · Esquel, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a LEARJET 35 airplane that occurred on May 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…May 6, 2020 · LV-BXU · Substantial damageNTSB CEN20WA171Accident · 3 fatalForeign investigationCessna 182 · Area Municipio De Joyabaj, GuatemalaMay 6, 2020 · TG-MOL · DestroyedNTSB ERA20WA167Accident · 2 fatalForeign investigationGrumman AA5 · Dnipropetrovsk, UkraineThe government of Ukraine has notified the NTSB of an accident involving a GRUMMAN AA5 airplane that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions of…May 1, 2020 · UR-DCJ · Substantial damageNTSB ANC20WA072Accident · 2 fatalForeign investigationSikorsky S76 · Cheonwangbong, South KoreaThe government of Korea, Republic Of has notified the NTSB of an accident involving a SIKORSKY S76 helicopter that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea, Republic Of's investigation…May 1, 2020 · HL9646 · Substantial damageNTSB CEN20WA200Accident · 1 fatalForeign investigationPiper PA 25-235 · Angostura, MexicoApr 28, 2020 · XB-ZOZNTSB CEN20WA157Incident · No injuriesForeign investigationCessna 650 · Ciudad Juarez, MexicoOn April 7, 2020, about 1640 hours universal coordinated time, a Cessna 650 airplane, Mexican registration XA-SDU, was involved in an incident at the Abraham González International Airport (MMCS), located in Ciudad Juárez, Chihuahua, Mexico, The NTSB has…Apr 7, 2020 · XA-SDU · Minor damageNTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.Apr 1, 2020 · N9883R · Substantial damageNTSB ERA20WA137Accident · 1 fatalForeign investigationBell 206 · Chicureo, ChileMar 24, 2020 · CC-ARR · DestroyedNTSB ERA20LA134Accident · 2 fatalClass 3 · LimitedFinal reportMaule MT-7 · Swansboro, NCThe airplane’s turning descent into water while enroute in night instrument meteorological conditions for reasons that could not be determined.Mar 24, 2020 · N899ZZ · DestroyedNTSB ANC20WA035Accident · 1 fatalForeign investigationBell 206 · Konstantinovsky Cape, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…Mar 23, 2020 · RA-01917NTSB ERA20WA136Accident · 2 fatalForeign investigationCessna 310 · Tefe, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 310 airplane that occurred on March 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Mar 13, 2020 · PR-GSG · Substantial damageNTSB DCA20WA089Incident · No injuriesForeign investigationBoeing 737 · Brazzaville, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…Mar 1, 2020 · CN-RNKNTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.Feb 29, 2020 · N601ND · Substantial damageNTSB 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…Feb 28, 2020 · RA-04246 · Substantial damageNTSB 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.Feb 23, 2020 · N840GS · Substantial damageNTSB 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…Feb 23, 2020 · C-GKCPNTSB 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…Feb 18, 2020 · XB-EMO · DestroyedNTSB 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…Feb 16, 2020 · JA17ARNTSB 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.Feb 12, 2020 · N654CE · Substantial damageNTSB 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…Feb 7, 2020 · RA-01893 · Substantial damageNTSB 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…Feb 1, 2020 · JA139FNTSB 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…Jan 23, 2020 · ZS-CAR · Substantial damageNTSB 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…Jan 23, 2020 · C-GSQA · Substantial damageNTSB 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…Jan 8, 2020 · UR-PSR · DestroyedNTSB 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.Jan 4, 2020 · N5573M · Substantial damageNTSB 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…Jan 3, 2020 · VT-CAF · Substantial damageNTSB 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…Jan 3, 2020 · F-OIAT · Destroyed