NTSB investigations: Cessna 120, MN
17 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 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 3 |
| 1967 | 2 |
| 1973 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2006 | 2 |
| 2013 | 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.\"eventStateOrRegion\" = 'MN' 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" = 'MN' 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" 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 CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.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 CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.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 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 CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNNTSB MKC80FER25Accident · No injuriesClosedCessna 120 · Square Lake, MNNTSB MKC74FER14Accident · Serious injuriesClosedCessna 120 · Ulen, MNNTSB MKC68D0040Accident · No injuriesClosedCessna 120 · Blaine, MNNTSB MKC67F0493Accident · Minor injuriesClosedCessna 120 · St.Cloud, MNNTSB MKC67D0384Accident · No injuriesClosedCessna 120 · Buyek, MNNTSB MKC67F0274Accident · No injuriesClosedCessna 120 · Rosemount, MNNTSB MKC66F0583Accident · No injuriesClosedCessna 120 · Rosemount, MNNTSB MKC66F0378Accident · No injuriesClosedCessna 120 · Eveleth, MNNTSB CHI66F0072Accident · No injuriesClosedCessna 120 · Fergus Falls, MNNTSB UNK64X1156Accident · No injuriesClosedCessna 120 · Robbinsdale, MN