NTSB investigations, IL

6 cases where NTSB found Preflight inspection.

Cases per year

20092026
NTSB investigations, IL per year, 2009–2026: 6 cases
20092
20101
20111
20161
20201

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\", '02061510'))
  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 CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.May 15, 2020 · N92036 · Substantial damageNTSB GAA16CA313Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Cairo, ILThe pilot's failure to ensure that the tailwheel pin was in the locked position prior to the takeoff roll, resulting in a runway excursion, ground loop, and substantial damage.Jun 12, 2016 · N20361 · Substantial damageNTSB CEN11LA635Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Waukegan, ILThe pilot’s inadequate preflight inspection of the airplane, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the accident were a malfunctioning fuel gauge and air traffic that prevented an on airport landing.Sep 10, 2011 · N103JC · Substantial damageNTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.Apr 21, 2010 · N4326D · Substantial damageNTSB CEN10CA067Accident · No injuriesData collectionFinal reportCessna 182 · Carmi, ILA total loss of engine power due to fuel starvation as a result of the pilot's failure to assure that the fuel tank filler cap was secured prior to flight.Dec 4, 2009 · C-GZYU · Substantial damageNTSB 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