NTSB investigations: Cessna 172C, WA

6 cases on aircraft the registry lists as Cessna 172C. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

NTSB investigations: Cessna 172C, WA per year, 1968–2026: 6 cases
1968	1
1972	1
1977	1
1987	1
1993	1
1997	1

Where

Open the map

Latest cases

Query with SQL

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 ('2072408')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072408'))
  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 ('2072408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 SEA97LA134Accident · No injuriesLimited investigationFinal reportCessna 172C · Fall City, WAthe pilot's selection of unsuitable terrain for landing. The soft, wet terrain was a related factor.Jun 11, 1997 · N1319Y · Substantial damage NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.Apr 25, 1993 · N1406Y · Destroyed NTSB SEA87LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Eatonville, WAThe student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and…Jan 12, 1987 · N1815Y · Destroyed NTSB SEA77FYE27Accident · Minor injuriesClosedCessna 172 · Olga, WAJul 8, 1977 · N8441X · Substantial damage NTSB SEA73FYE18Accident · Serious injuriesClosedCessna 172 · Longmire, WANov 12, 1972 · N1837Y · Destroyed NTSB SEA69D0069Accident · No injuriesClosedCessna 172 · Orchards, WAJul 8, 1968 · N1846Y · Substantial damage