NTSB investigations: Cessna 172H, NC
15 cases on aircraft the registry lists as Cessna 172H. 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 | 2 |
|---|---|
| 1968 | 2 |
| 1973 | 3 |
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2017 | 1 |
| 2023 | 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 ('2072424'))
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 ('2072424'))
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 ERA23LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kinston, NCThe airplane’s impact with two deer while performing a takeoff at night.NTSB GAA17CA206Accident · No injuriesData collectionFinal reportCessna 172 · Timberlake, NCThe student pilot’s failure to maintain pitch control during the landing flare with a tailwind, which resulted in a propeller strike.NTSB ATL96LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Hickory, NCEngine stoppage for undetermined reasons. A factor was the terrain furrows.NTSB ATL95LA157Accident · No injuriesLimited investigationFinal reportCessna 172H · Manteo, NCThe pilot's improper in-flight decision to touchdown at the mid-field point of the runway.NTSB ATL85FA189Accident · 2 fatalField investigationFinal reportCessna 172H · Hendersonville, NCThe plt reported that during takeoff, the eng lost power as the acft was climbing thru about 100 to 125 ft AGL. He made a rgt turn back toward the arpt to land. However, the acft stalled, then impacted in a parking lot near the departure end of the rwy &…NTSB IAD79DKM12Accident · Minor injuriesClosedCessna 172 · Spruce Pine, NCNTSB IAD79FA015Accident · 1 fatalClosedCessna 172 · Mt Airy, NCNTSB IAD75FLJ24Accident · No injuriesClosedCessna 172H · Roanoke Rapids, NCNTSB IAD74DKM10Accident · No injuriesClosedCessna 172 · Bryson City, NCNTSB IAD73FKM34Accident · No injuriesClosedCessna 172H · Burnsville, NCNTSB NYC73FKM22Accident · No injuriesClosedCessna 172 · Charlotte, NCNTSB DIA68A0046Accident · 1 fatalClosedCessna 172 · Hillsborough, NCNTSB DIA68F0182Accident · No injuriesClosedCessna 172H · Troy, NCNTSB DIA68A0015Accident · No injuriesClosedCessna 172H · Asheboro, NCNTSB DIA68F0032Accident · Serious injuriesClosedCessna 172 · Greenville, NC