NTSB investigations, 1986, IL

5 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19822026
NTSB investigations, 1986, IL per year, 1982–2026: 141 cases
19827
198311
198412
198510
19865
19875
19883
198910
19909
19913
19926
199310
199410
19955
19963
19974
19985
19993
20004
20012
20021
20032
20043
20054
20062
20072

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 year(c.\"eventDate\") = 1986
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353)
  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 CHI87FA010Accident · Serious injuriesField investigationFinal reportBeech 58 · Chicago, ILThe pilot departed home base with an undetermined amount of available fuel, after being advised by the lineman/refueler of the uncertainty of the amount of fuel onboard. The pilot assumed the aircraft had been refueled the previous evening and departed on…Oct 23, 1986 · N7305R · DestroyedNTSB CHI87LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe student pilot assumed he had full fuel tanks prior to takeoff. He then proceeded to fly the aircraft for approximately 4.4 hours. Just prior to his final landing he was forced to go around due to an aircraft on the runway. Following this go around he…Oct 5, 1986 · N5488B · Substantial damageNTSB CHI87DEE01Accident · Minor injuriesFinal reportCessna 182E · Plainfield, ILAccording to the pilot he performed a 'thorough' fuel system preflight by draining three clear fuel specimens from each wing and the belly drains. Shortly after takeoff the engine quit due to water contamination of the fuel system. Following the accident a…Oct 5, 1986 · N3205Y · Substantial damageNTSB CHI86FEE06Accident · Minor injuriesFinal reportFriling/Cothern Longeze · Plainfield, ILThe pilot made a steep right bank while entering the downwind leg on approach to land when the engine quit and the pilot was forced to make an emergency landing in a field short of the runway. Upon examination of the fuel system there was a lack of fuel in…Aug 28, 1986 · N45FC · Substantial damageNTSB CHI86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Schaumburg, ILAccording to the pilot, the aircraft had been refueled the day before in buffalo new york. The aircraft was then flown to chicago,IL. The duration of the flight was four hours and thirty minutes. The following day, without refueling, the aircraft was flown to…Jan 11, 1986 · N8470H · Substantial damage