NTSB investigations: Cessna 120
10 cases on aircraft the registry lists as Cessna 120, where the sequence of events included Off-field or emergency landing. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2022 | 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.\"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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR25LA265Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 120 · Taylor, AZOn August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.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 CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.NTSB CEN16LA033Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Gonzales, LAMaintenance personnel’s improper installation of the carburetor during recent maintenance, including the omission of a required cotter pin, which resulted in a total loss of engine power.NTSB ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.NTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.