NTSB investigations, Outside the U.S.
10 cases where NTSB found Action.
Cases per year
| 2009 | 3 |
|---|---|
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2022 | 1 |
| 2025 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020410'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020410')) 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 DCA25WA122Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Olympic Dam, AustraliaNTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB ERA13LA380Accident · Minor injuriesLimited investigationFinal reportPiper PA46R-350T · Cat Cay, BahamasThe pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…NTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…NTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB WPR10CA077Accident · No injuriesData collectionFinal reportPilatus Britten-Norman BN-2B-26 · Pago Pago, AntarcticaThe pilot's action to maneuver the airplane to avoid a collision with a flock of birds while on final approach, resulting in a hard landing. Contributing to the accident were the birds.NTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.NTSB ERA09WA335Accident · 1 fatalForeign investigationPiper Aerostar 6 · Minga Guazu, ParaguayOn June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…