NTSB investigations: Cessna 120
12 cases on aircraft the registry lists as Cessna 120, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 2005 | 1 |
| 2007 | 1 |
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 ('2071402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('2071402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB SEA05LA165Accident · 1 fatalLimited investigationFinal reportCessna 120 · Chiloquin, ORThe pilot's failure to maintain airspeed and a loss of control during a pull-up maneuver. A factor contributing to the accident was the inadvertent stall/spin, which resulted in the subsequent collision with terrain.NTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.NTSB SEA93LA066Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Battleground, WAThe pilot in command's allowing the aircraft to enter a stall/spin condition. Factors contributing to the accident were a tailwind, power lines and trees.NTSB CHI92FA231Accident · 2 fatalField investigationFinal reportCessna 120 · Maple, WIThe non-instrument rated private pilot's failure to maintain aircraft control.NTSB LAX92LA019Accident · 1 fatalLimited investigationFinal reportCessna 120 · Olancha, CAFailure of the pilot to maintain adequate airspeed resulting in an inadvertent stall while on final approach. Factors were the high density altitude and the pilot's poor approach planning.NTSB DEN86LA194Accident · No injuriesLimited investigationFinal reportCessna 120 · Riverton, WYPlt stated after accident '... We could not climb after initial takeoff and a pwr line was coming up so I tried to turn right and the plane stalled.' The density altitude was calculated to be 7,136 feet MSL. The plt stated that he did not lean the mixture for…NTSB ATL86LA151Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Magnolia, KYThe plt was using the acft to drop a tool to a mechanic friend and was flying at low alt toward rising terrain to verify the location where the tool fell. Witnesses said that when the plt exited the acft after the accident he stated he was too low, too slow,…NTSB FTW86FA046Accident · 1 fatalField investigationFinal reportCessna 120 · Whitefield, OKThe pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient…NTSB CHI85LA187Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Strongsville, OHWhile on final apch the headwind changed to a quartering left crosswind. A sudden loss of alt occurred and the acft contacted the displaced threshold and weathervaned into the wind. The acft traveled off the side of the rwy and nosed over in an area of grass.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…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.