Skip to content

NTSB investigations: Cessna 180, MI

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

19652026

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" = 'MI' 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 ('2072602')) 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\" = 'MI' 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 ('2072602'))
  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" = 'MI' 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 ('2072602'))
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 CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.Jul 24, 1999 · N9330C · Substantial damage NTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.Aug 17, 1996 · N9352U · 2 aircraft · Substantial damage NTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.Jun 21, 1991 · N2755C · Substantial damage NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.Aug 18, 1990 · N4547B · Destroyed NTSB CHI81DEM20Accident · Serious injuriesClosedCessna 180 · Detour Village, MIJun 12, 1981 · N4593B · Substantial damage NTSB CHI80DEM15Accident · Minor injuriesClosedCessna 180 · Lake Leelanau, MIFeb 2, 1980 · N2406C · Substantial damage NTSB CHI78FEM29Accident · No injuriesClosedCessna 180 · Otsego Lake, MIJul 15, 1978 · N1608C · Substantial damage NTSB CHI76FEC49Accident · No injuriesClosedCessna 180 · Salem, MIJul 17, 1976 · N1513C · Substantial damage NTSB CHI76DEC04Accident · No injuriesClosedCessna 180 · Tecumseh, MIAug 2, 1975 · N2902C · Substantial damage NTSB CHI75FEC15Accident · No injuriesClosedCessna 180 · Springville, MISep 21, 1974 · N7713A · Destroyed NTSB CHI73AEC28Accident · No injuriesClosedCessna 180 · Tecumseh, MIApr 1, 1973 · N2902C · Substantial damage NTSB CHI72FEM77Accident · Minor injuriesClosedCessna 180 · Acme, MIJun 22, 1972 · N4798B · Destroyed NTSB CHI72FEM37Accident · Serious injuriesClosedCessna 180 · Portage, MIOct 30, 1971 · N4743B · Substantial damage NTSB CHI71FBJ29Accident · No injuriesClosedCessna 180 · Lansing, MIAug 29, 1970 · N2471C · Substantial damage NTSB CHI71DBJ24Accident · No injuriesClosedCessna 180 · Ironwood, MIAug 29, 1970 · N3326D · Substantial damage NTSB CHI70FBJ34Accident · Minor injuriesClosedCessna 180 · Saginaw, MIJun 6, 1970 · N2836A · Substantial damage NTSB CHI70DDW12Accident · No injuriesClosedCessna 180 · Linden, MIApr 5, 1970 · N2961A · Substantial damage NTSB CHI69D0461Accident · No injuriesClosedCessna 180 · Charlevoix, MIJan 4, 1969 · N2430C · Substantial damage NTSB CHI69D0367Accident · No injuriesClosedCessna 180 · Baraga, MINov 30, 1968 · N4572B · Substantial damage NTSB CHI68F0143Accident · No injuriesClosedCessna 180 · Troy, MIJul 9, 1967 · N1508C · Substantial damage NTSB MKC68D0010Accident · Minor injuriesClosedCessna 180 · Battle Lake, MIMay 19, 1967 · N1603C · Substantial damage NTSB CHI67D0675Accident · No injuriesClosedCessna 180 · Eaton Rapids, MIApr 29, 1967 · N2284C · Substantial damage NTSB CHI67F0597Accident · No injuriesClosedCessna 180 · Plymouth, MIApr 22, 1967 · N4968A · Substantial damage NTSB CHI67F0630Accident · No injuriesClosedCessna 180 · Manistique, MIApr 1, 1967 · N9279C · Substantial damage NTSB CHI67F0495Accident · No injuriesClosedCessna 180 · Vicksburg, MIFeb 14, 1967 · N2813A · Substantial damage NTSB CHI67F0423Accident · No injuriesClosedCessna 180 · South Haven, MIJan 6, 1967 · N1789C · Substantial damage NTSB CHI67F0263Accident · No injuriesClosedCessna 180 · La Salle, MIOct 8, 1966 · N9115C · Substantial damage NTSB CHI66F0065Accident · Minor injuriesClosedCessna 180 · Marysville, MIJun 28, 1965 · N513J · Destroyed