OpenAirDocs.org

NTSB investigations, 1987, Outside the U.S.

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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

19622026

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'
  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 DCA88RA019Accident · 1 fatalForeign investigationCessna 402 · St. Barthelemy, WNDec 27, 1987 · N8209QNTSB MIA88WA074Accident · No injuriesForeign investigationMitsubishi MU-2B-30 · San Salvador, El SalvadorDec 23, 1987 · N255C · Substantial damageNTSB MIA88WA086Accident · No injuriesForeign investigationBoeing 747-124F · Bogota, ColombiaDec 17, 1987 · HK290 · Substantial damageNTSB MIA88WA056Accident · 1 fatalForeign investigationCessna 402B · Cat Island, BahamasDec 5, 1987 · N422TA · DestroyedNTSB LAX88WA067Accident · No injuriesForeign investigationPiper PA46 · Guaymas, MexicoNov 27, 1987 · N4367K · DestroyedNTSB LAX88WA068Accident · Minor injuriesForeign investigationCessna 182 · Punta Pescadero, MexicoNov 26, 1987 · N313DF · Substantial damageNTSB 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…Nov 16, 1987 · N2484B · DestroyedNTSB DCA88RA002Incident · No injuriesForeign investigationMcdonnell Douglas DC-10-15 · Tijuana, MexicoNov 7, 1987 · N1003NNTSB LAX88WA031Accident · No injuriesForeign investigationCessna 421C · Wollongong, AustraliaOct 31, 1987 · N8410G · Substantial damageNTSB NYC87FA264Accident · Serious injuriesField investigationFinal reportLockheed L-1011 · Bermuda, BermudaEncounter with undetectable clear air turbulence.Sep 28, 1987 · N317EA · Minor damageNTSB MIA87RA261Accident · 1 fatalForeign investigationEmbraer EMB 110-P-2 · Freeport, BahamasSep 28, 1987 · N876ACNTSB DCA87RA047Incident · No injuriesForeign investigationBoeing B 767 200ER · Frankfurt, GermanyAug 16, 1987 · N332AANTSB MIA87WA225Incident · No injuriesForeign investigationGrumman G-73-T · Bimini, BahamasAug 14, 1987 · N2969 · No damageNTSB MIA87IA166Incident · No injuriesIncident investigationFinal reportBoeing 747-245F · Caracas, VenezuelaFlight experienced leakage of a five gallon container of glutaraldehyde listed by the shipper as a class 8 corrosive on the aircrafts upper deck enroute miami, Florida to Caracas, venezuela. The chemical was later found not to be corrosive and the aircraft…May 29, 1987 · N813FT · Minor damageNTSB 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…May 27, 1987 · N2652B · DestroyedNTSB LAX87WA216Accident · Minor injuriesForeign investigationPiper PA-30 · Mexicali, MexicoMay 24, 1987 · N7077Y · Substantial damageNTSB LAX87WA217Accident · No injuriesForeign investigationCessna 150G · Castillejos, PhilippinesMay 13, 1987 · N3180X · Substantial damageNTSB MIA87RA152Accident · 6 fatalForeign investigationCessna P206 S/N P206-0009 · St. Johns, CanadaMay 1, 1987 · N2509XNTSB DCA87RA002Accident · No injuriesForeign investigationBoeing 727-247 · Calgary, CanadaMar 13, 1987 · N2819WNTSB FTW87WA070Accident · 3 fatalForeign investigationCessna 175 · La Union Morale, MexicoFeb 20, 1987 · N7635M · DestroyedNTSB FTW87RA066Accident · 1 fatalForeign investigationBoeing 707-323B · Durango, MexicoFeb 14, 1987 · N712PCNTSB 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…Feb 7, 1987 · N6797G · Substantial damage