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, newest first
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'
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' 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 DCA99WA080Incident · No injuriesForeign investigationBoeing 767 · Copenhagen, DenmarkNTSB DCA99RA074Accident · 1 fatalForeign investigationMcDonnell Douglas MD-90 · Hualien, TaiwanNTSB DCA99RA073Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Hong Kong, ChinaNTSB DCA99WA091Accident · No injuriesForeign investigationHawker Siddeley 800XP · Istanbul, TürkiyeNTSB NYC00WA172Accident · No injuriesForeign investigationLake LA-4-200 · Lake Puruvesi, FinlandNTSB NYC99WA205Accident · No injuriesForeign investigationCessna 180 · Quebec, CanadaNTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB FTW99RA217Accident · 6 fatalForeign investigationCessna 414 · Monrovia, LiberiaNTSB DCA99WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB FTW99WA209Accident · 5 fatalForeign investigationPiper PA-32-260 · Guayaquil, EcuadorNTSB DCA99WA070Accident · No injuriesForeign investigationEmbraer EMB-110 · FijiNTSB IAD99RA057Accident · 16 fatalForeign investigationCessna 208B · Bluefields, NicaraguaNTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaNTSB DCA00WA063Incident · No injuriesForeign investigationBoeing B-737 · Cuzco, PeruNTSB DCA99WA068Accident · 5 fatalForeign investigationBoeing 727-243F · Kathmandu, NepalNTSB DCA99WA075Accident · 2 fatalForeign investigationBeech 99 · Leige, BelgiumNTSB DCA99WA066Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesNTSB DCA99WA064Accident · No injuriesForeign investigationAirbus Industrie A310 · Manila, PhilippinesNTSB MIA99WA198Accident · 2 fatalForeign investigationBeech T-34B Mentor · San Isidro, Dominican RepublicNTSB DCA99WA063Incident · No injuriesForeign investigationMcDonnell Douglas DC-10 · Pointe A Pitre, FranceNTSB NYC99WA206Accident · 4 fatalForeign investigationRobinson R22 · Grossenhain, GermanyNTSB NYC99WA155Accident · No injuriesForeign investigationCessna A185F · Labrador, CanadaNTSB CHI99WA194Accident · 2 fatalForeign investigationMaule M-5-220C · Lake St. John, CanadaNTSB MIA99WA187Accident · 2 fatalForeign investigationCessna U206F · Ciudad Bolivar, VenezuelaNTSB MIA99WA176Accident · No injuriesForeign investigationCessna 210L · Gt. Harbour Cay, BahamasNTSB DCA99WA062Incident · No injuriesForeign investigationBoeing 757 · Tegucigalpa, HondurasNTSB DCA99WA061Accident · Minor injuriesForeign investigationBoeing 737-300 · Zhanjiang, ChinaNTSB IAD99WA072Accident · No injuriesForeign investigationMooney M20 · FranceNTSB NYC99WA121Accident · 2 fatalForeign investigationMitsubishi MU-2B-40 · Perry Sound, CanadaNTSB FTW00RA093Accident · Serious injuriesForeign investigationBell 206L4 · Cuenca, EcuadorNTSB SEA99WA057Accident · 2 fatalForeign investigationPiper PA-60-602P · Tambon Tha Chal, IndiaNTSB ANC99WA055Accident · Minor injuriesForeign investigationCessna 170B · Tsirku Glacier, CanadaNTSB IAD99WA071Accident · No injuriesForeign investigationCessna 172M · Georgetown/Guy, GuyanaNTSB 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 FTW99RA122Accident · 3 fatalForeign investigationKawasaki BK-117B-1 · Keelung, TaiwanNTSB DCA99RA056Accident · 3 fatalForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB LAX99RA151Accident · 4 fatalForeign investigationBell 206B · 60 N. Jakarta, IndonesiaNTSB DCA99RA057Accident · No injuriesForeign investigationLearjet 55 · FinlandNTSB DCA99RA053Accident · 6 fatalForeign investigationBoeing 737-400 · Ceyhan Adana, TürkiyeNTSB FTW99WA109Accident · No injuriesForeign investigationBell UH1-B · Mexico City, MexicoNTSB LAX99WA141Accident · 7 fatalForeign investigationBell 412 · Santan, IndonesiaNTSB DCA99WA081Incident · No injuriesForeign investigationBoeing MD80/87 · Geneva, SwitzerlandNTSB 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…NTSB DCA99WA048Accident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Pohang, South KoreaNTSB DCA99WA049Incident · No injuriesForeign investigationBoeing 727-200 · Calgary, CanadaNTSB MIA99WA104Accident · No injuriesForeign investigationFokker F-27F · Quito, EcuadorNTSB DCA99WA047Accident · No injuriesForeign investigationBoeing 747-200F · Madras, IndiaNTSB DCA99WA050Accident · No injuriesForeign investigationBoeing 737-228 · Biarritz, FranceNTSB IAD99WA033Accident · No injuriesForeign investigationRobinson R-44 · Sines, PortugalNTSB DCA99WA042Accident · No injuriesForeign investigationLockheed L-188 · Shannon, Ireland