NTSB investigations: Cessna 182H
4 cases on aircraft the registry lists as Cessna 182H, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 1986 | 1 |
| 1995 | 1 |
| 2007 | 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 ('2072718')
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\" = 240))
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 ('2072718')
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" = 240))
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 SEA07CA067Accident · Minor injuriesData collectionFinal reportCessna 182H · Jean, NVThe pilot's failure to adequately compensate for the wind conditions during final approach, which resulted in a loss of control and an in-flight collision with terrain. A contributing factor was the windshear condition encountered.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…NTSB SEA83LA126Accident · No injuriesLimited investigationFinal reportCessna 182H · Petersburg, AKThe student plt was on a night flt from whitehorse to prince rupert, Canada via skagway & juneau, AK. According to him, when passing the five fingers NDB to enter the strait, he encountered southeast winds of aprx 25 KTS. On attempting to return to juneau, he…