NTSB investigations: Cessna 182A, VA
12 cases on aircraft the registry lists as Cessna 182A. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 2002 | 1 |
| 2011 | 2 |
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 ('2072704'))
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 ('2072704'))
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 ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.NTSB ERA11CA267Accident · Minor injuriesData collectionFinal reportCessna 182A · Galax, VAThe pilot's inadequate compensation for the wind while on approach for landing.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.NTSB BFO85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe student plt taxied the acft to the run-up area and stopped with the engine running. The passenger, a rated helicopter pilot, exited the airplane to retrieve a portable communications radio. According to the student, the passenger ducked under the wing…NTSB ATL80FIA11Accident · Minor injuriesClosedCessna 182A · Somerville, VANTSB IAD74FID40Accident · No injuriesClosedCessna 182 · Danville, VANTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VANTSB DIA68F0122Accident · No injuriesClosedCessna 310 · Sandston, VANTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VANTSB NYC66F0079Accident · No injuriesClosedCessna 182 · Woodbridge, VANTSB NYC65F0211Accident · No injuriesClosedCessna 182 · Dulles Arpt, VA