# NTSB investigations, 2010: Structural icing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN11CA135](https://openairdocs.org/ntsb/CEN11CA135.md): Allen Raymond H Lancair Legacy · Troy, MI · Accident · No injuries · Data collection · Final report · Dec 25, 2010 · N385AS · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the landing which resulted in an inadvertent stall. Contributing to the accident was the structural icing on the airframe.
- [NTSB ERA11LA099](https://openairdocs.org/ntsb/ERA11LA099.md): Beech F35 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Dec 24, 2010 · N3448B · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during landing with airframe structural icing, resulting in an aerodynamic stall and subsequent hard landing. Contributing to the accident was the pilot’s continued flight into known icing conditions.
- [NTSB ERA11FA095](https://openairdocs.org/ntsb/ERA11FA095.md): Mooney M20R · Dundee, NY · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2010 · N968SM · Substantial damage
  > The pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.
- [NTSB CEN10WA331](https://openairdocs.org/ntsb/CEN10WA331.md): Cirrus Design SR20 · Sirdal, Norway · Accident · No injuries · Foreign investigation · May 28, 2010 · LN-BCD · Substantial damage
  > On May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…
- [NTSB ANC10LA019](https://openairdocs.org/ntsb/ANC10LA019.md): Cessna 208B · Kwigillingok, AK · Accident · No injuries · Limited investigation · Final report · Feb 17, 2010 · N207DR · Substantial damage
  > The pilot's decision to take off with ice-contaminated wings in freezing rain and mist, which resulted in an aerodynamic stall.
- [NTSB CEN10LA090](https://openairdocs.org/ntsb/CEN10LA090.md): Beech C-99 · Kearney, NE · Accident · No injuries · Limited investigation · Final report · Jan 6, 2010 · N206AV · Substantial damage
  > The failure of the pilot to maintain adequate airspeed during the approach resulting in a stall. Contributing to the accident was the accumulation of structural icing during the flight.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2010
  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
```

This list as a web page: https://openairdocs.org/ntsb-events/210/sequence?year=2010

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.