NTSB investigations: Cessna 120, OK
7 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1986 | 1 |
| 1988 | 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\" = 'OK' 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" = 'OK' 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 FTW88FA057Accident · Serious injuriesField investigationFinal reportCessna 120 · Ada, OKThe pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.NTSB FTW86FA046Accident · 1 fatalField investigationFinal reportCessna 120 · Whitefield, OKThe pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient…NTSB FTW80DPJ35Accident · No injuriesClosedCessna 120 · Leedey, OKNTSB FTW77FPM15Accident · No injuriesClosedCessna 120 · Bristow, OKNTSB FTW76FPM01Accident · Minor injuriesClosedCessna 120 · Sand Springs, OKNTSB FTW67D0066Accident · No injuriesClosedCessna 120 · Duncan, OKNTSB UNK64X1571Accident · No injuriesClosedCessna 120 · Okla City, OK