NTSB investigations: Cessna 120, CO
11 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 3 |
| 1973 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 2007 | 1 |
| 2018 | 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\" = 'CO' 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" = 'CO' 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 CEN19LA006Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Hudson, COThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB DEN07CA052Accident · No injuriesData collectionFinal reportCessna 120 · La Salle, COThe pilot's failure to maintain clearance from the ground. Contributing factors included the pilot's intentional low pass and his misjudging his altitude.NTSB DEN87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Peyton, CONC3004N, registered to the plt, ground looped during takeoff in a right quartering tailwind, with a check plt aboard. The plt said that upon rotation he elected to abort the flt. He abruptly reduced the power, the acft settled to the ground and ground looped.…NTSB DEN81FTE17Accident · No injuriesClosedCessna 120 · Erie, CONTSB DEN79DTE10Accident · No injuriesClosedCessna 120 · Englewood, CONTSB DEN74AD023Accident · 2 fatalClosedCessna 120 · Wiggins, CONTSB DEN70D0145Accident · No injuriesClosedCessna 120 · Akron, CONTSB DEN70D0041Accident · No injuriesClosedCessna 120 · Aurora, CONTSB DEN69D0225Accident · No injuriesClosedCessna 120 · Aurora, CONTSB DEN69D0063Accident · No injuriesClosedCessna 120 · Fort Collins, CONTSB DEN66D0119Accident · No injuriesClosedCessna 120 · Castle Rock, CO