NTSB investigations: Cessna TU206G, UT
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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1987 | 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.\"eventStateOrRegion\" = 'UT' 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" = 'UT' 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 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 DEN87LA241Accident · No injuriesLimited investigationFinal reportCessna TU206G · Spanish Fork, UTWhile cruising at 10,500 ft with the power set at 28 inches map & 2350 RPM, the eng suddenly lost pwr & began knocking. The plt noted a rapid drop in oil pressure & saw a 3-inch hole in the top of the eng cowling. He attempted to land on a highway, but was…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 DEN81FA042Accident · No injuriesClosedCessna TU206G · Cisco, UTNTSB DEN8UDA004Accident · No injuriesClosedCessna TU206G · Moab, UTNTSB DEN79FA024Accident · 2 fatalClosedCessna T206 · Brigham City, UT