# NTSB investigations: Convair 340-31

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 FTW87FA080](https://openairdocs.org/ntsb/FTW87FA080.md): Convair CV-580 · Dallas, TX · Accident · No injuries · Field investigation · Final report · Mar 25, 1987 · N73107 · Substantial damage
  > Metro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair…
- [NTSB DEN86FA120](https://openairdocs.org/ntsb/DEN86FA120.md): Convair 580 · Denver, CO · Accident · Serious injuries · Field investigation · Final report · Apr 25, 1986 · N73104 · No damage
  > N73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…
- [NTSB FTW82FA018](https://openairdocs.org/ntsb/FTW82FA018.md): Convair 580 · Longview, TX · Accident · No injuries · Closed · Nov 4, 1981 · N73143 · Substantial damage
- [NTSB DEN78IA009](https://openairdocs.org/ntsb/DEN78IA009.md): Convair 540 · Denver, CO · Incident · No injuries · Closed · Nov 28, 1977 · N73143 · Minor damage
- [NTSB DEN74AD033](https://openairdocs.org/ntsb/DEN74AD033.md): Convair 580 · Cheyenne, WY · Accident · Serious injuries · Closed · Jan 13, 1974 · N73145 · No damage
- [NTSB DEN73AD028](https://openairdocs.org/ntsb/DEN73AD028.md): Convair 580 · Alamosa, CO · Accident · Serious injuries · Closed · Dec 4, 1972 · N73112 · No damage
- [NTSB DEN71ID033](https://openairdocs.org/ntsb/DEN71ID033.md): Convair 580 · Albuquerque, NM · Incident · No injuries · Closed · Jan 29, 1971 · N73155 · No damage
- [NTSB LAX69A0027](https://openairdocs.org/ntsb/LAX69A0027.md): Convair 580 · Santa Barbara, CA · Accident · No injuries · Closed · Nov 12, 1968 · N73135 · Substantial damage
- [NTSB MKC69I0003](https://openairdocs.org/ntsb/MKC69I0003.md): Convair 580 · Pawnee City, NE · Incident · Minor injuries · Closed · Jul 23, 1968 · N73121 · No damage
- [NTSB DEN68A0017](https://openairdocs.org/ntsb/DEN68A0017.md): Convair 580 · Denver, CO · Accident · No injuries · Closed · Sep 8, 1967 · N73145 · Substantial damage
- [NTSB DEN67I0036](https://openairdocs.org/ntsb/DEN67I0036.md): Convair 580 · Salt Lake City, UT · Incident · No injuries · Closed · Dec 14, 1966 · N73155 · Substantial damage
- [NTSB UNK65X0437](https://openairdocs.org/ntsb/UNK65X0437.md): Convair CV-340 · Rock Springs, WY · Accident · Minor injuries · Closed · Oct 25, 1964 · N73155 · Substantial damage
- [NTSB UNK64X3979](https://openairdocs.org/ntsb/UNK64X3979.md): Convair CV-440 · Farmington, NM · Accident · No injuries · Closed · Sep 14, 1964 · N73126 · Substantial damage
- [NTSB UNK64X1647](https://openairdocs.org/ntsb/UNK64X1647.md): Convair 340 · Salt Lake City, UT · Incident · No injuries · Closed · May 7, 1964 · N73104 · Minor damage
- [NTSB MKC62A0052](https://openairdocs.org/ntsb/MKC62A0052.md): Convair 340 · Grand Island, NE · Accident · Serious injuries · Closed · Dec 21, 1962 · N73130 · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2422804'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2422804

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