# NTSB investigations: Cessna 172B, LA

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 FTW85LA103](https://openairdocs.org/ntsb/FTW85LA103.md): Cessna 172B · Coushatta, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1985 · N7718X · Substantial damage
  > The acft was on its 1st flt following maintenance for a previous nose gear shimmy problem. When the student made his 1st attempt to land, he noticed that the nose gear seemed to be cocked, so he aborted the landing. On the 2nd attempt, the acft swerved to the…
- [NTSB FTW66F0664](https://openairdocs.org/ntsb/FTW66F0664.md): Cessna 172 · Newellton, LA · Accident · No injuries · Closed · May 8, 1966 · N6941X · Substantial damage
- [NTSB FTW66D0202](https://openairdocs.org/ntsb/FTW66D0202.md): Cessna 172 · Chandeleur Isl, LA · Accident · No injuries · Closed · Mar 2, 1965 · N8125X · Substantial damage

## 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" = 'LA' 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=LA

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