Skip to content

NTSB investigations: Cessna 182L, TX

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

19682026

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 ('2072726')) 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 ('2072726'))
  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 ('2072726'))
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 WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.Jun 3, 2020 · N3107R · Substantial damage NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.Apr 6, 2008 · N42892 · Substantial damage NTSB DFW06CA162Accident · No injuriesData collectionFinal reportCessna 182L · Coupland, TXThe pilot's disorientation. Contributing factors were the prevailing night light condition and the inoperative landing light.Jun 20, 2006 · N42656 · Substantial damage NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.Aug 6, 2001 · N42892 · Substantial damage NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.May 22, 1994 · N42EM · Substantial damage NTSB FTW83FRG04Accident · 2 fatalFinal reportCessna 182L · Near Mcallen, TXThe aircraft departed Mcallen, TX at 1903 CST to an unknown destination. During departure, it was observed heading northwest. About 1 1/2 hrs later, it was again observed in the vicinity, about 7 miles northwest of Mcallen, TX. Witnesses stated that the plane…Dec 20, 1982 · N42717 · Destroyed NTSB FTW82DQG10Accident · No injuriesClosedCessna 182 · Dalhart, TXDec 5, 1981 · N42789 · Substantial damage NTSB FTW80DQG25Accident · No injuriesClosedCessna 182L · Sweetwater, TXJun 6, 1980 · N3307R · Substantial damage NTSB FTW78DQG27Accident · No injuriesClosedCessna 182L · Plainview, TXApr 22, 1978 · N3144R · Substantial damage NTSB FTW76AF115Accident · 4 fatalClosedCessna 182L · Mullin, TXAug 19, 1976 · N42216 · Destroyed NTSB FTW76DRG42Accident · No injuriesClosedCessna 182 · Austin, TXFeb 17, 1976 · N42216 · Substantial damage NTSB FTW76FPD15Accident · No injuriesClosedCessna 182 · Fort Worth, TXOct 10, 1975 · N3328R · Substantial damage NTSB FTW76DPD13Accident · No injuriesClosedCessna 182 · Seymour, TXOct 4, 1975 · N42706 · Substantial damage NTSB FTW75AF050Accident · 2 fatalClosedCessna 182L · Slaton, TXJan 23, 1975 · N42337 · Destroyed NTSB FTW75AF008Accident · 2 fatalClosedCessna 182L · San Antonio, TXAug 17, 1974 · N42791 · Destroyed NTSB FTW70AF065Accident · 2 fatalClosedCessna 182L · Flatonia, TXApr 18, 1970 · N3302R · Destroyed NTSB FTW70FRG29Accident · No injuriesClosedCessna 182L · San Marcos, TXApr 2, 1970 · N42533 · Destroyed NTSB FTW70A0015Accident · 2 fatalClosedCessna 182 · Salt Flat, TXAug 29, 1969 · N42981 · Destroyed NTSB FTW70D0051Accident · No injuriesClosedCessna 182L · Corpus Chrsti, TXJun 9, 1969 · N42006 · Substantial damage NTSB FTW70D0073Accident · No injuriesClosedCessna 182 · Lufkin, TXMay 23, 1969 · N3161R · Substantial damage NTSB FTW69D0317Accident · No injuriesClosedCessna 182L · Alice, TXDec 7, 1968 · N3303R · Substantial damage NTSB FTW69D0270Accident · No injuriesClosedCessna 182 · Lubbock, TXOct 20, 1968 · N3382R · Substantial damage NTSB FTW69F0172Accident · No injuriesClosedCessna 182 · Corpus Christ, TXAug 25, 1968 · N42279 · Substantial damage NTSB FTW69F0453Accident · 2 fatalClosedCessna Wren · Keller, TXJul 20, 1968 · N3472R · Destroyed NTSB FTW68F0599Accident · No injuriesClosedCessna 182 · Lubbock, TXMay 29, 1968 · N42279 · Substantial damage NTSB FTW68D0453Accident · No injuriesClosedCessna 182 · Wichita Falls, TXFeb 17, 1968 · N3410R · Substantial damage