NTSB investigations: Cessna U206G, 1987
6 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\") = 1987
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") = 1987
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 MIA88IA079Incident · No injuriesIncident investigationFinal reportCessna U206G · Key West, FLWhile water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was…NTSB SEA88LA026Accident · No injuriesLimited investigationFinal reportCessna 206 · Funter Bay, AKShortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration.NTSB BFO88LA006Accident · Minor injuriesLimited investigationFinal reportCessna U-206 · Front Royal, VAThe aircraft was involved in a midair collision with N756KP, a Cessna U206 aircraft, while both aircraft were on the final approach to runway 27 at the uncontrolled Front Royal, VA airport. Excellent VFR weather prevailed with 15 miles visibility reported.…NTSB SEA87FA180Accident · 1 fatalField investigationFinal reportCessna U206G II · Yakutat, AKAcft was observed to depart from controlled flight while in a steep left turn at slow speed and low altitude, impacting on a river sand bar. Fire ensued, demolishing acft. Following heavy rains, river rose and acft not recovered.NTSB FTW87FA206Accident · 3 fatalField investigationFinal reportCessna U206G · Lissie, TXThe Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16…NTSB FTW87FA190Accident · No injuriesField investigationFinal reportCessna 206G · Georgetown, TXTeardown of the aircraft engine revealed that the engine counterweight vibration damper assembly was out of tolerance. This allowed excessive engine vibration which resulted in failure of the camshaft drive gear and total engine failure. The pilot executed a…