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.
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
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 DCA24WA029Incident · No injuriesClass 5 · ForeignBoeing 787 · Bogotá, ColombiaNTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNTSB GAA24WA306Accident · No injuriesClass 5 · ForeignRaytheon Hawker · Ibadan, NigeriaNTSB GAA24WA025Accident · 4 fatalClass 5 · ForeignCirrus SR20 · St. Andrä im Lunga, AustriaNTSB GAA24WA031AccidentClass 5 · ForeignLearjet 35 · Cuernavaca, MexicoNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionNTSB ENG24WA008Incident · No injuriesClass 3 · ForeignAirbus A321 · Islamabad, PakistanNTSB GAA24WA022Accident · 12 fatalClass 5 · ForeignCessna 208 · Rio Branco, BrazilNTSB GAA24WA021IncidentClass 5 · ForeignCessna 525 · Paris, FranceNTSB GAA24WA055AccidentClass 5 · ForeignRobinson R44 · Groenvlei, South AfricaNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaNTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaNTSB GAA24WA125Accident · No injuriesClass 5 · Foreignreims F406 · Farm Erindi, NamibiaNTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaNTSB DCA23WA480IncidentClass 5 · ForeignBoeing 737 · Stuttgart, GermanyNTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB GAA24WA030Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaNTSB GAA24WA019Accident · Serious injuriesClass 5 · ForeignCessna 208 · Barwon Heads Geelong, AustraliaNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaNTSB DCA24WA018Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Frankfurt am Main, GermanyNTSB DCA24WA014Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomNTSB DCA24WA013IncidentClass 5 · ForeignBoeing 737 · Stocksbridge, United KingdomNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceNTSB GAA24WA057AccidentClass 5 · ForeignPiper PA-31-350 · Sioux Lookout, CanadaNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainNTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoNTSB GAA24WA017Accident · No injuriesClass 5 · ForeignCessna 170B · Duxford, United KingdomNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaNTSB DCA24WA008IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaNTSB GAA24WA006Accident · 4 fatalClass 4 · ForeignCirrus SR22 · Canberra, AustraliaNTSB ENG24WA006Incident · No injuriesClass 5 · ForeignViking DHC-6-200 · Hulhulé Island, MaldivesNTSB GAA24WA012Accident · No injuriesClass 5 · ForeignCirrus SR22 · Dubai, United Arab EmiratesNTSB DCA24WA012Accident · No injuriesClass 5 · ForeignAirbus A321 · Essex, United KingdomNTSB DCA24WA009IncidentClass 5 · ForeignBoeing 737 · Marrakesh, MoroccoNTSB GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoNTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilNTSB GAA24WA003Accident · Serious injuriesClass 5 · ForeignCessna P210 · Venice, ItalyNTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkNTSB DCA24WA004OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, Germany