NTSB investigations, Outside the U.S.
19 cases where the sequence of events included Fuel exhaustion.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 4 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '192' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '192' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA26WA003IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB GAA25WA027Accident · Serious injuriesClass 5 · ForeignPiper PA-23-250 · Freeport, BahamasNTSB GAA24WA285Accident · 2 fatalClass 4 · ForeignPiper PA-23-250 · Nassau, BahamasNTSB GAA24WA289Accident · Serious injuriesClass 4 · ForeignCessna 210K · Colmar, FranceNTSB GAA24WA118AccidentClass 5 · ForeignAero Commander 500-S · Bathurst, AustraliaNTSB GAA23WA252Accident · No injuriesClass 5 · ForeignPiper PA-32-301 · Marsh Harbor, BahamasNTSB DCA23WA429IncidentClass 4 · ForeignBoeing 737 · Palma de Mallorca, SpainNTSB GAA22WA074AccidentClass 5 · ForeignCessna 177 · Gauteng Province, South AfricaNTSB CEN18WA394Accident · No injuriesForeign investigationPiper PA28 · Décines, FranceOn August 2, 2018, about 1930 UTC, a Piper PA-28-181 airplane, French registration F-GKEC, sustained a loss of engine power while on approach to the Lyon-Bron Airport (LFLY), near Décines, France. The two occupants onboard sustained no injury. The airplane…NTSB ERA18WA052Accident · Serious injuriesForeign investigationBeech B200 · Pucallpa, PeruThe government of Peru has notified the NTSB of an accident involving a Beech B200C airplane that occurred on October 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB DCA17RA031Accident · No injuriesForeign investigationBAE AVRO146RJ · Medellin, ColombiaThe El Grupo de Investigacon de Accidentes (GRIAA) of Colombia has notified the NTSB of an accident involving a BAE AVRO146RJ that occurred on November 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA investigation under…NTSB ERA17WA059Accident · 4 fatalForeign investigationEmbraer EMB710 · Novo Progresso, BrazilOn November 24, 2016, about 2040 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NCJ, was substantially damaged when it impacted terrain on approach to an unregistered landing strip in a quarry near Novo Progresso, State of Para,…NTSB DCA17WA032Accident · No injuriesForeign investigationCessna 172 · Brits, North West Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving ZS-MPF, a Cessna 172M airplane that occurred on October 07, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB ERA14LA424Accident · 2 fatalLimited investigationFinal reportSocata TBM 700 · Caribbean Sea, A1The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…NTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB CEN13WA477Accident · Minor injuriesForeign investigationBeech 100 · Saint-Mathieu-de-Beloeil, CanadaOn June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),…NTSB ENG12WA037Accident · 2 fatalForeign investigationPilatus PC6 - B2H4 · Muaritan, IndonesiaOn April 25, 2012, at 09:29 UTC time, a Pilatus PC-6/B2-H4, PK-VVQ, operated by Susi Air, impacted terrain near Muaritan after the pilot reported a fuel system problem.The accident is being investigated by the Indonesian National Transportation Safety…NTSB ERA12LA268Accident · No injuriesLimited investigationFinal reportHawker Beechcraft C90GTX · Caribbean Sea, A1A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…NTSB DEN08WA052Accident · 2 fatalForeign investigationBeech 58P · Cherbourg, France