NTSB investigations, 2023, 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\") = 2023
    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.

NTSB DCA24WA029Incident · No injuriesClass 5 · ForeignBoeing 787 · Bogotá, ColombiaNov 6, 2023 · PH-BKA · No damageNTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNov 5, 2023 · N150SF · Substantial damageNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNov 5, 2023 · G-UZLO, · No damageNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNov 4, 2023 · VH-HPY · DestroyedNTSB GAA24WA306Accident · No injuriesClass 5 · ForeignRaytheon Hawker · Ibadan, NigeriaNov 3, 2023 · 5N-AMM · Substantial damageNTSB GAA24WA025Accident · 4 fatalClass 5 · ForeignCirrus SR20 · St. Andrä im Lunga, AustriaNov 2, 2023 · D-ESFB · DestroyedNTSB GAA24WA031AccidentClass 5 · ForeignLearjet 35 · Cuernavaca, MexicoNov 1, 2023 · XA-IRE · DestroyedNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionOct 31, 2023 · F-HLOU · DestroyedNTSB ENG24WA008Incident · No injuriesClass 3 · ForeignAirbus A321 · Islamabad, PakistanOct 30, 2023 · AP-BOD · No damageNTSB GAA24WA022Accident · 12 fatalClass 5 · ForeignCessna 208 · Rio Branco, BrazilOct 29, 2023 · PT-MEE · DestroyedNTSB GAA24WA021IncidentClass 5 · ForeignCessna 525 · Paris, FranceOct 28, 2023 · F-HMSG · Minor damageNTSB GAA24WA055AccidentClass 5 · ForeignRobinson R44 · Groenvlei, South AfricaOct 26, 2023 · ZT-RBU · Substantial damageNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaOct 26, 2023 · VH-KFT · DestroyedNTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaOct 26, 2023 · C-FLSX · No damageNTSB GAA24WA125Accident · No injuriesClass 5 · Foreignreims F406 · Farm Erindi, NamibiaOct 24, 2023 · V5-WAI · Substantial damageNTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaOct 24, 2023 · C-GXHJ · Substantial damageNTSB DCA23WA480IncidentClass 5 · ForeignBoeing 737 · Stuttgart, GermanyOct 23, 2023 · TC-SOR · 2 aircraft · No damageNTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 22, 2023 · VT-RBT · Substantial damageNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaOct 21, 2023 · ZS-JKE · Substantial damageNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damageNTSB GAA24WA030Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 19, 2023 · VT-RBC · DestroyedNTSB GAA24WA019Accident · Serious injuriesClass 5 · ForeignCessna 208 · Barwon Heads Geelong, AustraliaOct 19, 2023 · VH-UMV · Substantial damageNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaOct 19, 2023 · HK-2465G · Substantial damageNTSB DCA24WA018Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Frankfurt am Main, GermanyOct 18, 2023 · D-ABKM · No damageNTSB DCA24WA014Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomOct 18, 2023 · G-JMCZNTSB DCA24WA013IncidentClass 5 · ForeignBoeing 737 · Stocksbridge, United KingdomOct 17, 2023 · G-TAWDNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · DestroyedNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceOct 15, 2023 · F-HSLE · DestroyedNTSB GAA24WA057AccidentClass 5 · ForeignPiper PA-31-350 · Sioux Lookout, CanadaOct 14, 2023 · C-GQXD · No damageNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceOct 12, 2023 · F-GIKS · DestroyedNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyOct 10, 2023 · T7-HZM · DestroyedNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainOct 10, 2023 · CO493 · Substantial damageNTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoOct 9, 2023 · N6518P · Substantial damageNTSB GAA24WA017Accident · No injuriesClass 5 · ForeignCessna 170B · Duxford, United KingdomOct 9, 2023 · N2366D · Substantial damageNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaOct 8, 2023 · VH-RSBNTSB DCA24WA008IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoOct 8, 2023 · CN-ROU · Minor damageNTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanOct 7, 2023 · JA4083 · Substantial damageNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaOct 6, 2023 · C-GTYH · DestroyedNTSB GAA24WA006Accident · 4 fatalClass 4 · ForeignCirrus SR22 · Canberra, AustraliaOct 6, 2023 · VH-MSF · DestroyedNTSB ENG24WA006Incident · No injuriesClass 5 · ForeignViking DHC-6-200 · Hulhulé Island, MaldivesOct 6, 2023 · 8Q-RAL · No damageNTSB GAA24WA012Accident · No injuriesClass 5 · ForeignCirrus SR22 · Dubai, United Arab EmiratesOct 5, 2023 · A6-CTG · Substantial damageNTSB DCA24WA012Accident · No injuriesClass 5 · ForeignAirbus A321 · Essex, United KingdomOct 5, 2023 · G-OATW · Substantial damageNTSB DCA24WA009IncidentClass 5 · ForeignBoeing 737 · Marrakesh, MoroccoOct 5, 2023 · CN-RGH · No damageNTSB GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoOct 4, 2023 · XA-JAONTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilOct 4, 2023 · PS-JCO · DestroyedNTSB GAA24WA003Accident · Serious injuriesClass 5 · ForeignCessna P210 · Venice, ItalyOct 4, 2023 · OK-TKN · Substantial damageNTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkOct 4, 2023 · OY-HFS · Substantial damageNTSB DCA24WA004OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomOct 4, 2023 · EI-EGDNTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilOct 2, 2023 · PR-XIC · Substantial damageNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanySep 30, 2023 · D-EDDH