NTSB investigations: Cessna 182B
7 cases on aircraft the registry lists as Cessna 182B, where the first occurrence was “On ground/water collision with object”. 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
| 1983 | 1 |
|---|---|
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2000 | 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 ('2072706')
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\" = 310))
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 ('2072706')
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" = 310))
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 ANC00LA062Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot's inadequate compensation for the crosswind conditions, and his excessive use of brakes during landing. A factor associated with the accident was the trees alongside the landing area.NTSB SEA98LA194Accident · No injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDAn animal (cow elk) that had wandered onto the airport.NTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.NTSB IAD96LA152Accident · No injuriesLimited investigationFinal reportCessna 182B · Hanover, PAthe pilot's improper planning/decision and failure to maintain clearance from obstacles during the landing roll. Related factors were: darkness, the lack of usable runway lights, and the road grading equipment parked 50 feet from the edge of the grass runway.NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.NTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.NTSB CHI83LA429Accident · No injuriesLimited investigationFinal reportCessna 150M · Anderson, INCessna 150, N45257, collided with Cessna 182, N2462G, at ace airpark. N45257 was in the process of landing and N2462G was in the takeoff phase of operation. Neither plt used the airport UNICOM. Both plts rept slightly different wx conditions.