NTSB investigations: Cessna 337A, TX

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

19682026

NTSB investigations: Cessna 337A, TX per year, 1968–2026: 7 cases
1968	1
1970	1
1977	1
1980	1
1981	2
1988	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."eventStateOrRegion" = 'TX' 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 ('2075704')) 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.\"eventStateOrRegion\" = 'TX' 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 ('2075704'))
  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."eventStateOrRegion" = 'TX' 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 ('2075704'))
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 FTW89FA024Accident · 2 fatalField investigationFinal reportCessna 337A · Weatherford, TXThe pilot failed to maintain minimum required airspeed for slow flight (vs), resulting in a stall with insufficient altitude to recover. A contributing factor was the Piper pilot's unannounced fly-by, which diverted the Cessna pilot's attention.Nov 24, 1988 · N5337S · Destroyed NTSB FTW81FRG37Accident · Minor injuriesClosedCessna 337 · Melvin, TXMay 16, 1981 · N337W · Substantial damage NTSB FTW81FA089Accident · 2 fatalClosedCessna 337A · Evant, TXMay 15, 1981 · N6345F · Destroyed NTSB FTW80FA087Accident · 4 fatalClosedCessna 337A · Aledo, TXJun 16, 1980 · N7DT · Destroyed NTSB FTW77DRG22Accident · No injuriesClosedCessna 337 · Laredo, TXJan 1, 1977 · N19F · Substantial damage NTSB FTW71FRJ01Accident · Minor injuriesClosedCessna 337A · Pollok, TXJul 5, 1970 · N6263F · Substantial damage NTSB FTW68F0432Accident · No injuriesClosedCessna 337 · Schulenberg, TXFeb 4, 1968 · N6310F · Substantial damage