NTSB investigations: Cessna R182

8 cases on aircraft the registry lists as Cessna R182, where the first occurrence was “In flight collision with object”. 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 R182 per year, 1982–2026: 8 cases
1982	2
1983	1
1988	2
1993	1
2000	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 ('2072734') 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" = 220)) 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 ('2072734')
      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\" = 220))
  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 ('2072734')
    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" = 220))
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 CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.Jun 11, 2001 · N2344C · Substantial damage NTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.Aug 16, 2000 · N3674C · Destroyed NTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.Oct 11, 1993 · N6422S · Destroyed NTSB CHI88FA237Accident · 2 fatalField investigationFinal reportCessna 182RG · Zanesville, OHThe pilot's poor judgement/decision-making, and his over confidence in his own ability which led to his repeated decisions to operate his aircraft in adverse weather conditions. The fact that the pilot had operated the aircraft in adverse weather conditions…Sep 18, 1988 · N9877C · Destroyed NTSB LAX88LA111Accident · Serious injuriesLimited investigationFinal reportCessna R182 · San Andreas, CADuring a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not…Feb 22, 1988 · N3178C · Destroyed NTSB FTW83LA113Accident · No injuriesLimited investigationFinal reportCessna R182 · George West, TXThe plt reported that after he touched down on a wet grass runway, he was unable to stop, so he elected to go around. During the go-around, the gear collided with a fence, and subsequently, the acft crashed into trees and a building.Feb 11, 1983 · N737PT · Destroyed NTSB ATL83LA057Accident · No injuriesLimited investigationFinal reportCessna 182B · Huntsville, ALThe aircraft collided with trees during a landing approach in instrument meeorological conditions on a dark night. A VFR flight plan was filed. The aircraft was damaged in the collision but the pilot managed to continue the approach and land. No injuries were…Dec 9, 1982 · N4718S · Substantial damage NTSB ATL82FKQ15Accident · 3 fatalFinal reportCessna R182 · Ocean Springs, MSA pilot-rated witness observed the entire flight and accident. He stated that after takeoff and gear retraction, the aircraft was held at a very low altitude, which he thought was to gain airspeed. The aircraft reached the end of the runway and went into a…Jun 19, 1982 · N757FB · Destroyed