NTSB investigations: Cessna U206F, 1982
6 cases on aircraft the registry lists as Cessna U206F. 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
| 1973 | 4 |
|---|---|
| 1974 | 9 |
| 1975 | 5 |
| 1976 | 11 |
| 1977 | 11 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 8 |
| 1981 | 8 |
| 1982 | 6 |
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 10 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 2 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 5 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073333', '207333A'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073333', '207333A'))
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 MKC82DA173Accident · Minor injuriesFinal reportCessna U206F · Baton Rouge, LAThe pilot changed the fuel selector from right to left while descending through 2200 ft MSL. The engine failed immediately after the fuel selector was moved. Repeated attempts to restart the engine by changing fuel selector position was unsuccessful. The…NTSB ANC82FA091Accident · 4 fatalField investigationFinal reportRobertson C-U206F · Near Nondalton, AKShortly after takeoff from hudson lake the left wingtip contacted the water causing the acft to cartwheel. The acft came to rest inverted & floated for a short time before sinking. A witness reported the waves on the lake were at least 4 ft high & breaking…NTSB DEN82DA196Accident · No injuriesFinal reportCessna U206F · Kemmerer, WYThe aircraft lost power after takeoff in a large field. During the landing roll, the aircraft crossed a dirt road that crossed the field, the nose gear failed and the aircraft nosed over. A section of aluminum from the air induction box was missing. Aluminum…NTSB FTW82DA359Accident · No injuriesFinal reportCessna U206F · Katy, TXDuring arrival, the pilot initiated his landing with a quartering tail wind at 4 gusting to 8 knots. While landing, he realized his airspeed was too high and he elected to go around. During the maneuver, the tail of the aircraft collided with a power line at…NTSB SEA82DA107Accident · No injuriesFinal reportCessna U206 · Dry Bay, AKThe pilot reported that he arrived in marginal VFR weather conditions with rain and variable winds gusting to 12 knots. He stated that the windsock favored a landing to the east, downhill, to a wet grass runway. He reported that during a short field approach,…NTSB NYC82FNC09Accident · No injuriesFinal reportCessna U206 · Millinocket, MEBefore departing smith pond, Maine, the pilot checked the fuel and estimated he had between 30 and 40 gallons on board. He flew to waterville, then to katachdine lake, and was on the next leg of the flight when the engine lost power. He switched tanks and the…