NTSB investigations: Cessna 182B
9 cases on aircraft the registry lists as Cessna 182B, 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
| 1985 | 1 |
|---|---|
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2006 | 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 ('2072706')
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 ('2072706')
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 LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.NTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.NTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.NTSB LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.NTSB LAX92LA251Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Big Bear Lake, CAThe lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.NTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.NTSB SEA89LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Bonneville, WASome form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.NTSB SEA85LA167Accident · No injuriesLimited investigationFinal reportCessna 182 · Denio, NVA loss of pwr occurred while cruising above mountainous terrain. During forced landing the nose gear collapsed and the acft nosed over. The eng had just been rebuilt less than 37 hrs prior to the accident. The plt stated that a week prior to the accident the…