NTSB investigations: Cessna 172F, SC
8 cases on aircraft the registry lists as Cessna 172F. 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 | 1 |
|---|---|
| 1973 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 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\" = 'SC' 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 ('2072414'))
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" = 'SC' 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 ('2072414'))
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 ATL95FA079Accident · 1 fatalField investigationFinal reportCessna 172F · Seneca, SCThe pilot's inadequate visual lookout while maneuvering near utility lines, which resulted in a collision with the wires.NTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendNTSB ATL88LA116Accident · No injuriesLimited investigationFinal reportCessna 172F · Myrtle Beach, SCThe pilot reported that the airplane began to sink rapidly about 100 ft above the rwy threshold. He added pwr and initiated a flare. Upon touchdown, the airplane pitched down and rolled rt. The airplane subseqeuntly skidded off of the rt side of the rwy and…NTSB ATL85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia, SCThe plt reported that during a descent to 2100 ft, intermediate level offs were made at 5000, 4000, & 3000 ft. he stated that at 2200 ft, carb heat was removed & power was applied for the level off. However, when the throttle was advanced, the eng began…NTSB ATL84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172F · John'S Island, SCDuring a solo flt, the student flew to a local arpt to practice takeoffs & landings. After his last landing (on rwy 9), he elected to make a x-wind takeoff on rwy 21. During the takeoff, the acft began drifting left at about lift-off speed. The student…NTSB ATL83FA150Accident · Serious injuriesField investigationFinal reportCessna 172 · Spartanburg, SCAccording to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,…NTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCNTSB MIA67A0110Accident · 1 fatalClosedCessna 172F · Jackson, SC