Fatal NTSB investigations: Cessna P206C
8 cases on aircraft the registry lists as Cessna P206C. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1974 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1998 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073312'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073312'))
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 SEA98FA081Accident · 3 fatalField investigationFinal reportCessna P206C · Dubois, IDAttempted VFR flight into IMC and a loss of aircraft control. An inadequate weather evaluation and drug impairment were factors.NTSB IAD96FA061Accident · 1 fatalField investigationFinal reportCessna P206C · Hartwood, VAthe inadvertent/premature deployment of the first skydiver's parachute, which resulted in contact with the airplane's horizontal stabilizer by the first skydiver and his parachute, loss of integrity of the empennage to the aft fuselage, loss of aircraft…NTSB ANC90FA164Accident · 5 fatalField investigationFinal reportCessna P206C · Talkeetna, AKThe pilot-in-command's continued VFR flight into instrument meteorological conditions, and failure to maintain adequate altitude for terrain clearance. Factors to the accident were the adverse weather conditions, mountainous terrain, and the dark night.NTSB FTW86FA115Accident · 1 fatalField investigationFinal reportCessna P206C · Grand Chenier, LAThe aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.…NTSB FTW83FA128Accident · 3 fatalField investigationFinal reportCessna P-206C · Brookland, ARThe acft crashed in IMC weather after the pilot failed to complete a VOR approach to jonesboro. According to the owner of the accident acft, the plt was instrument rated and had filed an IFR flt plan but was not very proficient in instrument flying. During…NTSB CHI74AC073Accident · 4 fatalClosedCessna P206C · Coral, MINTSB LAX82FA013Accident · 5 fatalClosedCessna 206 · Quartzsite, AZNTSB MIA70AM087Accident · 2 fatalClosedCessna P206C · St.Augustine, FL