NTSB investigations: Cessna 182Q
13 cases on aircraft the registry lists as Cessna 182Q, where the first occurrence was “In flight collision with terrain/water”. 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 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2001 | 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 ('2072732')
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\" = 230))
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 ('2072732')
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" = 230))
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 MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB FTW99LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Marfa, TXThe pilot's failure to maintain clearance with the dirt bank during the landing flare.NTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.NTSB LAX95LA108Accident · 3 fatalLimited investigationFinal reportCessna 182Q · San Francisco, CAan inflight collision with water for undetermined reasons.NTSB FTW92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Port Sulphur, LAThe pilot planned the approach with a tailwind and did not attain the proper touchdown point. Factors were the tailwind and the delayed aborted landing.NTSB LAX91FA281Accident · 2 fatalField investigationFinal reportCessna 182Q · Fillmore, CAPoor judgement by the pilot to continue VFR flight into instrument meteorological conditions. Contributing to the accident was IFR conditions that included low ceilings and low visibility and insufficient instrument training of the pilot to deal with the IFR…NTSB NYC90FA231Accident · 2 fatalField investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's improper IFR operation in attempting an ILS approach in an airplane not equipped with an ILS glide slope receiver. The weather conditions were factors in the accident.NTSB LAX84LA217Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Hana, HIThe acft disappeared from radar about 8 mi north of Hana, HI, while on an over-water flt. When it did not return from the flt, a search was intiated, but the acft was not found. Only the nose wheel strut (which washed ashore) and a life vest (found by…NTSB SEA83FA139Accident · Serious injuriesField investigationFinal reportCessna 182Q II · Near Peak, ORThe acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…NTSB LAX82DUJ39Accident · Serious injuriesFinal reportCessna 182Q · Camp Verde, AZOn final approach the pilot allowed the aircraft to descend into bushes at the end of the runway. The pilot landed hard, the nose wheel collapsed and the aircraft nosed over.NTSB LAX82FXQ06Accident · 2 fatalFinal reportCessna 182 · Lake Tahoe, CAA pilot who landed prior to the departure of N5298N stated that his aircraft had accumulated 1/4 inch of airframe ice while over the lta VOR. An employee of Lake Tahoe aviation fueling service informed the pilot of N5298N of these weather conditions and ice…NTSB FTW82FQA14Accident · 2 fatalFinal reportCessna 182Q · Fort Sumner, NMThe plane crashed and burned on a dark moonless night after impacting in a nose low attitude. The crash site was located near the home of the pilot's friend where the pilot had visited earlier in the evening. After impacting in soft, level, sandy soil, the…