NTSB investigations: Cessna 305A, TX

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

19672026

NTSB investigations: Cessna 305A, TX per year, 1967–2026: 15 cases
1967	1
1968	1
1972	1
1977	2
1979	2
1985	1
1986	1
2011	1
2015	1
2016	1
2017	1
2019	1
2022	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."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 ('2074002')) 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 ('2074002'))
  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 ('2074002'))
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 CEN22LA325Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305A · Mc Kinney, TXThe failure of the pilot to maintain adequate airspeed during landing resulting in an inadvertent aerodynamic stall.Jul 15, 2022 · N5292G · Substantial damage NTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.Oct 17, 2019 · N5073Y · Substantial damage NTSB GAA17CA460Accident · No injuriesData collectionFinal reportCessna 305 · Eagle Lake, TXThe pilot’s loss of directional control during landing in variable wind conditions.Jul 29, 2017 · N72BD · Substantial damage NTSB GAA17CA050Accident · No injuriesData collectionFinal reportCessna 305 · Llano, TXThe pilot's failure to maintain directional control during the landing roll in cross wind conditions.Oct 21, 2016 · N5075S · Substantial damage NTSB GAA15CA242Accident · No injuriesData collectionFinal reportCessna 305A · Midlothian, TXThe failure of the brake line tubing for the right main landing gear brake, due to a non-standard method used to secure the brake line, which resulted in a loss of control during landing, and a ground loop.Aug 29, 2015 · N5255G · Substantial damage NTSB CEN12LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Fredericksburg, TXThe pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.Nov 30, 2011 · N6735Q · Substantial damage NTSB FTW87LA030Accident · No injuriesLimited investigationFinal reportCessna 305A · Mason, TXPrivate pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and…Dec 9, 1986 · N5211G · Destroyed NTSB FTW85LA333Accident · Serious injuriesLimited investigationFinal reportCessna 305A · League City, TXThe plt, while setting up for an aerial banner tow pick up, failed to properly divide his attention between his flt duties and observing another acft which was also in the traffic pattern. He allowed the acft to stall without sufficientalt to recover before…Aug 25, 1985 · N6393T · Destroyed NTSB FTW80DRG14Accident · No injuriesClosedCessna 305 · Fort Hood, TXDec 8, 1979 · N13025 · Substantial damage NTSB FTW79FQG31Accident · No injuriesClosedCessna 305A · Amarillo, TXApr 4, 1979 · N6996N · Substantial damage NTSB FTW78DQD06Accident · No injuriesClosedCessna 305A · Wink, TXDec 11, 1977 · N5233G · Substantial damage NTSB FTW77DRG61Accident · No injuriesClosedCessna 305A · Georgetown, TXJul 22, 1977 · N5314G · Substantial damage NTSB FTW72DQG37Accident · No injuriesClosedCessna 305A · Pampa, TXApr 10, 1972 · N5181G · Substantial damage NTSB FTW68F0478Accident · No injuriesClosedCessna 305A · Humble, TXFeb 25, 1968 · N1830 · Substantial damage NTSB FTW67F0412Accident · No injuriesClosedCessna 305A · Cedar Hill, TXJan 22, 1967 · N1831 · Substantial damage