NTSB investigations: Cessna 120, IA
18 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 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 2018 | 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\" = 'IA' 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" = 'IA' 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 CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB MKC84LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Larchwood, IAThe acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt…NTSB MKC81FCD01Accident · Minor injuriesClosedCessna 120 · La Porte City, IANTSB MKC77DCD03Accident · No injuriesClosedCessna 120 · Forest City, IANTSB MKC75FCD35Accident · Minor injuriesClosedCessna 120 · Dallas Center, IANTSB MKC74FCD45Accident · Minor injuriesClosedCessna 120 · Keosauqa, IANTSB MKC74FCD39Accident · No injuriesClosedCessna 120 · Hampton, IANTSB MKC73DCD67Accident · No injuriesClosedCessna 120 · Fort Dodge, IANTSB MKC73DCD60Accident · No injuriesClosedCessna 120 · Councl Bluff, IANTSB MKC72DCD55Accident · No injuriesClosedCessna 120 · Forest City, IANTSB MKC71DCD31Accident · No injuriesClosedCessna 120 · Fairfield, IANTSB MKC71DCD22Accident · No injuriesClosedCessna 120 · Gravity, IANTSB MKC70F0281Accident · Serious injuriesClosedCessna 120 · Riverton, IANTSB MKC68D0593Accident · No injuriesClosedCessna 120 · Dallas Ctr., IANTSB MKC67D0395Accident · No injuriesClosedCessna 120 · Marion, IANTSB MKC66D0385Accident · No injuriesClosedCessna 120 · Des Moines, IANTSB UNK64X3103Accident · No injuriesClosedCessna 120 · Laporte City, IA