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 CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB WPR20WA294Accident · No injuriesForeign investigationBell 206 · Lago, NigeriaThe government of Nigeria has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Nigeria's investigation under the provisions…NTSB ERA20LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Fletcher, NCA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN20WA435Accident · 2 fatalClass 4 · ForeignSchleicher ASH25 · Gloucestershire, United KingdomNTSB ANC20LA083Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS350 · Ninilchik, AKA loss of engine power for an undetermined reason.NTSB GAA20WA141IncidentClass 5 · ForeignRobinson R44 · Gulf of Glyfada, GreeceNTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe 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 based on the available evidence.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA328Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Marathon, TXThe in-flight loss of helicopter control for reasons that could not be determined based on the available evidence.NTSB DCA20WA136Accident · No injuriesForeign investigationBoeing 737 · Kozhikode, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on August 07, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of India's investigation…NTSB ANC20WA079Accident · No injuriesForeign investigationCessna 172 · Valdau, RussiaThe government of Russia has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on August 02, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…NTSB CEN20WA319Accident · No injuriesForeign investigationRans S12 · Sergio Perez de Leon, MexicoThe government of Mexico has notified the NTSB of an accident involving a RANS S12 airplane that occurred on July 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO…NTSB ANC20WA073Accident · 1 fatalForeign investigationCessna 140 · Abbotsford, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 140 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB GAA20WA148Accident · 1 fatalClass 4 · ForeignParachute Icarus Crossfire 2 · Juta, HungaryNTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB WPR20WA242Accident · Serious injuriesClass 5 · ForeignMD Helicopter 600 · Windhoek, NamibiaNTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA266Accident · Serious injuriesClass 3 · LimitedFinal reportLancair ES-P · Pauls Valley, OKThe reason for this accident could not be determined based on the available information.NTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.NTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB WPR20LA201Accident · 1 fatalClass 3 · LimitedFinal reportAvia Stroitel AC-5M · Bend, ORA loss of control just after takeoff for reasons that could not be determined based on the available information.NTSB WPR20LA191Accident · 1 fatalClass 3 · LimitedFinal reportEnstrom 280 · Hayden, IDThe total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.NTSB CEN20WA246Accident · No injuriesForeign investigationBell 407 · Long Marston, United KingdomThe government of the United Kingdom has notified the NTSB of an accident involving a Bell 407 helicopter that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation…NTSB WPR20LA190Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · North Las Vegas, NVA total loss of engine power for reasons that could not be determined based on the available information.NTSB ENG20WA037Incident · No injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe Mexican government has notified the NTSB of an incident involving an Airbus A330-202 that occurred June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the Direccion de Analisis de Accidentes e Incidentes de Aviacion (DGAC) of…NTSB WPR20WA182Accident · 2 fatalForeign investigationCessna 152 · Bhubaneswar, IndiaThe government of India has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of ICAO…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.NTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.NTSB CEN20WA433Accident · No injuriesClass 5 · ForeignCirrus SR22 · Foreign, United KingdomNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB CEN20WA171Accident · 3 fatalForeign investigationCessna 182 · Area Municipio De Joyabaj, GuatemalaNTSB 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…NTSB 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…NTSB CEN20WA200Accident · 1 fatalForeign investigationPiper PA 25-235 · Angostura, MexicoNTSB 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…NTSB 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.NTSB ERA20WA137Accident · 1 fatalForeign investigationBell 206 · Chicureo, ChileNTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.