NTSB investigations, IN

5 cases where NTSB found Snow/slush/ice covered surface.

Cases per year

20092026
NTSB investigations, IN per year, 2009–2026: 5 cases
20091
20101
20171
20191
20211

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\" = 'IN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023015'))
  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 CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.Feb 19, 2021 · N559RA · Substantial damageNTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.Feb 11, 2019 · N750TA · Substantial damageNTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.Dec 27, 2017 · N525KT · Substantial damageNTSB CEN10CA118Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Connersville, INThe pilot's failure to maintain directional control while landing on an ice- and slush-covered runway.Feb 11, 2010 · N8946W · Substantial damageNTSB CEN09CA148Accident · No injuriesData collectionFinal reportCessna 172 · Union Mills, INThe certificated flight instructor's failure to follow correct engine clearing procedures. A factor was the unsuitable landing area.Feb 1, 2009 · N53576 · Substantial damage