NTSB investigations, 2011, AL

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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

19622026
NTSB investigations, 2011, AL per year, 1962–2026: 2,501 cases
19621
19631
196461
196592
196670
196785
196868
196975
197089
197173
197276
197382
197467
197571
197677
197782
197872
197950
198050
198148
198261
198360
198441
198545
198648
198745
198836
198933
199032
199130
199240
199333
199427
199542
199632
199717
199827
199929
200017
200125
200227
200330
200427
200522
200624
200729
200828
200913
20108
201117
201225
201310
201424
201523
201612
201719
201820
201915
202017
202115
202221
202319
202411
202518
202617

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'
  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 ERA12CA096Accident · Serious injuriesData collectionFinal reportThompson Tommy W Loehle P5151 · Courtland, ALThe airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…Dec 4, 2011 · N212WE · Substantial damageNTSB 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 ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.Aug 20, 2011 · N2997G · Substantial damageNTSB ERA11CA441Accident · No injuriesData collectionFinal reportCessna 172K · Sylacauga, ALA stuck exhaust-valve on the number one cylinder which resulted in a loss of engine power.Aug 5, 2011 · N7214G · 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 ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…Jul 4, 2011 · N109DP · 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 ERA11CA353Accident · No injuriesData collectionFinal reportHead Balloons AX8-88 · Summerdale, ALThe balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.Jun 18, 2011 · N8190V · Substantial damageNTSB ERA11LA242Accident · No injuriesLimited investigationFinal reportWsk-Mielec AN-2 · Loxley, ALA loss of engine power due to internal failure.Apr 11, 2011 · N122AN · Substantial damageNTSB ERA11LA197Accident · No injuriesLimited investigationFinal reportBurr Andrew E Xiv Rotorway Exec 162F · Lincoln, ALA total loss of engine power during cruise flight for undetermined reasons.Mar 19, 2011 · N192AB · Substantial damageNTSB ERA11LA175Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Birmingham, ALA total loss of engine power for undetermined reasons.Mar 2, 2011 · N154MW · Substantial damageNTSB ERA11LA167Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Auburn, ALA loss of engine power due to an internal failure of the muffler that was not detected by maintenance personnel.Feb 27, 2011 · N3420U · Substantial damageNTSB ERA11LA135Accident · Serious injuriesLimited investigationFinal reportBelcher William B II Firestar · West Blocton, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Feb 6, 2011 · N43341 · Substantial damageNTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.Jan 26, 2011 · N9742J · Substantial damageNTSB ERA11CA123Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Jasper, ALThe pilot's loss of directional control on a wet runway during takeoff from a touch and go landing resulting in a runway excursion.Jan 24, 2011 · N1116C · 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