NTSB investigations: Cessna 182J, FL

14 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, FL per year, 1967–2026: 14 cases
1967	1
1968	5
1975	2
1978	1
1985	1
1986	1
1988	1
2001	1
2005	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 ('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\" = '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 ('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" = '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 ('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 MIA06CA010Accident · No injuriesData collectionFinal reportCessna 182J · Punta Gorda, FLThe pilot's inadequate remedial action following an encounter with wind gusts during the landing flare resulting in a hard landing and damage to the nose landing gear.Oct 16, 2005 · N3588F · Substantial damage NTSB MIA01FA077Accident · 2 fatalField investigationFinal reportCessna 182J · Stuart, FLThe loss of engine power due to undetermined reasons resulting in the forced landing. A factor in the accident was the unsuitable terrain encountered during the forced landing.Feb 13, 2001 · N979ND · Destroyed NTSB MIA89LA021Accident · No injuriesLimited investigationFinal reportCessna 182J · Okeechobee, FLThe plt rprtd that while landing at night, the acft bounced twice. Subsequently, it went off the rwy & onto a grass area. During the occurrence, the nose gear collapsed.Oct 29, 1988 · N2911F · Substantial damage NTSB MIA86LA237Accident · No injuriesLimited investigationFinal reportCessna 182-A · Tampa, FLThe 129 hour private pilot was landing on a runway with a 70 degree left crosswind and stated that upon touchdown the aircraft veered to the left and crashed into the trees. Post accident examination of the nose gear steering system and the brakes revealed no…Aug 15, 1986 · N3330F · Substantial damage NTSB MIA85LA160Accident · No injuriesLimited investigationFinal reportCessna C-182J · Loughman, FLThe acft was towing a banner at 500 ft alt when the engine lost power. The pilot amde an emergency landing in a sandy field and the acft nosed over. The acft had flown 1 hr 15 min with the fuel tank selector on 'both'. The acft took off with a total of aprx…Apr 27, 1985 · N2892F · Substantial damage NTSB MIA78DLA42Accident · No injuriesClosedCessna 182 · Gainesville, FLJul 4, 1978 · N3592F · Substantial damage NTSB MIA75FLD60Accident · No injuriesClosedCessna 182J · Lakeland, FLMar 16, 1975 · N3397F · Substantial damage NTSB MIA75AM061Accident · 1 fatalClosedCessna 182J · Tampa, FLFeb 20, 1975 · N456BC · Destroyed NTSB MIA69A0018Accident · 3 fatalClosedCessna 177 · Miami, FLOct 5, 1968 · N29407 · 2 aircraft · Destroyed NTSB MIA69D0019Accident · No injuriesClosedCessna 182 · Gainesville, FLMay 2, 1968 · N3587F · Substantial damage NTSB MIA68D0447Accident · No injuriesClosedCessna 182 · Titusville, FLFeb 24, 1968 · N2961F · Substantial damage NTSB MIA68A0069Accident · 2 fatalClosedCessna 182J · Bunnell, FLFeb 18, 1968 · N3000F · Destroyed NTSB MIA68D0445Accident · No injuriesClosedCessna 182 · Orlando, FLJan 23, 1968 · N3567F · Substantial damage NTSB MIA68D0063Accident · No injuriesClosedCessna 182J · Williston, FLJul 3, 1967 · N2405Q · Substantial damage