NTSB investigations: Cessna 207A, 1986
6 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\") = 1986
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") = 1986
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 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 ANC86LA158Accident · No injuriesLimited investigationFinal reportCessna 207A · Mountain Villag, AKThe airline transport pilot who is also a certificated airframe and powerplant mechanic elected to defer brake repairs until the end of the flying day. The fatigued right brake line failed before the end of the day's flying activity. During lndg the brakes…NTSB ANC86IA137Incident · No injuriesIncident investigationFinal reportCessna 207A · Togiak, AKAfter landing the airplane was taxiing to park and the pilot noticed the steering becoming stiff. He stopped the airplane and examined the nose gear and found it to have pivoted forward with the wheel coming to rest against the nose cowling. The mechanic…NTSB ANC86FA078Accident · 1 fatalField investigationFinal reportCessna 207A · Saint Marys, AKThe pilot stalled the airplane while making a steep turn to avoid high voltage power lines. The airplane caught fire on impact and the air taxi pilot subsequently died of extensive thermal injuries. The plt was flying in formation with another acft at low…NTSB DEN86FA115Accident · Minor injuriesField investigationFinal reportCessna 207A · Ogden, UTAcft was en route to slc where it was to be put on static display with other acft equipped with soloy-conversions (allison 250-C20S turboshaft engine installation). During descent through 12,000 ft into slc area eng flamed out and the prop auto-feathered. Plt…NTSB ANC86IA033Incident · No injuriesIncident investigationFinal reportCessna 207 · Barrow, AKEngine failed and seized in flight. A forced landing and the snow covered tundra followed with no injuries & minor damage to the airplane. Engine teardown and exam revealed #3 cylinder wrist pin broken.