NTSB investigations: Continental TSIO-520 series, 1982
8 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 8 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 3 |
| 2005 | 1 |
| 2006 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040')
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\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040')
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" = 230))
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 DEN83FA027Accident · 2 fatalField investigationFinal reportCessna P210 · Sioux Falls, SDAt 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy…NTSB DEN83LA003Accident · No injuriesLimited investigationFinal reportCessna TU206G · Rock Springs, WYThe aircraft was being used for transportation to an oil drilling sight. A 1300 ft portion of a road near the sight was being used as a landing strip. The pilot reported that after the plane touched down and was rolling, it came to a dog leg in the road. He…NTSB MKC82DA162Accident · No injuriesFinal reportCessna T188C · Mechanicsville, IAThe pilot began his takeoff from a 2200 ft strip with a load of about 40 gallons of fuel and 1500 to 1600 lbs of seed. He reported that the wind was from the southeast at 2 mph, the temperature was 74 deg, and the elevation was 800 ft. the aircraft became…NTSB FTW82DA356Accident · No injuriesFinal reportCessna T188C · Black, TXWhile making a swath run the aircraft collided with an irrigation pipe which extended about 15 feet AGL. The pipe was near farm equipment and blended with the background. After the collision the aircraft made a forced landing in a cotton field.NTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The…NTSB SEA82FYA08Accident · 1 fatalFinal reportCessna T210M · Shoshone, IDThe aircraft crashed in a near level attitude and at a high rate of speed. Neither the seat belt nor shoulder harness was fastened. The pilot's blood alcohol level was 236 mg%.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 LAX82FA203Accident · No injuriesField investigationFinal reportCessna T210N · Llano, CAThe pilot stated that when he attempted to extend the gear with the normal system, it would not operate. He stated that he cycled the gear handle 4 or 5 times and checked the circuit breakers. Reportedly, he tried to extend the gear with the hand pump but it…