NTSB investigations: Cessna U206G, 1994
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\") = 1994
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") = 1994
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 ANC95LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Angoon, AKThe pilot's continued flight into adverse weather. A factor related to the accident was the snow conditions.NTSB MIA95T#A02Accident · No injuriesClass 3Final reportCessna U-206G · Kenansville, FLNTSB CHI95LA056Accident · No injuriesLimited investigationFinal reportCessna 206G · Butler, MOthe pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.NTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.NTSB ANC94LA099Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to use the available longer portion of the lake for the takeoff run.NTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.NTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.