NTSB investigations: Cessna 172D, WA
13 cases on aircraft the registry lists as Cessna 172D. 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
| 1965 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1977 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 2004 | 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 ('2072410'))
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 ('2072410'))
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 WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA16CA286Accident · No injuriesData collectionFinal reportCessna 172 · Arlington, WAThe failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.NTSB SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB SEA87LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Kennewick, WAThe private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but…NTSB SEA78DYP04Accident · No injuriesClosedCessna 172D · Sunnyside, WANTSB SEA72FYE06Accident · No injuriesClosedCessna 172 · Renton, WANTSB SEA71DWD10Accident · Serious injuriesClosedCessna 172 · Arlington, WANTSB SEA69F0192Accident · Minor injuriesClosedCessna 172 · Port Orchard, WANTSB SEA69A0017Accident · 2 fatalClosedCessna 172 · Lopez, WANTSB SEA66D0018Accident · No injuriesClosedCessna 172D · Latah, WANTSB SEA65D0066Accident · No injuriesClosedCessna 172 · Yakima, WA