# NTSB investigations: Cessna 172B: 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 DEN00LA011](https://openairdocs.org/ntsb/DEN00LA011.md): Cessna 172B · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Oct 27, 1999 · N7906X · Substantial damage
  > The pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.
- [NTSB LAX90LA245](https://openairdocs.org/ntsb/LAX90LA245.md): Cessna 172 · Davis, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1990 · N7726X · Substantial damage
  > The pilot failed to maintin directional control by improperly using the brakes.
- [NTSB FTW90LA127](https://openairdocs.org/ntsb/FTW90LA127.md): Cessna 172 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 29, 1990 · N8190X · Substantial damage
  > Failure to maintain directional control.
- [NTSB FTW83LA203](https://openairdocs.org/ntsb/FTW83LA203.md): Cessna 172B · Spearman, TX · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N6992X · Substantial damage
  > The acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…
- [NTSB LAX82FUQ11](https://openairdocs.org/ntsb/LAX82FUQ11.md): Cessna 172 · Lancaster, CA · Accident · No injuries · Final report · Mar 14, 1982 · N7498X · Destroyed
  > At 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The…

## 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 ('2072406')
    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=2072406&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.