NTSB investigations: Cessna 120, OH
18 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 |
|---|---|
| 1966 | 4 |
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2014 | 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\" = 'OH' 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" = 'OH' 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 CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB NYC97LA147Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Napoleon, OHThe pilot's decision to take off with inadequate fuel.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 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 CHI79FEK21Accident · Minor injuriesClosedCessna 120 · Fredericktown, OHNTSB CHI74FEI42Accident · No injuriesClosedCessna 120 · N Bass Islnd, OHNTSB CHI74DEI24Accident · Minor injuriesClosedCessna 120 · Valley City, OHNTSB CHI72DEI19Accident · Minor injuriesClosedCessna 120 · Milan, OHNTSB CHI70DGD25Accident · Minor injuriesClosedCessna 120 · Burton, OHNTSB CHI70DGD15Accident · No injuriesClosedCessna 120 · Toledo, OHNTSB CHI70D0308Accident · No injuriesClosedCessna 120 · Huron, OHNTSB CHI70D0145Accident · No injuriesClosedCessna 120 · Columbia Sta, OHNTSB CHI68F0114Accident · No injuriesClosedCessna 120 · Columbus, OHNTSB CHI67F0275Accident · No injuriesClosedCessna 120 · Oxford, OHNTSB CHI66F0784Accident · No injuriesClosedCessna 120 · Delaware, OHNTSB CHI66D0679Accident · No injuriesClosedCessna 120 · Canton, OHNTSB CHI66D0557Accident · No injuriesClosedCessna 120 · Wooster, OHNTSB UNK65X1027Accident · No injuriesClosedCessna 120 · Avon, OH