NTSB investigations: Cessna 172G, NC
18 cases on aircraft the registry lists as Cessna 172G. 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.
Cases per year
| 1967 | 3 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2024 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072420'))
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 ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA26LA356Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172G · Shelby, NCNTSB ERA24LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Greensboro, NCThe pilot's improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB ATL90LA072Accident · No injuriesLimited investigationFinal reportCessna 172G · Wanchese, NCThe pilot's premature, discontinued use of carburetor heat.NTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…NTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…NTSB ATL82FKM04Accident · Serious injuriesFinal reportCessna 172G · Worthville, NCDuring arrival, the pilot entered a left downwind for runway 11 and proceeded to make a low pass over the strip to chase off cows. At approximately midfield, he initiated a climb and according to the passenger, when power was applied, the engine did not…NTSB IAD79DKM03Accident · Minor injuriesClosedCessna 172 · Linville, NCNTSB IAD76AI078Accident · 1 fatalClosedCessna 172 · St Pauls, NCNTSB IAD74DLJ31Accident · No injuriesClosedCessna 172 · Farmville, NCNTSB IAD74DLJ30Accident · No injuriesClosedCessna 172G · Hamilton, NCNTSB IAD74AI013Accident · 1 fatalClosedCessna 188B · Swan Quarter, NCNTSB IAD71DLJ15Accident · No injuriesClosedCessna 172G · Pantego, NCNTSB IAD71FLJ12Accident · Minor injuriesClosedCessna 172G · Wilmington, NCNTSB IAD71DKM01Accident · No injuriesClosedCessna 172G · Banner Elk, NCNTSB DIA69D0077Accident · Minor injuriesClosedCessna 172 · Raleigh, NCNTSB DIA68D0102Accident · No injuriesClosedCessna 172 · Davis, NCNTSB DIA68D0050Accident · No injuriesClosedCessna 172G · Chapel Hill, NCNTSB DIA67F0091Accident · Minor injuriesClosedCessna 172G · Canton, NC