NTSB investigations: Cessna 207A
11 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 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\" = 260))
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" = 260))
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 ANC01LA017Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's failure to use all available runway. Factors associated with the accident were the pilot's inadequate preflight planning/preparation, a short runway, a tailwind, and a slush-covered runway.NTSB ANC96LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Newtok, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident are the snow covered runway, and gusty crosswinds.NTSB ANC95LA013Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's inadequate compensation for crosswind. Crosswind conditions and an icy runway surface were factors in the accident.NTSB ANC93LA072Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain control of the airplane during landing.NTSB ANC88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this…NTSB ANC88LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot stated that during the landing roll on the ice covered runway, he lost control causing the plane to exit the departure end of the runway into a snow bank.NTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…NTSB ANC87LA015Accident · No injuriesLimited investigationFinal reportCessna 207A · Manokotak, AKThe pilot stated that he lost directional control of the aircraft on the takeoff roll. The aircraft exited the departure end of the runway into the open tundra.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 SEA84LA147Accident · No injuriesLimited investigationFinal reportCessna 207A · Reno, NVThe acft went off the rwy during a landing and the plt attempted a go-around with full flaps. The acft collided with a ditch and an irrigation pipe between the rwy and the taxi-way. The plt did not file an accident report. The accident information was…NTSB ANC83IA043Incident · No injuriesIncident investigationFinal reportCessna 207A · Kivalina, AKThe acft departed the left side of the runway on its takeoff roll due to misting or frosting of the windshield reducing visibility. The phenomenon is common to the area. The rwy is in poor condition with precautions to use the center only for takeoff &…