# Final NTSB investigations: Consolidated Vultee L-13

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 ANC86LA052](https://openairdocs.org/ntsb/ANC86LA052.md): Consolidated-Vultee L-13 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N2536B · Substantial damage
  > During the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At…
- [NTSB SEA79DYE19](https://openairdocs.org/ntsb/SEA79DYE19.md): Convair L-13 · Snohomish, WA · Accident · No injuries · Closed · Apr 21, 1979 · N4659V · Substantial damage
- [NTSB SEA78DYP02](https://openairdocs.org/ntsb/SEA78DYP02.md): Cons-Vultee L-13 · Wenatchee, WA · Accident · No injuries · Closed · Oct 11, 1977 · N4659V · Substantial damage
- [NTSB LAX76DUQ20](https://openairdocs.org/ntsb/LAX76DUQ20.md): Convair L-13 · San Fernando, CA · Accident · Minor injuries · Closed · Jan 1, 1976 · N101BH · Substantial damage
- [NTSB FTW70F0161](https://openairdocs.org/ntsb/FTW70F0161.md): Convair L-13 · Decatur, TX · Accident · No injuries · Closed · Aug 31, 1969 · N2538B · Substantial damage
- [NTSB SEA69D0048](https://openairdocs.org/ntsb/SEA69D0048.md): Convair L-13 · Genesee, ID · Accident · No injuries · Closed · Jul 23, 1968 · N66370 · Substantial damage
- [NTSB LAX66F0143](https://openairdocs.org/ntsb/LAX66F0143.md): Convair L-13A · Sparks, NV · Accident · Minor injuries · Closed · Aug 22, 1965 · N68847 · Substantial damage
- [NTSB UNK65X0260](https://openairdocs.org/ntsb/UNK65X0260.md): Convair L-13 · Mendota, CA · Accident · 1 fatal · Closed · Oct 12, 1964 · N5054V · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=2420702&status=final

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