NTSB investigations: Cessna 207A, 1998
11 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\") = 1998
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") = 1998
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 ANC99LA016Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were dark night conditions, snow covered terrain, and low ceilings.NTSB ANC99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Aniak, AKA loss of engine power due to fuel contamination. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Noorvik, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were a dark night and low ceilings.NTSB ANC99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Napaskiak, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. Factors in the accident were the pilot's inadequate planning/decision to continue a second takeoff following an engine surge and aborted takeoff, and unsuitable…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 ANC98LA150Accident · No injuriesLimited investigationFinal reportCessna 207A · Hughes, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent stall. A factor in the accident was the presence of a tail wind.NTSB ANC98LA099Accident · Minor injuriesLimited investigationFinal reportCessna 207 · King Salmon, AKThe disconnection of the mixture control cable from the mixture control arm. Factors associated with this accident were the inadequate 100 hour inspections performed by company mechanics.NTSB ANC98LA104Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKAn in-flight collision with a large bird.NTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…NTSB ANC98LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe throttle arm disconnecting from the throttle linkage to the engine as a result of inadequate inspection by company maintenance personnel. Factors associated with this accident were the company maintenance personnel not following the repetitive Service…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.