NTSB investigations: Cessna 206
6 cases on aircraft the registry lists as Cessna 206, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 LAX02LA171Accident · No injuriesLimited investigationFinal reportCessna 206 · Mohave Valley, AZthe pilot's failure to maintain directional control.NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB CHI96LA177Accident · No injuriesLimited investigationFinal reportCessna U206 · Inver Grove, MNthe pilot's improper recovery from the bounced landing. The gusty wind condition was a factor.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 SEA83LA012Accident · No injuriesLimited investigationFinal reportCessna 206 · 40 Nm Wnw Salmo, IDThe pilot began a takeoff from a runway covered with about six inches of wet snow and slush in calm wind conditions. He reported that during the takeoff, the right main wheel settled back to the runway and encountered an area of soft snow and slush. The…