NTSB investigations, 2011

6 cases where NTSB found Total experience.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 126 cases
200814
200913
20106
20116
201210
201313
20147
20159
20165
20175
20187
201910
20204
20213
20227
20233
20244

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02031015'))
  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 CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.Nov 11, 2011 · N13584 · Substantial damageNTSB WPR12LA029Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Diego, CAThe flight instructor's inadequate supervision of the student pilot during a simulated autorotation and the pilots’ failure to use carburetor heat while operating at reduced engine power while in carburetor icing conditions, which resulted in a loss of engine…Nov 8, 2011 · N4251A · Substantial damageNTSB ERA12LA063Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe pilot’s failure to maintain airspeed during a low-altitude turn into gusty tailwind conditions, which resulted in a loss of translational lift and settling with power. Contributing to the accident was the pilot's lack of total flight experience.Nov 5, 2011 · N413RM · Substantial damageNTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.Sep 4, 2011 · N43220 · Substantial damageNTSB WPR11FA239Accident · 1 fatalField investigationFinal reportBrantly B-2B · Weaverville, CAThe student pilot's decision to fly in windy conditions that exceeded his capabilities, which resulted in his subsequent loss of helicopter control. Contributing to the accident was his lack of flight experience in the accident helicopter.May 27, 2011 · N222DW · Substantial damageNTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.Apr 22, 2011 · N580EA · Destroyed