NTSB investigations: Cessna 207A

8 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “Overrun”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations: Cessna 207A per year, 1984–2026: 8 cases
1984	1
1985	1
1988	2
1990	1
1992	1
1993	1
2001	1

Where

Open the map

Latest cases

Query with SQL

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" = 340)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 340))
  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" = 340))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC01LA108Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's selection of a the wrong runway, which resulted in a tailwind for the takeoff attempt. Factors associated with the accident are a short takeoff area, a tailwind, and the pilot's inadequate evaluation of the weather conditions.Aug 13, 2001 · N562CT · Substantial damage NTSB ANC93LA098Accident · No injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial failure of the airplane's braking system.Jun 19, 1993 · N9869M · Substantial damage NTSB ANC92IA029Incident · No injuriesIncident investigationFinal reportCessna 207 · Port Moller, AKThe icy and snow covered condition of the runway surface and the pilot's inadequate preflight planning and preparation by not surveying the surface of the entire runway.Jan 15, 1992 · N70076 · Minor damage NTSB ANC90LA035Accident · No injuriesLimited investigationFinal reportCessna 207 · Takotna, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's failure to attain the proper touchdown point for landing, his excessive airspeed, his failure to go around while he still had sufficient airspeed, the snow covered…Feb 27, 1990 · N73128 · Substantial damage NTSB ANC88LA146Accident · No injuriesLimited investigationFinal reportCessna 207A · New Koliganek, AKThe pilot reported that he landed long on a rough 900' gravel strip. He was unable to stop the airplane before it went off the end of the runway and into the adjoining tundra.Sep 22, 1988 · N1763U · Substantial damage NTSB ANC88LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot was an aircraft mechanic for the operator of the airplane, and was enroute to another airport to repair a company airplane. The pilot stated that he did not do a complete job of preflighting the airplane, and attempted to takeoff with the control…Sep 10, 1988 · N6470H · Substantial damage 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…Jun 15, 1985 · N9828M · Substantial damage NTSB ANC84FA043Accident · Minor injuriesField investigationFinal reportCessna 207A · Crooked Creek, AKThe plt was using soft field procedures to takeoff from a 1600 ft dirt/gravel strip. The strip was wet & soft from melting snow, it sloped downhill with a 3% slope & 15 to 20 ft trees were located at the departure end. Also, the plt reported there were 3…Mar 12, 1984 · N7350U · Substantial damage