NTSB investigations: Cessna P206, CA
13 cases on aircraft the registry lists as Cessna P206. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1977 | 2 |
| 1980 | 1 |
| 1984 | 1 |
| 1987 | 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 ('2073304'))
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 ('2073304'))
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 LAX87FA213Accident · 4 fatalField investigationFinal reportCessna P206 · Tehachapi, CAAn USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government…NTSB LAX84FA134Accident · 4 fatalField investigationFinal reportCessna P206 · Redding, CAWhile en route, the plt contacted a fss & was advised that the Redding arpt was below minimums due to fog. He then contacted the benton UNICOM (7 mi nw of Redding muni) & reported that he could not see the rwy lights at the benton arpt, but that he would…NTSB LAX80FVG65Accident · No injuriesClosedCessna P206 · Lincoln, CANTSB OAK78DX001Accident · No injuriesClosedCessna P206 · Mammoth Lakes, CANTSB LAX77FUG46Accident · Minor injuriesClosedCessna P206 · Mesquite Lake, CANTSB LAX73AL012Accident · Minor injuriesClosedCessna 206 · Bakersfield, CANTSB LAX72FUA39Accident · No injuriesClosedCessna P206 · Hntngtn Bch, CANTSB OAK72DVG12Accident · No injuriesClosedCessna 206 · Lk Highlnds, CANTSB OAK71AP036Accident · Minor injuriesClosedCessna P206 · Fairfield, CANTSB OAK71DVG05Accident · No injuriesClosedCessna P206 · Beswick, CANTSB LAX68D0184Accident · No injuriesClosedCessna 206 · Olancha, CANTSB LAX67D0071Accident · Minor injuriesClosedCessna P206 · Lost Hills, CANTSB LAX66D0075Accident · No injuriesClosedCessna 206 · Lake Wohlford, CA