NTSB investigations: Cessna 120, AR

12 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

NTSB investigations: Cessna 120, AR per year, 1969–2026: 12 cases
1969	2
1971	1
1972	3
1974	1
1987	1
1990	1
1991	1
2004	1
2011	1

Where

Open the map

Latest cases

Query with SQL

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" = 'AR' 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

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\" = 'AR' 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" = 'AR' 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

Run 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 CEN11CA644Accident · No injuriesData collectionFinal reportCessna 120 · Camden, ARThe flight instructor's inadvertent braking during taxi.Sep 12, 2011 · N89954 · Substantial damage NTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.Jan 26, 2004 · N1961V · Substantial damage NTSB DEN91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Fayetteville, ARThe pilot failed to apply carburetor heat.Jun 3, 1991 · N76404 · Substantial damage NTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.Mar 4, 1990 · N90061 · Substantial damage NTSB MKC87LA039Accident · No injuriesLimited investigationFinal reportCessna 120 · Salem, ARThe airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure…Jan 8, 1987 · N72516 · Substantial damage NTSB FTW74FPG81Accident · Serious injuriesClosedCessna 120 · Altheimer, ARJun 27, 1974 · N1769V · Destroyed NTSB FTW73DPG33Accident · No injuriesClosedCessna 120 · Beebe, ARNov 5, 1972 · N76602 · Substantial damage NTSB FTW73DPG29Accident · No injuriesClosedCessna 120 · Corning, AROct 12, 1972 · N76324 · Substantial damage NTSB FTW73DPG20Accident · No injuriesClosedCessna 120 · Lakeview, ARSep 17, 1972 · N89729 · Substantial damage NTSB FTW71FPG42Accident · No injuriesClosedCessna 120 · Van Buren, ARMar 20, 1971 · N4257N · Substantial damage NTSB FTW70F0301Accident · Minor injuriesClosedCessna 120 · Mena, ARNov 15, 1969 · N1958V · Substantial damage NTSB FTW70F0143Accident · Serious injuriesClosedCessna 120 · Osceola, ARJul 30, 1969 · N1769V · Substantial damage