Skip to content

NTSB investigations: Cessna 182M, TX

21 cases on aircraft the registry lists as Cessna 182M. 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

19692026

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 ('2072728')) 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 ('2072728'))
  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 ('2072728'))
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 CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.Nov 25, 2010 · N182DG · Substantial damage NTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.Mar 30, 2010 · N71229 · Substantial damage NTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.May 30, 1993 · N91633 · Destroyed NTSB FTW85LA301Accident · No injuriesLimited investigationFinal reportCessna 182M · Tulia, TXThe student plt, with 2 hrs total night experience, flared high on final and stalled the acft, which subsequently landed hard on the nose gear, during a night practice flt. The plt stated that the red instrument lights would not work when he turned them on.…Jul 4, 1985 · N71846 · Substantial damage NTSB FTW85LA269Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pearsall, TXA commercially rated CFI departed on a part 135 air taxi flt, but encountered deteriorating weather conditions. Circling his destination he reported that rain clouds closed in. Anticipating that he would be unable to file IFR in the air, he elected to land in…Jun 28, 1985 · N200KH · Substantial damage NTSB FTW84LA313Accident · No injuriesLimited investigationFinal reportCessna 182M · Georgetown, TXWhile on a x-country flight the acft experienced a bird strike. The plt elected to return to the departure airfield for a precautionary landing. She made two hard landings on the first approach and then recovered and made a go-around. On the next approach she…Jun 30, 1984 · N71879 · Substantial damage NTSB FTW80FRG19Accident · Minor injuriesClosedCessna 182 · Rio Hondo, TXJan 7, 1980 · N71209 · Substantial damage NTSB FTW78FPD19Accident · No injuriesClosedCessna 182M · Granbury, TXMay 1, 1978 · N71202 · Substantial damage NTSB FTW77DPD31Accident · No injuriesClosedCessna 182P · Arlington, TXJul 1, 1977 · N71187 · Substantial damage NTSB FTW77DQD12Accident · No injuriesClosedCessna 182 · El Paso, TXFeb 22, 1977 · N70988 · Substantial damage NTSB FTW76DPD28Accident · No injuriesClosedCessna 182 · Keller, TXJan 20, 1976 · N70646 · Substantial damage NTSB FTW75AF020Accident · 2 fatalClosedCessna 182M · Hillsboro, TXSep 15, 1974 · N71038 · Destroyed NTSB FTW72DRA29Accident · No injuriesClosedCessna 182 · Kountze, TXNov 24, 1971 · N71038 · Substantial damage NTSB FTW71FQG06Accident · No injuriesClosedCessna 182M · Lubbock, TXJul 17, 1970 · N70981 · Substantial damage NTSB FTW71DPD03Accident · No injuriesClosedCessna 182M · Abilene, TXJul 15, 1970 · N70993 · Substantial damage NTSB FTW70FPD15Accident · Serious injuriesClosedCessna 182M · Smithfield, TXJun 21, 1970 · N71030 · Substantial damage NTSB FTW70DRA26Accident · No injuriesClosedCessna 182 · Halletsville, TXMay 22, 1970 · N71038 · Substantial damage NTSB FTW70DRA08Accident · No injuriesClosedCessna 182 · Galveston, TXFeb 14, 1970 · N71074 · Substantial damage NTSB FTW70FBG06Accident · No injuriesClosedCessna 182 · Addison, TXJan 8, 1970 · N70988 · Substantial damage NTSB FTW70F0329Accident · No injuriesClosedCessna 182 · Bay City, TXDec 13, 1969 · N92099 · Substantial damage NTSB FTW70D0045Accident · No injuriesClosedCessna 182M · Brownsville, TXApr 26, 1969 · N71456 · Substantial damage