NTSB investigations: Cessna 175

6 cases on aircraft the registry lists as Cessna 175, where the first occurrence was “In flight encounter with weather”. 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

19842026

NTSB investigations: Cessna 175 per year, 1984–2026: 6 cases
1984	1
1988	2
1990	1
1994	1
2000	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.Nov 12, 2000 · N7360M · Destroyed NTSB LAX94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Currie, NVthe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The snow, mountain obscuration, and icing conditions were factors in this accident.Mar 19, 1994 · N6727E · Substantial damage NTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.Dec 19, 1990 · N6626E · Destroyed NTSB DEN89LA021Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Fort Peck, MTThe plt enctrd hvy snow at night & turned back to find a nearby landing strip that he was familiar with. He recognized a ranch house associated with the strip, but was unable to find the landing area. He began to circle in hopes that someone would turn on the…Oct 27, 1988 · N7403M · Substantial damage NTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…Feb 14, 1988 · N6642E · Substantial damage NTSB DEN84LA302Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Corona, NMAt 0809 hrs, plt obtained telephone weather briefing & was advised VFR flt not recommended for intended route. At 1310 hrs, plt obtained second briefing, VFR flight again not recommended, no improvement expected prior to noon of following day. At 1428 hrs plt…Sep 26, 1984 · N6696E · Destroyed