Fatal NTSB investigations: Cessna 177A

11 cases on aircraft the registry lists as Cessna 177A. 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

19692026

Fatal NTSB investigations: Cessna 177A per year, 1969–2026: 11 cases
1969	2
1970	1
1971	1
1974	1
1978	1
1981	1
1988	1
1990	1
2005	1
2013	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073706')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073706'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073706'))
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 CEN14FA010Accident · 1 fatalField investigationFinal reportCessna 177 · Clayton, OKControlled flight into terrain for reasons that could not be determined from the available evidence.Oct 18, 2013 · N30495 · Substantial damage NTSB NYC05FA140Accident · 1 fatalField investigationFinal reportCessna 177A · S. Hackensack, NJThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and subsequent loss of engine power. A factor in the accident was the pilot's impairment from prescription medication.Sep 3, 2005 · N30491 · Substantial damage NTSB MIA90FA177Accident · 1 fatalField investigationFinal reportCessna 177-A · Gainesville, FLThe pilot's failure to refuel prior to flight.Aug 29, 1990 · N30306 · Substantial damage NTSB ATL89FA015Accident · 3 fatalField investigationFinal reportCessna 177A · La Follette, TNThe plt departed knoxville in VFR conds. There was an area of IFR wx to the north & northwest of knoxville. The wx was forecast to be marginal along his route of flt. The plt rprtd he wanted to depart knoxville on a heading of 360 deg & would be at 2500'. The…Oct 18, 1988 · N30470 · Destroyed NTSB MKC82FA009Accident · 5 fatalClosedCessna 177A · Ellinwood, KSNov 25, 1981 · N30288 · Destroyed NTSB NYC78FA065Accident · 1 fatalClosedCessna 177A · Newfane, NYJun 21, 1978 · N30475 · Substantial damage NTSB OAK75FJA05Accident · 1 fatalClosedCessna 177A · Kamuela, HIOct 22, 1974 · N30283 · Substantial damage NTSB OAK72AP021Accident · 2 fatalClosedCessna 177A · Las Vegas, NVDec 22, 1971 · N30521 · Destroyed NTSB CHI70AC078Accident · 2 fatalClosedCessna 177A · Lexington, OHMay 9, 1970 · N30505 · Destroyed NTSB SEA70A0012Accident · 2 fatalClosedCessna 177A · Spokane, WASep 21, 1969 · N30397 · Destroyed NTSB LAX69A0059Accident · 2 fatalClosedCessna 177A · Corona, CAApr 10, 1969 · N30452 · Destroyed