NTSB investigations: Cessna 206, CA
14 cases on aircraft the registry lists as Cessna 206. 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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1991 | 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\" = 'CA' 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 ('2073302'))
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" = 'CA' 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 ('2073302'))
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 LAX91LA409Accident · No injuriesLimited investigationFinal reportCessna 206 · Jamul, CAThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident was the soft wet runway condition.NTSB LAX84LA449Accident · No injuriesLimited investigationFinal reportCessna 206 · Sacramento, CAWhile taxiing for takeoff the pilot's seat slid aft causing the loss of directional control and subsequent collision with other acft. The plt stated that when she entered the acft she moved the seat full forward and that the seat lockingmechanism was not…NTSB LAX82DA126Accident · No injuriesFinal reportCessna 206-F · Winters, CAAfter takeoff as the aircraft climbed through 550 feet AGL the engine lost power. The pilot attempted to turn the aircraft around and land on a taxiway but landed in a soft area near it. The nose gear collapsed and the aircraft slid across the taxiway and…NTSB LAX81FUG47Accident · No injuriesClosedCessna 206 · Riverside, CANTSB OAK76FVH18Accident · No injuriesClosedCessna 206 · Angwin, CANTSB LAX75DUG41Accident · No injuriesClosedCessna 206 · Perris, CANTSB OAK74FVD34Accident · Serious injuriesClosedCessna 206 · Hayward, CANTSB OAK70AP037Accident · 1 fatalClosedCessna 206 · Jackson, CANTSB OAK69D0045Accident · No injuriesClosedCessna 206 · Novato, CANTSB LAX67D0358Accident · No injuriesClosedCessna 206 · Lompoc, CANTSB OAK66D0292Accident · No injuriesClosedCessna 206 · Yuba City, CANTSB LAX66D0011Accident · No injuriesClosedCessna 206 · Rancho Mirage, CANTSB OAK65F0009Accident · No injuriesClosedCessna 206 · Eureka, CANTSB UNK64X1692Accident · No injuriesClosedCessna 206 · Susanville, CA