NTSB investigations: Cessna 207A
19 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “In flight encounter with weather”. 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
| 1985 | 2 |
|---|---|
| 1987 | 2 |
| 1991 | 2 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 2 |
| 2006 | 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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 ANC07LA003Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKThe pilot's misjudgment of distance/altitude during the landing approach, which resulted in an undershoot and in-flight collision with a river embankment. Factors contributing to the accident were reduced visibility due to rain and mist.NTSB ANC01LA099Accident · No injuriesLimited investigationFinal reportCessna 207 · Healy, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, low clouds, and rain.NTSB ANC01TA047Accident · Minor injuriesFinal reportCessna 207 · Mtn. Village, AKThe pilot's continued VFR flight into instrument meteorological conditions while maneuvering. Factors in the accident were low ceilings, snow showers, whiteout conditions, and snow-covered terrain.NTSB ANC99FA047Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, spatial disorientation, and an inadvertent stall. Factors in the accident were weather conditions consisting of snow and mist, and flat lighting conditions.NTSB ANC99LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's continued flight into adverse weather conditions. Factors associated with the accident were freezing rain, an accumulation of ice on the wings and ailerons, and diminished directional control.NTSB ANC98FA152Accident · 1 fatalField investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, mountainous/hilly terrain features, rain, and fog.NTSB ANC97LA134Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.NTSB ANC97LA047Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Teller, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…NTSB ANC97LA027Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKthe pilot's continued VFR flight into instrument meteorological conditions, his misjudgment of distance and altitude during the approach to land, and his failure to attain a proper touchdown point during the landing. A factor relating to the accident was: the…NTSB ANC97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tununak, AKthe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from rising terrain. Factors associated with the accident were: low ceiling, fog, rising terrain, and the pilot's inadequate…NTSB ANC96LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKfailure of the pilot to maintain sufficient altitude/clearance above terrain, after becoming spatially disoriented, while maneuvering after takeoff. Factors relating to the accident were: fog, snow, partial obscuration, 'flat' conditions of light, and the…NTSB ANC95LA020Accident · No injuriesLimited investigationFinal reportCessna 207 · Saint Mary'S, AKThe pilot's decision to continue visual flight into instrument meteorological conditions. Factors associated with the accident are the pilot's failure to maintain adequate altitude/clearance from terrain, and the whiteout weather conditions.NTSB ANC94LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kwigillingok, AKThe pilot-in-command's failure to maintain the proper airspeed which resulted in an inadvertent stall and his failure to initiate a go-around when the runway environment was not clearly defined. A factor in the accident was the fog.NTSB ANC92FA022Accident · 1 fatalField investigationFinal reportCessna 207 · Mcgrath, AKThe pilot in command's improper inflight planning/decision and his attempt to fly VFR through IMC conditions. Factors contributing to the accident were the snow, whiteout conditions, and darkness.NTSB ANC91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Saint Marys, AKThe pilot-in-command's failure to maintain VFR flight in instrument meteorological conditions while maneuvering on a VFR flight plan. Factors related to the accident was the pic's failure to evaluate the weather conditions that existed.NTSB ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…NTSB ANC87FA023Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKWx conds on the day of the acdnt were rprtd to be extremely variable. Initially, when the plt obtained a wx briefing, VFR flt was not rcmdd. Later, the wx improved & the plt elected to proceed on the flt. While en route, he enctrd snow showers & dscndd to…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 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…