NTSB investigations, 2026, 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\") = 2026
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") = 2026 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 GAA26WA323Incident · No injuriesClass 5 · ForeignBAE Jetstream 3100 · Maiquetía, VenezuelaNTSB DCA26WA367Incident · No injuriesClass 5 · ForeignAirbus A321-271NX · Guayaquil, EcuadorNTSB GAA26WA330Accident · 2 fatalClass 5 · ForeignComp Air 7SL · Primavera do Leste, BrazilNTSB GAA26WA325Accident · 2 fatalForeign investigationCessna 172 · Kisbey, CanadaNTSB ENG26WA044Incident · No injuriesClass 5 · ForeignAirbus A320 · Zapote del Valle, MexicoNTSB DCA26WA375IncidentClass 5 · ForeignBoeing 777 · Schiphol, NetherlandsNTSB DCA26WA371Incident · No injuriesClass 5 · ForeignBoeing 787 · Pacific Ocean, VietnamNTSB DCA26WA365Incident · No injuriesClass 5 · ForeignBoeing 737 · Comalapa, El SalvadorNTSB DCA26WA363Accident · No injuriesClass 5 · ForeignBoeing 737 · Kindu, Congo - KinshasaNTSB GAA26WA320Accident · 3 fatalClass 5 · ForeignCessna F172 · Fronderath, GermanyNTSB GAA26WA310Accident · No injuriesClass 5 · ForeignPiper PA17 · Viseu, PortugalNTSB DCA26WA364Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Ezeiza, ArgentinaNTSB GAA26WA315Accident · No injuriesClass 5 · ForeignPiper PA32RT · Pulcallpa, PeruNTSB GAA26WA313Accident · Serious injuriesClass 5 · ForeignCessna 550 · Parelhas, BrazilNTSB GAA26WA311Accident · 5 fatalForeign investigationCessna T206 · Tatama Massif, ColombiaNTSB ENG26WA043Incident · No injuriesClass 5 · ForeignAirbus A321-271N · Parque Industrial Mazatlán, MexicoNTSB GAA26WA322Accident · 3 fatalClass 4 · ForeignCessna 402 · Agua Boa, BrazilNTSB GAA26WA308Accident · No injuriesClass 5 · ForeignCessna 152 · Mapitac, PhilippinesNTSB DCA26WA362Incident · No injuriesClass 5 · ForeignBoeing 737 · Tiouilit, MauritaniaNTSB GAA26WA321Accident · No injuriesClass 5 · ForeignTextron C680A · Misrata, LibyaNTSB GAA26WA305Accident · Serious injuriesClass 5 · ForeignCessna 172 · Midrand, South AfricaNTSB GAA26WA309Incident · No injuriesClass 5 · ForeignBell 412 · Ciudad del Carmen, MexicoNTSB GAA26WA306Accident · No injuriesClass 5 · ForeignPiper PA28 · Mossel Bay, South AfricaNTSB GAA26WA302Accident · 1 fatalClass 5 · ForeignCanadian Home Rotors Safari · Eyrewell, New ZealandNTSB GAA26WA300Accident · 5 fatalClass 5 · ForeignBolkow BO105 · Long Lellang, MalaysiaNTSB DCA26WA353AccidentClass 5 · ForeignDouglas DC8 · Kinshasa, Congo - KinshasaNTSB GAA26WA314Accident · Serious injuriesClass 5 · ForeignCessna 185 · Torbole, ItalyNTSB GAA26WA301Accident · 2 fatalClass 5 · ForeignBeech A36 · Archerfield, AustraliaNTSB GAA26WA297Occurrence · 4 fatalClass 3 · ForeignPiper PA-34-200T · Andros, BahamasNTSB DCA26WA355Accident · No injuriesClass 3 · ForeignBoeing 767-338 · Guatemala City, GuatemalaNTSB GAA26WA317Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Calgary, CanadaNTSB DCA26WA376IncidentClass 5 · ForeignBoeing 737 · La Chinita, VenezuelaNTSB ENG27WA003IncidentForeign investigationAirbus A330 · Sainte-Marie, RéunionNTSB DCA26WA349Incident · No injuriesClass 5 · ForeignBoeing 747 · Sharjah, United Arab EmiratesNTSB DCA26WA345IncidentClass 5 · ForeignBoeing 787 · Singapore, SingaporeNTSB GAA26WA312Accident · 2 fatalClass 5 · ForeignTecnam P2006T · Kampur, IndiaNTSB GAA26WA307Accident · No injuriesClass 5 · ForeignBeech C90 · Belo Horizonte, BrazilNTSB GAA26WA303Accident · No injuriesClass 5 · ForeignBeech G58 · Parana, BrazilNTSB GAA26WA296Accident · No injuriesClass 5 · ForeignCessna 152 · Ratmalana, Sri LankaNTSB GAA26WA295Accident · 1 fatalClass 5 · ForeignBeech 58 · Groote Eylandt, AustraliaNTSB DCA26WA343IncidentForeign investigationAirbus A320 · Mascot, AustraliaNTSB DCA26WA338Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Hongseong, South KoreaNTSB GAA26WA292Accident · 1 fatalClass 5 · ForeignBeech 200 · Prince George, CanadaNTSB GAA26WA288Accident · No injuriesForeign investigationCessna P206 · Playa Muerto, PanamaNTSB DCA26WA325Occurrence · No injuriesForeign investigationBoeing 737 · Chisinau, MoldovaNTSB GAA26WA286Incident · No injuriesClass 5 · ForeignGuimbal Cabri · Oxford, United KingdomNTSB GAA26WA285Accident · 7 fatalClass 5 · ForeignEurocopter EC130 · Ewaso Nyiro, KenyaNTSB ENG26WA039OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoNTSB GAA26WA283Accident · 3 fatalClass 5 · ForeignBell 206 · Exambela, GreeceNTSB DCA26WA344IncidentForeign investigationBoeing 737 · Mascot, Australia