NTSB investigations: Cessna R182
12 cases on aircraft the registry lists as Cessna R182, where the first occurrence was “Hard landing”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 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 ('2072734')
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\" = 200))
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 ('2072734')
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" = 200))
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 LAX07CA251Accident · No injuriesData collectionFinal reportCessna R182 · Coeur D'Alene, IDthe instructor's misjudged landing flare.NTSB DEN01LA031Accident · No injuriesLimited investigationFinal reportCessna R182 · Broomfield, COthe flight instructor's inadequate supervision of the dual student, which resulted in a hard landing. Contributing factors were the dual student flaring the airplane prematurely, resulting in an inadvertent stall/mush.NTSB DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB CHI97LA165Accident · No injuriesLimited investigationFinal reportCessna 182RG · Kansas City, MOthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was the excessive airspeed.NTSB CHI91LA044Accident · No injuriesLimited investigationFinal reportCessna 182RG · Lansing, ILExcessive lowering of flaps resulted in aircraft control not being maintained by the pilot..inadequate airspeed resulted in a stall/mush and subsequent collision with the terrain. Factors related to the accident were: a gusty crosswind and a delayed go-around…NTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.NTSB FTW85LA319Accident · No injuriesLimited investigationFinal reportCessna R182 · Lubbock, TXThe plt made a hard landing at the town and country arpt at Lubbock, TX, and a collapse of the nose gear resulted.NTSB CHI85LA162Accident · No injuriesLimited investigationFinal reportCessna R182 · Chicago, ILWhile in the landing flare, the acft apparently touched down on the nose gear & began to porpoise. During the subsequent bounces, the nose gear collapsed & the acft nosed over as it departed the side of the rwy. The plt stated that he felt that a gust of wind…NTSB LAX84LA292Accident · No injuriesLimited investigationFinal reportCessna 182RG · Palo Alto, CAAcft touched down on the nose gear, porpoised and finally impacted the rwy on the nose gear.NTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.NTSB FTW84LA062Accident · No injuriesLimited investigationFinal reportCessna R182 · Houston, TXThe acft nosed down during a crosswind landing. The rwy is 100/280 degrees and the wind was 360 degrees at 19 KTS. Shortly after the landing touchdown the acft nose gear separated from the acft.NTSB CHI82DA175Accident · No injuriesFinal reportCessna R182 · Cahokia, ILThe pilot was making touch and go landings on runway 30 with a wind from about 180 degrees at 11 KTS. On the fourth landing, the aircraft bounced two or three times. The plane slid sideways, went off the runway, and the nose gear failed.