# NTSB investigations: Continental C145 series, 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 DEN91LA024](https://openairdocs.org/ntsb/DEN91LA024.md): Cessna 170A · Welsh, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1990 · N1344D · Substantial damage
  > The pilot's improper compensation for wind conditions. A factor was the gusty wind.
- [NTSB FTW85LA201](https://openairdocs.org/ntsb/FTW85LA201.md): Cessna 170B · Ama, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1985 · N170NX · Destroyed
  > The aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used…
- [NTSB FTW80DRD23](https://openairdocs.org/ntsb/FTW80DRD23.md): Cessna 170B · Venice, LA · Accident · No injuries · Closed · Apr 20, 1980 · N5729C · Substantial damage
- [NTSB FTW72DRJ16](https://openairdocs.org/ntsb/FTW72DRJ16.md): Cessna 170B · Tallulah, LA · Accident · No injuries · Closed · Dec 4, 1971 · N3165B · Substantial damage
- [NTSB FTW71DRJ12](https://openairdocs.org/ntsb/FTW71DRJ12.md): Cessna 170 · Florien, LA · Accident · No injuries · Closed · Aug 10, 1970 · N1263D · Substantial damage
- [NTSB FTW70DRJ10](https://openairdocs.org/ntsb/FTW70DRJ10.md): Cessna 170B · Alexandria, LA · Accident · No injuries · Closed · Jun 20, 1970 · N4583C · Substantial damage
- [NTSB FTW69F0439](https://openairdocs.org/ntsb/FTW69F0439.md): Cessna 170A · Rayne, LA · Accident · No injuries · Closed · Apr 7, 1969 · N4403V · Substantial damage
- [NTSB FTW67F0435](https://openairdocs.org/ntsb/FTW67F0435.md): Cessna 170A · New Orleans, LA · Accident · No injuries · Closed · Jan 28, 1967 · N9908A · Substantial damage
- [NTSB FTW66D0175](https://openairdocs.org/ntsb/FTW66D0175.md): Cessna 170A · Jonesville, LA · Accident · No injuries · Closed · May 21, 1965 · N8291A · 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.engine_model_code IN ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17012&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.