NTSB investigations: Cessna 120, NC
10 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 | 2 |
|---|---|
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1975 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2016 | 1 |
| 2017 | 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\" = 'NC' 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" = 'NC' 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 GAA18CA027Accident · No injuriesData collectionFinal reportCessna 120 · New Bern, NCThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.NTSB ATL92LA094Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Wilmington, NCThe pilot's failure to obtain proper assistance during the engine starting procedure, and his failure to properly attend to the airplane with the engine running.NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.NTSB IAD75DKM21Accident · No injuriesClosedCessna 120 · Advance, NCNTSB IAD70DLJ02Accident · No injuriesClosedCessna 120 · Chadbourne, NCNTSB IAD70A0011Accident · 1 fatalClosedCessna 120 · Spruce Pine, NCNTSB MIA67F0199Accident · No injuriesClosedCessna 120 · Morganton, NCNTSB IAD75AI030Accident · 1 fatalClosedCessna 120 · Black Mountain, NCNTSB UNK65X1425Accident · No injuriesClosedCessna 120 · Vanceboro, NC