NTSB investigations: Cessna 207A, 1985
13 cases on aircraft the registry lists as Cessna 207A. 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
| 1967 | 1 |
|---|---|
| 1978 | 5 |
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 8 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 13 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 14 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 8 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 11 |
| 1999 | 5 |
| 2000 | 7 |
| 2001 | 7 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 5 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 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 ('2073605', '2073604'))
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 ('2073605', '2073604'))
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 ANC86FA014Accident · Serious injuriesField investigationFinal reportCessna C-207 · Napaskiak, AKAccording to the pilot-in-command, the weather at his destination was deteriorating so he diverted to Napaskiak where he encountered freezing drizzle rain and fog. While attempting to align himself with the runway for a landing to the south, the windshield…NTSB ANC86LA003Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Nelson Island, AKThe pilot stated that he lost 90 percent of aircraft control and an alarming rate of lost of altitude. At the time of the accident the wind was reported as 140 degrees at 30 knots with gust 40 knots. Chief pilot stated crossing the Island at a higher altitude…NTSB ANC85LA151Accident · No injuriesLimited investigationFinal reportCessna C-207 · Mountain Villag, AKThe pilot-in-command was aware of the weather he was operating in and intended to fly through a locally well known pass. He misidentified the pass and found himself in a narrow valley. There was insufficient width to effect a 180 degree turn and the rising…NTSB ANC85FA093Accident · Serious injuriesField investigationFinal reportCessna 207 · Eek, AKThe pilot-in-command stated that during the takeoff roll he was moving the flap control lever up and down to effect a lift off. The airplane never left the runway and ran off the end of the ten foot embankment, traveled 140 feet before striking a bank and…NTSB ANC85FA085Accident · 2 fatalField investigationFinal reportCessna C-207A · Golovin, AKAccording to the pilot-in-command, he was attempting to fly through a mountain saddle. As he turned towards the mountain and began his climb the weather deteriorated rapidly with ceilings zero, visibility zero and severe turbulence. The airplane struck the…NTSB ANC85IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Cape Simpson, AK# 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.NTSB ANC85LA109Accident · No injuriesLimited investigationFinal reportCessna 207 · Emmonak, AKThe pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the…NTSB ANC85LA062Accident · No injuriesLimited investigationFinal reportCessna 207 · Port Graham, AKThe plt lost directional control while taking off from a rwy covered with 4 to 6 inches of snow, ice & slush. The acft then swerved sideways, collided with a snow bank & was damaged. The arpt was located on public domain & was not regularily attended or…NTSB ANC85LA053Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mcgrath, AKThe acft contacted trees during a forced landing following an engine failure. Investigation revealed the crankshaft had failed for undetermined reasons. The enging had a total time of 1312 hrs since major overhaul.NTSB ANC85LA046Accident · 1 fatalLimited investigationFinal reportCessna 207A · Koyuk, AKThe acft landed about 630 ft short of the threshold of rwy 02. The plt said he purposely landed short to take advantage of a rwy upslope and because of the location of snow removal equipment at the other end of the rwy. In landing short however he landed on…NTSB ANC85LA039Accident · No injuriesLimited investigationFinal reportCessna C-207 · Nome, AKPlt obtained a special VFR to land at Nome arpt. Plt saw apch lights and made a left circle to line up with rwy. Plt stated, ceiling was 300 ft AGL, low visibility and freezing drizzle was present. Aprx 3/8 inch of ice was on airframe and windshield. Plt…NTSB ANC85LA034Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mt Village, AKTakeoff was performed downhill on the ice covered 2200 ft gravel airstrip. Plt stated liftoff was late but given the surrounding terrain, the takeoff was continued rather then aborted. During climb the acft contacted the roof of an abandoned building. Acft…NTSB ANC85LA032Accident · No injuriesLimited investigationFinal reportCessna 207A · Nuiqsut, AKAfter a night landing by the copilot, and after the first bounce, the pilot in command took control of the aircraft after it developed a high sink rate. The pilot then ground looped the aircraft.