NTSB investigations: Cessna TU206G

6 cases on aircraft the registry lists as Cessna TU206G, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19872026

NTSB investigations: Cessna TU206G per year, 1987–2026: 6 cases
1987	2
1988	2
1997	1
1999	1

Where

Open the map

Latest cases

Query with SQL

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" = 351)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 351))
  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" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW00LA033Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lafayette, LAThe partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…Nov 17, 1999 · N4803U · Substantial damage NTSB SEA97LA193Accident · No injuriesLimited investigationFinal reportCessna TU206G · Edwall, WAA fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.Aug 18, 1997 · N6620Z · Substantial damage NTSB LAX88LA250Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Palo Alto, CADuring a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of…Jul 9, 1988 · N6106U · Substantial damage NTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.Apr 13, 1988 · N735SU · Substantial damage NTSB ANC87LA162Accident · No injuriesLimited investigationFinal reportCessna 206G · 100mi S.Kng Slm, AKThe aircraft experienced an engine power loss while in cruise flight and subsequently undershot a lake during the emergency landing. Examination of the engine revealed the number 2 bearing was found completely disintegrated and missing from its seat. Evidence…Sep 19, 1987 · N756TT · Substantial damage 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…Sep 16, 1987 · N756HD · Destroyed