NTSB investigations: Cessna 120, FL
16 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 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2025 | 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\" = 'FL' 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" = 'FL' 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 ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.NTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB MIA03CA113Accident · Minor injuriesData collectionFinal reportCessna 120 · Plant City, FLThe failure of the pilot to maintain control of the airplane resulting in it nosing over during the landing roll.NTSB MIA87LA159Accident · No injuriesLimited investigationFinal reportCessna 120 · Oklawaha, FLThe plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main…NTSB MIA84LA027Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Punta Gorda, FLThe acft departed the rwy when the right main landing gear failed during landing. The plt stated that after landing the acft pulled to the right, he corrected to the left and the acft ground looped. Inspection of the acft revealed that the right main tire and…NTSB MIA81DKJ05Accident · Minor injuriesClosedCessna 120 · Mexico Beach, FLNTSB MIA79DLA53Accident · No injuriesClosedCessna 120 · Tallahassee, FLNTSB MIA72DKT39Accident · No injuriesClosedCessna 140 · Deerfld Beach, FLNTSB MIA70DLD07Accident · Minor injuriesClosedCessna 120 · Brooksville, FLNTSB MIA70D0098Accident · Serious injuriesClosedCessna 120 · Sarasota, FLNTSB MIA69D0434Accident · No injuriesClosedCessna 120 · Homestead, FLNTSB MIA68A0093Accident · 2 fatalClosedCessna 120 · Princeton, FLNTSB MIA68F0263Accident · Serious injuriesClosedCessna 120 · Venice, FLNTSB MIA68D0034Accident · No injuriesClosedCessna 120 · Cocoa, FLNTSB MIA66F0404Accident · Minor injuriesClosedCessna 120 · Hollywood, FLNTSB MIA66A0011Accident · 2 fatalClosedCessna 120 · Brooksville, FL