Fatal NTSB investigations, 2011, AL

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
Fatal NTSB investigations, 2011, AL per year, 1964–2026: 432 cases
19645
196511
196610
196711
19686
19697
19704
197111
197215
197318
197411
197512
19769
19779
197810
19797
19805
19818
19828
19838
198412
19857
198612
19876
19888
198910
199011
19918
199212
19936
199410
19957
19968
19974
19985
19997
20002
20019
20024
20038
20044
20055
20065
20077
20085
20095
20103
20115
20125
20133
20144
20152
20163
20172
20185
20194
20208
20212
20223
20235
20243
20251
20262

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\") = 2011
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.Sep 18, 2011 · N3577F · Substantial damageNTSB ERA11FA391Accident · 7 fatalField investigationFinal reportCessna 421C · Demopolis, ALThe pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…Jul 9, 2011 · N692TT · Substantial damageNTSB ERA11FA360Accident · 1 fatalField investigationFinal reportClabaugh Robert R Barracuda · Andalusia, ALThe pilot did not maintain airspeed while maneuvering on approach for landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Jun 26, 2011 · N289DH · Substantial damageNTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.Jun 18, 2011 · N1803T · Substantial damageNTSB ERA11FA107Accident · 1 fatalField investigationFinal reportBeech 58P · Birmingham, ALThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.Jan 6, 2011 · N48TS · Substantial damage