NTSB investigations: Cessna 182L
9 cases on aircraft the registry lists as Cessna 182L, 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2006 | 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 ('2072726')
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 ('2072726')
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 DFW07CA127Accident · Minor injuriesData collectionFinal reportCessna 182L · Cheneyville, LAThe loss of engine power while climbing due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the soft terrain at the forced landing site.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.NTSB DEN87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182L · La Junta, COThe engine quit during cruise flt at 8,500 feet MSL. During the emergency landing to unsuitable terrain, the acft nosed over. The plt had flown 5 hours on this flt. The long range fuel tanks had been installed with the filler ports inboard, limiting the total…NTSB ATL85LA122Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Falmouth, KYDuring flt in IMC conditions at 9000 ft MSL, the plt noted a loss of airspeed indications. He requested & received clearance to descend. During the descent, he elected to divert & received vectors for a nearby arpt. However, when he attempted to level off,…NTSB CHI84LA140Accident · No injuriesLimited investigationFinal reportCessna 182L · New Hudson, MIShortly after leveling off at 3000 ft the cabin of the acft filled with smoke and the acft lost all oil pressure. Shortly after this the engine quit. During the forced landing in a corn field the acft nosed over. During a post accident investigation it was…NTSB ATL83FA095Accident · 1 fatalField investigationFinal reportCessna 182L · Weyers Cave, VAThe acft crashed after takeoff when the engine lost power. The acft had not been flown for several months. An instructorwas invited on the extended cross-country to help the pilot who also had not flown for some time. During the pre-flight a considerable…