Skip to content

Fatal NTSB investigations: Cessna 172A

39 cases on aircraft the registry lists as Cessna 172A. 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 ('2072404')) 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 ('2072404'))
  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 ('2072404'))
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 WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.Oct 8, 2010 · N8437A · Substantial damage NTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.Nov 5, 2005 · N7467T · 2 aircraft · Substantial damage NTSB IAD97LA009Accident · 1 fatalLimited investigationFinal reportCessna 172A · Lebanon, OHimproper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.Oct 20, 1996 · N9890T · Destroyed NTSB ANC95FA104Accident · 2 fatalField investigationFinal reportCessna 172A · Naknek, AKInadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.Jul 15, 1995 · N9827T · 2 aircraft · Destroyed NTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…Aug 19, 1987 · N7559T · Destroyed NTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…Aug 5, 1985 · N7279T · Substantial damage NTSB FTW85FA060Accident · 1 fatalField investigationFinal reportCessna 172A · Hammond, LANon-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to…Nov 26, 1984 · N7415T · Destroyed NTSB DEN83FA039Accident · 1 fatalField investigationFinal reportCessna 172A · Leadville, COWhen a witness arrived at the arpt, the acft was at the fuel pumps & the plt had the preheater attached. The witness rprtd there was frost on the acft & the plt brushed the loose frost off with his hands. The plt asked for a window scraper, which was…Dec 26, 1982 · N7611T · Substantial damage NTSB FTW81FA090Accident · 1 fatalClosedCessna 172A · Verda, LAMay 13, 1981 · N7232T · Destroyed NTSB LAX81FA082Accident · 2 fatalClosedCessna 172A · Silver Peak, NVMay 3, 1981 · N7458T · Destroyed NTSB ATL81FA006Accident · 4 fatalClosedCessna 172 · Roanoke, VAOct 10, 1980 · N7644T · Destroyed NTSB LAX80FXQ28Accident · 2 fatalClosedCessna 172A · Tahoe City, CAMay 25, 1980 · N7803T · Substantial damage NTSB IAD79FA048Accident · 2 fatalClosedCessna 172A · Albany, KYMay 5, 1979 · N7687T · Destroyed NTSB DEN79FA012Accident · 1 fatalClosedCessna 172A · Park Valley, UTDec 27, 1978 · N7678T · Substantial damage NTSB MIA76AM088Accident · 1 fatalClosedCessna 172A · Milledgeville, GAMay 27, 1976 · N7848T · Destroyed NTSB OAK76FP050Accident · 2 fatalClosedCessna 172A · Planada, CAApr 10, 1976 · N7705T · Destroyed NTSB FTW75FPJ27Accident · 1 fatalClosedCessna 172A · Enid, OKJun 28, 1975 · N7686T · Destroyed NTSB MKC75AK025Accident · 1 fatalClosedCessna 172 · Abilene, KSOct 25, 1974 · N7300T · Destroyed NTSB IAD75FKW06Accident · 1 fatalClosedCessna 172 · Twinton, TNSep 14, 1974 · N7549T · Destroyed NTSB SEA74AS034Accident · 3 fatalClosedCessna 172A · Waterville, WAMar 1, 1974 · N7820T · Destroyed NTSB FTW74AF062Accident · 1 fatalClosedCessna 172A · Hot Springs, ARFeb 17, 1974 · N6839X · Destroyed NTSB MIA74AM059Accident · 3 fatalClosedCessna 172A · Jackson, GAJan 18, 1974 · N7779T · Destroyed NTSB FTW73AF046Accident · 2 fatalClosedCessna 172 · Salt Flat, TXFeb 20, 1973 · N7546T · Destroyed NTSB NYC73ANO74Accident · 1 fatalClosedCessna 172 · Missing AircraftNov 29, 1972 · N7344T · Destroyed NTSB LAX74FUJ03Accident · 2 fatalClosedCessna 172A · Indian Wlls, AZJul 2, 1972 · N7551T · Destroyed NTSB LAX72AL030Accident · 1 fatalClosedCessna 172A · Bagdad, AZOct 25, 1971 · N7570T · Destroyed NTSB CHI70AC086Accident · 1 fatalClosedCessna 172 · Missing AircraftMay 31, 1970 · N7487T · Destroyed NTSB NYC70AN100Accident · 2 fatalClosedCessna 172A · N.Branford, CTMar 15, 1970 · N7796T · Destroyed NTSB FTW70A0037Accident · 2 fatalClosedCessna 172 · Saginaw, TXNov 26, 1969 · N7271T · Destroyed NTSB FTW70A0031Accident · 1 fatalClosedCessna 172 · Mena, ARNov 11, 1969 · N7180T · Destroyed NTSB LAX69A0046Accident · 3 fatalClosedCessna 172 · Tehachapi, CAJan 27, 1969 · N7285T · Destroyed NTSB NYC68A0125Accident · 1 fatalClosedCessna 172 · Berlin, NJJun 2, 1968 · N7372T · Destroyed NTSB LAX67A0092Accident · 2 fatalClosedCessna 172A · Alberhill, CAMar 31, 1967 · N7172T · Destroyed NTSB OAK67A0024Accident · 2 fatalClosedCessna 172A · Davis, CAAug 14, 1966 · N9742T · Destroyed NTSB OAK67A0009Accident · 2 fatalClosedCessna 172 · San Carlos, CAJul 12, 1966 · N7484T · Destroyed NTSB NYC66A0035Accident · 2 fatalClosedCessna 172 · West Dover, VTSep 13, 1965 · N9809T · Destroyed NTSB UNK64X3524Accident · 1 fatalClosedCessna 172 · Macon, GAAug 21, 1964 · N7364T · Destroyed NTSB UNK64X0822Accident · 2 fatalClosedCessna 172 · Big Bear City, CAMar 6, 1964 · N7778T · Substantial damage NTSB UNK64X0735Accident · 1 fatalClosedCessna 172A · Quincy, CAFeb 28, 1964 · N7260T · Destroyed