NTSB investigations: Cessna 182J, AL

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

19672026

NTSB investigations: Cessna 182J, AL per year, 1967–2026: 10 cases
1967	1
1968	1
1969	1
1970	1
1971	1
1974	1
1975	1
1980	1
1994	1
2017	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" = 'AL' 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 ('2072722')) 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\" = 'AL' 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 ('2072722'))
  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" = 'AL' 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 ('2072722'))
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 ERA17CA089Accident · Minor injuriesData collectionFinal reportCessna 182 · Mobile, ALThe pilot’s failure to maintain airplane control during the initial climb.Jan 14, 2017 · N707RB · Substantial damage NTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.Apr 23, 1994 · N2945F · Substantial damage NTSB ATL80FA059Accident · 2 fatalClosedCessna 182 · Omaha, ALJun 23, 1980 · N701SP · Destroyed NTSB MIA76DKJ08Accident · No injuriesClosedCessna 182 · Bessemer, ALJul 11, 1975 · N3580F · Substantial damage NTSB MIA74AM061Accident · 1 fatalClosedCessna 182J · Birmingham, ALJan 23, 1974 · N3532F · Destroyed NTSB MIA71DKJ44Accident · Minor injuriesClosedCessna 182 · Toney, ALMar 20, 1971 · N2870F · Substantial damage NTSB MIA70FKJ14Accident · No injuriesClosedCessna 182J · Huntsville, ALJan 27, 1970 · N2796F · Substantial damage NTSB MIA70D0222Accident · No injuriesClosedCessna 182 · Bessemer, ALSep 4, 1969 · N3532F · Substantial damage NTSB MIA68A0068Accident · 3 fatalClosedCessna 182 · Calera, ALFeb 17, 1968 · N2671F · Destroyed NTSB MIA68D0366Accident · No injuriesClosedCessna 182 · Dothan, ALDec 9, 1967 · N3514F · Substantial damage