NTSB investigations, 2010
12 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\") = 2010
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") = 2010 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 CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…NTSB ERA10LA488Accident · 1 fatalLimited investigationFinal reportSchulman Mosquito XEL · Halifax, MAThe pilot's loss of control while hovering. Contributing to the accident was the pilot’s limited experience operating the helicopter make and model.NTSB CEN10LA442Accident · 1 fatalLimited investigationFinal reportLunceford Sparrowhawk II · Tell City, INThe pilot's loss of control of the gyroplane for undetermined reasons.NTSB CEN10LA422Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · McCook, NEThe pilot's inadequate visual lookout during taxi, which resulted in a collision with a parked airplane.NTSB ERA10LA297Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Rockohoma, NYThe pilot's inadequate preflight inspection which resulted in a total loss of engine power during the initial climb due to fuel contamination.NTSB CEN10FA291Accident · 2 fatalField investigationFinal reportBell 222 · Midlothian, TXThe fracture of a swashplate drive pin as a result of hydrogen embrittlement due to an unknown source, which resulted in an in-flight breakup of the main rotor system during cruise flight.NTSB CEN10LA255Accident · Minor injuriesLimited investigationFinal reportSupinski Mark R Supinski Mustang II · Peyton, COThe pilot’s failure to maintain control of the airplane during landing. Contributing to the accident was the pilot’s lack of experience flying tailwheel configured airplanes.NTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.NTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.