Fatal NTSB investigations: Continental TSIO-520 series, GA
11 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 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'GA' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB ATL04FA159Accident · 4 fatalField investigationFinal reportBeech 36TC · Sylvester, GAThe pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB ATL93FA082Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Statesboro, GAInadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…NTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…NTSB ATL81FA013Accident · 2 fatalClosedCessna T210N · Baxley, GA