NTSB investigations: Cessna 182G
6 cases on aircraft the registry lists as Cessna 182G, where the first occurrence was “Loss of engine power”. 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
| 1986 | 1 |
|---|---|
| 1987 | 2 |
| 1996 | 1 |
| 1999 | 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\" = 350))
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" = 350))
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 SEA07LA255Accident · No injuriesLimited investigationFinal reportCessna 182G · Fairfield, IDThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight inspection. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Freeland, WAThe pilot-in-command's improper use of carburetor heat and overload of the nose gear assembly during the forced landing. Contributing factors were carburetor icing conditions, the ditch and fence.NTSB SEA97LA026Accident · No injuriesLimited investigationFinal reportCessna 182G · Hardin, MTthe pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…NTSB NYC87LA263Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Kingston, NHDuring flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an…NTSB LAX87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Avenal, CAA Cessna 182G collided with trees during landing rollout on a dirt road. The pilot indicated during a telephone interview that the manifold pressure gradually dropped to 18 pounds. The aircraft was unable to maintain altitude and the pilot landed the aircraft…NTSB SEA86LA051Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Sandy, ORA total loss of power occurred due to a complete loss of oil. During engine teardown it was found that the oil filter adapter had slipped past the threads in the oil pump housing. The aircraft had the oil filter adapter replaced as well as the o ring on…