# NTSB investigations: Cessna 208B: Loss of control - on ground/water

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 ANC06CA012](https://openairdocs.org/ntsb/ANC06CA012.md): Cessna 208 · Brevig Mission, AK · Accident · No injuries · Data collection · Final report · Dec 19, 2005 · N303GV · Substantial damage
  > The pilot's inadequate compensation for crosswind conditions, which resulted in the left wing striking the ground while taxiing. A factor in the accident was a crosswind.
- [NTSB ANC06CA011](https://openairdocs.org/ntsb/ANC06CA011.md): Cessna 208B · Newtok, AK · Accident · No injuries · Data collection · Final report · Dec 13, 2005 · N454SF · Substantial damage
  > The pilot's inadequate compensation for gusting crosswind conditions, which resulted in the airplane exiting the runway, encountering snow, and the nose gear collapsing. Factors associated with the accident were the gusting wind and the icy runway.
- [NTSB ANC04LA032](https://openairdocs.org/ntsb/ANC04LA032.md): Cessna 208B · Toksook Bay, AK · Accident · No injuries · Limited investigation · Final report · Feb 10, 2004 · N1276P · Substantial damage
  > The pilot's inadequate planning and decision to initiate a takeoff into a crosswind that exceeded the airplane's demonstrated crosswind component, which resulted in a loss of directional control during the takeoff roll, and subsequent collision with terrain…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073701', '2073700', '2073705')
    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" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073701&occurrence=260

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