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.

NTSB DCA99WA080Incident · No injuriesForeign investigationBoeing 767 · Copenhagen, DenmarkAug 24, 1999 · OYKDN · Minor damageNTSB DCA99RA074Accident · 1 fatalForeign investigationMcDonnell Douglas MD-90 · Hualien, TaiwanAug 24, 1999 · B7873NTSB DCA99RA073Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Hong Kong, ChinaAug 23, 1999 · UNKNTSB DCA99WA091Accident · No injuriesForeign investigationHawker Siddeley 800XP · Istanbul, TürkiyeAug 21, 1999 · TCBHD · No damageNTSB NYC00WA172Accident · No injuriesForeign investigationLake LA-4-200 · Lake Puruvesi, FinlandAug 19, 1999 · N6187V · Substantial damageNTSB NYC99WA205Accident · No injuriesForeign investigationCessna 180 · Quebec, CanadaAug 18, 1999 · N4535B · Substantial damageNTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.Aug 11, 1999 · N64813 · DestroyedNTSB FTW99RA217Accident · 6 fatalForeign investigationCessna 414 · Monrovia, LiberiaAug 10, 1999 · N373BCNTSB DCA99WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaAug 8, 1999 · UNK · Substantial damageNTSB FTW99WA209Accident · 5 fatalForeign investigationPiper PA-32-260 · Guayaquil, EcuadorAug 3, 1999 · HCAKO · DestroyedNTSB DCA99WA070Accident · No injuriesForeign investigationEmbraer EMB-110 · FijiJul 29, 1999 · UNK · DestroyedNTSB IAD99RA057Accident · 16 fatalForeign investigationCessna 208B · Bluefields, NicaraguaJul 20, 1999 · YNCEDNTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaJul 15, 1999 · N2947K · DestroyedNTSB DCA00WA063Incident · No injuriesForeign investigationBoeing B-737 · Cuzco, PeruJul 12, 1999 · OB1724NTSB DCA99WA068Accident · 5 fatalForeign investigationBoeing 727-243F · Kathmandu, NepalJul 7, 1999 · VT-LCI · DestroyedNTSB DCA99WA075Accident · 2 fatalForeign investigationBeech 99 · Leige, BelgiumJun 30, 1999 · DIBEX · DestroyedNTSB DCA99WA066Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesJun 30, 1999 · N582FE · Substantial damageNTSB DCA99WA064Accident · No injuriesForeign investigationAirbus Industrie A310 · Manila, PhilippinesJun 28, 1999 · N420FE · Substantial damageNTSB MIA99WA198Accident · 2 fatalForeign investigationBeech T-34B Mentor · San Isidro, Dominican RepublicJun 25, 1999 · N1611 · DestroyedNTSB DCA99WA063Incident · No injuriesForeign investigationMcDonnell Douglas DC-10 · Pointe A Pitre, FranceJun 24, 1999 · N607GC · No damageNTSB NYC99WA206Accident · 4 fatalForeign investigationRobinson R22 · Grossenhain, GermanyJun 22, 1999 · N220WP · 2 aircraft · Substantial damageNTSB NYC99WA155Accident · No injuriesForeign investigationCessna A185F · Labrador, CanadaJun 22, 1999 · N185HC · Substantial damageNTSB CHI99WA194Accident · 2 fatalForeign investigationMaule M-5-220C · Lake St. John, CanadaJun 22, 1999 · N62041 · Substantial damageNTSB MIA99WA187Accident · 2 fatalForeign investigationCessna U206F · Ciudad Bolivar, VenezuelaJun 18, 1999 · YV239 · DestroyedNTSB MIA99WA176Accident · No injuriesForeign investigationCessna 210L · Gt. Harbour Cay, BahamasJun 11, 1999 · N1765X · DestroyedNTSB DCA99WA062Incident · No injuriesForeign investigationBoeing 757 · Tegucigalpa, HondurasJun 9, 1999 · N697AN · Minor damageNTSB DCA99WA061Accident · Minor injuriesForeign investigationBoeing 737-300 · Zhanjiang, ChinaJun 9, 1999 · B2525 · Substantial damageNTSB IAD99WA072Accident · No injuriesForeign investigationMooney M20 · FranceJun 5, 1999 · FGJGNNTSB NYC99WA121Accident · 2 fatalForeign investigationMitsubishi MU-2B-40 · Perry Sound, CanadaMay 25, 1999 · N701K · DestroyedNTSB FTW00RA093Accident · Serious injuriesForeign investigationBell 206L4 · Cuenca, EcuadorMay 17, 1999 · HCBYQNTSB SEA99WA057Accident · 2 fatalForeign investigationPiper PA-60-602P · Tambon Tha Chal, IndiaMay 3, 1999 · N602PK · DestroyedNTSB ANC99WA055Accident · Minor injuriesForeign investigationCessna 170B · Tsirku Glacier, CanadaApr 30, 1999 · N2599C · Substantial damageNTSB IAD99WA071Accident · No injuriesForeign investigationCessna 172M · Georgetown/Guy, GuyanaApr 24, 1999 · 8RGHA · DestroyedNTSB 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…Apr 23, 1999 · N719AS · Substantial damageNTSB FTW99RA122Accident · 3 fatalForeign investigationKawasaki BK-117B-1 · Keelung, TaiwanApr 21, 1999 · B5550NTSB DCA99RA056Accident · 3 fatalForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaApr 15, 1999 · HL737NTSB LAX99RA151Accident · 4 fatalForeign investigationBell 206B · 60 N. Jakarta, IndonesiaApr 14, 1999 · PKDBCNTSB DCA99RA057Accident · No injuriesForeign investigationLearjet 55 · FinlandApr 14, 1999 · UNKNTSB DCA99RA053Accident · 6 fatalForeign investigationBoeing 737-400 · Ceyhan Adana, TürkiyeApr 7, 1999 · TC-JEP · DestroyedNTSB FTW99WA109Accident · No injuriesForeign investigationBell UH1-B · Mexico City, MexicoApr 5, 1999 · N64CC · 2 aircraft · Substantial damageNTSB LAX99WA141Accident · 7 fatalForeign investigationBell 412 · Santan, IndonesiaApr 3, 1999 · PKHMV · DestroyedNTSB DCA99WA081Incident · No injuriesForeign investigationBoeing MD80/87 · Geneva, SwitzerlandMar 20, 1999 · ECGRL · Minor damageNTSB 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…Mar 15, 1999 · RA-25464 · DestroyedNTSB DCA99WA048Accident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Pohang, South KoreaMar 15, 1999 · HL757 · Substantial damageNTSB DCA99WA049Incident · No injuriesForeign investigationBoeing 727-200 · Calgary, CanadaMar 11, 1999 · N8873Z · Minor damageNTSB MIA99WA104Accident · No injuriesForeign investigationFokker F-27F · Quito, EcuadorMar 5, 1999 · HCBSL · Substantial damageNTSB DCA99WA047Accident · No injuriesForeign investigationBoeing 747-200F · Madras, IndiaMar 5, 1999 · UNK · DestroyedNTSB DCA99WA050Accident · No injuriesForeign investigationBoeing 737-228 · Biarritz, FranceMar 4, 1999 · FGBYA · Substantial damageNTSB IAD99WA033Accident · No injuriesForeign investigationRobinson R-44 · Sines, PortugalMar 2, 1999 · CS-HEI · Substantial damageNTSB DCA99WA042Accident · No injuriesForeign investigationLockheed L-188 · Shannon, IrelandMar 1, 1999 · N285F · Substantial damage