Final NTSB investigations, 2003, Outside the U.S.
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2003
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") = 2003 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 MIA04FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing, BahamasUndetermined.NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.NTSB MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…NTSB ANC03GA023Accident · Serious injuriesFinal reportBell 212 · McMurdo Station, AYThe pilot's continued operation of the helicopter with an unstable external load, which resulted in damage to the cargo hook assembly, adjacent throttle controls, and subsequent loss of engine power, precipitating an emergency descent and impact with terrain.…