NTSB investigations: Cessna 120, WA
17 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 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 3 |
| 1975 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2014 | 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\" = 'WA' 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" = 'WA' 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 WPR14CA192Accident · Minor injuriesData collectionFinal reportCessna 120 · Colville, WAThe pilot's failure to maintain directional control during the landing roll.NTSB SEA02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Deer Park, WALoss of directional control while landing. A drainage ditch was a factor.NTSB SEA99LA024Accident · No injuriesLimited investigationFinal reportCessna 120 · Omak, WAThe pilot-in-command's failure to maintain directional control. Contributing factors were the snow covered runway and a snowbank (berm) at the runway's edge.NTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…NTSB SEA93LA066Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Battleground, WAThe pilot in command's allowing the aircraft to enter a stall/spin condition. Factors contributing to the accident were a tailwind, power lines and trees.NTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.NTSB SEA79FA022Accident · 2 fatalClosedCessna 140 · Yakima, WANTSB SEA75DYG15Accident · No injuriesClosedCessna 120 · Moses Lake, WANTSB SEA73DYG11Accident · No injuriesClosedCessna 120 · Rockford, WANTSB SEA72DYE29Accident · No injuriesClosedCessna 120 · Seattle, WANTSB SEA73FYG32Accident · No injuriesClosedCessna 120 · George, WANTSB SEA71FWG42Accident · No injuriesClosedCessna 120 · Spokane, WANTSB SEA70DWD04Accident · No injuriesClosedCessna 120 · Auburn, WANTSB SEA68D0134Accident · Minor injuriesClosedCessna 120 · Seattle, WANTSB SEA67D0126Accident · No injuriesClosedCessna 120 · Alderwood, WANTSB SEA66F0021Accident · No injuriesClosedCessna 120 · Brewster, WANTSB UNK64X3784Accident · No injuriesClosedCessna 120 · Vancouver, WA