NTSB investigations: Cessna 182P, VA
12 cases on aircraft the registry lists as Cessna 182P. 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
| 1976 | 3 |
|---|---|
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2013 | 1 |
| 2016 | 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 ('2075816'))
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 ('2075816'))
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 GAA16CA235Accident · No injuriesData collectionFinal reportCessna 182P · Williamsburg, VAThe pilot's failure to maintain directional control during the landing in variable direction and gusting wind conditions, resulting in a landing off the side of the runway and impact with a drainage culvert.NTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.NTSB NYC03LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Blacksburg, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB IAD96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Saluda, VAwas the pilot's failure to follow the manufacturer's recommended approach reference speed (VREF) during the approach.NTSB BFO85LA069Accident · No injuriesLimited investigationFinal reportCessna 182P · Holly Grove, VAAfter takeoff, the acft lost pwr approximately 150 feet AGL. The plt added carburetor heat and turned the acft back towards gvm spring airport, gum spring, Virginia, but an emergency landing was executed in a short pasture, approximately 100 yards short of…NTSB ATL84LA154Accident · No injuriesLimited investigationFinal reportCessna 182P · Louisa, VAThe plt reported that the grass & ridges on the strip held the acft's speed down more than expected during the takeoff roll, so the plt decided to abort. The plt later stated that he could have made it safely, but his 'instinct' was stronger so he decided to…NTSB ATL82FA107Accident · 2 fatalClosedCessna 182 · Berryville, VANTSB ATL81FA012Accident · No injuriesClosedCessna 182P · Richmond, VANTSB IAD78FA002Accident · 4 fatalClosedCessna 182P · Wise, VANTSB IAD77DIA04Accident · No injuriesClosedCessna 182P · Chantilly, VANTSB IAD77FIA01Accident · Serious injuriesClosedCessna 182P · Nokesville, VANTSB IAD77FA007Accident · 1 fatalClosedCessna 182 · Centreville, VA