Skip to content

NTSB investigations: Cessna 182, TX

32 cases on aircraft the registry lists as Cessna 182. 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 ('2072702')) 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 ('2072702'))
  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 ('2072702'))
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 CEN18LA272Accident · No injuriesLimited investigationFinal reportCessna 182 · Odessa, TXAn on-ground fire for reasons that could not be determined based on the available information.Jul 16, 2018 · N182GQ · Substantial damage NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.Dec 12, 2008 · N5495B · Minor damage NTSB DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.Jul 8, 2007 · N5518B · Substantial damage NTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.May 21, 1994 · N6372A · Substantial damage NTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.Aug 10, 1989 · N5703B · Substantial damage NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.Jul 2, 1989 · N5827B · Substantial damage NTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.Apr 27, 1987 · N34S · Substantial damage NTSB FTW84LA106Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Corsicana, TXThe acft collided with wires shortly after takeoff as the plt maneuvered at low altitude. After the collision the acft flew for about 1/4 mile and crashed in an unimproved field on a farm. There was no passenger seat in the acft and the passenger was…Dec 30, 1983 · N46N · Destroyed NTSB FTW82DA278Accident · Minor injuriesFinal reportCessna 182 · Mckinney, TXAfter a normal skydiver drop, the pilot spiraled down for a normal landing on a 2000 ft gravel runway with a powerline at the approach end. The wind was reported as variable at 5 KTS. The pilot reported that during the landing, the aircraft touched down on…Jul 11, 1982 · N5429B · Substantial damage NTSB FTW80FRA08Accident · No injuriesClosedCessna 182 · Spring Creek, TXNov 3, 1979 · N5773B · Substantial damage NTSB FTW78DRG69Accident · No injuriesClosedCessna 182 · Sonora, TXAug 23, 1978 · N3567U · Substantial damage NTSB FTW77DPA26Accident · No injuriesClosedCessna 182 · Trinidad, TXAug 28, 1977 · N5438B · Substantial damage NTSB FTW76DQG53Accident · No injuriesClosedCessna 182 · Dalhart, TXJan 3, 1976 · N6488A · Substantial damage NTSB FTW75DQG84Accident · No injuriesClosedCessna 182 · Lubbock, TXSep 28, 1974 · N6272A · Substantial damage NTSB FTW74FQD04Accident · Minor injuriesClosedCessna 182 · Ft Davis, TXAug 12, 1973 · N4038D · Substantial damage NTSB FTW71AF047Accident · 4 fatalClosedCessna 182 · Junction, TXFeb 14, 1971 · N6492A · Destroyed NTSB FTW69F0376Accident · No injuriesClosedCessna 182 · El Paso, TXFeb 7, 1969 · N6333A · Substantial damage NTSB FTW69A0045Accident · 1 fatalClosedCessna 182 · Athens, TXJan 4, 1969 · N5442B · Destroyed NTSB FTW68A0069Accident · 1 fatalClosedCessna 182 · Kemah, TXJan 5, 1968 · N9382X · Destroyed NTSB FTW68D0337Accident · No injuriesClosedCessna 182 · Mason, TXNov 19, 1967 · N82N · Substantial damage NTSB FTW67F0474Accident · No injuriesClosedCessna 182 · Arlington, TXJan 27, 1967 · N282E · Substantial damage NTSB FTW67F0302Accident · No injuriesClosedCessna 182 · Bryan, TXNov 10, 1966 · N5390B · Substantial damage NTSB FTW67F0033Accident · No injuriesClosedCessna 182 · Dickinson, TXJun 5, 1966 · N6272A · Substantial damage NTSB FTW66D0328Accident · No injuriesClosedCessna 182 · Cedar Hill, TXSep 27, 1965 · N6416A · Substantial damage NTSB FTW66F0267Accident · No injuriesClosedCessna 182 · San Antonio, TXAug 14, 1965 · N5669B · Substantial damage NTSB FTW66D0190Accident · No injuriesClosedCessna 182 · Houston, TXAug 4, 1965 · N5537B · Substantial damage NTSB FTW65F0011Accident · No injuriesClosedCessna 182 · Dallas, TXMar 12, 1965 · N5317B · Substantial damage NTSB UNK65X1198Accident · No injuriesClosedCessna 182 · Houston, TXDec 31, 1964 · N5669B · Substantial damage NTSB UNK65X0644Accident · No injuriesClosedCessna 182 · Houston, TXNov 10, 1964 · N5732B · Substantial damage NTSB UNK65X0126Accident · No injuriesClosedCessna 182 · Burnet, TXOct 3, 1964 · N6345A · Substantial damage NTSB UNK64X3841Accident · No injuriesClosedCessna 182 · Dickinson, TXSep 7, 1964 · N6272A · Substantial damage NTSB UNK64X1129Accident · 1 fatalClosedCessna 182 · Wichita Falls, TXApr 1, 1964 · N6447A · Destroyed