NTSB investigations: Cessna 182E
5 cases on aircraft the registry lists as Cessna 182E, 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 | 1 |
|---|---|
| 1995 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 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 ('2072712')
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 ('2072712')
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 LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.NTSB IAD97FA117Accident · 5 fatalField investigationFinal reportCessna 182E · Smithfield, RIA loss of engine power for undetermined reason, and the pilot's failure to maintain control of the airplane.NTSB FTW96LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Erie, COinadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…NTSB MIA87LA037Accident · No injuriesLimited investigationFinal reportCessna 182E · Chiefland, FLThe plt stated that he was on final apch & attempted to go around due to gusting winds. He applied power, the eng quit & he collided with the trees at the end of the rwy. No determination could be made as to the malfunction of the eng as described by the plt.