Skip to content

NTSB investigations: Cessna 120, MI

30 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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.Jul 30, 2022 · N2902N · Substantial damage NTSB CEN14CA370Accident · No injuriesData collectionFinal reportCessna 120 · Midland, MIThe pilot's failure to maintain sufficient airspeed and his delayed application of engine power while on short final which resulted in a hard landing.Jul 16, 2014 · N76097 · Substantial damage NTSB CHI89LA178Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Brooklyn, MIFailure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.Aug 31, 1989 · N2101V · Destroyed NTSB CHI85LA306Accident · No injuriesLimited investigationFinal reportCessna 120 · Hart, MIThe pilot on the return leg of a x.country flt failed to visually check his fuel supply and selected an empty tank for takeoff. On liftoff the engine stopped and the pilot attempted to ld on the remaining 300 ft of runway. After touchdown the acft veered off…Jul 22, 1985 · N2785N · Substantial damage NTSB CHI83LA215Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Grandville, MIReportedly, the plt increased the bank angle during a turn to align the acft on final apch, then the plane lost speed & stalled. Subsequently, the acft impacted the ground aprx 480 ft southwest of the rwy threshold. Aprx 10 mi east at grand rapids, MI, the…May 15, 1983 · N3019N · Substantial damage NTSB CHI82DA273Accident · No injuriesFinal reportCessna 120 · Niles, MIThe student was on his second solo flight in evening hours. Reportedly, after he had completed 4 landings, dusk was approaching and the instructor told him to make only 2 more landings. When the student was about ready to takeoff on his 6th pattern, a king…Jul 26, 1982 · N2902N · Substantial damage NTSB CHI79FEC59Accident · 1 fatalClosedCessna 120 · Vassar, MIOct 20, 1979 · N2854N · Destroyed NTSB CHI76FEM29Accident · Minor injuriesClosedCessna 120 · Big Rapids, MIFeb 15, 1976 · N2099V · Substantial damage NTSB CHI76DEM26Accident · No injuriesClosedCessna 120 · Kalamazoo, MIJan 27, 1976 · N2404N · Substantial damage NTSB CHI75DEM09Accident · No injuriesClosedCessna 120 · East Tawas, MIDec 12, 1974 · N89982 · Substantial damage NTSB CHI75FET12Accident · No injuriesClosedCessna 120 · Sodus, MIDec 2, 1974 · N2571N · Substantial damage NTSB CHI75DEM18Accident · No injuriesClosedCessna 120 · Burlington, MIOct 31, 1974 · N2339N · Substantial damage NTSB CHI74FEC37Accident · Serious injuriesClosedCessna 120 · Flushing, MIApr 19, 1974 · N76554 · Substantial damage NTSB CHI74FEC19Accident · No injuriesClosedCessna 120 · Troy, MIOct 27, 1973 · N76610 · Substantial damage NTSB CHI74FEC18Accident · Minor injuriesClosedCessna 120 · Stockbridge, MIOct 25, 1973 · N4085N · Substantial damage NTSB CHI72DEM49Accident · No injuriesClosedCessna 120 · Allegan, MIFeb 12, 1972 · N2571N · Substantial damage NTSB CHI71FEM81Accident · No injuriesClosedCessna 120 · Holland, MIMay 30, 1971 · N3025N · Substantial damage NTSB CHI71FDW40Accident · No injuriesClosedCessna 120 · Flint, MIMar 4, 1971 · N3193N · Substantial damage NTSB CHI70FBJ39Accident · No injuriesClosedCessna 120 · Gobles, MIJun 23, 1970 · N2519N · Substantial damage NTSB CHI70F0353Accident · No injuriesClosedCessna 120 · Cedar Lake, MINov 23, 1969 · N76778 · Substantial damage NTSB CHI70F0125Accident · No injuriesClosedCessna 120 · Salem, MIAug 8, 1969 · N76165 · Substantial damage NTSB CHI68F0588Accident · No injuriesClosedCessna 120 · Saginaw, MIFeb 4, 1968 · N4267N · Substantial damage NTSB CHI68F0199Accident · No injuriesClosedCessna 120 · Sebewaing, MIAug 13, 1967 · N77352 · Substantial damage NTSB CHI66F0494Accident · Minor injuriesClosedCessna 120 · Greenville, MIJan 1, 1966 · N2946N · Substantial damage NTSB CHI66F0164Accident · No injuriesClosedCessna 120 · Negaune, MIAug 20, 1965 · N2978N · Destroyed NTSB CHI66F0126Accident · No injuriesClosedCessna 120 · Holland City, MIJul 29, 1965 · N2519N · Substantial damage NTSB UNK64X1847Accident · Minor injuriesClosedCessna 120 · Watervliet, MIMay 19, 1964 · N77208 · Substantial damage NTSB UNK64X1372Accident · No injuriesClosedCessna 120 · Pontiac, MIApr 19, 1964 · N3601V · Destroyed NTSB UNK64X1244Accident · No injuriesClosedCessna 120 · Detroit, MIApr 10, 1964 · N1913N · Substantial damage NTSB UNK64X0235Accident · No injuriesClosedCessna 120 · Lowell, MIJan 12, 1964 · N2946N · Substantial damage