NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 ANC06WA142Accident · Minor injuriesForeign investigationBell 206B · Fontas, Alberta, CanadaNTSB NYC06WA166Accident · 1 fatalForeign investigationPiper PA-23-250 · Thirkleby, United KingdomNTSB DFW06WA170Accident · 1 fatalForeign investigationCessna U206 · Chiguao, VenezuelaNTSB DFW06WA169Accident · No injuriesForeign investigationRaytheon Corporate Jets DH 125-3A · Barcelona, VenezuelaNTSB DCA06WA052Accident · No injuriesForeign investigationBoeing B737-300 · East Midlands, United KingdomNTSB DCA06WA051Incident · No injuriesForeign investigationBoeing B737-400 · Catania, ItalyNTSB WAS06WA013Incident · No injuriesForeign investigationBoeing 737-2m2 · Accra, GhanaNTSB DCA06WA065Incident · No injuriesForeign investigationBoeing B737-400 · Frankfurt, GermanyNTSB NYC06WA170Accident · No injuriesForeign investigationRobinson R-22 · Paris, FranceNTSB DCA06WA049Accident · No injuriesForeign investigationBoeing 747-200 · Rio Negro, ColombiaNTSB LAX06WA201Accident · No injuriesForeign investigationBell 407 · Bangalore, IndiaNTSB DCA06RA042Accident · No injuriesForeign investigationMcDonnell Douglas DC10-10F · Managua, NicaraguaNTSB LAX06WA188Accident · 1 fatalForeign investigationBeech A36 · Bathurst Island, AustraliaNTSB DFW06WA148Accident · 1 fatalForeign investigationAir Tractor AT-802 · Molinicos, SpainNTSB DFW06WA147Accident · 3 fatalForeign investigationSchweizer 269D · Ciudad Juarez, MexicoNTSB ENG06WA041Incident · No injuriesForeign investigationAirbus A330 · Dubai, United Arab Emirates, United Arab EmiratesNTSB NYC06WA132Accident · 2 fatalForeign investigationCessna 150M · Raharney, IrelandNTSB MIA06WA115Accident · Minor injuriesForeign investigationIsrael Aircraft Industries 1124 · Georgetown, BahamasNTSB SEA06WA104Accident · No injuriesForeign investigationCessna 210G · Seoul, South KoreaNTSB DCA08WA014Accident · Minor injuriesForeign investigationBoeing B737-200 · Jakarta, IndonesiaNTSB DCA06RA040Incident · No injuriesForeign investigationBoeing B727-200 · Banglore, IndiaNTSB ENG07WA003Accident · 113 fatalForeign investigationAirbus A320 · Sochi, RussiaNTSB DEN06WA072Accident · 2 fatalForeign investigationBeech C 24R · Albshausen, GermanyNTSB DCA06WA037Incident · No injuriesForeign investigationBoeing B737-800 · Skelleftea, SwedenNTSB DCA06WA036Incident · No injuriesForeign investigationAirbus A-300-B4 · Toronto, CanadaNTSB DFW06WA114Accident · No injuriesForeign investigationPiper PA-28-181 · Amman, JordanNTSB ATL06WA074Accident · 1 fatalForeign investigationPiper PA-34-220T · San Javier, SpainNTSB WAS06WA009Accident · 3 fatalForeign investigationCessna 208B · Kasese, UgandaNTSB ENG06RA037Accident · No injuriesForeign investigationBell 206B3 · San Paulo, BrazilNTSB SEA06WA085Accident · No injuriesForeign investigationGarlick UH-1H · Sarawak, MalaysiaNTSB DCA06WA035Accident · Serious injuriesForeign investigationBoeing 777 · Shanghai, ChinaNTSB ATL06WA067Accident · 2 fatalForeign investigationCessna 172M · Toledo, SpainNTSB SEA06WA079Accident · No injuriesForeign investigationLake LA-4-200 · Lady Smith, CanadaNTSB MIA06WA094Incident · No injuriesForeign investigationCessna 208B · El Alto, BoliviaNTSB MIA06WA087Accident · 2 fatalForeign investigationPiper PA-34-200T · Antioquia, ColombiaNTSB DFW06WA099Accident · Serious injuriesForeign investigationBell 407 · Morelia, MexicoNTSB NYC06WA095Accident · Minor injuriesForeign investigationBell 206 · Propriano, FranceNTSB DEN06WA057Accident · 1 fatalForeign investigationHerde Lancair 360 · Bankstown, AustraliaNTSB MIA06WA076Accident · 4 fatalForeign investigationCessna R172K · Cambita Garabit, Dominican RepublicNTSB DFW06WA091Accident · 6 fatalForeign investigationCessna 206 · Medellin, ColombiaNTSB LAX06WA132Accident · 1 fatalForeign investigationCessna A188B · Narrandera, AustraliaNTSB DFW06WA090Accident · 2 fatalForeign investigationCessna 150 · San Luis Potosi, MexicoNTSB MIA06RA070Accident · 5 fatalForeign investigationCessna 208B · Cuenca, EcuadorNTSB DEN06WA053Accident · 1 fatalForeign investigationMooney M-20K · San Bartelome, SpainNTSB ANC06WA042Accident · 1 fatalForeign investigationMD Helicopter MD 600 · Zama City, CanadaNTSB DEN06WA052Accident · 1 fatalForeign investigationPiper PA-28-180 · Bonndorf, GermanyNTSB DFW06WA100Accident · No injuriesForeign investigationRockwell Sabreliner · Cochabamba, BoliviaNTSB SEA06WA063Accident · 1 fatalForeign investigationBeech C24R · Ribe, DenmarkNTSB DFW06WA080Accident · 2 fatalForeign investigationCessna 421C · Labiano, SpainNTSB CHI06WA097Accident · 1 fatalForeign investigationMooney M-20K · Sachsen, Germany