NTSB investigations: Cessna 182Q
13 cases on aircraft the registry lists as Cessna 182Q, where the first occurrence was “Loss of engine power”. 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
| 1986 | 2 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 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 ('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\" = 350))
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" = 350))
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 LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.NTSB ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB FTW01LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Houston, TXthe loss of engine power for an undetermined reason, which resulted in a collision with terrain.NTSB CHI00LA252Accident · No injuriesLimited investigationFinal reportCessna 182Q · Warsaw, MOInadequate maintenance and the pilot's failure to maintain airspeed which resulted in failure of the carburetor and an inadvertent stall.NTSB ANC99LA120Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fairbanks, AKA loss of engine power for an undetermined reason. A factor was unsuitable terrain for a forced landing.NTSB MIA99LA192Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rock Springs, NC**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB ANC95GA048Accident · 1 fatalFinal reportCessna 182Q · Bumping Lake, WAA loss of engine power for an undetermined reason. Factors relating to the accident were: lack of suitable terrain for a forced landing in mountains, low ambient temperatures that contributed to hypothermia, the lack of survival equipment, an erratic ELT…NTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI91LA055Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Jerseyville, ILLoss of engine power for undetermined reasons and the icy runway conditions.NTSB LAX91LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAAn engine failure for undetermined reasons.NTSB SEA87LA029Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mountain Home, IDOn short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…NTSB ATL86LA060Accident · No injuriesLimited investigationFinal reportCessna 182Q · Carthage, MSWhile on final approach for landing the pilot advanced the throttle to adjust his final approach path and the engine lost power. The aircraft impacted the ground short of the runway and flipped inverted. The engine was later test run and performed to…