NTSB investigations: Cessna 207A
6 cases on aircraft the registry lists as Cessna 207A, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2000 | 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 ('2073605', '2073604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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 ('2073605', '2073604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 ANC00IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Deadhorse, AKAn in-flight fracture of the engine crankshaft propeller flange. A factor associated with the accident was the manufacturer's inadequate quality control standards.NTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…NTSB ANC90LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKFatigue failure of the right rudder bar. A factor related to the accident was: rough/uneven terrain beside the runway.NTSB ANC86LA158Accident · No injuriesLimited investigationFinal reportCessna 207A · Mountain Villag, AKThe airline transport pilot who is also a certificated airframe and powerplant mechanic elected to defer brake repairs until the end of the flying day. The fatigued right brake line failed before the end of the day's flying activity. During lndg the brakes…NTSB ANC85IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Cape Simpson, AK# 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.NTSB ANC83IA060Incident · No injuriesIncident investigationFinal reportCessna C-207A · Eek, AKDuring landing roll the left brake did not respond to the pilots commands. The acft veered off the right side of the runway. The aircraft had maintenance performed on the brakes 2 days before.