NTSB investigations, 2020, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c.\"eventDate\") = 2020
AND 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 year(c."eventDate") = 2020 AND 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 GAA21WA175Accident · 5 fatalClass 5 · ForeignPioneer 300 · Loches, FranceNTSB DCA21WA006IncidentClass 5 · ForeignBoeing 777 · Guiuan, Eastern Samar, PhilippinesNTSB CEN21WA059Accident · No injuriesClass 4 · ForeignPiper PA46 · Villingen-Schwenningen, GermanyNTSB GAA21WA003Accident · 1 fatalClass 5 · ForeignPiper PA25 · Juan Jose Rios, MexicoNTSB CEN21WA011Accident · No injuriesClass 5 · ForeignCirrus SR22 · Langdorp, BelgiumNTSB CEN21WA115Accident · Serious injuriesClass 5 · ForeignCessna 185A · Romsey, United KingdomNTSB DCA21WA003AccidentClass 5 · ForeignBoeing 737-4B6 · San Jose, Costa RicaNTSB ERA21WA033Accident · 2 fatalClass 3 · ForeignANG 01 · Peremoha, UkraineNTSB DCA21WA098IncidentClass 5 · ForeignAirbus A320-214 · Bogata, ColombiaNTSB ENG21WA005IncidentClass 5 · ForeignATR ATR72 · Makassar, IndonesiaNTSB DCA21WA004Incident · No injuriesClass 4 · ForeignBoeing 787-800 · Amsterdam, NetherlandsNTSB WPR21WA047Accident · Minor injuriesClass 5 · ForeignAir Tractor AT502 · Semera, EthiopiaNTSB DCA21WA001Incident · No injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB ENG21WA002IncidentClass 5 · ForeignAirbus A330 · Nawabshah, PakistanNTSB CEN20WA426Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Le Chevillotte, FranceNTSB CEN21WA017Accident · No injuriesClass 5 · ForeignCessna 180D · Linköping, SwedenNTSB CEN20WA418Incident · No injuriesClass 4 · ForeignSikorsky S92 · Sola, NorwayNTSB GAA20WA149AccidentClass 5 · ForeignCessna 182 · Minas City, UruguayNTSB CEN20WA423IncidentClass 5 · ForeignCessna 208B · Beef Island, British Virgin IslandsNTSB 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, Australia