NTSB investigations: Cessna 172H, MO
17 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 | 1 |
|---|---|
| 1968 | 3 |
| 1970 | 2 |
| 1971 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 2 |
| 1988 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2011 | 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\" = 'MO' 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" = 'MO' 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 CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.NTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.NTSB CHI03LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Holt, MOThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident were the trees.NTSB CHI03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Callao, MOA loss of engine power due to the erosion of the number 2 piston, resulting in loss of compression on that cylinder. Contributing factors were the tailwind, the muddy runway condition, and the roadway and ditch.NTSB CHI99FA341Accident · 3 fatalField investigationFinal reportCessna 172H · Plattsburg, MOthe pilot's failure to maintain airspeed during the initial climb. A factor relating to this accident was the inadvertent stall/spin.NTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…NTSB MKC82FCA09Accident · Serious injuriesFinal reportCessna 172H · Kahoka, MOThe pilot reported that on his first approach to land, the runway appeared to be short, so he made a go-around. He reported that he then used a short field technique. He stated that he did not like the looks of the runway, so he attempted another go-around.…NTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…NTSB MKC81FCA03Accident · No injuriesClosedCessna 172H · West Plains, MONTSB MKC78DCG14Accident · No injuriesClosedCessna 172H · Marshfield, MONTSB MKC71DCG50Accident · No injuriesClosedCessna 172H · Ava, MONTSB MKC71FCA22Accident · Serious injuriesClosedCessna 172H · Poplar Bluff, MONTSB MKC70DCG27Accident · No injuriesClosedCessna 172H · Maryville, MONTSB MKC69D0189Accident · No injuriesClosedCessna 172 · Spring City, MONTSB MKC69D0179Accident · No injuriesClosedCessna 172H · Tarkio, MONTSB MKC68D0597Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB MKC68D0452Accident · No injuriesClosedCessna 172 · Fenton, MO