Fatal NTSB investigations: Grumman TBM-3E

8 cases on aircraft the registry lists as Grumman TBM-3E. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Fatal NTSB investigations: Grumman TBM-3E per year, 1964–2026: 8 cases
1964	1
1967	2
1970	3
1971	1
1986	1

Where

Open the map

Latest cases

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC86FA196Accident · 1 fatalField investigationFinal reportGrumman TBM-3E · Brooklyn, CTThe 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…Aug 4, 1986 · N6581D · Destroyed NTSB OAK72FVG22Accident · 1 fatalClosedGrumman TBM3E · Placerville, CASep 4, 1971 · N6825C · Destroyed NTSB LAX71FUM11Accident · 1 fatalClosedGrumman TBM-3E · Ramona, CASep 4, 1970 · N9860C · Destroyed NTSB CAN714A905Accident · 1 fatalClosedGrumman TBM · St.Martin, CanadaJun 21, 1970 · N7031C · Destroyed NTSB SEA70FXM20Accident · 1 fatalClosedGrumman TBM · Boise, IDJun 19, 1970 · N7026C · Destroyed NTSB NYC67A0172Accident · 1 fatalClosedGrumman TBM-3E · Tuckerton, NJJun 2, 1967 · N9595C · Destroyed NTSB DEN67A0072Accident · 1 fatalClosedGrumman TBM3E · Upton, WYMay 23, 1967 · N6823C · Destroyed NTSB UNK64X2948Accident · 1 fatalClosedGrumman TBM-3 · Gibbonsville, IDJul 20, 1964 · N7016C · Destroyed