Skip to content

Fatal NTSB investigations: Cessna 172E

48 cases on aircraft the registry lists as Cessna 172E. 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."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 ('2072412')) 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 ('2072412'))
  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 ('2072412'))
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 CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…Dec 26, 2021 · N5798T · Destroyed NTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damage NTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…Aug 22, 2004 · N5410T · Destroyed NTSB FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…Apr 13, 2001 · N5638T · Destroyed NTSB CHI98FA048Accident · 1 fatalField investigationFinal reportCessna 172E · Topeka, KSthe pilot's improper use of carburetor heat. Contributing factors were carburetor icing conditions, dark night conditions, and the transmission wire.Nov 25, 1997 · N5332T · Substantial damage NTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..Oct 26, 1997 · N3097U · Destroyed NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.Nov 26, 1993 · N7702U · Substantial damage NTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…Sep 4, 1992 · N3847S · Destroyed NTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.Sep 5, 1988 · N3841S · Destroyed NTSB MIA88FA254Accident · 1 fatalField investigationFinal reportCessna 172E · Floweree, MSThe student pilot departed early in the morning and was not found until the next afternoon. There were no witnesses to the accident. The aircraft impacted the ground in a 50 degree nose down angle at a high rate of speed with evidence of aircraft rotation…Aug 13, 1988 · N5555T · Destroyed NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…Dec 21, 1986 · N7821U · Destroyed NTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…Sep 27, 1983 · N3058U · Destroyed NTSB FTW81FA134Accident · 2 fatalClosedCessna R172E · Bishop, TXAug 25, 1981 · N4208A · Destroyed NTSB LAX76AL038Accident · 1 fatalClosedCessna 172E · Corona, CANov 27, 1975 · N5342T · Destroyed NTSB MKC74AK002Accident · 2 fatalClosedCessna 172E · Lake Park, MNJul 30, 1973 · N3552S · Destroyed NTSB IAD74AI002Accident · 3 fatalClosedCessna 172E · Southern Pines, NCJul 4, 1973 · N3886S · Destroyed NTSB OAK72AP040Accident · 1 fatalClosedCessna 172E · Modesto, CAMay 10, 1972 · N3862S · Destroyed NTSB FTW72DQD16Accident · 4 fatalClosedCessna 172E · S.Buenaventra, MexicoNov 5, 1971 · N3602S · Destroyed NTSB NYC72AN023Accident · 1 fatalClosedCessna 172E · Greene, NYAug 15, 1971 · N3806S · Destroyed NTSB MIA72AM008Accident · 2 fatalClosedCessna 172E · Ft.Lauderdale, FLJul 31, 1971 · N5465T · Destroyed NTSB MKC72AK003Accident · 3 fatalClosedCessna 172E · Montrose, SDJul 10, 1971 · N3936S · Destroyed NTSB MIA71AM108Accident · 1 fatalClosedCessna 172E · Villalba, PRJun 6, 1971 · N3710S · Destroyed NTSB LAX71AL068Accident · 1 fatalClosedCessna 172E · El Cajon, CAMay 15, 1971 · N5678T · Destroyed NTSB ANC71AA016Accident · 3 fatalClosedCessna 172E · Northway, AKJun 27, 1970 · N7735U · Substantial damage NTSB MKC69A0054Accident · 1 fatalClosedCessna 172E · Tarkio, MOApr 7, 1969 · N5716T · Destroyed NTSB LAX71AL063Accident · 2 fatalClosedCessna 172E · Banning, CADec 1, 1968 · N2992U · Destroyed NTSB OAK69A0034Accident · 1 fatalClosedCessna 172E · Susanville, CANov 21, 1968 · N5740T · Destroyed NTSB MIA69A0020Accident · 2 fatalClosedCessna 172E · Spring Place, GAOct 7, 1968 · N7732U · Destroyed NTSB MIA69R0003Accident · 1 fatalClosedCessna 172E · Congo Twn, Burkina FasoSep 1, 1968 · N5777T · Destroyed NTSB DEN69A0009Accident · 1 fatalClosedCessna 172E · Kamas, UTAug 20, 1968 · N3024U · Destroyed NTSB CHI69A0013Accident · 5 fatalClosedCessna 172E · S.Bass Islnd, OHAug 4, 1968 · N3793S · Destroyed NTSB CHI68A0103Accident · 3 fatalClosedCessna 172 · Mount Horeb, WIJun 8, 1968 · N3837S · Destroyed NTSB MIA67A0096Accident · 2 fatalClosedCessna 172E · Donalsonville, GAMar 25, 1967 · N7730U · Destroyed NTSB LAX67F0333Accident · 1 fatalClosedCessna 172 · Phoenix, AZMar 9, 1967 · N3959S · Substantial damage NTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MOAug 28, 1966 · N3915S · Destroyed NTSB LAX66A0093Accident · 2 fatalClosedCessna 172E · Wendover, NVMay 26, 1966 · N3887S · Destroyed NTSB MIA66A0128Accident · 2 fatalClosedCessna 172E · Clearwater, FLMay 5, 1966 · N3907S · Destroyed NTSB CHI66A0045Accident · 1 fatalClosedCessna 172E · St.Joseph, MINov 7, 1965 · N3573S · Destroyed NTSB MKC66A0026Accident · 3 fatalClosedCessna 172E · Kansas City, MOOct 14, 1965 · N7745U · Destroyed NTSB MIA65I0081Incident · 1 fatalClosedCessna 172F · Aiken, SCFeb 9, 1965 · N3021U · Destroyed NTSB FTW65A0079Accident · 4 fatalClosedCessna 172 · Burleson, TXFeb 6, 1965 · N3709S · Destroyed NTSB LAX65A0061Accident · 4 fatalClosedCessna 172E · Fullerton, CAJan 24, 1965 · N3974S · Destroyed NTSB UNK65X0870Accident · 4 fatalClosedCessna 172 · Philadelphia, PANov 28, 1964 · N3558S · Destroyed NTSB UNK65X0573Accident · 2 fatalClosedCessna 172B · Mattituck, NYNov 5, 1964 · N5789T · Destroyed NTSB UNK65X0319Accident · 1 fatalClosedCessna 172 · Rancho Mirage, CAOct 18, 1964 · N3593S · Destroyed NTSB UNK64X3954Accident · 1 fatalClosedCessna 172E · Boling, TXSep 13, 1964 · N5391T · Destroyed NTSB UNK64X3738Accident · 2 fatalClosedCessna 172E · Eielson Afb, AKSep 2, 1964 · N5450T · Destroyed NTSB UNK64X2777Accident · 1 fatalClosedCessna 172E · Milpitas, CAJul 12, 1964 · N5554T · Destroyed