NTSB investigations: Cessna 120, 1982
5 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.
Cases per year
| 1964 | 41 |
|---|---|
| 1965 | 46 |
| 1966 | 36 |
| 1967 | 27 |
| 1968 | 25 |
| 1969 | 32 |
| 1970 | 31 |
| 1971 | 20 |
| 1972 | 17 |
| 1973 | 15 |
| 1974 | 20 |
| 1975 | 12 |
| 1976 | 16 |
| 1977 | 14 |
| 1978 | 4 |
| 1979 | 12 |
| 1980 | 7 |
| 1981 | 7 |
| 1982 | 5 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 8 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 11 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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" 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 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.NTSB CHI82DA319Accident · No injuriesFinal reportCessna 120 · St. Paul, MNPilot did not stow starter crank properly. During a landing the aircraft touched down almost sideways, went down on a wingtip and up on its nose. The starter crank was found jammed in the rudder controls.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…NTSB MKC82DA105Accident · No injuriesFinal reportCessna 120 · Gardner, KSDuring takeoff, the aircraft struck a fence near the departure end of the runway. After hitting the fence, it traveled about 37 yards before nosing over in an adjacent wheat field. The field was soft due to recent rains. The pilot said the 1300 ft runway was…NTSB LAX82DA107Accident · Minor injuriesFinal reportCessna 120 · San Andreas, CADuring a three point landing the aircraft started to ground loop. The pilot used rudder and power to recover but the aircraft ran off the side of the runway and struck a tree.