Skip to content

NTSB investigations: Cessna 182J, TX

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

19662026

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 ('2072722')) 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 ('2072722'))
  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 ('2072722'))
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 CEN16LA270Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXAn electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…Jul 19, 2016 · N2644F · Substantial damage NTSB CEN16LA068Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Baytown, TXThe pilot's failure to maintain directional control during landing in gusting wind conditions.Dec 19, 2015 · N2694F · Substantial damage NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.Oct 23, 2005 · N3331F · Substantial damage NTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.May 16, 1996 · N3160F · Substantial damage NTSB FTW84LA175Accident · No injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXThe acft landed long & fast with a 10 kt tailwind. The pilot was unable to stop the acft on the remaining rwy & ran of of the end. The left brake was found inop due to a lack of brake fluid. The acft was observed to veer to the right of the rwy prior to…Mar 26, 1984 · N2689F · Substantial damage NTSB FTW82DA271Accident · No injuriesFinal reportCessna 182J · Munester, TXDuring flight, the engine began losing power and both occupants detected a strong odor of gasoline. The pilot made a successful forced landing in a field. He stated that the engine lost all power on final approach. After coming to a stop, the pilot and…Jul 7, 1982 · N2405Q · Destroyed NTSB FTW82DA091Accident · No injuriesFinal reportCessna 182J · Boerne, TXThe pilot attempted a landing on a rough grass strip between two hills. Ground turbulence was encountered and the aircraft stalled. The aircraft bounced and when the pilot attempted a power recovery he collided with a fence.Mar 13, 1982 · N3514F · Substantial damage NTSB FTW82DQG02Accident · No injuriesClosedCessna 182J · Muleshoe, TXOct 23, 1981 · N3316F · Substantial damage NTSB FTW78FRJ12Accident · Serious injuriesClosedCessna 182J · Hemphill, TXMar 18, 1978 · N3105F · Substantial damage NTSB FTW76DRA32Accident · No injuriesClosedCessna 182 · Bellville, TXApr 22, 1976 · N2786F · Substantial damage NTSB FTW76FRG16Accident · Serious injuriesClosedCessna 182J · Austin, TXAug 22, 1975 · N3569S · Destroyed NTSB FTW75DQG53Accident · No injuriesClosedCessna 182 · Dalhart, TXApr 27, 1975 · N3307F · Substantial damage NTSB FTW73FPA27Accident · No injuriesClosedCessna 182R · Addison, TXMar 24, 1973 · N3302F · Substantial damage NTSB FTW73DQG34Accident · No injuriesClosedCessna 182 · Big Spring, TXMar 10, 1973 · N3193F · Substantial damage NTSB FTW71DQD28Accident · No injuriesClosedCessna 182 · Sierra Blanca, TXJun 29, 1971 · N3158F · Substantial damage NTSB FTW69F0537Accident · No injuriesClosedCessna 182J · Victoria, TXMay 10, 1969 · N2724F · Substantial damage NTSB FTW68F0464Accident · No injuriesClosedCessna 182J · Andrews, TXFeb 21, 1968 · N3112F · Substantial damage NTSB FTW67F0487Accident · No injuriesClosedCessna 182 · El Paso, TXMar 20, 1967 · N3312F · Substantial damage NTSB FTW66F0559Accident · No injuriesClosedCessna 182 · Dalhart, TXMar 17, 1966 · N2675F · Substantial damage