NTSB investigations: Cessna 182D
11 cases on aircraft the registry lists as Cessna 182D, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1984 | 3 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2006 | 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 ('2072710')
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\" = 353))
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 ('2072710')
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" = 353))
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 LAX06CA244Accident · No injuriesData collectionFinal reportCessna 182D · Santa Clarita, CAA loss of engine power due to fuel exhaustion. The fuel exhaustion was the result of a split O-ring on the right fuel cap, which allowed fuel to siphon out of the right fuel tank during flight.NTSB CHI99FA252Accident · Minor injuriesField investigationFinal reportCessna 182D · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations and the subsequent fuel exhaustion. Factors associated with the accident were the crops and the soft field conditions.NTSB CHI99LA180Accident · No injuriesLimited investigationFinal reportCessna 182D · Zurich, KSthe pilot's inadequate preflight planning/preparation. A factor was fuel exhaustion.NTSB LAX97LA147Accident · No injuriesLimited investigationFinal reportCessna 182D · Tucson, AZFuel exhaustion due to the inadequate preflight inspections performed by both pilots. A factor in the accident was the crosswind experienced during landing rollout.NTSB LAX96LA288Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Weed, CAThe pilot's improper fuel management. A factor was the lack of suitable terrain for the forced landing.NTSB LAX91LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Show Low, AZEngine failure due to fuel exhaustion. A factor was inoperative fuel gauges.NTSB LAX88LA167Accident · No injuriesLimited investigationFinal reportCessna 182D · Coolidge, AZAt the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…NTSB LAX87LA347Accident · No injuriesLimited investigationFinal reportCessna 182D · San Ramon, CAAfter telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was…NTSB NYC85LA031Accident · No injuriesLimited investigationFinal reportCessna 182D · Woodside, DEThe plt reported that he refueled the acft on 11/12/84 & filled the tanks. Tach time was 1766.95. On 11/20/84, when he took off, he estimated 51 gals of fuel was on board. He flew to another location & landed, then was away from his acft about 1 hr. When he…NTSB LAX84LA489Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Lincoln, CAAfter a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear…NTSB SEA84LA176Accident · No injuriesLimited investigationFinal reportCessna 182D · Eugene, ORThe plt estimated that the acft had about 1 hr of fuel remaining in the tanks prior to departure. However, after he had flown about 15 min, the eng lost power & would not restart. An emergency landing was made in a meadow about 2 mi from the arpt. The acft…