NTSB investigations: Cessna 182B, SC
7 cases on aircraft the registry lists as Cessna 182B. 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 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1998 | 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\" = 'SC' 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 ('2072706'))
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" = 'SC' 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 ('2072706'))
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 ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.NTSB ATL84LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Spartanburg, SCThe acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.NTSB ATL82FLG14Accident · Serious injuriesFinal reportCessna 182B · Charleston, SCThe flight departed conway, Arkansas for a non-stop flt to Charleston. Approximately 4 to 5 miles from the airport at Charleston, with the runway in sight, the engine quit. The acft struck trees drg a forced landing on a power line right-of-way 2 miles short…NTSB MIA71AM027Accident · 1 fatalClosedCessna 182B · Darlington, SCNTSB MIA70FLG18Accident · Serious injuriesClosedCessna 182B · Charleston, SCNTSB MIA68F0186Accident · No injuriesClosedCessna 182B · Greenville, SCNTSB MIA65D0109Accident · Serious injuriesClosedCessna 182 · Anderson, SC