Skip to content

NTSB investigations: Cessna 172L, NC

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

19712026

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" = 'NC' 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 ('2072432')) 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\" = 'NC' 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 ('2072432'))
  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" = 'NC' 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 ('2072432'))
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 ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.Jun 27, 2026 · N7764G · Substantial damage NTSB ERA24LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Stoneville, NCThe student pilot’s improper landing flare, which resulted in a bounced, hard landing.Apr 18, 2024 · N7921G · Substantial damage NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.Dec 31, 2010 · N4383Q · Substantial damage NTSB NYC07CA195Accident · No injuriesData collectionFinal reportCessna 172L · Winston-Salem, NCThe pilot's improper recovery from a bounced landing.Aug 18, 2007 · N7125Q · Substantial damage NTSB ATL06CA046Accident · No injuriesData collectionFinal reportCessna 172L · Long Island, NCThe student pilot's failure to achieve the proper touch down point on landing resulting in an overrun, on-ground collision with a ditch, and subsequent nose over. A factor in the accident was the inadequate supervision of the student pilot by the flight…Feb 23, 2006 · N3803Q · Substantial damage NTSB ATL04CA188Accident · Serious injuriesData collectionFinal reportCessna 172L · Kill Devil Hlls, NCAn in-flight encounter with a downdraft on final approach, which resulted in a loss of control of the airplane and subsequent collision with the ground.Sep 17, 2004 · N986AC · Substantial damage NTSB MIA00LA215Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCA loss of engine power due to failure of the No. 4 cylinder connecting rod during the first flight following engine overhaul for undetermined reasons. Contributing to the accident was unsuitable terrain.Jul 10, 2000 · N3875Q · Substantial damage NTSB MIA00LA214Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCThe failure of the pilot to initiate a go-around after the airplane began to porpoise, resulting in a hard landing and structural damage to the airplane.Mar 10, 2000 · N3875Q · Substantial damage NTSB ATL86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Charlotte, NCDuring the attempted takeoff the acft skipped, climbed a few feet, settled to the ground then climbed again before the plt attempted to abort the takeoff. The acft overran the end of the rwy, crossed a road and hit a ditch and nosed over. An estimated weight…Apr 8, 1986 · N2851Q · Destroyed NTSB ATL81FA095Accident · Serious injuriesClosedCessna 172L · Banner Elk, NCJul 15, 1981 · N7166Q · Destroyed NTSB IAD76FLJ19Accident · No injuriesClosedCessna 172 · Wilmington, NCFeb 22, 1976 · N7555G · Substantial damage NTSB IAD76DLJ12Accident · No injuriesClosedCessna 172L · Angier, NCOct 3, 1975 · N7890G · Substantial damage NTSB IAD74DLJ40Accident · No injuriesClosedCessna 172 · Castle Hayne, NCApr 29, 1974 · N7555G · Substantial damage NTSB IAD74DKM04Accident · No injuriesClosedCessna 172L · Wadesboro, NCJul 10, 1973 · N7236Q · Substantial damage NTSB IAD73DKM29Accident · No injuriesClosedCessna 172L · Trinity, NCMar 30, 1973 · N7820G · Substantial damage NTSB NYC73FLJ15Accident · Minor injuriesClosedCessna 172 · Morrisville, NCDec 24, 1972 · N3956Q · Substantial damage NTSB NYC73DKM13Accident · No injuriesClosedCessna 172 · Maiden, NCSep 27, 1972 · N7163Q · Substantial damage NTSB NYC72FKM04Accident · No injuriesClosedCessna 172 · Indian Trail, NCSep 5, 1971 · N7894G · Substantial damage NTSB IAD71FLJ28Accident · Minor injuriesClosedCessna 172L · Durham, NCJun 14, 1971 · N7867G · Substantial damage