NTSB investigations: Cessna 182Q
17 cases on aircraft the registry lists as Cessna 182Q, where the first occurrence was “Overrun”. 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 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2007 | 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 ('2072732')
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\" = 340))
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 ('2072732')
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" = 340))
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 SEA07CA257Accident · No injuriesData collectionFinal reportCessna 182Q · Dunsmuir, CAThe pilot's misjudgment of distance/speed and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun during the landing roll.NTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.NTSB IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindNTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.NTSB LAX96LA079Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fallbrook, CAthe pilot's inadequate preflight planning/preparation (failure to ensuring the flight information publication was current); his selection of the wrong runway for landing; his failure to achieve the proper touchdown point during the landing; and his failure to…NTSB MIA96LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Snellville, GAThe pilot's failure to attain the proper touchdown point on landing. The sunglare and wet grass were factors.NTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.NTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.NTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.NTSB ATL90LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cumming, GAA lack of fluid in the brake system and an inadequate annual inspection.NTSB CHI86FEE02Accident · Serious injuriesFinal reportCessna 182Q · Lansing, ILWhile on the return flt to Lansing, IL, the plt checked the midway ATIS for info. He believed that just before landing at the Lansing muni arpt, the wind had shifted to the east. According to witnesses, the acft touched down on the last 1/3 of the 2432 ft…NTSB FTW84LA251Accident · No injuriesLimited investigationFinal reportCessna 182Q · Whitney, TXAccording to the plt, he was unable to stop the acft after landing on a 2000 ft asphalt rwy. The acft overran the end of the rwy & hit a ditch. The nose gear collapsed & the acft nosed over. The wind was reported blowing from 210 deg at 20 gusting 25 KTS.…NTSB MKC83LA180Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hunter, KSThe plt reported that during arrival at the private strip, his apch was a bit hi & slightly fast. While landing, the acft floated in ground effect. Subsequently, it overran the rwy & impacted a wire fence & dirt bank.NTSB CHI83LA328Accident · No injuriesLimited investigationFinal reportCessna 182Q · Turner, MIThe plt reported that during a landing, the acft touched down at about the midpoint of a 2140 ft, grass rwy. When he applied braking action, the acft skidded on the grass surface & the plt was unable to stop on the landing area. After departing the rwy, the…NTSB LAX83LA326Accident · No injuriesLimited investigationFinal reportCessna 182Q · Buckeye, AZThe pilot stated that two attempts to land at turkey airstrip resulted in difficulty in achieving a proper final approach path. After some maneuvering on the 2nd approach the acft landed. One witness described the landing as hot with some floating and a late…NTSB DEN83LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · New Harmony, UTThe acft ran off the departure end of the rwy during landing after going through a fence/bushes and the acft nosed over. The pilot had made one go-around because of excessive airspeed. He said the windsock was limp as he obseved it. However,winds at cedar…NTSB SEA82DA105Accident · No injuriesFinal reportCessna 182Q · Spokane, WAThe pilot reported that after checking the wind sock, an approach was made to the runway over trees. Reportedly, the first approach was uncomfortable, so a go-around was made. The pilot stated that the second approach and touchdown were normal, but there was…