NTSB investigations: Cessna 182J
7 cases on aircraft the registry lists as Cessna 182J, 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2005 | 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 ('2072722')
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 ('2072722')
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 MIA06CA010Accident · No injuriesData collectionFinal reportCessna 182J · Punta Gorda, FLThe pilot's inadequate remedial action following an encounter with wind gusts during the landing flare resulting in a hard landing and damage to the nose landing gear.NTSB DEN99FA114Accident · 2 fatalField investigationFinal reportCessna 182J · La Veta, COThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain control of the aircraft. Factors were low ceiling and the pilot's lack of instrument experience.NTSB CHI92LA019Accident · No injuriesLimited investigationFinal reportCessna 182U · Rolla, MOThe pilot in command's failure to attain a proper flare on landing. A factor contributing to the accident was the pilot in command's inadvertent encounter with instrument meteorological conditions.NTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…NTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…NTSB MKC86FA139Accident · 4 fatalField investigationFinal reportCessna 182J · Hartford, ARWhen the acft did not arrive at its destn, a search was initiated. The wreckage was located 4 days later where the acft crashed in mountainous terrain. An investigation revealed there was severe thunderstorm activity in the area at the time of the accident.…NTSB DEN84LA069Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Alamosa, COThe plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft…