NTSB investigations: Cessna TU206G, WY
7 cases on aircraft the registry lists as Cessna TU206G. 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
| 1980 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 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\" = 'WY' 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 ('2073357'))
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" = 'WY' 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 ('2073357'))
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 DEN87LA009Accident · No injuriesLimited investigationFinal reportCessna TU206G · Greybull, WYThe plt departed aurora, co at 1000 en route to great falls, mt at 8000 ft MSL. At 1237 the plt advised worland fss that the eng had lost power and he was going down. The plt said that on final apch he had to pull up to avoid power lines. The acft stalled and…NTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…NTSB DEN83FA183Accident · Serious injuriesField investigationFinal reportCessna TU206G · Lander, WYThe plt reported that during a landing with full flaps, the acft touched down, then 'floated' back into the air about 5 ft. he elected to go around & applied full power. The acft then pitched up & to the left & began to travel to the left. The plt controlled…NTSB DEN83LA125Accident · No injuriesLimited investigationFinal reportCessna TU206 · Evanston, WYAfter departing Evanston the plt encountered adverse wx about 100 mi east & returned to Evanston. The plt executed a go-around from a rwy 34 approach due to unfavorable winds & then landed on rwy 16. Directional control was lost & the acft collided with a…NTSB DEN83LA003Accident · No injuriesLimited investigationFinal reportCessna TU206G · Rock Springs, WYThe aircraft was being used for transportation to an oil drilling sight. A 1300 ft portion of a road near the sight was being used as a landing strip. The pilot reported that after the plane touched down and was rolling, it came to a dog leg in the road. He…NTSB DEN81FA020Accident · 1 fatalClosedCessna 206G · Cokeville, WYNTSB DEN80FTC13Accident · Minor injuriesClosedCessna TU206G · Farson, WY