NTSB investigations: Cessna 182G
8 cases on aircraft the registry lists as Cessna 182G, where the first occurrence was “Loss of control - in flight”. 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 |
|---|---|
| 1987 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 2003 | 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 ('2072716')
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\" = 250))
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 ('2072716')
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" = 250))
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 SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.NTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.NTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.NTSB LAX93LA376Accident · No injuriesLimited investigationFinal reportCessna 182G · Carson City, NV1) the pilot's failure to maintain an appropriate airspeed during an attempted go around, 2) his failure to retract the landing flaps, and 3) the resulting inadvertent entry into a stall/mush condition.NTSB SEA91LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Pleasant Grove, UTThe pilot's failure to maintian proper airspeed while on final approach.NTSB ANC87LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Chistochina, AKDuring a telephone interview the pilot stated the aircraft did not produce full power and believed the reason was the propeller setting was not set to high RPM before landing. The aircraft stalled on final approach to the airport and the aircraft impacted the…NTSB CHI87FA114Accident · 1 fatalField investigationFinal reportCessna 182G · West Point, INDrg an IFR arrival, the plt was clrd for an ILS rwy 10 apch. No radar facilities were available, but at 1026 EST, he rprtd he was established on the localizer. Aprx 4 min later, he declared a missed apch & was cleared back to the outer marker (om), then was…NTSB LAX85LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker, AZThe pilot stated that he encountered shifting winds on landing at his destination airport and that turbulence was severe. There is no record of a weather briefing prior to departure.