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 ENG06WA026Incident · No injuriesForeign investigationAirbus Industrie A320 · Dublin, IrelandNTSB DFW06WA082Accident · Serious injuriesForeign investigationCessna 208B · Arecuna, VenezuelaNTSB DFW06WA079Accident · Minor injuriesForeign investigationAmerican Champion 8KCAB · Banjul, GambiaNTSB DCA06WA027Incident · No injuriesForeign investigationBoeing MD-82 · Surabaya, IndonesiaNTSB DCA06WA028Incident · No injuriesForeign investigationBoeing 717-200 · Paraburdoo, AustraliaNTSB DFW06WA075Accident · 4 fatalForeign investigationBell 206B3 · Mutata, ColombiaNTSB LAX06WA121Accident · 4 fatalForeign investigationRobinson R44 · Gunpowder, AustraliaNTSB SEA06WA058Accident · 6 fatalForeign investigationCessna 501 · Sulaimaniya, IraqNTSB ENG06WA010Incident · No injuriesForeign investigationBoeing 737 · Sao Paulo, BrazilNTSB DFW06WA069Accident · 3 fatalForeign investigationCessna 172P · Samana, Dominican RepublicNTSB ENG06RA013Accident · No injuriesForeign investigationCessna 208 Caravan · Strahan, Tasmania, AustraliaNTSB LAX06WA100Accident · 3 fatalForeign investigationBell 206B III · Parkes, AustraliaNTSB ENG06WA009Incident · No injuriesForeign investigationBoeing 747 · Istanbul, TürkiyeNTSB SEA06WA050Accident · No injuriesForeign investigationRockwell Commander 114TC · Oxford, United KingdomNTSB LAX06WA095Accident · 3 fatalForeign investigationRobinson R-44 · Lorca, Murcia, SpainNTSB SEA06WA046Accident · 3 fatalForeign investigationCessna 208B · Port Alberni, CanadaNTSB DFW06WA086Accident · 1 fatalForeign investigationBrantly Helicopter B-2B · Googlong, NSW, AustraliaNTSB CHI06WA075Accident · No injuriesForeign investigationStarduster SA-100 · Old Hay, Kent, United KingdomNTSB ENG06WA012Incident · No injuriesForeign investigationSao Paulo, BrazilNTSB NYC07WA012Incident · No injuriesForeign investigationCessna 208B · Floro, NorwayNTSB LAX06WA093Accident · 2 fatalForeign investigationBeech 58 · McArthur Rive M, AustraliaNTSB DCA08WA013Incident · No injuriesForeign investigationBoeing MD-82 · Makassar, IndonesiaNTSB WAS06WA007Accident · 1 fatalForeign investigationRobinson R22 · Cape Point, South AfricaNTSB SEA06WA045Accident · 4 fatalForeign investigationEADS Socata TB-20 Trinidad · Bourdeau, FranceNTSB WAS06WA006Accident · 1 fatalForeign investigationRobinson R22 · Mariental, NamibiaNTSB ATL06WA036Accident · 2 fatalForeign investigationBeech D35 · Tierra Blanca, Costa RicaNTSB DFW06WA053Accident · Minor injuriesForeign investigationde Havilland DHC-6 · Puerto Jimenez, Costa RicaNTSB DFW06WA052Accident · 2 fatalForeign investigationBeech 95B55 · Piedras Negras, VenezuelaNTSB MIA06WA038Accident · 4 fatalForeign investigationCessna 172RG · Mendoza, ArgentinaNTSB NYC06WA052Accident · 3 fatalForeign investigationRaytheon HS-125-700 · Kharkiv, UkraineNTSB LAX06WA077Accident · 5 fatalForeign investigationCessna U206 · Brisbane, Australia