NTSB investigations: Cessna 182M
12 cases on aircraft the registry lists as Cessna 182M, 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
| 1985 | 2 |
|---|---|
| 1986 | 2 |
| 1988 | 2 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1999 | 2 |
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 ('2072728')
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 ('2072728')
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 SEA99LA156Accident · No injuriesLimited investigationFinal reportCessna 182M · Sandpoint, IDThe pilot's improper flare. Factors include a runway that sloped uphill, and the pilot's failure to familiarize himself with the destination airstrip prior to departure.NTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.NTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB SEA88LA146Accident · No injuriesLimited investigationFinal reportCessna 182 · Veradale, WAThe pilot stated a high sink rate developed on final approach which he was unable to arrest with power. Acft landed hard and short, contacting a 3-FT berm at end of grass strip. During roll-out, flames were noted in aft cabin area. Occupants exited and acft…NTSB LAX88LA219Accident · No injuriesLimited investigationFinal reportCessna 182M · Flagstaff, AZAt the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising…NTSB MKC86LA096Accident · No injuriesLimited investigationFinal reportCessna 182M · Mountain Home, ARThe acft nose gear collapsed during a hard landing. The plt stated that his original destination was gastons arpt, lakeview, AR, which has a turf rwy. There are three other arpts in close proximity to gastons, but all have paved rwys. He further stated that…NTSB NYC86LA075Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Indiana, PACessna 182 landed in deep snow off the right side of the runway. The aircraft touched down hard broke the nose wheel and the Cessna flipped over and received substantial damage. There was no fire. There were no injuries to the pilot and one passenger.. The…NTSB FTW85LA301Accident · No injuriesLimited investigationFinal reportCessna 182M · Tulia, TXThe student plt, with 2 hrs total night experience, flared high on final and stalled the acft, which subsequently landed hard on the nose gear, during a night practice flt. The plt stated that the red instrument lights would not work when he turned them on.…NTSB FTW85LA228Accident · No injuriesLimited investigationFinal reportCessna 182M · Chickasha, OKThe acft bounced during landing and the student plt allowed the acft to porpoise. The nose gear, engine firewall and propeller were damaged. This was the student's first solo flt. His last 2.7 hrs of dual flt instruction consisted of 18 practice touch and go…