Skip to content

NTSB investigations: Cessna 172, NC

27 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" = '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 ('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\" = '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 ('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" = '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 ('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 ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.Mar 22, 2014 · N8988B · Substantial damage NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.Aug 2, 2008 · N6026A · Substantial damage NTSB MIA07CA141Accident · No injuriesData collectionFinal reportCessna 172 · Mooresville, NCThe inadequate preflight inspection of the airplane by the pilot-in-command for his failure to remove all water contamination from the fuel system.Sep 7, 2007 · N6729A · Substantial damage NTSB MIA99FA150Accident · 1 fatalField investigationFinal reportCessna 172 · Fontana, NCthe pilot continued visual flight into know weather conditions which resulted in reduced visibility, and the subsequent in-flight collision with rising terrain. Factors in this accidents were clouds and low ceiling in the accident area.May 5, 1999 · N30DS · Destroyed NTSB ATL98LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ocean Isle Bch, NCThe pilot's inadequate inflight planning that resulted in excessive airspeed and altitude for a full stop landing.Aug 6, 1998 · N4103F · Substantial damage NTSB ATL86LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kings Mountain, NCThe acft had been moored on an open ramp in extremely cold tempertures. During preflight the plt found that the fuel strainer drain would not close and one wing tank drain would not open. A mechanic attempted to repair the leaking strainer but could not stop…Dec 26, 1985 · N7300A · Substantial damage NTSB ATL83FA378Accident · 3 fatalField investigationFinal reportCessna 172 · Benson, NCAprx 3 mi south of the crash site, a witness saw the acft flying northbound along a railroad track. He reported that the acft was flying below tree top level & the eng was running smoothly. A short time later, another witness aprx 1 1/2 mi further north, also…Sep 25, 1983 · N8360B · Destroyed NTSB ATL83LA320Accident · No injuriesLimited investigationFinal reportCessna 172 · Folkstone, NCThe plt reported that during takeoff, his seat slid all the way aft. When this occurred, he pulled the yoke aft & the acf entered a power on stall & crashed. Reportedly, the plt did not secure the seat before taking off.Aug 10, 1983 · N4245F · Substantial damage NTSB ATL80FA051Accident · 2 fatalClosedCessna 172 · Salisbury, NCJun 8, 1980 · N8866B · Destroyed NTSB IAD78FLJ20Accident · No injuriesClosedCessna 172 · White Lake, NCJul 30, 1978 · N6055A · Substantial damage NTSB IAD75DKM27Accident · No injuriesClosedCessna 172 · Liberty, NCApr 23, 1975 · N7095T · Substantial damage NTSB IAD74DLJ42Accident · No injuriesClosedCessna 172 · Durants Neck, NCMay 17, 1974 · N5855A · Destroyed NTSB IAD74DKM53Accident · No injuriesClosedCessna 172 · Jefferson, NCApr 30, 1974 · N279MD · Substantial damage NTSB IAD74DKM37Accident · No injuriesClosedCessna 172 · Maiden, NCJan 22, 1974 · N8282B · Substantial damage NTSB IAD74DKM21Accident · No injuriesClosedCessna 172 · Asheville, NCOct 7, 1973 · N5970A · Substantial damage NTSB IAD74FLJ18Accident · Minor injuriesClosedCessna 172 · Sanford, NCSep 22, 1973 · N7077A · Substantial damage NTSB IAD74FLJ05Accident · Minor injuriesClosedCessna 172 · Raleigh, NCJul 28, 1973 · N5644A · Substantial damage NTSB IAD74FKM02Accident · Serious injuriesClosedCessna 172H · Hickory, NCJul 4, 1973 · N8242L · Substantial damage NTSB IAD70DKM08Accident · No injuriesClosedCessna 172 · Statesville, NCMay 11, 1970 · N7079A · Substantial damage NTSB IAD70D0121Accident · No injuriesClosedCessna 172 · Monroe, NCDec 29, 1969 · N5775A · Substantial damage NTSB IAD70A0018Accident · 1 fatalClosedCessna 172 · Hendersonville, NCSep 8, 1969 · N6444E · Substantial damage NTSB DIA69D0183Accident · No injuriesClosedCessna 172 · Rutherfordton, NCMay 11, 1969 · N7465A · Substantial damage NTSB DIA68D0186Accident · No injuriesClosedCessna 172 · Rose Hill, NCMar 22, 1968 · N6342E · Substantial damage NTSB DIA68D0062Accident · No injuriesClosedCessna 172 · Hayesville, NCSep 4, 1967 · N6444E · Substantial damage NTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damage NTSB MIA67A0152Accident · 2 fatalClosedCessna 172 · Hatteras, NCJun 26, 1966 · N4106F · Destroyed NTSB UNK65X0908Accident · 5 fatalClosedCessna 172 · Shelby, NCDec 3, 1964 · N8992B · Destroyed