NTSB investigations: Cessna 182A, MO
13 cases on aircraft the registry lists as Cessna 182A. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MO' 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 ('2072704'))
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" = 'MO' 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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.NTSB CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB MKC86LA200Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lexington, MOThe student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft…NTSB MKC81FCG45Accident · No injuriesClosedCessna 182A · Lexington, MONTSB MKC78FCG25Accident · No injuriesClosedCessna 182A · Lexington, MONTSB MKC78FCG08Accident · No injuriesClosedCessna 182A · Atherton, MONTSB MKC66F0567Accident · No injuriesClosedCessna 182 · Maryville, MONTSB MKC66D0472Accident · No injuriesClosedCessna 182A · Marshall, MONTSB MKC66F0021Accident · Serious injuriesClosedCessna 182 · Kansas City, MONTSB MKC65F0126Accident · No injuriesClosedCessna 182 · Sullivan, MONTSB UNK64X1938Accident · No injuriesClosedCessna 182 · Valley Park, MO