NTSB investigations: Cessna 320A
16 cases on aircraft the registry lists as Cessna 320A. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1992 | 1 |
| 1996 | 2 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074506'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW97LA020Accident · No injuriesLimited investigationFinal reportCessna 320A · Longmont, COThe partial failure of the fuel control servo, causing an excessive flow/output of fuel to, and flooding of, the right engine.NTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…NTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.NTSB ATL82DA111Accident · No injuriesFinal reportCessna 320A · Paintsville, KYThe pilot reported encountering wind shear at about 300 ft from the approach end of runway 31. He stated that the aircraft crabbed to the left and right rudder was applied. Also, he reported that the plane stalled about six to ten feet above the runway and…NTSB NYC81FA041Accident · 2 fatalClosedCessna 320 · West Mifflin, PANTSB OAK79FA036Accident · 2 fatalClosedCessna 320A · Monterey, CANTSB DEN76O0001Accident · 4 fatalClosedCessna 320 · Puerta Valrto, MexicoNTSB OAK74FXQ23Accident · No injuriesClosedCessna 320A · Fallon, NVNTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILNTSB OAK73IP016Incident · No injuriesClosedCessna 320A · Redding, CANTSB DEN68A0028Accident · 1 fatalClosedCessna 320A · Kanosh, UTNTSB DEN68F0034Accident · Serious injuriesClosedCessna 320A · Alamosa, CONTSB OAK67A0080Accident · No injuriesClosedCessna 320A · Montello, NVNTSB CHI66F0579Accident · No injuriesClosedCessna 320 · Saginaw, MINTSB UNK65X1408Accident · No injuriesClosedCessna 320 · Rancho Mirage, CANTSB UNK65X0590Accident · No injuriesClosedCessna 320 · Norfolk, NE