NTSB investigations, 2014
21 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\") = 2014
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") = 2014 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 CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.NTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ERA15FA016Accident · 2 fatalField investigationFinal reportRockwell International 112 · Gainesville, GAThe partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.NTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…NTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.NTSB CEN14FA462Accident · 4 fatalField investigationFinal reportCessna 421C · Las Cruces, NMThe misfueling of the airplane with jet fuel instead of the required aviation fuel, and the resultant detonation and a total loss of engine power during initial climb. Contributing to the accident were the line service technician's inadvertent misfueling of…NTSB CEN14LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Natchez, LAThe loss of power due to the failure of the No. 2 exhaust valve and rocker boss during takeoff.NTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.NTSB CEN14FA399Accident · 1 fatalField investigationFinal reportZimmerman Breezy · Oshkosh, WIThe pilot’s failure to maintain airplane control during landing while the air traffic controller was simultaneously coordinating the landing of three airplanes on the same runway, which resulted in the airplane exiting the runway and impacting a parked ground…NTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.NTSB ERA14FA300Accident · 3 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Huntsville, ALThe flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…NTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…NTSB ERA14FA255Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Fountain, FLThe pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…NTSB CEN14LA239Accident · No injuriesLimited investigationFinal reportCessna 525C · Columbus, OHThe flight crew’s decision to attempt an engine start in conditions that exceeded the engine's maximum allowable ground start crosswind component limitation.NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…NTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…NTSB ERA14WA154Accident · 5 fatalForeign investigationBeech BE9L-C90 · Villavicenco, ColombiaOn March 12, 2014, about 1133 universal coordinated time, a Hawker Beechcraft BE9L- C90, Colombian registration HK4921, was destroyed by impact and a postcrash fire, in the vicinity of Villavicencia, Meta, Colombia. The Colombian commercial pilot and four…NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.NTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.