NTSB investigations: Continental TSIO-520 series, ND
14 cases on aircraft whose registry engine model is Continental TSIO-520 series. 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
| 1980 | 1 |
|---|---|
| 1982 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2016 | 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
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" = 'ND' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
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 CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB CHI01LA309Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe emegency procedure not followed by the pilot.NTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.NTSB CHI98LA001Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe circuit breaker for the hydraulic pump popped during gear extension which resulting in the failure of the landing gear to lock in the extended position.NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.NTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB DEN90LA158Accident · No injuriesLimited investigationFinal reportCessna T-188 · Devils Lake, NDThe pilot's failure to refuel, resulting in fuel exhaustion. A forced landing in rough terrain is a factor.NTSB DEN87FA057Accident · Serious injuriesField investigationFinal reportCessna T210N · West Fargo, NDThe acft was observed flying low and slow on final approach to West Fargo arpt. The acft continued flt to the ground, hit hard, bounced and then flew close to the ground in a large sweeping arc until the left wing tip touched the ground. The acft subsequently…NTSB DEN86LA017Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Bismarck, NDShortly after takeoff, the plt of the Beech A36TC acft activated what he believed was the flap retraction lever, and the eng quit. The plt made a forced landing aprx 1000 ft from the rwy departure end. During the investigation, the eng was started and…NTSB DEN82DA136Accident · No injuriesFinal reportCessna T188C · Starkweather, NDThe pilot reported that the aircraft fuel tank had run out of fuel, so he added 2 to 3 gallons of av-gas. He said he thought this would be enough fuel to ferry the the aircraft four miles. He took off, and upon reaching about 400 ft AGL, the engine lost…NTSB DEN82DTG05Accident · No injuriesFinal reportCessna 188 · Devils Lake, NDThe pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…NTSB DEN80FTG16Accident · No injuriesClosedCessna T188 · Starkweather, ND