# NTSB investigations: Cessna 310D, IL

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 CHI85LA270](https://openairdocs.org/ntsb/CHI85LA270.md): Cessna 310D · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N1729K · Substantial damage
  > The acft was landing at dest arpt after a two hr xcountry flt. At gear ext no green light. Pilot recycled gear but still no light. Emergency ext used and three green indicated. On ld roll nose gear collapsed. Uplock arm tube was broken on the nose gear.
- [NTSB CHI69D0564](https://openairdocs.org/ntsb/CHI69D0564.md): Cessna 310D · Rockford, IL · Accident · No injuries · Closed · Apr 16, 1969 · N6893T · Substantial damage
- [NTSB UNK64X1772](https://openairdocs.org/ntsb/UNK64X1772.md): Cessna 310D · Taylorville, IL · Accident · No injuries · Closed · May 15, 1964 · N6743T · 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" = 'IL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2074212&state=IL

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