# NTSB investigations: Convair 600-240D

A list on [Convair 600-240D](https://openairdocs.org/model/convair-600-240d.md).

Matched to the registry by N-number and event date, newest first.

- [NTSB FTW92FA025](https://openairdocs.org/ntsb/FTW92FA025.md): Convair 600 · Forth Worth, TX · Accident · No injuries · Field investigation · Final report · Nov 20, 1991 · N94258 · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…
- [NTSB NYC89LA189](https://openairdocs.org/ntsb/NYC89LA189.md): Convair CV-600-240D · Augusta, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1989 · N94253 · Substantial damage
  > The failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…
- [NTSB CHI79DA016](https://openairdocs.org/ntsb/CHI79DA016.md): Convair 600 · Wilmington, OH · Accident · No injuries · Closed · Nov 18, 1978 · N74853 · Substantial damage
- [NTSB CHI79DA001](https://openairdocs.org/ntsb/CHI79DA001.md): Convair CV-600 · Cleveland, OH · Incident · No injuries · Closed · Oct 3, 1978 · N74855 · Minor damage
- [NTSB DCA74AZ006](https://openairdocs.org/ntsb/DCA74AZ006.md): Convair 600 · Mena, AR · Accident · 11 fatal · Closed · Sep 27, 1973 · N94230 · Destroyed
- [NTSB FTW72AF074](https://openairdocs.org/ntsb/FTW72AF074.md): Convair 600 · Alexandria, LA · Accident · No injuries · Closed · May 8, 1972 · N94236 · Substantial damage
- [NTSB FTW72AF054](https://openairdocs.org/ntsb/FTW72AF054.md): Convair 600 · Beaumont, TX · Accident · No injuries · Closed · Feb 16, 1972 · N94226 · Substantial damage
- [NTSB FTW71AF011](https://openairdocs.org/ntsb/FTW71AF011.md): Convair 600 · Lake Charles, LA · Accident · Serious injuries · Closed · Sep 16, 1970 · N94236 · No damage
- [NTSB FTW70A0007](https://openairdocs.org/ntsb/FTW70A0007.md): Convair 600 · Houston, TX · Accident · No injuries · Closed · Aug 1, 1969 · N94207 · Substantial damage
- [NTSB FTW67A0009](https://openairdocs.org/ntsb/FTW67A0009.md): Convair CV-600 · Harlingen, TX · Accident · No injuries · Closed · Jul 11, 1966 · N94215 · Substantial damage
- [NTSB FTW66A0101](https://openairdocs.org/ntsb/FTW66A0101.md): Convair CV-240 · Ft Worth, TX · Accident · No injuries · Closed · May 12, 1966 · N94208 · Substantial damage
- [NTSB FTW66A0044](https://openairdocs.org/ntsb/FTW66A0044.md): Convair CV-240 · College Sta., TX · Accident · No injuries · Closed · Nov 8, 1965 · N94249 · Substantial damage
- [NTSB MIA66A0047](https://openairdocs.org/ntsb/MIA66A0047.md): Convair 240D · Tallahassee, FL · Accident · No injuries · Closed · Oct 29, 1965 · N74858 · Substantial damage
- [NTSB FTW65A0069](https://openairdocs.org/ntsb/FTW65A0069.md): Convair CV-240 · Tulsa, OK · Accident · No injuries · Closed · Jan 8, 1965 · N74850 · Substantial damage
- [NTSB UNK65X0158](https://openairdocs.org/ntsb/UNK65X0158.md): Convair 240 · Roswell, NM · Incident · No injuries · Closed · Oct 6, 1964 · N94240 · No damage
- [NTSB CHI62A0009](https://openairdocs.org/ntsb/CHI62A0009.md): Convair 240 · Chicago, IL · Accident · No injuries · Closed · Jan 20, 1962 · N94253 · 2 aircraft · 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2422660')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/model/convair-600-240d/ntsb

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