NTSB investigations: Cessna 182F, OH

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

NTSB investigations: Cessna 182F, OH per year, 1965–2026: 8 cases
1965	2
1967	1
1968	1
1970	1
1972	1
1976	1
1993	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" = 'OH' 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 ('2072714')) 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\" = 'OH' 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 ('2072714'))
  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" = 'OH' 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 ('2072714'))
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 BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.Oct 1, 1993 · N3332U · Substantial damage NTSB CHI76FEG10Accident · No injuriesClosedCessna 182F · Springfield, OHMar 26, 1976 · N3566U · Substantial damage NTSB CHI72FEG34Accident · No injuriesClosedCessna 182F · West Caroltn, OHApr 29, 1972 · N3583Y · Substantial damage NTSB CHI71DGG13Accident · No injuriesClosedCessna 182 · St Clairsvle, OHSep 5, 1970 · N3482U · Substantial damage NTSB CHI69D0084Accident · No injuriesClosedCessna 182 · Jefferson, OHJul 3, 1968 · N3146U · Substantial damage NTSB CHI67F0553Accident · No injuriesClosedCessna 140 · Mt. Vernon, OHMar 18, 1967 · N3631U · Substantial damage NTSB CHI66D0496Accident · No injuriesClosedCessna 182F · Middle Bass, OHDec 5, 1965 · N3589Y · Substantial damage NTSB CHI65F0168Accident · No injuriesClosedCessna 182 · Bryan, OHMay 16, 1965 · N3290U · Substantial damage