NTSB investigations: Cessna U206F, 1983
3 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\") = 1983
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") = 1983
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 SEA84LA006Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Meyers Chuck, AKThe plt reported that the tide was out, so he was unable to takeoff in the protected bay at Meyers Chuck, AK. With the tide out, there was insufficient room in the bay, so he elected to takeoff on the ocean side of the area. During takeoff, a large wave was…NTSB SEA83FA197Accident · Serious injuriesField investigationFinal reportCessna U206F · Juneau, AKThe plt reported that while on a sightseeing flt, he proceeded up the taku inlet northbound. From there, he continued up over the taku glacier while climbing to aprx 5300 ft MSL.thereafter, he turned to proceed down the mendenhall glacier & begun a descent.…NTSB ANC83FA146Accident · 2 fatalField investigationFinal reportCessna C-206 · Anchorage, AKPrior to the flight N70531 was noted to have the entire cabin area full of cardboard fish packing boxes and empty 5 gal buckets stuffed one inside the other. The acft was noted to be heavier than normal during repositioning operations. The plt stated during a…