Cessna 120
NTSB investigations · 543
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 NYC83LA232Accident · No injuriesLimited investigationFinal reportCessna 120 · Punxsutawney, PAAccording to the pilot when he entered the aircraft he found that the master switch had been left on and the battery wasdown. He flew around the airport for about 45 min, to recharge the battery prior to departing for his destination. He arrived at his…NTSB CHI83FET02Accident · No injuriesFinal reportCessna 120 · Fort Wayne, INThe engine quit at about 50 ft AGL during the second takeoff near mid rwy. The pilot tried to restart the engine and lost the opportunity to try to land on the remaining rwy. The acft landed in an adjoining soybean field. The left fuel tank was empty. The…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.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 LAX83LA156Accident · No injuriesLimited investigationFinal reportCessna 120 · Long Beach, CAAccording to the pilot during rollout after landing he was making a right turn into a taxiway when a ground loop occurred. The left main gear was sheared during the ground looped and the left wing broke at the strut.NTSB LAX83LA126Accident · No injuriesLimited investigationFinal reportCessna 120 · Prescott, AZThe plt reported he was taxiing in winds that were moderate & gusting. While taxiing, he made s-turns & positioned the controls to compensate for the wind. As he approached the run-up area, he reduced power to slow down. At about that time, the nose suddenly…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.NTSB DEN82FTM01Accident · No injuriesClosedCessna 140 · Ogden, UTNTSB CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNNTSB LAX81FVM13Accident · No injuriesClosedCessna 120 · Watsonville, CANTSB MIA81DKJ05Accident · Minor injuriesClosedCessna 120 · Mexico Beach, FLNTSB FTW81FPD11Accident · No injuriesClosedCessna 120 · Bolivar, TXNTSB SEA81DYM16Accident · No injuriesClosedCessna 120 · Philomath, ORNTSB DEN81FTE17Accident · No injuriesClosedCessna 120 · Erie, CONTSB MKC81FCD01Accident · Minor injuriesClosedCessna 120 · La Porte City, IANTSB MKC81DCJ02Accident · No injuriesClosedCessna 120 · Aurora, NENTSB DEN80FTC29Accident · Serious injuriesClosedCessna 120 · Afton, WYNTSB ATL80FLG11Accident · Minor injuriesClosedCessna 120 · Union, SCNTSB ANC80DAG70Accident · No injuriesClosedCessna 120 · Egegik, AKNTSB IAD80FID11Accident · Serious injuriesClosedCessna 120 · Camp Hill, VANTSB MKC80FER25Accident · No injuriesClosedCessna 120 · Square Lake, MNNTSB FTW80FPD07Accident · No injuriesClosedCessna 120 · Lawn, TXNTSB LAX80DUJ17Accident · No injuriesClosedCessna 120 · Peoria, AZNTSB FTW80DPJ35Accident · No injuriesClosedCessna 120 · Leedey, OKNTSB CHI79FEC59Accident · 1 fatalClosedCessna 120 · Vassar, MINTSB MIA79FA130Accident · 2 fatalClosedCessna 120 · Vicksburg, MSNTSB MIA79DLA53Accident · No injuriesClosedCessna 120 · Tallahassee, FLNTSB IAD79FA074Accident · Serious injuriesClosedCessna 120 · Riverton, WVNTSB CHI79FEK21Accident · Minor injuriesClosedCessna 120 · Fredericktown, OHNTSB NYC79DNC37Accident · No injuriesClosedCessna 120 · Kents Hill, MENTSB MKC79FA039Accident · 1 fatalClosedCessna 120 · Madison, SDNTSB MIA79FKG50Accident · No injuriesClosedCessna 120 · Lagrange, GANTSB SEA79FA022Accident · 2 fatalClosedCessna 140 · Yakima, WANTSB DEN79DTE10Accident · No injuriesClosedCessna 120 · Englewood, CONTSB IAD79FA006Accident · 1 fatalClosedCessna 120 · Covington, TNNTSB MKC78FA058Accident · 1 fatalClosedCessna 120 · Kimball, NENTSB MKC78FA047Accident · 1 fatalClosedCessna 120 · Abilene, KSNTSB SEA77DTI24Accident · No injuriesClosedCessna 120 · Chester, MTNTSB NYC77FNA28Accident · No injuriesClosedCessna 120 · N.Kingstown, RINTSB NYC77FNC45Accident · No injuriesClosedCessna 120 · Limerick, MENTSB OAK77FA047Accident · 2 fatalClosedCessna 120 · San Ramon, CANTSB MKC77DCG45Accident · No injuriesClosedCessna 120 · Boonville, MONTSB FTW77FPM15Accident · No injuriesClosedCessna 120 · Bristow, OKNTSB NYC77FNE24Accident · No injuriesClosedCessna 120 · Woodbridge, CTNTSB MIA77FKG40Accident · No injuriesClosedCessna 120 · Jackson, GANTSB CHI77FET18Accident · No injuriesClosedCessna 120 · Logansport, IN
Back to Cessna 120