NTSB investigations: Cessna 182M, WA
6 cases on aircraft the registry lists as Cessna 182M. 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
| 1970 | 1 |
|---|---|
| 1974 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 2012 | 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\" = 'WA' 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 ('2072728'))
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" = 'WA' 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 ('2072728'))
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 WPR12CA226Accident · Minor injuriesData collectionFinal reportCessna 182M · Vashon Island, WAThe pilot's loss of directional control during a rejected takeoff, which resulted in a noseover.NTSB SEA93LA097Accident · No injuriesLimited investigationFinal reportCessna 182N · Anacortes, WAThe loss of control by the PIC when he selected the wrong runway, failed to attain the proper touchdown point, inadvertently stalled the acft attempting to abort the landing, and failed to maintain directional control after the aircraft mushed back onto the…NTSB SEA88LA146Accident · No injuriesLimited investigationFinal reportCessna 182 · Veradale, WAThe pilot stated a high sink rate developed on final approach which he was unable to arrest with power. Acft landed hard and short, contacting a 3-FT berm at end of grass strip. During roll-out, flames were noted in aft cabin area. Occupants exited and acft…NTSB SEA86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 182 · East Sound, WADuring landing roll at about 25 mph the pilot applied both brakes. A short time thereafter the right brake pedal went to the floor. Despite the pilot's application of hard left brake and rudder, the acft veered to the left into a drainage ditch. The nose gear…NTSB SEA75FYC22Accident · No injuriesClosedCessna 182M · Vancouver, WANTSB SEA70AS045Accident · 2 fatalClosedCessna 182M · Laurier, WA