NTSB investigations: Cessna 182
10 cases on aircraft the registry lists as Cessna 182, 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2002 | 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 ('2072702')
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 ('2072702')
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 LAX02LA298Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lucerne Valley, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.NTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.NTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).NTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.NTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.NTSB LAX88LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Ajo, AZThe plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…NTSB DEN83LA181Accident · No injuriesLimited investigationFinal reportCessna 182 · Forsyth, MTThe flt originated at cambridge, id with a planned refueling stop at billings, MT. The plt stated the acft was 'topped off' at cambridge before takeoff. En route, southerly winds were encountered which drifted the acft north, so a refueling stop was made at…NTSB MKC83LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Cuba, MOPilot says aircraft lost power at 200 feet AGL. Forced landing resulted in collision with a tree stump. No reason for engine malfunction found.NTSB ATL82DA194Accident · Minor injuriesFinal reportCessna 182 · Madison, INThe pilot reported that he experienced a gradual loss of power on a dark night. The terrain was hilly and covered with trees, and reportedly, the pilot elected to land upwind on the Ohio river. After ditching, the occupants egressed and swam to shore, but the…