Skip to content

Fatal NTSB investigations: Cessna 172B

33 cases on aircraft the registry lists as Cessna 172B. 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 ('2072406')) 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 ('2072406'))
  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 ('2072406'))
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 WPR26FA354Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172B · Royal City, WAOn September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 24, 2026 · N44P · Substantial damage NTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.Sep 23, 2012 · N8059X · Substantial damage NTSB LAX03FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172B · Little River, CAAircraft is missing.May 26, 2003 · N7555X · Destroyed NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.Jul 8, 2002 · N7550X · Substantial damage NTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.May 24, 1992 · N8102X · Destroyed NTSB SEA92FA114Accident · 1 fatalField investigationFinal reportCessna 172B · Eatonville, WAUndetermined.May 22, 1992 · N7579X · Destroyed NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…Dec 28, 1985 · N6876X · 2 aircraft · Destroyed NTSB SEA85FA082Accident · 3 fatalField investigationFinal reportCessna 172B · Smith, NVAccording to witnesses, the plt made multiple passes over his residence at low alt. The witnesses observed the acft in various maneuvers at low alt. One maneuver was described as a pull-up from about 100 ft to aprx 600 ft, where the acft went into a wingover…Apr 3, 1985 · N6923X · Destroyed NTSB MIA81FA073Accident · 1 fatalClosedCessna 182 · La Belle, FLMay 14, 1981 · N7407X · Destroyed NTSB MIA80FA095Accident · 2 fatalClosedCessna 172 · Wabasso, FLAug 28, 1980 · N3885L · Destroyed NTSB MIA79FLD42Accident · 1 fatalClosedCessna 172B · Orlando, FLFeb 25, 1979 · N7850X · No damage NTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNJul 22, 1978 · N7684X · Destroyed NTSB MKC78FA026Accident · 2 fatalClosedCessna 172 · Memphis, MOMar 9, 1978 · N7592X · Destroyed NTSB OAK76AP066Accident · 1 fatalClosedCessna 172B · Shelter Cove, CAAug 13, 1976 · N8058X · Destroyed NTSB SEA76AS054Accident · 3 fatalClosedCessna 172B · Curlew, WAJun 4, 1976 · N6916X · Destroyed NTSB LAX74AL020Accident · 3 fatalClosedCessna 172 · Silverado, CASep 10, 1973 · N7636X · Destroyed NTSB MIA72AM141Accident · 1 fatalClosedCessna 172B · Santee, SCJun 24, 1972 · N7516X · Destroyed NTSB MKC72AK018Accident · 1 fatalClosedCessna 172B · Forbes, NDAug 30, 1971 · N7982X · Destroyed NTSB MIA70AM074Accident · 1 fatalClosedCessna 210 · Gulf Of Mexico (Gulf of Mexico)Mar 7, 1970 · N6181F · 2 aircraft · Destroyed NTSB OAK69A0016Accident · 4 fatalClosedCessna 172B · Niles, CASep 5, 1968 · N7938X · Destroyed NTSB CHI69A0021Accident · 3 fatalClosedCessna 172 · Shade, OHAug 15, 1968 · N7282A · Destroyed NTSB SEA68A0045Accident · 1 fatalClosedCessna 172B · Bellingham, WAJan 2, 1968 · N8051X · Substantial damage NTSB CHI68A0057Accident · 1 fatalClosedCessna 172 · Millersburg, OHDec 25, 1967 · N8160X · Destroyed NTSB FTW68A0037Accident · 2 fatalClosedCessna 172 · Paris, TXSep 28, 1967 · N8210X · Destroyed NTSB FTW67A0091Accident · 3 fatalClosedCessna 172 · Matagorda Is., TXMar 10, 1967 · N8016X · Destroyed NTSB SEA67A0004Accident · 1 fatalClosedCessna 172B · Roy, MTJul 8, 1966 · N7834X · Destroyed NTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALDec 12, 1965 · N7543X · Destroyed NTSB MIA66A0030Accident · 1 fatalClosedCessna 172B · Englewood, FLSep 12, 1965 · N7652X · Destroyed NTSB NYC65A0117Accident · 2 fatalClosedCessna 172B · Woodstock, NYMar 17, 1965 · N8213X · Destroyed NTSB UNK64X4011Accident · 4 fatalClosedCessna 172B · Los Angeles, CASep 16, 1964 · N8025X · Destroyed NTSB UNK64X2673Accident · 1 fatalClosedCessna 172 · Gulfport, MSJul 5, 1964 · N7430X · Destroyed NTSB UNK64X2381Accident · 1 fatalClosedCessna 172B · Quinter, KSJun 19, 1964 · N8130X · Destroyed NTSB UNK64X1514Accident · 2 fatalClosedCessna 172 · Muskegon, MIApr 29, 1964 · N7989X · Destroyed