# NTSB investigations, Outside the U.S.: Airframe/component/system failure/malfunction NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. ## Latest cases - [NTSB SEA04IA010](https://openairdocs.org/ntsb/SEA04IA010.md): Boeing 747-100 · Lyon, France · Incident · No injuries · Incident investigation · Final report · Oct 2, 2003 · N479EV · Minor damage > An undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile. - [NTSB DCA02MA042](https://openairdocs.org/ntsb/DCA02MA042.md): McDonnell Douglas MD-11F · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 2, 2002 · N601FE · Substantial damage > The failure of the lower outboard nut and bolt assembly of the left inboard flap's outboard hinge that resulted from stress corrosion cracking and fatigue. Factors contributing to the accident were the inadequate materials specification of the bolt, and… - [NTSB CHI01IA102](https://openairdocs.org/ntsb/CHI01IA102.md): Fokker F28 MK 0100 · Montreal, Canada · Incident · No injuries · Incident investigation · Final report · Mar 6, 2001 · N1426A · Minor damage > the inaccurate aircraft deicing service the ground personnel performed alowing fluid injestion and the auxiliary power unit's turbine failure while standing. A factor was the auxiliary power unit's overspeed. - [NTSB LAX00TA051](https://openairdocs.org/ntsb/LAX00TA051.md): de Havilland DHC-7 · Kwajalein, Marshall Islands · Accident · No injuries · Final report · Nov 27, 1999 · N273EP · Substantial damage > The failure of the flight crew to properly execute the emergency landing gear extension procedure in response to a landing gear unsafe cockpit indication. - [NTSB LAX91LA398](https://openairdocs.org/ntsb/LAX91LA398.md): Piper PA-60-602P · Pago Pago, Antarctica · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1991 · VHUYX · Substantial damage > The 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 LAX91LA172](https://openairdocs.org/ntsb/LAX91LA172.md): Hughes 369C · Papua, Papua New Guinea · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1991 · N9227F · Destroyed > The loss of control of the helicopter due to a restriction of the cyclic control system. - [NTSB MIA88FA260](https://openairdocs.org/ntsb/MIA88FA260.md): Partenavia P-68C · Duncan Town, Bahamas · Accident · 6 fatal · Field investigation · Final report · Aug 19, 1988 · N39272 · Destroyed > The 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 DCA88IA056](https://openairdocs.org/ntsb/DCA88IA056.md): Boeing 747-123 · Nr Tokyo, Japan · Incident · No injuries · Incident investigation · Final report · May 2, 1988 · N157UA · Minor damage > United 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 LAX84FA415](https://openairdocs.org/ntsb/LAX84FA415.md): de Havilland DHC-6-300 · Tau, Antarctica · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1984 · N43SP · Substantial damage > The acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company… - [NTSB MIA84IA172](https://openairdocs.org/ntsb/MIA84IA172.md): Boeing 727-35 · Bahamas, Bahamas · Incident · No injuries · Incident investigation · Final report · May 24, 1984 · N4620 · No damage > While climbing thru FL 240, the aircrew noted that the #1 eng fire warning light illuminated. They secured the eng in accordance with the eng fire checklist procedure, then diverted for an unscheduled landing at miami, FL. An investigation revealed that the… - [NTSB MIA84IA140](https://openairdocs.org/ntsb/MIA84IA140.md): Boeing 747-121 · Martinique · Incident · No injuries · Incident investigation · Final report · Apr 14, 1984 · N751PA · Minor damage > While climbing through FL200 crew experienced a loss of #4 hydraulic system pressure, illumination of the red 'gear door' and 'left wing door open' lights, a medium freq vibration and heard a loud rushing sound. Flt diverted to miami, FL, where landing was… ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?occurrence=130&state=OF --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.