OpenAirDocs.org

NTSB investigations, 2011

7 cases where the sequence of events included Structural icing.

Cases per year

20082026

Where

Open the map

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '210' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ANC12CA016Accident · Minor injuriesData collectionFinal reportCessna 207A · Kwigillingok, AKThe pilot’s decision to continue visual flight into instrument meteorological conditions with moderate icing, which resulted in structural icing and an aerodynamic stall.Dec 21, 2011 · N6480H · Substantial damageNTSB ERA12FA115Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Morristown, NJThe airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…Dec 20, 2011 · N731CA · DestroyedNTSB CEN12CA104Accident · No injuriesData collectionFinal reportCessna 421B · Pampa, TXThe pilot's inadequate aircraft control during landing, which resulted in a hard landing.Dec 9, 2011 · N421CE · Substantial damageNTSB ERA11LA344Accident · No injuriesLimited investigationFinal reportBeech A100 · Gray, TNAn encounter with convectively-induced turbulence and icing, which resulted in an in-flight upset and a loss of airplane control.Jun 15, 2011 · N15L · Substantial damageNTSB WPR11FA228Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Rock Springs, WYThe pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.May 18, 2011 · N93577 · Substantial damageNTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.Mar 7, 2011 · CGPDO · Substantial damageNTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…Jan 6, 2011 · N800GP · Substantial damage