# NTSB investigations: Cessna 172A: On ground/water 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 FTW98LA003](https://openairdocs.org/ntsb/FTW98LA003.md): Cessna 172A · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Oct 3, 1997 · N7692T · Substantial damage
  > Encounter with high gusting winds while standing with the engine running
- [NTSB SEA90LA033](https://openairdocs.org/ntsb/SEA90LA033.md): Cessna 172A · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jan 8, 1990 · N7878T · Substantial damage
  > The pilot's improper use of the flight controls. Factors in the accident were the high, gusty wind conditions, the pilot's self induced pressure to arrive at work on time, and his lack of total pilot experience.
- [NTSB FTW86LA155](https://openairdocs.org/ntsb/FTW86LA155.md): Cessna 172A · Gainesville, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N7261T · Substantial damage
  > The pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…

## 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 ('2072404')
    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" = 330))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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