Skip to content

NTSB investigations: Cessna 172, MN

26 cases on aircraft the registry lists as Cessna 172. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'MN' 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 ('2072402')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'MN' 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 ('2072402'))
  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" = 'MN' 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI07LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Oak Grove, MNA loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.Jun 28, 2007 · N6267E · Substantial damage NTSB CHI05CA084Accident · No injuriesData collectionFinal reportCessna 172 · Baudette, MNThe pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…Mar 26, 2005 · N8954B · Substantial damage NTSB CHI96LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Emily, MNthe pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.Jul 20, 1996 · N7101T · Destroyed NTSB CHI94LA338Accident · No injuriesLimited investigationFinal reportCessna 172 · Mora, MNwas an improper touchdown by the pilot-in-command. Factor's associated with this accident were the pilot's diverted attention due to his perception of a crosswind condition and the pilot not performing a recovery from a bounced landing.Sep 17, 1994 · N8064B · Substantial damage NTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.Nov 17, 1992 · N7463A · Substantial damage NTSB MKC78DER98Accident · No injuriesClosedCessna 172 · Warren, MNSep 22, 1978 · N8976B · Substantial damage NTSB MKC77FA004Accident · 3 fatalClosedPiper PA-18 · Grand Rapids, MNNov 20, 1976 · N8415P · 2 aircraft · Destroyed NTSB MKC74FER44Accident · No injuriesClosedCessna 172 · Willmar, MNMar 23, 1974 · N6126E · Substantial damage NTSB MKC71FDD22Accident · No injuriesClosedCessna 172 · Detroit Lks, MNMar 14, 1971 · N8607B · Substantial damage NTSB MKC69F0451Accident · No injuriesClosedCessna 172 · Pequot Lakes, MNApr 26, 1969 · N8688B · Substantial damage NTSB MKC69D0103Accident · No injuriesClosedCessna 172 · Isle, MNAug 4, 1968 · N8522B · Substantial damage NTSB MKC69D0067Accident · No injuriesClosedCessna 150G · St Cloud, MNJul 14, 1968 · N3252J · 2 aircraft · Substantial damage NTSB MKC68F0358Accident · No injuriesClosedCessna 172 · Hill City, MNNov 13, 1967 · N5686A · Substantial damage NTSB MKC68F0242Accident · Minor injuriesClosedCessna 172 · Green Isle, MNSep 24, 1967 · N6389E · Destroyed NTSB MKC67A0041Accident · 1 fatalClosedCessna 172 · Spring Grove, MNJan 1, 1967 · N7378A · Destroyed NTSB MKC67F0243Accident · No injuriesClosedCessna 172 · So.St.Paul, MNSep 26, 1966 · N8746B · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6332E · 2 aircraft · Substantial damage NTSB MKC66D0545Accident · No injuriesClosedCessna 172 · Worthington, MNMay 19, 1966 · N7040T · Substantial damage NTSB MKC66D0532Accident · No injuriesClosedCessna 172 · Faribault, MNMar 31, 1966 · N8264B · Substantial damage NTSB MKC66D0531Accident · Minor injuriesClosedCessna 172 · Minneapolis, MNMar 31, 1966 · N8159B · Substantial damage NTSB MKC66F0486Accident · No injuriesClosedCessna 172 · Dexter, MNMar 8, 1966 · N5100A · Substantial damage NTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNOct 29, 1965 · N6345E · Substantial damage NTSB MKC65F0112Accident · No injuriesClosedCessna 172 · Rosemount, MNFeb 14, 1965 · N8722B · Substantial damage NTSB MKC65F0019Accident · No injuriesClosedCessna 172 · Crystal, MNJan 2, 1965 · N8264B · Substantial damage NTSB UNK64X1453Accident · No injuriesClosedCessna 172 · Circle Pines, MNApr 25, 1964 · N9146B · Substantial damage NTSB UNK64X0843Accident · No injuriesClosedCessna 172 · Le Sueur, MNMar 8, 1964 · N6314E · Substantial damage