NTSB investigations, 2009, IL

9 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations, 2009, IL per year, 2008–2026: 193 cases
2008	24
2009	9
2010	21
2011	15
2012	11
2013	14
2014	13
2015	9
2016	12
2017	11
2018	10
2019	5
2020	8
2021	5
2022	7
2023	12
2024	3
2025	4

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 year(c."eventDate") = 2009 AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 year(c.\"eventDate\") = 2009
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 year(c."eventDate") = 2009
  AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.Oct 18, 2009 · N3357W · Destroyed NTSB CEN09CA589Accident · Serious injuriesData collectionFinal reportDiehl KR-2 · Mt. Vernon, ILThe pilot's improper landing flare while landing with gusting winds and his failure to perform a go-around.Sep 17, 2009 · N4DD · Substantial damage NTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.Jul 29, 2009 · N4648A · Substantial damage NTSB CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.Jul 25, 2009 · N37080 · Substantial damage NTSB CEN09LA446Accident · No injuriesLimited investigationFinal reportBeech S35 · Tuscola, ILThe pilot failure to maintain proper speed and distance during approach to land which resulted in landing long and subsequent runway excursion.Jul 15, 2009 · N13W · Substantial damage NTSB CEN09CA410Accident · No injuriesData collectionFinal reportCessna 150 · Bloomington, ILThe complete loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight.Jul 3, 2009 · N8319J · Substantial damage NTSB CEN09LA355Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Cordova, ILThe pilot’s failure to maintain clearance with terrain after clearing an obstacle during an agricultural application pass.Jun 12, 2009 · N1734S · Destroyed NTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.Apr 11, 2009 · N87384 · Destroyed NTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of controlJan 2, 2009 · N3603R · Destroyed