NTSB investigations: Cessna 207A
14 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “In flight collision with object”. 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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2001 | 2 |
| 2004 | 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\" = 220))
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" = 220))
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 ANC05CA005Accident · No injuriesData collectionFinal reportCessna 207 · Chefornak, AKThe in-flight collision with a bird while on final approach to land.NTSB ANC02LA006Accident · No injuriesLimited investigationFinal reportCessna 207A · Kobuk, AKThe pilot's failure to maintain adequate clearance from objects during the initial climb after takeoff, and subsequent collision with a tree. A factor was the presence of trees along the runway.NTSB ANC01LA117Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot's failure to maintain adequate clearance from an object during the initial climb after takeoff.NTSB ANC98LA104Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKAn in-flight collision with a large bird.NTSB ANC98LA056Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control of the airplane, and his premature liftoff, resulting in a collision with a runway light fixture. Factors in the accident were wet runway conditions, and a rough and uneven runway surface with potholes.NTSB ANC97FA092Accident · 2 fatalField investigationFinal reportCessna 207A · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…NTSB ANC96LA144Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKan in-flight encouter with bird(s)/geese, which resulted in a bird strike.NTSB ANC93LA126Accident · No injuriesLimited investigationFinal reportCessna 207 · Egegik, AKThe pilot-in-command's failure to see and avoid the truck.NTSB ANC93FA060Accident · No injuriesField investigationFinal reportCessna 207 · Holy Cross, AKThe failure of the pilot in command to maintain the proper altitude. The trees were a factor in the accident.NTSB CHI90LA154Accident · No injuriesLimited investigationFinal reportCessna 207 · Toledo, OHThe pilot-in-command's poor preflight planning and his failure to attain proper climb rate during initial climb after takeoff.NTSB ANC87LA158Accident · No injuriesLimited investigationFinal reportCessna 207 · Two Lakes, AKThe pilot stated the gravel airstrip was muddy and he lifted off at the end of the strip. The aircraft clipped a tree with the horizontal stabilizer and the airplane settled into the trees.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 FTW82FRD10Accident · 1 fatalFinal reportCessna 207 · Franklinton, LAThe passenger stated that after sharp turns at low altitude over a farm house they did a roll & were too low to recover prior to striking trees. The acft came to rest inverted in a 4-5 ft deep farm pond. The autopsy report shows the plt's death by asphyxia…NTSB ANC82DA038Accident · Minor injuriesFinal reportCessna 207 · New Stuyahok, AKThe pilot utilized a soft field technique and commenced his takeoff from the runway threshold. During takeoff run he observed the runway end markers and elected to put down full flaps. The aircraft became airborne just before colliding with the end marker and…