NTSB investigations: Continental IO-520 series, 1982
18 cases on aircraft whose registry engine model is Continental IO-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 | 18 |
|---|---|
| 1983 | 18 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 5 |
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 ('17032')
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 ('17032')
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 MIA83FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Ft. Lauderdale, FLThe aircraft crashed while the pilot was apparently attempting to return to land after takeoff. No radio calls were made, but landing gear had been lowered. High speed and excessive rate of descent are not consistant with a normal or even emergency attempt to…NTSB FTW83FA060Accident · 4 fatalField investigationFinal reportBeech A36 · Carlsbad, TXThe pilot and passengers had departed the san angelo airport at about 1800 CST on the day of the accident. They stopped at midland, TX where they borrowed a courtesy car and drove to a restaurant. Later, the aircraft departed on a return flight. At about 2320…NTSB MIA83LA044Accident · No injuriesLimited investigationFinal reportCessna 210L · Jacksonville, FLThe pilot attempted to extend the landing gear using both normal and emergency procedures. All attempts to lower the gear were unsuccessful. The pilot landed gear up on a foamed runway. Investigation revealed that the landing gear power pack solenoid, part…NTSB LAX83FA038Accident · 5 fatalField investigationFinal reportCessna P206B · Near Shafter, NVPilot flew into the ground turning on final approach. Left wing and landing gear made first ground contact. The night was dark and terrain lacked lights. The runway was lighted. There were no known malfunctions to equipment. None of the occupants on board had…NTSB NYC83LA025Accident · No injuriesLimited investigationFinal reportCessna 210D · Morristown, NJPilot was flying with a mechanic to check avionics. Tower called to warn of helicopters. Mechanic asked him to change from right to left traffic. Pilot said the corrections disrupted his senses and he forgot to lower the landing gear.NTSB ANC83FA005Accident · No injuriesField investigationFinal reportCessna 206 · Flat, AKThe pilot made a forced landing shortly after takeoff. He stated that the aircraft lost power, but nothing was found to substantiate this. There was snow on the short runway. The pilot neglected to take a fuel sample before takeoff.NTSB ANC82DAA19Accident · No injuriesFinal reportCessna A185F · Kotzebue, AKThe pilot reported that the wind was from 010 deg at 13, gusting 16 to 17 KTS. He stated that if runway 35 had been used for departure, there would have been a delay due to other aircraft. Therefore, he decided to expedite his departure by using runway 08.…NTSB ANC82DA087Accident · No injuriesFinal reportCessna 185F · Naknek, AKThe pilot made a takeoff downwind in gusty conditions on a lake with marginal capabilities. Surrounding terrain makes wind swirling eddies. The aircraft lost lift and impacted on the bank of the lake in alder brush.NTSB ATL82DA265Accident · No injuriesFinal reportCessna 188B · Gibson, GAThe pilot began a swath run by approaching the field over tall trees. Just beyond the trees was a 7 ft rise in the terrain. The pilot stated that he did not flare soon enough. Reportedly, the plane struck the crop, the gear sheared off and the plane slid to a…NTSB DEN82FTI17Accident · No injuriesFinal reportBellanca 17-30A · Browning, MTAcft landed with the gear up.NTSB ANC82DAG42Accident · Serious injuriesFinal reportCessna 185 · Near Tyonek, AKThe float equipped plane was being used to transport cargo. A passenger was put on the flight at the last minute, but the pilot believed the aircraft was within its maximum weight limit. After takeoff, the pilot remained at a low altitude for a time while the…NTSB NYC82FA188Accident · 1 fatalField investigationFinal reportCessna 310R · Danbury, CTApproaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the…NTSB ANC82DA064Accident · Serious injuriesFinal reportCessna 207 · Near Kenai, AKSeveral black bears were spotted in a narrow canyon and the pilot began making tight, descending turns so his sightseeing passengers could get photographs. Reportedly, the stall warning horn came on, but the pilot continued the turns. He finally rolled out of…NTSB FTW82DA283Accident · No injuriesFinal reportBeech A36 · Port O'Connor, TXThe pilot decided to land at an airstrip that he had landed at about 3 years previously. Before landing, he made a 500 ft pass over the strip. He reported that the sun and glare were bright. He saw white spots on the strip, but thought they were filled-in…NTSB MKC82FCQ11Accident · Serious injuriesFinal reportCessna 188B · Scott City, KSThe aircraft crashed during an aerial application operation; however, the pilot could not remember the details of the accident. He believed that the propeller may have started to turn excessively fast, but this was not verified. After contacting the ground,…NTSB DEN82AA115Accident · 6 fatalFinal reportBeech V35B · Near Ringling, MTAlthough IMC existed over mountainous areas, the plt attempted a visual flt direct to salt lake city. The probable flt path of the acft was one which is usually flown by plts on VFR flts. The course taken by plts desiring to cross over themountain ridges west…NTSB DEN82DA079Accident · No injuriesFinal reportCessna 402A · Bismarck, NDThe pilot discovered that the gear would not extend electrically. Manual extension was attempted, but the crank would not turn in either direction. While applying pressure to the cranks, the chain drive failed. The plane was landed with the gear retracted.…NTSB LAX82FUG08Accident · 2 fatalFinal reportCessna 210G · Etiwanda, CAThe aircraft struck a ridge at an elevation of about 2000 ft MSL. At the impact point, the terrain sloped upward at an angle of about 35 degrees. The aircraft impacted in a near level flight attitude. The weather at the crash site was not determined. However,…