NTSB investigations: Cessna 207A, 2007
3 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\") = 2007
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") = 2007
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 ANC07LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Fairbanks, AKThe loss of engine power in cruise flight due to a lack of sufficient oil. A factor contributing to the accident was the pilot's improper in-flight decision to continue the flight after noting a loss of oil pressure.NTSB ANC07FA013Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKThe total loss of engine power during cruise flight due to the disintegration of engine bearings and the fracture of a connecting rod, which resulted in a ditching into ice covered ocean water. Factors contributing to the survivability of the accident were…NTSB ANC07LA014Accident · No injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain adequate clearance from terrain during the landing roll, which resulted in a collision with a snow berm with the left main landing gear, and subsequent damage to the right wing. Factors contributing to the accident were dark…