Skip to content

NTSB investigations: Cessna 172, IL

38 cases on aircraft the registry lists as Cessna 172. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402')) 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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
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 CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.Aug 21, 2015 · N8265B · Substantial damage NTSB CEN13CA495Accident · No injuriesData collectionFinal reportCessna 172 · Kankakee, ILThe airplane struck a deer during takeoff. Contributing to the accident was the perimeter fence being less than FAA's recommended 10 feet high.Aug 18, 2013 · N5148A · Substantial damage NTSB CHI08CA090Accident · No injuriesData collectionFinal reportCessna 172 · Apple River, ILThe pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a snow bank.Mar 1, 2008 · N8366B · Substantial damage NTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.Feb 9, 2002 · N7025A · Substantial damage NTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.Apr 14, 1998 · N6300E · Substantial damage NTSB CHI95LA281Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILinadequate preflight planning and preparation by the pilot and an inadverent stall encountered by the pilot.Aug 16, 1995 · N6146E · Substantial damage NTSB CHI90LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · New Lenox, ILFailure of the pilot to attain wind information, which resulted in his selection of an unfavorable (wrong) runway. A factor related to the accident was: the crosswind condition.Oct 16, 1989 · N4269F · Substantial damage NTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…Sep 8, 1985 · N6236E · Destroyed NTSB CHI81FEE37Accident · No injuriesClosedCessna 172P · Plainfield, ILMay 30, 1981 · N53015 · Substantial damage NTSB CHI81DEE30Accident · No injuriesClosedCessna 172 · Morris, ILApr 15, 1981 · N3972F · Substantial damage NTSB CHI80DEE54Accident · Serious injuriesClosedCessna 172 · Grayslake, ILAug 20, 1980 · N5713A · Substantial damage NTSB CHI80DEE20Accident · No injuriesClosedCessna 172 · Plato Center, ILApr 16, 1980 · N4288F · Substantial damage NTSB CHI78DEV07Accident · No injuriesClosedCessna 172 · Monmouth, ILNov 21, 1977 · N4041F · Substantial damage NTSB CHI78DEV05Accident · No injuriesClosedCessna 172 · Havana, ILOct 19, 1977 · N8345B · Substantial damage NTSB CHI77FA044Accident · 1 fatalClosedCessna 172 · East Dundee, ILMay 22, 1977 · N8031B · Destroyed NTSB CHI77DEV07Accident · No injuriesClosedCessna 172 · Benton, ILDec 5, 1976 · N6815A · Substantial damage NTSB CHI74AC011Accident · 2 fatalClosedCessna 172L · Seneca, ILJul 31, 1973 · N7863G · Destroyed NTSB CHI73FEE24Accident · Serious injuriesClosedCessna 172 · Morrison, ILSep 24, 1972 · N6361E · Destroyed NTSB CHI73FEE10Accident · Minor injuriesClosedCessna 172 · Streator, ILAug 4, 1972 · N8096B · Substantial damage NTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILOct 9, 1971 · N6597W · 2 aircraft · Substantial damage NTSB CHI71DEV49Accident · No injuriesClosedCessna 172 · Palestine, ILJun 14, 1971 · N6646A · Substantial damage NTSB CHI71FBQ18Accident · No injuriesClosedCessna 172 · Aledo, ILOct 4, 1970 · N8996B · Substantial damage NTSB CHI68D0604Accident · No injuriesClosedCessna 172 · Grayslake, ILFeb 15, 1968 · N8001B · Substantial damage NTSB CHI68F0567Accident · Serious injuriesClosedCessna 172 · Princeton, ILJan 30, 1968 · N1121F · Destroyed NTSB CHI68D0374Accident · No injuriesClosedCessna 172 · Beecher, ILOct 14, 1967 · N8795B · Substantial damage NTSB CHI68F0318Accident · No injuriesClosedCessna 172 · Pekin, ILAug 18, 1967 · N8754B · Substantial damage NTSB CHI68D0273Accident · Minor injuriesClosedCessna 172 · Lansing, ILAug 1, 1967 · N5115A · Substantial damage NTSB CHI68F0311Accident · No injuriesClosedCessna 172 · Canton, ILJul 18, 1967 · N5173A · Substantial damage NTSB CHI67F0465Accident · No injuriesClosedCessna 172 · Roselle, ILFeb 3, 1967 · N6000A · Substantial damage NTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damage NTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · Destroyed NTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage NTSB CHI67F0118Accident · Serious injuriesClosedCessna 172 · Dekalb, ILJul 16, 1966 · N6917A · Substantial damage NTSB CHI66A0063Accident · 5 fatalClosedPiper PA-22 · Rockton, ILJan 23, 1966 · N2712P · 2 aircraft · Destroyed NTSB CHI66F0204Accident · No injuriesClosedCessna 172 · Nokomis, ILAug 23, 1965 · N6421E · Substantial damage NTSB CHI65D0160Accident · Minor injuriesClosedCessna 172 · Chicago, ILMar 18, 1965 · N6152E · Substantial damage NTSB CHI65D0035Accident · No injuriesClosedCessna 172 · Morris, ILFeb 3, 1965 · N8784B · Substantial damage NTSB UNK64X2531Accident · No injuriesClosedCessna 172 · Clinton, ILJun 28, 1964 · N8841B · Substantial damage