Skip to content

NTSB investigations: Cessna 172K, NC

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

19702026

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 ('2072430')) 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 ('2072430'))
  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 ('2072430'))
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 ERA25LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Southport, NCThe pilot’s loss of aircraft control due to spatial disorientation, and the flight instructor’s inadequate supervision, which resulted in the subsequent overstress of the airplane during recovery.Dec 19, 2024 · N7085G · Substantial damage NTSB GAA19CA439Accident · Minor injuriesData collectionFinal reportCessna 172 · Manteo, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 30, 2019 · N78658 · Substantial damage NTSB ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.Mar 5, 2011 · N84867 · Substantial damage NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.Aug 20, 2007 · N7410G · Substantial damage NTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.Mar 9, 1996 · N79058 · Substantial damage NTSB ATL89LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmington, NCThe inadequate preflight preparation/planning by the pilot regarding the unique light features on runway 18 (lights mounted along the east side only). In addition the pilot failed to align the airplane with the runway and struck a vehicle that was parked…Jul 27, 1989 · N7444G · Substantial damage NTSB ATL81FLJ09Accident · Serious injuriesClosedCessna 172K · Conetoe, NCJun 17, 1981 · N7327G · Destroyed NTSB IAD79DKM10Accident · No injuriesClosedCessna 172 · Polkville, NCMar 10, 1979 · N46309 · Substantial damage NTSB IAD78FLJ16Accident · No injuriesClosedCessna 172 · Aulander, NCJun 29, 1978 · N46494 · Substantial damage NTSB IAD76AI092Accident · 5 fatalClosedCessna 172K · Bryson City, NCAug 9, 1976 · N78479 · Destroyed NTSB IAD75AI028Accident · 1 fatalClosedCessna 172K · Charlotte, NCNov 7, 1974 · N84718 · Destroyed NTSB IAD75DKM10Accident · No injuriesClosedCessna 172K · Indian Trail, NCSep 18, 1974 · N46494 · Substantial damage NTSB IAD74DLJ37Accident · No injuriesClosedCessna 172 · Oxford, NCApr 6, 1974 · N79910 · Substantial damage NTSB IAD74FKM13Accident · No injuriesClosedCessna 172 · Lake Lure, NCAug 17, 1973 · N79474 · Substantial damage NTSB NYC73AN117Accident · 3 fatalClosedCessna 172K · Relief, NCFeb 27, 1973 · N79559 · Destroyed NTSB NYC73DKM02Accident · No injuriesClosedCessna 172K · Hickory, NCJul 28, 1972 · N78472 · Substantial damage NTSB NYC73AN004Accident · 1 fatalClosedCessna 172 · Cherokee, NCJul 4, 1972 · N7434G · Substantial damage NTSB NYC72FLJ36Accident · No injuriesClosedCessna 172K · Freemont, NCJun 16, 1972 · N46632 · Substantial damage NTSB NYC72DKM19Accident · No injuriesClosedCessna 172 · Greensboro, NCJan 19, 1972 · N78776 · Substantial damage NTSB NYC72AN050Accident · 1 fatalClosedCessna 172 · Boone, NCOct 9, 1971 · N84577 · Destroyed NTSB IAD71FLJ27Accident · Minor injuriesClosedCessna 172K · Southport, NCJun 13, 1971 · N78490 · Substantial damage NTSB IAD70AI038Accident · 3 fatalClosedCessna 172K · Benson, NCJan 10, 1970 · N78393 · Destroyed