Skip to content

Fatal NTSB investigations: Cessna 172I

27 cases on aircraft the registry lists as Cessna 172I. 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

19682026

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072426')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072426'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072426'))
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 CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.Sep 13, 2020 · N8488L · Destroyed NTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.Nov 3, 2007 · N8353L · Substantial damage NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.Apr 28, 2005 · N8314L · Substantial damage NTSB DEN04FA104Accident · 2 fatalField investigationFinal reportCessna 172I · Paris, ARthe pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…Jul 11, 2004 · N46174 · Destroyed NTSB LAX98FA141Accident · 2 fatalField investigationFinal reportCessna 172 · Ramona, CAThe loss of control of the aircraft on final approach for undetermined reasons.Apr 24, 1998 · N8364L · Destroyed NTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.Sep 24, 1997 · N35405 · Destroyed NTSB CHI94FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172I · Kalamazoo, MIUndetermined.Nov 21, 1993 · N35549 · Destroyed NTSB CHI93FA139Accident · 2 fatalField investigationFinal reportCessna 172I · Ettrick, WIAn inflight explosion of a toluene-based fluid inside the airplane's cockpit.Apr 18, 1993 · N8337L · Destroyed NTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.Jul 24, 1992 · N27JF · Substantial damage NTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.Jun 11, 1992 · N225EB · Destroyed NTSB MIA87FA188Accident · 1 fatalField investigationFinal reportCessna 172I · Ellisville, MSBfr the flt, the arpt owner adzd the plt not to fly, since he (the plt) appeared to be intoxicated. The plt 'said ok & left,' but returned aprx 1 hr later. A witness rprtd the plt atmtd to takeoff with full flaps. Drg the takeoff roll, theacft drifted off the…Jun 20, 1987 · N8446L · Substantial damage NTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.Jun 20, 1986 · N46074 · Destroyed NTSB MIA83LA229Accident · 1 fatalLimited investigationFinal reportCessna 172I · Miami, FLThe acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…Sep 12, 1983 · N8366L · Minor damage NTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNov 2, 1978 · N46037 · Substantial damage NTSB OAK74AP048Accident · 2 fatalClosedCessna 172I · Hollister, CAMar 28, 1974 · N46041 · Destroyed NTSB NYC74AN074Accident · 2 fatalClosedCessna 172 · Swansea, MAMar 2, 1974 · N35526 · Destroyed NTSB OAK74AP026Accident · 3 fatalClosedCessna 172I · Callahan, CADec 21, 1973 · N35578 · Destroyed NTSB MKC73AK042Accident · 2 fatalClosedCessna 172 · Concordia, KSDec 19, 1972 · N46155 · Destroyed NTSB LAX73AL017Accident · 4 fatalClosedCessna 172I · Acton, CAOct 8, 1972 · N35803 · Destroyed NTSB NYC73AN028Accident · 5 fatalClosedCessna 172I · Hopedale, MAAug 15, 1972 · N752ST · Destroyed NTSB LAX73AL004Accident · 3 fatalClosedCessna 172 · La Jolla, CAJul 29, 1972 · N2820Q · 2 aircraft · Substantial damage NTSB CHI71AC050Accident · 2 fatalClosedCessna 172 · Missing AircraftJan 3, 1971 · N8342L · Destroyed NTSB MKC71AK015Accident · 2 fatalClosedCessna 172I · Vichy, MOSep 13, 1970 · N46223 · Destroyed NTSB MIA70AM061Accident · 1 fatalClosedCessna 172I · Merritt Islnd, FLJan 20, 1970 · N35403 · Destroyed NTSB CHI70A0006Accident · 3 fatalClosedCessna 172I · Barrington, ILJul 18, 1969 · N35777 · Destroyed NTSB SEA69A0050Accident · 3 fatalClosedCessna 172I · Spokane, WAMar 22, 1969 · N8497L · Destroyed NTSB LAX69A0006Accident · 4 fatalClosedCessna 172 · Earp, CAJul 13, 1968 · N46110 · Destroyed