Fatal NTSB investigations, 2012, GA

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, 2012, GA per year, 1964–2026: 759 cases
19646
196512
196611
196715
196819
196920
197024
197121
197225
197318
197417
197511
197620
197721
197817
197914
198019
198114
198219
198317
198415
198512
198612
198712
19887
198916
199012
199113
199210
199315
19947
199512
199610
199711
19987
19999
200010
200112
200213
200316
200411
20056
200611
200710
20087
20099
20108
201110
201212
20136
20149
20158
20167
20177
20189
20198
20207
202111
20228
202310
20246
20253
20265

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\") = 2012
    AND c.\"eventStateOrRegion\" = 'GA' 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 ERA13LA093Accident · 1 fatalLimited investigationFinal reportRussom Roy G Hummel H5 · Calhoun, GAThe pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.Dec 18, 2012 · N156FH · Substantial damageNTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.Dec 11, 2012 · N840DS · Substantial damageNTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.Nov 18, 2012 · N78304 · Substantial damageNTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.Nov 4, 2012 · N368PD · Substantial damageNTSB ERA12FA561Accident · 2 fatalField investigationFinal reportHall Don H RV-7 · Cumming, GAThe pilot’s failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.Sep 13, 2012 · N517DG · Substantial damageNTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.Aug 18, 2012 · N149AM · Substantial damageNTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.Jul 20, 2012 · N25UA · Substantial damageNTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…Jun 30, 2012 · N33CG · Substantial damageNTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…Jun 8, 2012 · N1481 · Substantial damageNTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…May 26, 2012 · N56FP · Substantial damageNTSB ERA12LA231Accident · 1 fatalLimited investigationFinal reportFirefly Balloons Firefly 8 · Fitzgerald, GAThe pilot's intentional flight into adverse weather. Contributing to the accident was the pilot's failure to obtain a weather briefing and his failure to follow the balloon manufacturer's published emergency procedure for weather deterioration during flight.Mar 16, 2012 · N14643 · Substantial damageNTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…Jan 8, 2012 · N4626 · Destroyed