# NTSB investigations, KS: Ice/rain protection system

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 CEN23LA264](https://openairdocs.org/ntsb/CEN23LA264.md): Beech B19 · Scott City, KS · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2023 · N9721Q · Substantial damage
  > A partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.
- [NTSB CEN19FA029](https://openairdocs.org/ntsb/CEN19FA029.md): Beech 55 · Liberal, KS · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2018 · N4817M · Substantial damage
  > The pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…
- [NTSB CEN16LA177](https://openairdocs.org/ntsb/CEN16LA177.md): Boeing A75N1 (PT17) · Osage City, KS · Accident · No injuries · Limited investigation · Final report · Apr 28, 2016 · N17PY · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN10LA068](https://openairdocs.org/ntsb/CEN10LA068.md): Beech V35 · Dodge City, KS · Accident · No injuries · Limited investigation · Final report · Dec 6, 2009 · N108L · Substantial damage
  > The failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.

## 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" = 'KS' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010230'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010230/cases?state=KS

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
