Skip to content

Fatal NTSB investigations: Cessna 175A

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

19642026

Where

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 ('2072504')) 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 ('2072504'))
  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 ('2072504'))
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 FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.Aug 22, 1998 · N6874E · Destroyed NTSB SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…Jun 17, 1995 · N6970E · Destroyed NTSB DEN92FA088Accident · 4 fatalField investigationFinal reportCessna 175A · Pagosa Springs, COThe pilot experiencing spatial disorientation and his failure to maintain aircraft control. Factors were: the pilot's total lack of instrument experience and dark night conditions.Aug 29, 1992 · N7032E · Destroyed NTSB LAX92FA305Accident · 4 fatalField investigationFinal reportCessna 175A · Overgaard, AZThe pilot's improper preflight performance planning and decision to operate the airplane over the maximum certified gross weight at a high density altitude airport which resulted in an inadvertent stall. Contributing to the accident was inadequate maintenance…Jul 19, 1992 · N8048T · Destroyed NTSB DEN86FA008Accident · 2 fatalField investigationFinal reportCessna 175A · Jal, NMA witness watched the acft takeoff and disappear in the darkness. The plt had intended to make 3 takeoffs and landings to regain currency for night flying. The acft never returned. The wreckage was found 2 miles north of the arpt the following morning. Wx was…Oct 11, 1985 · N6959E · Destroyed NTSB LAX80FA054Accident · 1 fatalClosedCessna 175A · Searchlight, NVFeb 17, 1980 · N7054E · Destroyed NTSB SEA79FA030Accident · 1 fatalClosedCessna 175A · Paris, IDApr 4, 1979 · N8040T · Destroyed NTSB FTW75AF047Accident · 1 fatalClosedCessna 175 · Abbeville, LADec 31, 1974 · N8066T · Destroyed NTSB CHI72AC049Accident · 2 fatalClosedCessna 175A · New Lebanon, OHDec 7, 1971 · N6820E · Destroyed NTSB DEN71AD039Accident · 1 fatalClosedCessna 175A · Rangely, COApr 22, 1971 · N6807E · Destroyed NTSB MIA70AM068Accident · 1 fatalClosedCessna 175A · Nashville, TNFeb 12, 1970 · N6965E · Destroyed NTSB OAK67A0019Accident · 3 fatalClosedCessna 175 · Kailua, HIAug 6, 1966 · N8058T · Destroyed NTSB SEA66A0055Accident · 4 fatalClosedCessna 175A · Cumberland, WAMay 9, 1966 · N6903E · Destroyed NTSB FTW66A0082Accident · 1 fatalClosedCessna 175A · Cabot, ARMar 27, 1966 · N6934E · Destroyed NTSB LAX66A0013Accident · 1 fatalClosedCessna 175A · Shoshone, CAJul 30, 1965 · N6925E · Destroyed NTSB MIA65A0114Accident · 1 fatalClosedCessna 175 · Houma, LAMay 19, 1965 · N6963E · Destroyed NTSB UNK64X3807Accident · 1 fatalClosedCessna 175A · Idleyld Park, ORSep 5, 1964 · N8074T · Destroyed NTSB UNK64X2987Accident · 3 fatalClosedCessna 175A · Arden, NYJul 23, 1964 · N7034E · Destroyed NTSB UNK64X0210Accident · 2 fatalClosedCessna 175A · Trinidad, COJan 10, 1964 · N7958T · Destroyed