NTSB investigations: Cessna 320, CA

10 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

19652026

NTSB investigations: Cessna 320, CA per year, 1965–2026: 10 cases
1965	1
1967	1
1971	1
1975	1
1976	3
1982	1
1996	1
2006	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" = 'CA' 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 ('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.\"eventStateOrRegion\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('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 LAX06CA171Accident · No injuriesData collectionFinal reportCessna 320 · Long Beach, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.May 14, 2006 · N5799X · Substantial damage NTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…Apr 28, 1996 · N5752X · Substantial damage 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 LAX77FUQ01Accident · Minor injuriesClosedCessna 320 · Oxnard, CAOct 12, 1976 · N5740X · Substantial damage NTSB LAX78FA074Accident · 4 fatalClosedCessna 320 · Santa Barbara, CAJul 13, 1976 · N5205X · Destroyed NTSB LAX76FUQ26Accident · Serious injuriesClosedCessna 320A · Granada Hills, CAFeb 5, 1976 · N3011R · Destroyed NTSB LAX75FUG38Accident · No injuriesClosedCessna 320 · Corona, CAMar 30, 1975 · N5739X · Substantial damage NTSB OAK71DVM33Accident · No injuriesClosedCessna 320 · San Jose, CAJan 3, 1971 · N1222D · Substantial damage NTSB LAX68D0133Accident · No injuriesClosedCessna 320 · Imperial, CAOct 4, 1967 · N5739X · Substantial damage NTSB OAK66D0031Accident · No injuriesClosedCessna 320 · Healdsburg, CAApr 15, 1965 · N5739X · Substantial damage