NTSB investigations: Cessna 182B
5 cases on aircraft the registry lists as Cessna 182B, where the first occurrence was “Overrun”. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 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\" = 340))
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" = 340))
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 SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.NTSB LAX91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Kernville, CA1)The failure of the pilot to accurately assess and compensate for the prevailing wind conditions; 2) his failure to maintain a correct approach speed for the aircraft; 3) his failure to attain a proper touchdown point; and 4) his failure to initiate a go…NTSB SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.NTSB MKC86LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Siloam Springs, ARThe PIC was practicing touch and go landings, and decided to change rwys for his final landing. The PIC stated he landed long on the 1650 foot turf rwy, but went off the end. The PIC stated he should have added pwr and made a go around. The PIC was late in…NTSB ATL84LA283Accident · No injuriesLimited investigationFinal reportCessna 182B · Kannapolis, NCThe plt reported that because of grnd fog in wilkersboro, NC, he diverted to Kannapolis, NC. Upon arriving over enochuille airport, he observed that grnd fog was present on the lake which is located adjacent to the arpt. Due to the fog, the plt elected to…