NTSB investigations: Continental IO-520 series

57 cases on aircraft whose registry engine model is Continental IO-520 series, where the defining event was Landing gear not configured. 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, newest first

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.\"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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095'))
  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.

NTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.Apr 24, 2012 · N8121R · Substantial damageNTSB CEN12CA036Accident · No injuriesData collectionFinal reportCessna 210J · West Chicago, ILThe pilot's failure to extend the landing gear before touchdown due to his failure to use a checklist.Oct 23, 2011 · N3309S · Substantial damageNTSB CEN11IA179Incident · No injuriesIncident investigationFinal reportCessna 210N · Columbia, MOThe pilot did not extend the landing gear before touchdown due to his distraction during the landing approach and his not using a landing checklist.Feb 8, 2011 · N92MP · Minor damageNTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.Dec 17, 2010 · N990W · Substantial damageNTSB ERA11CA076Accident · No injuriesData collectionFinal reportBeech 95-C55 · Williston, FLThe pilot's failure to properly configure and confirm the position of the landing gear prior to landing.Nov 19, 2010 · N677Z · Substantial damageNTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.Jun 13, 2009 · N266DC · Substantial damageNTSB WPR09LA100Accident · No injuriesLimited investigationFinal reportCessna 210A · Henderson, NVAn undetermined failure of the hydraulic power pack to fully extend the main landing gear through both the normal and emergency systems.Jan 27, 2009 · N210TF · Substantial damage