NTSB investigations: Cessna 172C, TX
12 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1972 | 1 |
| 1975 | 1 |
| 1992 | 1 |
| 2003 | 1 |
| 2018 | 1 |
| 2024 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('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" = '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 ('2072408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Cleburne, TXOn June 9, 2026 at about 1520 central daylight time a Cessna 172C, N1330Y, was substantially damaged when it crashed near Cleburne, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB CEN24LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Weslaco, TXThe student pilot’s failure to maintain control of the airplane during landing.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB FTW03LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Pecos, TXThe failure of the pilot to maintain aircraft control while landing. A contributing factor was the gusty wind condition.NTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB FTW76FRG03Accident · Serious injuriesClosedCessna 172 · Austin, TXNTSB FTW72DPD31Accident · No injuriesClosedCessna 172 · Fort Worth, TXNTSB FTW66F0585Accident · Minor injuriesClosedCessna 172C · Lowake, TXNTSB FTW66F0514Accident · No injuriesClosedCessna 172C · Houston, TXNTSB FTW65D0010Accident · No injuriesClosedCessna 172 · Plainview, TXNTSB UNK64X3341Accident · No injuriesClosedCessna 172 · Goliad, TXNTSB UNK64X1351Accident · No injuriesClosedCessna 172 · Bronte, TX