Skip to content

NTSB investigations: Cessna 182F, TX

19 cases on aircraft the registry lists as Cessna 182F. 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 ('2072714')) 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 ('2072714'))
  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 ('2072714'))
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 CEN24LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Ben Wheeler, TXThe pilot’s failure to maintain control while landing in a gusting wind.Mar 30, 2024 · N3322U · Substantial damage NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…Dec 30, 2019 · N3473U · Substantial damage NTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.May 8, 2018 · N3291U · Substantial damage NTSB GAA17CA243Accident · No injuriesData collectionFinal reportCessna 182 · Killeen, TXThe pilot's incorrect landing flare in gusting wind conditions.Apr 21, 2017 · N3308U · Substantial damage NTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.Apr 1, 2010 · N3320U · Substantial damage NTSB FTW03LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wildorado, TXThe airplane collided with an animal that wandered onto the runway. A contributing factor was sun glare impairing the pilot's view on final approach.Jan 31, 2003 · N3535Y · Substantial damage NTSB FTW92LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Morse, TXThe pilot's attempted VFR flight into IMC conditions. Factors were, the pilot's lack of instrument qualification, his failure to obtain a weather briefing prior to the flight, and dark night conditions.Nov 29, 1991 · N37749 · Substantial damage NTSB FTW83LA359Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Houston, TXThe acft collided with an unoccupied pickup truck during the landing roll. The truck was parked off the left side of therwy. The acft had started drifting right during the landing flare. As the acft touched down the student was correcting back to the left…Jul 27, 1983 · N3518U · Substantial damage NTSB FTW81DRA19Accident · No injuriesClosedCessna 182F · Houston, TXMar 8, 1981 · N3538Y · Substantial damage NTSB FTW80FRJ16Accident · Minor injuriesClosedCessna 182F · Uncertain, TXMay 6, 1980 · N3561U · Substantial damage NTSB FTW72FQD11Accident · No injuriesClosedCessna 182F · El Paso, TXSep 29, 1971 · N3121U · Substantial damage NTSB FTW70D0119Accident · No injuriesClosedCessna 182 · Amarillo, TXJul 20, 1969 · N3596U · Substantial damage NTSB FTW66F0594Accident · No injuriesClosedCessna 182 · Angleton, TXMar 16, 1966 · N3279U · Substantial damage NTSB FTW66D0439Accident · No injuriesClosedCessna 182 · Pecos, TXDec 11, 1965 · N3598U · Substantial damage NTSB FTW66D0388Accident · No injuriesClosedCessna 182 · Laredo, TXOct 21, 1965 · N3590U · Substantial damage NTSB FTW65D0020Accident · No injuriesClosedCessna 182F · Burnet, TXApr 11, 1965 · N3513U · Substantial damage NTSB FTW66F0013Accident · No injuriesClosedCessna 182 · Galveston, TXMar 21, 1965 · N3621U · Destroyed NTSB UNK64X3767Accident · No injuriesClosedCessna 182 · Laredo, TXSep 4, 1964 · N3312U · Substantial damage NTSB UNK64X1227Accident · No injuriesClosedCessna 182 · Mineral Wells, TXApr 8, 1964 · N3518U · Substantial damage