NTSB investigations: Cessna 182F
6 cases on aircraft the registry lists as Cessna 182F, 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
| 1983 | 3 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1994 | 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 ('2072714')
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 ('2072714')
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 FTW94LA308Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Monte Vista, COThe pilot's failure to maintain directional. Factors were the cross wind conditions, and the pilot's poor evaluation of the weather.NTSB DEN89LA086Accident · No injuriesLimited investigationFinal reportCessna 182 · Tooele, UTInadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors.NTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…NTSB DEN83LA208Accident · No injuriesLimited investigationFinal reportCessna 182F · Fort Morgan, COThe acft went off the rwy and nosed over during landing. The plt landed on rwy 14 with the wind reported as being from 250 degrees at 5 KTS with gusts to 7 KTS. The plt reported a gust of wind picked up the right wing. He lost directional control, the acft…NTSB FTW83LA359Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Houston, TXThe acft collided with an unoccupied pickup truck during the landing roll. The truck was parked off the left side of therwy. The acft had started drifting right during the landing flare. As the acft touched down the student was correcting back to the left…NTSB MKC83LA132Accident · No injuriesLimited investigationFinal reportCessna 182F · Dows, IAThe acft nosed over during takeoff. The rwy used was 090 and the wind was from 170 degrees at 17 KTS. The plt said the acfts right wing raised followed by the tail and then the left wing dropped impacting the sod rwy before the acft nosed over.