NTSB investigations: Cessna 182A

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

19842026

NTSB investigations: Cessna 182A per year, 1984–2026: 8 cases
1984	1
1990	1
1991	1
1998	1
2001	1
2003	1
2004	2

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 ('2072704') 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" = 354)) 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 ('2072704')
      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\" = 354))
  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 ('2072704')
    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" = 354))
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 CHI04CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Noblesville, INThe pilot's failure to select carburetor heat and his failure to maintain airspeed resulting in a stall. Factors were unstabilized approach the aircraft's low altitude, and the weather conditions conducive to carburetor icing.Jul 25, 2004 · N3708D · Substantial damage NTSB ATL04LA105Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Elberta, ALThe loss of engine power due to a foreign substance blockage of the fuel line which resulted in fuel starvation, and the pilot's failure to maintain terrain clearance during an aborted landing.May 1, 2004 · N5099D · Substantial damage NTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.Sep 7, 2003 · N6384B · Substantial damage NTSB CHI02LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Wahoo, NEThe pilot's inadequate preflight planning/preparation resulting in fuel exhaustion during cruise flight, and the unsuitable terrain for landing encountered by the pilot during the subsequent forced landing. Factors relating to the accident were the pilot's…Nov 10, 2001 · N3916D · Substantial damage NTSB FTW98LA146Accident · No injuriesLimited investigationFinal reportCessna 182A · Jacksonville, TXThe partial loss of engine power for undetermined reasons. Factors were the poor braking conditions due to the grassy wet runway.Mar 14, 1998 · N2130G · Substantial damage NTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.May 17, 1991 · N5048D · Substantial damage NTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.Sep 9, 1990 · N5146D · Substantial damage NTSB FTW84LA310Accident · No injuriesLimited investigationFinal reportCessna 182A · Marshall, TXThe acft was descended in a long glide from 5000 ft. the engine did not respond to throttle application on final. Pumping the throttle produced brief restarts. The plt landed in a rough field off the arpt. The nose gear separated and the acft nosed over. No…Jul 14, 1984 · N5885B · Substantial damage