NTSB investigations, Outside the U.S.
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventCountry\" <> 'USA' 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."eventCountry" <> 'USA' 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 GAA20WA139Accident · 1 fatalClass 5 · ForeignCessna 172 · Riyadh, Saudi ArabiaNTSB GAA20WA145Accident · Minor injuriesClass 5 · ForeignPiper PA34 · Cork, IrelandNTSB CEN20WA409Accident · 1 fatalClass 5 · ForeignPitts S1 · Kulmbach, GermanyNTSB WPR20WA329Accident · No injuriesClass 5 · ForeignRobinson R44 · Rooibok-Kraal, South AfricaNTSB WPR20WA327IncidentClass 5 · ForeignCessna 210 · Criterion, South AfricaNTSB DCA21WA017IncidentClass 5 · ForeignBombardier CL600 2C10 · Chihuahua City, MexicoNTSB CEN20WA408Accident · 2 fatalForeign investigationRaven Aircraft Corppration Raven · Moosburg an der Isar, GermanyNTSB CEN21WA036Accident · 2 fatalClass 5 · ForeignCessna TU206G · Los Laureles, MexicoNTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB DCA27WA007Incident · No injuriesClass 5 · ForeignFairchild SA227-AC · Gyor, HungaryNTSB DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanNTSB GAA20WA147Incident · No injuriesClass 5 · ForeignBellanca 8KCAB · Roskilde, DenmarkNTSB GAA20WA146Incident · No injuriesClass 4 · ForeignChampion 8KCAB · Roskilde, DenmarkNTSB GAA20WA138Incident · No injuriesForeign investigationPiper PA28R · Slagelse, DenmarkThe government of Denmark has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 10, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…NTSB DCA20WA151Incident · No injuriesClass 5 · ForeignBombardier CL600 2D24 · Gallivare, SwedenNTSB DCA20WA144Incident · No injuriesForeign investigationBoeing 737 · West Midland, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB GAA20WA133Accident · 4 fatalForeign investigationCommander 114 · Fur airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a COMMANDER 114 airplane that occurred on August 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…NTSB DCA20WA142Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13.All…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 GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB DCA20WA140Accident · No injuriesClass 5 · ForeignBoeing 767 · Bucure?ti, RomaniaNTSB WPR20WA292Accident · 1 fatalForeign investigationCessna 172 · Springs, South AfricaThe government of South Africa has notified the National Transportation Safety Board (NTSB) of an accident involving a Cessna 172 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyNTSB DCA20WA139Incident · No injuriesForeign investigationDouglas DC3 · San Jose del Guaviere, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Douglas (Boeing) DC3 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA of Colombia's investigation under the provisions…NTSB CEN20WA435Accident · 2 fatalClass 4 · ForeignSchleicher ASH25 · Gloucestershire, United KingdomNTSB GAA20WA141IncidentClass 5 · ForeignRobinson R44 · Gulf of Glyfada, GreeceNTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20WA434IncidentClass 5 · ForeignRaytheon Hawker · Le Bourget, FranceNTSB WPR21WA103AccidentClass 5 · ForeignCessna 150 · Kenitra, MoroccoNTSB CEN20WA439Accident · Serious injuriesClass 4 · ForeignCessna F-172 · Nabern-Teck, GermanyNTSB WPR20WA281Accident · No injuriesForeign investigationRobinson R22 · McArthur River Mine, AustraliaNTSB GAA21WA004Accident · No injuriesClass 5 · ForeignVans RV7 · Little Bassetts Farm, Bentwood, United KingdomNTSB GAA20WA129Accident · No injuriesForeign investigationHawker SEA Fury · Button End, Harston, Cambridgeshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a HAWKER SEA FURY airplane that occurred on August 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB CEN20WA376Accident · 1 fatalForeign investigationCanadair CL215 1A10 · Lobios (Ourense), PortugalThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…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 GAA20WA128Accident · 1 fatalForeign investigationRans S6 · Heathfield East Sussex, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA20WA151Accident · Serious injuriesClass 5 · ForeignCessna 182 · Steiermark, AustriaNTSB 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 WPR20WA248Accident · Serious injuriesForeign investigationRobinson R44 · Steam Plains, AustraliaThe government of Australia has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on July 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB GAA20WA125Accident · 1 fatalForeign investigationCessna R172 · Tarapaca-Amazonas, ColombiaNTSB 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 DCA20WA133Incident · No injuriesForeign investigationBoeing 737 · Wamena, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT of Indonesia'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 GAA20WA130Accident · No injuriesForeign investigationCessna 208 · Holbox, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA126Accident · 4 fatalForeign investigationCessna 172 · Blatten - VS, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB ENG20WA040Incident · No injuriesForeign investigationEmbraer ERJ190 · Chihuahua, MexicoNTSB ENG20WA038Accident · No injuriesClass 5 · ForeignPiper PA28RT · Basel, SwitzerlandNTSB WPR20WA241Incident · No injuriesForeign investigationCessna 441 · Djugun, AustraliaThe government of Australia has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on July 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…NTSB DCA20WA128Accident · No injuriesForeign investigationBoeing 777 · Shanghai, ChinaThe Civil Aviation Administration (CAAC) of China has notified the NTSB of an accident involving a Boeing 777, which occurred on July 22, 2020. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13 as the State…NTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…