NTSB investigations, IL

6 cases where NTSB found Spatial disorientation.

Cases per year

20102026
NTSB investigations, IL per year, 2010–2026: 6 cases
20102
20111
20121
20141
20151

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\" = 'IL' 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\", '02022025'))
  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 CEN15FA388Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Kewanee, ILThe pilot's loss of control due to spatial disorientation shortly after takeoff into low instrument meteorological conditions.Aug 30, 2015 · N765CD · Substantial damageNTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.Oct 13, 2014 · N31EW · DestroyedNTSB CEN13FA096Accident · 3 fatalField investigationFinal reportMBB BK 117 A-3 · Compton, ILThe inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.Dec 11, 2012 · N911BK · Substantial damageNTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.Nov 26, 2011 · N223CD · Substantial damageNTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.Feb 22, 2010 · N350WF · DestroyedNTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.Jan 24, 2010 · N222AQ · Destroyed