NTSB investigations: Cessna 182N

6 cases on aircraft the registry lists as Cessna 182N, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19822026

NTSB investigations: Cessna 182N per year, 1982–2026: 6 cases
1982	1
1986	1
1991	1
1994	1
1996	1
2001	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 ('2072730') 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" = 351)) 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 ('2072730')
      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\" = 351))
  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 ('2072730')
    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" = 351))
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 CHI02LA005Accident · No injuriesLimited investigationFinal reportCessna 182N · Graham, MOA loss of engine power due to the fatigue failure of the number 2 piston. Contributing to the accident was the unsuitable terrain.Oct 12, 2001 · N92913 · Substantial damage NTSB FTW96LA280Accident · No injuriesLimited investigationFinal reportCessna 182N · Truth Or Conseq, NMThe loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.Jun 30, 1996 · N9001G · Substantial damage NTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.Oct 8, 1994 · N8903G · Substantial damage NTSB SEA91LA103Accident · No injuriesLimited investigationFinal reportCessna 182N · Shelton, WAThe total loss of power due to mechanical failure when the pilot was over unsuitable terrain for a forced landing. Factors include a hard landing after an inadvertent stall prior to touchdown on a highway.May 11, 1991 · N8949G · Substantial damage NTSB LAX86FA326Accident · Serious injuriesField investigationFinal reportCessna 182N · Wilmington, CADuring a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…Aug 20, 1986 · N92252 · Destroyed NTSB NYC83FA045Accident · 1 fatalField investigationFinal reportCessna 182N · Ringwood, NJThe plt declared an emergency due to power loss & the acft crashed into a reservoir. Engine examination disclosed numerous pieces of the induction air filter throughout the engine. Filter paper was found lodged between the intake valve & valve seat of the #5…Dec 18, 1982 · N92612 · Substantial damage