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.

NTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceMay 21, 2022 · F-HJLB · Substantial damageNTSB GAA22WA184AccidentClass 5 · ForeignRans S6-ES · Hampshire, United KingdomMay 17, 2022 · G-CCTV · Substantial damageNTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiMay 16, 2022 · HL9490NTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, CanadaApr 30, 2022 · C-GLKD · Substantial damageNTSB GAA22WA159Accident · 1 fatalClass 5 · ForeignCessna 172 · Coonagarabran, AustraliaApr 18, 2022 · VH-REU · Substantial damageNTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaApr 4, 2022 · VH-PRW · DestroyedNTSB GAA22WA201Accident · Serious injuriesClass 5 · ForeignBell 206L-1 · Cooma, AustraliaMar 11, 2022 · VH-BHFNTSB GAA22WA113Accident · 1 fatalClass 5 · ForeignCessna U206G · Norseman, AustraliaMar 3, 2022 · VH-JVR · DestroyedNTSB GAA22WA112Accident · 14 fatalClass 5 · ForeignCessna 208B · Comoros, ComorosFeb 26, 2022 · 5H-MZANTSB GAA22WA109Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Leongatha, AustraliaFeb 22, 2022 · VH-SEH · DestroyedNTSB GAA22WA102Accident · 1 fatalClass 5 · ForeignCessna FA150 · Utrera, SpainFeb 16, 2022 · D-EATUNTSB GAA22WA103AccidentClass 5 · ForeignGarlick UH1H · Devonport, AustraliaFeb 14, 2022 · VH-UHX · DestroyedNTSB GAA22WA095Accident · 2 fatalClass 5 · ForeignCessna 172 · Region de la Araucania, ChileFeb 4, 2022 · CC-AFA · DestroyedNTSB GAA22WA056Accident · 1 fatalClass 5 · ForeignAmateur Built D11 · South Mackay, AustraliaDec 24, 2021 · VH-WBL · Substantial damageNTSB GAA22WA052Accident · 1 fatalClass 5 · ForeignPiper 25-260 · Vereda Aparco, Ibague, ColombiaDec 18, 2021 · HK1405 · Substantial damageNTSB GAA22WA050Accident · 9 fatalClass 5 · ForeignGulfstream GIV · Santo Domingo, Dominican RepublicDec 15, 2021 · HI-1050 · DestroyedNTSB GAA22WA040AccidentClass 5 · ForeignAir Tractor AT-400 · Bulyeroi, AustraliaDec 4, 2021 · VH-ACQ · DestroyedNTSB GAA22WA038Accident · 2 fatalClass 5 · ForeignMurphy Rebel · Wasbush, CanadaDec 4, 2021 · C-GMSG · DestroyedNTSB DCA22WA034IncidentClass 5 · ForeignBoeing 737 · Maringá, BrazilNov 18, 2021 · PR-GXH · No damageNTSB GAA22WA012AccidentClass 5 · ForeignRobinson R44 · Buchen-Sturzenhardt, GermanyOct 17, 2021 · D-HALR · DestroyedNTSB GAA22WA089Accident · 8 fatalClass 4 · ForeignPilatus PC12 · San Donato, ItalyOct 3, 2021 · YR-PDV · DestroyedNTSB GAA22WA001Accident · 3 fatalClass 5 · ForeignRobinson R44 · Lytkarino, RussiaOct 3, 2021 · RA-04172 · Substantial damageNTSB GAA21WA250Accident · 1 fatalClass 5 · ForeignCessna T206 · La Pajarera, MexicoSep 30, 2021 · XB-ITG · Substantial damageNTSB GAA21WA225Accident · 1 fatalClass 5 · ForeignPiper J3C · Mauricie, CanadaSep 12, 2021 · C-FSVTNTSB GAA21WA180Accident · 2 fatalClass 5 · ForeignPiper PA28 · Contrada Coccaro Fasano, ItalyJul 20, 2021 · I-SVBA · Substantial damageNTSB GAA21WA210AccidentClass 5 · ForeignCessna 172 · Beirut, LebanonJul 8, 2021 · OD-AAB · DestroyedNTSB GAA21WA172Accident · 3 fatalClass 5 · ForeignDouglas DC3 · Restrepo, ColombiaJul 8, 2021 · HK-2820 · DestroyedNTSB GAA21WA167Accident · Minor injuriesClass 5 · ForeignCessna 152 · Lima, PeruJun 27, 2021 · OB-2171NTSB GAA21WA154Accident · Serious injuriesClass 5 · ForeignPiper PA-32-300 · Moorabbin Aerodrome, AustraliaJun 22, 2021 · VH-CWK · DestroyedNTSB GAA21WA145Accident · 1 fatalClass 5 · ForeignRobinson R44 · Eidanger, NorwayJun 17, 2021 · LN-OGT · Substantial damageNTSB DCA21WA159Accident · No injuriesClass 5 · ForeignBoeing 737 · Derbyshire, United KingdomJun 16, 2021 · EC-MIENTSB GAA21WA141Accident · No injuriesClass 5 · ForeignBell 407 · Siaya County, KenyaMay 30, 2021 · 5Y-PSM · Substantial damageNTSB GAA21WA130Accident · 1 fatalClass 5 · ForeignCessna 188A · Inmediaciones Municipio Paz de Ariporo, Casanare, ColombiaMay 30, 2021 · HK1477 · Substantial damageNTSB GAA21WA133Accident · 1 fatalClass 5 · ForeignRobinson R22 · Hay South, AustraliaMay 26, 2021 · VH-KLY · Substantial damageNTSB GAA21WA132AccidentClass 5 · ForeignCessna 210 · Itaituba, BrazilMay 6, 2021 · PR-FPR · DestroyedNTSB GAA21WA104Accident · 2 fatalClass 5 · ForeignRobinson R22 · Durban, South AfricaMay 3, 2021 · ZS-HBR · Substantial damageNTSB GAA21WA100Accident · 4 fatalClass 5 · ForeignBell 206 · Rio Bravo, GuatemalaMay 2, 2021 · TG-SEN · Substantial damageNTSB GAA21WA089Accident · 1 fatalClass 5 · ForeignVans RV7A · Columbia, AustraliaApr 22, 2021 · VH-XWI · DestroyedNTSB GAA21WA081Accident · 2 fatalClass 5 · ForeignCessna 172 · Canberra, AustraliaApr 13, 2021 · VH-DLA · DestroyedNTSB GAA21WA201AccidentClass 5 · ForeignRobinson R44 · Hertzog Ville, South AfricaApr 8, 2021 · ZS-RHD · Substantial damageNTSB GAA21WA059Accident · No injuriesClass 4 · ForeignBeech 200 · Nairobi, KenyaMar 26, 2021 · 5Y-NJS · DestroyedNTSB GAA21WA038Accident · 1 fatalClass 5 · ForeignRobinson R22 · Bollena, ItalyFeb 27, 2021 · I-D125 · Substantial damageNTSB GAA21WA048Accident · No injuriesClass 5 · ForeignRobinson R66 · Khvoyninsky District, RussiaFeb 23, 2021 · RA-06201 · Substantial damageNTSB DCA21WA086Accident · No injuriesClass 5 · ForeignBoeing 737 · Vijayawada, IndiaFeb 20, 2021 · VT-GHE · Substantial damageNTSB GAA21WA021AccidentClass 5 · ForeignRobinson R22 · Hughenden, AustraliaFeb 11, 2021 · VH-HKC · Substantial damageNTSB GAA21WA018Accident · 2 fatalClass 4 · ForeignBell 206B · Courchevel, FranceFeb 9, 2021 · F-HUBA · DestroyedNTSB GAA21WA015Accident · 1 fatalClass 5 · ForeignAir Tractor AT402 · Hoopstad, South AfricaJan 22, 2021 · ZS-TCJ · Substantial damageNTSB GAA21WA029Accident · 1 fatalClass 5 · ForeignBell 206 · Wolseley, South AfricaJan 19, 2021 · ZS-HUC · DestroyedNTSB ANC21WA011Accident · 4 fatalClass 5 · ForeignRobinson R44 · Eaglesham, CanadaJan 2, 2021 · C-FBGT · DestroyedNTSB DCA21WA063IncidentClass 5 · ForeignAirbus A319-115 · Bogata, ColombiaDec 31, 2020 · N557AV · Minor damage