NTSB investigations, 2024, 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\") = 2024
    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 GAA25WA092Accident · Minor injuriesClass 5 · ForeignMD Helicopter 500 · Uppsala, SwedenNov 18, 2024 · SE-JVM · Substantial damageNTSB GAA25WA028Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · Langtora, SwedenNov 18, 2024 · SE-JVM · Substantial damageNTSB GAA25WA030Accident · 3 fatalClass 5 · ForeignCessna 172 · Murska Sobota, SloveniaNov 17, 2024 · S5-DLM · DestroyedNTSB DCA25WA049IncidentClass 5 · ForeignAirbus A320-214 · Bogota, ColombiaNov 16, 2024 · N411AV · No damageNTSB GAA25WA027Accident · Serious injuriesClass 5 · ForeignPiper PA-23-250 · Freeport, BahamasNov 15, 2024 · N91119 · Substantial damageNTSB DCA25LA044Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Tokyo, JapanAn encounter with turbulence while in cruise flight, resulting in serious injuries to two flight attendants.Nov 15, 2024 · N833AA · No damageNTSB GAA25WA029Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · SãO Paulo, BrazilNov 14, 2024 · PP-PLR · Substantial damageNTSB GAA25WA289Accident · No injuriesClass 4 · ForeignBombardier N/A · Hannover, GermanyNov 13, 2024 · VT-TUS · No damageNTSB DCA25WA043OccurrenceClass 5 · ForeignBoeing 737 · Brisbaine, AustraliaNov 13, 2024 · VH-VXC · No damageNTSB GAA25WA022Accident · Serious injuriesClass 5 · ForeignBell 205 · Región del Maule, ChileNov 12, 2024 · CC-ATFNTSB GAA25WA023Accident · 2 fatalClass 4 · ForeignCessna 172 · Fujairah, United Arab EmiratesNov 11, 2024 · A6-HSS · DestroyedNTSB DCA25WA121Incident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNov 11, 2024 · EI-IJL · 2 aircraft · No damageNTSB DCA25WA036IncidentClass 5 · ForeignBoeing 787 · Casablanca, MoroccoNov 11, 2024 · CN-RGB · Minor damageNTSB DCA25WA032IncidentClass 5 · ForeignBoeing 727 · Bogotá, ColombiaNov 11, 2024 · HK5216 · Minor damageNTSB DCA25WA033Incident · No injuriesClass 5 · ForeignAirbus A320-214 · Monteria, ColombiaNov 9, 2024 · N957AV · No damageNTSB DCA25WA031Accident · No injuriesClass 3 · ForeignBoeing 737 · Sao Paulo, BrazilNov 9, 2024 · PS-TLB · Substantial damageNTSB ENG25WA005IncidentClass 5 · ForeignBoeing 737 · Sydney, Australia, AustraliaNov 8, 2024 · VH-VYH · Minor damageNTSB ENG25WA003Incident · No injuriesClass 5 · ForeignAirbus A320 · Barcelona, SpainNov 8, 2024 · EC-MBS · No damageNTSB GAA25WA026Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Puebla, MexicoNov 7, 2024 · XB-FVF · Substantial damageNTSB GAA25WA062AccidentClass 5 · ForeignShort Bros SD3-60 · Roadtown, British Virgin IslandsNov 6, 2024 · N915GDNTSB DCA25WA027Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Nefaar, IndonesiaNov 5, 2024 · PK-YSC · No damageNTSB DCA25WA087IncidentClass 5 · ForeignSikorsky S-92A · Hammerfest, NorwayNov 4, 2024 · LN-ONYNTSB ENG25WA008Incident · No injuriesClass 5 · ForeignPilatus PC12 · Geneva, SwitzerlandNov 3, 2024 · 9H-EHA · No damageNTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.Nov 3, 2024 · N651UA · No damageNTSB DCA25WA035IncidentClass 5 · ForeignBoeing 787 · Jeddah, Saudi ArabiaNov 2, 2024 · F-OLRC · No damageNTSB GAA25WA017Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Zona-Bananera-Magdalena, ColombiaOct 29, 2024 · HK5177 · Substantial damageNTSB DCA25WA024Incident · No injuriesClass 5 · ForeignBoeing 747 · Incheon, South KoreaOct 28, 2024 · AZG129 · Minor damageNTSB DCA25WA018Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Alicante, SpainOct 28, 2024 · EI-HAY · No damageNTSB GAA25WA176Accident · 1 fatalClass 5 · ForeignSocata TB 20 · Vaduleni, MoldovaOct 27, 2024 · D-EMRT · DestroyedNTSB GAA25WA016Accident · Serious injuriesClass 4 · ForeignCessna 340A · Saint-Denis-de-l'Hôtel, FranceOct 27, 2024 · N38CM · DestroyedNTSB DCA25WA019IncidentClass 5 · ForeignAirbus A330 · International Waters, South AfricaOct 27, 2024 · ZS-SXJ · No damageNTSB GAA25WA025Accident · 1 fatalClass 5 · ForeignCessna 182P · The Oaks, AustraliaOct 26, 2024 · VH-APN · DestroyedNTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaOct 26, 2024 · VH-OHU · Substantial damageNTSB ENG25WA022IncidentClass 5 · ForeignBoeing 737 · Karachi, PakistanOct 25, 2024 · AP-BNA · Minor damageNTSB DCA25WA014IncidentClass 5 · ForeignBoeing 787 · Doha, QatarOct 25, 2024 · A7-BCV · Minor damageNTSB GAA25WA075OccurrenceClass 5 · ForeignBeech 200 · Pillanesburg, South AfricaOct 24, 2024 · SZ-SSPNTSB GAA25WA015Accident · 8 fatalClass 5 · ForeignSikorsky S76 · Port Harcourt, NigeriaOct 24, 2024 · 5N-BQG · Substantial damageNTSB GAA25WA024Accident · 1 fatalClass 5 · ForeignCessna 150L · Bacchus Marsh, AustraliaOct 22, 2024 · VH-EYU · Substantial damageNTSB ENG25WA002OccurrenceClass 5 · ForeignTextron Beech G58 · Okayama, JapanOct 22, 2024 · JA60AZ · Substantial damageNTSB DCA25WA017Incident · No injuriesClass 5 · ForeignBoeing 737 · Tenerife, SpainOct 21, 2024 · EI-DYD · No damageNTSB DCA25WA016IncidentClass 4 · ForeignBoeing 787 · Guangzhou, ChinaOct 21, 2024 · B-1243 · Minor damageNTSB DCA25WA028Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Ndiass, SenegalOct 19, 2024 · N199DN · No damageNTSB DCA25WA010AccidentClass 5 · ForeignAirbus A321 · Dublin, IrelandOct 18, 2024 · TC-LTL · Substantial damageNTSB GAA25WA012Accident · 2 fatalClass 5 · ForeignNorth American SNJ-3 · Räyskälä, FinlandOct 16, 2024 · OH-NAT · DestroyedNTSB DCA25WA011Incident · No injuriesClass 4 · ForeignBoeing 737 · Deli Serdang, IndonesiaOct 16, 2024 · PK-GMP · Minor damageNTSB ENG25WA007IncidentClass 5 · ForeignBombardier Global 7500 · Amsterdam, NetherlandsOct 15, 2024 · 9H-VISTA · Minor damageNTSB DCA25WA005IncidentClass 5 · ForeignBoeing 777 · Rawalpindi, PakistanOct 14, 2024 · HZAK21 · No damageNTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilOct 12, 2024 · PT-FEL · Substantial damageNTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainOct 12, 2024 · 9H-QBL · 2 aircraft · No damageNTSB GAA25WA013Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Ouro Preto - Minas Gerais, BrazilOct 11, 2024 · PS-SLR · Destroyed