# NTSB investigations: Continental 0-200 series, 1987, SC

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 ATL88LA004](https://openairdocs.org/ntsb/ATL88LA004.md): Cessna 150L · Cordesville, SC · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N11838 · Substantial damage
  > The airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…
- [NTSB ATL87LA221](https://openairdocs.org/ntsb/ATL87LA221.md): Cessna 150M · Edmund, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1987 · N45648 · Substantial damage
  > The CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…

## 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") = 1987
  AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17020&state=SC&year=1987

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