NTSB investigations: Cessna 172L, WA
17 cases on aircraft the registry lists as Cessna 172L. 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
| 1972 | 1 |
|---|---|
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1982 | 1 |
| 1988 | 3 |
| 1992 | 1 |
| 1994 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2009 | 1 |
| 2016 | 1 |
| 2017 | 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 ('2072432'))
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 ('2072432'))
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 GAA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Twisp, WAThe pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.NTSB WPR16LA090Accident · No injuriesLimited investigationFinal reportCessna 172L · McNeil Island, WAThe student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB SEA00LA180Accident · No injuriesLimited investigationFinal reportCessna 172L · Everett, WAThe other pilot's improper use (inadvertent release) of the brakes. Contributing factors were, a standing aircraft and the other pilot's diverting his attention from outside his aircraft.NTSB SEA98LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Puyallup, WAThe pilot-in-command's failure to refuel en-route resulting in fuel exhaustion. Contributing factors were a vehicle (in the landing path) and dark night conditions.NTSB SEA98FA170Accident · 1 fatalField investigationFinal reportCessna 172L · Anacortes, WATerrain clearance was not maintained. A low ceiling and the pilot's inadequate in-flight planning/decision were factors.NTSB SEA94LA102Accident · No injuriesLimited investigationFinal reportCessna 172L · Colville, WAThe pilot's failure to attain a proper touchdown point, and his excessive airspeed at the point of touchdown. Factors include the student pilot's lack of recent experience, and a ravine off the end of the runway.NTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.NTSB SEA88LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Leavenworth, WAOn initial climb over trees bordering 2500-FT mountain strip, plt experienced sudden and severe wind gusts beyond his capability to counter. Acft collided with trees and terrain.NTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…NTSB SEA88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.NTSB SEA83LA031Accident · No injuriesLimited investigationFinal reportCessna 172L · Vancouver, WAAfter landing, the pilot began taxiing to the parking area. While taxiing, he came to an area where he tried to taxi between a fuel truck and a Beech baron. The pilot stated that he misjudged the distance between his right wing tip and the fuel truck and the…NTSB SEA76DYE51Accident · No injuriesClosedCessna 172L · Raymond, WANTSB SEA74AS031Accident · 2 fatalClosedCessna 172L · Goldendale, WANTSB SEA74AS013Accident · 2 fatalClosedCessna 172 · Packwood, WANTSB SEA74FYE08Accident · Minor injuriesClosedCessna 172 · Kent, WANTSB SEA72DYE32Accident · No injuriesClosedCessna 172 · Seattle, WA