NTSB investigations: Cessna R182, VA
7 cases on aircraft the registry lists as Cessna R182. 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
| 1978 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 2019 | 1 |
| 2024 | 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.\"eventStateOrRegion\" = 'VA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072734'))
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."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072734'))
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 ERA24LA108Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Abingdon, VAThe pilot's failure to lower the airplane's landing gear prior to landing, which resulted in abnormal runway contact.NTSB GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.NTSB BFO86FA012Accident · No injuriesField investigationFinal reportCessna R182 · Leesburg, VAThe acft dptd dca with 4508,70GAL fuel,and 43LBS equipmt on board which computed out to be 26LBS over max gross. It was flown directly to Leesburg,VA where the winds were generally out of the west and there was the potential for windshear w/i 2000AGL. Both…NTSB BFO85FA071Accident · 2 fatalField investigationFinal reportCessna R182 · Browntown, VADrg a wx briefing, flt prctns for ocnl mtn obscn & IMC were relayed to the plt, but he was not provided a forecast for thunderstorms, nor advised VFR flt was not rcmdd. The route of flt was portrayed as marginal VFR, as was the destn at morgantown (mgm).…NTSB ATL84FA102Accident · No injuriesField investigationFinal reportCessna 182RG II · Chantilly, VAPlt stated he saw baggage tug at a stop, apparently holding, btw taxiways T-1 and T-2. Tug driver reported he stopped at the stop sign, looked left, looked right and observing no acft. He accelerated his vehicle and saw N1734R directly in front of him. He…NTSB ATL84LA074Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Pennington Gap, VAEnroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…NTSB IAD78FID24Accident · No injuriesClosedCessna 182RG · Williamsburg, VA