Skip to content

NTSB investigations: Cessna 120, GA

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

19642026

Where

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" = 'GA' 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 ('2071402')) 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\" = 'GA' 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 ('2071402'))
  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" = 'GA' 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 ('2071402'))
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 ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 24, 2011 · N3101N · Substantial damage NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.Jan 12, 2009 · N57N · Substantial damage NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.Sep 19, 2008 · N77068 · Substantial damage NTSB ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.Nov 18, 2005 · N57N · Substantial damage NTSB ATL89FA005Accident · Serious injuriesField investigationFinal reportCessna 120 · Monroe, GAThe pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…Oct 5, 1988 · N77458 · Destroyed NTSB ATL82DA277Accident · No injuriesFinal reportCessna 120 · Hawkinsville, GAThe aircraft nosed over while landing in a peanut field. The pilot reported that the terrain was softer than he realized, and when he applied brake pressure, the plane nosed over. He believed the accident would not have occurred it brakes had not been applied.Sep 16, 1982 · N2103V · Substantial damage NTSB MIA79FKG50Accident · No injuriesClosedCessna 120 · Lagrange, GAJun 8, 1979 · N1845N · Substantial damage NTSB MIA77FKG40Accident · No injuriesClosedCessna 120 · Jackson, GAJun 23, 1977 · N3104N · Substantial damage NTSB MIA77DKG16Accident · No injuriesClosedCessna 120 · Dawsonville, GAJan 27, 1977 · N76278 · Substantial damage NTSB MIA76FKG57Accident · No injuriesClosedCessna 120 · St Simon Is, GAApr 20, 1976 · N2942N · Substantial damage NTSB MIA76AM045Accident · 2 fatalClosedCessna 120 · Warner Robins, GANov 22, 1975 · N3593V · Destroyed NTSB MIA76FKG28Accident · Serious injuriesClosedCessna 120 · Athens, GAOct 20, 1975 · N1809N · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 120 · Stockbridge, GAOct 6, 1974 · N2481N · Substantial damage NTSB MIA75FKG33Accident · Minor injuriesClosedCessna 120 · Dawson, GASep 23, 1974 · N1875N · Substantial damage NTSB MIA71AM035Accident · 2 fatalClosedCessna 120 · Marietta, GAOct 23, 1970 · N89865 · Destroyed NTSB MIA71AM001Accident · 1 fatalClosedCessna 120 · Ringgold, GAJul 4, 1970 · N77269 · Destroyed NTSB MIA70D0275Accident · No injuriesClosedCessna 120 · Savannah, GAOct 16, 1969 · N1600V · Substantial damage NTSB MIA69F0157Accident · Serious injuriesClosedCessna 120 · Jonesboro, GAJun 30, 1968 · N1737N · Substantial damage NTSB MIA66D0617Accident · No injuriesClosedCessna 120 · Milledgeville, GAJun 5, 1966 · N3678V · Substantial damage NTSB MIA66D0468Accident · No injuriesClosedCessna 120 · Jonesboro, GAMar 1, 1966 · N2918N · Substantial damage NTSB MIA66D0265Accident · No injuriesClosedCessna 120 · Chamblee, GAOct 3, 1965 · N3185N · Substantial damage NTSB UNK64X0539Accident · Minor injuriesClosedCessna 120 · Cuthbert, GAFeb 11, 1964 · N1771N · Destroyed