Skip to content

NTSB investigations: Cessna 175, TX

21 cases on aircraft the registry lists as Cessna 175. 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."eventStateOrRegion" = 'TX' 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 ('2072502')) 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\" = 'TX' 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 ('2072502'))
  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" = 'TX' 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 ('2072502'))
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 CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.Jun 21, 2023 · N9354B · Substantial damage NTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.Jul 20, 2019 · N7013M · Substantial damage NTSB FTW88FA005Accident · Serious injuriesField investigationFinal reportCessna 175 · Crystal City, TXThe plt was attempting a night visual apch to his unlighted pvt strip when the acft struck trees, flew under a pwr line,struck additional trees & subsequently impacted the gnd. The acdnt occurred aprx 2.5 miles short of the threshold. Samples of the plt's…Oct 13, 1987 · N6512E · Destroyed NTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…Jan 31, 1987 · N175RF · Substantial damage NTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…Sep 9, 1984 · N7483M · Substantial damage NTSB FTW82DA225Accident · Minor injuriesFinal reportCessna 175 · Fort Worth, TXDuring a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard.Jun 13, 1982 · N9419B · Substantial damage NTSB FTW76FPA24Accident · Minor injuriesClosedCessna 175 · Dallas, TXJun 8, 1976 · N9259B · Substantial damage NTSB FTW76FPD17Accident · Serious injuriesClosedCessna 175 · Denton, TXOct 25, 1975 · N7122M · Substantial damage NTSB FTW75FPD20Accident · No injuriesClosedCessna 175 · Abilene, TXDec 1, 1974 · N7266M · Destroyed NTSB FTW73DPD43Accident · No injuriesClosedCessna 175 · Poolville, TXJun 10, 1973 · N7229M · Substantial damage NTSB FTW73FPA25Accident · Serious injuriesClosedCessna 175 · Greenville, TXMar 2, 1973 · N7649M · Destroyed NTSB FTW72FRA47Accident · No injuriesClosedCessna 175 · Houston, TXMar 15, 1972 · N7591M · Substantial damage NTSB FTW72DQG15Accident · No injuriesClosedCessna 175 · Seminole, TXAug 10, 1971 · N9446B · Substantial damage NTSB FTW68A0038Accident · 1 fatalClosedCessna 175 · Willis, TXOct 9, 1967 · N7162M · Destroyed NTSB FTW66F0557Accident · Minor injuriesClosedCessna 175 · Wichita Falls, TXMar 17, 1966 · N9406B · Substantial damage NTSB FTW66F0536Accident · No injuriesClosedCessna 175 · Dallas, TXMar 4, 1966 · N9446B · Substantial damage NTSB FTW66D0361Accident · No injuriesClosedCessna 175 · Hemphill, TXNov 5, 1965 · N8185T · Substantial damage NTSB FTW66D0099Accident · No injuriesClosedCessna 175 · Ft Stockton, TXJun 12, 1965 · N7475M · Substantial damage NTSB FTW66F0087Accident · Minor injuriesClosedCessna 175 · Vernon, TXJun 3, 1965 · N7386M · Destroyed NTSB UNK64X4003Accident · No injuriesClosedCessna 175 · Beumont, TXSep 16, 1964 · N7446M · Substantial damage NTSB UNK64X0860Accident · No injuriesClosedCessna 175 · Dallas, TXMar 9, 1964 · N9442B · Substantial damage