Skip to content

NTSB investigations: Cessna 182B, TX

23 cases on aircraft the registry lists as Cessna 182B. 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 ('2072706')) 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 ('2072706'))
  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 ('2072706'))
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 CEN20CA355Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Odessa, TXThe pilot's failure to maintain directional control of the airplane during landing.Aug 20, 2020 · N710NA · Destroyed NTSB CEN15LA012Accident · No injuriesLimited investigationFinal reportCessna 182B · Orange, TXThe pilot’s failure to maintain airplane control during a go-around to avoid another airplane that was making a nonstandard approach to the opposing runway. Contributing to the accident was the other pilot’s use of a nonstandard approach while landing on the…Oct 15, 2014 · N2437G · Substantial damage NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.Aug 15, 2009 · N2364G · Minor damage NTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.Aug 20, 1999 · N7277E · Substantial damage NTSB FTW99FA075Accident · 5 fatalField investigationFinal reportCessna 182B · Ozona, TXthe pilot's failure to obtain/maintain clearance from terrain during initial climb after take off. A contributing factor was the dark night.Feb 6, 1999 · N54FC · Destroyed NTSB FTW89LA018Accident · No injuriesLimited investigationFinal reportCessna 182B · El Paso, TXThe pilot said he thought he had enough fuel to keep the airplane airborne for 6 hours but the left tank ran dry in 4.0 hours and the right tank went dry at 4.1 hours. The landing was on a ranch airport but was not on a runway and the forced landing was a…Nov 11, 1988 · N2721G · Substantial damage NTSB FTW85FA065Accident · 2 fatalField investigationFinal reportCessna 182B · Brownsville, TXThe acft hit the stabilization wires on a 300 ft fm radio transmission tower followed by a collision with power- lines. Investigation revealed the plt & passg were enroute to the Brownsville, TX, airport to fly a DC-3 cargo acft to Mexico. At 1453 CST,…Dec 3, 1984 · N2406G · Destroyed NTSB FTW83LA296Accident · No injuriesLimited investigationFinal reportCessna 182B · Lufkin, TXWhile en route, the eng began surging. All instruments had normal indications, except the manifold pressure & tachometer were varying as the eng surged. The acft began losing alt, so the plt elected to land on a highway. He landed in front of several cars,…Jun 26, 1983 · N2550G · Substantial damage NTSB FTW81DRA08Accident · No injuriesClosedCessna 182B · League City, TXNov 24, 1980 · N2504G · Substantial damage NTSB FTW80DPD06Accident · No injuriesClosedCessna 182 · Roanoke, TXNov 7, 1979 · N2309G · Substantial damage NTSB FTW79DRG08Accident · No injuriesClosedCessna 182 · Skidmore, TXNov 10, 1978 · N2437G · Substantial damage NTSB FTW79DQG03Accident · Minor injuriesClosedCessna 182B · Ozona, TXOct 9, 1978 · N7143E · Substantial damage NTSB FTW78DRA25Accident · No injuriesClosedCessna 182 · Buna, TXMay 20, 1978 · N2693G · Substantial damage NTSB FTW76DPD25Accident · No injuriesClosedCessna 182 · Weatherford, TXJan 23, 1976 · N2547G · Substantial damage NTSB FTW75FPD37Accident · No injuriesClosedCessna 182 · Richland Hills, TXApr 21, 1975 · N818H · Substantial damage NTSB FTW75FPA18Accident · No injuriesClosedCessna 182B · Plano, TXFeb 19, 1975 · N2307G · Destroyed NTSB FTW72AF015Accident · 1 fatalClosedCessna 182B · Salt Flat, TXSep 19, 1971 · N7177E · Destroyed NTSB FTW71DRG34Accident · No injuriesClosedCessna 182 · Lampasas, TXOct 11, 1970 · N7202E · Substantial damage NTSB FTW70FRA06Accident · Serious injuriesClosedCessna 182B · Houston, TXJan 17, 1970 · N2475G · Substantial damage NTSB FTW67A0047Accident · 2 fatalClosedCessna 182B · Burnet, TXOct 23, 1966 · N2556G · Destroyed NTSB FTW65A0075Accident · 3 fatalClosedCessna 182 · Pampa, TXJan 21, 1965 · N2271G · Destroyed NTSB UNK65X1298Incident · No injuriesClosedCessna 182B · Mineral Wells, TXJan 17, 1965 · N2427G · 2 aircraft · Minor damage NTSB UNK64X1851Accident · No injuriesClosedCessna 182B · Dallas, TXMay 19, 1964 · N2309G · Substantial damage