Skip to content

NTSB investigations: Cessna 120, AK

18 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" = 'AK' 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\" = 'AK' 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" = 'AK' 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 ANC24LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Talkeetna, AKA degraded ignition system, which resulted in a total loss of engine power. Contributing to the accident was maintenance personnel’s inadequate inspection of the ignition system.Apr 21, 2024 · N77032 · Substantial damage NTSB ANC20CA054Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Gulkana, AKThe pilot's failure to maintain proper airspeed during final approach to landing, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.May 24, 2020 · N72536 · Substantial damage NTSB ANC14CA024Accident · No injuriesData collectionFinal reportCessna 120 · Fairbanks, AKThe pilot's loss of directional control during landing, resulting in a ground loop.Apr 28, 2014 · N77336 · Substantial damage NTSB ANC04LA081Accident · No injuriesLimited investigationFinal reportCessna 120 · Beluga, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in airplane departing the landing surface into a ditch, and subsequently nosing over in tall bushes. A factor contributing to the accident was soft…Jul 18, 2004 · N1847N · Substantial damage NTSB ANC00LA123Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Iliamna, AKA failure of the pilot to maintain directional control of the airplane. Factors in the accident were the passenger's inadvertent interference with the controls, and a ditch along the runway.Sep 14, 2000 · N72775 · Substantial damage NTSB ANC91LA034Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Atigan Pass, AKThe pilot continued to fly VFR into IFR conditions. Related to the accident were: low ceilings, whiteout conditions, and the mountainous terrain.Mar 11, 1991 · N77316 · Substantial damage NTSB ANC86LA044Accident · No injuriesLimited investigationFinal reportCessna 120 · Lake George, AKThe pilot stated that during a three point landing the main landing gear broke through a thin layer of ice into approximately six inches of snow and then the aircraft went over on its back.Apr 13, 1986 · N3008N · Substantial damage NTSB SEA83LA152Accident · No injuriesLimited investigationFinal reportCessna 120 · Tenakee Springs, AKThe acft nosed over during a forced landing on a rocky beach at night. The pilot did not use carburetor heat during the engine restart attempts.Jul 18, 1983 · N76239 · Substantial damage NTSB ANC80DAG70Accident · No injuriesClosedCessna 120 · Egegik, AKMay 15, 1980 · N1728N · Substantial damage NTSB ANC76DAG85Accident · No injuriesClosedCessna 140 · Birchwood, AKJan 29, 1976 · N77235 · Substantial damage NTSB ANC75DAG62Accident · No injuriesClosedCessna 120 · Kodiak, AKDec 25, 1974 · N77429 · Substantial damage NTSB ANC74FAA74Accident · No injuriesClosedCessna 120 · White Mntn, AKMar 11, 1974 · N2928N · Substantial damage NTSB ANC72FAA32Accident · Serious injuriesClosedCessna 120 · Fairbanks, AKMay 19, 1972 · N1719V · Substantial damage NTSB ANC72DAG84Accident · No injuriesClosedCessna 120 · Hope, AKDec 18, 1971 · N72233 · Substantial damage NTSB ANC71FAG74Accident · Minor injuriesClosedCessna 120 · Eagle River, AKMar 22, 1971 · N72233 · Substantial damage NTSB ANC71FAA07Accident · Minor injuriesClosedCessna 120 · Fairbanks, AKJul 10, 1970 · N77303 · Destroyed NTSB ANC68F0090Accident · No injuriesClosedCessna 120 · Iliamna, AKJan 12, 1968 · N89769 · Substantial damage NTSB UNK64X1557Accident · No injuriesClosedCessna 120 · Nenana, AKMay 2, 1964 · N77377 · Substantial damage