Final NTSB investigations, 2010, Outside the U.S.
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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
| 1962 | 9 |
|---|---|
| 1963 | 3 |
| 1964 | 108 |
| 1965 | 99 |
| 1966 | 106 |
| 1967 | 101 |
| 1968 | 64 |
| 1969 | 63 |
| 1970 | 70 |
| 1971 | 56 |
| 1972 | 79 |
| 1973 | 66 |
| 1974 | 65 |
| 1975 | 58 |
| 1976 | 16 |
| 1977 | 24 |
| 1978 | 36 |
| 1979 | 14 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 5 |
| 1984 | 5 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 8 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 10 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 6 |
| 2009 | 11 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 7 |
| 2025 | 2 |
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 year(c.\"eventDate\") = 2010
AND c.\"eventCountry\" <> 'USA'
AND c.\"completionStatus\" = 'Completed'
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") = 2010 AND c."eventCountry" <> 'USA' AND c."completionStatus" = 'Completed' 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 WPR11LA071Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Pago Pago, AntarcticaThe airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.NTSB ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.NTSB DCA10FA064Accident · Serious injuriesField investigationFinal reportBoeing 777 · Southern Tip of Greenland, DenmarkAn inadvertent encounter with unforecast turbulence in cruise flight.