NTSB investigations: Cessna T207A, AZ
13 cases on aircraft the registry lists as Cessna T207A. 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 | 3 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2014 | 1 |
| 2022 | 1 |
| 2025 | 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\" = 'AZ' 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 ('2073615', '2073614'))
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" = 'AZ' 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 ('2073615', '2073614'))
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 WPR25LA107Accident · No injuriesClass 4 · LimitedFinal reportCessna T207A · Tusayan, AZAn encounter with wind gusts, which resulted in a loss of control and a collapse of the nose landing gear.NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB WPR14FA186Accident · 1 fatalField investigationFinal reportCessna T207A · Page, AZThe pilot’s inability to maintain aircraft control due to a partial loss of engine power and an encounter with downdrafts and gusting crosswinds while on final approach to the runway. The reason for the partial loss of engine power could not be determined…NTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.NTSB LAX03LA164Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZa loss of engine power due to a oil starvation induced catastrophic internal failure of the engine caused by the rotation of the number 2 cylinder main bearing. This narrative was modified on February 16, 2005.NTSB LAX96FA339Accident · 1 fatalField investigationFinal reportCessna T207A · Littlefield, AZThe pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.NTSB LAX91FA213Accident · 7 fatalField investigationFinal reportCessna 207A · Grand Canyon, AZDetonation (or pre-ignition) in the number 1 cylinder, which resulted in erosion (burning) of the number 1 piston and subsequent loss of engine power. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB LAX90FA007Accident · Serious injuriesField investigationFinal reportCessna T207A · Grand Canyon, AZThe inflight failure of the airplane's powerplant as a result metal fatigue which allowed the crankshaft to fracture. Contributing to the accident was mountainous terrain of the Grand Canyon which did not allow a suitable forced landing area.NTSB LAX86LA295Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Whitmore, AZThe airplane departed marble canyon airport, marble canyon, Arizona, to pick up passengers at the grand canyon bar ten airstrip (1Z1) for a 14 CFR 135 flight. The pilot reported that upon arrival at 1Z1 he flew over the single dirt strip runway at about 20 ft…NTSB LAX85FA024Accident · No injuriesField investigationFinal reportCessna T207A · Sedona, AZOn final approach about 1.5 miles from the arpt the power loss occurred as the pilot attempted to add power. After flying over a ridge and several trees the acft touched down in the rough terrain and caught fire. The fire appeared to have started in the…NTSB LAX81FA120Accident · Serious injuriesClosedCessna T207A · Tusayan, AZNTSB LAX81FA090Accident · 1 fatalClosedCessna T207A · Grand Canyon, AZNTSB LAX81FUJ60Accident · Serious injuriesClosedCessna T207A · Chinle, AZ