# NTSB investigations: Cessna 172B, OK

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 FTW03LA116](https://openairdocs.org/ntsb/FTW03LA116.md): Cessna 172B · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Mar 26, 2003 · N6947X · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB FTW94LA317](https://openairdocs.org/ntsb/FTW94LA317.md): Cessna 172B · Poteau, OK · Accident · No injuries · Limited investigation · Final report · Sep 28, 1994 · N7617X · Substantial damage
  > The loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.
- [NTSB FTW92LA038](https://openairdocs.org/ntsb/FTW92LA038.md): Cessna 172B · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Dec 5, 1991 · N6947X · Substantial damage
  > Clearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.

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

This list as a web page: https://openairdocs.org/ntsb?model=2072406&state=OK

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