NTSB investigations: Cessna 182S
6 cases on aircraft the registry lists as Cessna 182S, where the first occurrence was “In flight encounter with weather”. 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
| 1985 | 1 |
|---|---|
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072701')
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\" = 240))
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 ('2072701')
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" = 240))
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 SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB ATL04FA093Accident · 3 fatalField investigationFinal reportCessna 182S · North Augusta, SCThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and subsequent in-flight collision with trees and the ground.NTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB ATL85FA101Accident · 2 fatalField investigationFinal reportCessna 182R · Burkes Garden, VAThe plt departed manassas without a current wx briefing or filing a flt plan. Plt had also left maps and a list of checkpoints at home. His route of flt was into an area of low ceilings and visibility. The acft crashed into a mountain at the 3850 ft level.…