NTSB investigations, 2011, Outside the U.S.
4 cases where the sequence of events included Fire/smoke (non-impact).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 10 |
| 2014 | 9 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 9 |
| 2018 | 13 |
| 2019 | 18 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 10 |
| 2023 | 13 |
| 2024 | 12 |
| 2025 | 15 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2011
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '150' 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 year(c."eventDate") = 2011 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' 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 WPR11RA480Incident · No injuriesForeign investigationAirbus A319 · Hassi Messaoud, AlgeriaOn September 22, 2011, about 2300 Coordinated Universal Time (UTC), Air France flight 558, an Airbus A319, F-GRXN, declared an emergency during cruise flight following an indication of smoke in the lavatory. The crew and passengers were not injured, and the…NTSB DCA11WA090Incident · No injuriesForeign investigationBoeing 777 · Cairo, EgyptOn July 29, 2011, a Boeing B777-200, registration SU-GBP, operated by EgyptAir, experienced a fire in the right hand lower portion of the cockpit area, adjacent to the electronic flight bag and an electrical power panel. The aircraft was in the process of…NTSB DCA11RA087Accident · 2 fatalClass 5 · ForeignBoeing 747 · Jeju Island, South KoreaNTSB WPR11WA488Accident · No injuriesForeign investigationEurocopter BO105 · Tari, Papua New GuineaOn July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…