NTSB investigations: Cessna 182C

7 cases on aircraft the registry lists as Cessna 182C, where the first occurrence was “Loss of engine power”. 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

19862026

NTSB investigations: Cessna 182C per year, 1986–2026: 7 cases
1986	2
1992	1
1996	1
1999	1
2003	1
2007	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 NYC07FA145Accident · 2 fatalField investigationFinal reportCessna 182C · Hiddenite, NCCarburetor icing, which resulted in a loss of engine power. Also causal, was the pilots' failure to maintain airspeed during the forced landing, which resulted in an inadvertent stall.Jun 21, 2007 · N8691T · Destroyed NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.Jun 22, 2003 · N8762T · Substantial damage NTSB FTW99LA089Accident · No injuriesLimited investigationFinal reportCessna 182C · Conway, ARThe total loss of engine power due to carburetor ice. Factors were the weather condition conducive to the formation of carburetor ice and the lack of suitable terrain for the forced landing.Mar 4, 1999 · N8645T · Substantial damage NTSB FTW96LA189Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Malvern, ARfailure of the pilot to apply carburetor heat during the approach to land, which resulted in a loss of engine power due to carburetor ice. A factor relating to the accident was: the carburetor icing (weather) condition.Apr 27, 1996 · N8552T · Destroyed NTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.Oct 4, 1992 · N8773T · Substantial damage NTSB SEA86LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Ashwood, ORA loss of power occurred for unknown reason. During landing roll the aircraft's right main gear struck a rock causing part of the gear box to be torn from the aircraft.Aug 25, 1986 · N9051T · Substantial damage NTSB NYC86LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Pepperell, MAAfter descending to traffic pattern altitude. The throttle was advanced with no response from the engine. On flare to landing, pilot experienced sun glare, drifted to the right, and touched down in a snow bank. Nose gear dug in and aircraft flipped over onto…Mar 2, 1986 · N8776T · Substantial damage