NTSB investigations, Outside the U.S.
11 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1984 | 3 |
|---|---|
| 1988 | 2 |
| 1991 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
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 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"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."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
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 SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn 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 DCA02MA042Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Subic Bay, PhilippinesThe 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 CHI01IA102Incident · No injuriesIncident investigationFinal reportFokker F28 MK 0100 · Montreal, Canadathe 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 LAX00TA051Accident · No injuriesFinal reportde Havilland DHC-7 · Kwajalein, Marshall IslandsThe failure of the flight crew to properly execute the emergency landing gear extension procedure in response to a landing gear unsafe cockpit indication.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 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 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 LAX84FA415Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-300 · Tau, AntarcticaThe 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 MIA84IA172Incident · No injuriesIncident investigationFinal reportBoeing 727-35 · Bahamas, BahamasWhile 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 MIA84IA140Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · MartiniqueWhile 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…