# NTSB investigations, 2017, MS: Off-field or emergency landing

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 ANC18LA011](https://openairdocs.org/ntsb/ANC18LA011.md): Cessna 172 · Oloh, MS · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2017 · N739KW · Substantial damage
  > A partial loss of engine power due to the failure of the No. 3 valve key (exhaust).
- [NTSB WPR18LA029](https://openairdocs.org/ntsb/WPR18LA029.md): Bell 206 · Rolling Fork, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 7, 2017 · N93PH · Substantial damage
  > An uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.
- [NTSB ANC18LA002](https://openairdocs.org/ntsb/ANC18LA002.md): Fleetwood Jack Team Airbike · Ocean Springs, MS · Accident · No injuries · Limited investigation · Final report · Oct 11, 2017 · N7566D · Substantial damage
  > An intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.
- [NTSB ERA17LA314](https://openairdocs.org/ntsb/ERA17LA314.md): Rudder Dwight K Kitfox IV 1200 Spdst · Raymond, MS · Accident · No injuries · Class 3 · Limited · Final report · Sep 5, 2017 · N16KR · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.

## 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") = 2017
  AND c."eventStateOrRegion" = 'MS' 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" = '440' 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/440/sequence?state=MS&year=2017

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