NTSB investigations: Cessna 172H, OH
19 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
| 1966 | 1 |
|---|---|
| 1967 | 5 |
| 1968 | 3 |
| 1969 | 2 |
| 1971 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 2 |
| 1990 | 1 |
| 2012 | 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\" = 'OH' 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" = 'OH' 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 CEN12CA620Accident · No injuriesData collectionFinal reportCessna 172H · Phillipsburg, OHThe pilot’s improper flare, which resulted in a hard landing.NTSB CHI90LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Brookville, OHThe pilot's failure to maintain positive control of the aircraft while encountering gusty, shifty winds and windshear during the initial climbout after takeoff.NTSB CHI83LA246Accident · No injuriesLimited investigationFinal reportCessna 172H · Dayton, OHThe plt stated he was aware of the displaced threshold due to barriers across the approach end of the rwy. After clearing the last barrier he felt the acft start to fall. He nosed over & added power but the nose gear struck the rwy first. The firewall &…NTSB CHI83LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · West Jefferson, OHThe pilot stated that he made a normal approach and was about to land when he added power to land over a rough area of the grass strip. He was maintaining just above stall speed and at minumum control when a gust of wind pushed the acftto the right toward the…NTSB CHI80FEI31Accident · Minor injuriesClosedCessna 172H · Willoughby, OHNTSB CHI80FEI04Accident · No injuriesClosedCessna 172 · Warren, OHNTSB CHI72DEI24Accident · No injuriesClosedCessna 172H · Painesville, OHNTSB CHI71FGG24Accident · No injuriesClosedCessna 172 · Columbus, OHNTSB CHI70F0061Accident · Minor injuriesClosedCessna 172H · Union, OHNTSB CHI69D0621Accident · Serious injuriesClosedCessna 172H · Hillsboro, OHNTSB CHI69D0376Accident · No injuriesClosedCessna 172H · Fairborn, OHNTSB CHI68D0779Accident · No injuriesClosedCessna 172 · New Phila., OHNTSB CHI68D0684Accident · No injuriesClosedCessna 172 · Dayton, OHNTSB CHI68D0455Accident · Minor injuriesClosedCessna 172 · Wellston, OHNTSB CHI68D0237Accident · No injuriesClosedCessna 172 · Sharon Ctr, OHNTSB CHI68D0260Accident · No injuriesClosedCessna 172 · Kent, OHNTSB CHI67F0550Accident · Minor injuriesClosedCessna 172 · Elyria, OHNTSB CHI67D0471Accident · No injuriesClosedCessna 172 · Vandalia, OHNTSB CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OH