NTSB investigations: Continental IO-520 series, 1982
8 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with object”. 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 | 10 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 12 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 6 |
| 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\" = 220))
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" = 220))
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 DEN83LA042Accident · No injuriesLimited investigationFinal reportBeech V35B · Kamis, UTThe plt stated he noticed a drop in oil pressure & a prop surge & decided to make a precautionary landing on a road. During the landing the acft struck several sign posts. Post accident tests showed no evidence of oil starvation or drop in oil pressure.NTSB FTW83FRG01Accident · 2 fatalFinal reportBeech 58 · Round Rock, TXBfr tkof, the plt obtained a wx briefing & filed an IFR flt plan. He tkof at aprx 0816 CDT. At aprx 0820, the acft was radar identified about 1 mi south of Round Rock, TX, heading eastbound. The plt was issued an IFR clnc, as filed, & was clrd to climb from…NTSB FTW82DA359Accident · No injuriesFinal reportCessna U206F · Katy, TXDuring arrival, the pilot initiated his landing with a quartering tail wind at 4 gusting to 8 knots. While landing, he realized his airspeed was too high and he elected to go around. During the maneuver, the tail of the aircraft collided with a power line at…NTSB ANC82DA073Accident · No injuriesFinal reportCessna 185 · Near Skwentna, AKThe pilot of the float plane began his takeoff from a narrow river with a left turn at the lift-off point. After becoming airborne and while turning, the right wing struck a branch. The pilot stated that the aircraft came to rest in the trees, upside down.…NTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…NTSB FTW82FPD16Accident · Serious injuriesFinal reportCessna 188B · Stanford, TXThe pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…NTSB ATL82DA074Accident · No injuriesFinal reportCessna A188B · Terry, MSDuring departure from a 2100 ft runway the pilot realized the plane was overloaded for the conditions. He opened the dump gate about 100 ft from the end of the runway. However he reported that lumps of fertilizer in the bottom of the hopper prevented the load…NTSB LAX82DA101Accident · No injuriesFinal reportBeech V35B · Taft, CAThe aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing.