NTSB investigations: Cessna T182T, NV
5 cases on aircraft the registry lists as Cessna T182T. 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.
Cases per year
| 2007 | 1 |
|---|---|
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'NV' 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 ('2072738', '2072739'))
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" = 'NV' 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 ('2072738', '2072739'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ANC18LA039Accident · No injuriesLimited investigationFinal reportCessna T182T · Yerington, NVLoss of directional control during landing for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB GAA17CA533Accident · No injuriesData collectionFinal reportCessna T182T · Silver Springs, NVThe flight instructor’s failure to maintain a proper descent rate during a simulated engine failure, which resulted in a bounced landing.NTSB GAA17CA291Accident · No injuriesData collectionFinal reportCessna T182 · Carson City, NVThe pilot’s unstabilized approach during the landing flare and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA15CA285Accident · No injuriesData collectionFinal reportCessna T182T · Ely, NVThe pilot's failure to maintain directional control during landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB SEA08FA023Accident · 2 fatalField investigationFinal reportCessna T182T · Las Vegas, NVThe pilot's failure to maintain an adequate terrain clearance/altitude during climb to cruise. Contributing to the accident were rising mountainous terrain, the dark nighttime lighting condition, the pilot's loss of situational awareness, and the Federal…