Fatal NTSB investigations: Continental GTSIO-520-C, 1982
3 cases on aircraft whose registry engine model is Continental GTSIO-520-C. 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
| 1971 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 2 |
| 2012 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2024 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 1982
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 ('17035'))
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 year(c."eventDate") = 1982
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 ('17035'))
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 FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…NTSB FTW82FA155Accident · 1 fatalField investigationFinal reportCessna 411A · Houston, TXThe acft was the second acft of a flight of two. The lead acft had received radio clearance for takeoff. The lead acft was to proceed to a visual checkpoint northwest of the arpt & wait for this acft to join up. Witnesses observed the acft depart rwy 17 &…NTSB DEN82FA056Accident · 3 fatalField investigationFinal reportCessna 320F · Missoula, MTDuring arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and…