NTSB investigations: Cessna 172H
11 cases on aircraft the registry lists as Cessna 172H, where the first occurrence was “Overrun”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340))
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 SEA03LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Sullivan Lake, WAThe pilot-in-command's downwind landing. A contributing factor was the tailwind condition.NTSB IAD97LA072Accident · No injuriesLimited investigationFinal reportCessna 172H · Westminister, MDThe pilot misjudged landing distance on the runway and his failure to perform a go-around.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 FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.NTSB ATL93LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's failure to attain the proper touchdown point, and his improper recovery from a bounced landing. A factor was the pilot's lack of total experience in the airplane.NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.NTSB NYC90LA094Accident · No injuriesLimited investigationFinal reportCessna C-172 · Matawan, NJPilot factor in that the pilot landed long and was unable to stop the a/c on the remaining r/w.NTSB CHI90LA013Accident · No injuriesLimited investigationFinal reportCessna 172H · Bay City, MIThe pilot's failure to execute a go-around in a timely manner.NTSB CHI85LA341Accident · No injuriesLimited investigationFinal reportCessna 172H · Whitewater, WIAccording to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed…NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.