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 MIA06WA137Incident · No injuriesForeign investigationCirrus Design SR22 · Bull Bay, JamaicaNTSB DEN06WA133Accident · 1 fatalForeign investigationPiper PA-28-181 · Bad Schwartau, GermanyNTSB DCA06WA075Incident · No injuriesForeign investigationBoeing 777-200 · Brindisi, ItalyNTSB LAX06WA300Accident · Minor injuriesForeign investigationBoeing B75N1 · Canyonleigh,NSW, AustraliaNTSB DCA06WA073Incident · No injuriesForeign investigationBoeing 777 · Brisbane, AustraliaNTSB DCA06WA074Incident · No injuriesForeign investigationBoeing 767-300 · IcelandNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaNTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoNTSB DCA06WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesNTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaNTSB ENG06WA036Incident · No injuriesForeign investigationCessna 560 · Calgary, CanadaNTSB CHI06WA271Accident · No injuriesForeign investigationPiper PA-46-350P · Suwalki, PolandNTSB DCA06WA069Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandNTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaNTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoNTSB WAS06WA014Incident · No injuriesForeign investigationBoeing 727-277 · Lagos, NigeriaNTSB DEN06WA122Accident · No injuriesForeign investigationCessna C210P · Hoexter, GermanyNTSB DCA06WA070Incident · No injuriesForeign investigationBoeing B737-300 · Doha, QatarNTSB DEN06WA120Accident · 1 fatalForeign investigationBellanca 17-31 ATC · Neuwerk Island, GermanyNTSB DEN06WA121Accident · No injuriesForeign investigationPiper PA-23-160 · Neresheim, GermanyNTSB DEN07WA029Accident · No injuriesForeign investigationPiper PA-24-220T · Zee Am See, AustriaNTSB DEN06WA129Accident · No injuriesForeign investigationPiper PA-32R · Varberg, SwedenNTSB ANC06WA120Accident · 6 fatalForeign investigationCessna 337 · Ft. Good Hope, CanadaNTSB ANC06WA116Accident · No injuriesForeign investigationMooney M20E · Victoria, CanadaNTSB NYC06WA202Accident · 3 fatalForeign investigationLockheed L-100-30 · Piacenza, ItalyNTSB NYC06WA203Accident · No injuriesForeign investigationCirrus SR-22 · Ligure Sea, ItalyNTSB MIA06WA128Accident · 2 fatalForeign investigationCessna 207A · Puerto Ayacucho, VenezuelaNTSB LAX06FA258Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Saipan, SarkA loss of engine power during the initial climb due to fuel starvation resulting from the pilot's improper fuel selector valve position selection and his failure to select a tank containing an adequate fuel supply. Contributing to the accident was the high…NTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaNTSB ENG06WA030Incident · No injuriesForeign investigationAirbus A320 · Shenzhen, China, ChinaNTSB NYC06WA186Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Guipuzcoa, SpainNTSB ENG06RA025Incident · No injuriesForeign investigationCanadair CL600-2B19-200 · Barcelona, Spain, SpainNTSB ENG06WA033Incident · No injuriesForeign investigationAirbus Industrie A320 · Islamabad, PakistanNTSB DCA06WA056Incident · Minor injuriesForeign investigationBoeing B767-200 · Cancun, MexicoNTSB CHI06WA231Accident · No injuriesForeign investigationCirrus Design SR-22 · Mantena, BrazilNTSB NYC06WA182Accident · No injuriesForeign investigationPiper PA-46T · Debrecen, HungaryNTSB ENG06WA022Incident · No injuriesClass 5 · ForeignBoeing 747-200F · Amsterdam, NetherlandsOn July 16, 2006, at 1424 coordinated universal time, a Boeing 747-200F, N516MC, operated by Atlas Air, sufferend minor damage when the left main body gear tires burst during takeoff from runway 36L at Amsterdam/Schiphol Airport (EHAM). The airplane returned…NTSB CHI06WA192Accident · 4 fatalForeign investigationPiper PA-46-310P · Marina di Campo, ItalyNTSB ENG06WA027Accident · No injuriesForeign investigationBell 206L · Maria Lankowitz, Austria, AustriaNTSB DEN06WA102Accident · 1 fatalForeign investigationCessna T310R · Saint Tropez, FranceNTSB ENG07WA032Accident · Serious injuriesForeign investigationGrumman AA-5B · Skane County, SwedenNTSB DEN06WA098Accident · 3 fatalForeign investigationCessna 172N · El Rosario, SpainNTSB WAS06WA012Accident · 5 fatalForeign investigationLockheed 382 C130 · Kigoma, TanzaniaNTSB DFW06WA177Accident · 5 fatalForeign investigationCessna 182C · Tepic, MexicoNTSB DCA06RA055Accident · 124 fatalForeign investigationAirbus Industrie A310-300 · Irkutsk, RussiaNTSB DCA06RA053Accident · 6 fatalForeign investigationSikorsky S61N · Tenerife, SpainNTSB DCA06WA054Incident · No injuriesForeign investigationBoeing 737-300 · Stansted, United KingdomNTSB DCA06WA057Incident · Serious injuriesForeign investigationBoeing MD-81 · Toyota, JapanNTSB DFW08WA205Accident · 5 fatalForeign investigationCessna T210N · Poptun, GuatemalaNTSB WAS06WA011Accident · 3 fatalForeign investigationCessna 208B · Vilanculos, Mozambique