NTSB investigations: Continental IO-520 series, KS

7 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Continental IO-520 series, KS per year, 1985–2026: 7 cases
1985	1
1994	1
1997	1
1999	2
2000	1
2005	1

Where

Open the map

Latest cases

Query with SQL

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" = 'KS' 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" = 220)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'KS' 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\" = 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 c."eventStateOrRegion" = 'KS' 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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI05LA114Accident · 1 fatalLimited investigationFinal reportCessna A188B · Ludell, KSThe pilot's failure to maintain clearance from trees during an aerial application maneuver. The trees and the sun glare were contributing factors.May 14, 2005 · N4734Q · Destroyed NTSB CHI00LA289Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSaltidude/clearance not obtained/maintained by the pilot. Factors to the accident were the hay bale, the inadequate preflight planning/preparation by the pilot, the high-density altitude, and the high weight of the aircraft at the time of the accident.Sep 1, 2000 · N9326R · Substantial damage NTSB CHI99LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Lincoln, KSthe altitude/clearance not obtained by the pilot and the unsuitable takeoff area selected by the pilot. Factors to the accident were the high, soft, and wet grass runway.May 16, 1999 · N9275R · Substantial damage NTSB CHI99LA111Accident · 1 fatalLimited investigationFinal reportCessna A188B · Atwood, KSThe pilot's failure to maintain clearance from obstacles.Mar 22, 1999 · N5706G · Destroyed NTSB CHI97LA228Accident · No injuriesLimited investigationFinal reportCessna 188B · Halstead, KSthe pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.Jul 28, 1997 · N4864Q · Substantial damage NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.Aug 19, 1994 · N133MC · Substantial damage NTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…Aug 5, 1985 · N9257G · Destroyed