NTSB investigations: Cessna 207, WI
7 cases on aircraft the registry lists as Cessna 207. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1986 | 1 |
| 1989 | 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.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073602'))
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."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073602'))
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 CHI90LA015Accident · No injuriesLimited investigationFinal reportCessna 207 · Dodgeville, WIPilot's improper planning/decision and his delay in deciding to go around. Factors related to the accident were: the unfavorable wind conditions, the pilot's visual perception on the crowned runway, his misjudgement of speed and remaining distance on the…NTSB CHI86LA084Accident · No injuriesLimited investigationFinal reportCessna 207 · Milwaukee, WIAfter preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil…NTSB CHI79FEP20Accident · No injuriesClosedCessna 207 · Lyndon Station, WINTSB CHI77DEP32Accident · No injuriesClosedCessna 207 · Wausau, WINTSB CHI76AC086Accident · 2 fatalClosedCessna 207 · East Troy, WINTSB CHI72ACO96Accident · 1 fatalClosedCessna 207 · Cochrane, WINTSB CHI71AC066Accident · No injuriesClosedCessna 207 · Richland Cen, WI