NTSB investigations: Cessna 182A, MT
9 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
| 1965 | 3 |
|---|---|
| 1968 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1999 | 1 |
| 2016 | 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\" = 'MT' 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" = 'MT' 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 GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.NTSB DEN85LA247Accident · No injuriesLimited investigationFinal reportCessna 182A · Troy, MTThe plt said that as he approached his destination he reduced engine pwr to begin descent. The engine quit forcing the pilot to land on unsuitable terrain. Contaminated fuel was found in the fuel system.NTSB SEA77DTI12Accident · No injuriesClosedCessna 182A · Browning, MTNTSB SEA73AS011Accident · 2 fatalClosedCessna 182A · Ennis, MTNTSB SEA68D0259Accident · No injuriesClosedCessna 182 · Fishtail, MTNTSB SEA66D0064Accident · No injuriesClosedCessna 182A · Schafer, MTNTSB SEA65A0060Accident · 3 fatalClosedCessna 182A · Malta, MTNTSB SEA66F0033Accident · No injuriesClosedCessna 182A · Shelby, MT