NTSB investigations: Cessna U206G, 1985
7 cases on aircraft the registry lists as Cessna U206G. 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
| 1977 | 1 |
|---|---|
| 1978 | 4 |
| 1979 | 8 |
| 1980 | 13 |
| 1981 | 5 |
| 1982 | 9 |
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 3 |
| 1993 | 7 |
| 1994 | 7 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 6 |
| 2005 | 2 |
| 2006 | 5 |
| 2007 | 8 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 5 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073356', '2073315', '2073314'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073356', '2073315', '2073314'))
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 NYC86LA003Accident · Serious injuriesLimited investigationFinal reportCessna C206 · West Dover, VTCessna aircraft, N9861Z overran runway 1, at West Dover, Vermont and landed on a golf course. The pilot stated that when the flight was about 50 feet above the runway and about 100 ft down the runway windshear was encountered, pulling the aircraft to the left…NTSB ANC85LA134Accident · No injuriesLimited investigationFinal reportCessna 206 · Kustatan River, AKThe plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over…NTSB ANC85LA073Accident · No injuriesLimited investigationFinal reportCessna 206 · Seward, AKThe plt stated the acft was in cruise flt when the engine quit. The plt attempted an emergency landing on the beach but crashed in the water. The acft engine was not located for several days after the accident. According to the operator the engine failure was…NTSB ANC85LA066Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Kodiak, AKAcft made low alt steep 180 deg turn, stalled & spun into water. Acft had just taken off & was to spot flsh for three fishing vessels.NTSB LAX85FA210Accident · 6 fatalField investigationFinal reportCessna U206G · Tuba City, AZThis was a medical transportation flight during the early morning hours in marginal weather conditions. The flight was not completed and was returning to the departure airport when it descended into desert terrain 10 miles short of its destination.NTSB CHI85LA129Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Angola, INThe plt of the acft began to have difficulty holding alt shortly after level-off at 6000 ft MSL. He stated that it sounded like the eng was flooding. He began a forced descent to the nearest suitable airfield and crossed over the NDB for that field at 3000 ft…NTSB NYC85LA055Accident · No injuriesLimited investigationFinal reportCessna 206G · Endicott, NYThe plt stated that the eng RPM dropped to idle when he made his second pwr reduction on downwind in preparation for landing. The throttle could not be pushed in when an attempt to add pwr was made. The acft touched down short of the rwy and came to rest aprx…