NTSB investigations: Cessna 120, PA

9 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

19642026

NTSB investigations: Cessna 120, PA per year, 1964–2026: 9 cases
1964	1
1965	1
1966	1
1967	2
1969	1
1970	1
1983	1
1991	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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.May 28, 1991 · N2714N · Substantial damage NTSB NYC83LA232Accident · No injuriesLimited investigationFinal reportCessna 120 · Punxsutawney, PAAccording to the pilot when he entered the aircraft he found that the master switch had been left on and the battery wasdown. He flew around the airport for about 45 min, to recharge the battery prior to departing for his destination. He arrived at his…Sep 4, 1983 · N77321 · Substantial damage NTSB NYC70DGM14Accident · Minor injuriesClosedCessna 120 · Friedens, PAApr 26, 1970 · N90165 · Substantial damage NTSB NYC70A0044Accident · 2 fatalClosedCessna 120 · Seneca, PAOct 18, 1969 · N72392 · Destroyed NTSB NYC68D0007Accident · No injuriesClosedCessna 120 · Honesdale, PAJul 22, 1967 · N77354 · Substantial damage NTSB NYC67F0683Accident · No injuriesClosedCessna 120 · Tarentum, PAJan 5, 1967 · N77474 · Substantial damage NTSB NYC67D0159Accident · No injuriesClosedCessna 120 · Mineral Point, PAAug 15, 1966 · N1767N · Substantial damage NTSB NYC66F0106Accident · No injuriesClosedCessna 120 · Beaver Falls, PAJun 15, 1965 · N2729N · Substantial damage NTSB UNK64X1305Accident · No injuriesClosedCessna 120 · Monroeville, PAApr 14, 1964 · N4256N · Substantial damage