Ongoing NTSB investigations, Outside the U.S.
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year
| 2023 | 1 |
|---|---|
| 2025 | 3 |
| 2026 | 1 |
Latest cases
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 c.\"eventCountry\" <> 'USA'
AND c.\"completionStatus\" = 'Ongoing'
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 c."eventCountry" <> 'USA' AND c."completionStatus" = 'Ongoing' 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 DCA26FA274Accident · Serious injuriesClass 3 · FieldPreliminary reportBoeing 737 · Polykastro, GreeceMalta Air, doing business as Ryanair flight 1879, a Boeing 737-8AS, registration 9H-QEU, experienced a No. 2 (right) engine fan-blade-out (FBO) failure during climb out from the Thessaloniki International Airport (SKG), Thessaloniki, Greece. Engine fragments…NTSB DCA25LA233Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 747-47UF · Guayaquil, EcuadorNTSB ENG25LA038IncidentClass 3 · LimitedPreliminary reportBoeing 777 · Beijing, ChinaOn May 26, 2025, at approximately 0925 UTC, a Boeing 777-200, registration N793UA, operated as United Airlines flight 889, executed a rejected takeoff at Beijing Capital International Airport when the crew heard a loud bang and followed by a No. 2 (right)…NTSB DCA25LA093Accident · Serious injuriesClass 3 · LimitedPreliminary reportBoeing 787-8 · Dabouzra, Côte d’IvoireOn January 24, 2025, about 00:31 universal coordinated time (UTC), United Airlines (UAL) flight 613, a Boeing 787-8, experienced altitude excursions during cruise flight while transitioning over Cote d’Ivoire airspace at 36,000 feet. Of the 11 crew members…NTSB ENG24LA009IncidentClass 3 · LimitedPreliminary reportAirbus A319 · Schiphol, NetherlandsOn November 10, 2023 at 0713 UTC, a Lufthansa Airbus A319, registration D-AIBG, experienced the loss of both electrical generators during approach to Amsterdam Airport Schiphol, Netherlands. The airplane’s ram air turbine deployed automatically. The airplane…