NTSB investigations: Cessna TR182
8 cases on aircraft the registry lists as Cessna TR182, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 LAX03FA142Accident · 2 fatalField investigationFinal reportCessna TR182 · Eagleville, CAthe pilot's encounter with mountain wave activity with downdrafts and severe turbulence, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was the pilot's improper decision to continue flight into an area of…NTSB NYC98LA038Accident · No injuriesLimited investigationFinal reportCessna TR182 · Owenton, KYThe pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.NTSB LAX91FA093Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's inadvertent flight into IMC and his failure to maintain aircraft control of the airplane. Factors which contributed to the accident related to the pilot becoming disoriented in the dark, nighttime, instrument weather conditions, and to the pilot's…NTSB FTW90FA018Accident · 2 fatalField investigationFinal reportCessna TR182 · Crane, TXThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his loss of aircraft control, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument…NTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB MKC82FCQ14Accident · 2 fatalFinal reportCessna TRI82 · Bunker Hill, KSThe non-instrument rated pilot departed great bend, KS sometime after 2000 CDT on 9/6/83 on a flight to lucas, KS. On 9/9/83, the aircraft was found where it had crashed between great bend and lucas. No preimpact, mechanical failures were evident. The 2256…NTSB FTW82FRG33Accident · 4 fatalFinal reportCessna R182 · Bergheim, TXAt 0010 the plt contacted san antonio tower approximately 10 mi north of san antonio intl arpt. He stated he was at 3100 ft in the clouds. The controller instructed the plt to turn left heading 030, maintain 3,000, & asked the plt if hewanted an IFR…