Final NTSB investigations: Cessna T182
7 cases on aircraft the registry lists as Cessna T182. 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
| 1981 | 1 |
|---|---|
| 1987 | 1 |
| 1997 | 1 |
| 2002 | 2 |
| 2006 | 1 |
| 2013 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072736'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072736'))
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 ERA13LA112Accident · No injuriesLimited investigationFinal reportCessna T182 · Brandon, FLFailure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.NTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…NTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…NTSB CHI82FA018Accident · No injuriesClosedCessna T182Q · Lansing, MI