Skip to content

NTSB investigations: Cessna 182A, MI

32 cases on aircraft the registry lists as Cessna 182A. 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" = '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 ('2072704')) 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 ('2072704'))
  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 ('2072704'))
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 CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.May 22, 2020 · N5179D · Substantial damage NTSB CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.Jul 18, 2006 · N6155B · Substantial damage NTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.Jul 6, 2006 · N4780D · Substantial damage NTSB CHI02FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Foster City, MIThe incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.Jun 17, 2002 · N5034D · Destroyed NTSB CHI01LA280Accident · No injuriesLimited investigationFinal reportCessna 182A · Grosse Ile, MIBoth the CFI and the student pilot on board improperly flared the airplane and the CFI's failure to perform remedial action during the landing.Aug 12, 2001 · N4080D · Substantial damage NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.Jul 2, 1989 · N3939D · Substantial damage NTSB CHI80FEC35Accident · Minor injuriesClosedCessna 182A · Richmond, MISep 7, 1980 · N4949Q · Substantial damage NTSB CHI79FEC42Accident · No injuriesClosedCessna 182 · Tecumseh, MIAug 12, 1979 · N3939D · Substantial damage NTSB CHI77FEC43Accident · Serious injuriesClosedCessna 182 · Gregory, MISep 10, 1977 · N6054B · Substantial damage NTSB CHI76FEC16Accident · 1 fatalClosedCessna 182 · Detroit, MIDec 28, 1975 · N6054B · No damage NTSB CHI74FET20Accident · No injuriesClosedCessna 182A · Berrien Spgs, MIApr 2, 1974 · N6325B · Substantial damage NTSB CHI73FEC02Accident · No injuriesClosedCessna 182A · Leslie, MIJul 10, 1973 · N3823D · Substantial damage NTSB CHI74 EC01Accident · No injuriesClosedCessna 182 · Saline, MIJul 8, 1973 · N5161D · Substantial damage NTSB CHI73DEM14Accident · No injuriesClosedCessna 182A · Charlevoix, MIAug 23, 1972 · N5187D · Substantial damage NTSB CHI71FEM89Accident · Minor injuriesClosedCessna 182 · Stambaugh, MIJun 22, 1971 · N3781D · Substantial damage NTSB CHI71FEC49Accident · Minor injuriesClosedCessna 182 · Tecumseh, MIMay 9, 1971 · N3939D · Substantial damage NTSB CHI71DBJ23Accident · No injuriesClosedCessna 182A · Blaney Park, MISep 5, 1970 · N5886B · Substantial damage NTSB CHI71FDW02Accident · Minor injuriesClosedCessna 182 · Tecumseh, MIJun 21, 1970 · N3939D · Substantial damage NTSB CHI70D0222Accident · No injuriesClosedCessna 182 · Comins, MIAug 15, 1969 · N4944D · Substantial damage NTSB CHI70D0089Accident · No injuriesClosedCessna 182 · Sandusky, MIJun 29, 1969 · N5038D · Substantial damage NTSB CHI69F0197Accident · No injuriesClosedCessna 182 · Orion, MIAug 19, 1968 · N5095D · Substantial damage NTSB CHI69F0027Accident · No injuriesClosedCessna 182 · Grosse Point, MIJun 21, 1968 · N5135D · Substantial damage NTSB CHI68F0001Accident · Serious injuriesClosedCessna 182 · Lambertville, MIJun 2, 1967 · N9998B · Substantial damage NTSB CHI67F0355Accident · No injuriesClosedPiper PA-22 · Adrian, MINov 26, 1966 · N5081Z · 2 aircraft · Substantial damage NTSB CHI67F0375Accident · No injuriesClosedCessna 182 · Beaver Isl., MIOct 6, 1966 · N6161B · Substantial damage NTSB CHI66F0743Accident · No injuriesClosedCessna 182 · Grand Haven, MIMay 21, 1966 · N4701D · Substantial damage NTSB CHI66F0477Accident · No injuriesClosedCessna 182 · Pontiac, MIDec 19, 1965 · N2156G · Substantial damage NTSB CHI66F0352Accident · No injuriesClosedCessna 182 · Pontiac, MIOct 13, 1965 · N5173D · Substantial damage NTSB CHI66D0043Accident · Minor injuriesClosedCessna 182 · Pigeon, MIJun 26, 1965 · N6115B · Substantial damage NTSB UNK64X1626Accident · No injuriesClosedCessna 182A · Standish, MIMay 5, 1964 · N5967B · Substantial damage NTSB UNK64X1052Accident · No injuriesClosedCessna 182 · Selfridge Afb, MIMar 27, 1964 · N5019D · Substantial damage NTSB UNK64X0151Accident · No injuriesClosedCessna 182 · Fewton, MIJan 4, 1964 · N3982D · Substantial damage