Fatal NTSB investigations, 1987, 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 | 1 |
|---|---|
| 1964 | 20 |
| 1965 | 18 |
| 1966 | 15 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 14 |
| 1971 | 11 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 11 |
| 1975 | 11 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 11 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 24 |
| 1996 | 37 |
| 1997 | 37 |
| 1998 | 43 |
| 1999 | 53 |
| 2000 | 77 |
| 2001 | 66 |
| 2002 | 59 |
| 2003 | 71 |
| 2004 | 75 |
| 2005 | 97 |
| 2006 | 89 |
| 2007 | 87 |
| 2008 | 90 |
| 2009 | 90 |
| 2010 | 98 |
| 2011 | 120 |
| 2012 | 119 |
| 2013 | 124 |
| 2014 | 107 |
| 2015 | 130 |
| 2016 | 131 |
| 2017 | 133 |
| 2018 | 137 |
| 2019 | 140 |
| 2020 | 91 |
| 2021 | 107 |
| 2022 | 125 |
| 2023 | 98 |
| 2024 | 110 |
| 2025 | 109 |
| 2026 | 109 |
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\") = 1987
AND c.\"eventCountry\" <> 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1987 AND c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 DCA88RA019Accident · 1 fatalForeign investigationCessna 402 · St. Barthelemy, WNNTSB MIA88WA056Accident · 1 fatalForeign investigationCessna 402B · Cat Island, BahamasNTSB LAX88FA045Accident · 2 fatalField investigationFinal reportCessna 441 · Mexicali, MexicoA Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…NTSB MIA87RA261Accident · 1 fatalForeign investigationEmbraer EMB 110-P-2 · Freeport, BahamasNTSB MIA87LA164Accident · 1 fatalLimited investigationFinal reportCessna 402C · Missing Acft, BahamasOn 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been…NTSB MIA87RA152Accident · 6 fatalForeign investigationCessna P206 S/N P206-0009 · St. Johns, CanadaNTSB FTW87WA070Accident · 3 fatalForeign investigationCessna 175 · La Union Morale, MexicoNTSB FTW87RA066Accident · 1 fatalForeign investigationBoeing 707-323B · Durango, MexicoNTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…