NTSB investigations, 2011

6 cases where NTSB found Ceiling/visibility/precip, general.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 65 cases
20082
20093
20107
20116
20125
20136
20144
20155
201610
20174
20184
20201
20212
20223
20232
20251

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\", '03035000'))
  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 ERA12CA119Accident · No injuriesData collectionFinal reportHughes 369D · Fall Branch, TNThe pilot's improper decision to continue a visual flight into instrument meteorological conditions, which resulted in a wire strike.Dec 21, 2011 · N500TN · Substantial damageNTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…Dec 2, 2011 · N90QL · DestroyedNTSB ERA11FA376Accident · 5 fatalField investigationFinal reportCessna A185F · Yabucoa, PRThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.Jul 1, 2011 · N8436Q · Substantial damageNTSB WPR11FA256Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Ukiah, ORThe non-instrument-rated pilot's decision to conduct a visual flight rules flight over mountainous terrain into a region covered by clouds, which likely resulted in spatial disorientation and subsequent loss of airplane control.Jun 11, 2011 · N79BF · Substantial damageNTSB WPR11FA230Accident · 1 fatalField investigationFinal reportCameron Lancair Legacy · Pioneer, CAThe pilot’s continued flight into instrument meteorological conditions at an insufficient altitude to clear terrain.May 18, 2011 · N121J · Substantial damageNTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.Apr 24, 2011 · N320AZ · Substantial damage