Continental TSIO-520-M
NTSB investigations · 18
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('17266')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('17266')
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 CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna T207A · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB WPR11FA232Accident · Serious injuriesField investigationFinal reportCessna T207A · Monument Valley, UTThe pilot's decision to initiate a go-around after a bounced landing at an airport where go-arounds were not advised and his failure to maintain adequate airspeed during the go-around.NTSB LAX06CA194Accident · No injuriesData collectionFinal reportCessna T207A · Jean, NVthe pilot's failure to obtain and maintain an adequate airspeed, which resulted in a stall/mush. A factor in the accident was the high density altitude.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 SEA03FA059Accident · 2 fatalField investigationFinal reportCessna T207 A · Merlin, ORThe pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.NTSB FTW98FA157Accident · Serious injuriesField investigationFinal reportCessna T207A · Monument Valley, UTThe engine's total power loss due to the induction air ducting separating because of inadequate maintenance by company personnel. Factors were the failure of the manufacturer to provide non-standard operating procedures in their airplane's information manual,…NTSB SEA97LA114Accident · No injuriesLimited investigationFinal reportCessna T207A · Monument Valley, UTA horse entering the runway after the aircraft touched down. Factors included no fence installed around part of the airstrip, and remedial action not possible.NTSB ANC96LA035Accident · No injuriesLimited investigationFinal reportCessna 206 · Willow, AKthe pilot's selection of unsuitable terrain for landing. Snow covered terrain that concealed uneven terrain was a factor in the accident.NTSB ANC95LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiak, AKA failure of the pilot to maintain directional control of the airplane. Icy runway conditions and a lack of a local NOTAM to report the runway condition by local maintenance personnel were factors in the accident.NTSB ANC86LA143Accident · No injuriesLimited investigationFinal reportCessna TU206A · Talkeetna, AKThe pilot forgot to retract the landing gear on the amphibous floats after taking off from a gravel runway. He landed on a lake with the wheels extended and the airplane turned over.NTSB SEA86FA215Accident · 6 fatalField investigationFinal reportCessna T207A · Frenchglen, ORAlthough low altitude flight within the gorge was not in accordance with the mission profile the pilot entered the canyon and proceeded upslope towards rising terrain. 87% of the pilot's extensive flight experience was in helicopter aircraft and he had…NTSB DEN84LA299Accident · No injuriesLimited investigationFinal reportCessna T207A · Mexican Hat, UTPlt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed…NTSB ANC83LA149Accident · Serious injuriesLimited investigationFinal reportCessna T-207A · Atmautluak, AKThe plt stated that during the takeoff roll, his seat slid backwards & he was unable to reach the controls. Subsequently, the acft veered to the right, departed the rwy & went into a shallow pond. The plt reported that the seat latch malfunctioned & was…NTSB MIA83LA150Accident · No injuriesLimited investigationFinal reportCessna 207 · Sebring, FLAccording to the plt, he heard a 'thump' when he was taking off from orlando west arpt, but attributed it to the grass strip. When he landed at Sebring arpt, he heard a scraping sound as he lowered the nose & elected to go around. He decided the nosewheel was…NTSB LAX81FUJ60Accident · Serious injuriesClosedCessna T207A · Chinle, AZ
Back to Continental TSIO-520-M