NTSB investigations: Cessna 208B, CA
12 cases on aircraft the registry lists as Cessna 208B. 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
| 1981 | 1 |
|---|---|
| 1993 | 1 |
| 1995 | 2 |
| 2006 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 2 |
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 ('2073701', '2073700', '2073705'))
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 ('2073701', '2073700', '2073705'))
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 WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.NTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.NTSB WPR20CA089Accident · Minor injuriesData collectionFinal reportCessna 208 · Eureka, CAThe pilot's delayed response to initiate a go-around during a night visual approach over water after the airplane entered instrument meteorological conditions, which resulted in a loss of forward visibility and subsequent impact with the water.NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…NTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…NTSB WPR10LA141Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAAn in-flight collision with a bird while on final approach.NTSB LAX06FA131Accident · 2 fatalField investigationFinal reportCessna 208B · Oak Glen, CAThe pilot's continued flight into instrument meteorological weather conditions and his subsequent failure to maintain an adequate airspeed while maneuvering, that led to a stall/spin.NTSB LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB LAX95FA077Accident · 1 fatalField investigationFinal reportCessna 208B · Pleasanton, CAfailure of the pilot-in-command to maintain visual contact with terrain and sufficient altitude for terrain clearance. Factors in the accident were the pilot's decision to initiate a descent 14 miles from the airport, and weather, specifically cloud…NTSB LAX93LA337Accident · No injuriesLimited investigationFinal reportCessna 208B · Los Angeles, CAThe inattention of the driver of a service truck to yield to aircraft and subsequent collision with the airplane as it crossed the service roadway.NTSB LAX81FUG17Accident · Serious injuriesClosedCessna 172N · Big Bear, CA