NTSB investigations, IL
14 cases where NTSB found Ceiling/visibility/precip.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2020 | 2 |
Where
Open the mapLatest 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\", '030350'))
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" = '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", '030350')) 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 CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.NTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.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.NTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…NTSB 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.NTSB 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.NTSB 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.NTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.NTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.NTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB CEN10CA092Accident · Minor injuriesData collectionFinal reportCessna 150L · Brownstown, ILA total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.NTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.NTSB CEN09CA448Accident · No injuriesData collectionFinal reportCessna C-182 · Fox Lake, ILThe pilot's inadequate flight planning and continued flight into adverse weather resulting in the collision with the pier during landing.