Fatal NTSB investigations: Cessna T337D

6 cases on aircraft the registry lists as Cessna T337D. 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

19712026

Fatal NTSB investigations: Cessna T337D per year, 1971–2026: 6 cases
1971	1
1972	1
1974	1
1978	1
1982	1
1997	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 ('2075719')) 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 ('2075719'))
  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 ('2075719'))
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 IAD97FA060Accident · 1 fatalField investigationFinal reportCessna 337D · Hickory, PAServicing of the pilots portable oxygen system with compressed air, which resulted in pilot incapacitation due to Hypoxia.Apr 1, 1997 · N2685S · Destroyed NTSB LAX83FA030Accident · 1 fatalField investigationFinal reportCessna T337D · Scottsdale, AZFour minutes after takeoff the plt radioed that his eng had failed & he was going down. The acft crashed into a residential area, striking power lines, a fence & two houses. The acft had been flown during the day with no refueling the right aux tank contained…Nov 10, 1982 · N86041 · Destroyed NTSB LAX78FA048Accident · 2 fatalClosedCessna 337D · Santa Barbara, CAMay 21, 1978 · N86100 · Destroyed NTSB LAX75OL007Accident · 1 fatalClosedCessna 337 · Chiconcuac, MexicoJul 28, 1974 · N85953 · Destroyed NTSB NYC73AN010Accident · 4 fatalClosedCessna T337D · Belfast, MEJul 14, 1972 · N86018 · Destroyed NTSB SEA72AS028Accident · 3 fatalClosedCessna T337D · Vale, ORDec 13, 1971 · N86371 · Destroyed