NTSB investigations, Outside the U.S.
183 cases where the defining event was Collision with terr/obj (non-CFIT).
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'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaNTSB GAA24WA099AccidentClass 5 · ForeignCessna 172 · Brownlow Hill, AustraliaNTSB GAA24WA080AccidentClass 5 · ForeignRobinson R44 · Santa Luzia, BrazilNTSB GAA24WA060Accident · No injuriesClass 5 · ForeignRobinson R44 · Arthur's Pass, New ZealandNTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaNTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanNTSB GAA23WA269Accident · No injuriesClass 5 · ForeignBell 204B · Aratula, AustraliaNTSB GAA23WA264Accident · No injuriesClass 5 · ForeignCessna 170 · Doutor Ulysses, BrazilNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaNTSB DCA23WA393Incident · No injuriesClass 5 · ForeignBoeing 767 · São Tomé, São Tomé & PríncipeNTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoNTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaNTSB GAA23WA193Accident · 1 fatalClass 5 · ForeignBell 47 · Sainte-Marthe, FranceNTSB GAA23WA180Accident · 1 fatalClass 5 · ForeignRobinson R22 · Buchanan, AustraliaNTSB GAA23WA274Accident · 1 fatalClass 5 · ForeignDB 6R · Ombersley Court, Worcestershire, United KingdomNTSB GAA23WA183Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Ngodwana, South AfricaNTSB GAA23WA149Accident · No injuriesClass 5 · ForeignRobinson R66 · Konakovo, RussiaNTSB GAA23WA150Accident · Serious injuriesClass 5 · ForeignCessna 182 · Langley Regional, CanadaNTSB GAA23WA141Accident · 1 fatalClass 5 · ForeignRobinson R44 · Middlemount, AustraliaNTSB GAA23WA108Accident · 1 fatalClass 5 · ForeignGrumman G164 · Comercial, UruguayNTSB GAA23WA090Accident · 2 fatalClass 5 · ForeignAir Tractor AT402 · Fazenda Juína, Juína - MT, BrazilNTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilNTSB GAA23WA065Accident · Minor injuriesClass 4 · ForeignPiper PA32R · Isla Martin Garcia, ArgentinaNTSB GAA23WA056Accident · 1 fatalClass 5 · ForeignAero Eli Servizi Yoyo · Lesna Jania, PolandNTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaNTSB GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNTSB GAA23WA032Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Richmond, AustraliaNTSB DCA23WA062Occurrence · No injuriesClass 5 · ForeignDouglas DC3 · Balikpapan, IndonesiaNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainNTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaNTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaNTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaNTSB GAA22WA261Accident · 1 fatalClass 5 · ForeignRobinson R22 · Albosaggia, ItalyNTSB GAA22WA245Accident · 1 fatalClass 5 · ForeignPiper PA11 · Aeródromo Chañar Ladeado, Santa Fe, ArgentinaNTSB GAA22WA313Accident · Serious injuriesClass 5 · ForeignPiper PA25 · Trinidad, ColombiaNTSB GAA22WA235Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Tiquisate, GuatemalaNTSB GAA22WA234Accident · No injuriesClass 5 · ForeignCessna F150 · Gödöllo, HungaryNTSB GAA22WA232Accident · 1 fatalClass 5 · ForeignChampion 7GCBC · Trois Riviere, Quebec, CanadaNTSB GAA22WA299Accident · 2 fatalClass 5 · ForeignBlackshape BS115 · Zwarte Meer, NetherlandsNTSB GAA22WA204Accident · 1 fatalClass 5 · ForeignBell 412 · Timika, IndonesiaNTSB GAA22WA199Accident · 3 fatalClass 5 · ForeignBell 206 · Currais Novos, Brazil