NTSB investigations: Cessna 182G
10 cases on aircraft the registry lists as Cessna 182G, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1997 | 2 |
| 2005 | 2 |
| 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\" = 353))
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" = 353))
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 LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.NTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.NTSB SEA05CA045Accident · Minor injuriesData collectionFinal reportCessna 182G · Redmond, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Trees were factors.NTSB ATL97FA135Accident · 1 fatalField investigationFinal reportCessna 182G · Lexington, TNImproper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.NTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.NTSB FTW85LA361Accident · No injuriesLimited investigationFinal reportCessna 182G · Maypearl, TXPlt stated that shortly after takeoff, the engine failed completely without warning. He set up for and executed a forced landing in a field. During the flare, one wing tip struck the top of a tree and during the landing roll the acft crossed several terraces,…NTSB CHI84LA367Accident · No injuriesLimited investigationFinal reportCessna 182G · Crawfordsville, INPlt stated that while en route the generator circuit breaker popped and attempts to reset it proved futile. A loss of pwr occurred later in the flt and a forced landig was made in a field during which the acft was damaged. No fuel was found in the acft after…NTSB MIA84LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Brandon, FLThe acft had been parked for about 2 mos with a partial fuel load. Prior to departure, 40 gal of auto fuel was added & both wing tank sumps & the gascolator were drained with only a minimal amount of water found. Shortly after takeoff, the eng lost power.…NTSB ATL83LA289Accident · No injuriesLimited investigationFinal reportCessna 182G · Simpsonville, KYShortly after beginning the initial descent for a landing at the destination, the eng lost power, but continued to run intermittently. The plt was unable to restore full power & made an emergency landing on a highway. During the landing roll, the left wing…NTSB MIA83LA002Accident · No injuriesLimited investigationFinal reportCessna 182 · Cocoa, FLDuring takeoff, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot s-turned and landed on a clear area beside the runway to keep from going into a river. Subsequently, the nose gear collapsed and the aircraft flipped over.…