Fatal NTSB investigations, 2011
18 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 19 |
| 2010 | 24 |
| 2011 | 18 |
| 2012 | 16 |
| 2013 | 11 |
| 2014 | 20 |
| 2015 | 13 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 10 |
| 2021 | 7 |
| 2022 | 10 |
| 2023 | 12 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 4 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' 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 WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.NTSB ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…NTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.NTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.NTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.NTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…NTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB WPR11FA120Accident · 1 fatalField investigationFinal reportAeronca O-58C · San Luis Obispo, CAThe pilot’s delay in using carburetor heat, which resulted in a loss of engine power due to an encounter with carburetor icing conditions.