# NTSB investigations, MD: 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 ERA22LA191](https://openairdocs.org/ntsb/ERA22LA191.md): Piper PA-32-260 · Grantsville, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 16, 2022 · N3618W · Substantial damage
  > The pilot’s decision to continue the flight into an area of moderate to heavy icing conditions, which resulted in a degradation of airplane performance and subsequent loss of control.
- [NTSB DCA15MA029](https://openairdocs.org/ntsb/DCA15MA029.md): Embraer EMB-500 · Gaithersburg, MD · Accident · 6 fatal · Class 1 · Major · Final report · Dec 8, 2014 · N100EQ · Destroyed
  > the pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…

## 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 c."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA'
  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?state=MD

---
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.