Skip to content

NTSB investigations: Cessna 172, GA

25 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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.Oct 21, 2021 · N6888A · Substantial damage NTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.Oct 9, 2021 · N8592B · Substantial damage NTSB ERA17LA158Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Euharlee, GAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.Apr 18, 2017 · N8368B · Substantial damage NTSB ATL07LA092Accident · No injuriesLimited investigationFinal reportCessna 172 · Brinson, GAA partial loss of engine power due to a blocked carburetor jet.Jun 19, 2007 · N921JR · Substantial damage NTSB ATL99FA074Accident · 1 fatalField investigationFinal reportCessna 172 · Savannah, GAThe pilot's selection of the wrong runway for landing and his delayed go-around, which resulted in the collision with trees. A factor was the tailwind on landing.Apr 24, 1999 · N6433B · Destroyed NTSB ATL94LA160Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Pine Mountain, GAThe pilot's inadequate compensation for existing wind conditions, and his failure to maintain both airspeed and clearance from a fence. Factors were the tailwind and the gusts which existed at the time of the accident.Aug 26, 1994 · N6650A · Substantial damage NTSB ATL90LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's operation of the airplane with known mechanical deficiencies. A factor in the accident was the improperly maintained condition of the magnetos.Aug 24, 1990 · N6173E · Substantial damage NTSB ATL87LA241Accident · No injuriesLimited investigationFinal reportCessna 172 · Baxley, GADuring a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at…Aug 25, 1987 · N4275F · Substantial damage NTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…May 17, 1986 · N6839A · Destroyed NTSB MIA73AM001Accident · 2 fatalClosedMidamerican 172 · Vidalia, GAJul 1, 1972 · N6418B · Destroyed NTSB MIA72FKG76Accident · No injuriesClosedCessna 172 · Morven, GAFeb 29, 1972 · N6212E · Substantial damage NTSB MIA72DKG28Accident · No injuriesClosedCessna 172 · Lafayette, GAAug 22, 1971 · N5188A · Substantial damage NTSB MIA71FKG30Accident · No injuriesClosedCessna 172 · Claxton, GAAug 30, 1970 · N7267T · Substantial damage NTSB MIA70AM063Accident · 2 fatalClosedCessna 172 · Dahlonega, GAJan 23, 1970 · N8949B · Destroyed NTSB MIA70D0290Accident · Serious injuriesClosedCessna 172 · Canton, GASep 6, 1969 · N7067T · Substantial damage NTSB MIA69A0030Accident · 1 fatalClosedCessna 172 · Stone Mountain, GADec 5, 1968 · N7039T · Destroyed NTSB MIA69D0275Accident · No injuriesClosedCessna 172 · Brunswick, GANov 24, 1968 · N5128A · Substantial damage NTSB MIA68A0035Accident · 3 fatalClosedCessna 172 · Villa Rica, GAOct 8, 1967 · N5625A · Destroyed NTSB MIA68F0029Accident · Serious injuriesClosedCessna 172 · Griswold, GAJun 17, 1967 · N8925B · Destroyed NTSB MIA67D0579Accident · No injuriesClosedCessna 172 · Palmetto, GAMay 24, 1967 · N9168B · Substantial damage NTSB MIA67D0442Accident · No injuriesClosedCessna 172 · Jonesboro, GAMar 13, 1967 · N6650A · Substantial damage NTSB MIA66A0062Accident · 1 fatalClosedCessna 172 · St Marys, GANov 27, 1965 · N6232E · Destroyed NTSB MIA65A0124Accident · 3 fatalClosedCessna 172 · Toccoa, GAJun 19, 1965 · N4253F · Destroyed NTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GADec 4, 1964 · N5625A · Substantial damage NTSB UNK64X2288Accident · No injuriesClosedCessna 172 · Cairo, GAJun 14, 1964 · N6886A · Substantial damage