NTSB investigations: Cessna P206D
12 cases on aircraft the registry lists as Cessna P206D. 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
| 1971 | 2 |
|---|---|
| 1974 | 2 |
| 1975 | 2 |
| 1979 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2022 | 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 ('2073338'))
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 ('2073338'))
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 GAA23WA040Accident · No injuriesClass 5 · ForeignCessna P206D · La Familia, BelizeNTSB NYC96LA100Accident · No injuriesLimited investigationFinal reportCessna P206D · Harrison, NYseparation of the number one connecting rod bolt, which resulted in a total loss of engine power.NTSB SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.NTSB FTW88FA072Accident · Minor injuriesField investigationFinal reportCessna P206D · Eagle Lake, TXAn inflight fire erupted following the separation of the number 4 cylinder. A metallurgist determined that studs failed in fatigue. The aircraft continued to burn after the emergency landing and was completely destroyed. The acft had an annual inspection…NTSB NYC85LA192Accident · No injuriesLimited investigationFinal reportCessna P206D · Limerick, MEDuring the short field approach, as the aircraft passed over the tree line, the sink rate suddenly increased. The pilot applied power and increased the pitch but the aircraft touching down hard and bounced. A second touch down was made and as the nosewheel…NTSB FTW79FQG17Accident · No injuriesClosedCessna P206D · Seminole, TXNTSB DEN76FQA24Accident · No injuriesClosedCessna 206 · Abiquiu, NMNTSB IAD76FIA03Accident · Serious injuriesClosedCessna P206D · Fredericksburg, VANTSB MIA75FKG50Accident · No injuriesClosedCessna P206 · Augusta, GANTSB OAK74DVD40Accident · No injuriesClosedCessna 206 · Alameda, CANTSB CHI72DEI25Accident · No injuriesClosedCessna 206 · Cleveland, OHNTSB FTW71FRG69Accident · Minor injuriesClosedCessna 206P · Eagle Pass, TX