NTSB investigations, 1995, IL

6 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 1995, IL per year, 1982–2026: 169 cases
198218
198314
19849
19859
19869
19878
198810
19893
19908
19917
19927
19934
19946
19956
19966
19972
19985
19996
20006
20015
20023
20035
20044
20052
20063
20074

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\") = 1995
    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\" = 260)
  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 CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.Aug 16, 1995 · N381AV · Substantial damageNTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.Aug 1, 1995 · N5068K · Substantial damageNTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.Jun 17, 1995 · N21873 · Substantial damageNTSB CHI95LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe pilot's failure to maintain directional control. A factor was the crosswind.May 1, 1995 · N47331 · Substantial damageNTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.Apr 15, 1995 · N6673H · Substantial damageNTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.Apr 2, 1995 · N4917Z · Substantial damage