NTSB investigations: Cessna 120
16 cases on aircraft the registry lists as Cessna 120, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 2000 | 1 |
| 2006 | 2 |
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\" = 353))
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" = 353))
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 NYC06CA188Accident · No injuriesData collectionFinal reportCessna 120 · Ashland, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.NTSB CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.NTSB LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.NTSB LAX92LA097Accident · No injuriesLimited investigationFinal reportCessna 120 · Sonoma, CAEngine failure due to a binding mixture control shaft. The binding mixture control shaft was the result of inadequate maintenance which allowed the accumulation of moisture and water in the carburetor to remain for an extended period of time causing rust and…NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB NYC91LA146Accident · No injuriesLimited investigationFinal reportCessna 120 · Delaware, OHCarburetor ice and the pilot in command's improper use of carburetor heat. A factor in the accident was the carburetor icing conditions.NTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.NTSB ATL90LA062Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Atmore, ALFuel starvation due to an inadequate preflight and improper positioning of the fuel selector. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI89LA008Accident · Minor injuriesLimited investigationFinal reportCessna 120 · St Peter, MNThe plt had intended to make a touch-&-go landing on a grass strip, but stated that he came in 'somewhat high.' He rprtd the acft was still airborne about halfway down the rwy when he elected to go around. He attempted to add power, but the eng 'sputtered &…NTSB ATL89FA005Accident · Serious injuriesField investigationFinal reportCessna 120 · Monroe, GAThe pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…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…NTSB CHI84LA372Accident · No injuriesLimited investigationFinal reportCessna 120 · Hopedale, ILThe acft nosed over during a forced landing in a corn field after the engine quit. The plt said he was operating on the left tank and when the engine sputtered he realized what was wrong and even though he immediately switched tanks the engine quit and did…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.