NTSB investigations, 2010, Outside the U.S.
6 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\") = 2010
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") = 2010 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 DCA11WA031Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn November 9, 2010, a Boeing 747-400, German registration D-ABVT, operated by Lufthansa, experienced a fire in the APU compartment. There were no injuries, and minor damage to the airplane. This incident is being investigated by the BFU of Germany.…NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesNTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.NTSB DCA10WA041Incident · No injuriesForeign investigationBoeing 747 · Paris, FranceOn March 18, 2010, at 0700 local time (0600 UTC), a Thai Airways International Boeing 747-4D7, registered in Thailand as HS-TGL, experienced a fire in its avionics bay while parked at Charles de Gaulle International Airport (CDG), Paris, France. No injuries…NTSB DCA10WA019Incident · Minor injuriesForeign investigationBoeing 737 · Hahn, GermanyOn January 4, 2010, at 0940 UTC, a Boeing 737-800, Irish registration EI-DAK, operated by Ryan Air, experienced fire and smoke in a ground power unit connector prior to takeoff at Hahn, Germany. The aircraft had minor damage and 5 of the 6 crew members…