NTSB investigations: Cessna TR182, MT
6 cases on aircraft the registry lists as Cessna TR182. 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
| 1982 | 2 |
|---|---|
| 1997 | 1 |
| 2008 | 1 |
| 2019 | 1 |
| 2020 | 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\" = 'MT' 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 ('2072735'))
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" = 'MT' 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 ('2072735'))
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 WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.NTSB WPR19LA184Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Lincoln, MTA loss of control during landing, which resulted in a nose landing gear collapse and runway excursion.NTSB LAX08LA284Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spotted Bear, MTThe pilot's inadequate compensation for the variable wind conditions and failure to maintain adequate airspeed during landing.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB DEN83LA034Accident · No injuriesLimited investigationFinal reportCessna TR182 · Billings, MTAfter power failure pilot landed on a highway and collided with an auto. No evidence of fuel was found in the aircraft.NTSB DEN82FTI11Accident · 1 fatalFinal reportCessna TR182 · Livingstone, MTThe plane crashed about six miles west of livingston, Montana. It was found to have struck about 50 ft below a 5300 ft ridge, while in a 20 degree climb attitude. The weather at livingston was: 900 ft broken, 2500 ft overcast, visibility 10 miles, wind…