Skip to content

NTSB investigations: Cessna 182E, TX

24 cases on aircraft the registry lists as Cessna 182E. 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 ('2072712')) 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 ('2072712'))
  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 ('2072712'))
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 CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.Sep 26, 2021 · N3293Y · Substantial damage NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.Mar 3, 2017 · N2892Y · Substantial damage NTSB LAX03LA179Accident · No injuriesLimited investigationFinal reportCessna 182E · Bryan, TXThe presence of foreign material in the carburetor intake venturi, which resulted in a partial loss of engine power during takeoff, and a subsequent off-airport forced landing.May 23, 2003 · N9389X · Substantial damage NTSB FTW82FRG30Accident · 2 fatalFinal reportCessna 182E · Armstrong, TXBefore taking off, the pilot reviewed the weather in person at the college station fss, but declined an official weather briefing. He departed in good VFR conditions and flew into an area of known and forcasted low ceilings. While en route, his flight path…May 10, 1982 · N9330X · Destroyed NTSB FTW80FA026Accident · 2 fatalClosedCessna 182E · Comfort, TXDec 21, 1979 · N2853Y · Destroyed NTSB FTW79FPM07Accident · Serious injuriesClosedCessna 182 · El Paso, TXApr 21, 1979 · N9361X · Substantial damage NTSB FTW79FRJ08Accident · No injuriesClosedCessna 182E · Tyler, TXFeb 12, 1979 · N3283Y · Substantial damage NTSB FTW78DRA01Accident · No injuriesClosedCessna 182 · Sargent, TXOct 8, 1977 · N3135Y · Substantial damage NTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXDec 10, 1976 · N3091Y · Destroyed NTSB FTW76AF054Accident · 2 fatalClosedCessna 182E · Mountain Home, TXJan 1, 1976 · N2921Y · Destroyed NTSB FTW75FQG11Accident · Serious injuriesClosedCessna 182E · White Deer, TXJul 24, 1974 · N2943Y · Destroyed NTSB FTW71DQG71Accident · No injuriesClosedCessna 182 · Snyder, TXMay 19, 1971 · N9224X · No damage NTSB FTW70D0136Accident · No injuriesClosedCessna 182E · Addison, TXAug 11, 1969 · N9376X · Substantial damage NTSB FTW68D0458Accident · No injuriesClosedCessna 182 · Aspermont, TXDec 22, 1967 · N9360X · Substantial damage NTSB FTW67D0331Accident · No injuriesClosedCessna 182 · Hamilton, TXNov 17, 1966 · N2889Y · Substantial damage NTSB FTW67D0190Accident · No injuriesClosedCessna 182 · Brownfield, TXAug 30, 1966 · N3183Y · Substantial damage NTSB FTW67D0150Accident · No injuriesClosedCessna 182 · Katy, TXAug 6, 1966 · N3023Y · Substantial damage NTSB FTW67D0097Accident · No injuriesClosedCessna 182E · Umbarger, TXJul 16, 1966 · N3330Y · Substantial damage NTSB FTW66D0687Accident · No injuriesClosedCessna 182E · San Antonio, TXApr 3, 1966 · N2889Y · Substantial damage NTSB FTW65A0088Accident · 2 fatalClosedCessna 182E · Needville, TXMar 11, 1965 · N9314X · Destroyed NTSB UNK65X1008Accident · No injuriesClosedCessna 182E · Austin, TXDec 14, 1964 · N3012Y · Substantial damage NTSB UNK64X2791Accident · No injuriesClosedCessna 182 · Matagorda Bea, TXJul 12, 1964 · N2889Y · Substantial damage NTSB UNK64X2299Accident · No injuriesClosedCessna 182E · Wimberly, TXJun 15, 1964 · N2934Y · Substantial damage NTSB UNK64X0304Accident · No injuriesClosedCessna 182E · El Paso, TXJan 20, 1964 · N2814Y · Substantial damage