NTSB investigations: Continental IO-520 series, CA
14 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 | 1 |
|---|---|
| 1983 | 3 |
| 1985 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 2 |
| 2005 | 2 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 LAX06FA066Accident · 2 fatalField investigationFinal reportBeech 36 · Livermore, CAThe pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…NTSB LAX06FA031Accident · 1 fatalField investigationFinal reportBeech F33A · Geyserville, CAthe pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.NTSB LAX02FA212Accident · 3 fatalField investigationFinal reportBeech S35 · Ojai, CAthe pilot's inadequate in-flight planning and failure to maintain an adequate terrain clearance altitude within the canyon.NTSB LAX02FA211Accident · 3 fatalField investigationFinal reportBeech V-35A · Ojai, CAthe pilot's inadequate in-flight planning and failure to maintain an adequate terrain clearance altitude within the canyon.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…NTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.NTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…NTSB LAX85FA213Accident · 1 fatalField investigationFinal reportBeech F33A · Goleta, CAWhen the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…NTSB LAX83FA388Accident · 2 fatalField investigationFinal reportCessna P206B · Kernville, CAThe acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL.NTSB LAX83LA291Accident · 1 fatalLimited investigationFinal reportBellanca 17-31A · Ducor, CAThe acft crashed into the side of a hill at 1900 feet MSL while on a photographic mission. The top of the mountain that was struck is 2412 feet MSL. The pilot was fatally injured in the crash and ground fire following impact. According to his secretary he was…NTSB LAX83FA144Accident · 2 fatalField investigationFinal reportCessna U2061 · Pt Reyes, CAThe Cessna U2061, purchased that day by the occupants, collided with trees on a hillside 10 miles from pt. Reyes, CA. An eyewitness observed the aircraft flying into worsening weather at 500 AGL or lower under a thin cloud layer in the olema valley. During…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,…