NTSB investigations: Cessna 182P, KS

9 cases on aircraft the registry lists as Cessna 182P. 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

19732026

NTSB investigations: Cessna 182P, KS per year, 1973–2026: 9 cases
1973	2
1976	1
1978	2
1981	1
1982	2
1983	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" = 'KS' 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 ('2075816')) 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\" = 'KS' 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 ('2075816'))
  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" = 'KS' 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 ('2075816'))
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 MKC83LA110Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Gardner, KSThe acft was throughly preflighted to check for water in fuel. The acft had been outdoors in rain for several weeks. Run-up and taxi were normal. During right turn out of traffic the engine quit. The pilot made a landing in a field and nosed over. The acft…May 16, 1983 · N780H · Destroyed NTSB MKC83LA013Accident · No injuriesLimited investigationFinal reportCessna 182D · Bucklin, KSDuring takeoff, the engine lost power from fuel exhaustion and the pilot made a forced landing in a plowed field. While landing, the wheels dug into the soil and the aircraft nosed over. The pilot stated that he regularily flew another aircraft with a larger…Nov 5, 1982 · N7432N · Substantial damage NTSB MKC82DA018Accident · Minor injuriesFinal reportCessna 182P · Topeka, KSDuring an aerial line patrol flight the pilot encountered low stratus clouds and started to return to billard airport when the engine ceased to operate. The pilot attempted to restart the aircraft but could not. A forced landing was made into a mowed pasture…Jan 19, 1982 · N52757 · Substantial damage NTSB MKC82FCG11Accident · Serious injuriesClosedCessna 182P · Olathe, KSNov 23, 1981 · N9164M · Substantial damage NTSB MKC78FCQ22Accident · No injuriesClosedCessna 182 · Augusta, KSMay 3, 1978 · N1466S · Substantial damage NTSB MKC78DCQ16Accident · No injuriesClosedCessna 182 · Manhattan, KSFeb 18, 1978 · N1431M · Substantial damage NTSB MKC77FCQ03Accident · Serious injuriesClosedCessna 182P · Kinsley, KSOct 19, 1976 · N4657K · Substantial damage NTSB MKC74FCQ20Accident · Serious injuriesClosedCessna 182 · Manhattan, KSDec 3, 1973 · N21357 · Substantial damage NTSB MKC73AK067Accident · No injuriesClosedCessna 182P · Yates Center, KSMay 18, 1973 · N7074Q · Destroyed