NTSB investigations: Cessna 172P, MO
9 cases on aircraft the registry lists as Cessna 172P. 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 | 2 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2011 | 1 |
| 2020 | 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 ('2072436'))
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 ('2072436'))
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 CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.NTSB CEN12CA022Accident · No injuriesData collectionFinal reportCessna 172P · Ozark, MOThe pilot’s inadequate compensation for gusty crosswind conditions while on approach.NTSB CHI95LA235Accident · No injuriesLimited investigationFinal reportCessna 172 · Springfield, MOimproper in-flight planning/decision by the pilot, and his continued flight into adverse weather conditions, which resulted in an uncontrolled altitude deviation and collision with terrain. Factors relating to the accident were: the adverse weather conditions.NTSB CHI94LA324Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrenton, MOthe pilot's failure to use the proper procedure for an aborted takeoff. Factors associated with the accident were the trees, the pilot's poor preflight/preparation, and the pilot's selection of unsuitable terrain for landing.NTSB MKC89LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Blue Springs, MOThe plt said, while cruising over a water reservoir at about 500 feet AGL, he collided with two waterfowl, believed to be geese. One struck the wing tip, the other near the wing root. Acft control remained constant with no control problems encountered, and…NTSB MKC87IA066Incident · No injuriesIncident investigationFinal reportCessna 172 · Neosho, MOThe acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn…NTSB MKC84LA075Accident · No injuriesLimited investigationFinal reportCessna 172P · Springfield, MOThe student plt was on the final leg of a x-country flt. While landing with a gusty x-wind, the acft veered off the rwy, encountered soft terrain & nosed over.NTSB MKC84LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Osage Beach, MOThe plt reported that while he was making an instrument apch in heavy rain, there was a parial loss of eng power. He applied carburetor heat, but reported that the eng still did not provide full power. He continued the vor/dme apch. When he saw the rwy, he…NTSB MKC83LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOOn landing the aircraft touched down hard, bounced and the right main landing gear broke off. A go around was executed and the flight proceeded to Kansas City where an emergency landing was made. During landing the aircraft swerved off the runway to the right.