# NTSB investigations: Beech 95, MI

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 CHI82DA111](https://openairdocs.org/ntsb/CHI82DA111.md): Beech 95 · Pontiac, MI · Accident · Serious injuries · Final report · Apr 5, 1982 · N2765Y · No damage
  > It was dark and the temperature was about 20 degrees when the pilot and two passengers arrived at the plane. The pilot had started the right engine before the passengers arrived, but the left engine failed to start in the cold temperature. The pilot was…
- [NTSB CHI77AC095](https://openairdocs.org/ntsb/CHI77AC095.md): Beech 95 · L'Anse, MI · Accident · 2 fatal · Closed · Sep 20, 1976 · N2080C · Destroyed
- [NTSB CHI74FEM25](https://openairdocs.org/ntsb/CHI74FEM25.md): Beech 95 · Midland, MI · Accident · No injuries · Closed · Dec 1, 1973 · N274C · Substantial damage
- [NTSB CHI72FEM73](https://openairdocs.org/ntsb/CHI72FEM73.md): Beech 95 · Midland, MI · Accident · No injuries · Closed · Jun 9, 1972 · N274C · Substantial damage
- [NTSB CHI70FBG07](https://openairdocs.org/ntsb/CHI70FBG07.md): Beech 95 · Plymouth, MI · Accident · No injuries · Closed · Feb 1, 1970 · N274C · Substantial damage
- [NTSB CHI67F0578](https://openairdocs.org/ntsb/CHI67F0578.md): Beech 95 · Houghton Lake, MI · Accident · No injuries · Closed · Apr 8, 1967 · N2702Y · Substantial damage
- [NTSB UNK64X4037](https://openairdocs.org/ntsb/UNK64X4037.md): Beechcraft B95 · Sault St Marie, MI · Accident · No injuries · Closed · Sep 18, 1964 · N169Y · 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" = 'MI' 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 ('1153402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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