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.
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
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 GAA25WA092Accident · Minor injuriesClass 5 · ForeignMD Helicopter 500 · Uppsala, SwedenNTSB GAA25WA028Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · Langtora, SwedenNTSB GAA25WA030Accident · 3 fatalClass 5 · ForeignCessna 172 · Murska Sobota, SloveniaNTSB DCA25WA049IncidentClass 5 · ForeignAirbus A320-214 · Bogota, ColombiaNTSB GAA25WA027Accident · Serious injuriesClass 5 · ForeignPiper PA-23-250 · Freeport, BahamasNTSB 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.NTSB GAA25WA029Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · SãO Paulo, BrazilNTSB GAA25WA289Accident · No injuriesClass 4 · ForeignBombardier N/A · Hannover, GermanyNTSB DCA25WA043OccurrenceClass 5 · ForeignBoeing 737 · Brisbaine, AustraliaNTSB GAA25WA022Accident · Serious injuriesClass 5 · ForeignBell 205 · Región del Maule, ChileNTSB GAA25WA023Accident · 2 fatalClass 4 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB DCA25WA121Incident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNTSB DCA25WA036IncidentClass 5 · ForeignBoeing 787 · Casablanca, MoroccoNTSB DCA25WA032IncidentClass 5 · ForeignBoeing 727 · Bogotá, ColombiaNTSB DCA25WA033Incident · No injuriesClass 5 · ForeignAirbus A320-214 · Monteria, ColombiaNTSB DCA25WA031Accident · No injuriesClass 3 · ForeignBoeing 737 · Sao Paulo, BrazilNTSB ENG25WA005IncidentClass 5 · ForeignBoeing 737 · Sydney, Australia, AustraliaNTSB ENG25WA003Incident · No injuriesClass 5 · ForeignAirbus A320 · Barcelona, SpainNTSB GAA25WA026Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Puebla, MexicoNTSB GAA25WA062AccidentClass 5 · ForeignShort Bros SD3-60 · Roadtown, British Virgin IslandsNTSB DCA25WA027Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Nefaar, IndonesiaNTSB DCA25WA087IncidentClass 5 · ForeignSikorsky S-92A · Hammerfest, NorwayNTSB ENG25WA008Incident · No injuriesClass 5 · ForeignPilatus PC12 · Geneva, SwitzerlandNTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.NTSB DCA25WA035IncidentClass 5 · ForeignBoeing 787 · Jeddah, Saudi ArabiaNTSB GAA25WA017Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Zona-Bananera-Magdalena, ColombiaNTSB DCA25WA024Incident · No injuriesClass 5 · ForeignBoeing 747 · Incheon, South KoreaNTSB DCA25WA018Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Alicante, SpainNTSB GAA25WA176Accident · 1 fatalClass 5 · ForeignSocata TB 20 · Vaduleni, MoldovaNTSB GAA25WA016Accident · Serious injuriesClass 4 · ForeignCessna 340A · Saint-Denis-de-l'Hôtel, FranceNTSB DCA25WA019IncidentClass 5 · ForeignAirbus A330 · International Waters, South AfricaNTSB GAA25WA025Accident · 1 fatalClass 5 · ForeignCessna 182P · The Oaks, AustraliaNTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaNTSB ENG25WA022IncidentClass 5 · ForeignBoeing 737 · Karachi, PakistanNTSB DCA25WA014IncidentClass 5 · ForeignBoeing 787 · Doha, QatarNTSB GAA25WA075OccurrenceClass 5 · ForeignBeech 200 · Pillanesburg, South AfricaNTSB GAA25WA015Accident · 8 fatalClass 5 · ForeignSikorsky S76 · Port Harcourt, NigeriaNTSB GAA25WA024Accident · 1 fatalClass 5 · ForeignCessna 150L · Bacchus Marsh, AustraliaNTSB ENG25WA002OccurrenceClass 5 · ForeignTextron Beech G58 · Okayama, JapanNTSB DCA25WA017Incident · No injuriesClass 5 · ForeignBoeing 737 · Tenerife, SpainNTSB DCA25WA016IncidentClass 4 · ForeignBoeing 787 · Guangzhou, ChinaNTSB DCA25WA028Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Ndiass, SenegalNTSB DCA25WA010AccidentClass 5 · ForeignAirbus A321 · Dublin, IrelandNTSB GAA25WA012Accident · 2 fatalClass 5 · ForeignNorth American SNJ-3 · Räyskälä, FinlandNTSB DCA25WA011Incident · No injuriesClass 4 · ForeignBoeing 737 · Deli Serdang, IndonesiaNTSB ENG25WA007IncidentClass 5 · ForeignBombardier Global 7500 · Amsterdam, NetherlandsNTSB DCA25WA005IncidentClass 5 · ForeignBoeing 777 · Rawalpindi, PakistanNTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilNTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainNTSB GAA25WA013Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Ouro Preto - Minas Gerais, Brazil