NTSB investigations: Cessna TU206G
9 cases on aircraft the registry lists as Cessna TU206G, 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 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1988 | 1 |
| 1998 | 1 |
| 2006 | 2 |
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 ('2073357')
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 ('2073357')
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 DEN06CA089Accident · No injuriesData collectionFinal reportCessna TU206G · Alamosa, COthe pilot's failure to maintain aircraft control during the landing. Contributing factors include the gusty winds, the crosswind, and the pilot exceeding the maximum demonstrated crosswind component for the airplane.NTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.NTSB ANC98FA168Accident · 1 fatalField investigationFinal reportCessna TU-206G · Ketchikan, AKThe pilot's continued VFR flight into instrument meteorological conditions. Contributing factors were low ceilings and mountainous/hilly terrain.NTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…NTSB SEA84FA064Accident · 2 fatalField investigationFinal reportCessna U206 · Stevenson, WAThe plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…NTSB ATL84FA028Accident · 2 fatalField investigationFinal reportCessna TU206G · Brentwood, TNThe acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with…NTSB LAX83FA458Accident · 2 fatalField investigationFinal reportCessna TU206-G · Flagstaff, AZThe acft collided with trees shortly after takeoff. The weather was marginal with 700 ft scattered, ceiling 3000 ft WITH8 miles visibility. The plt received two weather briefings about an hour apart while waiting for weather improvement. The briefer commented…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 SEA83FA057Accident · 1 fatalField investigationFinal reportCessna TU206G · Soda Springs, IDA search for the aircraft was begun after the pilot's relatives reported it was overdue and residents near the crash site heard the sounds of a low flying plane suddenly terminate. Unofficial reports of the weather indicated it was about 200 ft obscured, 1/4…