NTSB investigations: Cessna 182
9 cases on aircraft the registry lists as Cessna 182, where the first occurrence was “Loss of control - in flight”. 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
| 1987 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 3 |
| 1993 | 2 |
| 1998 | 1 |
| 2004 | 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\" = 250))
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" = 250))
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 FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.NTSB FTW94FA028Accident · 3 fatalField investigationFinal reportCessna 182P · Marlow, OKAn inoperative vacuum system, an inoperative turn & bank indicator, and an inoperative directional gyro, which resulted in an inability of the pilot to control the airplane after it encountered instrument meteorological conditions (IMC). Factors related to…NTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.NTSB FTW92FA048Accident · 1 fatalField investigationFinal reportCessna 182 · Santa Teresa, NMThe pilot's failure to maintain control. Factors were the dark night, pilot's apprehension, pilot's lack of instrument experience, spatial disorientation, poor instrument location, visual perception and inadequate cockpit lighting.NTSB NYC91LA252Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hadley, MAAn inflight loss of control due to entanglement of a prematurely deployed parachute in the elevator.NTSB ANC91FA107Accident · 1 fatalField investigationFinal reportCessna 182 · Takotna, AKThe pilot's loss of control in flight due to spatial disorientation while attempting to operate under visual flight rules while in instrument meteorological conditions. Contributing to the accident was the mountainous terrain.NTSB CHI90FA240Accident · 2 fatalField investigationFinal reportCessna 182 · Marine City, MIPilot-in-command's ostentation display resulted in his failure to maintain flying sped, and a subsequent stall.NTSB ATL87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Waycross, GADuring a normal approach to a sod strip, the pilot reported that the gusty wind condition ceased and the acft stalled to the ground short of the intended landing area. The pilot was not able to recover from the sinking condition. The impact caused substantial…