# NTSB investigations: Continental O-470 series, SC: In flight encounter with weather

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 ATL99FA019](https://openairdocs.org/ntsb/ATL99FA019.md): Cessna 182P · Santee, SC · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1998 · N6522M · Destroyed
  > The pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.
- [NTSB ATL90FA022](https://openairdocs.org/ntsb/ATL90FA022.md): Cessna 182P · Darlington, SC · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1989 · N58735 · Destroyed
  > The pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.
- [NTSB ATL89LA217](https://openairdocs.org/ntsb/ATL89LA217.md): Cessna 182Q · Mt Pleasant, SC · Accident · No injuries · Limited investigation · Final report · Sep 24, 1989 · N735BN · Substantial damage
  > Failure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…
- [NTSB ATL83LA089](https://openairdocs.org/ntsb/ATL83LA089.md): Cessna 182M · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Jan 18, 1983 · N70872 · Substantial damage
  > During arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…

## 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" = '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 ('17026')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17026&occurrence=240&state=SC

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