Skip to content

NTSB investigations: Cessna 170A, TX

27 cases on aircraft the registry lists as Cessna 170A. 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 ('2072304')) 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 ('2072304'))
  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 ('2072304'))
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 CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.Nov 2, 2022 · N9244A · Substantial damage NTSB CEN22LA236Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Houston, TXThe pilot’s inability to compensate for a downdraft during the landing flare, which resulted in a hard, bounced landing, and subsequent loss of directional control.Jun 2, 2022 · N1396D · Substantial damage NTSB CEN13CA544Accident · No injuriesData collectionFinal reportCessna 170A · Victoria, TXThe student pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.Sep 11, 2013 · N170TP · Substantial damage NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.Jul 26, 2013 · N5401C · Substantial damage NTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.Jun 4, 2012 · N9753A · Substantial damage NTSB FTW02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Giddings, TXThe failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.Oct 27, 2001 · N4127G · 2 aircraft · Substantial damage NTSB FTW00LA249Accident · No injuriesLimited investigationFinal reportCessna 170A · Mexia, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswind and the pilot's failure to perform a go-around upon encountering a windshift/crosswind.Sep 5, 2000 · N1447D · Substantial damage NTSB FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.Sep 3, 1999 · N3865V · Substantial damage NTSB FTW96LA223Accident · No injuriesLimited investigationFinal reportCessna 170A · Wharton, TXfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.May 19, 1996 · N9131A · Substantial damage NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.Aug 7, 1991 · N9582A · Destroyed NTSB FTW88FA160Accident · 4 fatalField investigationFinal reportCessna 170A · El Paso, TXPilot's impairment due to the influence of alcohol.Sep 3, 1988 · N9101A · Destroyed NTSB FTW88LA098Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Sour Lake, TXThe acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles…May 9, 1988 · N3853V · Destroyed NTSB FTW87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · San Marcos, TXThe student pilot lost directional control when the tail wheel came off the runway. The instructor pilot stated that he was late with corrective action and the aircraft ground looped off the runway.Aug 8, 1987 · N401P · Substantial damage NTSB FTW83LA081Accident · No injuriesLimited investigationFinal reportCessna 170A · Temple, TXThe student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed.Jan 11, 1983 · N1781D · Substantial damage NTSB FTW76DPD43Accident · No injuriesClosedCessna 170 · Weatherford, TXJun 4, 1976 · N9557A · Substantial damage NTSB FTW71FRA18Accident · No injuriesClosedCessna 170A · Pearland, TXSep 13, 1970 · N9560A · Substantial damage NTSB FTW70D0226Accident · No injuriesClosedCessna 170A · Pottsboro, TXSep 14, 1969 · N5566C · Substantial damage NTSB FTW69D0231Accident · No injuriesClosedCessna 170 · Lancaster, TXSep 27, 1968 · N9948A · Substantial damage NTSB FTW68D0325Accident · No injuriesClosedCessna 170 · Kerrville, TXNov 3, 1967 · N9271A · Substantial damage NTSB FTW68F0177Accident · No injuriesClosedCessna 170A · Pearland, TXAug 24, 1967 · N9980A · Substantial damage NTSB FTW67A0081Accident · 1 fatalClosedCessna 170 · Cedar Hill, TXFeb 5, 1967 · N1399D · Destroyed NTSB FTW67D0430Accident · No injuriesClosedCessna 170A · Austin, TXJan 2, 1967 · N1310D · Substantial damage NTSB FTW67F0075Accident · No injuriesClosedGlobe GC-1B · Addison, TXJul 22, 1966 · N3301K · 2 aircraft · Substantial damage NTSB FTW66F0648Accident · Minor injuriesClosedCessna 170A · Spearman, TXMay 1, 1966 · N1789D · Destroyed NTSB FTW65F0037Accident · No injuriesClosedCessna 170 · Corpus Christi, TXApr 25, 1965 · N5567C · Substantial damage NTSB UNK65X1370Accident · Minor injuriesClosedCessna 170A · Henderson, TXJan 29, 1965 · N9572A · Substantial damage NTSB UNK64X0670Accident · No injuriesClosedCessna 170A · Ft Worth, TXFeb 23, 1964 · N1399D · Substantial damage