NTSB investigations: Cessna 182K
6 cases on aircraft the registry lists as Cessna 182K, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1988 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2000 | 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 ('2072724')
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\" = 351))
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 ('2072724')
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" = 351))
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 LAX00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Mayer, AZthe total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.NTSB CHI96LA051Accident · No injuriesLimited investigationFinal reportCessna 182 · Tamms, ILfuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.NTSB LAX92LA203Accident · No injuriesLimited investigationFinal reportCessna 182K · Carefree, AZInadequate aircraft maintenance and the failure of the pilot to ensure that adequate engine oil was on board prior to departure.NTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.NTSB NYC90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Limington, MEFuel starvation, due to carburetor contamination, which resulted in a forced landing in unsuitable terrain.NTSB CHI88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Detroit Lakes, MNDuring the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine…