Final NTSB investigations, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 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 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 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…NTSB ATL99LA026Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · La Tortue, HaitiInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).NTSB ATL98IA024Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Montego Bay, JamaicaThe pilot's improper recovery from a bounced landing, compounded by the automatic deployment of the ground spoilers on main wheel spin-up, resulting in a pitch angle beyond the tail strike pitch angle of the airplane, which led to the tail contacting the…NTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.NTSB LAX97LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · Aguiguan Island, MauritiusThe pilot's failure to maintain runway alignment while landing on an undeveloped private dirt strip.NTSB LAX97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tinian, Sarkthe pilot's improper takeoff abort. Contributing to the accident was the pilot's improper preflight planning and preparation.NTSB LAX97LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Rota, Sarkthe unauthorized use of automobile gasoline which led to the loss of engine power due to fuel vapor generation.NTSB CHI97IA096Incident · No injuriesIncident investigationFinal reportBoeing 747-269B · Manaus, Brazilthe pilot-in-command's (non-flying pilot) improper flare. Related factors were inadequate crew/coordination, haze and sunglare.NTSB DCA97LA027Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600R · St John Antigua, Antigua & BarbudaThe captain failed to establish and maintain a stabilized approach (or perform a go-around), and applied excessive pitch rotation during the subsequent recovery from a bounced landing, resulting in a tail strike. A factor contributing to the accident was the…NTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.NTSB IAD96LA128Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Amos, Canadathe pilot's inadvertent wheels down landing on water. A related factor was his diverted attention during the landing.NTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.NTSB MIA96IA039Incident · No injuriesIncident investigationFinal reportBoeing 747-212B · Amsterdam, NetherlandsThe failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.NTSB LAX95LA190Accident · 3 fatalLimited investigationFinal reportStol UC-1 · Saipan, Sarkan inflight collision with the ocean for undetermined reasons.NTSB MIA94T#A04Accident · No injuriesClass 3Final reportCASA 212-A · Canuto, St. LuciaNTSB LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.NTSB ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…NTSB FTW93TA#06Accident · No injuriesFinal reportCessna CE-550 · Comayagua, HondurasNTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.NTSB LAX93LA019Accident · 3 fatalLimited investigationFinal reportCessna 310R · Saipan, MauritiusThe pilot not following wake turbulence (votex) avoidance procedures, which are detailed in FAA publications, resulting in the airplane encountering wake turbulence. Factors in this accident were: 1) the pilot's inability to control the airplane after…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB LAX91LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-602P · Pago Pago, AntarcticaThe mechanical failure of the airplane's nose wheel/gear steering system. A contributing factor was the pilot's inability to maintain directional control following the loss of steering effectiveness.NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB LAX91LA147Accident · 1 fatalLimited investigationFinal reportde Havilland DHC6-300 · Nuuuli, AntarcticaThe inadequate lighting of the gate at the terminal and inadequate training of the security guard by company personnel. Contributing to this accident was a dark night condition.NTSB MIA91IA051Incident · No injuriesIncident investigationFinal reportDassault-Breguet HU-25/A · Bimini, BahamasInadequate visual lookout by the pilots of both aircraft, resulted in their failure to see-and-avoid the other aircraft.NTSB LAX91LA013Accident · 2 fatalLimited investigationFinal reportBell 47G5 · AntarcticaThe pilot's failure to maintain on adequate altitude while maneuvering above the water.NTSB LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…NTSB LAX89LA129Accident · No injuriesLimited investigationFinal reportHughes 269C · Saipan, SarkFailure of maintenance personnel to assure the helicopter was serviced with the proper grade of fuel. A factor realated to the accident was: the lack of a suitable landing area, which resulted in having to ditch the helicopter in the water.NTSB NYC89LA072Accident · Serious injuriesLimited investigationFinal reportBoeing B-747-123 · Bridgetown, BahamasThe failure of the flight attendant to notice that the elevator was not present as she entered the elevator shaft and prior to closing the door.NTSB NYC88IA246Incident · Minor injuriesIncident investigationFinal reportBoeing 747-100 · Georgetown, GuyanaIncident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter.NTSB MIA88FA260Accident · 6 fatalField investigationFinal reportPartenavia P-68C · Duncan Town, BahamasThe acft crashed in the ocean nr Duncan Town, Bahamas. The wx according to witnesses was VMC. The flt had been airborne enroute from nassau for about 1 hr and 20 minutes. Witnesses on a nearby boat said the acft was flying in a slight left bank when the left…NTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.NTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…NTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.NTSB DCA88IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Nr Tokyo, JapanUnited flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it…NTSB MIA88LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Saba Island, NTThe loss of power for undetermined reasons.NTSB 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 NYC87FA264Accident · Serious injuriesField investigationFinal reportLockheed L-1011 · Bermuda, BermudaEncounter with undetectable clear air turbulence.NTSB 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…NTSB 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 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…NTSB DCA86AA017Accident · 2 fatalFinal reportCessna P210N · Keflavik, IcelandAt 1146 gmt, N4906K deptd on a 5 hr flt to narssarssuaq, greenland with an estd 7 hrs of fuel. When the plt rprtd 60 mi sw of greenland, the destn vis was below IFR min & the ceiling at the altn arpt was below the mda. The plt elected to cont to reykjavik,…NTSB MIA85LA209Accident · 4 fatalLimited investigationFinal reportPiper PA-32R-301 · Bahamas, BahamasThe acft failed to arrive at it's intended destination on a flt from nassau, Bahamas to opa locka arpt, miami, FL. The acft was reported missing by the miami fss. The U.S. Coast guard initiated a search on 07-12-85 at about 1831 EDT & search was suspended on…NTSB FTW85IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-200B · Mexico City, MexicoDuring the initial climb after takeoff a 27 foot tall light pole was struck by the right main landing gear 1,677 feet from the end of the rwy. Acft gross weight dictated a 5 deg flap takeoff and company performance data authorized departure on either rwy 5R…NTSB NYC85LA013Accident · 1 fatalLimited investigationFinal reportDe Havilland DHC-4 · Sable Island Ns, CanadaPlt ditched acft in atlantic ocean following a loss of power due to fuel exhaustion. Co-pilot stated they were aware of bad wx along the route but the plt was anxious to get to their destination. Headwinds encountered en route were stronger then expected.…NTSB MIA84LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bimini, BahamasThe plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island.