NTSB investigations: Cessna 182M, FL

10 cases on aircraft the registry lists as Cessna 182M. 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

19692026

NTSB investigations: Cessna 182M, FL per year, 1969–2026: 10 cases
1969	1
1970	1
1971	1
1972	3
1973	1
1980	1
1981	1
1985	1

Where

Open the map

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" = 'FL' 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 ('2072728')) 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\" = 'FL' 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 ('2072728'))
  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" = 'FL' 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 ('2072728'))
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 MIA85LA103Accident · No injuriesLimited investigationFinal reportCessna 182M · Davie, FLPlt stated he intended to land at opa-locka and he was in a hurry to do so because a passenger had become air sick. Instead, the plt unintentionally landed on an ultralight airstrip. The landing gear dug into soft terrain during the landing roll and the acft…Feb 23, 1985 · N71837 · Substantial damage NTSB MIA82DLD08Accident · No injuriesClosedCessna 182 · Vero Beach, FLNov 22, 1981 · N71335 · Destroyed NTSB MIA81FLD10Accident · No injuriesClosedCessna 182 · Reddick, FLDec 29, 1980 · N71882 · Substantial damage NTSB MIA73DKT90Accident · No injuriesClosedCessna 182 · W.Palm Beach, FLApr 28, 1973 · N70633 · Substantial damage NTSB MIA73AM025Accident · 3 fatalClosedCessna 182M · Keystone Hgts, FLSep 3, 1972 · N91658 · Destroyed NTSB MIA73FLD10Accident · Minor injuriesClosedCessna 182M · Dunnellon, FLAug 20, 1972 · N70979 · Substantial damage NTSB MIA72DKT68Accident · No injuriesClosedCessna 182 · Ft.Lauderdale, FLApr 15, 1972 · N71355 · Substantial damage NTSB MIA71DKT71Accident · No injuriesClosedCessna 182 · Lantana, FLJul 23, 1971 · N70633 · Substantial damage NTSB MIA71DLD17Accident · No injuriesClosedCessna 182M · Ocala, FLSep 5, 1970 · N70867 · Substantial damage NTSB MIA70F0218Accident · No injuriesClosedCessna 182 · Ft.Lauderdale, FLOct 21, 1969 · N70633 · Substantial damage