# Fatal NTSB investigations: Grumman TBM-3E

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 NYC86FA196](https://openairdocs.org/ntsb/NYC86FA196.md): Grumman TBM-3E · Brooklyn, CT · Accident · 1 fatal · Field investigation · Final report · Aug 4, 1986 · N6581D · Destroyed
  > The acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of…
- [NTSB OAK72FVG22](https://openairdocs.org/ntsb/OAK72FVG22.md): Grumman TBM3E · Placerville, CA · Accident · 1 fatal · Closed · Sep 4, 1971 · N6825C · Destroyed
- [NTSB LAX71FUM11](https://openairdocs.org/ntsb/LAX71FUM11.md): Grumman TBM-3E · Ramona, CA · Accident · 1 fatal · Closed · Sep 4, 1970 · N9860C · Destroyed
- [NTSB CAN714A905](https://openairdocs.org/ntsb/CAN714A905.md): Grumman TBM · St.Martin, Canada · Accident · 1 fatal · Closed · Jun 21, 1970 · N7031C · Destroyed
- [NTSB SEA70FXM20](https://openairdocs.org/ntsb/SEA70FXM20.md): Grumman TBM · Boise, ID · Accident · 1 fatal · Closed · Jun 19, 1970 · N7026C · Destroyed
- [NTSB NYC67A0172](https://openairdocs.org/ntsb/NYC67A0172.md): Grumman TBM-3E · Tuckerton, NJ · Accident · 1 fatal · Closed · Jun 2, 1967 · N9595C · Destroyed
- [NTSB DEN67A0072](https://openairdocs.org/ntsb/DEN67A0072.md): Grumman TBM3E · Upton, WY · Accident · 1 fatal · Closed · May 23, 1967 · N6823C · Destroyed
- [NTSB UNK64X2948](https://openairdocs.org/ntsb/UNK64X2948.md): Grumman TBM-3 · Gibbonsville, ID · Accident · 1 fatal · Closed · Jul 20, 1964 · N7016C · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3950310'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=3950310

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