NTSB investigations: Cessna TU206G
11 cases on aircraft the registry lists as Cessna TU206G, where the first occurrence was “Loss of control - on ground/water”. 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 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 3 |
| 1990 | 1 |
| 1994 | 1 |
| 1997 | 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 ('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\" = 260))
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" = 260))
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 SEA97LA153Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Halls Crossing, UTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting crosswinds.NTSB SEA94LA063Accident · No injuriesLimited investigationFinal reportCessna TU206 · Salt Lake City, UTThe pilot's improper aircraft handling during the aborted takeoff.NTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.NTSB SEA89LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Las Vegas, NVThe loss of directional control as a result of gusting wind conditions.NTSB DEN89LA087Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Broomfield, COPilot's failure to properly control the aircraft while conducting a crosswind takeoff.NTSB SEA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna TU206-G · Reno, NVThe pilot's failure to adequately compensate for crosswinds. Contributing to the accident was the pilot's decision to land the amphibious aircraft in strong crosswind conditions.NTSB CHI88FA005Accident · No injuriesField investigationFinal reportCessna TU-206G · Lansing, MIImmediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered…NTSB SEA87LA028Accident · No injuriesLimited investigationFinal reportCessna T-206 · Warren, IDThe pilot was attempting to land on a snow covered us forrest service airstrip at dawn. The aircrafts right main gear caught on uneven terrain to the side of the airstrip, veered to the right, and then nosed over inverted.NTSB ANC83LA057Accident · No injuriesLimited investigationFinal reportCessna TU206G · Glennallen, AKThe acft collided with a snowbank and ground looped during landing on a snow covered narrow runway. The pilot had been inactive in flying for several years and had recently purchased the accident acft. He had 9 hours dual and 3 hours solo in this acft. He…NTSB DEN82DA096Accident · No injuriesFinal reportCessna TU206G · Price, UTThe aircraft encountered a dust devil shortly after touchdown during a landing on an unimproved area. The pilot reported that the dust devil moved the aircraft to the right and into a ditch.NTSB SEA82DA016Accident · No injuriesFinal reportCessna TU206G · Pullman, WAThe aircraft had a rudder/directional control problem that had been occurring intermittently. When it occurred during the previous flight, the pilot had to use full right rudder to keep the ball centered. Before landing on that flight, he made a low pass near…