# NTSB investigations: Cessna 310, PA

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 NYC82DA022](https://openairdocs.org/ntsb/NYC82DA022.md): Cessna 310 · Butler, PA · Accident · No injuries · Final report · Jan 15, 1982 · N4875B · Substantial damage
  > The pilot arrived at the destination at dusk. He circled the airport at pattern altitude to check the wind and runway condition. He noted that the runway was covered with snow. A long approach was made to runway 36 in a calm wind condition. Just prior to…
- [NTSB NYC77FHA37](https://openairdocs.org/ntsb/NYC77FHA37.md): Cessna 310 · Doylestown, PA · Accident · No injuries · Closed · Sep 8, 1977 · N310W · Substantial damage
- [NTSB NYC72AN167](https://openairdocs.org/ntsb/NYC72AN167.md): Cessna 310 · Reading, PA · Accident · 2 fatal · Closed · Jun 29, 1972 · N5250A · Destroyed
- [NTSB NYC68F0348](https://openairdocs.org/ntsb/NYC68F0348.md): Cessna 310 · Erie, PA · Accident · No injuries · Closed · Jan 23, 1968 · N3095D · Substantial damage
- [NTSB NYC67A0148](https://openairdocs.org/ntsb/NYC67A0148.md): Cessna 310 · Indiana, PA · Accident · 2 fatal · Closed · Apr 26, 1967 · N5217A · Destroyed
- [NTSB NYC66F0256](https://openairdocs.org/ntsb/NYC66F0256.md): Cessna 310B · Bristol, PA · Accident · No injuries · Closed · Aug 7, 1965 · N3693D · 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" = 'PA' 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 ('2074202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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