NTSB investigations, 2011
15 cases where the sequence of events included Fire/smoke (post-impact).
Cases per year
| 2008 | 43 |
|---|---|
| 2009 | 35 |
| 2010 | 12 |
| 2011 | 15 |
| 2012 | 17 |
| 2013 | 19 |
| 2014 | 21 |
| 2015 | 32 |
| 2016 | 24 |
| 2017 | 21 |
| 2018 | 25 |
| 2019 | 17 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 17 |
| 2023 | 17 |
| 2024 | 16 |
| 2025 | 8 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '170' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '170' 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 CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.NTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.NTSB ERA11CA294Accident · Minor injuriesData collectionFinal reportPiper PA-23-250 · Clayton, NYThe pilot's failure to obtain a proper touchdown point while landing with a gusting tailwind.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.NTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.