# NTSB investigations: Continental C145 series, 2023

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 GAA24WA017](https://openairdocs.org/ntsb/GAA24WA017.md): Cessna 170B · Duxford, United Kingdom · Accident · No injuries · Class 5 · Foreign · Oct 9, 2023 · N2366D · Substantial damage
- [NTSB WPR23LA260](https://openairdocs.org/ntsb/WPR23LA260.md): Cessna 170B · Fremont Island, UT · Accident · No injuries · Class 4 · Limited · Final report · Jul 7, 2023 · N1664D · Substantial damage
  > The pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.
- [NTSB WPR23LA233](https://openairdocs.org/ntsb/WPR23LA233.md): Cessna 170B · Elko, NV · Accident · No injuries · Class 4 · Limited · Final report · Jun 16, 2023 · N8223A · Substantial damage
  > The pilot’s loss of control after encountering a dust devil during takeoff.
- [NTSB WPR23LA300](https://openairdocs.org/ntsb/WPR23LA300.md): Cessna 170B · Tracy, CA · Accident · No injuries · Class 4 · Limited · Final report · May 17, 2023 · N2771C · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.
- [NTSB WPR23LA171](https://openairdocs.org/ntsb/WPR23LA171.md): Cessna 170B · Queen Creek, AZ · Accident · No injuries · Class 4 · Limited · Final report · Apr 29, 2023 · N2207D · Substantial damage
  > The airplane’s encounter with a dust devil after landing, which resulted in a loss of directional control.
- [NTSB CEN23LA140](https://openairdocs.org/ntsb/CEN23LA140.md): Cessna 170A · Oklahoma City, OK · Accident · No injuries · Class 4 · Limited · Final report · Mar 19, 2023 · N9254A · Substantial damage
  > The pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.
- [NTSB WPR23LA096](https://openairdocs.org/ntsb/WPR23LA096.md): Cessna 170 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jan 23, 2023 · N9534A · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.

## 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 year(c."eventDate") = 2023
  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&year=2023

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