NTSB investigations: Cessna 182J
9 cases on aircraft the registry lists as Cessna 182J, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1988 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2003 | 1 |
| 2005 | 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 ('2072722')
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\" = 260))
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 ('2072722')
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" = 260))
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 DFW05CA057Accident · No injuriesData collectionFinal reportCessna 182J · Malvern, ARThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the sun glare.NTSB SEA03LA083Accident · No injuriesLimited investigationFinal reportCessna 182J · Payette, IDThe pilot-in-command's failure to maintain directional control during the landing roll resulting in the aircraft departing the runway environment, collapsing the nose gear and nosing over. Contributing factors were the pilot-in-command's failure to execute a…NTSB CHI97LA065Accident · No injuriesLimited investigationFinal reportCessna 182J · Gaylord, MIthe student pilot's inadequate compensation for the wind conditions which resulted in a failure to maintain proper runway alignment. Factors associated with the accident were: the gusty, crosswind condition, the pilot's failure to perform a go-around, and the…NTSB ANC96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nikiski, AKThe pilot's failure to maintain directional control during takeoff.NTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.NTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…NTSB MIA86LA237Accident · No injuriesLimited investigationFinal reportCessna 182-A · Tampa, FLThe 129 hour private pilot was landing on a runway with a 70 degree left crosswind and stated that upon touchdown the aircraft veered to the left and crashed into the trees. Post accident examination of the nose gear steering system and the brakes revealed no…NTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…NTSB FTW84LA175Accident · No injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXThe acft landed long & fast with a 10 kt tailwind. The pilot was unable to stop the acft on the remaining rwy & ran of of the end. The left brake was found inop due to a lack of brake fluid. The acft was observed to veer to the right of the rwy prior to…