NTSB investigations: Cessna TU206G, 1979

8 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

NTSB investigations: Cessna TU206G, 1979 per year, 1971–2026: 133 cases
1971	1
1975	1
1978	5
1979	8
1980	10
1981	6
1982	6
1983	8
1984	2
1985	4
1986	5
1987	6
1988	7
1989	4
1990	2
1991	3
1993	3
1994	2
1995	4
1996	3
1997	4
1998	3
1999	3
2000	1
2001	2
2002	1
2003	1
2005	1
2006	6
2007	3
2008	2
2009	1
2011	4
2014	1
2015	2
2017	1
2018	1
2019	1
2020	3
2025	2

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 year(c."eventDate") = 1979 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

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 year(c.\"eventDate\") = 1979
    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 year(c."eventDate") = 1979
  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

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 DEN80DQG03Accident · No injuriesClosedCessna 206 · Hobbs, NMDec 9, 1979 · N735VE · Substantial damage NTSB DEN79FTE82Accident · No injuriesClosedCessna TU206G · Rifle, COSep 16, 1979 · N756KW · Substantial damage NTSB LAX79DA071Accident · No injuriesClosedCessna TP206C · San Jose, CAAug 30, 1979 · N630WE · Substantial damage NTSB OAK79DXQ14Accident · No injuriesClosedCessna TU206G · Austin, NVMay 9, 1979 · N756YY · Substantial damage NTSB SEA79FYM28Accident · No injuriesClosedCessna 206G · The Dalles, ORApr 22, 1979 · N756SR · Substantial damage NTSB DEN79FA034Accident · No injuriesClosedCessna TU206 · Castle Rock, COMar 29, 1979 · N7249N · Substantial damage NTSB DEN79FA024Accident · 2 fatalClosedCessna T206 · Brigham City, UTFeb 26, 1979 · N868BJ · Destroyed NTSB OAK79DVW09Accident · No injuriesClosedCessna TU206G · Tonopah, NVFeb 16, 1979 · N7374C · Substantial damage