NTSB investigations: Cessna P206B, CA
7 cases on aircraft the registry lists as Cessna P206B. 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2009 | 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 ('2073309'))
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 ('2073309'))
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 WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB LAX01LA303Accident · 2 fatalLimited investigationFinal reportCessna P206B · Willits, CAthe failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.NTSB LAX97LA231Accident · Minor injuriesLimited investigationFinal reportCessna P206B · Desert Center, CAThe pilot's unexpected encounter with dust devils during the takeoff ground roll.NTSB LAX87FA142Accident · 2 fatalField investigationFinal reportCessna P206B · Green Valley, CAA Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…NTSB LAX83FA388Accident · 2 fatalField investigationFinal reportCessna P206B · Kernville, CAThe acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL.NTSB LAX78DUM20Accident · No injuriesClosedCessna 206 · Imperial, CANTSB OAK77DVD28Accident · No injuriesClosedCessna 206 · Crescent City, CA