Fatal NTSB investigations: Cessna 320

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

19662026

Fatal NTSB investigations: Cessna 320 per year, 1966–2026: 12 cases
1966	1
1967	1
1969	1
1973	1
1976	1
1977	1
1978	1
1982	1
1985	1
1989	1
1990	1
2020	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 ('2074502')) 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 ('2074502'))
  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 ('2074502'))
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 CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.Jul 1, 2020 · N19AS · Destroyed NTSB FTW90FA171Accident · 1 fatalField investigationFinal reportCessna 320 · Center, TXThe pilot's failure to maintain minimum control speed (VMC) and lack of qualification/training in multi-engine aircraft, which resulted in loss of aircraft control. A factor related to the accident was: failure of the left engine turbocharger, which resulted…Aug 30, 1990 · N377S · Destroyed NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.Oct 28, 1989 · N5725X · Destroyed NTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…Dec 6, 1985 · N5755X · Destroyed NTSB LAX82AA235Accident · 3 fatalFinal reportCessna 320B · San Jose, CAThe C-172M had departed reid-hillview arpt (6 mi east) & improperly entered a right downwind for rwy 30R at San Jose. The C-320B had executed a go-around from rwy 30R due to other traffic & was in a climbing turn also entering downwind for rwy 30R. The C-320B…Jun 26, 1982 · N510BC · 2 aircraft · Destroyed NTSB SEA78FA057Accident · 6 fatalClosedCessna 320 · Anaconda, MTAug 18, 1978 · N24P · Destroyed NTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WISep 11, 1977 · N5719X · Destroyed NTSB LAX78FA074Accident · 4 fatalClosedCessna 320 · Santa Barbara, CAJul 13, 1976 · N5205X · Destroyed NTSB DEN74AD030Accident · 1 fatalClosedCessna 320 · Spanish Fork, UTDec 2, 1973 · N5204X · Destroyed NTSB FTW70A0013Accident · 2 fatalClosedCessna 320 · Burleson, TXSep 7, 1969 · N5773X · Destroyed NTSB NYC68A0045Accident · 6 fatalClosedCessna 320 · Bronx, NYSep 16, 1967 · N5709X · Destroyed NTSB SEA67A0014Accident · 3 fatalClosedCessna 320-1 · Fairview, ORAug 15, 1966 · N5760X · Destroyed