# NTSB investigations, SD: Fire/smoke (non-impact)

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 CEN22FA433](https://openairdocs.org/ntsb/CEN22FA433.md): Airgyro AG915 · Yankton, SD · Accident · 1 fatal · Class 3 · Field · Final report · Sep 27, 2022 · N499AG · Destroyed
  > A loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.
- [NTSB CEN17IA094](https://openairdocs.org/ntsb/CEN17IA094.md): Eurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SD · Incident · No injuries · Class 2 · Incident · Final report · Jan 27, 2017 · N911MK · Minor damage
  > The gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…
- [NTSB CEN16LA201](https://openairdocs.org/ntsb/CEN16LA201.md): Cessna 402B · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · May 27, 2016 · N76MD · Substantial damage
  > The failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.
- [NTSB CEN12FA100](https://openairdocs.org/ntsb/CEN12FA100.md): Cessna 421C · Sioux Falls, SD · Accident · 4 fatal · Field investigation · Final report · Dec 9, 2011 · N421SY · Substantial damage
  > The pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…

## 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" = 'SD' 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" = '150' 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/150/sequence?state=SD

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