NTSB investigations: Cessna TU206G
8 cases on aircraft the registry lists as Cessna TU206G, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1988 | 2 |
| 1993 | 1 |
| 2006 | 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\" = 250))
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" = 250))
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 SEA06TA152Accident · No injuriesFinal reportCessna TU206G · Lowman, IDThe pilot's loss of aircraft control due to a downdraft on short final followed by an uncontrolled descent to a hard landing.NTSB SEA93LA122Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mountain Home, IDCompensation for wind conditions was inadequate. The wind gusts were a factor.NTSB NYC88FA216Accident · 2 fatalField investigationFinal reportCessna TU206G · White Lake, NYThe float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn…NTSB SEA88FA122Accident · 5 fatalField investigationFinal reportCessna TU-206-G · Root Ranch, IDShortly after takeoff, prior to reaching 500 feet AGL, the pilot lost control of the aircraft and struck trees. After striking trees the aircraft then impacted the ground and exploded into flames. Witnesses stated that from the time of rotation to the time…NTSB LAX85LA331Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Taohoma, CAOn July 27, 1985 a float equipped Cessna TU206G landed on choppy water, nosed over and sank at the seaplane base in lake tahoe, CA. The pilot and 1 passenger were not injured. Witnesses reported that time water conditions were moderate chop with waves 2 to 5…NTSB LAX85LA221Accident · Minor injuriesLimited investigationFinal reportCessna TU-206G · Pinon, AZAt the conclusion of a cross country business flt, plt initiated a straight in approach after monitoring the wind conditions by observing a flag, which he reported as 'limp.' Plt reported that touchdown occurred at '50 knots' following a full flap approach at…NTSB LAX84LA209Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Auburn, CAThe plt came in for her 3rd landing and after flaring high'cut'the throttle and said she hoped for a'soft'landing with trim back and 40 degrees of flaps. A plt on the ground near the rwy said his attention was drawn to the acft because of a large increase in…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…