Final NTSB investigations, 1999, 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 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\") = 1999
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") = 1999 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 LAX00TA051Accident · No injuriesFinal reportde Havilland DHC-7 · Kwajalein, Marshall IslandsThe failure of the flight crew to properly execute the emergency landing gear extension procedure in response to a landing gear unsafe cockpit indication.NTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB LAX99LA163Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Fitiuta, Australiathe mechanical separation of the left engine beta control linkage during landing rollout, which resulted in asymmetrical decelerative action and the pilot's subsequent inability to maintain directional control. The separation of the linkage was due to the…NTSB IAD99GA036Accident · 13 fatalFinal reportMil MI-8MTV-1 · Hinche, HaitiThe flightcrew's inability to maintain visual contact with mountainous terrain in night, instrument meteorological conditions. Contributing to the accident was a lack of preparation and support for difficult flight conditions, including lack of coordination…